MySQL Not Saving - Printable Version

MySQL Not Saving - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Not Saving (/showthread.php?tid=415661)

MySQL Not Saving - RenovanZ - 14.02.2013

Hey Guys, I've converted my script from Y_INI to MySQL Database, and I trying to test the private server on my localhost, when I login and logout I got a notified from the server-samp.exe that there's Query error, after that, I checking the MySQL Database from phpMyAdmin is not saving, this is the serverlog

Code:

[14/02/2013 12:57:29] Incoming connection: 10.76.58.77:49277
[14/02/2013 12:57:29] [join] Sql_Test has joined the server (0:10.76.58.77)
[14/02/2013 12:57:52] Sql_Test has logged in.
[14/02/2013 12:57:52]  Loading Sql_EverydayTest's vehicles.
[14/02/2013 12:57:52]  Loading all vehicles mods.
[14/02/2013 12:57:52] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1054)
[14/02/2013 12:57:52] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 12:59:15] [zcmd] [Sql Test]: /stats
[14/02/2013 12:59:43] [zcmd] [Sql Test]: /b a
[14/02/2013 13:14:29] [zcmd] [Sql Test]: /ss
[14/02/2013 13:14:31] [zcmd] [Sql Test]: /stats
[14/02/2013 13:16:31]  Unloading Sql_Test's vehicles.
[14/02/2013 13:16:31] [part] Sql_EverydayTest has left the server (0:1)
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1064)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[14/02/2013 13:16:31] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1054)
[14/02/2013 13:16:31] [MySQL] Check /logs/querydump.log to review the query that threw the error.

Please Help

Re: MySQL Not Saving - Vince - 14.02.2013

And what are we supposed to do about it if we can't see the query that generated the error in the first place?

Re: MySQL Not Saving - RenovanZ - 14.02.2013

Debug.txt

Code:

[12:57:42] CMySQLHandler::Query(resultID) - Threaded query with id 3 started. (Extra ID: 0)

[12:57:43] CMySQLHandler::ProcessQueryThread(SELECT Username from users WHERE Username = 'Sql_Test') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[12:57:43] OnQueryFinish(3,"SELECT Username from users WHERE Username = 'Sql_Test'") - Called.

[12:57:43] >> mysql_store_result( Connection handle: 1 )

[12:57:43] CMySQLHandler::StoreResult() - Result was stored.

[12:57:43] >> mysql_num_rows( Connection handle: 1 )

[12:57:43] CMySQLHandler::NumRows() - Returned 0 row(s)

[12:57:43] >> mysql_free_result( Connection handle: 1 )

[12:57:43] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(SELECT Username from users WHERE Username = 'Sql_Test') - Successfully executed.

[12:57:48] >> mysql_store_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::StoreResult() - Result was stored.

[12:57:48] >> mysql_num_rows( Connection handle: 1 )

[12:57:48] CMySQLHandler::NumRows() - Returned 0 row(s)

[12:57:48] >> mysql_free_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(SELECT Username from users WHERE Username = 'Sql_Test') - Successfully executed.

[12:57:48] >> mysql_store_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::StoreResult() - Result was stored.

[12:57:48] >> mysql_num_rows( Connection handle: 1 )

[12:57:48] CMySQLHandler::NumRows() - Returned 0 row(s)

[12:57:48] >> mysql_free_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(INSERT INTO `users` (`Username`, `Key`) VALUES ('Sql_Test','fckz}–ѓ€ЌЏЏ')) - Successfully executed.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(SELECT Username from users WHERE Username = 'Sql_Test') - Successfully executed.

[12:57:48] >> mysql_store_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::StoreResult() - Result was stored.

[12:57:48] >> mysql_num_rows( Connection handle: 1 )

[12:57:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[12:57:48] >> mysql_free_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(SELECT `Key` from users WHERE Username = 'Sql_Test') - Successfully executed.

[12:57:48] >> mysql_store_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::StoreResult() - Result was stored.

[12:57:48] >> mysql_retrieve_row( Connection handle: 1 )

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Key") - fckz}–ѓ€ЌЏЏ

[12:57:48] >> mysql_free_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:48] >> mysql_query( Connection handle: 1 )

[12:57:48] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: 0)

