09.11.2013, 02:42
Queria saber oque fiz de errado, para dar esse error:
Code:
Код:
[01:34:27] Error #1064 - Error: 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 '', `PosicaoY` = 0.03500, `PosicaoZ` = 0.00000, `RotacaoX` = 90.00000, `RotacaoY` = 180.00000, `R' at line 1 | Query: UPDATE `acessorios` SET `Dono` = '23', `Modelo` = 18911, `Espinha` = 2, `PosicaoX` = 0.04700', `PosicaoY` = 0.03500, `PosicaoZ` = 0.00000, `RotacaoX` = 90.00000, `RotacaoY` = 180.00000, `RotacaoZ` = 90.00000, `EscalaX` = 1.00000, `EscalaY` = 1.00000, `EscalaZ` = 1.00000 WHERE `ID` = '179' | Callback: OnQueryFinish
Код:
format(mysql_string, sizeof(mysql_string), "UPDATE `acessorios` SET"); format(mysql_string, sizeof(mysql_string), "%s `Dono` = '%d',", mysql_string, PlayerVariaveis[playerid][playerSQLID]); format(mysql_string, sizeof(mysql_string), "%s `Modelo` = %d,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_Modelo]); format(mysql_string, sizeof(mysql_string), "%s `Espinha` = %d,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_Espinha]); format(mysql_string, sizeof(mysql_string), "%s `PosicaoX` = %0.5f',", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_PosicaoX]); format(mysql_string, sizeof(mysql_string), "%s `PosicaoY` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_PosicaoY]); format(mysql_string, sizeof(mysql_string), "%s `PosicaoZ` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_PosicaoZ]); format(mysql_string, sizeof(mysql_string), "%s `RotacaoX` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_RotacaoX]); format(mysql_string, sizeof(mysql_string), "%s `RotacaoY` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_RotacaoY]); format(mysql_string, sizeof(mysql_string), "%s `RotacaoZ` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_RotacaoY]); format(mysql_string, sizeof(mysql_string), "%s `EscalaX` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_EscalaX]); format(mysql_string, sizeof(mysql_string), "%s `EscalaY` = %0.5f,", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_EscalaY]); format(mysql_string, sizeof(mysql_string), "%s `EscalaZ` = %0.5f", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_EscalaZ]); format(mysql_string, sizeof(mysql_string), "%s WHERE `ID` = '%d'", mysql_string, PlayersAcessorios[playerid][slotid][acessorio_ID]); mysql_function_query(conectar_mysql[0], mysql_string, false, "CarregarAcessorios", "ii", SENDDATA_THREAD, playerid);