[14:30:41] [connection] 84.213.122.212:62120 requests connection cookie. [14:30:42] [connection] incoming connection: 84.213.122.212:62120 id: 11 [14:30:42] [query:i] from 109.96.26.231 [14:30:42] [query:p] from 109.96.26.231 [14:30:42] [query:c] from 109.96.26.231 [14:30:42] [query:r] from 109.96.26.231 [14:30:42] [query:p] from 109.96.26.231 [14:30:42] [join] Arge has joined the server (11:46.214.147.220) [14:30:42] Player Arge (11) reports client version: 0.3.7 [14:30:43] [query:i] from 149.202.241.189 [14:30:43] [query:r] from 149.202.241.189 [14:30:43] [query:d] from 149.202.241.189 [14:30:44] [query:p] from 109.96.26.231 [14:30:45] [query:p] from 86.106.123.2 [14:30:45] [query:i] from 86.106.123.2 [14:30:45] [query:p] from 109.96.26.231 [14:30:45] [query:i] from 109.101.152.63 [14:30:45] [query:p] from 109.101.152.63 [14:30:45] [query:c] from 109.101.152.63 [14:30:45] [query:r] from 109.101.152.63 [14:30:46] [query:p] from 109.101.152.63 [14:30:46] [query:p] from 109.101.152.63 [14:30:47] [query:p] from 109.96.26.231 [14:30:48] [query:p] from 109.101.152.63 [14:30:48] [query:p] from 109.96.26.231 [14:30:49] [query:i] from 109.101.152.63 [14:30:49] [query:p] from 109.101.152.63 [14:30:49] [query:c] from 109.101.152.63 [14:30:49] [query:r] from 109.101.152.63 [14:30:49] [query:p] from 109.101.152.63 [14:30:50] [query:p] from 109.96.26.231 [14:30:50] [query:i] from 109.101.152.63 [14:30:50] [query:p] from 109.101.152.63 [14:30:50] [query:c] from 109.101.152.63 [14:30:50] [query:r] from 109.101.152.63 [14:30:50] [query:p] from 109.101.152.63 [14:30:51] [query:i] from 109.96.26.231 [14:30:51] [query:p] from 109.96.26.231 [14:30:51] [query:c] from 109.96.26.231 [14:30:51] [query:r] from 109.96.26.231 [14:30:51] [query:p] from 109.96.26.231 [14:30:53] [query:p] from 109.96.26.231 [14:30:53] [query:i] from 109.101.152.63 [14:30:53] [query:p] from 109.101.152.63 [14:30:53] [query:c] from 109.101.152.63 [14:30:53] [query:r] from 109.101.152.63 [14:30:53] [query:p] from 109.101.152.63 [14:30:53] [query:i] from 109.101.152.63 [14:30:53] [query:p] from 109.101.152.63 [14:30:53] [query:c] from 109.101.152.63 [14:30:53] [query:r] from 109.101.152.63 [14:30:53] [query:p] from 109.101.152.63 [14:30:54] [query:p] from 109.101.152.63 [14:30:54] [query:i] from 109.101.152.63 [14:30:54] [query:p] from 109.101.152.63 [14:30:54] [query:c] from 109.101.152.63 [14:30:54] [query:r] from 109.101.152.63 [14:30:54] [query:p] from 109.101.152.63 [14:30:54] [query:p] from 109.96.26.231
Hi, open server.cfg
Change: logqueries 1 To: logqueries 0 Also, this does not crash your server. To backtrack the problem get crashdetect plugin and run it. Once the server crash (restarts) open server_log.txt and check the [debug] lines before the crash. If you cannot fix it, open a thread in the help section and we will help out. |
lanmode 0 rcon_password password hostname UnionZone UK : Phantom RPG announce 1 query 1 gamemode0 gmvort 1 filterscripts antiaim anti-flood anti-flood weburl www.unionzone.com plugins streamer.so sscanf.so GeoIP_Plugin.so mysql_static.so mysql_5.5.so mysql.so Whirlpool.so maxnpc 1 onfoot_rate 40 incar_rate 40 weapon_rate 40 stream_distance 300.0 stream_rate 1000 language ENG connseedtime 300000 sleep 5 cookielogging 1 db_logging 1 db_log_queries 1 minconnectiontime 0 logqueries 0
This is my server .cfg:
Code:
lanmode 0 rcon_password password hostname UnionZone UK : Phantom RPG announce 1 query 1 gamemode0 gmvort 1 filterscripts antiaim anti-flood anti-flood weburl www.unionzone.com plugins streamer.so sscanf.so GeoIP_Plugin.so mysql_static.so mysql_5.5.so mysql.so Whirlpool.so maxnpc 1 onfoot_rate 40 incar_rate 40 weapon_rate 40 stream_distance 300.0 stream_rate 1000 language ENG connseedtime 300000 sleep 5 cookielogging 1 db_logging 1 db_log_queries 1 minconnectiontime 0 logqueries 0 Before to add logqueries 1, the server still restarting.. i will take the crashdetect. |
Seems to me you're doing loads of SQLITE quires, that are flooding your server, turn them to 0 and use crash detect to find out about the crash
|
public SetPlayerUnjail() { new aim, piss; for(new playerid; playerid < MAX_PLAYERS; playerid++) { aim = -1; piss = -1; if(!IsPlayerConnected(playerid) || IsPlayerNPC(playerid)) { continue; } if(GetPVarInt(playerid, "IsOnFire") && !CanPlayerBurn(playerid, 1)) { TogglePlayerBurning(playerid, false); } if(Pissing_at_Flame(playerid) != -1 || Aiming_at_Flame(playerid) != -1) { piss = Pissing_at_Flame(playerid); aim = Aiming_at_Flame(playerid); #if defined German GameTextForPlayer(playerid, " ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~r~~h~Feuer", 1500, 6); #else GameTextForPlayer(playerid, " ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~n~ ~r~~h~Flames", 1500, 6); #endif if(PlayerFireTimer[playerid][2] == -1 && ((aim != -1 && Pressing(playerid) & KEY_FIRE) || piss != -1)) { new value, time, Float:x, Float:y, Float:z; if(piss != -1) { value = piss; time = EXTINGUISH_TIME_PEEING; } else if(aim != -1) { value = aim; if(GetPlayerWeapon(playerid) == 41) { CreateExplosion(Flame[value][Flame_pos][0], Flame[value][Flame_pos][1], Flame[value][Flame_pos][2], 2, 5); continue; } if(IsPlayerInAnyVehicle(playerid)) { time = EXTINGUISH_TIME_VEHICLE; } else { time = EXTINGUISH_TIME_ONFOOT; } } if(value < -1) { time = EXTINGUISH_TIME_PLAYER; } time *= 1000; if(value >= -1) { x = Flame[value][Flame_pos][0]; y = Flame[value][Flame_pos][1]; z = Flame[value][Flame_pos][2]; RemoveSmokeFromFire(value); Flame[value][Smoke][0] = CreateDynamicObject(18727, x, y, z, 0.0, 0.0, 0.0); Flame[value][Smoke][1] = CreateDynamicObject(18727, x+1, y, z, 0.0, 0.0, 0.0); Flame[value][Smoke][2] = CreateDynamicObject(18727, x-1, y, z, 0.0, 0.0, 0.0); Flame[value][Smoke][3] = CreateDynamicObject(18727, x, y+1, z, 0.0, 0.0, 0.0); Flame[value][Smoke][4] = CreateDynamicObject(18727, x, y-1, z, 0.0, 0.0, 0.0); } PlayerFireTimer[playerid][2] = SetTimerEx("ExtinguishTimer", time, 0, "dd", playerid, value); } } if(CanPlayerBurn(playerid) && IsAtFlame(playerid)) { TogglePlayerBurning(playerid, true); } #if defined BurnOthers new Float:x, Float:y, Float:z; for(new i; i < MAX_PLAYERS; i++) { if(playerid != i && IsPlayerConnected(i) && !IsPlayerNPC(i)) { if(CanPlayerBurn(i) && GetPVarInt(playerid, "IsOnFire") && !GetPVarInt(i, "IsOnFire")) { GetPlayerPos(i, x, y, z); if(IsPlayerInRangeOfPoint(playerid, BURNING_RADIUS, x, y, z)) { TogglePlayerBurning(i, true); } } } } #endif } }
(This answer is not really gonna help)
Excuse me but is your server scripted so players can extinguish fires by... Peeing on them ? |