jeffreymcdon
Ученик
[10:52:39] [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 '`Skin` = '73',`Sex` = '1',`Money` = '0',`Admin` = '0',`Mail` = '54321',`Age` = '' at line 1
[10:52:39] [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 '`Skin` = '73',`Sex` = '1',`Money` = '0',`Admin` = '0',`Mail` = '54321',`Age` = '' at line 1
[10:52:39] [ERROR] CMySQLQuery::Execute[Registr] - (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 ''Mail', 'Age') VALUES ('TEST_ARE1234', '1', '73', '1', 'pass123', '0', '54321' at line 1
Вот что в mysql_log выдало, не пойму где ошибка
[10:52:39] [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 '`Skin` = '73',`Sex` = '1',`Money` = '0',`Admin` = '0',`Mail` = '54321',`Age` = '' at line 1
[10:52:39] [ERROR] CMySQLQuery::Execute[Registr] - (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 ''Mail', 'Age') VALUES ('TEST_ARE1234', '1', '73', '1', 'pass123', '0', '54321' at line 1
Вот что в mysql_log выдало, не пойму где ошибка
Код:
stock SavePlayer(i)
{
new scr[128];
new string[320];
f("UPDATE `accounts` SET ");
format(scr, sizeof(scr), "`Level` = '%d'", Player[i][pLevel]);
strcat(string, scr);
format(scr, sizeof(scr), "`Skin` = '%d',", Player[i][pSkin]);
strcat(string, scr);
format(scr, sizeof(scr), "`Sex` = '%d',", Player[i][pSex]);
strcat(string, scr);
format(scr, sizeof(scr), "`Money` = '%d',", Player[i][pMoney]);
strcat(string, scr);
format(scr, sizeof(scr), "`Admin` = '%d',", Player[i][pAdmin]);
strcat(string, scr);
format(scr,sizeof(scr), "`Mail` = '%s',",Player[i][pMail]);
strcat(string,scr);
format(scr,sizeof(scr), "`Age` = '%d',",Player[i][pAge]);
strcat(string,scr);
format(scr,sizeof(scr), "`Pass` = '%s'",Player[i][pPass]);
strcat(string,scr);
format(scr, sizeof(scr), " WHERE `Name` = '%s'", Player[i][pName]);
strcat(string, scr, sizeof(string));
mysql_function_query(ConnectMySQL, string, false, "", "");
Player[i][pMoney] = Money(i);
mysql_function_query(ConnectMySQL, string, true, "", "");
}
