[NewerthRoleplay]

Hey in my login and register system I am using threaded queries, however I am not sure how I would use the fetch row format function in the callback, here is the callback:

pawn Код:

public OnPlayerLogin(playerid)
{
    new username[MAX_PLAYER_NAME];
    GetPlayerName(playerid, username, sizeof(username));
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        if(mysql_fetch_row_format(query, "|"))
        {
            sscanf(query,"e<p<|>s[24]s[32]iiiiiiiiiiiiiifffiiii>", PlayerInfo[playerid]);
            new str[80];
            format(str, sizeof(str),"Welcome %s, you have been loged to your account",username);
            SendClientMessage(playerid, COLOR_BLUE, str);
            SetPlayerInterior(playerid, 0);
            SetPlayerVirtualWorld(playerid, 0);
            if(PlayerInfo[playerid][pPosX] != 0 && PlayerInfo[playerid][pPosY] != 0 && PlayerInfo[playerid][pPosZ] != 0)
            {
                SetPlayerPos(playerid, PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ]);
            }
            SpawnPlayer(playerid);
        }
    }
    else
    {
        ShowPlayerDialog(playerid,LOGIN_DIALOG,DIALOG_STYLE_PASSWORD,"SpectralRP: Login.","Wrong password:","Login","Cancel");
    }
    mysql_free_result();
}

And here is the login stock:

pawn Код:

stock LoginPlayer(playerid, pass[])
{
    new query[1000], username[MAX_PLAYER_NAME];
    GetPlayerName(playerid, username, sizeof(username));
    format(query, sizeof(query),"SELECT * FROM `Users` WHERE Username = '%s' AND password = md5('%s')",username, pass);
    mysql_function_query(dbconnect, query, false, "OnPlayerLogin", "");
}

The errors I am getting are:

Код:

Y:\Documents\SpectralRP\gamemodes\spectral.pwn(522) : error 017: undefined symbol "query"
Y:\Documents\SpectralRP\gamemodes\spectral.pwn(524) : error 017: undefined symbol "query"

The problem I am coming across is how would it work in this callback as the row format is supposed to be fetched from the query that was made outside of the query. How am I able to get the row format then?

[NewerthRoleplay]

Ah sorry I was confused about something