MySQL Error
#9

pawn Код:
stock MySQL_Login(playerid)
{
    GivePlayerMoney(playerid,16000);
    new query[128], pname[24], savingstring[20];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT * FROM `PlayerData` WHERE `Name` = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row(query,"|"))
    {

        mysql_fetch_field("Score", savingstring); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field("PlayerLevel", savingstring); APlayerData[playerid][PlayerLevel] = strval(savingstring);
        //mysql_fetch_field("OFWarns", savingstring); APlayerData[playerid][OFWarns] = strval(savingstring);

    }
    mysql_free_result();
    return 1;
}
I've commented out the OFWarns field fetching since I haven't seen it in your screen, if you're sure that field is there just uncomment the line.
Reply


Messages In This Thread
MySQL Error - by SomebodyAndMe - 31.05.2012, 13:43
Re: MySQL Error - by mati233 - 31.05.2012, 13:56
Re: MySQL Error - by SomebodyAndMe - 31.05.2012, 13:59
Re: MySQL Error - by mati233 - 31.05.2012, 14:00
Re: MySQL Error - by SomebodyAndMe - 31.05.2012, 14:01
Re: MySQL Error - by mati233 - 31.05.2012, 14:03
Re: MySQL Error - by SomebodyAndMe - 31.05.2012, 14:05
Re: MySQL Error - by mati233 - 31.05.2012, 14:16
Re: MySQL Error - by pointer* - 31.05.2012, 14:20
Re: MySQL Error - by SomebodyAndMe - 31.05.2012, 14:24

Forum Jump:


Users browsing this thread: 1 Guest(s)