Emperium Breaker ladder

[Emperium Breaker ladder]

hmmmp.. i dont get this one

 

/* SQL Query

alter table `char` add empbreak int(11) unsigned not null default 0 after unban_time, add index (empbreak);

*/

 

please check my 2 screen shots if i do it correctly

is this correct?

 

or this one

the first one...

create empbreak inside "char" columns

 

 

_____________________________________________________________________________

 

 

btw how can i add announce for who break the emperium ?

 

 

Thx for help

 

 

 

edited

done

 

I add

 

announce ""+ strcharinfo(0) +" has destroyed the Emperium in the map [" +strcharinfo(3) +"]",bc_blue;

or

announce "["+ strcharinfo(0) +"] has destroyed the ["+getcastlename(strnpcinfo(2))+"] Emperium",bc_all,0x800080;

 

after

 

query_sql "update `char` set empbreak = empbreak +1 where char_id = "+ getcharid(0);