Okay!
For reference, if you want the exact mysql query here it is:
Code:
CREATE TABLE IF NOT EXISTS players(`rank` INTEGER NOT NULL AUTO_INCREMENT, `score` int(12) NOT NULL default 0 , `steamid` varchar(255) NOT NULL , `kills` int(12) NOT NULL default 0, `deaths` int(12) NOT NULL default 0, `shots` int(12) NOT NULL default 0, `hits` int(12) NOT NULL default 0, `name` varchar(255) NOT NULL , `active_badge` varchar(255) NOT NULL default 0, `time_played` int(11) NOT NULL default 0, PRIMARY KEY ( `rank` )) ENGINE = MYISAM;
However I would use the attached .smx pluggin. The exact modifications are as follows:
1. Changed the create tables code
2. Added SOD Stats messages, for when it connects successfully (not just for on fail)
3. Removed onshoot events (this would put far to much pressure on server)
so put the new sodstats.smx in the normal pluggins folder. (modname\addons\sourcemod\plugins)
And you will need to modify your databases.cfg (located in modname\addons\sourcemod\configs\databases.cf g)
To the following (example):
Code:
"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"host" "XX.XX.XX.XXX"
"database" "database_name"
"user" "mysql_username"
"pass" "mysql_password"
//"timeout" "0"
//"port" "0"
}
"storage-local"
{
"driver" "mysql"
"host" "XX.XX.XX.XXX"
"database" "database_name"
"user" "mysql_username"
"pass" "mysql_password"
}
}
Note for those using an external server (not localhost), you must add the game server's IP address to the mysql servers whitelist.
As for the web interface, the one on my site, is kind of custom built for my site. I am happy to share it, just it uses some of my own custom running functions. However I would be most happy to build a standalone one (that can be easily modified visually) if there is enough interest, Or you could just add me on msn/steam and we can see what we can cook up.
Cheers, Josh
, thanks heaps for the pluggin. If you need any help with the SQL (which you seem to have sorted) or the web interface, I would love to help 
Linear Mode
