Скинь OnGameModeInit
Вид для печати
Скинь OnGameModeInit
PHP код:
public OnGameModeExit()
{
for(new i=0; i<MAX_PLAYERS; i++) format(ExitInfo[i][ExitName],5,"None"),ExitInfo[i][ExitTime] = 0;
mysql_function_query(database,"UPDATE `users` SET `onstatus`='0'", false, "", "");
mysql_function_query(database,"DELETE FROM `banlog` WHERE `unban_date` < NOW()",false,"","");
mysql_function_query(database,"DELETE FROM `users` WHERE `pTut`='0'",false,"","");
SaveServer();
mysql_close(database);
}
PHP код:
stock SetServerSetting(host[], user[], db[], pass[])
{
//================ MySQL ========================
//printf("host: %s user - %s database - %s pass: %s",host, user, db, pass);
database = mysql_connect(host, user, db, pass);
if(mysql_errno(database) != 0) SendRconCommand("password ola77b"),print("[Ошибка]: Не удалось соединиться с сервером базы данных!");
//mysql_function_query(database,"SET NAMES cp1251",false,"","");
mysql_function_query(database,"SET NAMES cp1251",false,"","");
//================ Query ========================
mysql_function_query(database,"DELETE FROM `logs` WHERE DATEDIFF(NOW(), `date`) > '7'",false,"","");
mysql_function_query(database,"UPDATE `users` SET `onstatus`='0'", false, "", "");
mysql_function_query(database,"DELETE FROM `banlog` WHERE `unban_date` < NOW()",false,"","");
mysql_function_query(database,"SELECT * FROM `fraction`",false,"LoadFractions","");
mysql_function_query(database,"SELECT * FROM `pickups`", true, "LoadTP","");
mysql_function_query(database,"SELECT * FROM `fstats`", true, "LoadRepa","");
mysql_function_query(database,"SELECT * FROM `houses`", true, "LoadHouses","");
mysql_function_query(database,"SELECT * FROM `ferm`", true, "LoadFerm","");
mysql_function_query(database,"SELECT * FROM `kazino`", true, "LoadKazino","");
mysql_function_query(database,"SELECT * FROM `bizz`", true, "LoadBizz","");
mysql_function_query(database,"SELECT * FROM `sbizz`", true, "LoadSBizz","");
mysql_function_query(database,"SELECT * FROM `mbizz`", true, "LoadMBizz","");
mysql_function_query(database,"SELECT * FROM `avtomas`", true, "LoadAvto","");
mysql_function_query(database,"SELECT * FROM `gangzones`", true, "LoadGangZones","");
mysql_function_query(database,"SELECT * FROM `other`", true, "LoadOther","");
mysql_function_query(database,"SELECT * FROM `cars`", true, "LoadBuyableCars","");
mysql_function_query(database,"SELECT * FROM `fracveh`", true, "LoadFracCars","");
return true;
}
И потом логи в студию (Вызвать краш нужно)PHP код:
public OnGameModeExit()
{
for (new i = 0; i<MAX_PLAYERS; i++) format(ExitInfo[i][ExitName], 5, "None"), ExitInfo[i][ExitTime] = 0;
mysql_log(LOG_ALL);
mysql_function_query(database, "UPDATE `users` SET `onstatus`='0'", false, "", "");
mysql_function_query(database, "DELETE FROM `banlog` WHERE `unban_date` < NOW()", false, "", "");
mysql_function_query(database, "DELETE FROM `users` WHERE `pTut`='0'", false, "", "");
SaveServer();
mysql_close(database);
}
краша больше не заметно, может это потому что я обновил пару плагинов, но теперь у меня проблема с кодировкой
И это не при загрузке текста, а при сохранение, потому что название не меняется в запросе UPDATE.
кодировка баз utf8, а при старте я даю запрос
http://img.uz/d/2015/10/56213925b4746.pngКод:SET NAMES cp1251
Другая проблема - новая тема.
Ну так и быть помогу тут:
После подключение к серверу хоста средствами mysql (mysql_connect) вставьте следующие:
PHP код:
mysql_set_charset("utf8_bin");
mysql_function_query(handle, "SET NAMES 'utf8'", false, "", "");
mysql_function_query(handle, "SET CHARACTER SET 'cp1251'", false, "", "");
к сожалению вновь тот краш
из server_log.txt:
из mysql_log.txt:Код:[23:08:02] * [MySQL]: Lost connection to MySQL server during query
[23:08:02] * [Query]: SELECT `Name` FROM `users` WHERE `Name`='Scooter_Brown'
а насчет кодироки:Код:[23:08:02] [ERROR] CMySQLQuery::Execute[OnPlayerRegister] - (error #2013) Lost connection to MySQL server during query
все еще ?????? вместо русских букв уже, и так же при загрузкеКод:[23:08:02] [ERROR] CMySQLQuery::Execute[OnPlayerRegister] - (error #2013) Lost connection to MySQL server during query
Запрос загрузки лидеров:
PHP код:
cache_get_field_content(i,"fLeader",FracInfo[i][fLeader],database,MAX_PLAYER_NAME);
Version include and plugin in studio!
Покажите mysql_connect