MySQL Save Function. - Printable Version

MySQL Save Function. - 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 Save Function. (/showthread.php?tid=520858)

MySQL Save Function. - AMouldyLemon - 20.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[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][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],);
            pname);
            mysql_query(query);
            
            
            return true;
        }
    }
    return false;
}

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)

Help and an explanation why would be nice. Thank you!

Re: MySQL Save Function. - RenovanZ - 20.06.2014

pawn Код:

Character[playerid][CarKey3],);// <----599
            mysql_query(query); // <----600

Should be:

pawn Код:

Character[playerid][CarKey3]);// <----599
            mysql_query(query); // <----600

You don't need "," anymore if you have ")" after it.

Re: MySQL Save Function. - AMouldyLemon - 20.06.2014

pawn Код:

MyProject.pwn(572 -- 599) : error 029: invalid expression, assumed zero
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 029: invalid expression, assumed zero
MyProject.pwn(602 -- 630) : error 001: expected token: ",", but found "-identifier-"
MyProject.pwn(602 -- 630) : fatal error 107: too many error messages on one line

Re: MySQL Save Function. - RenovanZ - 20.06.2014

pawn Код:

Character[playerid][FactionRank],);
            pname);

This too, should be:

pawn Код:

Character[playerid][FactionRank],
            pname);

pawn Код:

Character[playerid][FactionRank],);
            pname);

Should be:

pawn Код:

Character[playerid][FactionRank],
            pname);

Re: MySQL Save Function. - AMouldyLemon - 20.06.2014

No..

pawn Код:

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

Re: MySQL Save Function. - RenovanZ - 20.06.2014

Quote:

Originally Posted by AMouldyLemon

No..

pawn Код:

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

My bad, take a look on my code, I have edited it.

Re: MySQL Save Function. - AMouldyLemon - 20.06.2014

I love you.

Re: MySQL Save Function. - AMouldyLemon - 20.06.2014

Also, would mysql_query(0, query); work?

Re: MySQL Save Function. - RenovanZ - 20.06.2014

It wont, cause mysql_query parameter is:

pawn Код:

mysql_query(query[], resultid, extraid, connectionHandle)

You should place query at the first parameter.

Re: MySQL Save Function. - Konstantinos - 20.06.2014

It actually depends on the version of the mysql plugin. If the version is R5, R6, then use the above but if the version is from the latest ones, then connection handle is first (and it's 1 by default not 0).