Eoch Server spawning WAY too many vehicles

[luckydo]

Server spawning WAY too many vehicles

 

MaxVehicles is set at what I want but server keep dropping more in --- I can't find a way to keep it under control without lots of manual work, can anyone help me out or point me to the thread if in fact this has beens solved?

[=DB4D=The Doctor]

Yeah having the same problem. 

[Thug]

use this in your data base. NOTE some doors may go away. Not that many players on so I just give them to the players.

 

DELETE FROM object_data

 

WHERE

 

 object_data.CharacterID = 0

 

AND (Inventory = '[[ [], [] ], [ [], [] ], [ [], [] ] ]' OR Inventory = '[]')

 

 

btw I use Navicat and do this every time they get out of hand.

hope this works for you.

[luckydo]

Thanks Thug, yes I've been trying to manage the issue using:
 

DELETE FROM

`Object_DATA`

WHERE

`Object_DATA`.`Classname` NOT LIKE 'Tent%'

AND `Object_DATA`.`Classname` NOT LIKE '%Locked'

AND `Object_DATA`.`Classname` NOT LIKE 'Land%'

AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'

AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'

AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'

AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'

AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ','Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')

AND `Object_DATA`.`Inventory` = '[[[],[]],[[],[]],[[],[]]]'

 

 

from another post on these forums  located at  

 

 

But to be honest it still feels like a losing battle even using this through navicat a couple times a day manually.

[clemontine36]

DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) AND `Fuel` > 0

 

Far better using that manually, or as an event so that people don't loose their base doors!

[Triksterism]

I'm pretty new to SQL, how do we go about executing such a thing?

[fr1nk]

Open a new query window in whichever client you're using...paste the above in there and hit 'run'.

[luckydo]

FYI

 

This line if you include the OR Inventory:

 

AND (Inventory = '[[ [], [] ], [ [], [] ], [ [], [] ] ]' OR Inventory = '[]')

 

will wipe players bases....just stick to the following if you want to be safe..

 

DELETE FROM

`Object_DATA`

WHERE

`Object_DATA`.`Classname` NOT LIKE 'Tent%'

AND `Object_DATA`.`Classname` NOT LIKE '%Locked'

AND `Object_DATA`.`Classname` NOT LIKE 'Land%'

AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'

AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'

AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'

AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'

AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ','Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')

AND `Object_DATA`.`Inventory` = '[[[],[]],[[],[]],[[],[]]]'

[luckydo]

By the way I'm still looking for help on my original reason for posting this thread:

 

 

 

Server spawning WAY too many vehicles

 

MaxVehicles is set at what I want but server keep dropping more in --- I can't find a way to keep it under control without lots of manual work, can anyone help me out or point me to the thread if in fact this has beens solved?

[Flosstradamus]

You are looking for help in the wrong forum. Post it in the appropriate forum and you will get an appropriate response.

[luckydo]

what's the "right" forum?  I appreciate people bothering to take the time to tell me that but kind of want to ones who don't bother to mention where the "appropriate" place is to die in a fire.  Is that wrong?  Isn't that like saying "You need to ask your question in German, I'm not going to tell you how to do that, I'm just going to post that you need to in order to get a response" not super helpful.

[mgm]

luckydo,

 

I'm new to Epoch & server hosting, I had the same problem/question. After going through forums and spending a day on it, I came up with a system (actually mostly copied it from forums/web sites) and modified these proven solutions according to my taste. SQL queries might have small errors and can be surely done in a more efficient way but the below works for me so far.

 

1. If you do not have a proper system of automatically shutting down & restarting the server every N hours, I suggest you get that sorted first.

 

2. Once you are OK with step 1 above, next I suggest you run some SQL scripts "every N hours after server is automatically shutdown via script and just before it is automatically restarted via script" to clean up your server. In other words, remove old spawned vehicles & your server will spawn new ones. With this approach your total randomly spawned vehicle number will stay at about the same range (i.e.: it will not keep going up all the time).

 

Once you are ready to run SQL scripts at every N hours, you can write your scripts from scratch or you can simply base it on existing scripts to save time.

Below are the scripts I currently use and so far am happy with.

Should you wish to use this approach, probably best if you do not copy & paste from the code below, instead use the attached ZIP file content because in one file I cut it short not to spam the forum.

