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

Threaded Mode
MySQL Error
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#1

15.02.2013, 04:34
Hey, when Im logout from the server, there's a query error, this is the error
Код:
[2013/2/15 - 12:55:13]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/15 - 12:55:13] OnQueryFinish
[2013/2/15 - 12:55:13] Lost connection to MySQL server during query
[2013/2/15 - 12:55:13] SET SQL_SAFE_UPDATES=0;
[2013/2/15 - 12:55:13] NULL
[2013/2/15 - 12:55:13] Lost connection to MySQL server during query
[2013/2/15 - 12:55:13]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/15 - 12:55:13] OnQueryFinish
[2013/2/15 - 12:55:13] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea
The Query:
Код:
	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);
Find
Reply
PaulDinam
Gangsta
*****
Posts: 887
Threads: 251
Joined: Jun 2011
Reputation: 0
#2

15.02.2013, 05:25
You're missing :
Код:
UPDATE `users` SET ............. and why do you have ///// every time
Find
Reply
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#3

15.02.2013, 05:30
I'll show you the fully code
Код:
stock g_mysql_SaveAccount(playerid)
{
	new query[100000], accountName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, accountName, MAX_PLAYER_NAME);
		
	g_mysql_SafeUpdating();
	
	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` = '%s', \
		`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,",
		query,
		PlayerInfo[playerid][pChecks],
		PlayerInfo[playerid][pGunLic]
	);
	
	format(query, sizeof(query), "%s \
		`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,",
		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]
	);
	
	format(query, sizeof(query), "%s \
		`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,",
		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]
	);

	format(query, sizeof(query), "%s \
	    `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,",
	    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]
	);


	format(query, sizeof(query), "%s \
	    `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,",
	    PlayerVehicleInfo[playerid][0][pvMods][12],
	    PlayerVehicleInfo[playerid][0][pvMods][13],
	    PlayerVehicleInfo[playerid][0][pvMods][14]
	);

	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,",
	    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]
	);

	format(query, sizeof(query), "%s \
	    `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,",
	    PlayerVehicleInfo[playerid][1][pvMods][12],
	    PlayerVehicleInfo[playerid][1][pvMods][13],
	    PlayerVehicleInfo[playerid][1][pvMods][14]
	);

	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,",
	    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]
	);

	format(query, sizeof(query), "%s \
	    `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,",
	    PlayerVehicleInfo[playerid][2][pvMods][12],
	    PlayerVehicleInfo[playerid][2][pvMods][13],
	    PlayerVehicleInfo[playerid][2][pvMods][14]
	);

	format(query, sizeof(query), "%s \
	    `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,",
		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]
	);

	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,",
		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]
	);

	format(query, sizeof(query), "%s \
	    `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,",
		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]
	);


	format(query, sizeof(query), "%s \
	    `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
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#4

15.02.2013, 05:34
Jesus... That code... my God. But, I won't even go there right now...

You're saying there's a string to send along with each query, yet you're forgetting to include the variable to read the string from in some of the format lines. Take a second look, notice how you're forgetting to do this...?

pawn Код:
query,
Find
Reply
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#5

15.02.2013, 05:37
Quote:
Originally Posted by RealCop228
Посмотреть сообщение
Jesus... That code... my God. But, I won't even go there right now...

You're saying there's a string to send along with each query, yet you're forgetting to include the variable to read the string from in some of the format lines. Take a second look, notice how you're forgetting to do this...?

pawn Код:
query,
Oah, My eyes, I dont saw it
Find
Reply
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#6

15.02.2013, 05:53
Thanks! It Fixed, +REP!
Find
Reply
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#7

15.02.2013, 10:20
Hey, there's a new query error
this is the error:
Код:
[2013/2/15 - 14:32:22] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea[2013/2/15 - 17:57:1] SET SQL_SAFE_UPDATES=0;
[2013/2/15 - 17:57:1] NULL
[2013/2/15 - 17:57:1] Lost connection to MySQL server during query
The query is:
Код:
stock SafeUpdating()
{
	mysql_query("SET SQL_SAFE_UPDATES=0;", NO_THREAD, 0, MainPipeline);
	return 1;
}
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#8

15.02.2013, 14:01
Quote:
Originally Posted by Kiyozi_Mu
Посмотреть сообщение
Hey, there's a new query error
this is the error:
Код:
[2013/2/15 - 14:32:22] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea[2013/2/15 - 17:57:1] SET SQL_SAFE_UPDATES=0;
[2013/2/15 - 17:57:1] NULL
[2013/2/15 - 17:57:1] Lost connection to MySQL server during query
The query is:
Код:
stock SafeUpdating()
{
	mysql_query("SET SQL_SAFE_UPDATES=0;", NO_THREAD, 0, MainPipeline);
	return 1;
}
I don't see a reason for you to need to send that as a query, so just go ahead and delete it!
Find
Reply
RenovanZ
Gangsta
****
Posts: 597
Threads: 42
Joined: Jul 2012
Reputation: 0
#9

15.02.2013, 14:07
Quote:
Originally Posted by RealCop228
Посмотреть сообщение
I don't see a reason for you to need to send that as a query, so just go ahead and delete it!
yea I've deleted it about an hour ago, and I got new Query error -_-
this is the error
Код:
[22:25:29] CMySQLHandler::Query(UPDATE `users` SET `IP` = '10.76.169.250', `AccountID` = 11, `Registered` = 1, `ConnectedTime` = 0, `Sex` = 1, `Age` = 23, `Band` = 0, `PermBand` = 0, `Warnings` = 0, `Disabled` = 0, `Level` = 1, `AdminLevel` = 0, `DonateRank` = 0, `Respect` = 0, `Money` = 10000, `Bank` = 20000, `pHealth` = 100.000000, `pArmor` = 0.000000, `Int` = 0, `Local` = 255, `VirtualWorld` = 0, `Model` = 0, `SPos_x` = 1697.929565, `SPos_y` = -1849.516723, `SPos_z` = 14.153086, `SPos_r` = 14.669365, `Radio` = 0, `RadioFreq` = 0, `Origin` = 0, `Crimes` = 0, `Accent` = 0, `CHits` = 0, `FHits` = 0, `Arrested` = 0, `Fishes` = 0, `BiggestFish` = 0, `Job` = 0, `Paycheck` = 22, `HeadValue` = 0, `Jailed` = 0, `JailTime` = 0, `Materials` = 0, `Pot` = 0, `Crack` = 0, `Leader` = 0, `Member` = 0, `Division` = 0, `FMember` = 0, `Rank` = 0, `MechSkill` = 0, `TruckSkill` = 0, `FishSkill` = 0, `CheckCash` = 0, `Checks` = 0, `GunLic` = 0, `PayDay` = 1, `PayDayHad` = 0, `CDPlayer` = 0, `Dice` = 0, `Spraycan` = 0, `Rope` = 0, `Cigars` = 0, `Bombs` = 0, `Tutorial` = 0, `OnDuty` = 0, `Hospital` = 0, `Married` = 0, `MarriedTo` = '', `ContractBy` = '', `ContractDetail` = '', `WantedLevel` = 0, `Insurance` = 0, `Helper` = 0, `GiftTime` = 0, `AcceptedHelp` = 0, `AcceptReport` = 0, `TrashReport` = 0, `GangWarn` = 0, `FactionBanned` = 0, `CSFBanned` = 0, `VIPInviteDay` = 0, `TempVIP` = 0, `BuddyInvite` = 0, `Tokens` = 0, `PTokens` = 0, `TriageTime` = 0, `PrisonedBy` = '', `PrisonReason` = '', `Flag` = '', `TicketTime` = 0, `Screwdriver` = 0, `Smslog` = 0, `Wristwatch` = 0, `Surveillance` = 0, `Firstaid` = 0, `Rccam` = 0, `Receiver` = 0, `GPS` = 0, `Sweep` = 0, `SweepLeft` = 0, `Bugged` = 0, `Smslog0` = '', `Smslog1` = '', `Smslog2` = '', `Smslog3` = '', `Smslog4` = '', `Smslog5` = '', `Smslog6` = '', `Smslog7` = '', `Smslog8` = '', `Smslog9` = '', `Warrants` = 0, `JudgeJailTime` = 0, `JudgeJailType` = 0, `BeingSentenced` = 0, `ProbationTime` = 0, `DMKills` = 0, `CallsAccepted` = 0, `PatientsDelivered` = 0, `LiveBanned` = 0, `BizID` = 0, `Hunger` = 0, `Mask` = 0, `MaskNumber` = 0, `Bladder` = 0, `Schem1` = 0, `Schem2` = 0, `Schem3` = 0, `Schem4` = 0, `Schem5` = 0, `Schem6` = 0, `Schem7` = 0, `Schem8` = 0, `Schem9` = 0, `Schem10` = 0, `Schem11` = 0, `Schem12` = 0, `Energy` = 0, `Component` = 0, `Tires` = 0, `PaycheckTime` = 60, `SecTime` = 27, `MinutesTime` = 0, `pv0PosX` = 0.000000, `pv0PosY` = 0.000000, `pv0PosZ` = 0.000000, `pv0PosAngle` = 0.000000, `pv0ModelId` = 0, `pv0Lock` = 0, `pv0Locked` = 0, `pv0PaintJob` = 0, `pv0Color1` = 0, `pv0Color2` = 0, `pv0Price` = 0, `pv0Weapon0` = 0, `pv0Weapon1` = 0, `pv0Weapon2` = 0, `pv0WepUpgrade` = 0, `pv0Fuel` = 0.000000, `pv0Impound` = 0, `pv0Neon` = 0, `pv0NumPlate` = 0, `pv0WeaponAmmo0` = 0, `pv0WeaponAmmo1` = 0, `pv0WeaponAmmo2` = 0, `pv0Health` = 0.000000, `pv0Mod0` = 0, `pv0Mod1` = 0, `pv0Mod2` = 0, `pv0Mod3` = 0, `pv0Mod4` = 0, `pv0Mod5` = 0, `pv0Mod6` = 0, `pv0Mod7` = 0, `pv0Mod8` = 0, `pv0Mod9` = 0, `pv0Mod10` = 0, `pv0Mod11` = 0, `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 0, `pv1PosX` = 0.000000, `pv1PosY` = 0.000000, `pv1PosZ` = 0.000000, `pv1PosAngle` = 0.000000, `pv1ModelId` = 0, `pv1Lock` = 0, `pv1Locked` = 0, `pv1PaintJob` = 0, `pv1Color1` = 0, `pv1Color2` = 0, `pv1Price` = 0, `pv1Weapon0` = 0, `pv1Weapon1` = 0, `pv1Weapon2` = 0, `pv1WepUpgrade` = 0, `pv1Fuel` = 0.000000, `pv1Impound` = 0, `pv1Neon` = 0, `pv1NumPlate` = 0, `pv1WeaponAmmo0` = 0, `pv1WeaponAmmo1` = 0, `pv1WeaponAmmo2` = 0, `pv1Health` = 0.000000, `pv1Mod0` = 0, `pv1Mod1` = 0, `pv1Mod2` = 0, `pv1Mod3` = 0, `pv1Mod4` = 0, `pv1Mod5` = 0, `pv1Mod6` = 0, `pv1Mod7` = 0, `pv1Mod8` = 0, `pv1Mod9` = 0, `pv1Mod10` = 0, `pv1Mod11` = 0, `pv1Mod12` = 0, `pv1Mod13` = 0, `pv1Mod14` = 0, `pv2PosX` = 0.000000, `pv2PosY` = 0.000000, `pv2PosZ` = 0.000000, `pv2PosAngle` = 0.000000, `pv2ModelId` = 0, `pv2Lock` = 0, `pv2Locked` = 0, `pv2PaintJob` = 0, `pv2Color1` = 0, `pv2Color2` = 0, `pv2Price` = 0, `pv2Weapon0` = 0, `pv2Weapon1` = 0, `pv2Weapon2` = 0, `pv2WepUpgrade` = 0, `pv2Fuel` = 0.000000, `pv2Impound` = 0, `pv2Neon` = 0, `pv2NumPlate` = 0, `pv2WeaponAmmo0` = 0, `pv2W) - An error has occured. (Error ID: 1064, 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 '' at line 1)

[22:25:29] OnQueryError() - Called.
Find
Reply
SuperViper
High-roller
*****
Posts: 1,177
Threads: 27
Joined: Sep 2011
Reputation: 0
#10

15.02.2013, 14:19
Your query is getting cut off, you need to increase the string size.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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