Player Status in DB
Posted: Mon Nov 22, 2021 1:28 pm
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
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.
Source Code: https://github.com/AoiKagase/Amxx-PSD
PHP https://github.com/AoiKagase/Amxx-PSD-Frontend
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
Install this plugin.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.)
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.
v1.0 over Development on GitHub2021.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.
Source Code: https://github.com/AoiKagase/Amxx-PSD
PHP https://github.com/AoiKagase/Amxx-PSD-Frontend