25.04.2014, 13:53
savePlayerData(playerid); This running in OnPlayerDisconnect
Full Code
This mysql_query
Full Code
Код:
[20:57:42] ID[42] XXXX Start Save [20:57:42] ID[42] XXXX Variable Save [20:57:42] ID[42] XXXX Update 1 [20:57:42] ID[42] XXXX Update 2 [20:57:42] [debug] Server crashed while executing tolrp.amx [20:57:42] [debug] AMX backtrace: [20:57:42] [debug] #0 native mysql_query () [005575d0] from mysql.DLL [20:57:42] [debug] #1 000ce85c in ?? (0x0000002a) from tolrp.amx [20:57:42] [debug] #2 000d80e4 in public SSCANF_OnPlayerDisconnect (0x0000002a, 0x00000001) from tolrp.amx [20:57:42] [debug] #3 native CallLocalFunction () [00472ad0] from samp-server.exe [20:57:42] [debug] #4 0000ae50 in public Streamer_OnPlayerDisconnect (0x0000002a, 0x00000001) from tolrp.amx [20:57:42] [debug] #5 00002194 in public Itter_OnPlayerDisconnect (0x0000002a, 0x00000001) from tolrp.amx [20:57:42] [debug] #6 00001c4c in public OnPlayerDisconnect (0x0000002a, 0x00000001) from tolrp.amx [20:57:42] [debug] Native backtrace: [20:57:42] [debug] #0 0284ea1d in ?? () from LIBMYSQL.dll
Код:
stock savePlayerData(const playerid)
{
if(PlayerInfo[playerid][pStatus] >= 1 || PlayerInfo[playerid][pStatus] == -1) {
printf("ID[%d] %s Start Save", playerid,RPN(playerid));
new
saveQuery[3500];
new TableID = PlayerInfo[playerid][pInternalID];
#if defined DEBUG
print("[debug] savePlayerData Step 1");
#endif
if(PlayerInfo[playerid][pStatus] == -1) PlayerInfo[playerid][pStatus] = 0;
if(PlayerInfo[playerid][pCarModel] >= 1 && doesVehicleExist(PlayerInfo[playerid][pCarID]))
{
GetVehiclePos(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][pCarPos][0], PlayerInfo[playerid][pCarPos][1], PlayerInfo[playerid][pCarPos][2]);
GetVehicleZAngle(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][pCarPos][3]);
for(new i = 0; i < 13; i++) {
PlayerInfo[playerid][pCarMods][i] = GetVehicleComponentInSlot(PlayerInfo[playerid][pCarID], i);
}
PlayerInfo[playerid][pCarFuel] = Fuel[PlayerInfo[playerid][pCarID]];
GetVehicleHealth(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][CarHealth][0]);
GetVehiclePanelsDamageStatus(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][PFrontLeft][0], PlayerInfo[playerid][PFrontRight][0], PlayerInfo[playerid][PRearLeft][0], PlayerInfo[playerid][PRearRight][0], PlayerInfo[playerid][PWindShield][0], PlayerInfo[playerid][PFrontBumper][0], PlayerInfo[playerid][PRearBumper][0]);
GetVehicleDoorsDamageStatus(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][DBonnet][0], PlayerInfo[playerid][DBoot][0], PlayerInfo[playerid][DFrontLeft][0], PlayerInfo[playerid][DFrontRight][0], PlayerInfo[playerid][DRearLeft][0], PlayerInfo[playerid][DRearRight][0]);
GetVehicleLightsDamageStatus(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][LFirst][0], PlayerInfo[playerid][LSecond][0], PlayerInfo[playerid][LThird][0], PlayerInfo[playerid][LFourth][0]);
GetVehicleTiresDamageStatus(PlayerInfo[playerid][pCarID], PlayerInfo[playerid][TFrontLeft][0], PlayerInfo[playerid][TFrontRight][0], PlayerInfo[playerid][TRearLeft][0], PlayerInfo[playerid][TRearRight][0]);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vPFrontLeft = '%d', vPFrontRight = '%d', vPRearLeft = '%d', vPRearRight = '%d', vPWindShield = '%d', vPFrontBumper = '%d', vPRearBumper = '%d', vDBonnet = '%d', vDBoot = '%d', vDFrontLeft = '%d', vDFrontRight = '%d', vDRearLeft = '%d', vDRearRight = '%d' WHERE playerID = '%d'",
PlayerInfo[playerid][PFrontLeft][0], PlayerInfo[playerid][PFrontRight][0], PlayerInfo[playerid][PRearLeft][0], PlayerInfo[playerid][PRearRight][0], PlayerInfo[playerid][PWindShield][0],
PlayerInfo[playerid][PFrontBumper][0], PlayerInfo[playerid][PRearBumper][0], PlayerInfo[playerid][DBonnet][0], PlayerInfo[playerid][DBoot][0], PlayerInfo[playerid][DFrontLeft][0], PlayerInfo[playerid][DFrontRight][0], PlayerInfo[playerid][DRearLeft][0], PlayerInfo[playerid][DRearRight][0],TableID);
mysql_query(saveQuery);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vLFirst = '%d', vLSecond = '%d', vLThird = '%d', vLFourth = '%d', vTFrontLeft = '%d', vTFrontRight = '%d', vTRearLeft = '%d', vTRearRight = '%d', vHealth = '%f' WHERE playerID = '%d'",
PlayerInfo[playerid][LFirst][0], PlayerInfo[playerid][LSecond][0], PlayerInfo[playerid][LThird][0], PlayerInfo[playerid][LFourth][0], PlayerInfo[playerid][TFrontLeft][0], PlayerInfo[playerid][TFrontRight][0], PlayerInfo[playerid][TRearLeft][0], PlayerInfo[playerid][TRearRight][0], PlayerInfo[playerid][CarHealth][0], TableID);
mysql_query(saveQuery);
}
if(PlayerInfo[playerid][vModel] >= 1 && doesVehicleExist(PlayerInfo[playerid][pVeh]))
{
GetVehiclePos(PlayerInfo[playerid][pVeh],PlayerInfo[playerid][vX], PlayerInfo[playerid][vY], PlayerInfo[playerid][vZ]);
GetVehicleZAngle(PlayerInfo[playerid][pVeh],PlayerInfo[playerid][vA]);
for(new i = 0; i < 14; i++) {
PlayerInfo[playerid][pVehMod][i] = GetVehicleComponentInSlot(PlayerInfo[playerid][pVeh], i);
}
PlayerInfo[playerid][vFuel] = Fuel[PlayerInfo[playerid][pVeh]];
GetVehicleHealth(PlayerInfo[playerid][pVeh], PlayerInfo[playerid][CarHealth][1]);
GetVehiclePanelsDamageStatus(PlayerInfo[playerid][pVeh], PlayerInfo[playerid][PFrontLeft][1], PlayerInfo[playerid][PFrontRight][1], PlayerInfo[playerid][PRearLeft][1], PlayerInfo[playerid][PRearRight][1], PlayerInfo[playerid][PWindShield][1], PlayerInfo[playerid][PFrontBumper][1], PlayerInfo[playerid][PRearBumper][1]);
GetVehicleDoorsDamageStatus(PlayerInfo[playerid][pVeh], PlayerInfo[playerid][DBonnet][1], PlayerInfo[playerid][DBoot][1], PlayerInfo[playerid][DFrontLeft][1], PlayerInfo[playerid][DFrontRight][1], PlayerInfo[playerid][DRearLeft][1], PlayerInfo[playerid][DRearRight][1]);
GetVehicleLightsDamageStatus(PlayerInfo[playerid][pVeh], PlayerInfo[playerid][LFirst][1], PlayerInfo[playerid][LSecond][1], PlayerInfo[playerid][LThird][1], PlayerInfo[playerid][LFourth][1]);
GetVehicleTiresDamageStatus(PlayerInfo[playerid][pVeh], PlayerInfo[playerid][TFrontLeft][1], PlayerInfo[playerid][TFrontRight][1], PlayerInfo[playerid][TRearLeft][1], PlayerInfo[playerid][TRearRight][1]);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vvPFrontLeft = '%d', vvPFrontRight = '%d', vvPRearLeft = '%d', vvPRearRight = '%d', vvPWindShield = '%d', vvPFrontBumper = '%d', vvPRearBumper = '%d', vvDBonnet = '%d', vvDBoot = '%d', vvDFrontLeft = '%d', vvDFrontRight = '%d', vvDRearLeft = '%d', vvDRearRight = '%d' WHERE playerID = '%d'",
PlayerInfo[playerid][PFrontLeft][1], PlayerInfo[playerid][PFrontRight][1], PlayerInfo[playerid][PRearLeft][1], PlayerInfo[playerid][PRearRight][1], PlayerInfo[playerid][PWindShield][1],
PlayerInfo[playerid][PFrontBumper][1], PlayerInfo[playerid][PRearBumper][1], PlayerInfo[playerid][DBonnet][1], PlayerInfo[playerid][DBoot][1], PlayerInfo[playerid][DFrontLeft][1], PlayerInfo[playerid][DFrontRight][1], PlayerInfo[playerid][DRearLeft][1], PlayerInfo[playerid][DRearRight][1],TableID);
mysql_query(saveQuery);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vvLFirst = '%d', vvLSecond = '%d', vvLThird = '%d', vvLFourth = '%d', vvTFrontLeft = '%d', vvTFrontRight = '%d', vvTRearLeft = '%d', vvTRearRight = '%d', vvHealth = '%f' WHERE playerID = '%d'",
PlayerInfo[playerid][LFirst][1], PlayerInfo[playerid][LSecond][1], PlayerInfo[playerid][LThird][1], PlayerInfo[playerid][LFourth][1], PlayerInfo[playerid][TFrontLeft][1], PlayerInfo[playerid][TFrontRight][1], PlayerInfo[playerid][TRearLeft][1], PlayerInfo[playerid][TRearRight][1], PlayerInfo[playerid][CarHealth][1], TableID);
mysql_query(saveQuery);
}
if(PlayerInfo[playerid][vvModel] >= 1 && doesVehicleExist(PlayerInfo[playerid][pVVeh]))
{
GetVehiclePos(PlayerInfo[playerid][pVVeh],PlayerInfo[playerid][vvX], PlayerInfo[playerid][vvY], PlayerInfo[playerid][vvZ]);
GetVehicleZAngle(PlayerInfo[playerid][pVVeh],PlayerInfo[playerid][vvA]);
for(new i = 0; i < 14; i++) {
PlayerInfo[playerid][pVVehMod][i] = GetVehicleComponentInSlot(PlayerInfo[playerid][pVVeh], i);
}
PlayerInfo[playerid][vvFuel] = Fuel[PlayerInfo[playerid][pVVeh]];
GetVehicleHealth(PlayerInfo[playerid][pVVeh], PlayerInfo[playerid][CarHealth][2]);
GetVehiclePanelsDamageStatus(PlayerInfo[playerid][pVVeh], PlayerInfo[playerid][PFrontLeft][2], PlayerInfo[playerid][PFrontRight][2], PlayerInfo[playerid][PRearLeft][2], PlayerInfo[playerid][PRearRight][2], PlayerInfo[playerid][PWindShield][2], PlayerInfo[playerid][PFrontBumper][2], PlayerInfo[playerid][PRearBumper][2]);
GetVehicleDoorsDamageStatus(PlayerInfo[playerid][pVVeh], PlayerInfo[playerid][DBonnet][2], PlayerInfo[playerid][DBoot][2], PlayerInfo[playerid][DFrontLeft][2], PlayerInfo[playerid][DFrontRight][2], PlayerInfo[playerid][DRearLeft][2], PlayerInfo[playerid][DRearRight][2]);
GetVehicleLightsDamageStatus(PlayerInfo[playerid][pVVeh], PlayerInfo[playerid][LFirst][2], PlayerInfo[playerid][LSecond][2], PlayerInfo[playerid][LThird][2], PlayerInfo[playerid][LFourth][2]);
GetVehicleTiresDamageStatus(PlayerInfo[playerid][pVVeh], PlayerInfo[playerid][TFrontLeft][2], PlayerInfo[playerid][TFrontRight][2], PlayerInfo[playerid][TRearLeft][2], PlayerInfo[playerid][TRearRight][2]);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vvvPFrontLeft = '%d', vvvPFrontRight = '%d', vvvPRearLeft = '%d', vvvPRearRight = '%d', vvvPWindShield = '%d', vvvPFrontBumper = '%d', vvvPRearBumper = '%d', vvvDBonnet = '%d', vvvDBoot = '%d', vvvDFrontLeft = '%d', vvvDFrontRight = '%d', vvvDRearLeft = '%d', vvvDRearRight = '%d' WHERE playerID = '%d'",
PlayerInfo[playerid][PFrontLeft][2], PlayerInfo[playerid][PFrontRight][2], PlayerInfo[playerid][PRearLeft][2], PlayerInfo[playerid][PRearRight][2], PlayerInfo[playerid][PWindShield][2],
PlayerInfo[playerid][PFrontBumper][2], PlayerInfo[playerid][PRearBumper][2], PlayerInfo[playerid][DBonnet][2], PlayerInfo[playerid][DBoot][2], PlayerInfo[playerid][DFrontLeft][2], PlayerInfo[playerid][DFrontRight][2], PlayerInfo[playerid][DRearLeft][2], PlayerInfo[playerid][DRearRight][2],TableID);
mysql_query(saveQuery);
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vvvLFirst = '%d', vvvLSecond = '%d', vvvLThird = '%d', vvvLFourth = '%d', vvvTFrontLeft = '%d', vvvTFrontRight = '%d', vvvTRearLeft = '%d', vvvTRearRight = '%d', vvvHealth = '%f' WHERE playerID = '%d'",
PlayerInfo[playerid][LFirst][2], PlayerInfo[playerid][LSecond][2], PlayerInfo[playerid][LThird][2], PlayerInfo[playerid][LFourth][2], PlayerInfo[playerid][TFrontLeft][2], PlayerInfo[playerid][TFrontRight][2], PlayerInfo[playerid][TRearLeft][2], PlayerInfo[playerid][TRearRight][2], PlayerInfo[playerid][CarHealth][2], TableID);
mysql_query(saveQuery);
}
new SlotnotSav;
new Slot = GetWeaponSlot(GetPlayerWeapon(playerid));
if(GetPlayerWeapon(playerid) > 0 && PlayerInfo[playerid][pWeapons][Slot] == HoldWP[playerid])
{
if(PlayerInfo[playerid][pWeapons][Slot] == HoldWP[playerid])
{
SaveDodAmmo(playerid,Slot);
SlotnotSav = Slot;
}
HoldWP[playerid] = 0;
}
for(new i = 0; i < 13; i++)
{
if(i != SlotnotSav)
{
SaveDodAmmo(playerid,i);
}
}
if(PlayerInfo[playerid][pAdminDuty] == 0 && PlayerInfo[playerid][pEvent] == 0) {
GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
GetPlayerArmour(playerid, PlayerInfo[playerid][pArmour]);
}
//printf("Step 2 Pass");
// If they're not in an event and not spectating, current pos is saved. Otherwise, they'll be set back to the pos they last used /joinevent or /spec.
if(PlayerInfo[playerid][pSpectating] == INVALID_PLAYER_ID && PlayerInfo[playerid][pEvent] == 0) {
if(PlayerInfo[playerid][pTutorial] == 0)
{
GetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
PlayerInfo[playerid][pInterior] = GetPlayerInterior(playerid);
PlayerInfo[playerid][pVirtualWorld] = GetPlayerVirtualWorld(playerid); // If someone disconnects while spectating.
}
}
printf("ID[%d] %s Variable Save", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerBanned = '%d', playerSeconds = '%d', playerSkin = '%d', playerBuySkin = '%d', playerHungry = '%d', playerWDrop = '%d', playerSick = '%d' WHERE playerID = '%d'", PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pSeconds], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pBuySkin],PlayerInfo[playerid][pHungry], WaterDrop[playerid], PlayerInfo[playerid][pSick], TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 1", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerAccent = '%s', plaagjaowg = '%d', playerJob = '%d', playerWeapon0 = '%d', playerWeapon1 = '%d', playerWeapon2 = '%d', playerWeapon3 = '%d' WHERE playerID = '%d'", PlayerInfo[playerid][pAccent], PlayerInfo[playerid][pAdminLevel], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pWeapons][0], PlayerInfo[playerid][pWeapons][1], PlayerInfo[playerid][pWeapons][2], PlayerInfo[playerid][pWeapons][3],TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 2", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerEnergy = '%d', playerDef = '%d', playerCWood = '%d', placash = '%d', playerBankMoney = '%d', playerFacDuty = '%d', playerGascan = '%d', playerIron = '%d', playerBuaWater = '%d'",
PlayerInfo[playerid][pEnergy], PlayerInfo[playerid][pDef],PlayerInfo[playerid][pCWood], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pBankMoney], PlayerInfo[playerid][pFacDuty], PlayerInfo[playerid][pGas], PlayerInfo[playerid][pIron], PlayerInfo[playerid][pBuaWater]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 3", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerInterior = '%d', playerVirtualWorld = '%d', playerHealth = '%f', playerArmour = '%f', playerPosX = '%f', playerPosY = '%f', playerPosZ = '%f'", PlayerInfo[playerid][pInterior], PlayerInfo[playerid][pVirtualWorld], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pArmour], PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 4", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerDelay = '%d', playerGlass1 = '%d', playerGlass2 = '%d', playerGlass3 = '%d', playerCarAmmo1 = '%d', playerCarAmmo2 = '%d', playerCarAmmo3 = '%d', playerDie = '%d', playerDieVW = '%d', playerDieInt = '%d'",
PlayerInfo[playerid][pJobDelay],PlayerInfo[playerid][pSunglass][0], PlayerInfo[playerid][pSunglass][1], PlayerInfo[playerid][pSunglass][2],PlayerInfo[playerid][pCarAmmo][0], PlayerInfo[playerid][pCarAmmo][1], PlayerInfo[playerid][pCarAmmo][2], PlayerInfo[playerid][pDie], PlayerInfo[playerid][pDieVW], PlayerInfo[playerid][pDieInt]);
format(saveQuery, sizeof(saveQuery), "%s, playerCarLicensePlate = '%s', playerCarlic = '%d', playerWPlic = '%d', playerFishBet = '%d', playergps = '%d', playerCoin = '%d', playerCarFuel = '%d',playerCarWeapon1 = '%d', playerCarWeapon2 = '%d', playerCarWeapon3 = '%d', playerCarWeapon4 = '%d', playerCarWeapon5 = '%d'",saveQuery,
PlayerInfo[playerid][pCarLicensePlate],PlayerInfo[playerid][pCarlicense],PlayerInfo[playerid][pWepLic],PlayerInfo[playerid][pFishBet],PlayerInfo[playerid][pGPS],PlayerInfo[playerid][pCoin], PlayerInfo[playerid][pCarFuel],PlayerInfo[playerid][pCarWeapons][0], PlayerInfo[playerid][pCarWeapons][1], PlayerInfo[playerid][pCarWeapons][2], PlayerInfo[playerid][pCarWeapons][3], PlayerInfo[playerid][pCarWeapons][4]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 5", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET vModel = '%d', vX = '%f', vY = '%f', vZ = '%f', vA = '%f', pVehVW = '%d', vC1 = '%d', vC2 = '%d', vPJ = '%d', vLocked = '%d', vModSlot0 = '%d', vModSlot1 = '%d', vModSlot2 = '%d', vModSlot3 = '%d', vModSlot4 = '%d', vModSlot5 = '%d', vModSlot6 = '%d'", PlayerInfo[playerid][vModel],
PlayerInfo[playerid][vX], PlayerInfo[playerid][vY], PlayerInfo[playerid][vZ], PlayerInfo[playerid][vA], PlayerInfo[playerid][pVehVW], PlayerInfo[playerid][vC1], PlayerInfo[playerid][vC2], PlayerInfo[playerid][vPJ], PlayerInfo[playerid][vLocked], PlayerInfo[playerid][pVehMod][0],
PlayerInfo[playerid][pVehMod][1], PlayerInfo[playerid][pVehMod][2], PlayerInfo[playerid][pVehMod][3], PlayerInfo[playerid][pVehMod][4], PlayerInfo[playerid][pVehMod][5],PlayerInfo[playerid][pVehMod][6]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 6", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerPhoneBook = '%d', playerGroup = '%d', playerGroupRank = '%d', playerIP = '%s', playerDropCarTimeout = '%d', playerRope = '%d', playerAdminDuty = '%d', playerCrimes = '%d', playerArrests = '%d', playerWarrants = '%d', playerAge = '%d', playerCarMod7 = '%d', playerCarMod8 = '%d', playerCarMod9 = '%d', playerCarMod10 = '%d', playerCarMod11 = '%d', playerCarMod12 = '%d'",
PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pGroup], PlayerInfo[playerid][pGroupRank], PlayerInfo[playerid][pConnectionIP], PlayerInfo[playerid][pDropCarTimeout], PlayerInfo[playerid][pRope], PlayerInfo[playerid][pAdminDuty], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pArrests], PlayerInfo[playerid][pWarrants], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pCarMods][7], PlayerInfo[playerid][pCarMods][8],
PlayerInfo[playerid][pCarMods][9], PlayerInfo[playerid][pCarMods][10], PlayerInfo[playerid][pCarMods][11], PlayerInfo[playerid][pCarMods][12]);
format(saveQuery, sizeof(saveQuery), "%s, playerWeapon11 = '%d', playerWeapon12 = '%d', playerJobSkill1 = '%d', playerJobSkill2 = '%d', playerJobSkill3 = '%d', playerMaterials = '%d', playerHours = '%d', playerLevel = '%d', playerExp = '%d', playerAmmo0 = '%d', playerAmmo1 = '%d', playerAmmo2 = '%d', playerAmmo3 = '%d', playerAmmo4 = '%d', playerAmmo5 = '%d', playerMeat = '%d'", saveQuery, PlayerInfo[playerid][pWeapons][11], PlayerInfo[playerid][pWeapons][12],
PlayerInfo[playerid][pJobSkill][0], PlayerInfo[playerid][pJobSkill][1], PlayerInfo[playerid][pJobSkill][2], PlayerInfo[playerid][pMaterials], PlayerInfo[playerid][pPlayingHours], PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pAmmo][0], PlayerInfo[playerid][pAmmo][1], PlayerInfo[playerid][pAmmo][2], PlayerInfo[playerid][pAmmo][3], PlayerInfo[playerid][pAmmo][4], PlayerInfo[playerid][pAmmo][5],PlayerInfo[playerid][pMeat]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 7", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerWarning1 = '%s', playerWarning2 = '%s', playerWarning3 = '%s', playerBanReason = '%s', playerHospitalized = '%d', playerFirstLogin = '%d', playerAdminName = '%s', playerPrisonTime = '%d', playerPrisonID = '%d', playerPrisonChoose = '%d', playerPhoneNumber = '%d' , playerAmmo6 = '%d', playerAmmo7 = '%d', playerAmmo8 = '%d', playerAmmo9 = '%d', playerAmmo10 = '%d', playerAmmo11 = '%d', playerAmmo12 = '%d', playerActive = '%d'",
PlayerInfo[playerid][pWarning1], PlayerInfo[playerid][pWarning2],PlayerInfo[playerid][pWarning3],PlayerInfo[playerid][pBanReason],
PlayerInfo[playerid][pHospitalized], PlayerInfo[playerid][pFirstLogin], PlayerInfo[playerid][pAdminName],
PlayerInfo[playerid][pPrisonTime], PlayerInfo[playerid][pPrisonID],PlayerInfo[playerid][pPrisonUse], PlayerInfo[playerid][pPhoneNumber],PlayerInfo[playerid][pAmmo][6], PlayerInfo[playerid][pAmmo][7], PlayerInfo[playerid][pAmmo][8], PlayerInfo[playerid][pAmmo][9], PlayerInfo[playerid][pAmmo][10], PlayerInfo[playerid][pAmmo][11], PlayerInfo[playerid][pAmmo][12],PlayerInfo[playerid][pActive]);
/* Vehicle 2*/
format(saveQuery, sizeof(saveQuery), "%s, vvModel = '%d', vvX = '%f', vvY = '%f', vvZ = '%f', vvA = '%f', pVVehVW = '%d', vvC1 = '%d', vvC2 = '%d', vvPJ = '%d', vvLocked = '%d', vvModSlot0 = '%d', vvModSlot1 = '%d', vvModSlot2 = '%d', vvModSlot3 = '%d', vvModSlot4 = '%d', vvModSlot5 = '%d', vvModSlot6 = '%d'",
saveQuery, PlayerInfo[playerid][vvModel],PlayerInfo[playerid][vvX], PlayerInfo[playerid][vvY], PlayerInfo[playerid][vvZ], PlayerInfo[playerid][vvA], PlayerInfo[playerid][pVVehVW], PlayerInfo[playerid][vvC1], PlayerInfo[playerid][vvC2], PlayerInfo[playerid][vvPJ], PlayerInfo[playerid][vvLocked], PlayerInfo[playerid][pVVehMod][0], PlayerInfo[playerid][pVVehMod][1], PlayerInfo[playerid][pVVehMod][2], PlayerInfo[playerid][pVVehMod][3], PlayerInfo[playerid][pVVehMod][4], PlayerInfo[playerid][pVVehMod][5],
PlayerInfo[playerid][pVVehMod][6]);
format(saveQuery, sizeof(saveQuery), "%s, vvModSlot7 = '%d', vvModSlot8 = '%d', vvModSlot9 = '%d', vvModSlot10 = '%d', vvModSlot11 = '%d', vvModSlot12 = '%d', vvModSlot13 = '%d', vvWeapon1 = '%d', vvWeapon2 = '%d', vvWeapon3 = '%d', vvWeapon4 = '%d', vvWeapon5 = '%d', vvAmmo1 = '%d', vvAmmo2 = '%d', vvAmmo3 = '%d', vvAmmo4 = '%d', vvAmmo5 = '%d'",
saveQuery, PlayerInfo[playerid][pVVehMod][7], PlayerInfo[playerid][pVVehMod][8], PlayerInfo[playerid][pVVehMod][9], PlayerInfo[playerid][pVVehMod][10], PlayerInfo[playerid][pVVehMod][11], PlayerInfo[playerid][pVVehMod][12], PlayerInfo[playerid][pVVehMod][13], PlayerInfo[playerid][vvWeapon][0], PlayerInfo[playerid][vvWeapon][1], PlayerInfo[playerid][vvWeapon][2], PlayerInfo[playerid][vvWeapon][3], PlayerInfo[playerid][vvWeapon][4],
PlayerInfo[playerid][vvAmmo][0], PlayerInfo[playerid][vvAmmo][1],PlayerInfo[playerid][vvAmmo][2], PlayerInfo[playerid][vvAmmo][3], PlayerInfo[playerid][vvAmmo][4]);
format(saveQuery, sizeof(saveQuery), "%s, vvCash = '%d', vvMats = '%d', vvGascan = '%d', vvWeed = '%d', vvPizza = '%d', vvKit = '%d', vvFuel = '%d', vvIns = '%d'",saveQuery, PlayerInfo[playerid][vvTrunk][0], PlayerInfo[playerid][vvTrunk][1], PlayerInfo[playerid][vvTrunk][2], PlayerInfo[playerid][vvTrunk][3], PlayerInfo[playerid][vvTrunk][4], PlayerInfo[playerid][vvTrunk][5], PlayerInfo[playerid][vvFuel], PlayerInfo[playerid][vvIns]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 8", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerJobSkill4 = '%d', playerJobSkill5 = '%d', playerJobSkill6 = '%d', playerJobSkill7 = '%d', playerHatSave = '%d', playerGlassSave = '%d', playerBandaSave = '%d', playerAnySave = '%d', playerAAnySave = '%d', playerAAAnySave = '%d'", PlayerInfo[playerid][pJobSkill][3], PlayerInfo[playerid][pJobSkill][4], PlayerInfo[playerid][pJobSkill][5],
PlayerInfo[playerid][pJobSkill][6],PlayerInfo[playerid][pHatSav],PlayerInfo[playerid][pGlassSav],
PlayerInfo[playerid][pBandaSav],PlayerInfo[playerid][pAnySav],PlayerInfo[playerid][pAAnySav],PlayerInfo[playerid][pAAAnySav]);
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, PlayerInfo[playerid][pCarModel], PlayerInfo[playerid][pCarColour][0], PlayerInfo[playerid][pCarColour][1],
PlayerInfo[playerid][pCarPos][0], PlayerInfo[playerid][pCarPos][1], PlayerInfo[playerid][pCarPos][2], PlayerInfo[playerid][pCarPos][3], PlayerInfo[playerid][pCarMods][0], PlayerInfo[playerid][pCarMods][1], PlayerInfo[playerid][pCarMods][2], PlayerInfo[playerid][pCarMods][3], PlayerInfo[playerid][pCarMods][4], PlayerInfo[playerid][pCarMods][5], PlayerInfo[playerid][pCarMods][6]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 8.5", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerCarTrunk1 = '%d', playerCarTrunk2 = '%d', playerCarTrunk3 = '%d', playerCarTrunk4 = '%d', playerCarTrunk5 = '%d', playerCarTrunk6 = '%d', playerInsurance = '%d', playerPhoneCredit = '%d', playerWalkieTalkie = '%d', playerWeed = '%d', playerWSeed = '%d'", PlayerInfo[playerid][pCarTrunk][0], PlayerInfo[playerid][pCarTrunk][1],
PlayerInfo[playerid][pCarTrunk][2], PlayerInfo[playerid][pCarTrunk][3], PlayerInfo[playerid][pCarTrunk][4], PlayerInfo[playerid][pCarTrunk][5], PlayerInfo[playerid][pInsurance], PlayerInfo[playerid][pPhoneCredit], PlayerInfo[playerid][pWalkieTalkie], PlayerInfo[playerid][pWeed], PlayerInfo[playerid][pSeedWeed]);
format(saveQuery, sizeof(saveQuery), "%s, playerVIP = '%d', playerVIPDay = '%d', playerVIPMonth = '%d', playerVIPHour = '%d', playerNeon1 = '%d', playerNeon2 = '%d', playerNeon3 = '%d', playerLotto = '%d', playerDieTime = '%d'", saveQuery, PlayerInfo[playerid][pVIP], PlayerInfo[playerid][pVIPDay], PlayerInfo[playerid][pVIPMonth], PlayerInfo[playerid][pVIPHour], PlayerInfo[playerid][pNeon], PlayerInfo[playerid][pVNeon],
PlayerInfo[playerid][pVVNeon], PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pDieTime]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 9", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET Crimes1 = '%d', Crimes2 = '%d', Crimes3 = '%d', Crimes4 = '%d', Crimes5 = '%d', Crimes6 = '%d'",
PlayerInfo[playerid][pCrime][0], PlayerInfo[playerid][pCrime][1], PlayerInfo[playerid][pCrime][2], PlayerInfo[playerid][pCrime][3], PlayerInfo[playerid][pCrime][4], PlayerInfo[playerid][pCrime][5]);
format(saveQuery, sizeof(saveQuery), "%s, CrimeReporter1 = '%s', CrimeReporter2 = '%s', CrimeReporter3 = '%s', CrimeReporter4 = '%s', CrimeReporter5 = '%s', CrimeReporter6 = '%s'", saveQuery,
PlayerInfo[playerid][pCrimeReporter0], PlayerInfo[playerid][pCrimeReporter1], PlayerInfo[playerid][pCrimeReporter2], PlayerInfo[playerid][pCrimeReporter3], PlayerInfo[playerid][pCrimeReporter4], PlayerInfo[playerid][pCrimeReporter5]);
format(saveQuery, sizeof(saveQuery), "%s, playerTag = '%s', playerTag2 = '%s', playerTag3 = '%s', playerSTag = '%d', playerCTag = '%s', playerCTag2 = '%s', playerCTag3 = '%s', playerFightStyle = '%d', playerWalkStyle = '%d'", saveQuery, PlayerInfo[playerid][pTag1],
PlayerInfo[playerid][pTag2], PlayerInfo[playerid][pTag3], PlayerInfo[playerid][pSTag], PlayerInfo[playerid][pCTag1], PlayerInfo[playerid][pCTag2], PlayerInfo[playerid][pCTag3], PlayerInfo[playerid][pFightStyle], PlayerInfo[playerid][pWalkStyle]);
format(saveQuery, sizeof(saveQuery), "%s, playerIdcard = '%d', playerIdcardvalid = '%d'",saveQuery, PlayerInfo[playerid][pIdcard], PlayerInfo[playerid][pIdcardvalid]);
format(saveQuery, sizeof(saveQuery), "%s, vModSlot7 = '%d', vModSlot8 = '%d', vModSlot9 = '%d', vModSlot10 = '%d', vModSlot11 = '%d', vModSlot12 = '%d', vModSlot13 = '%d', vWeapon1 = '%d', vWeapon2 = '%d', vWeapon3 = '%d', vWeapon4 = '%d', vWeapon5 = '%d', vAmmo1 = '%d', vAmmo2 = '%d', vAmmo3 = '%d', vAmmo4 = '%d', vAmmo5 = '%d'",
saveQuery, PlayerInfo[playerid][pVehMod][7], PlayerInfo[playerid][pVehMod][8], PlayerInfo[playerid][pVehMod][9], PlayerInfo[playerid][pVehMod][10], PlayerInfo[playerid][pVehMod][11], PlayerInfo[playerid][pVehMod][12], PlayerInfo[playerid][pVehMod][13], PlayerInfo[playerid][vWeapon][0], PlayerInfo[playerid][vWeapon][1], PlayerInfo[playerid][vWeapon][2], PlayerInfo[playerid][vWeapon][3], PlayerInfo[playerid][vWeapon][4],
PlayerInfo[playerid][vAmmo][0], PlayerInfo[playerid][vAmmo][1],PlayerInfo[playerid][vAmmo][2], PlayerInfo[playerid][vAmmo][3], PlayerInfo[playerid][vAmmo][4]);
format(saveQuery, sizeof(saveQuery), "%s, vCash = '%d', vMats = '%d', vGascan = '%d', vWeed = '%d', vPizza = '%d', vKit = '%d', vFuel = '%d', vIns = '%d'",
saveQuery, PlayerInfo[playerid][vTrunk][0], PlayerInfo[playerid][vTrunk][1], PlayerInfo[playerid][vTrunk][2], PlayerInfo[playerid][vTrunk][3], PlayerInfo[playerid][vTrunk][4], PlayerInfo[playerid][vTrunk][5], PlayerInfo[playerid][vFuel], PlayerInfo[playerid][vIns]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 10", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET");
format(saveQuery, sizeof(saveQuery), "%s playerHat1 = '%d', playerHat2 = '%d', playerHat3 = '%d', playerBanda1 = '%d', playerBanda2 = '%d', playerBanda3 = '%d'", saveQuery,
PlayerInfo[playerid][pHat][0], PlayerInfo[playerid][pHat][1], PlayerInfo[playerid][pHat][2], PlayerInfo[playerid][pBanda][0], PlayerInfo[playerid][pBanda][1], PlayerInfo[playerid][pBanda][2]);
format(saveQuery, sizeof(saveQuery), "%s, playerAny1 = '%d', playerAny2 = '%d', playerAny3 = '%d', playerAAny1 = '%d', playerAAny2 = '%d', playerAAny3 = '%d'", saveQuery,
PlayerInfo[playerid][pAny][0], PlayerInfo[playerid][pAny][1], PlayerInfo[playerid][pAny][2], PlayerInfo[playerid][pAAny][0], PlayerInfo[playerid][pAAny][1], PlayerInfo[playerid][pAAny][2]);
format(saveQuery, sizeof(saveQuery), "%s, playerAAAny1 = '%d', playerAAAny2 = '%d', playerAAAny3 = '%d'", saveQuery,
PlayerInfo[playerid][pAAAny][0], PlayerInfo[playerid][pAAAny][1], PlayerInfo[playerid][pAAAny][2]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, TableID);
mysql_query(saveQuery);
printf("ID[%d] %s Update 11", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerDPosX = '%f', playerDPosY = '%f', playerDPosZ = '%f', playerCarPaintJob = '%d', playerCarLock = '%d', playerStatus = '%d', playerGender = '%d', playerHelperLevel = '%d', playerAdminPIN = '%d'",
PlayerInfo[playerid][pDiePos][0], PlayerInfo[playerid][pDiePos][1], PlayerInfo[playerid][pDiePos][2],PlayerInfo[playerid][pCarPaintjob], PlayerInfo[playerid][pCarLock],
PlayerInfo[playerid][pStatus], PlayerInfo[playerid][pGender],PlayerInfo[playerid][pHelper], GetPVarInt(playerid, "pAdminPIN"));
format(saveQuery, sizeof(saveQuery), "%s, playerWeapon4 = '%d', playerWeapon5 = '%d', playerWeapon6 = '%d', playerWeapon7 = '%d', playerWeapon8 = '%d', playerWeapon9 = '%d', playerWeapon10 = '%d', playerCarAmmo4 = '%d', playerCarAmmo5 = '%d', playerFamily = '%d', playerFamilyRank = '%d'", saveQuery,
PlayerInfo[playerid][pWeapons][4], PlayerInfo[playerid][pWeapons][5], PlayerInfo[playerid][pWeapons][6], PlayerInfo[playerid][pWeapons][7], PlayerInfo[playerid][pWeapons][8],
PlayerInfo[playerid][pWeapons][9], PlayerInfo[playerid][pWeapons][10], PlayerInfo[playerid][pCarAmmo][3], PlayerInfo[playerid][pCarAmmo][4],PlayerInfo[playerid][pFamily], PlayerInfo[playerid][pFamilyRank]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, PlayerInfo[playerid][pInternalID]);
mysql_query(saveQuery);
printf("ID[%d] %s Update 12", playerid,RPN(playerid));
format(saveQuery, sizeof(saveQuery), "UPDATE aacoutsername SET playerObj1 = '%d', playerObj2 = '%d', playerObj3 = '%d', playerObj4 = '%d', playerObj5 = '%d', playerHouse = '%d'",
PlayerInfo[playerid][pMyObj][0], PlayerInfo[playerid][pMyObj][1], PlayerInfo[playerid][pMyObj][2],PlayerInfo[playerid][pMyObj][3], PlayerInfo[playerid][pMyObj][4], PlayerInfo[playerid][pHouse]);
format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, PlayerInfo[playerid][pInternalID]);
mysql_query(saveQuery);
printf("ID[%d] %s Update 13", playerid,RPN(playerid));
.
.
.
.