[Guide] how successfully insert Offical Blizz Building in game

[arthars1]

*******I don't Think its a repost. I wrote this entire guide myself, everyting in it I found it on my own. Althrough you may already know how or seen how on web site.but everyting in the guide i did myself on my own.*******

LIST OF NEEDED PROGRAM:
Notepad (or any similar program)
MYwowstudio
Navicat (or any similar porgram)


FIRST STEP:

ok first of all open Notepad

and copy this :

INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(XXXXX, 14, ZZZZZ, "NNNNNN", , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

SECOND STEP:

[2.1]Change XXXXX to Any Entry ID (I sugjest to use ID's over 250000 to avoind any error) this Entry ID will be Used to Spawn The Game Object.

[2.2]Make Sure 14 Stays 14 (if you change the flag to another number the item will not work)

[2.3] Now it is the time to use MYwowstudio to find .WMO bulding files.

First open MYwowstudio, with the program, find your World Of Warcraft Directory (ex: C/program files/World of Warcraft)

Then open the Data folder.(ex: C/program files/World of Warcraft/Data)

Then open the folder of the WoW Version you are using (ex: C/program files/World of Warcraft/Data/enUS)

Then Open the MPQ file named patch-enUS

On That file there sould be a Directory named: DBFilesclient Open it.



After That Select GameObjectDisplayInfo.dbc
then there should be a window poping



GO TO THE BLUE SQUARE AND TYPE :Building
then Click On FIND then to cycle through the Building Files click NEXT
(ONCE YOU CHOOSE A FILE MAKE SURE ITS A .WMO FILE IF NOT THE ITEM WILL NOT WORK)

When you found a interesting file look in in the GREEN colon
and Remember the ID.

EX:


THIRD STEP:

INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(XXXXX, 14, ZZZZZ, "NNNNNN", , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

REPLACE ZZZZZ with the ID you found (ex: 629 )

FORTH STEP:

REPLACE NNNNNN with The Name you want the object to have (EX: Orctower01)

FINAL STEP:

Save the Notepad file into .SQL format
Then Execute in your DB with Navicat (or any similar program) into your DB

HERE IS AN EXEMPLE OF THE 629 Orctower01 GAME OBJECT



UPDATE:
HERES A LIST OF COOL STRUCTURE YOU CAN ADD.

SW FRONT ENTRANCE



DARNASUS DRUID TOWER



Humain Chapel



AND THERE MUSH MORE CHEK OUT YOURSELF




AND VOILA YOU GOT ALMOST ANY WOW OFFICIAL BLIZZARD BUILDING TO SPAWN ANYWHERE IN YOUR SERVER ^^

[AfterMidnight]

One question.

Can other's see the building?

[arthars1]

Sure ting il post a list of cool building i managed to insert later on i wont have the time for now ^^











(FOR ALL YOUR CUSTOM SERVER NEEDS PM FOR ITEMS BUILDINGS CREATURE VENDORS )

[amaranth]

client side only i believe

[arthars1]

Everyone that logs on my server can see those building they are added to the DB just like a custom item or a vendor. you can even add spawn Ids for permenent structures.

[estride]

awsome guide! nice work

[Xtinction]

lol Funny Guide

[Neth'zul]

Why would other ppl not see it? Your inserting an object into the game, its not like a modle edit.

[Jodeath]

can you help me find me the Goldshire inn look, i couldnt find it

[guitargod218]

The Goldshire Inn is non-usable using this method, since it's a .wmo (which stands for world model object?). Anyway, it's what Blizzard uses when they make a map, as they want all their buildings to be un-selectable (unlike a chair). Now, some of the .wmos are retrievable using this method, since they were added to the dbc (such as Stormwind and the druid tower). For the rest, you need to either use world building (which is explained in the model editing section), or you can use Walshie's Game Object Repack.

[G4rry]

You missed something. I think it was a 0 on row 4.

Anyway, I fixed it.

INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(XXXXXX, 14, ZZZZZ, "NNNNN", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[Enuf]

I have no idea how to run this in my DB XD Anyone help?

[dingdapk]

nice guid ehelped me find a few building i needed thanks!

[cyianos]

Very detailed and lots of pictures. +rep (Gave out too much today, will give some to ya tomarrow)

[OMGPWN]

This is same as my guide well same point
http://www.mmowned.com/forums/emulat...ects-game.html