MySQL saving system, help.
#2

You're forgetting

);

after each format();

pawn Код:
forward MasterAccountSave(playerid);
public MasterAccountSave(playerid)
{
    if(AccountExists(playerid))
    {
        if(MasterAccount[playerid][mLoggedIn])
        {
            new query[1024], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE MasterAccount SET cName=%d, cOwnerID=%d, Level=%d, cAdminLevel=%d, cCash=%d, cBank=%d, cMask=%d, ExperiencePoints=%d, SpawnPoint=%d, CellPhone=%d, CellPhoneNumber=%d, Accent='%s', CellBattery=%d, Job=%d, cID=%d, Deaths=%d, Kills=%d, CarKey1=%d, CarKey2=%d, CarKey3=%d WHERE Username='%s'",
            Character[playerid][cName],
            Character[playerid][cOwnerID],
            Character[playerid][cID],
            Character[playerid][cAdminLevel],
/*          Character[playerid][Float:cX],
            Character[playerid][Float:cY],
            Character[playerid][Float:cZ],
            Character[playerid][Float:cAngle],
            Character[playerid][cWorld],
            Character[playerid][cInterior],*/

            Character[playerid][cCash],
            Character[playerid][cBank],
            Character[playerid][cSkin],
            Character[playerid][cMask],
            Character[playerid][Level],
            Character[playerid][SpawnPoint],
            Character[playerid][Accent],
            Character[playerid][ExperiencePoints],
            Character[playerid][Deaths],
            Character[playerid][Kills],
            Character[playerid][CellPhone],
            Character[playerid][CellPhoneNumber],
            Character[playerid][CellBattery],
            Character[playerid][Job],
            Character[playerid][CarKey1],
            Character[playerid][CarKey2],
            Character[playerid][CarKey3]);
            mysql_query(query);
           
            format(query, sizeof(query),"UPDATE Accounts SET Money=%d, BankMoney=%d, Level=%d, AdminLevel=%d, Faction=%d, FactionRank=%d, RegistrationStep=%d, BirthDay=%d, BirthMonth=%d, BirthYear=%d, SpawnPoint=%d, TutorialComplete=%d, HelperLevel=%d, Accent='%s', MinutesPlayed=%d, AchievementPoints=%d, ExperiencePoints=%d, DonatorLevel=%d, Deaths=%d, Kills=%d, Clothes1=%d, Clothes2=%d, Clothes3=%d, ClothesUsed=%d, CarLicense=%d, HouseKey=%d, Business1Key=%d WHERE Username='%s'",
            Character[playerid][Clothes1],
            Character[playerid][Clothes2],
            Character[playerid][Clothes3],
            Character[playerid][ClothesUsed],
            Character[playerid][CarLicense],
            Character[playerid][TruckLicense],
            Character[playerid][HouseKey],
            Character[playerid][Business1Key,],
            Character[playerid][Business2Key],
            Character[playerid][Faction],
            Character[playerid][FactionRank]);
            mysql_query(query);
           
           
            return true;
        }
    }
    return false;
}
Give that a go.
Reply


Messages In This Thread
MySQL saving system, help. - by AMouldyLemon - 18.06.2014, 19:38
Re: MySQL saving system, help. - by DobbysGamertag - 18.06.2014, 20:00
Re: MySQL saving system, help. - by AMouldyLemon - 18.06.2014, 20:04
Re: MySQL saving system, help. - by DobbysGamertag - 18.06.2014, 20:11
Re: MySQL saving system, help. - by AMouldyLemon - 18.06.2014, 21:17
Re: MySQL saving system, help. - by AMouldyLemon - 19.06.2014, 14:26

Forum Jump:


Users browsing this thread: 1 Guest(s)