[ash47]

@Daymon

I think you need to set the driver to mysql or something, i read it on some wiki

To my problem, the website works fine, I'm not sure what im doing wrong, but, the achievements ingame don't unlock! The !achievements usually works, it loads the players.php page, kinda laggy, but there are NO PLAYERS! I'd expect there to be atleast my name in there, but there wasn't, i tried searchign for my steam ID and such, nothing!

I've put the files in the correct folders, i tried the normal version, !achievements didn't even work, i tried compiling it myself, nothing. I tried Gachl's quick fix, the !achievements now works, but still no players on my achievements page, tried compiling it myself, same result...

in my server.cfg, i added the following:

sm_ca_url "http://myhost.com/players.php"
sm_ca_db "default"
sm_ca_prefix "ach"

except myhost was my real host

"default"
{
"driver" "mysql"
"host" "mymysqlhost"
"database" "mydatabasename"
"user" "myusername"
"pass" "mypassword"
//"timeout" "0"
//"port" "0"
}

I'm not sure what im doing wrong, i didn't include my actual details though...

What plugins do i need to have installed for the mysql databases to work? Is there any Cvars that need to be on, to make the mysql databases actually work?

I am using the ca_pack achievements, the 3 achievements do comeup on my website thingo!

I executed the SQL file provided with the pack, that worked fine, after it wasn't workin, i then executed the admin SQL and stuff on it, maybe that would fix it, it didn't

Nothing else i can think of, any ideas?!?

edit: It appears it can't connect to my MSQL host, any ideas why not?!?

[Sexual Harassment Panda]

Originally Posted by 3_stooges_geo will it be possible to make achievements for killing certain players?

Anything that is put into console can be made into an achievement. Jindo already made one for killing certain players if you clicked his link.

[ash47]

okay! I found my problem, my host didn't allow remote mysql connections So, i found a website that does: http://www.freemysql.net made a mysql database with them, and i connect to that now instead, seems to work fine Still testing though...

[Sexual Harassment Panda]

you can't just give them ips to allow in? that's unfortunate.

[ash47]

I know, it's stupid, I was using free hosting though, so what do u expect. After doing some testing, I've found that it still isn't working properly, I looked at http://labs.topaz-games.com/kj/achievements/players.php and on there, the names popup, on mine, the steam IDs pop up, and they link to ?u=ach_ which i know isn't correct, they are ment to ?u=steamid. I'll go through my table in a minute...

edit: ok, after some screwing around with settings, i got it to fully 100% work

To make things VERY clear:

I used Gachl's quick fix!

i used: sm_ca_prefix ""

My Mysql server DOES have remote mysql allowed!

I think that Daymon's error is because of this as well...

THX! All i need now are some achievements!

[Jindo]

Just letting you know that I've managed to get some kill-based achievements working and I'm going to get to work on a pack of those.

[ash47]

Just letting you know that I've managed to get some kill-based achievements working and I'm going to get to work on a pack of those.

Awesome! I'd like to see a nice big lengthy pack of achievements to install onto my server, but honestly, not too many stupid ones. I wouldn't mind a copy of the ones that are already on your server as well

I might make some of my own achievements as well, I guess making the actual icons will be the hard thing

[Gachl]

Hmm I love it when problems solves themselves

[Gachl]

New version up!

v0.3 2009/08/22
*	Fixed plugin loading problems

I failed so much

[Xsinthis]

Any guide or help on writing own achievements? I only have basic java knowledge, so i'm hoping this isn't too hard, cause this would be great!!!