To make this work for you, you will need to do tiny modifications like path and frequency (my server restart frequency is 3 hours hence the 3 hour interval in some places in SQL queries).

Just one hour ago I added a forum entry, trying to explain this system to players which you can also benefit from (it has exact vehicle list & explanation which you can copy if you like). link

 

Let me know if you have any questions and I will be happy to help.

// DB_Cleanup-Object-Threshold_After_Spawn_Level_1__3h.sql

-- EXECUTION FREQUENCY: 		To be executed before each server restart.
-- SUMMARY:				Delete bicycles 3 hours after spawn time.
DELETE 
	FROM `Object_DATA` 
WHERE (`Object_DATA`.`Classname` LIKE '%MMT_Civ%'
	OR `Object_DATA`.`Classname` LIKE '%Old_bike_TK_INS_EP1%')
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 HOUR)
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 HOUR);

// DB_Cleanup-Object-Untouched_Level_1__24h.sql

-- EXECUTION FREQUENCY: 		To be executed before each server restart.
-- SUMMARY:				Any object matching the criteria and hasn't been touched for at least 24 hours will be deleted.
DELETE 
	FROM `Object_DATA` 
WHERE (`Object_DATA`.`Classname` LIKE '%TT650_Ins%'
	OR `Object_DATA`.`Classname` LIKE '%TT650_Ins%'
// blah
// blah
// blah
	OR `Object_DATA`.`Classname` LIKE '%Volha_2_TK_CIV_EP1%')
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR)
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR);

	-- find old tents (untouched for at least 24 hours)
DELETE
	FROM `Object_DATA` 
