harboro1,77,245,3 script Voucher 878,{
mes @name$;
mes "Service premium ID";
next;
menu "Input Code Voucher",L_ICV,"Change my Mind",L_end;
L_ICV:
mes "Input your code";
input @donate_code$;
next;
query_sql "SELECT `code` FROM `cashcode` WHERE `code` = '"+@donate_code$+"'", @donation_code$;
query_sql "SELECT `status` FROM `cashcode` WHERE `code` = '"+@donate_code$+"'", @donate_status;
if(strtoupper(@donate_code$)==@donation_code$ && @donate_status == 0)
{
query_sql "SELECT `cash` FROM `cashcode` WHERE `code` = '"+@donate_code$+"'", .@donation_code$;
atcommand "@cash +"+.@donation_code$+"";
mes "You gained ^0000FF" + .@donation_code$ + "^000000 Cash Point.";
mes "Total Cash : ^0000FF"+#CASHPOINTS+"^000000 Cash Point";
query_sql "UPDATE `cashcode` SET `status`=1 WHERE `code`='"+@donate_code$+"'";
query_sql "UPDATE `cashcode` SET `userid`=(SELECT `userid` FROM `login` WHERE `code`='"+@donate_code$+"')";
close2;
end;
}
if(strtoupper(@donate_code$)==@donation_code$ && @donate_status == 1)
{
mes "Code already used.";
close;
}
else
{
mes "Code unregister.";
close;
}
L_end:
mes "if you change of mind back again";
close;
}
anybody help me. i want take userid from table login to table cashcode.
code i make is wrong. ?