Jump to content

luckydo

Member
  • Posts

    24
  • Joined

  • Last visited

Posts posted by luckydo

  1. vehicles spawned by Infi's AH do not blow up. If you're using another tool to spawn them, open up whatever script you're using and add a variable then add an exception for that variable in your server_functions.sqf. This is explained on loads of scripts, like this one : http://opendayz.net/threads/release-scroll-menu-pick-your-spawn-point-and-loadout.13143/

     

    Actually I don't get what you mean here really.  Look I just need the easiest way with the least security risks to make it so I can use all guns, all ammo, all vehicles.  I'd like to understand what you guys think is best practice to do this I just don't understand the method you are proposing, need more step by step instructional info if you wouldn't mind. 

  2. Looking for help on how to be able to spawn and keep/use vehicles like the 350z and NYPD patrol car on my overpoch server.  I've tried adding them to a variables.sqf that I call from the init file and adding them to the DZE_safeVehicle list (the same way you would for deployable bikes) which does fix them from exploding or disappearing right away but they do eventually disappear.

     

    I can see the potential of this Epoch/Overwatch hybrid but god damn it's hard to get some of this stuff working.  Any help would be appreciated.

  3. 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. 

  4. 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.
  5. 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]
    ];
  6. 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); 

  7. 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.

  8. 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?

  9. 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` = '[[[],[]],[[],[]],[[],[]]]'
  10. 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.
×
×
  • Create New...