Query and String help

[nasagnilac]

HI Im just having a problem with my script

-	script	Donate	-1,{

		setarray .@DonateItems[0],  5518, 5518, 25000;
		setarray .@DonateAmount[0],    1,    1,   100;
OnInit:
	bindatcmd "reward","Donate::OnDoDonate",100,100;
	end;

OnDoDonate:
	input $@email$;
	query_sql "SELECT `userid` FROM `login` WHERE `email` = '$@email$'",$@userid$;
			if (!$@email$) {dispbottom "The email is invalid."; end;}
	for( set .@i, 0; .@i < getarraysize(.@DonateItems); set .@i, .@i + 1 ){
	query_sql("INSERT INTO `rewardaccountnpc` ('account_id', 'reward_id' , 'reward_amount') VALUES ('$@userid$','.@DonateItems[.@i]','.@DonateAmount[.@i]')");
	}
}
	

When Im going to put the email [email protected]..

I got this kind of error... what is the problem?

Edited November 10, 2013 by gmprestige

[Capuche]

query_sql "SELECT `userid` FROM `login` WHERE `email` = '$@email$'",$@userid$;

should be

query_sql "SELECT `userid` FROM `login` WHERE `email` = '" + $@email$ + "'",$@userid$;

same thing in insert

 

 

if (!$@email$) ...

$@email$ is a string variable, "!" is unappropriate

it should be

if ($@email$ == "")

 

 

 

		setarray .@DonateItems[0],  5518, 5518, 25000;
		setarray .@DonateAmount[0],    1,    1,   100;
OnInit:

these arrays should be definited under OnDoDonate: label like that

OnDoDonate:
	setarray .@DonateItems[0],  5518, 5518, 25000;
	setarray .@DonateAmount[0],    1,    1,   100;