[+ARUKARI-]

Player Status in DB v1.10

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,GEOIP.
• Setup MySQL Server. (I will not explain here)
• Install and Setting any servers (Web+PHP)
• Check, addons/amxmodx/configs/sql.cfg
  

  amx_psd_sql_host	"127.0.0.1"	// MySQL server address.
  amx_psd_sql_user	"root"		// MySQL login user.
  amx_psd_sql_pass	"*****"		// MySQL login password.
  amx_psd_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 'root@'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

2021.02.01. v1.10
Added: amx_psd_serverid
Added: database cvars (amx_psd_sql_host/user/pass/db)
Modify: Insert Query has Threaded.
Fixed: player name escape.
2020.12.10. 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.
2020.04.18. v1.04
Fixed: Can't CTs Win Count for Time up.
17.04.2020 v1.03
Fixed: Create Table SQL.
2020.04.11. v1.02
Fixed: online time bug.
2020.04.06. v1.00
Big UPDATE.
Added Tables.
server_map
server_round
total_stats
user_info
user_objective
user_rstats
user_stats
user_wrstats
user_wstats

2008.06.10. 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..
2008.05.29. v0.7 add command "amx_psd_update"
synchronize csstats.dat and database.
2008.05.28. 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.
2008.04.25. v0.5 fix connecting bug for windows.
2008.04.22. v0.3 cut some "public"
2008.04.20. v0.2 single quotation in name no write bug fix.
2008.04.19. v0.1 first release.

v1.0 over Development on GitHub

• Source Code: https://github.com/AoiKagase/Amxx-PSD
• PHP https://github.com/AoiKagase/Amxx-PSD-Frontend
• DEMO