[iArko]

When ever someone leaves the server or makes there accont save the gamemode crashes, Does nayone see anything wrong with this.

pawn Код:

format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerBanned = '%d', playerSeconds = '%d', playerSkin = '%d', playerMoney = '%d', playerBankMoney = '%d'", playerVariables[playerid][pBanned], playerVariables[playerid][pSeconds], playerVariables[playerid][pSkin], playerVariables[playerid][pMoney], playerVariables[playerid][pBankMoney]);

        format(saveQuery, sizeof(saveQuery), "%s, playerInterior = '%d', playerVirtualWorld = '%d', playerHealth = '%f', playerArmour = '%f', playerPosX = '%f', playerPosY = '%f', playerPosZ = '%f'", saveQuery, playerVariables[playerid][pInterior], playerVariables[playerid][pVirtualWorld], playerVariables[playerid][pHealth], playerVariables[playerid][pArmour], playerVariables[playerid][pPos][0], playerVariables[playerid][pPos][1], playerVariables[playerid][pPos][2]);

        format(saveQuery, sizeof(saveQuery), "%s, playerAccent = '%s', playerAdminLevel = '%d', playerJob = '%d', playerWeapon0 = '%d', playerWeapon1 = '%d', playerWeapon2 = '%d', playerWeapon3 = '%d'", saveQuery, playerVariables[playerid][pAccent], playerVariables[playerid][pAdminLevel], playerVariables[playerid][pJob], playerVariables[playerid][pWeapons][0], playerVariables[playerid][pWeapons][1], playerVariables[playerid][pWeapons][2], playerVariables[playerid][pWeapons][3]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWeapon4 = '%d', playerWeapon5 = '%d', playerWeapon6 = '%d', playerWeapon7 = '%d', playerWeapon8 = '%d', playerWeapon9 = '%d', playerWeapon10 = '%d'", saveQuery, playerVariables[playerid][pWeapons][4], playerVariables[playerid][pWeapons][5], playerVariables[playerid][pWeapons][6], playerVariables[playerid][pWeapons][7], playerVariables[playerid][pWeapons][8], playerVariables[playerid][pWeapons][9], playerVariables[playerid][pWeapons][10]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWeapon11 = '%d', playerWeapon12 = '%d', playerJobSkill1 = '%d', playerJobSkill2 = '%d', playerMaterials = '%d', playerHours = '%d', playerLevel = '%d'", saveQuery, playerVariables[playerid][pWeapons][11], playerVariables[playerid][pWeapons][12], playerVariables[playerid][pJobSkill][0], playerVariables[playerid][pJobSkill][1], playerVariables[playerid][pMaterials], playerVariables[playerid][pPlayingHours], playerVariables[playerid][pLevel]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWarning1 = '%s', playerWarning2 = '%s', playerWarning3 = '%s', playerHospitalized = '%d', playerFirstLogin = '%d', playerAdminName = '%s', playerPrisonTime = '%d', playerPrisonID = '%d', playerPhoneNumber = '%d'", saveQuery, playerVariables[playerid][pWarning1], playerVariables[playerid][pWarning2], playerVariables[playerid][pWarning3], playerVariables[playerid][pHospitalized], playerVariables[playerid][pFirstLogin], playerVariables[playerid][pAdminName],
        playerVariables[playerid][pPrisonTime], playerVariables[playerid][pPrisonID], playerVariables[playerid][pPhoneNumber]);

        format(saveQuery, sizeof(saveQuery), "%s, playerCarPaintJob = '%d', playerCarLock = '%d', playerStatus = '%d', playerGender = '%d', playerFightStyle = '%d', playerCarWeapon1 = '%d', playerCarWeapon2 = '%d', playerCarWeapon3 = '%d', playerCarWeapon4 = '%d', playerCarWeapon5 = '%d', playerCarLicensePlate = '%s'", saveQuery, playerVariables[playerid][pCarPaintjob], playerVariables[playerid][pCarLock],
        playerVariables[playerid][pStatus], playerVariables[playerid][pGender], playerVariables[playerid][pFightStyle], playerVariables[playerid][pCarWeapons][0], playerVariables[playerid][pCarWeapons][1], playerVariables[playerid][pCarWeapons][2], playerVariables[playerid][pCarWeapons][3], playerVariables[playerid][pCarWeapons][4], playerVariables[playerid][pCarLicensePlate]);

        format(saveQuery, sizeof(saveQuery), "%s, playerCarModel = '%d', playerCarColour1 = '%d', playerCarColour2 = '%d', playerCarPosX = '%f', playerCarPosY = '%f', playerCarPosZ = '%f', playerCarPosZAngle = '%f', playerCarMod0 = '%d', playerCarMod1 = '%d', playerCarMod2 = '%d', playerCarMod3 = '%d', playerCarMod4 = '%d', playerCarMod5 = '%d', playerCarMod6 = '%d'", saveQuery, playerVariables[playerid][pCarModel], playerVariables[playerid][pCarColour][0], playerVariables[playerid][pCarColour][1],
        playerVariables[playerid][pCarPos][0], playerVariables[playerid][pCarPos][1], playerVariables[playerid][pCarPos][2], playerVariables[playerid][pCarPos][3], playerVariables[playerid][pCarMods][0], playerVariables[playerid][pCarMods][1], playerVariables[playerid][pCarMods][2], playerVariables[playerid][pCarMods][3], playerVariables[playerid][pCarMods][4], playerVariables[playerid][pCarMods][5], playerVariables[playerid][pCarMods][6]);

        format(saveQuery, sizeof(saveQuery), "%s, playerCarTrunk1 = '%d', playerCarTrunk2 = '%d', playerWalkieTalkie = '%d'", saveQuery, playerVariables[playerid][pCarTrunk][0], playerVariables[playerid][pCarTrunk][1], playerVariables[playerid][pWalkieTalkie]);

        format(saveQuery, sizeof(saveQuery), "%s,playerPhoneBook=%d,playerGroup=%d,playerGroupRank=%d,playerIP=%s,playerScrapCarTimeout=%d,playerHotwireTime=%d,playerRope=%d,playerToolKit=%d,playerScrewdriver=%d, playerMask=%d,playerVehicleParts=%d, playerGunLicense=%d,playerAdminDuty=%d,playerCrimes=%d,playerArrests=%d,playerWarrants=%d,playerAge=%d,playerCarMod7=%d,playerCarMod8=%d,playerCarMod9=%d,playerCarMod10=%d',playerCarMod11=%d,playerCarMod12=%d,playerBoomBox=%d", saveQuery,
        playerVariables[playerid][pPhoneBook], playerVariables[playerid][pGroup], playerVariables[playerid][pGroupRank], playerVariables[playerid][pConnectionIP], playerVariables[playerid][pScrapCarTimeout], playerVariables[playerid][pHotwireTime], playerVariables[playerid][pRope], playerVariables[playerid][pToolKit], playerVariables[playerid][pScrewDriver], playerVariables[playerid][pVehicleParts], playerVariables[playerid][pMask], playerVariables[playerid][pGunLicense], playerVariables[playerid][pAdminDuty],
        playerVariables[playerid][pCrimes], playerVariables[playerid][pArrests], playerVariables[playerid][pWarrants], playerVariables[playerid][pAge], playerVariables[playerid][pCarMods][7], playerVariables[playerid][pCarMods][8], playerVariables[playerid][pCarMods][9], playerVariables[playerid][pCarMods][10], playerVariables[playerid][pCarMods][11], playerVariables[playerid][pCarMods][12], playerVariables[playerid][pBoomBox]);
        
        format(saveQuery, sizeof(saveQuery), "%s, playerCarModel2 = '%d', playerCar2Colour1 = '%d', playerCar2Colour2 = '%d', playerCar2PosX = '%f', playerCar2PosY = '%f', playerCar2PosZ = '%f', playerCar2PosZAngle = '%f', playerCar2Mod0 = '%d', playerCar2Mod1 = '%d', playerCar2Mod2 = '%d', playerCar2Mod3 = '%d', playerCar2Mod4 = '%d', playerCar2Mod5 = '%d', playerCar2Mod6 = '%d',playerCar2Mod10 = '%d', playerCar2Mod11 = '%d', playerCar2Mod12 = '%d', playerCar2PaintJob = '%d', playerCar2Lock = '%d'",
        saveQuery, playerVariables[playerid][pCarModel2], playerVariables[playerid][pCar2Colour][0],  playerVariables[playerid][pCar2Colour][1], playerVariables[playerid][pCar2Pos][0], playerVariables[playerid][pCar2Pos][1], playerVariables[playerid][pCar2Pos][2], playerVariables[playerid][pCar2Pos][3], playerVariables[playerid][pCar2Mods][0], playerVariables[playerid][pCar2Mods][1], playerVariables[playerid][pCar2Mods][2], playerVariables[playerid][pCar2Mods][3], playerVariables[playerid][pCar2Mods][4], 
        playerVariables[playerid][pCar2Mods][5], playerVariables[playerid][pCar2Mods][6], playerVariables[playerid][pCar2Mods][10], playerVariables[playerid][pCar2Mods][11], playerVariables[playerid][pCar2Mods][12], playerVariables[playerid][pCar2Paintjob], playerVariables[playerid][pCar2Lock]);

