[DoPe^]

Heya! i'm working on a Hlstatsx Reset Rank plugin at the moment.

I can get it to reset the rank, but it's like some playerstats are still saved, so it just brings back the stats again :S really weird.

These are some of the queries I have tried to run


This one resets the rank, and it works, but it's like the session is still saved, so the stuff it resets here gets restored.

PHP Code:

FormatEx(Query, sizeof(Query), "UPDATE hlstats_players SET kills ='0', deaths ='0', suicides ='0', skill ='%d', headshots ='0', last_skill_change ='0', kill_streak ='0', death_streak ='0' WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",cfg_s_Points,authid,game,game); 


I then also ran this one to see if that would fix it, but no luck.

PHP Code:

FormatEx(Query, sizeof(Query), "UPDATE hlstats_players_history SET connection_time ='0', kills ='0', deaths ='0', suicides ='0', skill ='%d', headshots ='0', kill_streak ='0', death_streak='0', skill_change ='0' WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",cfg_s_Points,authid,game,game); 


I then found livestats, which I think is the one making the issue, the info in this table is the stuff that is getting restored again I believe.
But running this Query dosnt help at all.

PHP Code:

FormatEx(Query, sizeof(Query), "UPDATE hlstats_livestats SET kills ='0', deaths ='0', suicides ='0', headshots ='0', connected ='0', skill_change ='0', skill ='%d' WHERE player_id = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' )",cfg_s_Points,authid,game); 


Am I missing something?
Any help would be really appreciated

[Rytis]

The first one should work, because that's the same query that hlstats uses to change playerdetails.

[DoPe^]

Originally Posted by Rytis The first one should work, because that's the same query that hlstats uses to change playerdetails.

Yeah exactly, it does also work.
But the issue is that somehow some of the stats get restored, and i think it's either the session stats or the livestats that does it.

I Can post a screenshot later, so you can see what I mean.

[Root_]

FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_players WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);  

FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_players_history WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);  

FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_livestats WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);

[DoPe^]

Originally Posted by Root_ FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_players WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);  FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_players_history WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);  FormatEx(Query, sizeof(Query), "DELETE FROM hlstats_livestats WHERE playerid = ( SELECT playerid FROM hlstats_playeruniqueids WHERE uniqueid = '%s' AND game = '%s' ) AND game = '%s'",authid,game,game);

I think I tried that.
The player will have to rejoin the server for the stats to count again.
If I remember correctly.

[Killer0561]

This code works?
I wanted to compile and install this plugin on my server.

[DoPe^]

Originally Posted by Killer0561 This code works? I wanted to compile and install this plugin on my server.

Nope, and it's not even the full code.
I did get it to reset the rank, but after a few seconds, the player would have his rank back again somehow.

[micazoid]

That is a very cool Idea Dope^

We also reset our stats once a month, so this would be very handy =)

Good Luck in tracking this Bug!

[DezzY]

i think you have to stop hlstatsx by putty, then execute the plugin (comand) and then start again the hlstatsx

Thats how i change the point in my hlstatsx

[Mavrick4283]

Originally Posted by DoPe^ Nope, and it's not even the full code. I did get it to reset the rank, but after a few seconds, the player would have his rank back again somehow.

That is because the Daemon stores some of the data in memory (for performance reasons),

So this plugin is not as simple as you think, as you would also have to rewrite or bolt on to the daemon some code the would force the clearing of that score.