Jump to content
ersan

DayZ.ST - $30/mo for 50 Slot US/EU Servers - FTP - DayZ 1.8.0.3 - Epoch 1.0.3.1 - Instant Setup - Custom Panel - Live Map Tool

Recommended Posts

I have not "hacked" anything. There is always room for competition, and more than one direction with something. I'm honestly sorry I've upset you so much Tucker, but I still strongly feel that healthy competition and opposing design directions can only serve to refine the Taviana experience.

I would consider hosting your version if you guys work the bugs out of it. Additionally, if you want people to choose your version over EUs, you need to add vehicles or other variations in the map to improve the and surpass it.

Share this post


Link to post
Share on other sites

Okay - I am figuring this out trial by fire...

I figured out the map tool (mission.biedi in arma 2 documents folder) and was given this code... The first instance I was able to insert no problem. 25 rows successfully added.

INSERT INTO `building` (`id`, `class_name`) VALUES ('1','Land_Fort_Watchtower'), ('2','Land_fortified_nest_big'), ('3','Land_CamoNetB_EAST'), ('4','Misc_cargo_cont_net1'), ('5','Misc_cargo_cont_tiny'), ('6','MASH'), ('7','Land_fort_bagfence_long'), ('8','Fort_Nest_M240'), ('9','Land_HBarrier_large'), ('10','WarfareBCamp'), ('11','LAV25_HQ_unfolded'), ('12','USMC_WarfareBVehicleServicePoint'), ('13','USMC_WarfareBBarracks'), ('14','Land_Fuel_tank_stairs'), ('15','Base_WarfareBBarrier10xTall'), ('16','Land_tent_east'), ('17','Hhedgehog_concreteBig'), ('18','Land_water_tank'), ('19','Land_CamoNet_EAST'), ('20','Barrack2'), ('21','Land_fortified_nest_small'), ('22','Land_CamoNetVar_EAST'), ('23','Land_Mil_Barracks_i'), ('24','USMC_WarfareBAntiAirRadar'), ('25','USMC_WarfareBFieldhHospital');

This next one doesn't work for me...

INSERT INTO `instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','198.105.220.164','[-39.78,[530.25,3173.6,0]]'), ('2','198.105.220.164','[-294.89,[519.66,3184.05,0]]'), ('3','198.105.220.164','[-95.78,[512.31,3206.85,0]]'), ('4','198.105.220.164','[0,[512.14,3202.89,0]]'), ('3','198.105.220.164','[-76.12,[502.81,3233.02,0]]'), ('1','198.105.220.164','[-183.43,[327.49,2713.31,-0]]'), ('1','198.105.220.164','[0,[1639.61,7326.44,0]]'), ('5','198.105.220.164','[0,[1639.17,7325.52,-0]]'), ('3','198.105.220.164','[118.85,[1624.55,7339.83,-0]]'), ('1','198.105.220.164','[-183.43,[485.67,10392.86,0]]'), ('3','198.105.220.164',' blah blah blah it's long and ends with ;

That last one I keep an error like this

#1452 - Cannot add or update a child row: a foreign key constraint fails (`blissuserid`.`instance_building`, CONSTRAINT `instance_building_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`))

How can I get this to work? The map was made with Arma II 3D editor

Edited by survivorcarl

Share this post


Link to post
Share on other sites

Okay - I am figuring this out trial by fire...

I figured out the map tool (mission.biedi in arma 2 documents folder) and was given this code... The first instance I was able to insert no problem. 25 rows successfully added.

INSERT INTO `building` (`id`, `class_name`) VALUES ('1','Land_Fort_Watchtower'), ('2','Land_fortified_nest_big'), ('3','Land_CamoNetB_EAST'), ('4','Misc_cargo_cont_net1'), ('5','Misc_cargo_cont_tiny'), ('6','MASH'), ('7','Land_fort_bagfence_long'), ('8','Fort_Nest_M240'), ('9','Land_HBarrier_large'), ('10','WarfareBCamp'), ('11','LAV25_HQ_unfolded'), ('12','USMC_WarfareBVehicleServicePoint'), ('13','USMC_WarfareBBarracks'), ('14','Land_Fuel_tank_stairs'), ('15','Base_WarfareBBarrier10xTall'), ('16','Land_tent_east'), ('17','Hhedgehog_concreteBig'), ('18','Land_water_tank'), ('19','Land_CamoNet_EAST'), ('20','Barrack2'), ('21','Land_fortified_nest_small'), ('22','Land_CamoNetVar_EAST'), ('23','Land_Mil_Barracks_i'), ('24','USMC_WarfareBAntiAirRadar'), ('25','USMC_WarfareBFieldhHospital');

This next one doesn't work for me...

INSERT INTO `instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','198.105.220.164','[-39.78,[530.25,3173.6,0]]'), ('2','198.105.220.164','[-294.89,[519.66,3184.05,0]]'), ('3','198.105.220.164','[-95.78,[512.31,3206.85,0]]'), ('4','198.105.220.164','[0,[512.14,3202.89,0]]'), ('3','198.105.220.164','[-76.12,[502.81,3233.02,0]]'), ('1','198.105.220.164','[-183.43,[327.49,2713.31,-0]]'), ('1','198.105.220.164','[0,[1639.61,7326.44,0]]'), ('5','198.105.220.164','[0,[1639.17,7325.52,-0]]'), ('3','198.105.220.164','[118.85,[1624.55,7339.83,-0]]'), ('1','198.105.220.164','[-183.43,[485.67,10392.86,0]]'), ('3','198.105.220.164',' blah blah blah it's long and ends with ;

