Steve_Stage
Новичок
Вот код, в нем допущена какая-то ошибка:
Вот mysql_log:
[22:12:57] [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 '`National`, `Level`, `Referal`, `Referal_Check`) VALUES('%s', '%s', '%s', '%d', ' at line 1
Код:
static
fmt_str[] =
"\
INSERT INTO `accounts` (`Nickname`, `Password`, `Email`, `Sex`, `Skin`, `Age` `National`, `Level`, `Referal`, `Referal_Check`) VALUES\
('%s', '%s', '%s', '%d', '%d', '%d', '%d', '%s', '%d')\
",
fmt_str_2[] = "SELECT * FROM `accounts` WHERE `Nickname` = '%s'";
new
string[sizeof(fmt_str)+MAX_PLAYER_NAME*2+103], //sssss1
string_2[sizeof(fmt_str_2)+MAX_PLAYER_NAME-1];
mysql_format(connect_mysql, string, sizeof(string), fmt_str,
player[playerid][pName], player[playerid][pPass], player[playerid][pMail], player[playerid][pSex], player[playerid][pSkin], player[playerid][pAge],
player[playerid][pNational], player[playerid][pLevel], player[playerid][pReferal], player[playerid][pReferalCheck]);
mysql_format(connect_mysql, string_2, sizeof(string_2), fmt_str_2, player[playerid][pName]);
mysql_function_query(connect_mysql, fmt_str, true, "", "");
mysql_function_query(connect_mysql, fmt_str_2, true, "@_GetID", "i", playerid);
SpawnPlayer(playerid);
[22:12:57] [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 '`National`, `Level`, `Referal`, `Referal_Check`) VALUES('%s', '%s', '%s', '%d', ' at line 1
