[Cyrodii]

This is my OnPlayerConnect.

pawn Код:

public OnPlayerConnect(playerid)
{
    new query[126];
    
    if(Checkban(playerid) == 0)
    {
        format(query, sizeof(query), "SELECT * FROM accounts WHERE pName = '%s'", GetName(playerid));
        mysql_query(query);
        mysql_store_result();
        
        if(mysql_num_rows() == 1)
        {
            SendClientMessage(playerid, -1, "That username is registered!");
            ShowPlayerDialog(playerid, dialogThreadLogin, DIALOG_STYLE_INPUT, "Login", "Please login with the password you made", "Login", "Cancel");
        }
        else
        {
            SendClientMessage(playerid, -1, "That username is not registered. You may register it");
            ShowPlayerDialog(playerid, dialogThreadRegister, DIALOG_STYLE_INPUT, "Register", "Please enter a password you will remember", "Register", "Cancel");
        }
    }

    return 1;
}

So in your case you would probably just need:

pawn Код:

new query[126]

format(query, sizeof(query), "SELECT * FROM accounts WHERE pName = '%s'", GetName(playerid));