Reset Forger/Brewer and Taekwon rank

[Alexandria 53]

Hello you guys, 

 

is there a way to automatically wipe Forger/Brewer/Taekwon rankings every 3 months and this, without having to reboot the server ?

 

I have made this script but my server has to reboot to show the ranks empty.

 

http://pastebin.com/J87N6pxZ

 

Thanks.

[AnnieRuru 956]

I don't think its possible

by reading the source, the source also actually built the list upon sql_handle

https://github.com/HerculesWS/Hercules/blob/master/src/char/char.c#L2724

then compare the list each with the player's char id

https://github.com/HerculesWS/Hercules/blob/master/src/map/pc.c#L355

 

problem of resetting the value while server is online is the sd->status.fame require players to online

its not like the list is actually built internally with a sorting algorithm or ladder algorithm

it actually do a constant listing with sql_handle

 

so the only way to correctly reset the variables is do it when the server shut down

update `char` set fame = 0;
update char_reg_num_db set value = 0 where `key` = 'TK_MISSION_ID' or `key` = 'TK_MISSION_COUNT';

Edited March 12, 2014 by AnnieRuru

[Alexandria 53]

Ohh I see, thanks Annie!