thanks heaps frostbyte, for this awesome pluggin, and it works fine in safemode, so im just gonna keep it in safemode. Will try the mysql later today
Hmmm well i presume you mean this file here: cstrike\addons\sourcemod\configs\databases.cf g
Code:
"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"host" "**.**.**.***"
"database" "*******"
"user" "*******"
"pass" "*******"
//"timeout" "0"
//"port" ""
}
"storage-local"
{
"driver" "mysql"
"database" "**.**.**.***"
"port" "3306"
}
}
I get the error:
sodstats.smx - Unable to connect to database -[2003] Cant connect to mysql server on 'localhost' (10061)
Anyways, all the details are correct im sure.
So I tried copying all of the stuff from "default" and pasted into "storage-local". After I did that I got the error "table could not be made".. does this mean it connected to the database that time?
I thought that it did mean this so I tried making the table manually with:
Code:
CREATE TABLE `gamecent_gcnz`.`players` (
`rank` INT 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` VARCHAR( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `rank` )
)
So it created the table, but I still got the same error? (could not create table)
The mysql user does have the correct permissions btw.
Thanks in advance, Josh