Raised This Month: $94 Target: $400
 23% 

sqlstats


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   Counter-Strike        Category:   Statistical        Approver:   twistedeuphoria (82)
ripcurl2
Member
Join Date: Oct 2004
Old 10-23-2004 , 08:15   sqlstats
Reply With Quote #1

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 )
Attached Files
File Type: sma Get Plugin or Get Source (sqlstats-0.16.sma - 6467 views - 5.5 KB)
File Type: sma Get Plugin or Get Source (sqlstats.sma - 7465 views - 22.3 KB)
File Type: sma Get Plugin or Get Source (sqlstats.sma - 6480 views - 22.5 KB)
ripcurl2 is offline
kingpin
Veteran Member
Join Date: Apr 2004
Location: kpsforum.com
Old 10-23-2004 , 09:08  
Reply With Quote #2

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.
__________________
kingpin is offline
Send a message via ICQ to kingpin Send a message via AIM to kingpin Send a message via MSN to kingpin Send a message via Yahoo to kingpin Send a message via Skype™ to kingpin
ripcurl2
Member
Join Date: Oct 2004
Old 10-23-2004 , 09:20  
Reply With Quote #3

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 is offline
ripcurl2
Member
Join Date: Oct 2004
Old 10-23-2004 , 10:52  
Reply With Quote #4

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 is offline
ripcurl2
Member
Join Date: Oct 2004
Old 10-23-2004 , 18:51  
Reply With Quote #5

ripcurl2 is offline
knubbe
Junior Member
Join Date: Aug 2004
Location: Sweden
Old 10-23-2004 , 19:07  
Reply With Quote #6

really nice
__________________
buhhu
knubbe is offline
Send a message via MSN to knubbe
RujinXERO
Junior Member
Join Date: Oct 2004
Old 10-23-2004 , 19:32  
Reply With Quote #7

this doesnt compile for .16 is there anyway you can make this work for .16 please?
RujinXERO is offline
ripcurl2
Member
Join Date: Oct 2004
Old 10-23-2004 , 19:53  
Reply With Quote #8

i'll take a look at it tomorrow
ripcurl2 is offline
ripcurl2
Member
Join Date: Oct 2004
Old 10-24-2004 , 09:57  
Reply With Quote #9

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
Attached Files
File Type: sma Get Plugin or Get Source (sqlstats-0.16.sma - 1993 views - 5.5 KB)
ripcurl2 is offline
RujinXERO
Junior Member
Join Date: Oct 2004
Old 10-24-2004 , 20:10  
Reply With Quote #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..
RujinXERO is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:08.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode