I want to be able to level up by sql

[Prime]

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

[ocelote]

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 May 2, 2015 by ocelote

[Emistry]

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;

[Prime]

Thanks you all!