HELP !! My money don't save MYSQL!
#10

Hmm, I did see something wrong with the above code, you're wrapping integers which shouldn't be done.
pawn Код:
script OnAccountSave(playerid)
{
    if(PlayerInfo[playerid][pLogged] == 0) return 1;
    new query[456], final[1028];
    format(query, sizeof(query), "UPDATE `Accounts` SET ");
    strcat(final,query);
    format(query, sizeof(query), "`Level` = %d,",PlayerInfo[playerid][pLevel]);
    strcat(final,query);
    format(query, sizeof(query), "`Sex` = %d,",PlayerInfo[playerid][pSex]);
    strcat(final,query);
    format(query, sizeof(query), "`Skin` = %d,",PlayerInfo[playerid][pSkin]);
    strcat(final,query);
    format(query, sizeof(query), "`Hours` = %d,",PlayerInfo[playerid][pHours]);
    strcat(final,query);
    format(query, sizeof(query), "`Minutes` = %d,",PlayerInfo[playerid][pMinutes]);
    strcat(final,query);
    format(query, sizeof(query), "`Language` = %d,",PlayerInfo[playerid][pLanguage]);
    strcat(final,query);
    format(query, sizeof(query), "`Admin` = %d,",PlayerInfo[playerid][pAdmin]);
    strcat(final,query);
    format(query, sizeof(query), "`Helper` = %d,",PlayerInfo[playerid][pHelper]);
    strcat(final,query);
    format(query, sizeof(query), "`Respect` = %d,",PlayerInfo[playerid][pRespect]);
    strcat(final,query);
    format(query, sizeof(query), "`Money` = %d,",PlayerInfo[playerid][pMoney]);
    strcat(final,query);
    format(query, sizeof(query), "`Bank` = %d,",PlayerInfo[playerid][pBank]);
    strcat(final,query);
    format(query, sizeof(query), "`Age` = %d,",PlayerInfo[playerid][pAge]);
    strcat(final,query);
    format(query, sizeof(query), "`Reports` = %d,",PlayerInfo[playerid][pReports]);
    strcat(final,query);
    format(query, sizeof(query), "`Newbies` = %d,",PlayerInfo[playerid][pNewbies]);
    strcat(final,query);
    format(query, sizeof(query), "`Warn` = %d,",PlayerInfo[playerid][pWarn]);
    strcat(final,query);
    format(query, sizeof(query), "`MuteTime` = %d,",PlayerInfo[playerid][pMuteTime]);
    strcat(final,query);
    format(query, sizeof(query), "`Mute` = %d,",PlayerInfo[playerid][pMute]);
    strcat(final,query);
    format(query, sizeof(query), "`Banned` = %d,",PlayerInfo[playerid][pBanned]);
    strcat(final,query);
    format(query, sizeof(query), "`BanDays` = %d,",PlayerInfo[playerid][pBanDays]);
    strcat(final,query);
    format(query, sizeof(query), "`BannedBy` = '%s',",PlayerInfo[playerid][pBannedBy]);
    strcat(final,query);
    format(query, sizeof(query), "`MarkX` = %f,",PlayerInfo[playerid][pMarkX]);
    strcat(final,query);
    format(query, sizeof(query), "`MarkY` = %f,",PlayerInfo[playerid][pMarkY]);
    strcat(final,query);
    format(query, sizeof(query), "`MarkZ` = %f,",PlayerInfo[playerid][pMarkZ]);
    strcat(final,query);
    format(query, sizeof(query), "`BannedReason` = '%s',",PlayerInfo[playerid][pBannedReason]);
    strcat(final,query);
    format(query, sizeof(query), "`Crashed` = %d,",PlayerInfo[playerid][pCrashed]);
    strcat(final,query);
    format(query, sizeof(query), "`DrivingLicenseA` = %d,",PlayerInfo[playerid][pDrivingLicenseA]);
    strcat(final,query);
    format(query, sizeof(query), "`DrivingLicenseB` = %d,",PlayerInfo[playerid][pDrivingLicenseB]);
    strcat(final,query);
    format(query, sizeof(query), "`DrivingLicenseC` = %d,",PlayerInfo[playerid][pDrivingLicenseC]);
    strcat(final,query);
    format(query, sizeof(query), "`WeaponLicense` = %d,",PlayerInfo[playerid][pWeaponLicense]);
    strcat(final,query);
    format(query, sizeof(query), "`FlyingLicense` = %d,",PlayerInfo[playerid][pFlyingLicense]);
    strcat(final,query);
    format(query, sizeof(query), "`NavigationLicense` = %d,",PlayerInfo[playerid][pNavigationLicense]);
    strcat(final,query);
    format(query, sizeof(query), "`Work` = %d,",PlayerInfo[playerid][pWork]);
    strcat(final,query);
    format(query, sizeof(query), "`AdminJailed` = %d,",PlayerInfo[playerid][pAdminJailed]);
    strcat(final,query);
    format(query, sizeof(query), "`AdminJailedReason` = '%s',",PlayerInfo[playerid][pAdminJailedReason]);
    strcat(final,query);
    format(query, sizeof(query), "`AdminJailedMinutes` = %d,",PlayerInfo[playerid][pAdminJailedMinutes]);
    strcat(final,query);
    format(query, sizeof(query), "`AdminJailedAdmin` = '%s',",PlayerInfo[playerid][pAdminJailedAdmin]);
    strcat(final,query);
    format(query, sizeof(query), "`AlreadyVoted` = '%s',",PlayerInfo[playerid][pAlreadyVoted]);
    strcat(final,query);
    format(query, sizeof(query), "`Tester` = %d,",PlayerInfo[playerid][pTester]);
    strcat(final,query);
    format(query, sizeof(query), "`Recover` = '%s'",PlayerInfo[playerid][pRecover]);
    strcat(final,query);
    format(query, sizeof(query), " WHERE ID = %d", PlayerInfo[playerid][pID]);
    strcat(final,query);
    mysql_format(mysql, final, sizeof(final), "%s", final);
    mysql_query(mysql, final, false);
    return 1;
}
Only strings should be wrapped.
Reply


Messages In This Thread
HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:09
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:13
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:20
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:21
Re: HELP !! My money don't save MYSQL! - by MerryDeer - 22.09.2016, 16:21
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:23
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:33
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:34
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:39
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 18:14

Forum Jump:


Users browsing this thread: 2 Guest(s)