Ghost PVP Ladder GM Reset.

[Unholy Touch]

Hi guys can you help me make a GM Reset menu of this ladder? I want a gm level 99 can globally reset all the records. i try it using the sql query, deleting all the fields in the table but the problem is when the players kills again, it continues the last records he got. i also tried deleting the fields and restart the server, but still the same. Thank you in advance.

[diamondhole]

On 2/16/2013 at 6:48 PM, Unholy Touch said:

Actually Empty the pvp_rank table wont solve the issue, because Ghost uses a variable global variable, which can be reset by assigning another value which in my case set it to 0. I just made a script in which when the player login his/her statistics in ladder will be reset to 0.

 

-    script    Playerresetladder_Login    -1,{
OnPCLoginEvent:
if(chkifresetladder >= 1) goto chk_kungtaposna;
query_sql "DELETE FROM `pvp_rank` WHERE `pvp_rank`.`char_id` = "+getcharid(0)+"";
callsub OnPvPReset;
set chkifresetladder,1;
end;
OnPvPReset:
set Kill, 0;
set Death, 0;
set KillingStreak, 0; 
set MultiKill, 0;
set KillingSpree, 0;
set Dominating, 0;
set MegaKill, 0;
set Unstoppable, 0;
set WickedSick, 0;
set MonsterKill, 0;
set Godlike, 0;
set BeyondGodlike, 0;
set DoubleKill, 0;
set TripleKill, 0;
set UltraKill, 0;
set Rampage, 0;
set Ownage, 0;
set NemesisKill, 0;
set FeedCount, 0;
return;
chk_kungtaposna:
end;
}

 

im not really good at scripting so in my case i need to use another variable for "chkifresetladder" every month. thank you.

is it possible to make a npc where gm can click and it reset this table, i try manually but this sql require char id i want reset for all, plus i have use for first time. So it wont reset again for the 2nd time

[Emistry]

you are asking others to create a new ladder script for you ? or modify your current ladder script ?

if you are requesting a new ladder...then make it in details..

else...show your scripts...

[icabit]

create a gm menu

create an option for you to reset the ladder

TRUNCATE TABLE `pvp_rank`

since ghost's pvp system uses `pvp_rank` table in your database you just only need to empty the table

Edited January 15, 2013 by icabit

[Unholy Touch]

Actually Empty the pvp_rank table wont solve the issue, because Ghost uses a variable global variable, which can be reset by assigning another value which in my case set it to 0. I just made a script in which when the player login his/her statistics in ladder will be reset to 0.

 

-    script    Playerresetladder_Login    -1,{
OnPCLoginEvent:
if(chkifresetladder >= 1) goto chk_kungtaposna;
query_sql "DELETE FROM `pvp_rank` WHERE `pvp_rank`.`char_id` = "+getcharid(0)+"";
callsub OnPvPReset;
set chkifresetladder,1;
end;
OnPvPReset:
set Kill, 0;
set Death, 0;
set KillingStreak, 0; 
set MultiKill, 0;
set KillingSpree, 0;
set Dominating, 0;
set MegaKill, 0;
set Unstoppable, 0;
set WickedSick, 0;
set MonsterKill, 0;
set Godlike, 0;
set BeyondGodlike, 0;
set DoubleKill, 0;
set TripleKill, 0;
set UltraKill, 0;
set Rampage, 0;
set Ownage, 0;
set NemesisKill, 0;
set FeedCount, 0;
return;
chk_kungtaposna:
end;
}

 

im not really good at scripting so in my case i need to use another variable for "chkifresetladder" every month. thank you.

Edited October 24, 2013 by Capuche
Insert the script in Code

[Akbare]

use icabit modification 

Edited October 24, 2013 by Akbare