Emperium Breaker ladder

[AnnieRuru]

being asked too much in script request section, so better just release one

script
emp_breaker_ladder_1.0.txt
patch ... no need recompile ...
http://upaste.me/0b1d4993914f05487

what this script do ?
hmm ... just display the top players who has broke emperium ..

Spoiler

emp_breaker_ladder_1.0.txt
emp_breaker_ladder_1.0.diff

http://upaste.me/0b1d4993914f05487

 

[Hadeszeus]

+1

 

[Mashiro]

being asked too much in script request section, so better just release one

script

emp_breaker_ladder_1.0.txt

patch ... no need recompile ...

emp_breaker_ladder_1.0.diff

what this script do ?

hmm ... just display the top players who has broke emperium ..

how to instal? (where i put emp_breaker_ladder.diff?)

sorry for bad english.

 

[jaBote]

Diff file is not put anywhere, it's a file so that some tools can automatically apply it on your files, but you can do so manually. You can manually perform these changes without the need of an automated tool. This diff is particularly simple to apply:

On npc/guild/agit_main.txt look for:

OnAgitBreak:Add after that:

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

 On npc/guild/agit_main_se.txt look for:

OnStartArena:Add after that:

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

And don't forget to add the SQL addition on your database that comes with the NPC!

 

[WalkingBad]

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

 

[mrdominic]

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);

 

[rans]

Nice!