MvP Ranker NPC

//============================
// MvP Ranker NPC
//============================
sec_in01,84,175,4	script	MVP Ranking	722,{
	set .@npc$,"[ ^FF0000 MVP's Ranking ^000000 ]";
	mes .@npc$;
	query_sql "SELECT name, kills, points FROM mvp ORDER BY kills DESC LIMIT 10",.@name$,.@kills,.@points;
	for(set .@i,0;.@i<=9;set .@i,.@i+1) {

		mes "^0000FF"+(.@i+1)+".^000000 " +( (.@name$[.@i] == "")? "None":.@name$[.@i] )+ " - ^FF0000"+.@kills[.@i]+"^000000 Kill(s)";
	}
	mes " ";
	set .@npc$,"";
	set .@points,0;
	query_sql "SELECT `points` FROM `mvp` WHERE `char_id`="+getcharid(0),.@points;
	mes "^0000FF["+strcharinfo(0)+"'s]^000000 MvP kill(s) is ^FF0000"+.@points+"^000000 Boss Monster(s).";
	close;

	OnInit:
	//waitingroom "MVP's Ranking",0;   // Look on the configuration!
	end;

}