mes .@npc_name$;
mes "Welcome to the Donation System. How can I help you?";
next;
switch(Select("Server Information:Donation Information:View My Donation Code:Enter My Donation Code:Exit"))
{
case 1:
// todo Server Information
close;
case 2:
// to do Donation Information
close;
case 3:
mes .@npc_name$;
mes "Please enter your Validation Code:";
input @my_code$;
next;
query_sql "SELECT `validation_code` FROM `donate` WHERE `validation_code` = '"+@my_code$+"'", @available_code$;
next;
if(@my_code$ == @available_code$)
{
query_sql "SELECT `code` FROM `donate` WHERE `validation_code` = '"+@my_code$+"'", @available_code2$;
mes .@npc_name$;
mes "Your Donation Code is : [^FF7700" + @available_code2$+ "^000000].";
close2;
end;
}
else
{
mes .@npc_name$;
mes "Your Validation Code is Invalid.";
close;
}
case 4:
mes .@npc_name$;
mes "Please enter your Donation Code:";
input @donate_code$;
next;
query_sql "SELECT `code` FROM `donate` WHERE `code` = '"+@donate_code$+"'", @donation_code$;
query_sql "SELECT `status` FROM `donate` WHERE `code` = '"+@donate_code$+"'", @donate_status;
if(strtoupper(@donate_code$)==@donation_code$ && @donate_status == 0)
{
query_sql "SELECT `item_amount` FROM `donate` WHERE `code` = '"+@donate_code$+"'", @Donation_Code$;
mes .@npc_name$;
mes "You get ^0000FF" + getitemname(.donate_item) + " - " + @Donation_Code$ + " ea.^000000";
query_sql "UPDATE `donate` SET `status`=1 WHERE `code`='"+@donate_code$+"'";
close2;
//query_sql "DELETE FROM `donate` WHERE `code`='"+@donate_code$+"'";
getitem .donate_item,@Donation_Code$;
end;
}
else
{
mes .@npc_name$;
mes "This Donation Code doesn't exist.";
close;
}
case 5:
mes .@npc_name$;
mes "Have a nice day.";
close;
}
this is my code
i want is when i put the Donation Code it will register automatically her account id in the SQL