[Jezternz]

Completly rewriting this post .
First things first. Can I use this mod with estools also installed (ie for gungame, cause when I have them both running it seems to crash the server (see previos post for details). I have noticed It runs fine if I run Es tools in safemode, however I would rather run it in standard mode if possible.

Secondly (and more importantly). Does this mod support mysql? or only the local-sql db. if it does support mysql, please help me to get this working, if not would it be easy enough to rewrite it so you coul connect to an external mysqldb. If not would the developer consider makng this an optional parameter (defaulting to local-sql)?

Thanks, Josh

[ottobohn]

Any fix for it to work on DM servers? I get nothing on ours and it's sourcemod 1.x with the newest DM.

Otto

[FrostbyteX]

The question about your server crashing when used with estools is too time-involved for me to look into at the moment. But you can use this plugin with mysql. Just open your storage-local database config file and change "SQLite" to "mysql" and then set your server IP and port below it.

As far as this plugin not working with deathmatch, which deathmatch mod are you running? Are you running the deathmatch sourcemod plugin or a separate assembly? Try executing "sm_stats_enabled 1" on the server.

Do you get any warnings or errors?

Steve

[Jezternz]

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

"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:

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

[Box Cutter]

Frostbyte, a few posts earlier you mentioned some new features you will be adding in the next release. Do you know when you will have the next release out? I only ask because I'm going to install this plugin on my server here soon and if a update is about to come out I might save myself the trouble of upgrading and just install the new version. Thanks!

-BC

[Jezternz]

For anyone who in the future has the same table creation problem. I modified the create player tables query to

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

[Box Cutter]

So I went ahead and installed the plugin on my CS:SDM server and can happily report that everything seems to be functioning properly. The only thing that seems wierd is the starting off with 1000 points. I know you mentioned something to this effect on a previous post but is there anyways to start people off at 0 points? I figured I would ask before players start asking why this is so.

Thanks a bunch for a great plugin.

-BC

[FrostbyteX]

Okay, let's see if I can remember all of this...

I've already written and tested the above "new features," but I'm trying to figure out a way to automatically upgrade without having to delete player stats (that means version checking and database migration).

The sample config file you posted has the IP under "database." That's actually the name of the database in MySQL. Look at the above entry in the default config for a template to follow.

Also, updating stats every gunshot would probably lock up your server. That's a lot of queries. At the moment the plugin saves statistics per player every player death.

Did I get everything?

Steve

[Box Cutter]

Well I would not mind deleting stats since I just added the plugin. If you would like to release the new version I would be more than happy to run it and test it out. Oh and about the 1000 points. Can it be set to start at zero or maybe a lesser number. Thanks.

-BC

[FrostbyteX]

I'll add it as a cvar.

sm_stats_startingpoints <0-infinity>

Though your players might not be too happy to see themselves with a negative score ;).