Breaker of the month

[Outfox pRO]

please set my breaker of the month to war of emperium only thank you

prontera,157,197,3 script BOTM 413,{


mes "[Breaker of The Month]";

set @nb, query_sql("select name,count(*) as wins from `emp_breakers` left join `char` on `char`.char_id=`emp_breakers`.char_id where `time`>='"+(gettimetick(2)-(3600*24*30))+"' group by `emp_breakers`.char_id ORDER BY wins DESC LIMIT 1", @name$, @wins);

if(@nb)

{

mes ""+@name$[0]+" - "+@wins[0]+" wins";

}

else

{

mes "We have not this player";

monster "prontera",160,186,"Poringz0rd",1288,1;

}

close;


OnInit:

waitingroom "Breaker Of The Month",0;

end;

query_sql("CREATE TABLE IF NOT EXISTS `emp_breakers` (`id` int(20) NOT NULL AUTO_INCREMENT,`char_id` int(30) NOT NULL,`time` int(30) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB;");

end;


OnNPCKillEvent:

if(killedrid == 1288)

{

query_sql("insert into emp_breakers values (null, '"+getcharid(0)+"', UNIX_TIMESTAMP())");

}

end;

}

Edited September 15, 2013 by Patskie
Change to code

[Capuche]

I don't undersand your request, please reformulate it.