error:mysql_store_result strickenkid plugin

error:mysql_store_result strickenkid plugin - 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: error:mysql_store_result strickenkid plugin (/showthread.php?tid=391508)

error:mysql_store_result strickenkid plugin - [SPD]TerminatorPL - 10.11.2012

Hi, I have error when i load data with strickenkid plugin

Error log:
[MySQL] Error <0>: Funtion: mysql_store_result called when no result stored.

Pawn Code:

Код:

    stock MySQL_Login(playerid)
    {
        new query[512];
        format(query, sizeof(query), "SELECT * FROM `spd_players` WHERE `name` = '%s'", Nick(playerid));
        mysql_query(query);
        mysql_store_result();
        while(mysql_fetch_row(query, "|"))
    	{
            sscanf(query, "p<|>ds[25]s[33]s[5]ddddddddddddddddddfff",
            PlayerInfo[playerid][pUid],
            PlayerInfo[playerid][pNick],
            PlayerInfo[playerid][pHaslo],
            PlayerInfo[playerid][pSalt],
            PlayerInfo[playerid][pAdmin],
            PlayerInfo[playerid][pLider],
            PlayerInfo[playerid][pFrakcja],
            PlayerInfo[playerid][pDj],
            PlayerInfo[playerid][pMute],
            PlayerInfo[playerid][pWarny],
            PlayerInfo[playerid][pJail],
            PlayerInfo[playerid][pScigany],
            PlayerInfo[playerid][pPunkty],
            PlayerInfo[playerid][pWizyty],
            PlayerInfo[playerid][pCzas],
            PlayerInfo[playerid][pPrawko],
            PlayerInfo[playerid][pToll],
            PlayerInfo[playerid][pScore],
            PlayerInfo[playerid][pKasa],
            PlayerInfo[playerid][pBank],
            PlayerInfo[playerid][pPojazdy],
            PlayerInfo[playerid][pDomy],
            PlayerInfo[playerid][gX],
            PlayerInfo[playerid][gY],
            PlayerInfo[playerid][gZ]);
      	}
        mysql_free_result();
        return 1;
    }

Re: error:mysql_store_result strickenkid plugin - Jarnu - 10.11.2012

You are not storing any result here.
remove following:

pawn Код:

mysql_store_result();

Re: error:mysql_store_result strickenkid plugin - [SPD]TerminatorPL - 10.11.2012

Quote:

Originally Posted by Jarnu

You are not storing any result here.
remove following:

pawn Код:

mysql_store_result();

When I remove this code the data do not load

.

Edit: all right thanks
close this topic