Jerson A Tadios's post in Card Trader was marked as the answer
it really works again I owe you much now last sir if you remember you also help me about my mvp ladder last thing about that can you put a reset option "for GM USE ONLY" thank you..
HERE'S the code thank you
/* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ *
* ~~~~~~~~ Euphy's MVP Ladder v1.3 ~~~~~~~~ *
* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */
prontera,148,170,6 script MVP Ladder 891,{
mes "[Rank MVP]";
mes "Hello.";
mes "What are you doing here";
next;
switch(select("Check Ranking.:My points.:Nothing...")) {
case 1:
mes "[Rank MVP]";
query_sql("SELECT char_id, CAST(`value` AS SIGNED) FROM `char_reg_num` WHERE `key` = 'MVP_Rank' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 20",.@cid,.@value);
for(set .@i,0; .@i<getarraysize(.@cid); set .@i,.@i+1) {
query_sql("SELECT `name` FROM `char` WHERE char_id = "+.@cid[.@i]+";",.@j$);
set .@name$[.@i], .@j$;
}
if (!getarraysize(.@cid))
mes "The rankings are empty.";
else for(set .@i,0; .@i<getarraysize(.@cid); set .@i,.@i+1)
mes "["+(.@i+1)+"] "+.@name$[.@i]+" ~ "+.@value[.@i]+" kills";
close;
case 2:
mes "[Rank MVP]";
mes "You killed "+((MVP_Rank)?"^0055FF"+MVP_Rank:"no")+"^000000 MVP"+((MVP_Rank == 1)?".":"s.");
close;
case 3:
close;
}
OnNPCKillEvent:
if (getmonsterinfo(killedrid,22)) {
set MVP_Rank, MVP_Rank+1;
if (MVP_Rank == 1)
query_sql("INSERT INTO `char_reg_num` (`char_id`,`key`,`index`,`value`) VALUES ("+getcharid(0)+",'MVP_Rank','0',1)");
else
query_sql("UPDATE `char_reg_num` SET `value` = '"+MVP_Rank+"' WHERE char_id = "+getcharid(0)+" AND `key` ='MVP_Rank'");
dispbottom "~ You killed "+MVP_Rank+" MVP"+((MVP_Rank == 1)?"":"s")+". ~";
dispbottom " ~ Reward: Cash + 1 ~ ";
set #CASHPOINTS, #CASHPOINTS + 1;
specialeffect2 313;
}
end;
}