Jump to content

Kerbo

Member
  • Posts

    36
  • Joined

  • Last visited

Posts posted by Kerbo

  1. AFAIK CfgWorlds.hpp is not directly available as it is part of the map build process. You can see where it is pulled in to build config.bin (if you decode that file line 36 is start of Napf class). I don't believe you can override that but am no expert.

  2.  

    I am getting this error:

    SQL Error (1146): Table 'mysql.object_data' doesn't exist
    

     

    mysql is the database (or schema) name and object_data is the table name. In this case your mysql client is using the default database (mysql) which it will do unless you specify something different. You need to switch to your DayZ database before running the SQL or add "USE epoch;" to the top of your script (assuming your DayZ database is called epoch). Hope that make sense.

  3. For #1 this should work:

    SELECT * FROM
        `Object_DATA`
    WHERE
        `Object_DATA`.`CharacterID` <> 0
        AND `Object_DATA`.`CharacterID` <= 12500
        AND `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`.`LastUpdated` < DATE_SUB(NOW(), INTERVAL 10 DAY);

    It's good practice to check DELETE's with a SELECT first so if the results look right replace "SELECT * FROM" above with "DELETE FROM" and rerun.

     

    I don't know of an easy way to do #2 since Hitpoints is an array that can vary depending on vehicle type.

  4. It would take some scripting knowledge and a little elbow grease but you could generate the images yourself using a custom mission and the PHP script I wrote for the DayZAdmin web tool.

    https://github.com/wriley/DayZAdmin/blob/master/utilities/RPTScan.php

     

    My workflow goes something like this:

    1) Create mission with DEVTOOLS and correct SQF

    2) Clear client RPT file

    3) Run mission and dump classes

    4) Run .bat files on appropriate extracted pbo's

     

    I can provide no support for this due to lack of time but it's not rocket science.

  5.   Do you think theres enough talent around here to offer Dotjosh a solution, or even create a substitute that applies across the board, not to only Epoch?

     

      Would really show how focused on the community the Epoch group is.

     

    IMHO there is definitely enough talent to implement the technical solution but who will pay for the infrastructure? Someone has to pay for the servers/power/rack space/bandwidth/etc.

  6. Safezone traders is a must i think, traders would lose their meaning otherwise. One could only go there as part of a group. A server that "doesn't suck" would have these features if you asked me:

     

    • No 3rd view, not even in vehicles
    • No crosshairs, no death messages
    • Dayz standard spawn gear, no extras
    • No bicycle out of the (tool)box
    • moderate to high prices at the traders
    • well designed missions both at remote areas and in towns
    • Night and daytime
    • Zero vehicles that are spawned by the server, they ought to be bought
    • No magic cinder bases, everything should be destroyable

     

    Would it be possible to protect trader zones by AI? They would treat everyone as friendly, but if s/o fires at a player, they instantly recognize him or her as an enemy and start hunting that player? I think this should be doable from a technical point of view..

     

    I hosted a server mostly like that for a long time and 99% of people would leave within 2 minutes of joining. You can find hardcore servers but they are underpopulated because very few people want that kind of DayZ experience. The closest thing I have found these days is Mells House, check Axle's sig for link.

  7. This should do the trick. You can test first with the SELECT and then if it looks OK run the second with DELETE.

     

    SELECT * 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`.`LastUpdated` < NOW() - INTERVAL 7 DAY;

    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`.`LastUpdated` < NOW() - INTERVAL 7 DAY;
×
×
  • Create New...