WHERE (`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR)
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR)
	AND Classname LIKE 'TentStorage%'
	AND (`Inventory` = '[]' OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]')));

// DB_Cleanup-Object-Untouched_Level_2__3d.sql

-- Delete the following vehicles after 3 days	of LastUpdate time
DELETE 
	FROM `Object_DATA` 
WHERE (`Object_DATA`.`Classname` LIKE '%hilux1_civil_2_covered%'
	OR `Object_DATA`.`Classname` LIKE '%Old_moto_TK_Civ_EP1%'
	OR `Object_DATA`.`Classname` LIKE '%TT650_TK_CIV_EP1%'
	OR `Object_DATA`.`Classname` LIKE '%Volha_2_TK_CIV_EP1%')
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY)
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY);

// DB_Cleanup-Object-Untouched_Level_3__7d.sql

-- EXECUTION FREQUENCY: 		To be executed before each server restart.
-- SUMMARY:				Delete any vehicles with no gear, after being untouched for 7 days.
DELETE 
	FROM `Object_DATA` 
WHERE (`Classname` NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort'
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
	AND (`Inventory` = '[]' OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]')));

-- SUMMARY:									Delete old Tents, after being untouched for 7 days		[at this point, we don't care if they have gear inside]
DELETE 
	FROM `Object_DATA` 
WHERE (`Classname` LIKE 'TentStorage%')
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY);

// DB_Cleanup-Object-Untouched_Level_4__14d.sql

-- EXECUTION FREQUENCY: 		To be executed before each server restart.
-- SUMMARY:				Delete matching untouched objects (vehicles WITH gear) after being untouched for 14 days
DELETE 
	FROM `Object_DATA` 
WHERE (`Classname` NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort'
	AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
	AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
	AND (`Inventory` <> '[]' AND (`Inventory` <> '[[[],[]],[[],[]],[[],[]]]')));

Edit - let's continue this one here since we already started but just for future reference:

I think the most appropriate sub-forum for similar future questions would be How's it Done? (Need help getting something setup or need to know something?) link

__SQL_scripts.zip

[Dufer]

Make sure your dynamic_vehicle.sqf located in dayz_server/missions/<yourmissionhere>/dynamic_vehicle.sqf isn't missing any commas / quotations or brackets besides the last one without a comma.

 

Should look something like this.

AllowedVehiclesList = [
["V5S_Civ",5],
["V5S_Open_TK_CIV_EP1",5],
["V5S_Open_TK_EP1",5],
["V5S_RA_TK_GUE_EP1_DZE",5],
["V5S_Refuel_TK_GUE_EP1_DZ",5],
["V5S_TK_EP1_DZE",5],
["VolhaLimo_TK_CIV_EP1",5]
];

I've had this happen before and it would spawn close to 400 vehicles every restart.

 

 

Hope this helps!

[luckydo]

Thanks, at this point I'm trying to make it so the server won't spawn vehicles that players don't use or like.  I've not been successful so far is taking the values out pf the SQL files (server won't boot)  so I'm trying to manually take them out by using for example something like this:

 

DELETE 

FROM `Object_DATA` 

WHERE (`Object_DATA`.`Classname` LIKE '%MMT_Civ%'

OR `Object_DATA`.`Classname` LIKE '%Old_bike_TK_INS_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Blue%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Green%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Red%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Yellow%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Yellow%'

  OR `Object_DATA`.`Classname` LIKE '%Fishing_Boat%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Blue%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Red%'

  OR `Object_DATA`.`Classname` LIKE '%ATV_CZ_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_TK_CIV_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%Zodiac%'

  OR `Object_DATA`.`Classname` LIKE '%PBX%'

  OR `Object_DATA`.`Classname` LIKE '%RHIB%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_Ins%'

  OR `Object_DATA`.`Classname` LIKE '%GLT_M300_LT%'

  OR `Object_DATA`.`Classname` LIKE '%tractor%'

  OR `Object_DATA`.`Classname` LIKE '%GNT_C185U%'

  OR `Object_DATA`.`Classname` LIKE '%GLT_M300_LT%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_Civ%'

  OR `Object_DATA`.`Classname` LIKE '%SkodaBlue%'

  OR `Object_DATA`.`Classname` LIKE '%SkodaRed%'

  OR `Object_DATA`.`Classname` LIKE '%Lada2%'

  OR `Object_DATA`.`Classname` LIKE '%VolhaLimo_TK_CIV_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%Lada1%'

  OR `Object_DATA`.`Classname` LIKE '%GAZ_Vodnik_MedEvac%'

  OR `Object_DATA`.`Classname` LIKE '%Mi17_Civilian_DZ%'

  OR `Object_DATA`.`Classname` LIKE '%Skoda%'

  OR `Object_DATA`.`Classname` LIKE '%Smallboat_2%')

AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR)

AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR); 

[luckydo]

I've tried to remove vehicles from  dynamic_vehicle.sqf so it looks like this:  server authentication hangs

 

AllowedVehiclesList = [

["ArmoredSUV_PMC_DZE",1],

["CH_47F_EP1_DZE",1],

["CSJ_GyroC",3],

["CSJ_GyroCover",3],

["CSJ_GyroP",3],

["datsun1_civil_1_open",3],

["datsun1_civil_2_covered",3],

["datsun1_civil_3_open",3],

["hilux1_civil_1_open",3],

["hilux1_civil_2_covered",3],

["hilux1_civil_3_open_EP1",3],

["HMMWV_DES_EP1",3],

["HMMWV_DZ",3],

["HMMWV_M1035_DES_EP1",1],

["HMMWV_M1151_M2_CZ_DES_EP1_DZE",1],

["HMMWV_M998A2_SOV_DES_EP1_DZE",1],

["Ikarus",3],

["Ikarus_TK_CIV_EP1",3],

["Kamaz",3],

["KamazRefuel_DZ",1],

["LandRover_CZ_EP1",3],

["LandRover_MG_TK_EP1_DZE",1],

["LandRover_Special_CZ_EP1_DZE",1],

["LandRover_TK_CIV_EP1",3],

["M1030_US_DES_EP1",3],

["MH6J_DZ",3],

["Mi17_Civilian_DZ",3],

["Mi17_DZE",3],

["MtvrRefuel_DES_EP1_DZ",1],

["MTVR_DES_EP1",3],

["MV22_DZ",1],

["Offroad_DSHKM_Gue_DZE",3],

["Old_bike_TK_INS_EP1",3],

["Old_moto_TK_Civ_EP1",3],

["PBX",3],

["Pickup_PK_GUE_DZE",3],

["Pickup_PK_INS_DZE",3],

["Pickup_PK_TK_GUE_EP1_DZE",3],

["SUV_Blue",1],

["SUV_Camo",1],

["SUV_Charcoal",1],

["SUV_Green",1],

["SUV_Orange",1],

["SUV_Pink",1],

["SUV_Red",1],

["SUV_Silver",1],

["SUV_TK_CIV_EP1",1],

["SUV_White",1],

["SUV_Yellow",1],

["UAZ_CDF",3],

["UAZ_INS",3],

["UAZ_MG_TK_EP1_DZE",3],

["UAZ_RU",3],

["UAZ_Unarmed_TK_CIV_EP1",3],

["UAZ_Unarmed_TK_EP1",3],

["UAZ_Unarmed_UN_EP1",3],

["UH1H_DZE",2],

["UH1Y_DZE",2],

["UH60M_EP1_DZE",1],

["UralRefuel_TK_EP1_DZ",1],

["Ural_CDF",3],

["Ural_TK_CIV_EP1",3],

["Ural_UN_EP1",3],

["V3S_Open_TK_CIV_EP1",3],

["V3S_Open_TK_EP1",3],

["V3S_Refuel_TK_GUE_EP1_DZ",1],

["VWGolf",3],

["Zodiac",3]

];

[mgm]

 

I've tried to remove vehicles from  dynamic_vehicle.sqf so it looks like this:  server authentication hangs

 

AllowedVehiclesList = [

["ArmoredSUV_PMC_DZE",1],

["CH_47F_EP1_DZE",1],

["CSJ_GyroC",3],

["CSJ_GyroCover",3],

["CSJ_GyroP",3],

["datsun1_civil_1_open",3],

["datsun1_civil_2_covered",3],

["datsun1_civil_3_open",3],

["hilux1_civil_1_open",3],

["hilux1_civil_2_covered",3],

["hilux1_civil_3_open_EP1",3],

["HMMWV_DES_EP1",3],

["HMMWV_DZ",3],

["HMMWV_M1035_DES_EP1",1],

["HMMWV_M1151_M2_CZ_DES_EP1_DZE",1],

["HMMWV_M998A2_SOV_DES_EP1_DZE",1],

["Ikarus",3],

["Ikarus_TK_CIV_EP1",3],

["Kamaz",3],

["KamazRefuel_DZ",1],

["LandRover_CZ_EP1",3],

["LandRover_MG_TK_EP1_DZE",1],

["LandRover_Special_CZ_EP1_DZE",1],

["LandRover_TK_CIV_EP1",3],

["M1030_US_DES_EP1",3],

["MH6J_DZ",3],

["Mi17_Civilian_DZ",3],

["Mi17_DZE",3],

["MtvrRefuel_DES_EP1_DZ",1],

["MTVR_DES_EP1",3],

["MV22_DZ",1],

["Offroad_DSHKM_Gue_DZE",3],

["Old_bike_TK_INS_EP1",3],

["Old_moto_TK_Civ_EP1",3],

["PBX",3],

["Pickup_PK_GUE_DZE",3],

["Pickup_PK_INS_DZE",3],

["Pickup_PK_TK_GUE_EP1_DZE",3],

["SUV_Blue",1],

["SUV_Camo",1],

["SUV_Charcoal",1],

["SUV_Green",1],

["SUV_Orange",1],

["SUV_Pink",1],

["SUV_Red",1],

["SUV_Silver",1],

["SUV_TK_CIV_EP1",1],

["SUV_White",1],

["SUV_Yellow",1],

["UAZ_CDF",3],

["UAZ_INS",3],

["UAZ_MG_TK_EP1_DZE",3],

["UAZ_RU",3],

["UAZ_Unarmed_TK_CIV_EP1",3],

["UAZ_Unarmed_TK_EP1",3],

["UAZ_Unarmed_UN_EP1",3],

["UH1H_DZE",2],

["UH1Y_DZE",2],

["UH60M_EP1_DZE",1],

["UralRefuel_TK_EP1_DZ",1],

["Ural_CDF",3],

["Ural_TK_CIV_EP1",3],

["Ural_UN_EP1",3],

["V3S_Open_TK_CIV_EP1",3],

["V3S_Open_TK_EP1",3],

["V3S_Refuel_TK_GUE_EP1_DZ",1],

["VWGolf",3],

["Zodiac",3]

];

 

If you have the option to test now:

• stop the server, take a backup of the SQL db then delete all vehicles
• take backup of dynamic vehicles file and then heavily edit it (to allow 3 vehicles maybe, 1 of each)
• set max vehicles to 10
• restart the server and see how it goes.

 

if you're running out of resources (memory) then server authentication fails might happen. this happened several times to me just tonight when my test machine run out of memory...

too many existing objects might be the reason why you're receiving it now.

[luckydo]

Thank you MGM,

  I have tried the same approach you've mentioned by changing the individual limit from 3 for example to 1, even tried changing the value to 0.  The same result occurs where the server cannot successfully authenticate a player using the server.pbo that has any edits to this particular dynamic_vehicle.sqf  file.  Keep in mind that I have my server limited to 175 max vehicles which I've gotten it to stay at with the added manual navicat commands of:

 

DELETE 

FROM `Object_DATA` 

WHERE (`Object_DATA`.`Classname` LIKE '%MMT_Civ%'

OR `Object_DATA`.`Classname` LIKE '%Old_bike_TK_INS_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Blue%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Green%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Red%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Yellow%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Yellow%'

  OR `Object_DATA`.`Classname` LIKE '%Fishing_Boat%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Blue%'

  OR `Object_DATA`.`Classname` LIKE '%JetSkiYanahui_Case_Red%'

  OR `Object_DATA`.`Classname` LIKE '%ATV_CZ_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_TK_CIV_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%Zodiac%'

  OR `Object_DATA`.`Classname` LIKE '%PBX%'

  OR `Object_DATA`.`Classname` LIKE '%RHIB%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_Ins%'

  OR `Object_DATA`.`Classname` LIKE '%GLT_M300_LT%'

  OR `Object_DATA`.`Classname` LIKE '%tractor%'

  OR `Object_DATA`.`Classname` LIKE '%GNT_C185U%'

  OR `Object_DATA`.`Classname` LIKE '%GLT_M300_LT%'

  OR `Object_DATA`.`Classname` LIKE '%TT650_Civ%'

  OR `Object_DATA`.`Classname` LIKE '%SkodaBlue%'

  OR `Object_DATA`.`Classname` LIKE '%SkodaRed%'

  OR `Object_DATA`.`Classname` LIKE '%Lada2%'

  OR `Object_DATA`.`Classname` LIKE '%VolhaLimo_TK_CIV_EP1%'

  OR `Object_DATA`.`Classname` LIKE '%Lada1%'

  OR `Object_DATA`.`Classname` LIKE '%GAZ_Vodnik_MedEvac%'

  OR `Object_DATA`.`Classname` LIKE '%Mi17_Civilian_DZ%'

  OR `Object_DATA`.`Classname` LIKE '%Skoda%'

  OR `Object_DATA`.`Classname` LIKE '%Smallboat_2%')

AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR)

AND `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR);

 

 

 

 

 

