Hello all+)
The main idea of this plugin is to display in-game statistical data from Psychostats ver.3 using SQLx (threaded).
There are at least four plugins at alliedmods which work with PS(1.x,2.x,3.x) in someway. None of them have worked for me as needed.
So.. here comes the new plugin...
Requirements
AMX Mod X 1.76d is highly recommended.
Psychostats v. 3.0.6b
Setup
Edit configuration and add this to your sql.cfg
Code:
amx_sql_pshost "127.0.0.1" // the sqldb ip
amx_sql_psuser "psychostats" // psycho sql user
amx_sql_pspass "hidden" // db password
amx_sql_psdb "ps3" // Psycho DB name
amx_sql_psprefix "ps_" // used tableprefix in psychostats db
Usage
Only
/rank and
/top15 commands are implemented.
If you use STATSX plugin you must comment out these lines in statsx.sma:
Code:
register_clcmd("say /rank", "cmdRank", 0, "- display your rank (chat)")
register_clcmd("say /top15", "cmdTop15", 0, "- display top 15 players (M
OTD)")
register_clcmd("say_team /rank", "cmdRank", 0, "- display your rank (cha
t)")
register_clcmd("say_team /top15", "cmdTop15", 0, "- display top 15 playe
rs (MOTD)")
Then recompile it.
I have no idea (help me?) of how to avoid this except changing commands to /psrank and /pstop15 or something else.
Plugin automatically detects Psychostats setting "uniqueid". i.e how your players are identified in the log files.
I've used some code and general ideas from these plugins:
Psychostats/HLStats Rank by Fyre
Psychostats Interface Plugin by Jason Morriss and JTP10181
SQLx Test Plugin by dvander
Thank you guys!
P.S This is my first AMXMODX plugin.