R> Mvp Ladder

[charon]

Can Any One Help Me With The Script Of Top 10 Mvp Ladder

Thank You

[Sharpienero]

I can't find this resource, but it seems like a good one to have. I'll bump this because I want the script as well.

[charon]

Yea Same Here

[deathscythe13]

didn't test it yet but that should work

prontera,156,180,4 script MVP LADDER 100,{
set .@query, query_sql ("SELECT char_id,value FROM  `global_reg_value` WHERE  `str` LIKE  'mvpladder' ORDER BY  `str` DESC LIMIT 0,10",.@char_id,.@value);  // Query Limit to 10
for(set .@i,0; .@i<.@query; set .@i,.@i+1) {
attachrid(.@char_id[.@i]);
mes .@i+" "+strcharinfo(0)+" kills: "+.@value[.@i];
}
close;
OnNPCKillEvent:
if (getmonsterinfo(killedrid,MOB_MVPEXP)) //Every Kill MVP +1
 set mvpladder,mvpladder+1;
end;
}

Edited June 30, 2012 by deathscythe13

[iraciz]

is not working, sorry! I cant even see the npc

Edited October 5, 2012 by iraciz

[Emistry]

you can try this...but it's SQL Version.

http://pastebin.com/raw.php?i=KQFjt7ia

make sure you load this Table in your SQL before use the NPC Scripts.

CREATE TABLE IF NOT EXISTS `E-MVPRank` (
`char_id` int(11) unsigned NOT NULL default '0',
`name` varchar(30) NOT NULL DEFAULT '',
`Count` int(11) unsigned NOT NULL default '0',
PRIMARY KEY  (`char_id`)
) ENGINE=MyISAM;