This guide is a tribute to OMGPWN's thread, but, as his guide's only for Acsent, i thought i'd make one for all the Mangos users.
Before we get on started i just want to point out that i made this guide by my self, i did NOT copy it from any other site or user here on MMowned.
The only difference is the inserted code in notepad.
Anyhoo! Let's get on started!
Programs!
MyWarCraftStudio
Navicat, or anyother MySQL browser program. ( For inserting the object to the server )
Open up MyWarcraftStudio.
Go to, File -> Open MPQ Archive -> Browse to your enGB/enUS folder.(C:\World of
Warcraft\Data\enGB) Open up patch-enGB/enUS.
In the MPQ archive you'll find a folder called "DBFilesClient", open it up!
Scroll down until you find GameObjectDisplayInfo.dbc, open it up!
Now search for whatever object you'd like to import, let's say you want a Lion statue. Write Lion in the search bar, and press Find, and keep on pressing next until you find your desired object.
When that's done, take out the Display ID for the model. ( The random numbers to the left. For the Lion statue it's 6.)
Now open up notepad!
Copy 'n paste this code into Notepad. I'll qoute.
We'll have to edit everything in red, don't panic! I'll help ya out!INSERT INTO gameobject_template
(`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`)
VALUES
(ENTRY, 14, DISPLAYID, 'NAME', '', 35, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
Entry: The desired entry for your object, such as 250000 or so.
Don't touch the 14, don't you DARE touching it!
Display ID: The Display id for the object, in this case, 6.
Name: Just pick a random name, like LionStatueBBQ or something.
Now save the file, name it LionStatueBBQ.sql or what ever you called your object.
Your almost done!
Now open up Navicat or whatever program your using, open up your mangos database and execute batch file, browse to your SQL and your done!
I made this guide as noob friendly as possible, but if you still have questions, don't hesitate to ask.
Well then, thank you for taking your time and reading my guide.
Bye and Peace.
Edit: For everyone that had the MWCS bug, please re-download it from the new link and try again.