toxa1373
Новичок
Всем привет. Сделал /alogin но теперь выдает ошибку.
Код при регистрации в /alogin
Сохранение аккаунта:
HTML:
[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 '`admin` = '1' `pDostup` = 'G' WHERE `id` = '1'' at line 1
PHP:
new query_string[256];
format(query_string, sizeof(query_string), "UPDATE `accounts` SET pDostup = '%s' WHERE `id` = '%d' LIMIT 1",inputtext, PlayerInfo[playerid][pID]);
mysql_function_query(mysql_connect_id, query_string, false, "", "");
Сохранение аккаунта:
PHP:
stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(20+MAX_PLAYER_NAME)+(16+30)] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `name` = '%s',", query_string, PlayerInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, PlayerInfo[playerid][pPassword]);
format(query_string, sizeof(query_string), "%s `admin` = '%d'", query_string, PlayerInfo[playerid][pAdmin]);
format(query_string, sizeof(query_string), "%s `pDostup` = '%s'", query_string, PlayerInfo[playerid][pDostup]);
format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, PlayerInfo[playerid][pID]);
mysql_function_query(mysql_connect_id, query_string, false, "", "");
return 1;
}
Последнее редактирование модератором:
