Emperium Breaker Ladder

[Hatake Kakashi]

how to put reset or how to reset this emp ladder?

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;

Lex:
next;
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "What points would you like to exchange?";
mes "^FF0000Note: Check your inventory and weight before exchanging with me!";
menu "Emperium Break Points",-,"Nothing",Lno;
next;
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "What do you want to exchange with?";
menu "Billow",-,"Emblem of Solar God",Lesg,"Ripple",Lrip,"Silver Ornament",Lsil,"Wrath of Valkyrie",Lval;
next;
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "You need 50 Breaker Points for this..";
mes "Do you still want Billow?";
menu "Yes",-,"No",Lno;
if(brokeemp < 50) goto Lnep;
if(brokeemp >= 50)
next;
mes "Here you go!";
getitem 7091,1;
set brokeemp,brokeemp-50;
close;


Lnep:
next;
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "Not enough points!";
close;

Lesg:
next;
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "You need 70 Breaker Points for this..";
mes "Do you still want Emblem of Solar God?";
menu "Yes",-,"No",Lno;
next;
if(brokeemp < 70) goto Lnep;
if(brokeemp >= 70)
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "Here you go!";
getitem 7086,1;
set brokeemp,brokeemp-70;
close;

Lrip:
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "You need 50 Breaker Points for this..";
mes "Do you still want Ripple?";
menu "Yes",-,"No",Lno;
if(brokeemp < 50) goto Lnep;
if(brokeemp >= 50)
next;
mes "Here you go!";
getitem 7090,1;
set brokeemp,brokeemp-50;
close;

Lval:
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "You need 50 Breaker Points for this..";
mes "Do you still want Wrath of Valkyrie?";
menu "Yes",-,"No",Lno;
if(brokeemp < 50) goto Lnep;
if(brokeemp >= 50)
next;
mes "Here you go!";
getitem 7078,1;
set brokeemp,brokeemp-50;
close;

Lsil:
mes "[ ^00FF00 Kaspersky ^000000 ]";
mes "You need 50 Breaker Points for this..";
mes "Do you still want Silver Ornament?";
menu "Yes",-,"No",Lno;
if(brokeemp < 50) goto Lnep;
if(brokeemp >= 50)
next;
mes "Here you go!";
getitem 7077,1;
set brokeemp,brokeemp-50;
close;

Llad:
   next;
   for( set .@x,0; .@x<=9; set .@x,.@x+1 )
   {
       mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+.@count[.@x]+"^000000 Point(s)";
   } // .@x starts at 0, but you want to start with '1st', so use (.@x+1)
close;

}

[Emistry]

open your database and delete every single variable named "value"

not sure this will work or not ~

​DELETE FROM global_reg_value WHERE value != 0;

Edited December 3, 2011 by Emistry

[Hatake Kakashi]

but in my database i dont have that breaker.sql.

[Emistry]

inside your global_reg_value with named "value"

[Brian]

​DELETE FROM global_reg_value WHERE value != 0;

That will delete ALL non-zero variables from your `global_reg_value` table!

@Hatake: here's how to delete the "brokeemp" variables

1. stop your server
   
2. run this SQL query:
   

   DELETE FROM global_reg_value WHERE `str`='brokeemp';

   
   

3. start your server
   

Edited December 3, 2011 by Brian

[Emistry]

DX ... i tot the variable that stored in the table was named as "Value" ..... Deng !!!! >.<