All buildings, models, etc. as Gameobjects (Echeloned Mangos)

[Sidriel]

I have taken the SQL file from http://www.mmowned.com/forums/world-...cemu-only.html

This works for a trinity core! You can PM me if you have errors and I'll try to work it out. (include the error please)

Credit goes to Spyro for coming up with everything, I just used what was there.

DOWNLOAD*NOW!

[Frostic]

does not work on mangos core... does not have the right column count

[Sidriel]

Alright I can edit that fairly easily if u can give me an example query.

[Sidriel]

Again. I can make it work for any core if you give me an example query from the gameobject table.

[endfromflame]

ok so heres my code

INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES (31, 2, 6, 'Old Lion Statue', '', '', '', 84, 0, 0.63, 0, 0, 0, 0, 0, 0, 43, 73, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

[Sidriel]

This is mangos?

[endfromflame]

OK so i updated ur SQL myself and imported it into my DB

[Msg] Finished - 29327 queries executed successfully
--------------------------------------------------

so it works i uploaded it to MegaUpload <.< hope thats ok if not i can upload it somewhere else

Mangos = Gameobject_Template.SQL


i also noticed ur DB query was for Ascent not Mangos

[Ballwinkle]

reupload?

/filler

[Linita]

OK so i updated ur SQL myself and imported it into my DB

[Msg] Finished - 29327 queries executed successfully
--------------------------------------------------

so it works i uploaded it to MegaUpload <.< hope thats ok if not i can upload it somewhere else

Mangos = Gameobject_Template.SQL


i also noticed ur DB query was for Ascent not Mangos

Hello everybody!

I have been looking for game objects for so long, and I cant still make it work. I downloaded your'file (the first one from Sidriel didnt work at all for me) and I have this error...

Everything goes just fine, but ingame, I cannot spawn any go's. Cheeck out my screen. I would really appreciate if somebody could help me to make it work.

Screen. My emu is 3.3.5a...

[predattak]

all buildings ?! u need an SQL patch 4 that .. can u tell me what game objects are in this ?

[Linita]

So... Nobody can help me? >.<

[Sidriel]

You need this patch http://ds003.com/download/gopatch/In...01/patch-D.MPQ (put it in your wow/data folder)

here's the list http://ds003.com/download/gopatch/list.txt

Edit: After looking at your screen, it seems there's some problems. What I would do is re-extract the DBC for your server.

[Linita]

You need this patch http://ds003.com/download/gopatch/In...01/patch-D.MPQ (put it in your wow/data folder)

here's the list http://ds003.com/download/gopatch/list.txt

Edit: After looking at your screen, it seems there's some problems. What I would do is re-extract the DBC for your server.

I downloaded the patch previously. And...

Excuse my english. But could you please explain me how to do that you said in the edit?

[dansku17]

i need help for this one when i try run Sql then i get this error -> "SQL Error (2013): Lost connection to MySQL server durning query"
So what i do to get this work on trinity?

[Sidriel]

Dansku17, you just timed out. Make sure you have a solid connection to your MySQL server during the whole thing.

Linita, usually when you have a server (unless your running off a repack and even then) you extract the DBC, maps, and vmaps from your wow folder. I believe you need to re-extract the DBC, because it looks like the gameobject displayids are not going through.