View Single Post
Jezternz
Junior Member
Join Date: May 2008
Location: New Zealand - Auckland
Old 05-12-2008 , 18:21   Re: SoD Player Stats
Reply With Quote #114

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

Last edited by Jezternz; 05-12-2008 at 19:33.
Jezternz is offline
Send a message via MSN to Jezternz Send a message via Skype™ to Jezternz