/*
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;
*/

fayon,90,115,5 script Sample 757,{
query_sql( "SELECT `name`,`Class`,`Count` FROM `E-MVPRank` ORDER BY `Count` DESC LIMIT 10",.@Name$,.@Class,.@Count );
if( getarraysize( .@Name$ ) ){
	for( set .@i,0; .@i < getarraysize( .@Name$ ); set .@i,.@i + 1 )
		mes "[ "+( .@i + 1 )+". ] "+.@Name$[.@i]+" ( "+jobname( .@Class[.@i] )+" ) - "+.@Count[.@i]+" Points";
}else{
	mes "No Record Found.";
}
close;

OnInit:
setarray .mvp_list[0],1002,1002,1002,1002;
for( .@i = 0; .@i < getarraysize( .mvp_list ); .@i++ )
	setd( ".mvp_"+.mvp_list ),1;

OnMinute00:
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;

OnNPCKillEvent:
if( getd( ".mvp_"+.mvp_list ) )
	query_sql( "INSERT INTO `E-MVPRank` SET `char_id`='"+getcharid(0)+"',`name`='"+strcharinfo(0)+"',`Class`='"+Class+"',`Count`='1' ON DUPLICATE KEY UPDATE `Count`=`Count`+1" );
end;
}