Psychostats 3 in-game stats (threaded SQLx)
 

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
Usage
Only /rank and /top15 commands are implemented.

If you use STATSX plugin you must comment out these lines in statsx.sma:
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.

Re: Psychostats 3 in-game stats (threaded SQLx)
 

You should perhaps inform users that if they place this plugin above statsx.amxx in plugins.ini, they won't have to edit any existing plugins. This approach prevents the user from having to alter stock plugins after one or more updates.

Re: Psychostats 3 in-game stats (threaded SQLx)
 

it would be cool to have some sort of /search or /topclan functions like in the other plug in....except using the mysql db not the inet+motd

Re: Psychostats 3 in-game stats (threaded SQLx)
 

Any screenshots?

That would be cool.
I'm currently using this plugin
http://forums.alliedmods.net/showthread.php?t=51156

But if this plugin is what I think it is, showing print messages instead of freaking MOTD HTML then it so should be approved because that reminds me of PyschoViewer for Source.

EDIT

That what it is exactly! Very good job man. I'm sure if you could work in a search feature and other things listed in the plugin I posted but this for now is exactly what is needed!

Re: Psychostats 3 in-game stats (threaded SQLx)
 

I've tried to make the plugin mostly identical to statsx behavior.
So then player "say /rank", the game show chat message to others and then client_print his rank to the player.
If statsx plugin is enabled too, the player will get two different rank messages (from psychostats & from csstats). If "say /rank" command was disabled in your statsx plugin, the player will get rank message from PS and "Server has disabled that option" message from statsx.
I see the only proper way to do this without recompiling statsx. Command functions must except But then "say /rank" will not appear as a chat message visible for other players. If there is the way to make "say" message visible...

I'll try to implement that and may be some other commands too in time.

Re: Psychostats 3 in-game stats (threaded SQLx)
 

this needs to be unapproved cause it doesn't work anymore: http://forums.alliedmods.net/showthread.php?t=24012

this need to be unapproved cause it lags too much because every time you use it, it needs to connect to the inet and show the stats through the browser: http://forums.alliedmods.net/showthread.php?t=51156

the one thing that i don't like about this plug in is that it spams the server logs with this crap:

Re: Psychostats 3 in-game stats (threaded SQLx)
 

Im sure he could add a cvar to have it log optionally. That would problaby get a good idea, as the logs do offer good troubleshooting information.

as for the second plugin you said should be unapproved. I dont think so, as it still works, may be a little laggy but it all depends on clients computer then, cause I load fairly quickly.

Re: Psychostats 3 in-game stats (threaded SQLx)
 

You could send the SayText message yourself and then return PLUGIN_HANDLED. You can look at AdminListen if you need an example of how to do this.

Re: Psychostats 3 in-game stats (threaded SQLx)
 

I have not tested this yet, but seriously I was getting pissed that those other ones did not work for crap. Some barely worked, some did not at all. Although the lagg issue, that sux. If you want to add a cvar to the logs, would that not be a whole lot of cvar checking and possibly slow things down even more? Im going to test it tho, I just hope it doesnt lagg incredibly since one of our servers is not hosted, but a home pc lol :D

It would also be nice to implement csstats with psychostats, well be separate and use diff commands? like /psrank. Because some people just came on and it will take ages to get anywhere with psychostats on teh server, but with regular stats, they can accomplish something... I dunno

Re: Psychostats 3 in-game stats (threaded SQLx)
 

bmann

Your problaby right on adding another cvar, I noticed he does include a PSDEBUG define, with a few additions you can simply recompile the plugin with the if statements so they dont log anymore :)