Артемиано
Ученик
Всем добрый день уважаемые пользователи P-I.
Требуется помощь, нет сохранения аккаунтов.
Требуется помощь, нет сохранения аккаунтов.
Вот ошибка с MySQL Log
PHP:
[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 '`nickname` = 'Artem_Nyashev', `password` = 'qwerty123' `skin` = ';' `level` = '' at line 1
PHP:
if(pInfo[playerid][pLogin] == true) {}
new query_string[386];
format(query_string, sizeof(query_string), "%s `nickname` = '%s',", query_string, pInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, pInfo[playerid][pPassword]);
format(query_string, sizeof(query_string), "%s `skin` = '%s'", query_string, pInfo[playerid][pSkin]);
format(query_string, sizeof(query_string), "%s `level` = '%s'", query_string, pInfo[playerid][pLevel]);
format(query_string, sizeof(query_string), "%s `exp` = '%s'", query_string, pInfo[playerid][pExp]);
format(query_string, sizeof(query_string), "%s `admin` = '%s'", query_string, pInfo[playerid][pAdmin]);
format(query_string, sizeof(query_string), "%s `dostup` = '%s'", query_string, pInfo[playerid][pDostup]);
format(query_string, sizeof(query_string), "%s WHERE `nickname` = '%s'", query_string, pInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
