SQL Help
#3

You forgot the WHERE clause in your SELECT query, also you are trying to retrieve the row BEFORE the query and you are not storing the result

pawn Код:
stock LoadPlayerInfo(iPlayer)
{
    new
        Query[700];

    format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s';", pName(iPlayer));
    mysql_query(Query);

    mysql_store_result();

    if(mysql_fetch_row(Query))
    {
        sscanf(Query, "e<p<|>s[24]s[35]dddddfffddd>", Player[iPlayer]); // Remember to update this if you add more info...
        GivePlayerMoney(iPlayer, Player[iPlayer][pMoney]);
        SetPlayerScore(iPlayer, Player[iPlayer][pLevel]);
        SetSpawnInfo(iPlayer, 0, Player[iPlayer][pSkin], Player[iPlayer][pLastX], Player[iPlayer][pLastY], Player[iPlayer][pLastZ], 90, 0, 0, 0, 0, 0, 0);
    }

    mysql_free_result();
    return 1;
}
And here there is no need of using mysql_free_result since you don't store anything

pawn Код:
stock SavePInfo(playerid)
{
    if(GetPVarInt(playerid, "LoggedIN") == 1)
    {
        new Float:x, Float:y, Float: z;
        GetPlayerPos(playerid, x, y, z);
        new
            Query[600];

        format(Query, sizeof(Query), "UPDATE `playerinfo` SET `kills` = %d, `deaths` = %d, `money` = %d, `AdminLevel` = %d, `Skin` = %d, `Last Pos X` = %f, `Last Pos Y` = %f, `Last Pos Z` = %f, `Interior` = %d, `DonatorLevel` = %d, `Level` = %d WHERE `user` = '%s'",

        Player[playerid][pKills],
        Player[playerid][pDeaths],
        GetPlayerMoney(playerid),
        Player[playerid][pAdminLevel],
        GetPlayerSkin(playerid),
        x,
        y,
        z,
        GetPlayerInterior(playerid),
        Player[playerid][pDonatorLevel],
        GetPlayerScore(playerid),
        pName(playerid));

        mysql_query(Query);
       
        return 1;
    }
    else return 0;
}
Reply


Messages In This Thread
SQL Help - by iGetty - 11.01.2012, 15:09
Re: SQL Help - by iGetty - 13.01.2012, 18:23
Respuesta: SQL Help - by OPremium - 13.01.2012, 18:37
Re: SQL Help - by iGetty - 13.01.2012, 19:14

Forum Jump:


Users browsing this thread: 1 Guest(s)