[AMouldyLemon]

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!

[RenovanZ]

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.

[AMouldyLemon]

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

[RenovanZ]

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

[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)

[RenovanZ]

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.

[AMouldyLemon]

I love you.

[AMouldyLemon]

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

[RenovanZ]

It wont, cause mysql_query parameter is:

pawn Код:

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

You should place query at the first parameter.

[Konstantinos]

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).