/* 
 
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;
 
*/
 
 
fayon,90,115,5  script  Sample  757,{
function send_mail;
 
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]+" Points";
}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" );
end;
 
OnClock0000:
do{
    query_sql( "SELECT `char_id` FROM `E-MVPRank` WHERE `Count` > 0 ORDER BY `Count` DESC LIMIT 100 OFFSET "+.@offset,.@cid );
    set .@size,getarraysize( .@cid );
    set .@i,0; 
    while( .@i < .@size ){
        .@rank = .@offset + .@i;
        // reward format
        // setarray .@reward,<item id>,<amount>,<zeny>;
        if( .@rank < 1 ) setarray .@reward,512,100,10000;
        else if( .@rank < 10 ) setarray .@reward,512,10,5000;
        else if( .@rank < 50 ) setarray .@reward,512,5,2500;
        else if( .@rank < 100 ) setarray .@reward,512,2,1250;
        else if( .@rank < 200 ) setarray .@reward,512,1,625;
        
        send_mail( ( .@rank+1 ),.@cid[.@i],.@reward[0],.@reward[1],.@reward[2] );
        set .@i,.@i + 1;
    }
    set .@offset,.@offset + 100;
    deletearray .@cid;
}while( .@offset < 200 );
query_sql( "TRUNCATE `E-MVPRank`" );
end;
 
function    send_mail   {
    .@rank = getarg(0);
    .@cid = getarg(1);
    .@item_id = getarg(2);
    .@amount = getarg(3);
    .@zeny = getarg(4);
    
    query_sql( "INSERT INTO `mail` ( send_name,dest_id,title,message,nameid,amount,identify,zeny,time ) VALUES ("+
        "'no-reply',"+.@cid+",'MVP Rank Top "+.@rank+" Reward',"+
        "'Brave one,% % Congratulations!% Your MVP Rank is "+.@rank+" % % % % % % [ Your reward is attached. ]',"+
        .@item_id+","+.@amount+",0,"+.@zeny+",UNIX_TIMESTAMP(NOW()))"
    );
    return;
}
 
}