[12:57:48] CMySQLHandler::ProcessQueryThread(SELECT * FROM `users` WHERE `Username` = 'Sql_Test') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[12:57:48] OnQueryFinish(1,"SELECT * FROM `users` WHERE `Username` = 'Sql_Test'") - Called.

[12:57:48] >> mysql_store_result( Connection handle: 1 )

[12:57:48] CMySQLHandler::StoreResult() - Result was stored.

[12:57:48] >> mysql_retrieve_row( Connection handle: 1 )

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("IP") - NULL

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("AccountID") - 3

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("ConnectedTime") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Sex") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Band") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("PermBand") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Warnings") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Disabled") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Level") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("AdminLevel") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("DonateRank") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Respect") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Money") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Bank") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("pHealth") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("pArmor") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Int") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Local") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("VirtualWorld") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Model") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("SPos_x") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("SPos_y") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("SPos_z") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("SPos_r") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Radio") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("RadioFreq") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Origin") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Crimes") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Accent") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("CHits") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FHits") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Arrested") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Fishes") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("BiggestFish") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Job") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Paycheck") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("HeadValue") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Jailed") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("JailTime") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Materials") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Pot") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Crack") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Leader") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Member") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Division") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FMember") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Rank") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("MechSkill") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("TruckSkill") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FishSkill") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FightingStyle") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("PhoneNr") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Apartment") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("CarLic") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FlyLic") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("BoatLic") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("FishLic") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("CheckCash") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Checks") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("GunLic") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("PayDay") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("PayDayHad") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("CDPlayer") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Dice") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Spraycan") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Rope") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Cigars") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Bombs") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Tutorial") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("OnDuty") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Hospital") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Married") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("MarriedTo") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("ContractBy") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("ContractDetail") - 

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("WantedLevel") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Insurance") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("Helper") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("GiftTime") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("AcceptedHelp") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("AcceptReport") - 0

[12:57:48] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:48] CMySQLHandler::FetchField("TrashReport") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("GangWarn") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("FactionBanned") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("CSFBanned") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pVIPInviteDay") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("TempVIP") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("BuddyInvite") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Tokens") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("PTokens") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("TriageTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("PrisonedBy") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("PrisonReason") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Flag") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("TicketTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Screwdriver") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Wristwatch") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Surveillance") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Firstaid") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Rccam") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Receiver") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("GPS") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Sweep") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("SweepLeft") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Bugged") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog0") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog1") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog2") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog3") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog4") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog5") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog6") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog7") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog8") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Smslog9") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Warrants") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("JudgeJailTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("JudgeJailType") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("ProbationTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("DMKills") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("CallsAccepted") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("PatientsDelivered") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("LiveBanned") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("BizID") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Hunger") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Mask") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("MaskNumber") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Bladder") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem1") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem2") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem3") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem4") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem5") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem6") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem7") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem8") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem9") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem10") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem11") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Schem12") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Energy") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Component") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("Tires") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("PaycheckTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("SecTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("MinutesTime") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0PosX") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0PosY") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0PosZ") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0PosAngle") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0ModelId") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Lock") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Locked") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0PaintJob") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Color1") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Color2") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Price") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Ticket") - 

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Weapon0") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Weapon1") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Weapon2") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0WepUpgrade") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Fuel") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Impound") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:49] CMySQLHandler::FetchField("pv0Neon") - 0

[12:57:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0NumPlate") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0WeaponAmmo0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0WeaponAmmo1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0WeaponAmmo2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Health") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod3") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod4") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod5") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod6") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod7") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod8") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod9") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod10") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod11") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod12") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod13") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv0Mod14") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1PosX") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1PosY") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1PosZ") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1PosAngle") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1ModelId") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Lock") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Locked") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1PaintJob") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Color1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Color2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Price") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Ticket") - 

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Weapon0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Weapon1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Weapon2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1WepUpgrade") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Fuel") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Impound") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Neon") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1NumPlate") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1WeaponAmmo0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1WeaponAmmo1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1WeaponAmmo2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Health") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod3") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod4") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod5") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod6") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod7") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod8") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod9") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod10") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod11") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod12") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod13") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv1Mod14") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2PosX") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2PosY") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2PosZ") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2PosAngle") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2ModelId") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Lock") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Locked") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2PaintJob") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Color1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Color2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Price") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Ticket") - 

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Weapon0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Weapon1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Weapon2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2WepUpgrade") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Fuel") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Impound") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Neon") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2NumPlate") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2WeaponAmmo0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2WeaponAmmo1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2WeaponAmmo2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Health") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod0") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod1") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod2") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod3") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod4") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod5") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod6") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod7") - 0

