Adding buildings via Database

Phenonix

Member
Right First time i've made a big post like this so if there's any problems please lemme know.

----------------------------------------------------------------------------------------------

Step 1 (All maps)
Right first things first you want to do is download the Jon-C5 Editor update here and follow the instructions to install and get it working. This will give you the ability to add more buildings such as fire-stations etc.

Step 2 (Running)
Run Arma 2 as stated in Jon-C5 Editor and when at main menu press Alt+E and select Chernarus for example.

Step 3 (Setup Editor)
At the right hand side of the editor there are some options at the minute though we just need 3, Select Center and double click anywhere on map doesn't matter where then when the box comes up just click okay. Do this again but for the groups and then again for unit. This will allow you to be able to save the map later and look around your map with the unit you created.

Step 4 (Creation)
Create your edits with the vehicle tab and place what you would like to place where, try not to add to much in one go though.

Step 5 (Save)
Save your map as multiplayer (don't know if this matters its just the way i do it).

Step 6 (Finding the right file)
Go into your documents folder, go into arma2 other profiles and then missions. In here you should see all your missions saves. Go into the one you saved example test.chernarus.
In here you want the test.chernarus beldi file, Open this file in notepad ++ ( if you don't have this the download can be found here) .

Step 7 (Building information from beldi file)
Once open you are will be looking at for example.
Code:
objectType="vehicle";
    class Arguments
    {
        POSITION="[13043.407, 3624.3174, -1.3173169]";
        TYPE="Land_molo_krychle";
        AZIMUT="55.226189";
        PARENT="";
    };
This is what we want.

Step 8 (Adding the building to the database)
Now we need to make a list of the buildings that will be added so the database know what they are. In your database go to the Buildings table and you should have 2 columns with ID and Class.
In here you will need to put the ID (I started at 100 and then increment accordingly) and the Class we want to look at the beldi file part TYPE="Land_molo_krychle"; the bit we want is Land_molo_krychle.

When added it should look like this

ID Class
101 Land_molo_krychle

If you where to add 2 of the Land_molo_krychle to your map you do not need to add it again in this table as it is already in.

Step 9 (Putting the building onto your map)
Now you want to go into your database and go into the Instance_buildings.
In here you should have the columns;

ID(Unique to this table)
Building ID(This is the ID of the building you are putting in from the building table)
InstanceID(This is the ID of the map ie 1 is for chernarus)
WorldSpace(This is the buildings position)
Created(I Don't use this think its just for telling you when you created it)

Right in the ID column you want to start from 100 and increase accordingly.
Building ID you want to put what building you want to put there for this tutorial its Land_molo_krychle which will be buildingid 100.
Instance ID need to be 1 for chernarus.

For the world space its works from the beldi file, the database cords work as [2,[7300,3560,0]].

2 is heading
7300 is X
3560 is Y
0 is Z (This is height From ground)

To get these from the beldi you do as follow.
Code:
objectType="vehicle";
    class Arguments
    {
        POSITION="[13043.407, 3624.3174, -1.3173169]";
        TYPE="Land_molo_krychle";
        AZIMUT="55.226189";
        PARENT="";
    };

Azimut is heading = 55.22618913043.407 = X
3624.3174 = Y
-1.3173169 = Z

So when done it should like like [55.226189,[13043.407,3624.3174,-1.3173169]]
After this is all added save

Step 9 (Restart)
Restart your server and your building should now be there.

--------------------------------------------------------------------------------------------

This looks complicated and long but when you get the hang of it you can add whole cities in minutes.
As i said this is my first major post so any problems I've made please lemme know and ill rectify them. Hope this helps

~Phenonix
 
  • Like
Reactions: bFe
Does this also help spawn loot in them? I am looking for help on getting loot to spawn in the newly added buildings. I made sure to only use the buildings that are being used by DayZ, but still can't get loot to spawn in these.
 
i have a Namalsk dayz.st server, im trying to find out what im doing wrong

my biedi file

http://www.mediafire.com/?ppb9p6d8dyb2du7

when i try to paste it in my dayz.st database i get this

2i25rpd.jpg
 
i have a Namalsk dayz.st server, im trying to find out what im doing wrong

my biedi file

http://www.mediafire.com/?ppb9p6d8dyb2du7

when i try to paste it in my dayz.st database i get this
Try inserting this file into your Database, I converted it to SQL for you as Beidi Format will not work. Open it with Wordpad and copy ALL text.
I use Navicat to insert my SQL files, Might be worth checking out.
 

Attachments

  • Document.txt
    857 bytes · Views: 24
I edit my maps a bit differently to this tutorial, I will create a video on how I do ti and post a new thread tomorrow, It will provide another option for adding buildings and objects via database. The video is for servers running bliss, i.e. DayZ.ST.
 
Try inserting this file into your Database, I converted it to SQL for you as Beidi Format will not work. Open it with Wordpad and copy ALL text.
I use Navicat to insert my SQL files, Might be worth checking out.

Hey Stealth, I tried uploading a text document through Navicat and was given an error about source fields not having target fields to go into. I've attached my text document if you had time to check it out? Thank you in advance
 

Attachments

  • 2_21_upload.txt
    6.9 KB · Views: 10
Hey Stealth, I tried uploading a text document through Navicat and was given an error about source fields not having target fields to go into. I've attached my text document if you had time to check it out? Thank you in advance
OK I am having a look through your file and have found some errors already, sorry it is taking sometime but I been creating a tutorial video for you all and the rotten thing failed to fully upload so gotta give it another go, hopefully will get both jobs finalised in the next 4-6 hours.

EDIT: DHuxley, I have found many faults, could you shoot us the beidi file? It might speed the process up.
 
Try inserting this, tested on mine and works fine. oh and delete that file from mediafire if you want too.
 

Attachments

  • Bliss 589_upload.txt
    7 KB · Views: 15
I have been testing this for last couple of days and i have noticed that there is some problems with the buildings moving and not going exactly where you want sometimes(height wise).

@DHuxley - I dont use sql for my database so sorry i couldn't help with this.
 
I have been testing this for last couple of days and i have noticed that there is some problems with the buildings moving and not going exactly where you want sometimes(height wise).
I know the movement you are talking about and it only occurs when you go to edit it again, to avoid there a further process to take I have been doing this with no real issues for over 4 months now. All I can say is if you wish to cnage it remember to empty your instance_building and you Building Tables b4 adding the new file, Also when you open your editor and you notice any movement DO NOT move them, trying to fix them is what F*#Ks them up, any Questions PM me and I will send you my TS details and run you through it all.
 
Well i am currently testing adding via mission file and this seems to be alot quicker but comes with the price of the mission file getting bigger.
 
Each time I try this it creates a .PBO file and when used pbo manager and open it I only see like two lines or symbols.

Im a idiot think i got it.
 
The way i did all of this was by using DayzCC to import everything to a database, Then i used HeidiSQL to back it up, and them imported it all to my current database. This way you dont have to do the copy and pasting part at all.
 
Back
Top