[fuem1907]

Hello there, I have a script which written in SQL language.

Let me explain what I need:

When someone connects to your server, in registration screen, it'll also ask for their e-mail. And there will be a note above it which says "Attention, if you don't put your correct e-mail here, if somethings happens to your account xx-gaming won't take responsibility." and when they put their mail there, it'll be saved to their character file. Thats it. Can someone do that coding for me?

[Cameltoe]

Just add another dialog where the user has to input their email as well. It's quite easy really. https://sampwiki.blast.hk/wiki/ShowPlayerDialog

[fuem1907]

I see but, We need a code that gonna save e-mail's to mySQL. Our mysql table name is "mail" and we're using zCMD. When someone types cmd:mail and he has no mail info in his userfile. He'll be forwarded to the dialog screen for typing his mail. But if he
already got his e-mail in his userfile. He won't be able to change it with this CMD. Thanks.

[Cameltoe]

mysql("UPDATE `users` SET mail = 'mailhere' WHERE username = 'usernamehere';");

And get the email from inputtext from the dialog.