[12:57:50] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:50] CMySQLHandler::FetchField("pv2Mod8") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod9") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod10") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod11") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod12") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod13") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pv2Mod14") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0PosY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0RotY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0RotZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0ScaleX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0ScaleY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt0ScaleZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1PosY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1RotY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1RotZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1ScaleX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1ScaleY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt1ScaleZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2PosY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2RotY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2RotZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2ScaleX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2ScaleY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt2ScaleZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3PosY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3RotY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3RotZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3ScaleX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3ScaleY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt3ScaleZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt42PosY") - 

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4RotY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4RotZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4ScaleX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4ScaleY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt4ScaleZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5ModelId") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5Bone") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5PosX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5PosY") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5PosZ") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5RotX") - 0

[12:57:51] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:51] CMySQLHandler::FetchField("pt5RotY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt5RotZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt5ScaleX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt5ScaleY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt5ScaleZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6ModelId") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6Bone") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6PosX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6PosY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6PosZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6RotX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6RotY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6RotZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6ScaleX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6ScaleY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt6ScaleZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7ModelId") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7Bone") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7PosX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7PosY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7PosZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7RotX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7RotY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7RotZ") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7ScaleX") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7ScaleY") - 0

[12:57:52] >> mysql_fetch_field_row( Connection handle: 1 )

[12:57:52] CMySQLHandler::FetchField("pt7ScaleZ") - 0

[12:57:52] >> mysql_free_result( Connection handle: 1 )

[12:57:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[12:57:52] >> mysql_query( Connection handle: 1 )

[12:57:52] CMySQLHandler::Query(SET SQL_SAFE_UPDATES=0;) - Successfully executed.

[12:57:52] >> mysql_query( Connection handle: 1 )

[12:57:52] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[12:57:52] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[12:57:52] OnQueryError() - Called.

[13:16:29] >> mysql_query( Connection handle: 1 )

[13:16:29] CMySQLHandler::Query(SET SQL_SAFE_UPDATES=0;) - Successfully executed.

[13:16:29] >> mysql_query( Connection handle: 1 )

[13:16:29] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:29] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:29] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:29] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:29] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:29] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:29] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:29] >> mysql_query( Connection handle: 1 )

[13:16:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:30] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

 to OnQueryError()

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_real_escape_string( Connection handle: 1 )

[13:16:30] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:16:30] >> mysql_query( Connection handle: 1 )

[13:16:30] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:30] >> mysql_query( Connection handle: 1 )

[13:16:30] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:30] >> mysql_query( Connection handle: 1 )

[13:16:30] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:30] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::ProcessQueryThread(UPDATE `users` SET `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 WHERE `Username` = 'Sql_Test') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(SET SQL_SAFE_UPDATES=0;) - Successfully executed.

[13:16:31] >> mysql_query( Connection handle: 1 )

[13:16:31] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:16:31] OnQueryError() - Called.

[13:16:31] OnQueryFinish(2,"UPDATE `users` SET `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 WHERE `Username` = 'Sql_Test'") - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

Thread() - Error will be triggered to OnQueryError()

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:16:31] OnQueryError() - Called.

[13:16:31] OnQueryError() - Called.

[13:16:31] OnQueryError() - Called.

querydump.log

Code:

