help NPC Email Updater Script

[LordJasz]

Sup people.
I'm trying to create a npc that will update the emails and I don't know what is wrong...
Here is the script.

prontera,156,145,4	script	Test NPC::test	589,{
set .@accountid,getcharid(3);
    mes "Do you want to register your email to receive our news?";
    menu "Let's go!",-,"Nah, I'm okay.",L_No;
	next;
	mes "Type your email.";
    input (.@email,5,39);
	query_sql ( "UPDATE `login` SET `email` VALUE "+.@email" WHERE `account_id` LIKE "+.@accountid+"");
	next;
	mes "Muito bem seu e-mail foi cadastrado/atualizado!";
    close;
L_No:
	mes "Tudo bem."
	close;
}

Is anything right at least? Lol

[Emistry]

while (input (.@email$,5,39));
query_sql ( "UPDATE `login` SET `email` = '"+escape_sql(.@email$)+"' WHERE `account_id` LIKE "+.@accountid+"");

 

[LordJasz]

12 hours ago, Emistry said:

while (input (.@email$,5,39));
query_sql ( "UPDATE `login` SET `email` = '"+escape_sql(.@email$)+"' WHERE `account_id` LIKE "+.@accountid+"");

 

Thanks! 100% Working.