Gameobjects (Houses)

[reconz]

Hello. I have a slight issue, well really more of a problem (atleast to me).

I got my server up yesterday and such, had been working on it for quite awhile. Just now when I was gonna make a custom 'city' I noticed that NC-DB haven't got those Westfall Houses, and Duskwood Trees. And Stormwind Bridges etc. I tried searching around for it here on the forums, with no results of any up-to-date SQL to add it.

Can anyone point me in the right direction where I could get this..Possibly?
Pwetty pwease :]

[titanexile]

search in your sql data base. if you have one if not get one. i use sqlyog it works well. then go to world then gameobjects. you can see all of the go's in the game. then you could export it to an excel doc for easy access.

[reconz]

As I mentioned - My NC-DB did not include one. Meaning I've already tried searching for it in my database.

[Sandile]

download Mywarcraft studio and WoW model viewer and then look for the gameobjects in WoW model viewer in the world section. When you find a ID you want open up Mywarcraftstudio click on the File thing at the top then click Open MPQ Archive(or just click ctrl+O and point it to your wow directory and then open up the Data folder then enUS/enGB folder and click on the patch-enUS / patch-enGB and open it up. Now click on DBfilesclient and search for gameobjectdisplayinfo. Open it up. A new window will appear, here you will see pretty much. At the top of the window you see a white empty bar, thats the search bar. Write in the name of the gameobject you found in WoW model viewer and click Find. Now you maby found your gameobject, if you didn't then click Next. If nothing happends it means that the gameobject doesn't exist. All gameobjects in Wow Model viewer doesn't exist in the dbc files.
Now to the left of the name you will have a number. Thats the displayid. Now open up your gameobject_names table in your Database and make a new entry. Pick a ID of your choice and a name of your choice and then in displayid write the number you found in Mywarcraftstudio to the left of the name. Here are some gameobject types you can use:
1 - Button
2 - Quest
3 - Chest
4 - Binder
5 - Generic
6 - Trap
7 - Chair
8 - Spell Focus
9 - Text
10 - Goober
11 - Transport
12 - Area Damage
13 - Camera
14 - Map Object
15 - Mo Transport
16 - Duel Arbiter
17 - Fishing Node
18 - Ritual
19 - Mailbox
20 - Auction House
21 - Guard Post
22 - Spell Caster
23 - Meeting Stone
24 - Flag Stand
25 - Fishing Hole
26 - Flag Drop
You will probably use 5 and 14 mainly. when you found a gameobject in Mywarcraftstudio it will say NAME.wmo or NAME.mdx
for wmo files use gameobject type 14 and for mdx files use gameobject type 5. Other types may also work but if you pick gameobject type 5 for wmo files it will just be displayed as blue/white boxes.

Now you are done. Good Luck with your server

[Reflection]

If you want up-to-date premade gameobjects I downloaded and updated over 2000 of them for my last release, credits to 777devil777 for finding them and me for updating them.
There's some houses, trees etc but I've not searched for a bridge yet.

Download
If you wish to make custom gameobjects follow Sandile's guide. /