That last one I keep an error like this

#1452 - Cannot add or update a child row: a foreign key constraint fails (`blissuserid`.`instance_building`, CONSTRAINT `instance_building_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`))

How can I get this to work? The map was made with Arma II 3D editor

If you would like a hand hit me up on my website or on my teamspeak all the info is at www.goat-land.com

Also the EU version just needs to be locked down more as you can spawn in some crazy vehicles lol. Also hackers with the new bypass can spawn in anything just a heads up also thank you for letting us use the eu version .

Share this post


Link to post
Share on other sites
If you would like a hand hit me up on my website or on my teamspeak all the info is at www.goat-land.com

Hey, thanks for the offer! I don't have team speak. Based on the error I am getting is there anything I can do differently? The map has custom buildings and fortification placements that's it. All vehicle stuff has been done through Days.St control panel.

Share this post


Link to post
Share on other sites

Hey, thanks for the offer! I don't have team speak. Based on the error I am getting is there anything I can do differently? The map has custom buildings and fortification placements that's it. All vehicle stuff has been done through Days.St control panel.

I am shocking at explaining shit this way lol if ya have skype leve ya name and i will add you it will only take me 5mins to talk you thu the steps. I will be making a vid some time this week on now to do it as there are no good ones out there and i had to teach myself how to do it all lol as people was just not willing to help. I will also have all the info you will need on my website well my new one once i get it up and running.

Share this post


Link to post
Share on other sites

Dude type that shit in here lol, i am pretty proficient with simple instructions... I just need to get that one INSERT copy/paste into the building_instance table.

Share this post


Link to post
Share on other sites

Is there seriously nobody who can help me import my custom buildings into my Dayz.ST server??!?! I know many of you have done it successfully.

When I use the map tool for Bliss I get two sections of MYSQL queries to run... The first works fine. Adds 25 items to my database.

This next one (instance_building) doesn't work for me...

