[Antenastyle]

Alright, I have a problem with a SQL function called DoesPlayerExists, this is the code:

Код:

public OnPlayerConnect(playerid)
{
    DefaultPlayerValues(playerid);
	
	Logged[playerid] = false;
 
    DoesPlayerExist(playerid);
    return true;
}

Код:

public DoesPlayerExist(playerid)
{
    new query[128];
    mysql_format(sqlConnection, query, sizeof(query), "SELECT id FROM users WHERE Name= '%e' LIMIT 1", GetName(playerid));
    mysql_pquery(sqlConnection, query, "SQL_DoesPlayerExist", "i", playerid);
    return true;
}

Код:

public SQL_DoesPlayerExist(playerid)
{
    new exists = -1;
    if(cache_num_rows(sqlConnection) != 0)
    {
       ShowLoginDialog(playerid, "");
    }
    else
    {
        ShowRegisterDialog(playerid, "");
    }
	
	TogglePlayerSpectating(playerid, true);
	
    return exists;
}

It shows the register dialog when needed but it doesn't shows the login one. Don't know why

[Freedom.]

Try this.

Код:

public OnPlayerConnect(playerid)
{
    DefaultPlayerValues(playerid);
	Logged[playerid] = false;

	new query[128];
	format(query, sizeof(query), "SELECT * FROM `users` WHERE `name` = '%s'", GetName(playerid));
	mysql_tquery(g_SQL, query, "SQL_DoesPlayerExist", "d", playerid);
    return 1;
}

forward SQL_DoesPlayerExist(playerid);
public SQL_DoesPlayerExist(playerid)
{
	if(cache_num_rows() > 0)
	{
       ShowLoginDialog(playerid, "");
    }
    else
    {
        ShowRegisterDialog(playerid, "");
    }
    
	TogglePlayerSpectating(playerid, true);
    return 1;
}

[Antenastyle]

Quote:

Originally Posted by Freedom. Try this. Код: public OnPlayerConnect(playerid) { DefaultPlayerValues(playerid); Logged[playerid] = false; new query[128]; format(query, sizeof(query), "SELECT * FROM `users` WHERE `name` = '%s'", GetName(playerid)); mysql_tquery(g_SQL, query, "SQL_DoesPlayerExist", "d", playerid); return 1; } forward SQL_DoesPlayerExist(playerid); public SQL_DoesPlayerExist(playerid) { if(cache_num_rows() > 0) { ShowLoginDialog(playerid, ""); } else { ShowRegisterDialog(playerid, ""); } TogglePlayerSpectating(playerid, true); return 1; }

That worked, thank you!