/*

CREATE TABLE IF NOT EXISTS `kill_rank` (
  `name` varchar(30) NOT NULL default '',
  `kill` int(11) unsigned NOT NULL default '0',

  PRIMARY KEY  (`name`)
) ENGINE=MyISAM;

*/

prontera,155,181,5	script	Sample	757,{
.@rank = query_sql( "SELECT * FROM `kill_rank` ORDER BY `kill` DESC LIMIT 10",.@name$,.@kill );
if( .@rank ){
	mes "Rank";
	for( .@i = 0; .@i < .@rank; .@i++ )
		mes "["+(.@i+1)+".] "+.@name$[.@i]+" - "+.@kill[.@i];
}else{
	mes "No Record..";
}
close;

OnNPCKillEvent:
query_sql( "INSERT INTO `kill_rank` VALUES ( '"+strcharinfo(0)+"','1' ) ON DUPLICATE KEY UPDATE `kill`=`kill`+1" );
end;
}