Raised This Month: $ Target: $400
 0% 

[MySQL] A way to save pug stats correctly


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 01-22-2014 , 15:38   [MySQL] A way to save pug stats correctly
Reply With Quote #1

Hi all, i tried to save stats of attached plugin, but i not have sucess, the server crash on every map end or Player disconnect (without log files)

My output commands are:

Meta List:
PHP Code:
Currently loaded plugins:
      
description      stat pend  file              vers      src   load  unlod
 
1AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.8.3-d  ini   Start ANY  
 
2FakeMeta         RUN   -    fakemeta_amxx_i3  v1.8.3-d  pl1   ANY   ANY  
 
3CStrike          RUN   -    cstrike_amxx_i38  v1.8.3-d  pl1   ANY   ANY  
 
4CSX              RUN   -    csx_amxx_i386.so  v1.8.3-d  pl1   ANY   ANY  
 
5Ham Sandwich     RUN   -    hamsandwich_amxx  v1.8.3-d  pl1   ANY   ANY  
 
6MySQL            RUN   -    mysql_amxx_i386.  v1.8.3-d  pl1   ANY   ANY  
6 plugins
6 running 
version
PHP Code:

rcon version
Protocol version 48
Exe version 1.1.2.7
/Stdio (cstrike)
Exe build10:03:21 Aug  8 2013 (6132
Plugins (Yes, i not using other amxmodX Plugins, so dont care about Non-Steam etc)
PHP Code:
Currently loaded plugins:
       
name                    version     author            file             status   
 
[  1] [PUGAnti Flood        1.8.3       SmileY            Flood.amxx       running  
 
[  2SQL Bans (AMX)          1.8.3       SmileY            bans.amxx        running  
 
[  3Easy Anti Cheat Plugin  1.8.3       SmileY            eac.amxx         running  
 
[  4Imessage (Chat Color)   1.8.3       SmileY            imessage.amxx    running  
 
[  5] [PUGVote Kick         1.8.3       SmileY            VoteKick.amxx    running  
 
[  6Pug Mod (XT)            1.8.3       SmileY            CsPug.amxx       running  
6 plugins
6 running 
Someone can post some method to store player stats correctly?

Ps. It is 2 plugins, the bugged plugin and the plugin without the MySQL part (Only counting the stats)

Thanks 4 u help..
Attached Files
File Type: sma Get Plugin or Get Source (stats_bug.sma - 637 views - 12.6 KB)
File Type: inc stats.inc (2.2 KB, 141 views)
File Type: txt stats_sql.txt (3.3 KB, 158 views)
File Type: sma Get Plugin or Get Source (stats_no_sql.sma - 588 views - 6.0 KB)
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 

Last edited by ^SmileY; 01-22-2014 at 15:41.
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
 



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 10:10.


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