Using mysql_fetch_row_format in a threaded query

Using mysql_fetch_row_format in a threaded query - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Using mysql_fetch_row_format in a threaded query (/showthread.php?tid=388756)

Using mysql_fetch_row_format in a threaded query - NewerthRoleplay - 30.10.2012

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?

Re: Using mysql_fetch_row_format in a threaded query - NewerthRoleplay - 30.10.2012

Ah sorry I was confused about something