Saving System MySQL
#6

As i notice on this part of code there is no commas
pawn Код:
`Rank` = '%d' \
                                    `Class1Weapon1` = '%d' \
                                    `Class1Weapon2` = '%d' \
                                    `Class1Weapon3` = '%d' \
                                    `Class2Weapon1` = '%d' \
                                    `Class2Weapon2` = '%d' \
                                    `Class2Weapon3` = '%d' \
                                    `Class3Weapon1` = '%d' \
                                    `Class3Weapon2` = '%d' \
                                    `Class3Weapon3` = '%d' \
also ' ' only use it when it is a string not an integer (most people said)
and try increasing string because 256 is not enough. i would say increase it to 500+

Try this code
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    if(pInfo[playerid][pLoggedIn] == 1)
    {
        new Query[556];
        format(Query, sizeof(Query),"UPDATE `Users` SET `IP` = '%s', `Admin` = %d, `PWL` = %d, `SWL` = %d, `TWL` = %d, `XP` = %d, `Kills` = %d, `Deaths` = %d, `Money` = %d, `Score` = %d, `Rank` = %d,\
        `Class1Weapon1` = %d, `Class1Weapon2` = %d, `Class1Weapon3` = %d, `Class2Weapon1` = %d, `Class2Weapon2` = %d, `Class2Weapon3` = %d, `Class3Weapon1` = %d, `Class3Weapon2` = %d, `Class3Weapon3` = %d\
        WHERE `UserName` = '%s'"
,
        pIP[playerid],pInfo[playerid][pAdmin],PrimaryWeaponLevel[playerid], SecondaryWeaponLevel[playerid],ThirdaryWeaponLevel[playerid],pInfo[playerid][pXP],pInfo[playerid][pKills],pInfo[playerid][pDeaths],
        pInfo[playerid][pMoney], pInfo[playerid][pScore],pInfo[playerid][pRank],ClassInfo[playerid][0][Weapon1], ClassInfo[playerid][0][Weapon2],ClassInfo[playerid][0][Weapon3],ClassInfo[playerid][1][Weapon1],
        ClassInfo[playerid][1][Weapon2],ClassInfo[playerid][1][Weapon3],ClassInfo[playerid][2][Weapon1],ClassInfo[playerid][2][Weapon2],ClassInfo[playerid][2][Weapon3],
        pName[playerid]);
        mysql_query(Query);
    }
    return 1;
}
Reply


Messages In This Thread
Saving System MySQL - by Sanady - 04.04.2013, 12:07
Re: Saving System MySQL - by Sanady - 04.04.2013, 12:16
Re: Saving System MySQL - by 3ventic - 04.04.2013, 12:57
Re: Saving System MySQL - by Sanady - 04.04.2013, 18:40
Re: Saving System MySQL - by LarzI - 04.04.2013, 18:48
Re: Saving System MySQL - by Patrick - 04.04.2013, 19:00
Re: Saving System MySQL - by LarzI - 05.04.2013, 08:02
Re: Saving System MySQL - by Sanady - 05.04.2013, 11:38
Re: Saving System MySQL - by LarzI - 05.04.2013, 13:09
Re: Saving System MySQL - by Sanady - 05.04.2013, 14:00

Forum Jump:


Users browsing this thread: 1 Guest(s)