[2013/2/14 - 12:57:52] UPDATE `users` SET `Online` = 1 WHERE Username = 'Sql_Test'
[2013/2/14 - 13:16:31] UPDATE `users` SET `IP` = '10.76.58.77', `AccountID` = '3', `Registered` = 1, `ConnectedTime` = 0, `Sex` = 1, `Age` = 23, `Band` = 0[2013/2/14 - 13:16:31] UPDATE `users` SET `PayDay` = 1, `PayDayHad` = 0, `CDPlayer` = 0, `Dice` = 0, `Spraycan` = 0, `Rope` = 0, `Cigars` = 0, `Bombs` = 0,[2013/2/14 - 13:16:31]  `pv0PosX` = 0.000000, `pv0PosY` = 0.000000, `pv0PosZ` = 0.000000, `pv0PosAngle` = 0.000000, `pv0ModelId` = 0, `pv0Lock` = 0, `pv0Lo[2013/2/14 - 13:16:31]  `pv0Mod12` = 0, `pv0Mod13` = 0, `pv0Mod14` = 83 WHERE `Username` = ''
[2013/2/14 - 13:16:31]  `pv1PosX` = 0.000000, `pv1PosY` = 0.000000, `pv1PosZ` = 0.000000, `pv1PosAngle` = 0.000000, `pv1ModelId` = 0, `pv1Lock` = 0, `pv1Lo[2013/2/14 - 13:16:31]  `pv1Mod12` = 0, `pv1Mod13` = 0, `pv1Mod14` = 83 WHERE `Username` = ''
[2013/2/14 - 13:16:31]  `pv2PosX` = 0.000000, `pv2PosY` = 0.000000, `pv2PosZ` = 0.000000, `pv2PosAngle` = 0.000000, `pv2ModelId` = 0, `pv2Lock` = 0, `pv2Lo[2013/2/14 - 13:16:31]  `pv2Mod12` = 0, `pv2Mod13` = 0, `pv2Mod14` = 83 WHERE `Username` = ''
[2013/2/14 - 13:16:31]  `pt1ModelId` = 0, `pt1Bone` = 0, `pt1PosX` = 0.000000, `pt1PosY` = 0.000000, `pt1PosZ` = 0.000000, `pt1RotX` = 0.000000, `pt1RotY` [2013/2/14 - 13:16:31]  `pt3ModelId` = 0, `pt3Bone` = 0, `pt3PosX` = 0.000000, `pt3PosY` = 0.000000, `pt3PosZ` = 0.000000, `pt3RotX` = 0.000000, `pt3RotY` [2013/2/14 - 13:16:31]  `pt5ModelId` = 0, `pt5Bone` = 0, `pt5PosX` = 0.000000, `pt5PosY` = 0.000000, `pt5PosZ` = 0.000000, `pt5RotX` = 0.000000, `pt5RotY` [2013/2/14 - 13:16:31]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/14 - 13:16:31] UPDATE `users` SET `Online` = 0 WHERE Username = 'Sql_Test'

Re: MySQL Not Saving - 3ventic - 14.02.2013

Why are there timestamps in middle of the queries in querydump.log?

Re: MySQL Not Saving - Boooth - 14.02.2013

There is obviously something wrong with the formatting of your Player Data Loading query, unless you display the query from your script, I'm afraid there is not alot we can do.

Re: MySQL Not Saving - RenovanZ - 14.02.2013

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;

Re: MySQL Not Saving - RenovanZ - 14.02.2013

Anyone ?

Re: MySQL Not Saving - adsy - 14.02.2013

if every single one of those is a query?
do you clear the query before you start?
do you query every one after formatting it? (your code above doesnt)
is your query variable BIG enough? ie query[256] or query[512]

Re: MySQL Not Saving - RenovanZ - 14.02.2013

Quote:

Originally Posted by adsy

if every single one of those is a query?
do you clear the query before you start?
do you query every one after formatting it? (your code above doesnt)
is your query variable BIG enough? ie query[256] or query[512]

I've make query variable is big, and now I got this query error

Code:

[2013/2/14 - 19:27:17]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` [2013/2/14 - 19:27:17] OnQueryFinish
[2013/2/14 - 19:27:17] 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/14 - 19:30:1]  `pt7ModelId` = 0, `pt7Bone` = 0, `pt7PosX` = 0.000000, `pt7PosY` = 0.000000, `pt7PosZ` = 0.000000, `pt7RotX` = 0.000000, `pt7RotY` =[2013/2/14 - 19:30:1] OnQueryFinish
[2013/2/14 - 19:30:1] 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

Re: MySQL Not Saving - RenovanZ - 14.02.2013

Anyone ?