[MySQL] Check Account not quite working
#4

Quote:
Originally Posted by coakiddo
Посмотреть сообщение
You are not using threaded queries correctly.
https://sampforum.blast.hk/showthread.php?tid=337810

Код:
stock CheckAccountExists(account[])
{
        new string[128];
        format(string, sizeof(string), "SELECT * FROM `users` WHERE `Name` = '%s' LIMIT 1", account);
        mysql_function_query(mCon, string, true, "CheckAccount", "","");
        return 1;
}
Код:
forward CheckAccount();
public CheckAccount()
{
      new rows, fields;
      cache_get_data(rows, fields);
      if(rows) // registered
      {
      }
      else // Not registered
      {
      }
}

Thanks i need to check the plauers account for OnPlayerConnect to show the correct dialog

Код:
public OnPlayerConnect(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,sizeof(name));
	if(CheckAccountExists(name))
	{
        ShowPlayerDialog(playerid,dlogin,DIALOG_STYLE_INPUT,"Login","Welcome back. This account is registered. \nInsert your password to login to your account","Login","Quit");/*A dialog with input style will appear so you can insert your password to login.*/
    }
    else 
    {
        ShowPlayerDialog(playerid,dregister,DIALOG_STYLE_INPUT,"Register","Welcome! This account is not registered.\nEnter your own password to create a new account.","Register","Quit");
        return 1;
    }
I have no use for CheckAccount? new to MySQL and its confusing a little
Reply


Messages In This Thread
[MySQL] Check Account not quite working - by Kontrol - 16.01.2013, 03:00
Re: [MySQL] Check Account not quite working - by Treyvan - 16.01.2013, 03:07
Re: [MySQL] Check Account not quite working - by coakiddo - 16.01.2013, 06:54
Re: [MySQL] Check Account not quite working - by Kontrol - 16.01.2013, 12:33
Re: [MySQL] Check Account not quite working - by coakiddo - 16.01.2013, 14:10
Re: [MySQL] Check Account not quite working - by Kontrol - 16.01.2013, 14:24
Re: [MySQL] Check Account not quite working - by Kontrol - 17.01.2013, 02:04
Re: [MySQL] Check Account not quite working - by Kontrol - 17.01.2013, 18:49

Forum Jump:


Users browsing this thread: 1 Guest(s)