luckydo Posted June 14, 2014 Report Share Posted June 14, 2014 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? Link to comment Share on other sites More sharing options...
0 =DB4D=The Doctor Posted June 14, 2014 Report Share Posted June 14, 2014 Yeah having the same problem. Link to comment Share on other sites More sharing options...
0 Thug Posted June 14, 2014 Report Share Posted June 14, 2014 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. Link to comment Share on other sites More sharing options...
0 luckydo Posted June 14, 2014 Author Report Share Posted June 14, 2014 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. Link to comment Share on other sites More sharing options...
0 clemontine36 Posted June 15, 2014 Report Share Posted June 15, 2014 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! Link to comment Share on other sites More sharing options...
0 Triksterism Posted June 15, 2014 Report Share Posted June 15, 2014 I'm pretty new to SQL, how do we go about executing such a thing? Link to comment Share on other sites More sharing options...
0 fr1nk Posted June 16, 2014 Report Share Posted June 16, 2014 Open a new query window in whichever client you're using...paste the above in there and hit 'run'. Link to comment Share on other sites More sharing options...
0 luckydo Posted June 20, 2014 Author Report Share Posted June 20, 2014 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` = '[[[],[]],[[],[]],[[],[]]]' Link to comment Share on other sites More sharing options...
0 luckydo Posted June 20, 2014 Author Report Share Posted June 20, 2014 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? Link to comment Share on other sites More sharing options...
0 Flosstradamus Posted June 20, 2014 Report Share Posted June 20, 2014 You are looking for help in the wrong forum. Post it in the appropriate forum and you will get an appropriate response. Link to comment Share on other sites More sharing options...
0 luckydo Posted June 20, 2014 Author Report Share Posted June 20, 2014 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. Link to comment Share on other sites More sharing options...
0 mgm Posted June 20, 2014 Report Share Posted June 20, 2014 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 Link to comment Share on other sites More sharing options...
0 Dufer Posted June 20, 2014 Report Share Posted June 20, 2014 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! Link to comment Share on other sites More sharing options...
0 luckydo Posted June 20, 2014 Author Report Share Posted June 20, 2014 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); Link to comment Share on other sites More sharing options...
0 luckydo Posted June 20, 2014 Author Report Share Posted June 20, 2014 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] ]; Link to comment Share on other sites More sharing options...
0 mgm Posted June 21, 2014 Report Share Posted June 21, 2014 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. Link to comment Share on other sites More sharing options...
0 luckydo Posted June 21, 2014 Author Report Share Posted June 21, 2014 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. Link to comment Share on other sites More sharing options...
0 mgm Posted June 22, 2014 Report Share Posted June 22, 2014 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. Link to comment Share on other sites More sharing options...
0 KillingPigs123 Posted June 22, 2014 Report Share Posted June 22, 2014 In your init.sqf around line 25, what is the MaxVehicleLimit set to? Link to comment Share on other sites More sharing options...
0 inigomontoyayoukilledmydad Posted June 22, 2014 Report Share Posted June 22, 2014 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 Link to comment Share on other sites More sharing options...
0 luckydo Posted June 23, 2014 Author Report Share Posted June 23, 2014 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 Link to comment Share on other sites More sharing options...
0 mgm Posted June 23, 2014 Report Share Posted June 23, 2014 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? Link to comment Share on other sites More sharing options...
0 luckydo Posted June 24, 2014 Author Report Share Posted June 24, 2014 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. Link to comment Share on other sites More sharing options...
0 mgm Posted June 25, 2014 Report Share Posted June 25, 2014 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... Link to comment Share on other sites More sharing options...
0 luckydo Posted July 2, 2014 Author Report Share Posted July 2, 2014 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 Link to comment Share on other sites More sharing options...
0 mgm Posted July 2, 2014 Report Share Posted July 2, 2014 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? Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
25 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now