I think there is some bug upon this script, it shows the top players but the class is stuck at novice and won't be updated under the waitingroom. Hopefully any pro scripter can help to fix them out. Thanks much.
/*
CREATE TABLE IF NOT EXISTS `E-MVPRank` (
`char_id` int(11) unsigned NOT NULL default '0',
`name` varchar(30) NOT NULL DEFAULT '',
`Class` smallint(6) unsigned NOT NULL default '0',
`Count` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`)
) ENGINE=MyISAM;
*/
prontera,162,152,4 script MVP Ladder 619,{
query_sql( "SELECT `name`,`Count` FROM `E-MVPRank` ORDER BY `Count` DESC LIMIT 5",.@Name$,.@Count );
if( getarraysize( .@Name$ ) ){
for( set .@i,0; .@i < getarraysize( .@Name$ ); set .@i,.@i + 1 )
mes "[ "+( .@i + 1 )+". ] "+.@Name$[.@i]+" - "+.@Count[.@i]+" MvP killed";
}else{
mes "No Record Found.";
}
close;
OnNPCKillEvent:
if( getmonsterinfo( killedrid,MOB_MVPEXP ) )
query_sql( "INSERT INTO `E-MVPRank` SET `char_id`='"+getcharid(0)+"',`name`='"+strcharinfo(0)+"',`Count`='1' ON DUPLICATE KEY UPDATE `Count`=`Count`+1" );
OnMinute31:
query_sql( "SELECT `name`,`Class`,`Count` FROM `E-MVPRank` ORDER BY `Count` DESC LIMIT 1",.@Name$,.@Class,.@Count );
delwaitingroom;
waitingroom "TOP : "+.@Name$+" ("+jobname( .@Class )+") : "+.@Count+" Kill",0;
end;
}
Question
fallen0519
I think there is some bug upon this script, it shows the top players but the class is stuck at novice and won't be updated under the waitingroom. Hopefully any pro scripter can help to fix them out. Thanks much.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.