1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Linear Mode
MySQL Not Saving
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#6

14.02.2013, 09:48
My Query
Code:
	format(query, sizeof(query), "UPDATE `users` SET \
		`IP` = '%s', \
		`AccountID` = '%d', \
		`Registered` = %d, \
		`ConnectedTime` = %d, \
		`Sex` = %d, \
		`Age` = %d, \
		`Band` = %d, \
		`PermBand` = %d, \
		`Warnings` = %d, \
		`Disabled` = %d, \
		`Level` = %d, \
		`AdminLevel` = %d, \
		`DonateRank` = %d, \
		`Respect` = %d, \
		`Money` = %d, \
		`Bank` = %d,",
		PlayerInfo[playerid][pIP],
		PlayerInfo[playerid][pAccountID],
		PlayerInfo[playerid][pReg],
		PlayerInfo[playerid][pConnectTime],
		PlayerInfo[playerid][pSex],
		PlayerInfo[playerid][pAge],
		PlayerInfo[playerid][pBanned],
		PlayerInfo[playerid][pPermaBanned],
		PlayerInfo[playerid][pWarns],
		PlayerInfo[playerid][pDisabled],
		PlayerInfo[playerid][pLevel],
		PlayerInfo[playerid][pAdmin],
		PlayerInfo[playerid][pDonateRank],
		PlayerInfo[playerid][pExp],
		GetPVarInt(playerid, "Cash"),
		PlayerInfo[playerid][pAccount]
	);
	
	format(query, sizeof(query), "%s \
		`pHealth` = %f, \
		`pArmor` = %f, \
		`Int` = %d, \
		`Local` = %d, \
		`VirtualWorld` = %d, \
		`Model` = %d, \
		`SPos_x` = %f, \
		`SPos_y` = %f, \
		`SPos_z` = %f, \
		`SPos_r` = %f,",
		query,
		PlayerInfo[playerid][pHealth],
		PlayerInfo[playerid][pArmor],
		PlayerInfo[playerid][pInt],
		PlayerInfo[playerid][pLocal],
		PlayerInfo[playerid][pVW],
		PlayerInfo[playerid][pModel],
		PlayerInfo[playerid][pPos_x],
		PlayerInfo[playerid][pPos_y],
		PlayerInfo[playerid][pPos_z],
		PlayerInfo[playerid][pPos_r]
	);
	
	format(query, sizeof(query), "%s \
		`Radio` = %d, \
		`RadioFreq` = %d, \
		`Origin` = %d, \
		`Crimes` = %d, \
		`Accent` = %d, \
		`CHits` = %d, \
		`FHits` = %d, \
		`Arrested` = %d, \
		`Fishes` = %d, \
		`BiggestFish` = %d, \
		`Job` = %d,",
		query,
		PlayerInfo[playerid][pRadio],
		PlayerInfo[playerid][pRadioFreq],
		PlayerInfo[playerid][pOrigin],
		PlayerInfo[playerid][pCrimes],
		PlayerInfo[playerid][pAccent],
		PlayerInfo[playerid][pCHits],
		PlayerInfo[playerid][pFHits],
		PlayerInfo[playerid][pArrested],
		PlayerInfo[playerid][pFishes],
		PlayerInfo[playerid][pBiggestFish],
		PlayerInfo[playerid][pJob]
	);
	
	format(query, sizeof(query), "%s \
		`Paycheck` = %d, \
		`HeadValue` = %d, \
		`Jailed` = %d, \
		`JailTime` = %d, \
		`Materials` = %d, \
		`Pot` = %d, \
		`Crack` = %d, \
		`Leader` = %d, \
		`Member` = %d, \
		`Division` = %d, \
		`FMember` = %d,",
		query,
		PlayerInfo[playerid][pPayCheck],
		PlayerInfo[playerid][pHeadValue],
		PlayerInfo[playerid][pJailed],
		PlayerInfo[playerid][pJailTime],
		PlayerInfo[playerid][pMats],
		PlayerInfo[playerid][pPot],
		PlayerInfo[playerid][pCrack],
		PlayerInfo[playerid][pLeader],
		PlayerInfo[playerid][pMember],
		PlayerInfo[playerid][pDivision],
		PlayerInfo[playerid][pFMember]
	);
	
	format(query, sizeof(query), "%s \
		`Rank` = %d, \
		`MechSkill` = %d, \
		`TruckSkill` = %d, \
		`FishSkill` = %d, \
		`CheckCash` = %d,",
		query,
		PlayerInfo[playerid][pRank],
		PlayerInfo[playerid][pMechSkill],
		PlayerInfo[playerid][pTruckSkill],
		PlayerInfo[playerid][pFishSkill],
		PlayerInfo[playerid][pCheckCash]
	);
	
	format(query, sizeof(query), "%s \
		`Checks` = %d, \
		`GunLic` = %d, \
		WHERE `Username` = '%s'",
		query,
		PlayerInfo[playerid][pChecks],
		PlayerInfo[playerid][pGunLic],
  		accountName
	);
	
	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);
	
	format(query, sizeof(query), "UPDATE `users` SET \
		`PayDay` = %d, \
		`PayDayHad` = %d, \
		`CDPlayer` = %d, \
		`Dice` = %d, \
		`Spraycan` = %d, \
		`Rope` = %d, \
		`Cigars` = %d, \
		`Bombs` = %d,",
		PlayerInfo[playerid][pPayDay],
		PlayerInfo[playerid][pPayDayHad],
		PlayerInfo[playerid][pCDPlayer],
		PlayerInfo[playerid][pDice],
		PlayerInfo[playerid][pSpraycan],
		PlayerInfo[playerid][pRope],
		PlayerInfo[playerid][pCigar],
		PlayerInfo[playerid][pBombs]
	);
	
	format(query, sizeof(query), "%s \
		`Tutorial` = %d, \
		`OnDuty` = %d, \
		`Hospital` = %d, \
		`Married` = %d, \
		`MarriedTo` = '%s', \
		`ContractBy` = '%s', \
		`ContractDetail` = '%s', \
		`WantedLevel` = %d, \
		`Insurance` = %d,",
		query,
		PlayerInfo[playerid][pTut],
		PlayerInfo[playerid][pDuty],
		GetPVarInt(playerid, "Hospital"),
		PlayerInfo[playerid][pMarried],
		PlayerInfo[playerid][pMarriedTo],
		PlayerInfo[playerid][pContractBy],
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pContractDetail]),
		PlayerInfo[playerid][pWantedLevel],
		PlayerInfo[playerid][pInsurance]
	);
	
	format(query, sizeof(query), "%s \
		`Helper` = %d, \
		`GiftTime` = %d, \
		`AcceptedHelp` = %d, \
		`AcceptReport` = %d, \
		`TrashReport` = %d, \
		`GangWarn` = %d,",
		query,
		PlayerInfo[playerid][pHelper],
		PlayerInfo[playerid][pGiftTime],
		PlayerInfo[playerid][pAcceptedHelp],
		PlayerInfo[playerid][pAcceptReport],
		PlayerInfo[playerid][pTrashReport],
		PlayerInfo[playerid][pGangWarn]
	);
	
	format(query, sizeof(query), "%s \
		`FactionBanned` = %d, \
		`CSFBanned` = %d, \
		`VIPInviteDay` = %d, \
		`TempVIP` = %d, \
		`BuddyInvite` = %d, \
		`Tokens` = %d, \
		`PTokens` = %d, \
		`TriageTime` = %d, \
		`PrisonedBy` = '%s', \
		`PrisonReason` = '%s', \
		`Flag` = '%s', \
		`TicketTime` = %d, \
		`Screwdriver` = %d, \
		`Smslog` = %d, \
		WHERE `Username` = '%s'",
		query,
		PlayerInfo[playerid][pFactionBanned],
		PlayerInfo[playerid][pCSFBanned],
		PlayerInfo[playerid][pVIPInviteDay],
		PlayerInfo[playerid][pTempVIP],
		PlayerInfo[playerid][pBuddyInvited],
		PlayerInfo[playerid][pTokens],
		PlayerInfo[playerid][pPaintTokens],
		PlayerInfo[playerid][pTriageTime],
		PlayerInfo[playerid][pPrisonedBy],
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pPrisonReason]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pFlag]),
		PlayerInfo[playerid][pTicketTime],
		PlayerInfo[playerid][pScrewdriver],
		PlayerInfo[playerid][pSmslog],
		accountName
	);
		
	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);
	
	format(query, sizeof(query), "UPDATE `users` SET \
		`Wristwatch` = %d, \
		`Surveillance` = %d, \
		`Firstaid` = %d, \
		`Rccam` = %d, \
		`Receiver` = %d, \
		`GPS` = %d, \
		`Sweep` = %d, \
		`SweepLeft` = %d, \
		`Bugged` = %d,",
		PlayerInfo[playerid][pWristwatch],
		PlayerInfo[playerid][pSurveillance],
		PlayerInfo[playerid][pFirstaid],
		PlayerInfo[playerid][pRccam],
		PlayerInfo[playerid][pReceiver],
		PlayerInfo[playerid][pGPS],
		PlayerInfo[playerid][pSweep],
		PlayerInfo[playerid][pSweepLeft],
		PlayerInfo[playerid][pBugged]
	);
	
	format(query, sizeof(query), "%s \
		`Smslog0` = '%s', \
		`Smslog1` = '%s', \
		`Smslog2` = '%s', \
		`Smslog3` = '%s', \
		`Smslog4` = '%s', \
		`Smslog5` = '%s', \
		`Smslog6` = '%s', \
		`Smslog7` = '%s', \
		`Smslog8` = '%s', \
		`Smslog9` = '%s',",
		query,
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog0]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog1]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog2]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog3]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog4]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog5]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog6]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog7]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog8]),
		g_mysql_ReturnEscaped(PlayerInfo[playerid][pSmslog9])
	);

	format(query, sizeof(query), "%s \
		`Warrants` = %d, \
		`JudgeJailTime` = %d, \
		`JudgeJailType` = %d, \
		`BeingSentenced` = %d, \
		`ProbationTime` = %d, \
		`DMKills` = %d,",
		query,
		PlayerInfo[playerid][pWarrant],
		PlayerInfo[playerid][pJudgeJailTime],
		PlayerInfo[playerid][pJudgeJailType],
		PlayerInfo[playerid][pBeingSentenced],
		PlayerInfo[playerid][pProbationTime],
		PlayerInfo[playerid][pDMKills]
	);
	
	format(query, sizeof(query), "%s \
		`CallsAccepted` = %d, \
		`PatientsDelivered` = %d, \
		`LiveBanned` = %d, \
		`BizID` = %i, \
		`Hunger` = %d, \
		`Mask` = %d, \
		`MaskNumber` = %d, \
		`Bladder` = %d \
		WHERE `Username` = '%s'",
		query,
		PlayerInfo[playerid][pCallsAccepted],
		PlayerInfo[playerid][pPatientsDelivered],
		PlayerInfo[playerid][pLiveBanned],
		PlayerInfo[playerid][BizID],
		PlayerInfo[playerid][pHunger],
		PlayerInfo[playerid][pMask],
		PlayerInfo[playerid][pMaskNumber],
		PlayerInfo[playerid][pBladder],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `Schem1` = %d, \
	    `Schem2` = %d, \
	    `Schem3` = %d, \
	    `Schem4` = %d, \
	    `Schem5` = %d, \
		`Schem6` = %d, \
		`Schem7` = %d, \
		`Schem8` = %d, \
		`Schem9` = %d, \
		`Schem10` = %d, \
		`Schem11` = %d, \
		`Schem12` = %d,",
		query,
		PlayerInfo[playerid][pSchemGun][0],
		PlayerInfo[playerid][pSchemGun][1],
		PlayerInfo[playerid][pSchemGun][2],
		PlayerInfo[playerid][pSchemGun][3],
		PlayerInfo[playerid][pSchemGun][4],
		PlayerInfo[playerid][pSchemGun][5],
		PlayerInfo[playerid][pSchemGun][6],
		PlayerInfo[playerid][pSchemGun][7],
		PlayerInfo[playerid][pSchemGun][8],
		PlayerInfo[playerid][pSchemGun][9],
		PlayerInfo[playerid][pSchemGun][10],
		PlayerInfo[playerid][pSchemGun][11]
	);
	
	format(query, sizeof(query), "%s \
		`Energy` = %d, \
		`Component` = %d, \
		`Tires` = %d, \
		`PaycheckTime` = %d, \
		`SecTime` = %d, \
		`MinutesTime` = %d,",
		PlayerInfo[playerid][pEnergy],
		PlayerInfo[playerid][pComponent],
		PlayerInfo[playerid][pTires],
		PlayerInfo[playerid][pPaycheckTime],
		PlayerInfo[playerid][pSecTime],
		PlayerInfo[playerid][pMinutesTime]
	);
	
	format(query, sizeof(query), "%s \
	    `pv0PosX` = %f, \
	    `pv0PosY` = %f, \
	    `pv0PosZ` = %f, \
	    `pv0PosAngle` = %f, \
	    `pv0ModelId` = %d, \
	    `pv0Lock` = %d, \
	    `pv0Locked` = %d, \
	    `pv0PaintJob` = %d, \
	    `pv0Color1` = %d, \
	    `pv0Color2` = %d, \
	    `pv0Price` = %d \
		WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][0][pvPosX],
		PlayerVehicleInfo[playerid][0][pvPosY],
		PlayerVehicleInfo[playerid][0][pvPosZ],
		PlayerVehicleInfo[playerid][0][pvPosAngle],
		PlayerVehicleInfo[playerid][0][pvModelId],
		PlayerVehicleInfo[playerid][0][pvLock],
		PlayerVehicleInfo[playerid][0][pvLocked],
		PlayerVehicleInfo[playerid][0][pvPaintJob],
		PlayerVehicleInfo[playerid][0][pvColor1],
		PlayerVehicleInfo[playerid][0][pvColor2],
		PlayerVehicleInfo[playerid][0][pvPrice],
		accountName
	);
	
	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);
	
	format(query, sizeof(query), "UPDATE `users` SET \
	    `pv0Weapon0` = %d, \
	    `pv0Weapon1` = %d, \
		`pv0Weapon2` = %d, \
		`pv0WepUpgrade` = %d, \
		`pv0Fuel` = %f, \
		`pv0Impound` = %d, \
		`pv0Neon` = %d, \
		`pv0NumPlate` = %d, \
		`pv0WeaponAmmo0` = %d, \
		`pv0WeaponAmmo1` = %d, \
		`pv0WeaponAmmo2` = %d, \
		`pv0Health` = %f,",
		PlayerVehicleInfo[playerid][0][pvWeapons][0],
		PlayerVehicleInfo[playerid][0][pvWeapons][1],
		PlayerVehicleInfo[playerid][0][pvWeapons][2],
		PlayerVehicleInfo[playerid][0][pvWepUpgrade],
		PlayerVehicleInfo[playerid][0][pvFuel],
		PlayerVehicleInfo[playerid][0][pvImpounded],
		PlayerVehicleInfo[playerid][0][pvNeon],
		PlayerVehicleInfo[playerid][0][pvNumberPlate],
		PlayerVehicleInfo[playerid][0][pvWeaponsAmmo][0],
		PlayerVehicleInfo[playerid][0][pvWeaponsAmmo][1],
		PlayerVehicleInfo[playerid][0][pvWeaponsAmmo][2],
		PlayerVehicleInfo[playerid][0][pvHealth]
	);

	format(query, sizeof(query), "%s \
		`pv0Mod0` = %d, \
		`pv0Mod1` = %d, \
		`pv0Mod2` = %d, \
		`pv0Mod3` = %d, \
		`pv0Mod4` = %d, \
		`pv0Mod5` = %d, \
		`pv0Mod6` = %d, \
		`pv0Mod7` = %d, \
		`pv0Mod8` = %d, \
		`pv0Mod9` = %d, \
		`pv0Mod10` = %d, \
		`pv0Mod11` = %d,",
		PlayerVehicleInfo[playerid][0][pvMods][0],
		PlayerVehicleInfo[playerid][0][pvMods][1],
		PlayerVehicleInfo[playerid][0][pvMods][2],
		PlayerVehicleInfo[playerid][0][pvMods][3],
		PlayerVehicleInfo[playerid][0][pvMods][4],
		PlayerVehicleInfo[playerid][0][pvMods][5],
		PlayerVehicleInfo[playerid][0][pvMods][6],
		PlayerVehicleInfo[playerid][0][pvMods][7],
		PlayerVehicleInfo[playerid][0][pvMods][8],
		PlayerVehicleInfo[playerid][0][pvMods][9],
		PlayerVehicleInfo[playerid][0][pvMods][10],
		PlayerVehicleInfo[playerid][0][pvMods][11]
	);
	
	format(query, sizeof(query), "%s \
	    `pv0Mod12` = %d, \
	    `pv0Mod13` = %d, \
	    `pv0Mod14` = %d \
	    WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][0][pvMods][12],
	    PlayerVehicleInfo[playerid][0][pvMods][13],
	    PlayerVehicleInfo[playerid][0][pvMods][14],
	    accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "%s \
	    `pv1PosX` = %f, \
	    `pv1PosY` = %f, \
	    `pv1PosZ` = %f, \
	    `pv1PosAngle` = %f, \
	    `pv1ModelId` = %d, \
	    `pv1Lock` = %d, \
	    `pv1Locked` = %d, \
	    `pv1PaintJob` = %d, \
	    `pv1Color1` = %d, \
	    `pv1Color2` = %d, \
	    `pv1Price` = %d \
		WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][1][pvPosX],
		PlayerVehicleInfo[playerid][1][pvPosY],
		PlayerVehicleInfo[playerid][1][pvPosZ],
		PlayerVehicleInfo[playerid][1][pvPosAngle],
		PlayerVehicleInfo[playerid][1][pvModelId],
		PlayerVehicleInfo[playerid][1][pvLock],
		PlayerVehicleInfo[playerid][1][pvLocked],
		PlayerVehicleInfo[playerid][1][pvPaintJob],
		PlayerVehicleInfo[playerid][1][pvColor1],
		PlayerVehicleInfo[playerid][1][pvColor2],
		PlayerVehicleInfo[playerid][1][pvPrice],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pv1Weapon0` = %d, \
	    `pv1Weapon1` = %d, \
		`pv1Weapon2` = %d, \
		`pv1WepUpgrade` = %d, \
		`pv1Fuel` = %f, \
		`pv1Impound` = %d, \
		`pv1Neon` = %d, \
		`pv1NumPlate` = %d, \
		`pv1WeaponAmmo0` = %d, \
		`pv1WeaponAmmo1` = %d, \
		`pv1WeaponAmmo2` = %d, \
		`pv1Health` = %f,",
		PlayerVehicleInfo[playerid][1][pvWeapons][0],
		PlayerVehicleInfo[playerid][1][pvWeapons][1],
		PlayerVehicleInfo[playerid][1][pvWeapons][2],
		PlayerVehicleInfo[playerid][1][pvWepUpgrade],
		PlayerVehicleInfo[playerid][1][pvFuel],
		PlayerVehicleInfo[playerid][1][pvImpounded],
		PlayerVehicleInfo[playerid][1][pvNeon],
		PlayerVehicleInfo[playerid][1][pvNumberPlate],
		PlayerVehicleInfo[playerid][1][pvWeaponsAmmo][0],
		PlayerVehicleInfo[playerid][1][pvWeaponsAmmo][1],
		PlayerVehicleInfo[playerid][1][pvWeaponsAmmo][2],
		PlayerVehicleInfo[playerid][1][pvHealth]
	);

	format(query, sizeof(query), "%s \
		`pv1Mod0` = %d, \
		`pv1Mod1` = %d, \
		`pv1Mod2` = %d, \
		`pv1Mod3` = %d, \
		`pv1Mod4` = %d, \
		`pv1Mod5` = %d, \
		`pv1Mod6` = %d, \
		`pv1Mod7` = %d, \
		`pv1Mod8` = %d, \
		`pv1Mod9` = %d, \
		`pv1Mod10` = %d, \
		`pv1Mod11` = %d,",
		PlayerVehicleInfo[playerid][1][pvMods][0],
		PlayerVehicleInfo[playerid][1][pvMods][1],
		PlayerVehicleInfo[playerid][1][pvMods][2],
		PlayerVehicleInfo[playerid][1][pvMods][3],
		PlayerVehicleInfo[playerid][1][pvMods][4],
		PlayerVehicleInfo[playerid][1][pvMods][5],
		PlayerVehicleInfo[playerid][1][pvMods][6],
		PlayerVehicleInfo[playerid][1][pvMods][7],
		PlayerVehicleInfo[playerid][1][pvMods][8],
		PlayerVehicleInfo[playerid][1][pvMods][9],
		PlayerVehicleInfo[playerid][1][pvMods][10],
		PlayerVehicleInfo[playerid][1][pvMods][11]
	);

	format(query, sizeof(query), "%s \
	    `pv1Mod12` = %d, \
	    `pv1Mod13` = %d, \
	    `pv1Mod14` = %d \
	    WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][1][pvMods][12],
	    PlayerVehicleInfo[playerid][1][pvMods][13],
	    PlayerVehicleInfo[playerid][1][pvMods][14],
	    accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "%s \
	    `pv2PosX` = %f, \
	    `pv2PosY` = %f, \
	    `pv2PosZ` = %f, \
	    `pv2PosAngle` = %f, \
	    `pv2ModelId` = %d, \
	    `pv2Lock` = %d, \
	    `pv2Locked` = %d, \
	    `pv2PaintJob` = %d, \
	    `pv2Color1` = %d, \
	    `pv2Color2` = %d, \
	    `pv2Price` = %d \
		WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][2][pvPosX],
		PlayerVehicleInfo[playerid][2][pvPosY],
		PlayerVehicleInfo[playerid][2][pvPosZ],
		PlayerVehicleInfo[playerid][2][pvPosAngle],
		PlayerVehicleInfo[playerid][2][pvModelId],
		PlayerVehicleInfo[playerid][2][pvLock],
		PlayerVehicleInfo[playerid][2][pvLocked],
		PlayerVehicleInfo[playerid][2][pvPaintJob],
		PlayerVehicleInfo[playerid][2][pvColor1],
		PlayerVehicleInfo[playerid][2][pvColor2],
		PlayerVehicleInfo[playerid][2][pvPrice],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pv2Weapon0` = %d, \
	    `pv2Weapon1` = %d, \
		`pv2Weapon2` = %d, \
		`pv2WepUpgrade` = %d, \
		`pv2Fuel` = %f, \
		`pv2Impound` = %d, \
		`pv2Neon` = %d, \
		`pv2NumPlate` = %d, \
		`pv2WeaponAmmo0` = %d, \
		`pv2WeaponAmmo1` = %d, \
		`pv2WeaponAmmo2` = %d, \
		`pv2Health` = %f,",
		PlayerVehicleInfo[playerid][2][pvWeapons][0],
		PlayerVehicleInfo[playerid][2][pvWeapons][1],
		PlayerVehicleInfo[playerid][2][pvWeapons][2],
		PlayerVehicleInfo[playerid][2][pvWepUpgrade],
		PlayerVehicleInfo[playerid][2][pvFuel],
		PlayerVehicleInfo[playerid][2][pvImpounded],
		PlayerVehicleInfo[playerid][2][pvNeon],
		PlayerVehicleInfo[playerid][2][pvNumberPlate],
		PlayerVehicleInfo[playerid][2][pvWeaponsAmmo][0],
		PlayerVehicleInfo[playerid][2][pvWeaponsAmmo][1],
		PlayerVehicleInfo[playerid][2][pvWeaponsAmmo][2],
		PlayerVehicleInfo[playerid][2][pvHealth]
	);

	format(query, sizeof(query), "%s \
		`pv2Mod0` = %d, \
		`pv2Mod1` = %d, \
		`pv2Mod2` = %d, \
		`pv2Mod3` = %d, \
		`pv2Mod4` = %d, \
		`pv2Mod5` = %d, \
		`pv2Mod6` = %d, \
		`pv2Mod7` = %d, \
		`pv2Mod8` = %d, \
		`pv2Mod9` = %d, \
		`pv2Mod10` = %d, \
		`pv2Mod11` = %d,",
		PlayerVehicleInfo[playerid][2][pvMods][0],
		PlayerVehicleInfo[playerid][2][pvMods][1],
		PlayerVehicleInfo[playerid][2][pvMods][2],
		PlayerVehicleInfo[playerid][2][pvMods][3],
		PlayerVehicleInfo[playerid][2][pvMods][4],
		PlayerVehicleInfo[playerid][2][pvMods][5],
		PlayerVehicleInfo[playerid][2][pvMods][6],
		PlayerVehicleInfo[playerid][2][pvMods][7],
		PlayerVehicleInfo[playerid][2][pvMods][8],
		PlayerVehicleInfo[playerid][2][pvMods][9],
		PlayerVehicleInfo[playerid][2][pvMods][10],
		PlayerVehicleInfo[playerid][2][pvMods][11]
	);

	format(query, sizeof(query), "%s \
	    `pv2Mod12` = %d, \
	    `pv2Mod13` = %d, \
	    `pv2Mod14` = %d \
	    WHERE `Username` = '%s'",
	    PlayerVehicleInfo[playerid][2][pvMods][12],
	    PlayerVehicleInfo[playerid][2][pvMods][13],
	    PlayerVehicleInfo[playerid][2][pvMods][14],
	    accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pt0ModelId` = %d, \
	    `pt0Bone` = %d, \
		`pt0PosX` = %f, \
		`pt0PosY` = %f, \
		`pt0PosZ` = %f, \
		`pt0RotX` = %f, \
		`pt0RotY` = %f, \
		`pt0RotZ` = %f, \
		`pt0ScaleX` = %f, \
		`pt0ScaleY` = %f, \
		`pt0ScaleZ` = %f,",
		PlayerToyInfo[playerid][0][ptModelID],
		PlayerToyInfo[playerid][0][ptBone],
		PlayerToyInfo[playerid][0][ptPosX],
		PlayerToyInfo[playerid][0][ptPosY],
		PlayerToyInfo[playerid][0][ptPosZ],
		PlayerToyInfo[playerid][0][ptRotX],
		PlayerToyInfo[playerid][0][ptRotY],
		PlayerToyInfo[playerid][0][ptRotZ],
		PlayerToyInfo[playerid][0][ptScaleX],
		PlayerToyInfo[playerid][0][ptScaleY],
		PlayerToyInfo[playerid][0][ptScaleZ]
	);
	
	format(query, sizeof(query), "%s \
	    `pt1ModelId` = %d, \
	    `pt1Bone` = %d, \
		`pt1PosX` = %f, \
		`pt1PosY` = %f, \
		`pt1PosZ` = %f, \
		`pt1RotX` = %f, \
		`pt1RotY` = %f, \
		`pt1RotZ` = %f, \
		`pt1ScaleX` = %f, \
		`pt1ScaleY` = %f, \
		`pt1ScaleZ` = %f \
		WHERE `Username` = '%s'",
		PlayerToyInfo[playerid][1][ptModelID],
		PlayerToyInfo[playerid][1][ptBone],
		PlayerToyInfo[playerid][1][ptPosX],
		PlayerToyInfo[playerid][1][ptPosY],
		PlayerToyInfo[playerid][1][ptPosZ],
		PlayerToyInfo[playerid][1][ptRotX],
		PlayerToyInfo[playerid][1][ptRotY],
		PlayerToyInfo[playerid][1][ptRotZ],
		PlayerToyInfo[playerid][1][ptScaleX],
		PlayerToyInfo[playerid][1][ptScaleY],
		PlayerToyInfo[playerid][1][ptScaleZ],
		accountName
	);
	
	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pt2ModelId` = %d, \
	    `pt2Bone` = %d, \
		`pt2PosX` = %f, \
		`pt2PosY` = %f, \
		`pt2PosZ` = %f, \
		`pt2RotX` = %f, \
		`pt2RotY` = %f, \
		`pt2RotZ` = %f, \
		`pt2ScaleX` = %f, \
		`pt2ScaleY` = %f, \
		`pt2ScaleZ` = %f,",
		PlayerToyInfo[playerid][2][ptModelID],
		PlayerToyInfo[playerid][2][ptBone],
		PlayerToyInfo[playerid][2][ptPosX],
		PlayerToyInfo[playerid][2][ptPosY],
		PlayerToyInfo[playerid][2][ptPosZ],
		PlayerToyInfo[playerid][2][ptRotX],
		PlayerToyInfo[playerid][2][ptRotY],
		PlayerToyInfo[playerid][2][ptRotZ],
		PlayerToyInfo[playerid][2][ptScaleX],
		PlayerToyInfo[playerid][2][ptScaleY],
		PlayerToyInfo[playerid][2][ptScaleZ]
	);

	format(query, sizeof(query), "%s \
	    `pt3ModelId` = %d, \
	    `pt3Bone` = %d, \
		`pt3PosX` = %f, \
		`pt3PosY` = %f, \
		`pt3PosZ` = %f, \
		`pt3RotX` = %f, \
		`pt3RotY` = %f, \
		`pt3RotZ` = %f, \
		`pt3ScaleX` = %f, \
		`pt3ScaleY` = %f, \
		`pt3ScaleZ` = %f \
		WHERE `Username` = '%s'",
		PlayerToyInfo[playerid][3][ptModelID],
		PlayerToyInfo[playerid][3][ptBone],
		PlayerToyInfo[playerid][3][ptPosX],
		PlayerToyInfo[playerid][3][ptPosY],
		PlayerToyInfo[playerid][3][ptPosZ],
		PlayerToyInfo[playerid][3][ptRotX],
		PlayerToyInfo[playerid][3][ptRotY],
		PlayerToyInfo[playerid][3][ptRotZ],
		PlayerToyInfo[playerid][3][ptScaleX],
		PlayerToyInfo[playerid][3][ptScaleY],
		PlayerToyInfo[playerid][3][ptScaleZ],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pt4ModelId` = %d, \
	    `pt4Bone` = %d, \
		`pt4PosX` = %f, \
		`pt4PosY` = %f, \
		`pt4PosZ` = %f, \
		`pt4RotX` = %f, \
		`pt4RotY` = %f, \
		`pt4RotZ` = %f, \
		`pt4ScaleX` = %f, \
		`pt4ScaleY` = %f, \
		`pt4ScaleZ` = %f,",
		PlayerToyInfo[playerid][4][ptModelID],
		PlayerToyInfo[playerid][4][ptBone],
		PlayerToyInfo[playerid][4][ptPosX],
		PlayerToyInfo[playerid][4][ptPosY],
		PlayerToyInfo[playerid][4][ptPosZ],
		PlayerToyInfo[playerid][4][ptRotX],
		PlayerToyInfo[playerid][4][ptRotY],
		PlayerToyInfo[playerid][4][ptRotZ],
		PlayerToyInfo[playerid][4][ptScaleX],
		PlayerToyInfo[playerid][4][ptScaleY],
		PlayerToyInfo[playerid][4][ptScaleZ]
	);

	format(query, sizeof(query), "%s \
	    `pt5ModelId` = %d, \
	    `pt5Bone` = %d, \
		`pt5PosX` = %f, \
		`pt5PosY` = %f, \
		`pt5PosZ` = %f, \
		`pt5RotX` = %f, \
		`pt5RotY` = %f, \
		`pt5RotZ` = %f, \
		`pt5ScaleX` = %f, \
		`pt5ScaleY` = %f, \
		`pt5ScaleZ` = %f \
		WHERE `Username` = '%s'",
		PlayerToyInfo[playerid][5][ptModelID],
		PlayerToyInfo[playerid][5][ptBone],
		PlayerToyInfo[playerid][5][ptPosX],
		PlayerToyInfo[playerid][5][ptPosY],
		PlayerToyInfo[playerid][5][ptPosZ],
		PlayerToyInfo[playerid][5][ptRotX],
		PlayerToyInfo[playerid][5][ptRotY],
		PlayerToyInfo[playerid][5][ptRotZ],
		PlayerToyInfo[playerid][5][ptScaleX],
		PlayerToyInfo[playerid][5][ptScaleY],
		PlayerToyInfo[playerid][5][ptScaleZ],
		accountName
	);

	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	format(query, sizeof(query), "UPDATE `users` SET \
	    `pt6ModelId` = %d, \
	    `pt6Bone` = %d, \
		`pt6PosX` = %f, \
		`pt6PosY` = %f, \
		`pt6PosZ` = %f, \
		`pt6RotX` = %f, \
		`pt6RotY` = %f, \
		`pt6RotZ` = %f, \
		`pt6ScaleX` = %f, \
		`pt6ScaleY` = %f, \
		`pt6ScaleZ` = %f,",
		PlayerToyInfo[playerid][6][ptModelID],
		PlayerToyInfo[playerid][6][ptBone],
		PlayerToyInfo[playerid][6][ptPosX],
		PlayerToyInfo[playerid][6][ptPosY],
		PlayerToyInfo[playerid][6][ptPosZ],
		PlayerToyInfo[playerid][6][ptRotX],
		PlayerToyInfo[playerid][6][ptRotY],
		PlayerToyInfo[playerid][6][ptRotZ],
		PlayerToyInfo[playerid][6][ptScaleX],
		PlayerToyInfo[playerid][6][ptScaleY],
		PlayerToyInfo[playerid][6][ptScaleZ]
	);

	format(query, sizeof(query), "%s \
	    `pt7ModelId` = %d, \
	    `pt7Bone` = %d, \
		`pt7PosX` = %f, \
		`pt7PosY` = %f, \
		`pt7PosZ` = %f, \
		`pt7RotX` = %f, \
		`pt7RotY` = %f, \
		`pt7RotZ` = %f, \
		`pt7ScaleX` = %f, \
		`pt7ScaleY` = %f, \
		`pt7ScaleZ` = %f \
		WHERE `Username` = '%s'",
		PlayerToyInfo[playerid][7][ptModelID],
		PlayerToyInfo[playerid][7][ptBone],
		PlayerToyInfo[playerid][7][ptPosX],
		PlayerToyInfo[playerid][7][ptPosY],
		PlayerToyInfo[playerid][7][ptPosZ],
		PlayerToyInfo[playerid][7][ptRotX],
		PlayerToyInfo[playerid][7][ptRotY],
		PlayerToyInfo[playerid][7][ptRotZ],
		PlayerToyInfo[playerid][7][ptScaleX],
		PlayerToyInfo[playerid][7][ptScaleY],
		PlayerToyInfo[playerid][7][ptScaleZ],
		accountName
	);
	mysql_query(query, SENDUSERDATA_THREAD, playerid, MainPipeline);

	return 1;
Find
Reply
« Next Oldest | Next Newest »


Messages In This Thread
MySQL Not Saving - by RenovanZ - 14.02.2013, 04:53
Re: MySQL Not Saving - by Vince - 14.02.2013, 05:01
Re: MySQL Not Saving - by RenovanZ - 14.02.2013, 05:03
Re: MySQL Not Saving - by 3ventic - 14.02.2013, 07:57
Re: MySQL Not Saving - by Boooth - 14.02.2013, 09:30
Re: MySQL Not Saving - by RenovanZ - 14.02.2013, 09:48
Re: MySQL Not Saving - by RenovanZ - 14.02.2013, 11:07
Re: MySQL Not Saving - by adsy - 14.02.2013, 11:23
Re: MySQL Not Saving - by RenovanZ - 14.02.2013, 11:36
Re: MySQL Not Saving - by RenovanZ - 14.02.2013, 12:07

Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help