Emperium Breaker Ladder

[sandbox]

Every emp break, the breaker gets +1 point, and he/she can exchange it for prizes(castle drops, etc)

Installation:

npc/guild/agit_template.txt

find:

// The Emperium has been broken.
OnAgitBreak:
set .@GID,getcharid(2);
// Show and log error if an unguilded player breaks the Emperium. (Should NEVER happen)

add:

// The Emperium has been broken.
OnAgitBreak:

set brokeemp,brokeemp+1;

set .@GID,getcharid(2);
// Show and log error if an unguilded player breaks the Emperium. (Should NEVER happen)

download the file,

put it on your npc/custom folder,

as for now you can exchange it for 5 castle drops only, you can add / replace the prizes that would be given (see script)

the ladders shows the top 10 who has highest points, when you exchange your points for prizes, your points decreases @ the ladder too, you can edit that by adding another variable and editing the ladder output formula, or if you don't know how to, just post here

Enjoy:D

Download Link: http://pastebin.com/ausRbr9v

[Jezu]

+1 vote for this!

It is really helpful when you have a lot of Emperium Breaker on your server and if this is enable on your server, they will surely excite for what prizes they will get when breaking an Emperium!

* Recommended for WoE/PvP/BG Oriented Servers outhere!

[sandbox]

Well you seem to be liking my scripts aren't you? Thank you Jesu! I might release some more after I'm done cleaning my script archives, I haven't been much into scripting these days, I make 0-2 per month now.. Thanks for acknowledging my work! I will inform you if there would be more!

Edited June 12, 2012 by ganjaman

[kickazz08]

How to add this in your database?

query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

[Euphy]

How to add this in your database?

query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

That's an NPC query, and furthermore it's a "select" command. Read: documentation, basics.

In other words, you don't.

[kickazz08]

sorry im new at rathena..

i have seen scripts on emp breaker ladder...

like this one..

prontera,148,188,5 script Breaker Ladder 790,{

query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

mes "[ ^00FF00 Kaspersky ^000000 ]";

mes "Hello there "+strcharinfo(0)+", what do you want to do?";

menu "Check Emperium Break Points",-,"View Breaker Ladder",Llad,"Exchange Points",Lex,"Nothing",Lno;

next;

next;

mes "[ ^00FF00 Kaspersky ^000000 ]";

mes "Hmm, wait a second, i'll go check my records..";

next;

mes strcharinfo(0)+"'s Emperium Break Points is ^FF0000"+brokeemp+"^000000 Point(s)";

close;

Lno:

next;

mes "[ ^00FF00 Kaspersky ^000000 ]";

mes "Suit yourself..";

close;

so i just leave it out like this?

thnx euphy..... can the records of the break oints be modified ?