Jump to content

juandayz

Collaborator
  • Content Count

    2098
  • Joined

  • Last visited

  • Days Won

    143

Everything posted by juandayz

  1. I found another bug. Everytime i ask "anyone in cherno?" I die. Maybe devs are using player setdammage 1; when u chat this words?
  2. @totis if ure runing this block_ remember run the function to find vehicles without keys. ( if u dont have this function the sql event should be stop) So go to your heidy or navicat or whatever program you are using and run it as query over your db one single time. -- ---------------------------- -- Function structure for FindVehicleKeysCount -- ---------------------------- DROP FUNCTION IF EXISTS `FindVehicleKeysCount`; DELIMITER ;; CREATE FUNCTION `FindVehicleKeysCount`(`keyId` INT) RETURNS int(11) BEGIN DECLARE totalKeys INT DEFAULT 0; DECLARE keyName VARCHAR(32) DEFAULT ""; DECLARE keysInChar INT DEFAULT 0; DECLARE keysInObj INT DEFAULT 0; SET keyName = (CASE WHEN `keyId` < 2501 THEN CONCAT('ItemKeyGreen', `keyId`) WHEN `keyId` < 5001 THEN CONCAT('ItemKeyRed', `keyId` - 2500) WHEN `keyId` < 7501 THEN CONCAT('ItemKeyBlue', `keyId` - 5000) WHEN `keyId` < 10001 THEN CONCAT('ItemKeyYellow', `keyId` - 7500) WHEN `keyId` < 12501 THEN CONCAT('ItemKeyBlack', `keyId` - 10000) ELSE 'ERROR' END); SET keysInChar = (SELECT COUNT(*) FROM `Character_DATA` WHERE `Alive` = '1' AND (`Inventory` LIKE CONCAT('%', keyName, '%') OR `Backpack` LIKE CONCAT('%', keyName, '%'))); SET keysInObj = (SELECT COUNT(*) FROM `Object_DATA` WHERE `Inventory` LIKE CONCAT('%', keyName, '%')); RETURN (keysInChar + keysInObj); END
  3. Upload a pull request in gitub with your code changes.
  4. take my Bec folder from here- (you also will see the complete autorestart .bat files and maintain sql.) http://www.mediafire.com/file/plf0dzukd6u2p0x/EPOCH+AUTORESTART.rar (im using this bec folder since 2016 on all my servers) this is my .bat to execute the Bec. TIMEOUT /T 25 /NOBREAK cd\ cd "D:\epoch16\instance_1_takistan\BattlEye\Bec" Bec.exe -f Config.cfg --dsc
  5. i just want to say.. i was hosting an epoch server by 1 year in a vm. One day the conection with the vm just fall down. (one week). the problem? The company had no pay the internet connection. Was Fckn Epic..... the connection with the vm was restored after one week,, but ...was not the same . and also i was hosting a dayz mod server from my pc.. ( its not a super pc..) but i had nice response from it with 15 players (not more cuz my pc could exploit )
  6. juandayz

    Base Maintain

    @BennyD101 try this one:
  7. juandayz

    Base Maintain

    No. The only thing in selfactions.sqf is the plotmanagement option when you aim to your plot.
  8. Agree uninstall everything and reinstall again. Remove your server files too. Once you did it run arma2 and play 1 minute ..do the same with arma2oa. Later copy all content of arma2 into c:\testserver\ do the same with arma2oa but do not copy folders with @. Overwrite. Proceed with the server pack that i give you and create a new database ..remember put the db values in your hiveEXT.ini
  9. juandayz

    Base Maintain

    no, its like epoch 1.0.5.1 the hive comes by default with 6 days after remove. the sql events comes by default but you need load it in your db. So basically if u dont want use maintain .. just place -1 in hive. if u want maintain... place -1 in hive and load the sql functions.
  10. juandayz

    Base Maintain

    the hive line just remove everything... for example your players mount a base with walls, doors etc... if u place: CleanupPlacedAfterDays = 6 then after 6 days.. the server gonna remove everything .. dont care if they maintain or not. if u place: CleanupPlacedAfterDays = -1 this function stop to work,, and nothing is removed. then you can use the maintain function provided by plotmanagement and the damageOnAge sql query. Then now, the damageOnage sql start to damage your walls,doors 0.1 per day (you can change this value) then when the damage is 1. the wall is deleted. The maintain function of plotmanager .. restore this value at 0. so the wall is not deleted if you maintain it.
  11. juandayz

    Base Maintain

    anyway i guess you feel confused.. but dont worry at times when i had my own server this was the last thing that i was able to understand. Took me almos 6 months to have it running on epoch 1.0.5.1. Remember @theduke give me this one.. ( when i could not understand it) maybe help you same way as help me. damageonage.sql clean.bat and you need run the .bat file with your scheduler.xml at moment when your server restart. or run it manually (Double click over clean.bat on each server restart) or create a windows sheduled task.
  12. juandayz

    Base Maintain

    @BennyD101 as salival said you.. heres my find vehicles without keys function. I run it one single time with HeidySQL or Navicat .. you paste the code and run it as query over your database.. then this function keep loaded. -- ---------------------------- -- Function structure for FindVehicleKeysCount -- ---------------------------- DROP FUNCTION IF EXISTS `FindVehicleKeysCount`; DELIMITER ;; CREATE FUNCTION `FindVehicleKeysCount`(`keyId` INT) RETURNS int(11) BEGIN DECLARE totalKeys INT DEFAULT 0; DECLARE keyName VARCHAR(32) DEFAULT ""; DECLARE keysInChar INT DEFAULT 0; DECLARE keysInObj INT DEFAULT 0; SET keyName = (CASE WHEN `keyId` < 2501 THEN CONCAT('ItemKeyGreen', `keyId`) WHEN `keyId` < 5001 THEN CONCAT('ItemKeyRed', `keyId` - 2500) WHEN `keyId` < 7501 THEN CONCAT('ItemKeyBlue', `keyId` - 5000) WHEN `keyId` < 10001 THEN CONCAT('ItemKeyYellow', `keyId` - 7500) WHEN `keyId` < 12501 THEN CONCAT('ItemKeyBlack', `keyId` - 10000) ELSE 'ERROR' END); SET keysInChar = (SELECT COUNT(*) FROM `Character_DATA` WHERE `Alive` = '1' AND (`Inventory` LIKE CONCAT('%', keyName, '%') OR `Backpack` LIKE CONCAT('%', keyName, '%'))); SET keysInObj = (SELECT COUNT(*) FROM `Object_DATA` WHERE `Inventory` LIKE CONCAT('%', keyName, '%')); RETURN (keysInChar + keysInObj); END
  13. juandayz

    Base Maintain

    but an easy way? damageonage.bat UPDATE `object_data` SET `Damage`=0.1 WHERE `Inventory` = '[]' run manually each 14 days. or create a windowns function to run it each 14 days. Not recomended but is the most easy and lazy way
  14. juandayz

    Base Maintain

    @BennyD101 The tip is run one single sql with all included , damage on age, unlock vehicles, delete dead characters.. on each server restart. this is the one that i was using. NW_SERVER_MAINTAIN.sql You can call this file with your scheduler.xml or with a windows function.... example how i call it: a bunch of my scheduler.xml NW_SHUTDOWN.bat NW_MAINTAIN.bat r
  15. juandayz

    Base Maintain

    14 days in hive cleanup means remove everything after 14 days. recomend you in hive use CleanupPlacedAfterDays = -1 The thing that youre looking for is the damage on age sql function -- ---------------------------- -- Fix inventory on maintainable 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 0.1 damage to objects daily. -- ---------------------------- UPDATE `object_data` SET `Damage` = IF( `Damage` = 0.0, 0.1, `Damage` + 0.1 ) WHERE `LastUpdated` <= DATE_SUB(NOW(), INTERVAL 1 DAY) AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') ); -- ---------------------------- -- Set 0.1 damage doors/plots daily. -- ---------------------------- UPDATE `object_data` SET `Damage` = IF( `Damage` = 0.0, 0.1, `Damage` + 0.1 ) 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 `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND `Inventory` != '[]'; (change the intervals days at your taste) if ure not sure how to use it.. check this post
  16. 1-open ...\MPMissions\DayZ_Epoch_1.Chernarus\scripts\traders\server_traders.sqf at top add lines in blue: changes for your owns categorys. Recomend you change the trader class.. cuz if i remember well BanditW1_Dz is also used as character for players.. then if someone choose this model gonna have a trader menu over his body.
  17. ok, are you using coins? Can you give me the ai class name , his coords and his setdir values?
  18. Yes you can do it. But you will learn use arma2o 3d editor to place the ia .. go to themain menu of the game and press ctrl +e to open the editor 3d
  19. open your arma2oa editor 3D. ( i guess you know how to use it) place your trader save the file. open the mission saved. take his class name, his position coords and direction. Now: open ...\@DayZ_Epoch_Server\addons\dayz_server\traders\chernarus11.sqf Now if u wanna give this trader a items menu to sell/bought.. take a look here: Note: if ure using coins you have done 80% of the work in the guode from above. Just open your chernarus11.sqf (the one where all traders are defined with categorys to sell and bought and add your own)
  20. Do you have the PMC installed? (Private military company addon). check how my expansions looks: IF U HAVE INSTALLED AND ACTIVE ALL THOSE EXPANSIONS THEN PROCEED WITH: /////////////////////////////////////////////////////////////// I build this server pack for you to test. was tested before and works for me... How to install it? 1-Create a folder in C:\testserver 2-into C:\testserver\ drop all content located in your ....\steam\steamapps\common\Arma 2\ 3- now drop all content located ...\steam\steamapps\common\Arma 2 Operation Arrowhead\ into the same folder (C:\testserver\ ) But do not paste anykind of folder with @ for example do not paste @dayz and @dayz_epoch. 4-Download from here http://epochmod.com/a2dayzepoch.php !!!!JUST THE CLIENT FILES!!!! and place into C:\testserver\ 5-download my files http://www.mediafire.com/file/6cf6piy7fwf95i5/testserver.rar and place all content into C:\testserver\ 6-open C:\testserver\instance_11_Chernarus\HiveEXT.ini and entry your DataBase values in those lines:_ execute your server with DayZ_Epoch_instance_11_Chernarus.bat and try to join. @Anaconda101 if this donst works ..should be a client issue. Write me by private. I can join to your machine if u want with team viewer.
  21. Looks like default epoch variables.sqf. are you using it into the mpmissions\your instance\ or is the one into dayz_code.pbo? Cuz if is the one in dayz_code.pbo you need create a new custom in mpmissions.... other way changes do not take effect. anyway if this variables.sqf is your custom and not your default then you did it well. the class names was added succesfully.
  22. @Anaconda101 ok tnks for answer every thing mate....its much more easier help people like you. (anyway cant belive its not a client error cuz your rpt is giving you a lot of missings addons..but anyway maybe your server is not loading this addons .) you are using this files right? http://epochmod.com/a2dayzepoch.php well try this: in your start.bat try replacing the lines in red by your own server root path:
  23. can you paste your whole custom variables.sqf (the one who is called from init.sqf) ?
  24. @Anaconda101 a few questions. Are you running an epoch server right? not overpoch. Are you loading the @Dayz_Epoch folder in your game? Are you loading the same folder in your server? How your start.bat or your server launcher.bat looks? for example this mine: launcher.bat: in my arma2oa game in main menu/expansions/ i have active the Arma2,Arma2oa, and Epoch 1.6 mods. check if u have the same. Cuz maybe im wrong but seems to be a client issue. Are you be able to join to others servers? Thers other peoples who can join to your server? Here you can see how my server root looks:
×
×
  • Create New...