[EliteApple]

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?

[Emmet_]

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();

[EliteApple]

Didn't work.