automatically award

[Scofield]

I have this script that shows the top 100 ranking placed in PvP, like once a month he was alone and did reset the first place award.

 

prontera,171,182,3    script    Ranking MvP    857,{

    if (getgmlevel() > 20) {
        if ( select( "Ranking", "Reset" ) -1 ) {
            query_sql "DELETE FROM `global_reg_value` WHERE `str` = 'MVPRank'";
            dispbottom "Ranking MvP resetado.";
            close;
        }
    }
    query_sql "SELECT `global_reg_value`.`value`, `char`.`name` FROM `global_reg_value` left join `char` on `global_reg_value`.`char_id` = `char`.`char_id` "+
                "WHERE `global_reg_value`.`str`= 'MVPRank' ORDER BY ABS(value) DESC LIMIT 100", .@pontos_mvp, .@char_name$;
    dispbottom "Posição.  Jogador:  MVPs Mortos: ";
    dispbottom " ";
    if( !getarraysize( .@char_name$ ) )
        dispbottom "*Lista Vazia*";
    else
        for( set .@i,0; .@i < getarraysize( .@char_name$ ) ; set .@i, .@i +1 )
            dispbottom "["+ ( .@i +1 ) +"] Nome: ["+ .@char_name$[.@i] +"] [MVPs: "+ .@pontos_mvp[.@i]+"]";
    close;

OnInit:
    waitingroom "[ Ranking MVP ]",0;
    end;
}