Raised This Month: $165 Target: $400
 41% 

Player Status in DB


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   Counter-Strike        Category:   Statistical        Approver:   Orangutanz (13)
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 00:13   Player Status in DB
Reply With Quote #1

Player Status in DB v1.07

DESCRIPTION
  • This adds up the status of the player and writes in it at a database.
  • Update DB in RoundEnd, Mapchange, Client Connected/Disconnected.
  • On your homepage, please use ranking to displaying it.

INSTALL an USING
  • Require module MySQL,CSTRIKE,CSX.
  • Setup MySQL Server. (I will not explain here)
  • Install and Setting any servers (Web+PHP)
  • Check, addons/amxmodx/configs/sql.cfg
    Code:
    • amx_sql_host "127.0.0.1" // MySQL server address.
    • amx_sql_user "root" // MySQL login user.
    • amx_sql_pass "*****" // MySQL login password.
    • amx_sql_db "amx" // database name. (Please make it in advance.)
  • Install this plugin.
  • ex. rankpage upload on your homepage(need PHP).

CREDIT
  • ripcurl2 : sqlstats
  • AmxxDevTeam: StatsX

ATTENTION
  • Supported AMXMODX 1.90 in CS1.6
  • I tested linux server on CS1.6+MySQL
  • "[PSD] Error: Can`t connect: 'Access denied for user '[email protected]'localhost' (using password: NO)'"
    You don't make a database for a MySQL server. Or you don't set a password.
    Or an IP address or user name is wrong.


UPDATED
Code:
  • 10.12.2020 v1.07 Fixed: reset command not working. Fixed: ERROR: client_putinserver. Fixed: amx_psd_reset/amx_psd_update: not updating user table. (user name) Fixed: ERROR: for sql_mode=only_full_group_by.
  • 18.04.2020 v1.04 Fixed: Can't CTs Win Count for Time up.
  • 17.04.2020 v1.03 Fixed: Create Table SQL.
  • 11.04.2020 v1.02 Fixed: online time bug.
  • 06.04.2020 v1.00 Big UPDATE. Added Tables.
    • server_map
    • server_round
    • total_stats
    • user_info
    • user_objective
    • user_rstats
    • user_stats
    • user_wrstats
    • user_wstats
  • 10.06.2008 v0.73 add "amx_psd_initialize","amx_psd_reset" fix VALVE_ID_PENDING,STEAM_ID_LAN don't recording. fix can't update bug. known bug: initialize cmd is wrong..
  • 29.05.2008 v0.7 add command "amx_psd_update" synchronize csstats.dat and database.
  • 28.05.2008 v0.6 I unify Windows version and Linux versions. Speedup of the access to the database. add a K/D rate field to a database table.
  • 25.04.2008 v0.5 fix connecting bug for windows.
  • 22.04.2008 v0.3 cut some "public"
  • 20.04.2008 v0.2 single quotation in name no write bug fix.
  • 19.04.2008 v0.1 first release.
v1.0 over Development on GitHub
Attached Files
File Type: zip psd_107.zip (7.7 KB, 28 views)
__________________

Last edited by +ARUKARI-; 12-10-2020 at 03:43. Reason: update 1.07
+ARUKARI- is online now
Alka
AMX Mod X Plugin Approver
Join Date: Dec 2006
Location: malloc(null)
Old 04-19-2008 , 03:33   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #2

Nice...gj
__________________
Still...lovin' . Connor noob! Hello
Alka is offline
NelegalJke
Member
Join Date: Mar 2008
Location: Ukraine
Old 04-19-2008 , 05:22   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #3

no bugs?
__________________
NelegalJke is offline
Send a message via ICQ to NelegalJke
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 07:41   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #4

Alka:
Thanks

NelegalJke:
It is the intention.
However, it is impossible to know all.

I will think that I add some functions in future.
__________________
+ARUKARI- is online now
`666
AlliedModders Donor
Join Date: Jan 2006
Location: UK
Old 04-19-2008 , 08:08   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #5

any one tested on cz?
`666 is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 08:15   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #6

Quote:
Originally Posted by `666 View Post
any one tested on cz?
I don't have CZ.. tested CS1.6 only.
__________________
+ARUKARI- is online now
`666
AlliedModders Donor
Join Date: Jan 2006
Location: UK
Old 04-19-2008 , 08:20   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #7

I guess ill be 1st
`666 is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 08:26   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #8

Quote:
Originally Posted by `666 View Post
I guess ill be 1st
oh thanks!
I wait for a good report.
__________________
+ARUKARI- is online now
DeuX
Member
Join Date: Apr 2008
Old 04-21-2008 , 05:22   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #9

I welcome!

Plugin good me liked, but for me problem!
Business in that as though correctly did everything, but for me does
not want will unite with the server of MySql!
What can a problem be in???

For me fashions AmxModX 1.80...

Tuning did everything, and writes me
"[PSD] Error: Can`t connect: 'Access denied for user '[email protected]'localhost' (using password: NO)'"

Did I adjust parameters in the file in cfg, in a script, and in what problem?
Help, because it is very desirable to put this plugin on the server!
DeuX is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-21-2008 , 06:56   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #10

DeuX:
did you create DB on mysql server?
and "localhost" doesn't work. try "127.0.0.1"

Code:
amx_sql_host "127.0.0.1" //NOT "localhost"!
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "dbname" //you create db on mysql server.
__________________
+ARUKARI- is online now
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 09:42.


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