as well as

 

DELETE FROM

`Object_DATA`

WHERE

`Object_DATA`.`Classname` NOT LIKE 'Tent%'

AND `Object_DATA`.`Classname` NOT LIKE '%Locked'

AND `Object_DATA`.`Classname` NOT LIKE 'Land%'

AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'

AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'

AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'

AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'

AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ','Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')

AND `Object_DATA`.`Inventory` = '[[[],[]],[[],[]],[[],[]]]'

 

 

But ultimately I just don't want the server to spawn any crappy vehicles at all.

[mgm]

 

Thank you MGM,

  I have tried the same approach you've mentioned by changing the individual limit from 3 for example to 1, even tried changing the value to 0.  The same result occurs where the server cannot successfully authenticate a player using the server.pbo that has any edits to this particular dynamic_vehicle.sqf  file.  Keep in mind that I have my server limited to 175 max vehicles which I've gotten it to stay at with the added manual navicat commands of:

<snip>

How come you can't modify dynamic_vehicle.sqf file at all -- are you not using Notepad++? If so, are you making sure your "Encoding > Encode in ANSI" setting is selected?

If I remember correctly I had an issue once when created a new sqf file from scratch and it defaulted to my Notepad++ settings (which is UTF-8) which didn't work well. I had to switch to ANSI after which it worked - I think.

