sqlstats

ripcurl2 · **Plugin Info:**

sqlstats, the name says it all: stats dumped in a sql database.
the plugin parses csstats values to a database whenever a player disconnects or a mapswitch is done. It's up to the server manager to get the stats into a website (via php).

20-09-2005
released a new version (0.1.8 ) , please give feedback as it is untested.

24-01-2005
added history tables to the plugin, haven't really tested it fully, but i'm sure i will get bugreports from you guys

. anyways you probably want sql_bannedIDs.sma too i'll post it too (separate plugin)
with sql_bannedIDs your stats will be purged from cheaters' stats.
This plugin resets the stats every day, and stores them into the database tables. You should add to your website stuff like "day top15" , "month top15" , "week top15" , "year top15" , "live dayly stats", "live monthly stats" etc...

18-12-2004
Found some time to work on the plugin. I reworked and traced a lot of problems, it should now work on LAN servers too.
The performance is waaayy better, it takes 1 db connection to update all players. During gameplay all is stored in memory to minimize CPU cost. I am busy testing it. It wil come online asap.

it still has some quirks:
25-11-2004 got a mail from russia: on lan servers the steam_id is a non-unique string, while db steam_ids must be unique.
This results in a few db entries. a fix is in the works (hopefully i can fix this

)

kingpin · 10-23-2004 , 08:08

nice work, this can help out all the people where they want the php stuff integerated into their site completely and can do this by themselves.

ripcurl2 · 10-23-2004 , 08:20

note on 0.1.1: there is a bug with the rank value that is put into the database. Since the ranks are saved per playerdisconnect/mapswitch, a new player ranked # will be written to a database where another (inactive) player is also ranked #.
In essence you can get mulitple number 1 ranks or number 2 ranks in the database. Still figuring out a simple fix to this though. I think it's best to get the ranknumbers figured out in the PHP/website part.

oh a pretty important note:
create a new cvar "amx_sqlstats_table" in the amxmodx/configs/sql.cfg file

ripcurl2 · 10-23-2004 , 09:52

okay i found it is still not working correctly, currently working on a fix. Have patience

[edit] 0.1.2 is working version. [/edit]

ripcurl2 · 10-23-2004 , 17:51

knubbe · 10-23-2004 , 18:07

really nice

RujinXERO · 10-23-2004 , 18:32

this doesnt compile for .16 is there anyway you can make this work for .16 please?

ripcurl2 · 10-23-2004 , 18:53

i'll take a look at it tomorrow

ripcurl2 · 10-24-2004 , 08:57

I made a version for 0.16 however I can't test it since I don't have a server running on amxmodx 0.16. I just unpacked the 0.16 tarball and started debugging from there there are still 4 warnings

sqlstats-0.16.sma(83 -- 89) : warning 213: tag mismatch
sqlstats-0.16.sma(89) : warning 213: tag mismatch
sqlstats-0.16.sma(142) : warning 213: tag mismatch
sqlstats-0.16.sma(143) : warning 213: tag mismatch

and they all have to do with mysql functions, so give me feedback if it works or not.

Keep in mind that this version is NOT for amxmodx 0.20

RujinXERO · 10-24-2004 , 19:10

well it seems the only Cvar registered is amx_sqlstats_table.. so if im not mistaken shouldnt there be a cvar for the host,username,pass and all that? if not.. i have no clue where to set that stuff.. but other than that.. it compiled and loaded fine..