INSERT INTO `instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','198.105.220.164','[-39.78,[530.25,3173.6,0]]'), ('2','198.105.220.164','[-294.89,[519.66,3184.05,0]]'), ('3','198.105.220.164','[-95.78,[512.31,3206.85,0]]'), ('4','198.105.220.164','[0,[512.14,3202.89,0]]'), ('3','198.105.220.164','[-76.12,[502.81,3233.02,0]]'), ('1','198.105.220.164','[-183.43,[327.49,2713.31,-0]]'), ('1','198.105.220.164','[0,[1639.61,7326.44,0]]'), ('5','198.105.220.164','[0,[1639.17,7325.52,-0]]'), ('3','198.105.220.164','[118.85,[1624.55,7339.83,-0]]'), ('1','198.105.220.164','[-183.43,[485.67,10392.86,0]]'), ('3','198.105.220.164',' blah blah blah it's long and ends with ;

That last one I keep an error like this

#1452 - Cannot add or update a child row: a foreign key constraint fails (`blissuserid`.`instance_building`, CONSTRAINT `instance_building_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`))

Edited by survivorcarl

Share this post


Link to post
Share on other sites

Is there seriously nobody who can help me import my custom buildings into my Dayz.ST server??!?! I know many of you have done it successfully.

When I use the map tool for Bliss I get two sections of MYSQL queries to run... The first works fine. Adds 25 items to my database.

This next one (instance_building) doesn't work for me...

Do you all redy have buildings in the table? if so you need to change the id number so like if you have buildings 1-50 then you need the next lot to go from 50 -**

Share this post


Link to post
Share on other sites
Quote

http://dayzmod.com/f...80#entry1051508

Thanks Sinoco! Now it took my changes into the DB, now let's try a server restart and see if it actually worked!

The data seems to be in the database but after a restart no buildings have spawned lol.... I am pulling my hair out, here... wasted the entire day lol.

Share this post


Link to post
Share on other sites

C'mon guys... Help me out and I'll STFU. I've seemingly added all paramters to database for Buildings and Instance_building but after 2 restarts and 1 shut down/restart my custom bases are still not spawning!!!??

What am I doing wrong... so many of you have got this working.

Share this post


Link to post
Share on other sites

Okay - I am figuring this out trial by fire...

I figured out the map tool (mission.biedi in arma 2 documents folder) and was given this code... The first instance I was able to insert no problem. 25 rows successfully added.

INSERT INTO `building` (`id`, `class_name`) VALUES ('1','Land_Fort_Watchtower'), ('2','Land_fortified_nest_big'), ('3','Land_CamoNetB_EAST'), ('4','Misc_cargo_cont_net1'), ('5','Misc_cargo_cont_tiny'), ('6','MASH'), ('7','Land_fort_bagfence_long'), ('8','Fort_Nest_M240'), ('9','Land_HBarrier_large'), ('10','WarfareBCamp'), ('11','LAV25_HQ_unfolded'), ('12','USMC_WarfareBVehicleServicePoint'), ('13','USMC_WarfareBBarracks'), ('14','Land_Fuel_tank_stairs'), ('15','Base_WarfareBBarrier10xTall'), ('16','Land_tent_east'), ('17','Hhedgehog_concreteBig'), ('18','Land_water_tank'), ('19','Land_CamoNet_EAST'), ('20','Barrack2'), ('21','Land_fortified_nest_small'), ('22','Land_CamoNetVar_EAST'), ('23','Land_Mil_Barracks_i'), ('24','USMC_WarfareBAntiAirRadar'), ('25','USMC_WarfareBFieldhHospital');

This next one doesn't work for me...

INSERT INTO `instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','198.105.220.164','[-39.78,[530.25,3173.6,0]]'), ('2','198.105.220.164','[-294.89,[519.66,3184.05,0]]'), ('3','198.105.220.164','[-95.78,[512.31,3206.85,0]]'), ('4','198.105.220.164','[0,[512.14,3202.89,0]]'), ('3','198.105.220.164','[-76.12,[502.81,3233.02,0]]'), ('1','198.105.220.164','[-183.43,[327.49,2713.31,-0]]'), ('1','198.105.220.164','[0,[1639.61,7326.44,0]]'), ('5','198.105.220.164','[0,[1639.17,7325.52,-0]]'), ('3','198.105.220.164','[118.85,[1624.55,7339.83,-0]]'), ('1','198.105.220.164','[-183.43,[485.67,10392.86,0]]'), ('3','198.105.220.164',' blah blah blah it's long and ends with ;

That last one I keep an error like this

#1452 - Cannot add or update a child row: a foreign key constraint fails (`blissuserid`.`instance_building`, CONSTRAINT `instance_building_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`))

How can I get this to work? The map was made with Arma II 3D editor

well i can tell you your instance id is wrong you have a ip address in there look at your control panel on the left look for database username bliss_ numbers those numbers are your instance_id replace the ip with those

numbers

this is wrong : ('1','198.105.220.164','[-39.78,[530.25,3173.6,0]]') should look something like this ('1','245','[-39.78,[530.25,3173.6,0]]')