[KillingPigs123]

In your init.sqf around line 25, what is the MaxVehicleLimit set to?

[inigomontoyayoukilledmydad]

hes already said he tried editing the dyanmicvehicle, and he also said hes tried everything with the mxvehiclelimit, even setting it to 0. it still spawns vehicles.

 

im now noticing this on my server also. seems like every reboot more and more vehicles, its really getting nuts, when i set vehicle markers on infistar and look at my map it looks like the fricken milky way

[luckydo]

In your init.sqf around line 25, what is the MaxVehicleLimit set to?

 

MaxVehicleLimit = 175; // Controls the max overall vehicle limit       

 

as I set this to 175 myself, as I wanted this many

[mgm]

It is MaxVehicleLimit AND dynamic_vehicle.sqf. This works for me.

If it is not working for you one of your files [or maybe a completely different file somewhere] is bad thus breaking the configuration you're trying to achieve.

 

Once again, I suggest:

• For test purposes, backup your db & delete it, create a new one, execute Epoch's default db sql script to populate it.
• Then start your server see if it stabilizes at ~175 vehicles. Restart it a couple of times and see if it still keeps creating whole set of new vehicles [~175] on each restart. [so you'll have over 500 in 3 restarts << problem with your setup].
• Also as a separate test, try deleting ALL VEHICLES in-between restarts, and restarting it a couple of times. See if you can stabilize that way. If you can, that means sqf files are actually working and SQL CLEANUP ROUTINES are not.
• Then you will need to stop playing with sqf files and start playing with SQL files to fix your cleanup routines.

 

Try the above and let us know?

[luckydo]

It is MaxVehicleLimit AND dynamic_vehicle.sqf. This works for me.

If it is not working for you one of your files [or maybe a completely different file somewhere] is bad thus breaking the configuration you're trying to achieve.

 

Once again, I suggest:

• For test purposes, backup your db & delete it, create a new one, execute Epoch's default db sql script to populate it.
• Then start your server see if it stabilizes at ~175 vehicles. Restart it a couple of times and see if it still keeps creating whole set of new vehicles [~175] on each restart. [so you'll have over 500 in 3 restarts << problem with your setup].
• Also as a separate test, try deleting ALL VEHICLES in-between restarts, and restarting it a couple of times. See if you can stabilize that way. If you can, that means sqf files are actually working and SQL CLEANUP ROUTINES are not.
• Then you will need to stop playing with sqf files and start playing with SQL files to fix your cleanup routines.

 

Try the above and let us know?

 

 

Gave this a shot and it although I thought I had it solved it ended up going back to the old behavior.

 

On the note of SQL cleanup routines I'm a little confused how they can help because even timed perfectly to execute right before and during the moments when the server goes all the way down for restart -- the server is going come back online and shit out a whole bunch of vehicles.. So It's back to square one for now I guess. 

[mgm]

Gave this a shot and it although I thought I had it solved it ended up going back to the old behavior.

 

On the note of SQL cleanup routines I'm a little confused how they can help because even timed perfectly to execute right before and during the moments when the server goes all the way down for restart -- the server is going come back online and shit out a whole bunch of vehicles.. So It's back to square one for now I guess. 

SQL won't help you "not to spawn". In order not to spawn stuff, you need to resolve that in dynamic_vehicles.sqf. There's no way around it. I think your file and/or your editor is somehow bad. Perhaps download latest Notepad++ and start with a new copy of dynamic_vehicles.sqf

 

What SQL will help you with is, removing the old vehicles which were already spawned but somehow didn't find the care & love they need. SQL will kick in, in between restarts, and will delete them...

[luckydo]

I got the server to boot up after I modified dynamic_vehicle.sqf --- took lines of the cars I didn't want -- and boats (which I hate) --  AND THEY STILL SPAWN --  AHHHHHHHHHHH

[mgm]

I got the server to boot up after I modified dynamic_vehicle.sqf --- took lines of the cars I didn't want -- and boats (which I hate) --  AND THEY STILL SPAWN --  AHHHHHHHHHHH

What I do to test is, I modify the file to spawn one single type of vehicle [ always little bird :) ] and then delete all non user owned vehicles & restart. On restart if you don't find hundreds of littlebirds (only) then your file is not even active somehow.

 

This way I figured Overpoch is actually using Epoch_Server > server.pbo. Are you running Overpoch - could it be the same issue?