FragZ
-
Posts
487 -
Joined
-
Last visited
Content Type
Profiles
Forums
Articles
Posts posted by FragZ
-
-
This sql deletes vehicles not used in 7 days that have some damage
BEGIN DELETE FROM dayz_epoch.object_data WHERE object_data.LastUpdated < NOW() - INTERVAL 7 DAY AND Hitpoints LIKE '%wheel_2_1_steering",1%' AND Hitpoints LIKE '%wheel_2_2_steering",1%' OR Hitpoints LIKE '%motor",1%' OR Hitpoints LIKE '%karoserie",1%' OR Hitpoints LIKE '%Pravy zadni tlumic",1%' OR Hitpoints LIKE '%engine",1%'; END
This sql unlocks vehicles not used in 7 days
UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked') AND `Inventory` <> '[]' AND `Inventory` IS NOT NULLGives me this error:
ErrorSQL query:
BEGIN DELETE FROM dayz_epoch.Object_DATA WHERE Object_DATA.LastUpdated < NOW( ) - INTERVAL 14 DAY AND Hitpoints LIKE '%wheel_2_1_steering",1%' AND Hitpoints LIKE '%wheel_2_2_steering",1%' OR Hitpoints LIKE '%motor",1%' OR Hitpoints LIKE '%karoserie",1%' OR Hitpoints LIKE '%Pravy zadni tlumic",1%' OR Hitpoints LIKE '%engine",1%';
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM dayz_epoch.Object_DATA
WHERE Object_DATA.LastUpdated < NOW() - INTE' at line 2
-
I am using dayz.st and I would like to know if there is a way to delete all vehicles unused for over like... 2-3 weeks.
I know in the database there is a tab with *last updated*. Is there a way (sql or whatever) to remove all of those who are too old? Our server is getting stacked by people buying vehicles and leaving etc... plus the normal 500 vehicle spawns.
Help :) -
//Custom Spawns file// /* Custom group spawns Eg. [[953.237,4486.48,0.001], //position 4, //Number Of units 1, //Skill level 0-1 or skill array number if using custom skills "Random" for random Skill array. "Random", //Primary gun set number. "Random" for random weapon set. 4, //Number of magazines "", //Backpack "" for random or classname here. "Bandit2_DZ", //Skin "" for random or classname here. "Random" //Gearset number. "Random" for random gear set. ] call spawn_group; Place your custom group spawns below */ // Death Alley [[7994.49,13659.3,0],9,1,"Random",8,"","Random","Random"] call spawn_group; //Group1 [[8100.5,13527.5,0],9,1,"Random",8,"","Random","Random"] call spawn_group; //Group2 //Novylug [[9610.84,11279.6,0],7,1,"Random",8,"","Random","Random"] call spawn_group; //Patrol //NWAF base [[4481.76,10249.8,0],7,1,"Random",8,"","Random","Random"] call spawn_group; //Patrol /* Custom static weapon spawns Eg. (with one position) [[[911.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Custom static weapon spawns Eg. (with mutiple positions) [[[911.21545,4532.7612,2.6292224],[921.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Place your custom static weapon spawns below */ /* Custom Chopper Patrol spawn Eg. [[725.391,4526.06,0], //Position to patrol [0,0,0], // Position to spawn chopper at 2000, //Radius of patrol 10, //Number of waypoints to give "UH1H_DZ", //Classname of vehicle (make sure it has driver and two gunners) 1 //Skill level of units ] spawn heli_patrol; Place your heli patrols below */ /* Custom Vehicle patrol spawns Eg. (Watch out they are stupid) [[725.391,4526.06,0], //Position to patrol [725.391,4526.06,0], // Position to spawn at 200, //Radius of patrol 10, //Number of waypoints to give "HMMWV_Armored", //Classname of vehicle (make sure it has driver and gunner) 1 //Skill level of units ] spawn vehicle_patrol; Place your vehicle patrols below this line */ /* Paradropped unit custom spawn Eg. [[911.21545,4532.7612,2.6292224], //Position that units will be dropped by [0,0,0], //Starting position of the heli 400, //Radius from drop position a player has to be to spawn chopper "UH1H_DZ", //Classname of chopper (Make sure it has 2 gunner seats!) 5, //Number of units to be para dropped 1, //Skill level 0-1 or skill array number if using custom skills "Random" for random Skill array. "Random", //Primary gun set number. "Random" for random weapon set. 4, //Number of magazines "", //Backpack "" for random or classname here. "Bandit2_DZ", //Skin "" for random or classname here. "Random", //Gearset number. "Random" for random gear set. True //True: Heli will stay at position and fight. False: Heli will leave if not under fire. ] spawn heli_para; Place your paradrop spawns under this line */
There :P
-
I just went back to v1.2 and it works great.
Can we have a link for this? 1.3doesnt work for me
-
Still need help.
-
Didint work still. I don't know why!
-
I tried to set an heli as evac and now when I call it it says there is no evac chopper in the evac field... No one can use it either I got 5 people to try it.
-
[[8100.5,13527.5, ],9,1,"Random",8,"","Random","Random"] call spawn_group; //Group2
[8100.5,13527.5, ]
[8100.5,13527.5,0]
Your welcome :)
Thats the only reason why no AI group is spawning??? xD
-
I support this. It would be really usefull to indicate where domes are as well!
-
I tried using custom spawns feature, and it didint work at all.
Can someone help me with it? Here is my code
//Custom Spawns file// /* Custom group spawns Eg. [[953.237,4486.48,0.001], //position 4, //Number Of units 1, //Skill level 0-1 or skill array number if using custom skills "Random" for random Skill array. "Random", //Primary gun set number. "Random" for random weapon set. 4, //Number of magazines "", //Backpack "" for random or classname here. "Bandit2_DZ", //Skin "" for random or classname here. "Random" //Gearset number. "Random" for random gear set. ] call spawn_group; Place your custom group spawns below */ // Death Alley [[7994.49,13659.3,0],9,1,"Random",8,"","Random","Random"] call spawn_group; //Group1 [[8100.5,13527.5, ],9,1,"Random",8,"","Random","Random"] call spawn_group; //Group2 //Novylug [[9610.84,11279.6,0],7,1,"Random",8,"","Random","Random"] call spawn_group; //Patrol //NWAF base [[4481.76,10249.8,0],7,1,"Random",8,"","Random","Random"] call spawn_group; //Patrol /* Custom static weapon spawns Eg. (with one position) [[[911.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Custom static weapon spawns Eg. (with mutiple positions) [[[911.21545,4532.7612,2.6292224],[921.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Place your custom static weapon spawns below */ /* Custom Chopper Patrol spawn Eg. /////////////////////////////////////////////ETC ETC ETC////////////////////////////////////////
-
Same here I would like to see that also! Would be cool for RPG servers as well
-
I use this script for zombie free bases. It makes it so plot poles will TP zombies in a offmap zone!
//--------------------------------------------------------------------- // Epoch Base Safe Area // By MadMartyr // Modified from generic ZombieShield code by felixberndt and meat // http://opendayz.net/threads/prevent-zombie-spawning.8799/#post-32461 //--------------------------------------------------------------------- while {true} do { sleep 10; // No Zeds near Plot Poles _playerPos = getPos player; _nearPole = nearestObject [_playerPos, "Plastic_Pole_EP1_DZ"]; if (!isNull _nearPole) then { _pos2 = getPos _nearPole; _zombies2 = _pos2 nearEntities ["zZombie_Base", dayz_poleSafeArea]; _count2 = count _zombies2; for "_i" from 0 to (_count2 -1) do { _zombie2 = _zombies2 select _i; _zombie2 setpos [-3367.739,-120.84577,-8247.0625]; }; }; }; -
My custom spawns do not work neither does the whole thing I think... I will try reinstalling it I guess :/
-
When I made my evac chopper on Epoch chernarus (with a blackhawk) it worked first time. I landed it back and now it says *there is no evac chopper in your evac chopper field* or something like that.
Also when I tried landing another helicopter it didint work either. Even the first time I set it as evac it said there was no helicopter on the evac field.
Any idea ? -
I am having issues when server gets over 30 players on. Some people get loadout, some don't... and most of the time the customs ones doesn't work at all.
//Default Loadout DefaultMagazines = ["ItemBandage","ItemBandage","ItemPainkiller","FoodCanSardines","ItemWaterbottle","15Rnd_9x19_M9SD","15Rnd_9x19_M9SD"]; DefaultWeapons = ["Itemtoolbox","ItemMap","ItemHatchet_DZE","ItemCompass","ItemKnife","M9SD"]; DefaultBackpack = "DZ_Patrol_Pack_EP1"; DefaultBackpackWeapon = ""; //Sniper Loadout if ((getPlayerUID player) in ["xxxxxxxx","xxxxxxxx"]) then { // Delta_Ghrim and Mads DefaultMagazines = ["ItemBandage","ItemBandage","ItemBandage","ItemBandage","15Rnd_9x19_M9SD","15Rnd_9x19_M9SD","ItemMorphine","ItemPainkiller","ItemBloodbag","ItemWaterbottleBoiled","ItemWaterbottleBoiled","FoodSteakCooked","20Rnd_762x51_DMR","20Rnd_762x51_DMR","20Rnd_762x51_DMR","Skin_Sniper1_DZ"]; DefaultWeapons = ["M9SD","DMR","Binocular_Vector","NVGoggles","ItemMap","ItemCompass","ItemGPS","ItemWatch","ItemKnife","Itemtoolbox","ItemCrowbar","Itemetool","ItemHatchet_DZE","Itemetool"]; DefaultBackpack = "DZ_Backpack_EP1"; DefaultBackpackWeapon = ""; }; -
Need help still
-
I have the excelisor bridge right now, but for some reason it keep messing up and shit...
I also don't like the fact that it is arriving on the bottom of the hill... Is there another type of skalisty bridge somewhere one the forums of dayz? Or whatever?
-
I want to use this system only for custom spawns location (AI city etc).
Atm, it spawns a plane/jet/heli flying around (which I don't want)... I ONLY WANT custom spawns. I have a mission system so... can anyone help me with setting it up only for custom spawns? -
Still needing help.
-
I can't get the custom spawns to work and it keekps spawning either a jet or heli patrol flying around...
Any ideas how to fix this?
My custom spawn file:
//Custom Spawns file// /* Custom group spawns Eg. [[4481.76, 10249.8, 0], //position 9, //Number Of units 1, //Skill level 0-1 or skill array number if using custom skills "Random" for random Skill array. "Random", //Primary gun set number. "Random" for random weapon set. 4, //Number of magazines "", //Backpack "" for random or classname here. "Soldier1_DZ", //Skin "" for random or classname here. "Random" //Gearset number. "Random" for random gear set. ] call spawn_group; Place your custom group spawns below */ // Death Alley [[7994.49, 13659.3, 0],9,1,"Random",8,"","Soldier1_DZ","Random"] call spawn_group; //Group1 [[8100.5, 13527.5, 0],9,1,"Random",8,"","Soldier_DZ","Random"] call spawn_group; //Group2 //Novylug [[9610.84, 11279.6, 0],7,1,"Random",8,"","Soldier_DZ","Random"] call spawn_group; //Patrol //NWAF base [[4481.76, 10249.8, 0],7,1,"Random",8,"","Soldier_DZ","Random"] call spawn_group; //Patrol /* Custom static weapon spawns Eg. (with one position) [[[911.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Custom static weapon spawns Eg. (with mutiple positions) [[[911.21545,4532.7612,2.6292224],[921.21545,4532.7612,2.6292224]], //position(s) (can be multiple). "M2StaticMG", //Classname of turret 0.5, //Skill level 0-1. Has no effect if using custom skills "Bandit2_DZ", //Skin "" for random or classname here. 1, //Primary gun set number. "Random" for random weapon set. (not needed if ai_static_useweapon = False) 2, //Number of magazines. (not needed if ai_static_useweapon = False) "", //Backpack "" for random or classname here. (not needed if ai_static_useweapon = False) "Random" //Gearset number. "Random" for random gear set. (not needed if ai_static_useweapon = False) ] call spawn_static; Place your custom static weapon spawns below */ /* Custom Chopper Patrol spawn Eg. [[725.391,4526.06,0], //Position to patrol [0,0,0], // Position to spawn chopper at 2000, //Radius of patrol 10, //Number of waypoints to give "UH1H_DZ", //Classname of vehicle (make sure it has driver and two gunners) 1 //Skill level of units ] spawn heli_patrol; Place your heli patrols below */ /* Custom Vehicle patrol spawns Eg. (Watch out they are stupid) [[725.391,4526.06,0], //Position to patrol [725.391,4526.06,0], // Position to spawn at 200, //Radius of patrol 10, //Number of waypoints to give "HMMWV_Armored", //Classname of vehicle (make sure it has driver and gunner) 1 //Skill level of units ] spawn vehicle_patrol; Place your vehicle patrols below this line */ /* Paradropped unit custom spawn Eg. [[911.21545,4532.7612,2.6292224], //Position that units will be dropped by [0,0,0], //Starting position of the heli 400, //Radius from drop position a player has to be to spawn chopper "UH1H_DZ", //Classname of chopper (Make sure it has 2 gunner seats!) 5, //Number of units to be para dropped 1, //Skill level 0-1 or skill array number if using custom skills "Random" for random Skill array. "Random", //Primary gun set number. "Random" for random weapon set. 4, //Number of magazines "", //Backpack "" for random or classname here. "Bandit2_DZ", //Skin "" for random or classname here. "Random", //Gearset number. "Random" for random gear set. True //True: Heli will stay at position and fight. False: Heli will leave if not under fire. ] spawn heli_para; Place your paradrop spawns under this line */
What changes do I need to make?
-
From the words of Buttface, the DZAI creator.
http://opendayz.net/threads/a-i-base-guards.18413/#post-92765
Basically even if you change the behavior and such, it still wont work, as its a lot more complex than that.
Ok thank you very much. I will try to get Wicked Static spawns working.
I also have a problem... There is always either a heli or a JET flying around (AI controlled). I don't know why since I don't even have them enabled... as far as I know,
I only want STATIC SPAWNS with Wicked as I use DZMS for missions.
-
Ok what about other systems if I take apart the Friendly part? Is there a way to make AIs on certain places on combat state *RED* (which in WickedAI seems to be open fire on sight) and some other spawns would be *Green* 9which again in WickedAI seems to be Fire if fired at).
Part of code I am referring at:
_unitGroup setBehaviour "AWARE"; _unitGroup setSpeedMode "FULL"; _unitGroup setCombatMode "RED";
I have seen that RED means they will engage at will and some stuff such as open fire. Green was meant to be associated with *Fire if fired upon*.
I am still looking at my files to find where I read that.
EDIT: Found this https://community.bistudio.com/wiki/ArmA:_AI_Combat_Modes
-
DAYZ EPOCH 1.0.4.2
I would like to know if there is an AI system that supports DZMS (vampire's ai mission system) and have custom static spawns that can be hostiles to everyone and some that are Friendly unless shot at?
I don't want roaming AIs I just want the AIs to spawn at 5-6 places and defend them. The Friendly ones (lets call them Green) would be like the military groups defending outposts for survivors. They would therefore shoot zombies, and survivors if they shoot them. The hostiles (let's call them RED) would rather open fire at everyone they see as on Salvation city.
If anyone has an idea or a suggestion I would appreciate it.
Regards -
DZMS will work fine with WickedAI. The missions will run alongside eachother.
Okok. I would like to know how to change the crate content... cus so far it is alot OP.
Is there files to change them? I would make less stuff for the missions...
How to clean old vehicles
in Scripting
Posted
I got it working by removing some parts. Reason was DayZ.ST has diff database setup. Final code was this: