[+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

[Alka]

Nice...gj

[NelegalJke]

no bugs?

[+ARUKARI-]

Alka:
Thanks

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

I will think that I add some functions in future.

[`666]

any one tested on cz?

[+ARUKARI-]

Originally Posted by `666 any one tested on cz?

I don't have CZ.. tested CS1.6 only.

[`666]

I guess ill be 1st

[+ARUKARI-]

Originally Posted by `666 I guess ill be 1st

oh thanks!
I wait for a good report.

[DeuX]

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 'root@'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!

[+ARUKARI-]

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

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.