Jump to content

J001

Member
  • Posts

    11
  • Joined

  • Last visited

Posts posted by J001

  1. 6 hours ago, Zupa said:

    Some info regarding the feature:

    Advanced Trading is included in the latest Epoch 1.6 ( Which is coming eventually ).

    Various changes and bugfixes have been applied by the Community devs ( Credits will be given later).

    Also features like vehicle buying have been added. 

     

    Thanks for the info!

    The mod really need a update, and hope community along with arma 3 raise again.

  2. This fix is still temp :

                if (dayz_clientPreload && dayz_authed) exitWith { diag_log "PLOGIN: Login loop completed!"; };

     

    with:

     

                if (dayz_clientPreload && dayz_authed) exitWith {

                    endLoadingScreen;
                    diag_log "PLOGIN: Login loop completed!";
                };

     

    As players still get bugged , and ends up with limbo, bird, or otherwise

     

    After my tests, it solves it for a time, but then the problems comes back, and pvar kicks #0 starts.

     

    I will go back to removing this line, and leave it at people cant join hearing sounds in loading and stuck, so that they can resolve the login by reconnecting, or wait for server restart.

  3.  

    /* =================== DELETES =================== */
    
    /* Delete old crap */
    DELETE FROM `object_data`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 21 DAY);
    
    /* Delete destroyed objects */
    DELETE FROM `object_data`
    WHERE Damage = 1;
    
    /* Delete plots and doors not being cleaned */
    DELETE FROM `Object_DATA`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
    AND `Classname` IN ('Plastic_Pole_EP1_DZ','CinderWallDoorSmallLocked_DZ','CinderWallDoorLocked_DZ','CinderWallSmallDoorway_DZ','CinderWallDoorway_DZ','Land_DZE_WoodDoorLocked','CinderWallDoor_DZ','CinderWallDoorSmall_DZ','Land_DZE_WoodDoor','Land_DZE_GarageWoodDoor','Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_LargeWoodDoor','WoodLargeWallDoor_DZ');
    
    /* Delete old login data */
    DELETE FROM `player_login`;
    
    /* Delete untouched server spawned vehicles */
    DELETE FROM `object_data`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY)
    AND `CharacterID` = '0'
    AND `Classname`
    NOT REGEXP 'barrier|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|sand|scaffold|nest';
    
    /* Delete all vehicles not touched in 7 days */
    DELETE FROM `object_data`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
    AND `Classname`
    NOT REGEXP 'barrier|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|sand|scaffold|nest';
    
    /* Delete empty storage objects */
    DELETE FROM `object_data`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY)
    AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') )
    AND `Classname` IN ('Wooden_shed_DZ','WoodShack_DZ', 'TentStorage', 'TentStorageDomed', 'TentStorageDomed2', 'WoodCrate_DZ', 'GunRack_DZ', 'OutHouse_DZ', 'StorageShed_DZ');
    
    /* Delete unused storage objects */
    DELETE FROM `object_data`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 10 DAY)
    AND `Classname` IN ('Wooden_shed_DZ','WoodShack_DZ', 'TentStorage', 'TentStorageDomed', 'TentStorageDomed2', 'WoodCrate_DZ', 'GunRack_DZ', 'OutHouse_DZ', 'StorageShed_DZ');
    
    /* =================== UPDATES =================== */
    
    /* Unlock Purchased Untouched Vehicles */
    UPDATE `object_data`
    SET `CharacterID` = 0
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 5 DAY)
    AND `CharacterID` > 0
    AND `Classname`
    NOT REGEXP 'barrier|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|sand|scaffold|nest';
    
    /* Fix inventory on maintain objects */
    UPDATE `object_data`
    SET `inventory` = '[]',`LastUpdated` = `LastUpdated`
    WHERE `inventory` = '[[[],[]],[[],[]],[[],[]]]'
    AND
    `Classname` IN (
    'BagFenceRound_DZ','CinderWall_DZ','CinderWallDoorLocked_DZ','CinderWallDoorSmall_DZ','CinderWallDoorSmallLocked_DZ',
    'CinderWallHalf_DZ','FireBarrel_DZ','GunRack_DZ','LightPole_DZ','MetalFloor_DZ','MetalPanel_DZ','OutHouse_DZ','TentStorage',
    'TentStorageDomed','TentStorageDomed2','Sandbag1_DZ','Scaffolding_DZ','StickFence_DZ','StorageShed_DZ','WorkBench_DZ',
    'WoodCrate_DZ','WoodFloor_DZ','WoodFloorQuarter_DZ','WoodLargeWall_DZ','WoodLargeWallWin_DZ','WoodShack_DZ','WoodSmallWall_DZ',
    'WoodSmallWallThird_DZ','WoodSmallWallWin_DZ','Land_DZE_GarageWoodDoor','WoodFloorHalf_DZ','Fort_RazorWire','Land_DZE_LargeWoodDoorLocked',
    'WoodStairsRails_DZ','WoodLadder_DZ','WoodStairsSans_DZ','M240Nest_DZ','Land_DZE_WoodDoor'
    );
    
    /* Set Damage on all other objects */
    UPDATE `Object_DATA`
    SET `Damage`=0.2
    WHERE `ObjectUID` <> 0
    AND `CharacterID` <> 0
    AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY)
    AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') );
    
    /* Set Damage On Doors/Plot Poles using Door Management via Age */
    UPDATE `Object_DATA`
    SET `Damage`=0.2
    WHERE `Classname` IN ('Plastic_Pole_EP1_DZ','CinderWallDoorSmallLocked_DZ','CinderWallDoorLocked_DZ','CinderWallSmallDoorway_DZ','CinderWallDoorway_DZ','Land_DZE_WoodDoorLocked','CinderWallDoor_DZ','CinderWallDoorSmall_DZ','Land_DZE_WoodDoor','Land_DZE_GarageWoodDoor','Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_LargeWoodDoor','WoodLargeWallDoor_DZ')
    AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY)
    AND `Inventory` != '[]';
    
    /* Set Safe Combo to 0000 */
    UPDATE `object_data`
    SET `CharacterID` = 0
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
    AND `CharacterID` > 0
    AND `Classname` = "VaultStorageLocked"
    AND `Inventory` <> '[]'
    AND `Inventory` IS NOT NULL;
    
    /* Set Lock Box to RED 00 */
    UPDATE `object_data`
    SET `CharacterID` = 10000
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
    AND `CharacterID` > 0
    AND `Classname` = "LockboxStorageLocked"
    AND `Inventory` <> '[]'
    AND `Inventory` IS NOT NULL;

     

     

    CEN!

     

    May i kiss your forhead!

     

    Thanks for sharing this!

×
×
  • Create New...