Проблема Сохранение аккаунта

[Zishka 4]

Привет. 

Кто может помочь, у меня если зайдет новый игрок то у него просто не появляется диалог и появляется варн в логах mysql, я не понял из-за чего это, хостинг менял.

 

 

Лог mysql

[23:41:54] >> mysql_query_callback(Connection handle: 1)
[23:41:54] ProcessQueryThread(RegisterCallback) - Executing query INSERT INTO `users` (`pName`, `pKey`, `pRegIP`, `pRegData`) VALUE ('ByhaIIIka_Offensive', 'скрыт', 'скрыт', '04.09.20...
[23:41:54] ProcessQueryThread(RegisterCallback) - Error will be triggered to OnQueryError().
[23:41:54] OnQueryError() - Callback has been called.
[23:42:32] >> mysql_query_callback(Connection handle: 1)
[23:42:32] ProcessQueryThread(OnPlayerRegCheck) - Executing query SELECT `pName` FROM `users` WHERE `pName` = 'ByhaIIIka_Offensive'...
[23:42:32] ProcessQueryThread(OnPlayerRegCheck) - Query was successful.
[23:42:32] ProcessQueryThread(OnPlayerRegCheck) - Data caching enabled.
[23:42:32] CMySQLHandler::StoreResult() - Result was stored.
[23:42:32] CMySQLHandler::FreeResult() - Result was successfully freed.
[23:42:32] ProcessQueryThread(OnPlayerRegCheck) - Data being passed to ProcessTick().
[23:42:32] OnPlayerRegCheck(d) - Callback has been called.
[23:42:32] >> cache_get_data(Connection handle: 1)
[23:42:32] ProcessTick() - The cache has been cleared.
[23:42:35] >> mysql_query_callback(Connection handle: 1)
[23:42:35] ProcessQueryThread(RegisterCallback) - Executing query INSERT INTO `users` (`pName`, `pKey`, `pRegIP`, `pRegData`) VALUE ('ByhaIIIka_Offensive', 'скрыт', 'скрыт', '04.09.20...
[23:42:35] ProcessQueryThread(RegisterCallback) - Error will be triggered to OnQueryError().
[23:42:35] OnQueryError() - Callback has been called.

Код

stock OnPlayerRegister(playerid, password[])
{
    new str[128], data[16];
	format(data, sizeof(data), "%s", date("%dd.%mm.%yyyy", gettime()));
    format(str, sizeof(str), "INSERT INTO `users` (`pName`, `pKey`, `pRegIP`, `pRegData`) VALUE ('%s', '%s', '%s', '%s')", PInfo[playerid][pName], password, PInfo[playerid][pIP], data);
    mysql_function_query(ConnectBD, str, false, "RegisterCallback","d", playerid);
    return true;
}

--

ConnectMySQL()
{
	ConnectBD = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
	switch(mysql_ping()) {
	case 1: print(" БД MySQL успешно подключена."),SendRconCommand("mapname Criminal Russia");
	case -1: print(" БД MySQL не подключена. "),SendRconCommand("mapname нет коннекта"), SetGameModeText("Зомби | ZDM (N.C)");
	}
	return true;
}

Изменено 4 сентября, 2018 пользователем Zishka

[Zishka 4]

Проблема решена. Проблема была в mxdate