[Mean]

Crashdetect plugin.

https://sampforum.blast.hk/showthread.php?tid=262796

[iArko]

Quote:

Originally Posted by Mean Crashdetect plugin. https://sampforum.blast.hk/showthread.php?tid=262796

Doesnt help my problem that much :/

[Scenario]

Quote:

Originally Posted by iArko Doesnt help my problem that much :/

It isn't a solution... it's supposed to tell you WHERE the crash is being caused.

OT: You aren't specifying a WHERE clause in your query, so the information doesn't know where it's supposed to be updating. So, you should add something like this to the final query...

pawn Код:

WHERE `playerName` = '%s'

[iArko]

Quote:

Originally Posted by RealCop228 It isn't a solution... it's supposed to tell you WHERE the crash is being caused. OT: You aren't specifying a WHERE clause in your query, so the information doesn't know where it's supposed to be updating. So, you should add something like this to the final query... pawn Код: WHERE `playerName` = '%s'

Thanks

[iArko]

errorid: 1064 | error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',playerScrapCarTimeout=49,playerHotwireTime=0,pl ayerRope=0,playerToolKit=0,play' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE playeraccounts SET playerPhoneBook=85,playerGroup=0,playerGroupRank=1 ,playerIP=,playerScrapCarTimeout=49,playerHotwire Time=0,playerRope=0,playerToolKit=0,playerScrewdri ver=1, playerMask=1,playerVehicleParts=-1, playerGunLicense=15,playerAdminDuty=1,playerCrimes =0,playerArrests=0,playerWarrants=0,playerAge=0,pl ayerCarMod7=1991,playerCarMod8=0,playerCarMod9=0,p layerCarMod10=0',playerCarMod11=0,playerCarMod12=0 ,playerBoomBox=0, playerCarModel2 = '0', playerCar2Colour1 = '-1', playerCar2Colour2 = '-1', playerCar2PosX = '0.000000', playerCar2PosY = '0.000000', playerCar2PosZ = '0.000000', playerCar2PosZAngle = '0.000000', playerCar2Mod0 = '0', playerCar2Mod1 = '0', playerCar2Mod2 = '0', playerCar2Mod3 = '0', playerCar2Mod4 = '0', playerCar2Mod5 = '0', playerCar2Mod6 = '0',playerCar2Mod10 = '0', playerCar2Mod11 = '0', playerCar2Mod12 = '0', playerCar2PaintJob = '0', playerCar2Lock = '0', playerAdminPIN = 4917 WHERE playerID = '1'

Thats the only thing that the plugin said

[Scenario]

Okay, it's caused by these: ' ' '

pawn Код:

'%d'

Doing that in the SQL query will return an error. Remove them, they aren't necessary unless it's for a string. (i.e. '%s')

[iArko]

Quote:

Originally Posted by RealCop228 It isn't a solution... it's supposed to tell you WHERE the crash is being caused. OT: You aren't specifying a WHERE clause in your query, so the information doesn't know where it's supposed to be updating. So, you should add something like this to the final query... pawn Код: WHERE `playerName` = '%s'

Quote:

Originally Posted by RealCop228 Okay, it's caused by these: ' ' ' pawn Код: '%d' Doing that in the SQL query will return an error. Remove them, they aren't necessary unless it's for a string. (i.e. '%s')

Ok thanks for the help man.