MySQL saving system, help. - Printable Version

MySQL saving system, help. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL saving system, help. (/showthread.php?tid=520402)

MySQL saving system, help. - AMouldyLemon - 18.06.2014

EDITED:

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 PlayerCharacter SET cName=%s, 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'", // <----572
            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],);// <----599
            mysql_query(query); // <----600
            
            format(query, sizeof(query), "UPDATE PlayerCharacter SET Clothes1=%d, Clothes2=%d, Clothes3=%d, ClothesUsed=%d, CarLicense=%d, TruckLicense=%d, HouseKey=%d, Business1Key=%d, Business2Key=%d, Faction=%d, FactionRank=%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],);
            /*Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],
            Player[playerid][],*/
            pname);
            mysql_query(query);
            
            
            return true;
        }
    }
    return false;
}

EDIT: New errors

pawn Код:

(572 -- 599) : error 029: invalid expression, assumed zero
(572 -- 599) : error 001: expected token: ",", but found ";"
(600) : error 035: argument type mismatch (argument 1)
(602 -- 610) : error 001: expected token: "]", but found ","
(602 -- 613) : error 001: expected token: ",", but found ";"
(630) : warning 215: expression has no effect
(630) : error 001: expected token: ";", but found ")"
(630) : error 029: invalid expression, assumed zero
(630) : warning 215: expression has no effect
(631) : error 035: argument type mismatch (argument 1)

Re: MySQL saving system, help. - DobbysGamertag - 18.06.2014

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.

Re: MySQL saving system, help. - AMouldyLemon - 18.06.2014

pawn Код:

(572 -- 599) : error 029: invalid expression, assumed zero
MyProject.pwn(572 -- 599) : error 001: expected token: ",", but found ";"
MyProject.pwn(600) : error 035: argument type mismatch (argument 1)
MyProject.pwn(602 -- 610) : error 001: expected token: "]", but found ","
MyProject.pwn(602 -- 613) : error 001: expected token: ",", but found ";"
MyProject.pwn(630) : warning 215: expression has no effect
MyProject.pwn(630) : error 001: expected token: ";", but found ")"
MyProject.pwn(630) : error 029: invalid expression, assumed zero
MyProject.pwn(630) : warning 215: expression has no effect
MyProject.pwn(631) : error 035: argument type mismatch (argument 1)

Re: MySQL saving system, help. - DobbysGamertag - 18.06.2014

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;
}

I cant compile it properly, since i don't have your enum.

If you like, you can PM me your script. I'll sort it that way for you.

Re: MySQL saving system, help. - AMouldyLemon - 18.06.2014

pawn Код:

enum PlayerCharacter
{
    cName[MAX_PLAYER_NAME],
    cOwnerID,
    cID,
    cAdminLevel,
    Float:cX,
    Float:cY,
    Float:cZ,
    Float:cAngle,
    cWorld,
    cInterior,
    cCash,
    cBank,
    cSkin,
    cMask,
    Level,
    SpawnPoint,
    Accent,
    ExperiencePoints,
    Deaths,
    Kills,
    CellPhone,
    CellPhoneNumber,
    CellBattery,
    Job,
    CarKey1,
    CarKey2,
    CarKey3,
    Clothes1,
    Clothes2,
    Clothes3,
    ClothesUsed,
    CarLicense,
    TruckLicense,
    HouseKey,
    Business1Key,
    Business2Key,
    Faction,
    FactionRank,
}
new Character[MAX_PLAYERS][PlayerCharacter];

pawn Код:

forward MasterAccountSave(playerid);
public MasterAccountSave(playerid)
{
    if(AccountExists(playerid))
    {
        if(MasterAccount[playerid][mLoggedIn])
        {
            new query[300]
            mysql_format(0, query, sizeof(query), "UPDATE `Master` (password,email_address,ip_address,super_admin,old_ip) VALUES ('%s', '%s', '%s', '%d', '%s', '%d')", MasterAccount[mPassword], MasterAccount[playerid][mEmailAddress], GetPlayerIPEx(playerid), MasterAccount[playerid][mSuperAdmin], MasterAccount[playerid][mOld_IP], MasterAccount[playerid][mID]);
            mysql_tquery(0, query, "", "");
            
            */
            new query[1024], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE PlayerCharacter SET cName=%s, 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 PlayerCharacter 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],);
            pname);
            mysql_query(query);
            
            
            return true;
        }
    }
    return false;
}

Re: MySQL saving system, help. - AMouldyLemon - 19.06.2014

Help please