Automated MVP ladder & reward system 4.1

//===== rAthena Script =======================================
//= Automated MVP Ladder and reward system 
//===== By: ==================================================
//= pajodex
//===== Current Version: =====================================
//= 4.0
//===== Compatible With: =====================================
//= rAthena Project (pajodex)
//===== Description: =========================================
/*

- MVP Ladder which is fully automated.
- Just leave it on and NPC will do the rest.
- Easy configure
- Added @mvpreset command to reset the ladder. It will also reset the 
  monthly and weekly if it is on the '.day' and '.week' at settings 
- Updated with latest mail command https://github.com/rathena/rathena/commit/5b13dc7009e312585bba0ea55d77fc5afa8aecad

New Feature:
    * Event will only trigger to MVPs in their respective maps..
    * If amon ra is killed outside moc_pryd06, script wont trigger..
    

*/
//=====******** Note ********=================================
//= if you find bugs or problem, please do tell DM me at
//= Discord (pajodex#1328) or rAthena (pajodex) 
//= open for suggestions
//===== Additional Comments: =================================
// 1.0 - Initial release (MVP Kill standalone)
// 2.0 - Added SQL based with ladder
//         Added automatic reward system
//         Added functions
//         Added bitwise variables
//         Optimization
// 2.1 - Cleaned the script
//         updated title
// 2.2 - Fixed error on reward if players are offline    
// 2.3 - Added nobranch mapflags to all maps listed (Sukea23 via discord)
// 2.4 - Ranking fixed (reported by Sukea23)
// 3.0 - Script optimization and re-work
//         added new ranker feature : view your rank
//         added mvp ladder points system
//         added simple mvp ladder shop
// 3.1 - Fix ranking issues on tie-cases (reported by Heikenz) https://rathena.org/board/topic/114565-utility-automated-mvp-ladder-reward-system/?do=findComment&comment=344981
//         added item as currency support in ladder shop (Heikenz)
//         modified F_CheckMvpLadder function 
//         Special Thanks to : AnnieRuru for mentoring me.
// 4.0 - Updated to latest svn
//          Now uses *mail script command. You must UPDATE your trunk
//       or apply this commit https://github.com/rathena/rathena/commit/5b13dc7009e312585bba0ea55d77fc5afa8aecad
//         Script Optimization
//         Script Rework
//       Now uses a new SQL table that utilizes InnoDB instead of MyISAM
// -------------------------------------------------------
//         How to use F_MVPReward:
//         F_MVPReward ( <tablename>, <Num of players to get reward (default : 10)>, <rewardarrays> )
//         This will allow you to set the number of players to receive
//         the rewards. For small population server, you can set this to 5 or 
//         any amount as you wish.
//         This update is in-response to Holograma's question in the post:
//        https://rathena.org/board/topic/114565-utility-automated-mvp-ladder-reward-system/?tab=comments#comment-341725
//===== Credits goes to: =====================================
//= hurtsky
//= secret
//= sader1992
//= Stolao
//= Euphy 
//= AnnieRuru
//=============================================================

// Bitwise Variables 
    // 1 = enable daily reward and record
    // 2 = enable weekly reward and record
    // 4 = enable monthly reward and record
    // 8 = enable mvp ladder item reward when killing MVP
    // 16 = enable mvp ladder points when killing MVP
    .Option = 1|2|4|8|16;    
    
    // NPC Name
    .nm$ = "[ ^FF0000MVP Ranker^000000 ]";
        
    // Point rewarded when mvp is killed (if Option 16 is enabled)
    .point = 100;    
    
    // Chance of getting an item (if Option 8 is enabled)
    .chance = 80;    
    
    // Day of the month to automatically get reward
    .day = 1;
    
    // Day of the week
    .week = SUNDAY; 
    
    setarray .reward,    // rewards for mvp killing    
        501, 10,        // Solo reward <item>, <amt>
        501, 5;            // Party reward <item>, <amt>
    
    // daily top 10 reward <ID>,<AMOUNT>,<ZENY>
    setarray .daily_rwd,  
            607,3,1000, // top 1
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,2,1000,
            607,1,1000;    // top 10    
    
    // weekly top 10 reward <ID>,<AMOUNT>,<ZENY>
    setarray .weekly_rwd,   
            607,3,10000, // top 1
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,2,10000,
            607,1,10000; // top 10
            
    // monthly top 10 reward <ID>,<AMOUNT>,<ZENY>
    setarray .monthly_rwd, 
            607,3,100000, // top 1
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,2,100000,
            607,1,1000; // top 10
            
    // use @mvpreset command to reset the ladder. It will also reset the ...
    // ... montly and weekly if it is on the .day and .week settings from above
    bindatcmd("mvpreset" ,strnpcinfo(0)+"::OnReward",99,99);
    
    // No branch mapflags on the maps listed..
    for(.@i = 0; .@i < getarraysize(.t_maps$); ++.@i)
        setmapflag .t_maps$[.@i], mf_nobranch;
    
    // ladder shop
    npcshopdelitem "mvp_ladder_shop_q", 607;
    
    for(.@i = 0; .@i < getarraysize(.Shop); .@i = .@i + 2)
        npcshopadditem "mvp_ladder_shop_q", .Shop[.@i], .Shop[.@i + 1];
    
    waitingroom "MVP LADDER!",0;