[TiMbErLaNd]

I load everything point everything correctly.

When I type in /rank the server crashes instantly.

I have reviewed logs and am not recieving any errors.

Any help would be greatful.

[ZodiacMindwarp]

I am getting the same results. Do a "/rank" and server crashes instantly.

Amxmodx 1.75a
Linux NS 3.1.3
Metamod 1.19p28


*Note: has anyone retried it by restarting the server? I think this issue was similar to a rev in the past with the crashing server issue, and it worked when you restarted the gameserver console.

I would test but have a tonage of traffic right now. If nobody can verify I will test it later.

Z

[TiMbErLaNd]

That does not help the situation. I just tested that.

[Ner0]

Yupp,my server craches to when u type "/rank",since i've installed amxx 1.75,even though i sucessfulle compilled the sma

[TiMbErLaNd]

Can someone take this plugin over or something?

The maker hasent logged into the forums in over 2 months.

[vazze]

This plugin is a resource hog.

I Have following specs:

2 x Opteron 246
Tyan Thunder K8W Motherboard
8 x 512 Registered 400MHz memory running NUMA.

And a 100/100Mbit fiber, and when plugin runs (every 2-3 minutes) i get pingspikes on all people on the server, people that have 20 in ping gets 150-180 in ping and freezelags.
Myself that are on same "network" get about 100+ in ping, and i have 3-5 in ping before.

The CPU resource states that the plugin doesnt affect the CPU much, only a % or 2, not more..

Why is that?

[TiMbErLaNd]

I posted my lasst message on..
07-14-06 , 09:29 PM

Then he edited the original post on..
Last edited by Fyre : 07-17-06 at 10:49 AM .

In this he states this

Maybe I can also fix the lag with the new functions for querying the sql server, stay tuned.

I noticed the very high pings as well and stopped using the plugin after I changed my SQL version to an earlier version so that this plugin would work.

I hope that the new querying process with the newer SQL Module is up soon, I really would like this plugin up and running.

[Aslanbey]

Originally Posted by Fyre If you like both Stats like me and use both you might like to have your rank shown ingame. Simply type "/rank" into the chat and you get your rank shown from HL Stats and Psychostats. This is just a combination and can be set per CVAR HL Stats only, Psychostats only or to let them show you both of them at the same time. However you have to set up this plugin first because of 2 Databases that have to be queried with different acc|password|dbname. WORKAROUND 1.75 Use the mysql_amxx.dll/so from Zip file below (its an older version, does not support new SQLX Functions) Requirements AMX Mod X 1.70 (1.60 - compatibility mode) 1.75 NOT SUPPORTED YET --- GOT TO REWRITE THE QUERIES SQL Module Setup Put these cvars in your amxx.cfg This must be added to your sql.cfg in your configs directory New in 1.0f Linux case-sensitive in HLStats tables Report bugs please. Usage If you use statsx plugin then use the patched statsx.sma (recompile) in the attachements Since AMXX 1.70 you can use the default statsx plugin (both /rank calls will be shown), if you dislike that use the provided patched statsx plugin Version History Line 26 Code: // REMOVE "//" for AMXX 1.60 Support</p><p>//#define SUPPORT_1_60 Todo: Requested 1.60 backwards compatibility --- DONE. 04/28/06 Add Kills/Deaths and Ratio on HLStats say announce [Requested] 1.75 compatibility [Crashes on /rank] --- sry guys I have not much time Maybe I can also fix the lag with the new functions for querying the sql server, stay tuned. PICS

[Liquidz]

so this does work for 1.70? how? im lost

[poisoned]

Hi there,
I have the problem, that the queries don't work.
I installed the plugin and it works, but what about the sql-tables etc.?
They are not being created automatically..so how must i name the table and the fields?

This is the log-message:

L 08/09/2006 - 06:270: [psychohlstatsrank.amxx] SELECT query error regarding table "pstats_plr" and table "pstats_plrdata" check your "amx_sql_psprefix" settings
L 08/09/2006 - 06:270: [psychohlstatsrank.amxx] Table 'psystats.pstats_plr' doesn't exist
L 08/09/2006 - 06:270: [MYSQL] Invalid result handle -1
L 08/09/2006 - 06:270: [AMXX] Displaying debug trace (plugin "psychohlstatsrank.amxx")
L 08/09/2006 - 06:270: [AMXX] Run time error 10: native error (native "dbi_free_result")
L 08/09/2006 - 06:270: [AMXX] [0] 5429.attach::surroundingPlayersps (line 532)
L 08/09/2006 - 06:277: [psychohlstatsrank.amxx] SELECT query error regarding table "hlstats_Players" and table "hlstats_PlayerUniqueIds" check your "amx_sql_hlprefix" settings
L 08/09/2006 - 06:277: [psychohlstatsrank.amxx] Table 'psystats.hlstats_Players' doesn't exist
L 08/09/2006 - 06:277: [MYSQL] Invalid result handle -1
L 08/09/2006 - 06:277: [AMXX] Displaying debug trace (plugin "psychohlstatsrank.amxx")
L 08/09/2006 - 06:277: [AMXX] Run time error 10: native error (native "dbi_free_result")
L 08/09/2006 - 06:277: [AMXX] [0] 5429.attach::surroundingPlayershl (line 383)
L 08/09/2006 - 06:27:47: [psychohlstatsrank.amxx] SELECT query error regarding table "pstats_plr" and table "pstats_plrdata" check your "amx_sql_psprefix" settings
L 08/09/2006 - 06:27:47: [psychohlstatsrank.amxx] Table 'psystats.pstats_plr' doesn't exist
L 08/09/2006 - 06:27:47: [MYSQL] Invalid result handle -1