PDA

Просмотр полной версии : [Вопрос] [ERROR] CMySQLQuery::Execute[] - (error #1064)


ALIT13
12.12.2015, 21:55
[23:45:59] [ERROR] CMySQLQuery::Execute[] - (error #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 '`Sex` = '1' `Cash` = '270970' `Level` = '1' `Email` = '@mqil.ru', `HouseKey` = '' at line 1
в чем проблема

stock SavePlayer(playerid)
{
if(GetPVarInt(playerid,"Logged") > 0)
{
new query[800] = "UPDATE `Accounts` SET ";

format(query, sizeof(query), "%s `Skin` = '%d'", query, PlayerInfo[playerid][pSkin]);
format(query, sizeof(query), "%s `Sex` = '%d'", query, PlayerInfo[playerid][pSex]);
format(query, sizeof(query), "%s `Cash` = '%d'", query, GetPlayerMoney(playerid));
format(query, sizeof(query), "%s `Level` = '%d'", query, PlayerInfo[playerid][pLevel]);
format(query, sizeof(query), "%s `Email` = '%s',", query, PlayerInfo[playerid][pEmail]);

format(query, sizeof(query), "%s `HouseKey` = '%d',", query, PlayerInfo[playerid][pHouseKey]);
format(query, sizeof(query), "%s `SaleHouse` = '%d',", query, PlayerInfo[playerid][pSaleHouse]);
format(query, sizeof(query), "%s `Car` = '%d',", query, PlayerInfo[playerid][pCar]);

format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid));
mysql_function_query(mysql_variable, query, false, "", "");
}
return true;
}
Desulaid
12.12.2015, 22:15
То ли я такая Ванга, то ли ответ когда-то давно был дан, ибо я туплю :D


stock SavePlayer(playerid)
{
if(GetPVarInt(playerid,"Logged") > 0)
{
new query[800] = "UPDATE `Accounts` SET ";

format(query, sizeof(query), "%s `Skin` = '%d',", query, PlayerInfo[playerid][pSkin]);
format(query, sizeof(query), "%s `Sex` = '%d',", query, PlayerInfo[playerid][pSex]);
format(query, sizeof(query), "%s `Cash` = '%d,'", query, GetPlayerMoney(playerid));
format(query, sizeof(query), "%s `Level` = '%d',", query, PlayerInfo[playerid][pLevel]);
format(query, sizeof(query), "%s `Email` = '%s',", query, PlayerInfo[playerid][pEmail]);

format(query, sizeof(query), "%s `HouseKey` = '%d',", query, PlayerInfo[playerid][pHouseKey]);
format(query, sizeof(query), "%s `SaleHouse` = '%d',", query, PlayerInfo[playerid][pSaleHouse]);
format(query, sizeof(query), "%s `Car` = '%d',", query, PlayerInfo[playerid][pCar]);

format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid));
mysql_function_query(mysql_variable, query, false, "", "");
}
return true;
}
ALIT13
12.12.2015, 22:44
щяс так
[ERROR] CMySQLQuery::Execute[] - (error #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 'WHERE `Name` = 'Andr_Silva'' at line 1
Desulaid
12.12.2015, 22:55
stock SavePlayer(playerid)
{
if(GetPVarInt(playerid,"Logged") > 0)
{
new query[800] = "UPDATE `Accounts` SET ";

format(query, sizeof(query), "%s `Skin` = '%d',", query, PlayerInfo[playerid][pSkin]);
format(query, sizeof(query), "%s `Sex` = '%d',", query, PlayerInfo[playerid][pSex]);
format(query, sizeof(query), "%s `Cash` = '%d',", query, GetPlayerMoney(playerid));
format(query, sizeof(query), "%s `Level` = '%d',", query, PlayerInfo[playerid][pLevel]);
format(query, sizeof(query), "%s `Email` = '%s',", query, PlayerInfo[playerid][pEmail]);

format(query, sizeof(query), "%s `HouseKey` = '%d',", query, PlayerInfo[playerid][pHouseKey]);
format(query, sizeof(query), "%s `SaleHouse` = '%d',", query, PlayerInfo[playerid][pSaleHouse]);
format(query, sizeof(query), "%s `Car` = '%d'", query, PlayerInfo[playerid][pCar]);

format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid));
mysql_function_query(mysql_variable, query, false, "", "");
}


Вот точно должно сейчас работать :)
L0ndl3m
12.12.2015, 23:08
format(query, sizeof(query), "%s `Cash` = '%d,'", query, GetPlayerMoney(playerid));


Вот точно должно сейчас работать :)
Не думаю.
Desulaid
12.12.2015, 23:17
Не думаю.

А теперь передумывай.
$continue$
13.12.2015, 00:22
А теперь передумывай.
SQL Injection хотите словить... Дело Ваше.