SA-MP Forums Archive
MySQL retrieving - 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: MySQL retrieving (/showthread.php?tid=469069)


MySQL retrieving - EliteApple - 11.10.2013

I started using BlueGs R5 plugin and began making a script but..

I don't know. It's just not right.

pawn Код:
mysql_debug(1);
    mysql_retrieve_row(true);
    if(mysql_retrieve_row())
    {
        mysql_fetch_field_row(DataString, "Skin");
        PlayerStats[playerid][pSkin] = strval(DataString);
        mysql_retrieve_row(false);
        printf("Skin: %d",PlayerStats[playerid][pSkin]);
        gPlayerLogged[playerid] = 1;
        mysql_debug(0);
    }
    mysql_free_result();

I know this is wrong, can someone tell me what though?

Re: MySQL retrieving - Jefff - 11.10.2013

pawn Код:
mysql_debug(1);
// mysql_query(...);
// mysql_store_result();
if(mysql_fetch_row(DataString))
{
    PlayerStats[playerid][pSkin] = strval(DataString);
    printf("Skin: %d",PlayerStats[playerid][pSkin]);
    gPlayerLogged[playerid] = 1;
}
mysql_free_result();
mysql_debug(0);