Share this post


Link to post
Share on other sites

ah ha.... Thanks MTucker... I am on it! I am not sure how that happened? In the field for Bliss Database ID I keep getting an error if I enter my actual ID? I entered my IP and it shot out the SQL querys to copy paste... I'll try what you said with a simple find/replace of the query, should work

Thank you!

Share this post


Link to post
Share on other sites

Anyone know where to find a list of all vehicles,gunz, skins etc. that can be used on Taviana (DAYZLAND.EU)?

Edit: Kill messages dont work on Taviana? Is that totally normal?

Edited by sukkaed

Share this post


Link to post
Share on other sites

ah ha.... Thanks MTucker... I am on it! I am not sure how that happened? In the field for Bliss Database ID I keep getting an error if I enter my actual ID? I entered my IP and it shot out the SQL querys to copy paste... I'll try what you said with a simple find/replace of the query, should work

Thank you!

just make sure that you remove the bliss part and have just the numbers

if you have anymore problems ill PM you my TS info and i can walk you thru it just to make sure that your crossing the T and dotting the i

Edited by MTUCKER0

Share this post


Link to post
Share on other sites

I am not sure if I have seen this asked here before, but do you plan on providing hosting for the mod and the standalone when it comes out ersan? You are IMO the best host and I would like to keep my future business with you.

Share this post


Link to post
Share on other sites

I am not sure if I have seen this asked here before, but do you plan on providing hosting for the mod and the standalone when it comes out ersan? You are IMO the best host and I would like to keep my future business with you.

Indeed, when it is available you will be able to switch between mod and standalone in the control panel.

Share this post


Link to post
Share on other sites

Anyone know where to find a list of all vehicles,gunz, skins etc. that can be used on Taviana (DAYZLAND.EU)?

Edit: Kill messages dont work on Taviana? Is that totally normal?

I can't speak for DayZLand.Eu's version - but we've noticed the same thing with folks running the latest bliss package of our Taviana. The issue is in the database, and if we're able to track down a resolution I'd be more than happy to share it with Alex & DayZLand.Eu.

Share this post


Link to post
Share on other sites

May want to check the Salt Lake City node, both our servers there are pinging out every 10 seconds.

Share this post


Link to post
Share on other sites

May want to check the Salt Lake City node, both our servers there are pinging out every 10 seconds.

Yeah just noticed this a few minutes ago, seems to be a problem with the datacenter, all servers there are getting heavy packet loss. We informed the datacenter, these types of issues are usually resolved quickly.

EDIT: They told me it's because of a large inbound DDoS at the datacenter (not directed at us, just somebody else hosted there). It must be pretty big if it's causing that many problems. I'm sure it will return to normal soon.

EDIT2: Seems like it's back to normal now.

Edited by ersan191
  • Like 1

Share this post


Link to post
Share on other sites

Thanks MTucker - Custom Bases - COMPLETE!!! Yay!

Now onto my next question... I am spawning gun/ammo crates

Do any of you have a quick copy/paste text file of rMod Guns/Ammo to copy/paste into the Crate Inventory in the Instance_Vehicle table? Or am I stuck making one from scratch lol...

I noticed I could spawn weapon crates with various weapons in the arma 3D editor (like USspecialweapons for example)... I am guessing these don't work in Dayz? OR HOW do I make on in the 3d editor and then get the proper SQL entries from one of them to copy/paste into inventory in PHPMyAdmin?

Thanks!

Share this post


Link to post
Share on other sites

Thanks MTucker - Custom Bases - COMPLETE!!! Yay!

Now onto my next question... I am spawning gun/ammo crates

Do any of you have a quick copy/paste text file of rMod Guns/Ammo to copy/paste into the Crate Inventory in the Instance_Vehicle table? Or am I stuck making one from scratch lol...

I noticed I could spawn weapon crates with various weapons in the arma 3D editor (like USspecialweapons for example)... I am guessing these don't work in Dayz? OR HOW do I make on in the 3d editor and then get the proper SQL entries from one of them to copy/paste into inventory in PHPMyAdmin?

Thanks!

i dont have any off hand so yes you will have to make from scratch the ones in the 3d editor should work have never tried to port on over just remember there are some op weapons in those crates

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×