Jump to content
  • 0

Question

8 answers to this question

Recommended Posts

  • 0
Posted (edited)

you have a missing table in your database
the missing table name is `global_reg_value`,
make sure that you import the sql files correctly.

im not sure if rathena main.sql have that kind of table

EDIT:
Base from this link https://github.com/rathena/rathena/blob/master/sql-files/main.sql

nope, rathena sql dont have that table,

 

you can modify the npc to use this table(s) instead,
`global_acc_reg_str`

`global_acc_reg_num`
 

Edited by benching
  • 0
Posted

global_reg_value db no longer exist, you should replace this to char_reg_num since "brokeemp" is a permanent character variable.

you have a missing table in your database

the missing table name is `global_reg_value`,

make sure that you import the sql files correctly.

im not sure if rathena main.sql have that kind of table

EDIT:

Base from this link https://github.com/rathena/rathena/blob/master/sql-files/main.sql

nope, rathena sql dont have that table,

 

you can modify the npc to use this table(s) instead,

`global_acc_reg_str`

`global_acc_reg_num`

 

 

Doesn't work

post-4558-0-82330700-1454691087_thumb.png

  • 0
Posted (edited)
 

 

global_reg_value db no longer exist, you should replace this to char_reg_num since "brokeemp" is a permanent character variable.


you have a missing table in your database
the missing table name is `global_reg_value`,
make sure that you import the sql files correctly.

im not sure if rathena main.sql have that kind of table

EDIT:
Base from this link https://github.com/rathena/rathena/blob/master/sql-files/main.sql

nope, rathena sql dont have that table,

 

you can modify the npc to use this table(s) instead,
`global_acc_reg_str`

`global_acc_reg_num`
 

 

Doesn't work

 

oops, sorry.
its char_reg_num_db

please do edit it.

Edited by Aureon
  • 0
Posted

 

 

 

global_reg_value db no longer exist, you should replace this to char_reg_num since "brokeemp" is a permanent character variable.

you have a missing table in your database

the missing table name is `global_reg_value`,

make sure that you import the sql files correctly.

im not sure if rathena main.sql have that kind of table

EDIT:

Base from this link https://github.com/rathena/rathena/blob/master/sql-files/main.sql

nope, rathena sql dont have that table,

 

you can modify the npc to use this table(s) instead,

`global_acc_reg_str`

`global_acc_reg_num`

 

 

Doesn't work

 

oops, sorry.

its char_reg_str not num.

please do edit it.

 

post-4558-0-87015500-1454693875_thumb.png

  • 0
Posted

can you attach the npc script?

turbo_room,89,81,5	script	Breaker Ladder	790,{



query_sql "SELECT `char`.char_id,`char`.`name`,char_reg_str.`value` FROM char_reg_str LEFT JOIN `char` ON char_reg_str.char_id=`char`.char_id WHERE char_reg_str.str='brokeemp' ORDER BY CAST(`char_reg_str`.`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;

}

up

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...