15.02.2013, 04:34
Hey, when Im logout from the server, there's a query error, this is the error
The 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] 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
Код:
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);