Jump to content
  • 0

I want to be able to level up by sql


Question

Posted
niflheim,304,71,6	script	 Woe Coin Trader	956,{
mes "[Woe Coin]";
mes "test 350";
next;
switch(select("Yes:No")) {
	case 1:
	mes "[ Woe Coin ]";	
	query_sql "UPDATE `char` SET `base_level` = '"+@lvl+"' WHERE `char_id` = '"+getcharid(0)+"' LIMIT 1";
	end;
	
	case 3:
	mes "[ Woe Coin ]";
	mes "Come back any time.";
	close;
}
OnInit:
set @lvl, 349;
}

I cant level up my char it shows a mysql error i want that it updates the char lvl to 350 by sql please help :c

3 answers to this question

Recommended Posts

Posted (edited)

You can't use @ variable in OnInit event. Cuz it's 'temporary character integer variable'

You need this:

niflheim,304,71,6    script     Woe Coin Trader    956,{
mes "[Woe Coin]";
mes "test 350";
next;
switch(select("Yes:No")) {
    case 1:
    mes "[ Woe Coin ]";    
    query_sql("UPDATE `char` SET `base_level` = '"+.lvl+"' WHERE `char_id` = '"+getcharid(0)+"'");
    close;
    
    case 2:
    mes "[ Woe Coin ]";
    mes "Come back any time.";
    close;
}
OnInit:
set .lvl, 349;
end;
}

But why you don't use 

set BaseLevel, BaseLevel + .level;

??

Edited by ocelote
Posted


query_sql( "UPDATE `char` SET `base_level` = 350 WHERE `online` = 0 AND `base_level` < 350" );

addrid(0);

if ( BaseLevel < 350 ) {

BaseLevel = 350;

mes "You level up to 350.";

}

end;

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...