Скинь OnGameModeInit
Скинь OnGameModeInit
Value your freedom or you will lose it, teaches history. "Don't bother us with politics," respond those who don't want to learn. (c) Richard Stallman
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);
}
Последний раз редактировалось $continue$; 16.10.2015 в 21:37. Причина: UPD / Time: 20:37 / MSK
Value your freedom or you will lose it, teaches history. "Don't bother us with politics," respond those who don't want to learn. (c) Richard Stallman
Другая проблема - новая тема.
Ну так и быть помогу тут:
После подключение к серверу хоста средствами 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, "", "");
Value your freedom or you will lose it, teaches history. "Don't bother us with politics," respond those who don't want to learn. (c) Richard Stallman
Unreal (16.10.2015)
к сожалению вновь тот краш
из 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!
Value your freedom or you will lose it, teaches history. "Don't bother us with politics," respond those who don't want to learn. (c) Richard Stallman
Покажите mysql_connect
Value your freedom or you will lose it, teaches history. "Don't bother us with politics," respond those who don't want to learn. (c) Richard Stallman
Эту тему просматривают: 1 (пользователей: 0 , гостей: 1)