algaia,205,161,4 script Test Rank 100,{

mes "[Blacksmith Ranking]";
mes "=======================";
for( set .@i,0; .@i < getarraysize( .Name$ ); set .@i,.@i + 1 ){
	mes "Top "+( .@i + 1 )+" Smith";
	mes ""+.Name[.@i]+" - Fame : "+.Fame;
	mes "=======================";
}
close;

OnPCLoginEvent:
for( set .@i,0; .@i < getarraysize( .Name$ ); set .@i,.@i + 1 )
	if( strcharinfo(0) == .Name$[.@i] ){
		atcommand "@aura 701";
		dispbottom "You're on "+( .@i + 1 )+"th Place";

	}
end;

OnInit:
query_sql( "SELECT `fame`,`name` FROM `char` WHERE `fame` > 0 AND `class` IN ( '10','4011','4033','4058','4064','4100' ) ORDER BY `fame` DESC LIMIT 3", .Fame, .Name$ );
end;
}