Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Не создается аккаунт при регистрации MySQL R39

Статус
В этой теме нельзя размещать новые ответы.

Paul_Denton

Новичок
Здравствуйте. При регистрации не создается аккаунт, с чем это связано?

PHP:
case DIALOG_REGISTER:
        {
            if (!response) return Kick(playerid);
            if(response)
            {
				if(!strlen(inputtext) || strlen(inputtext) < 6 || strlen(inputtext) > 64)
				{
				        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD,""COL_BLUE"Регистрация",""Короткий или длинный пароль", "ОК", "");
					return 1;
				}
				PlayerInfo[playerid][pPass][0] = EOS;
        		        strins(PlayerInfo[playerid][pPass], inputtext, 0);
				CreateNewAccount(playerid, inputtext);
            }
        }
PHP:
stock CreateNewAccount(playerid, password[])
{
        new query_string[66+MAX_PLAYER_NAME-4+100];
        format(query_string, sizeof(query_string), "INSERT INTO `playerinfo` (`NICKNAME`, `PASSWORD`, `ADMIN`, `SCORE`, `CASH`, `MUTED`, `MUTETIME`, `PRISONED`, `PRISONTIME`, `VIP`) VALUES ('%s', '%s', 0, 0, 0, 0, 0, 0, 0, 0)", PlayerInfo[playerid][pName], password);
        mysql_function_query(mysql_connect_ID, query_string, true, "UploadPlayerAccountNumber", "i", playerid);
	restriction[playerid] = 1;
	ShowPlayerDialog(playerid, DIALOG_SUCCESS_1, DIALOG_STYLE_MSGBOX,""COL_BLUE"Регистрация", ""COL_WHITE"Зарегистрировались", "ОК", "");
        return 1;
}
PHP:
forward UploadPlayerAccountNumber(playerid);
public UploadPlayerAccountNumber(playerid) PlayerInfo[playerid][pID] = cache_insert_id(mysql_connect_ID);
Логи MySQL:

PHP:
[15:20:19] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playerinfo` WHERE `NICKNAME` = 'Paul_Denton'", callback: "FindPlayerInTable", format: "i"
[15:20:19] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - starting query execution
[15:20:19] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - query was successfully executed within 0.88 milliseconds
[15:20:19] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:20:19] [DEBUG] Calling callback "FindPlayerInTable"..
[15:20:19] [DEBUG] cache_get_data - connection: 1
[15:20:19] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:20:30] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `playerinfo` (`NICKNAME`, `PASSWORD`, `ADMIN`, `SCOR", callback: "UploadPlayerAccountNumber", format: "i"
[15:20:30] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccountNumber] - starting query execution
[15:20:30] [ERROR] CMySQLQuery::Execute[UploadPlayerAccountNumber] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[15:20:30] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccountNumber] - error will be triggered in OnQueryError
[15:20:30] [DEBUG] Calling callback "OnQueryError"..
[15:21:10] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerinfo` SET WHERE `ID` = '0' `NICKNAME` = 'Paul_Dent", callback: "(null)", format: "(null)"
[15:21:10] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[15:21:10] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `ID` = '0' `NICKNAME` = 'Paul_Denton', `PASSWORD` = '465hsd674' WHERE `AD' at line 1
[15:21:10] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[15:21:10] [DEBUG] Calling callback "OnQueryError"..
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу