emp ranker

////============================
//// Emp Breaking Ladder
////============================
sec_in01,88,175,4	script	Emperium Ranking	722,{
	query_sql "SELECT `char`.`char_id`,`char`.`name`, `global_reg_value`.`value` FROM global_reg_value LEFT JOIN `char` ON `global_reg_value`.`char_id`=`char`.`char_id` WHERE `global_reg_value`.`str`='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

	mes "^FF0000[ Emperium Ranking ]^000000";
	for( set .@x,0; .@x<=9; set .@x,.@x+1 ) {
	mes "^0000FF"+(.@x+1)+".^000000 " +( (.@name$[.@x] == "")? "None":.@name$[.@x] )+ " - ^FF0000"+.@count[.@x]+"^000000 Break(s)";
}
	mes " ";
	mes "^0000FF["+strcharinfo(0)+"'s]^000000 Emperium Break's is ^FF0000" + brokeemp + "^000000 Break(s)";
	close;

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

}