SA-MP Forums Archive
MySQL not fetching. - 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 not fetching. (/showthread.php?tid=465331)


MySQL not fetching. - EliteApple - 21.09.2013

I'm finally using a new MySQL plugin, BlueGs.

And, well, I don't know if I got this right.
pawn Код:
mysql_fetch_field_row("Level", DataString);
    PlayerStats[playerid][pLevel] = strval(DataString);
    SetPlayerScore(playerid, PlayerStats[playerid][pLevel]);
    
    mysql_fetch_field_row("Admin", DataString);
    PlayerStats[playerid][pAdmin] = strval(DataString);
    
    
    mysql_fetch_field_row("Tester", DataString);
    PlayerStats[playerid][pTester] = strval(DataString);
    
    mysql_fetch_field_row("Skin", DataString);
    PlayerStats[playerid][pSkin] = strval(DataString);
    
    mysql_fetch_field_row("Tutorial", DataString);
    PlayerStats[playerid][pTutorial] = strval(DataString);
    
    mysql_fetch_field_row("Cash", DataString);
    PlayerStats[playerid][pCash] = strval(DataString);
    
    mysql_fetch_field_row("Spawn", DataString);
    PlayerStats[playerid][pSpawn] = strval(DataString);
    mysql_free_result();
Everything comes back as 0, when it shouldn't. Ideas?

Re: MySQL not fetching. - Emmet_ - 21.09.2013

You can't use mysql_fetch_field_row without using mysql_retrieve_row to indicate that you're retrieving a value, and you had the parameters switched around.

Try this:

pawn Код:
while (mysql_retrieve_row())
{
    mysql_fetch_field_row(DataString, "Level");
    PlayerStats[playerid][pLevel] = strval(DataString);
    SetPlayerScore(playerid, PlayerStats[playerid][pLevel]);
    
    mysql_fetch_field_row(DataString, "Admin");
    PlayerStats[playerid][pAdmin] = strval(DataString);
    
    mysql_fetch_field_row(DataString, "Tester");
    PlayerStats[playerid][pTester] = strval(DataString);
    
    mysql_fetch_field_row(DataString, "Skin");
    PlayerStats[playerid][pSkin] = strval(DataString);
    
    mysql_fetch_field_row(DataString, "Tutorial");
    PlayerStats[playerid][pTutorial] = strval(DataString);
    
    mysql_fetch_field_row(DataString, "Cash");
    PlayerStats[playerid][pCash] = strval(DataString);
    
    mysql_fetch_field_row(DataString, "Spawn");
    PlayerStats[playerid][pSpawn] = strval(DataString);
}    
mysql_free_result();


Re: MySQL not fetching. - EliteApple - 22.09.2013

Didn't work.