For anyone who in the future has the same table creation problem. I modified the create player tables query to
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;
Works Correctly now, probrably a slightly different syntax to the localsql, at least the version on mysql i am using (4.1.22-standard)
Thanks again Frostbyte for the great pluggin!
Also. Would having these queries fire off on every single gun shot be a heavy load for the server?
Im tempted to disable the onfire/onhurt events