DayZ 3D editoring file to db insert converter
*By using this to edit your database, you are doing so at your own risk. You should have some sense of database maintenance, execution and general administration, before using this converter.
**Currently tested on Cherno map DayZ (v.1.7.6.1) using the 3d editor. Has not been tested on 2d editor file or other maps. (Feel free to tell us in the forums if it works on a different map or if you discovered a problem.)
How it works:
This converter is taking all the "class vehicle_#" sections of the "biedi" file provided by 3d editor and building the two sql inserts (tables "building" and "instance_building") for your bliss database.
The id of the building table needs to be set, which is the reason for the starting point (could be 1, but sounds like most people start with 100).
In both inserts, the bliss database number is needed, which is the reason you should put it in the form below. If you are a security freak and are anal about not wanting to type it in, you are not required. However, it is needed when you run your insert. So, if you choose not to add it, or forgot to, you will need to edit your sql inserts. (refer to the first asterisk above)
Instructions:
Create your "<name>.biedi" file from 3d editing, open it in notepad (yes, it does not require notepad++). In the form below, enter your bliss number, leave the starting building id or change it, copy the contents of your file, paste it in the text area of the form and hit submit.
The converted information will display below the text area. Copy everything below the text area that displayed, paste into your sql window of your database, click go and enjoy.
Credits:
The converter was built out of necessity, since another site was no longer available. Certain individuals (their videos) helped connect the dots (creating the "mission.biedi" file from the 3d editor, screen screenshots of the what the sql commands are, etc.) The following peeps were the inspiration: zzblurgames (3d editor video), Dave Croucher (2d editor video, but still inspired me) and GathMan (my php goto guy when I get stuck).
|