Paul_Denton
Новичок
Здравствуйте. При регистрации не создается аккаунт, с чем это связано?
Логи MySQL:
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);
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"..
Последнее редактирование:
