[Ryz]

i am using mysql saving system but
Money and score not saving

pawn Код:

stock MySQL_Login(playerid)
{
    new Query[1000];
    mysql_real_escape_string(PlayerInfo[playerid][Nick], PlayerInfo[playerid][Nick]);
    format(Query, sizeof(Query), "SELECT * FROM `playerdata` WHERE `nick` COLLATE latin1_general_cs = '%s' LIMIT 1", PlayerInfo[playerid][Nick]);
    mysql_query(Query);
    mysql_store_result();
    while(mysql_fetch_row(Query))
    {
        mysql_fetch_int("id", PlayerInfo[playerid][ID]);
        mysql_fetch_int("admin", PlayerInfo[playerid][Level]);
        mysql_fetch_int("score", PlayerInfo[playerid][pScore]);
        SetPlayerScore(playerid, PlayerInfo[playerid][pScore]);
        mysql_fetch_int("money", PlayerInfo[playerid][Money]);
        GivePlayerMoney(playerid, PlayerInfo[playerid][Money]);
        mysql_fetch_int("kills", PlayerInfo[playerid][Kills]);
        mysql_fetch_int("deaths", PlayerInfo[playerid][Deaths]);
        mysql_fetch_int("banned", PlayerInfo[playerid][banned]);
        mysql_fetch_int("Donor", PlayerInfo[playerid][dRank]);
        mysql_fetch_int("Pilot", PlayerInfo[playerid][pPilot]);
        mysql_fetch_int("NavyPilot", PlayerInfo[playerid][jPilot]);
        mysql_fetch_int("Helper", PlayerInfo[playerid][Helper]);
    }
    mysql_free_result();
    PlayerInfo[playerid][LoggedIn] = 1; 
    return 1;
}

[UnknownGamer]

Mate, this is not MYSQL Saving. This is MYSQL Loading... Look at the query line...

"SELECT * FROM BLALALALALAL WHERE id = dbID" for example.

MySQL saving is: "UPDATE samp_users SET name='lol', hp='0' WHERE id = pdbID"

[Ryz]

Opps my bad

I have stock save player, here is he

pawn Код:

SavePlayer(playerid)
{
    if(PlayerInfo[playerid][LoggedIn] == 1)
    {
        new Query[1000];
        format(Query, 1000, "UPDATE `playerdata` SET `admin` = '%d', `score` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d', `banned` = '%d', `Donor` = '%d', `Pilot` = '%d', `NavyPilot` = '%d', `Helper` = '%d' WHERE `id` = '%d' LIMIT 1",
        PlayerInfo[playerid][Level],
        PlayerInfo[playerid][pScore],
        PlayerInfo[playerid][Money],
        PlayerInfo[playerid][Kills],
        PlayerInfo[playerid][Deaths],
        PlayerInfo[playerid][banned],
        PlayerInfo[playerid][dRank],
        PlayerInfo[playerid][pPilot],
        PlayerInfo[playerid][jPilot],
        PlayerInfo[playerid][Helper],
        PlayerInfo[playerid][ID]);
        mysql_query(Query);
    }
}

[UnknownGamer]

Quote:

Originally Posted by Ryz Opps my bad I have stock save player, here is he pawn Код: SavePlayer(playerid) {     if(PlayerInfo[playerid][LoggedIn] == 1)     {         new Query[1000];         format(Query, 1000, "UPDATE `playerdata` SET `admin` = '%d', `score` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d', `banned` = '%d', `Donor` = '%d', `Pilot` = '%d', `NavyPilot` = '%d', `Helper` = '%d' WHERE `id` = '%d' LIMIT 1",         PlayerInfo[playerid][Level],         PlayerInfo[playerid][pScore],         PlayerInfo[playerid][Money],         PlayerInfo[playerid][Kills],         PlayerInfo[playerid][Deaths],         PlayerInfo[playerid][banned],         PlayerInfo[playerid][dRank],         PlayerInfo[playerid][pPilot],         PlayerInfo[playerid][jPilot],         PlayerInfo[playerid][Helper],         PlayerInfo[playerid][ID]);         mysql_query(Query);     } }

Do you have a MySQL Log?

[Ryz]

Quote:

Do you have a MySQL Log?

Fixed after after changing Money to pMoney everywhere in gamemode!