/*
	// run these SQL script
		ALTER TABLE  `char` ADD  `emp_break` INT( 11 ) NOT NULL DEFAULT  '0';
		ALTER TABLE  `guild` ADD  `emp_break` INT( 11 ) NOT NULL DEFAULT  '0';

	// find this ...inside	 npc/guild/agit_main.txt ( line 101 )
		OnAgitBreak:

	// add below
		query_sql( "UPDATE `char` SET `emp_break` = `emp_break` + 1 WHERE `char_id` = "+getcharid(0) );
		query_sql( "UPDATE `guild` SET `emp_break` = `emp_break` + 1 WHERE `guild_id` = "+getcharid(2) );

*/

prontera,155,171,5	script	Emperium Breaker	757,{
.@mode = select( "Top "+.top_rank+" Player", "Top "+.top_rank+" Guild" ) - 1;
query_sql( "SELECT `name`,`emp_break` FROM `"+.table$[.@mode]+"` WHERE `emp_break` > 0 ORDER BY `emp_break` DESC LIMIT "+.top_rank,.@name$,.@break );
.@size = getarraysize( .@name$ );
if( .@size ){
	mes "Top "+.top_rank+" emp breaker records.";
	while( .@i < .@size ){
		mes "["+( .@i+1 )+".] "+.@name$[.@i]+" : "+.@break[.@i];
		.@i++;
	}

}else{
	mes "No record found.";
}
close;

OnInit:
// show how many record
.top_rank = 10;
setarray .table$,"char","guild";
end;

}