[Sql/Patch] All buildings, models, etc. as Gameobjects

[Tonyfalco]

I'm a bit new in using SQL and I need some help using this patch.
I'm currently running an Arcemu server and using HeidiSQL, but I cannot run fully the SQL batch. I always get the error " Column count doesn't match value count at row 1 "
Thanks in advance.

[Razalan]

Crazy. +rep

[kjankoski]

Is Dalaran included as a spawnable gameobject in this pack?

[SpiXe]

Dalaran is indeed included, yes As well as most other towns and dungoens (if not all)! Open the object list located on the bottom of the first message and search for .wmo files (or just "Dalaran").

To the maker: This is absolutely fantastic! I'm running an RP server with friends and we've been looking for something like this for ages! My friends have already built several cities..

Thanks a lot and my first +rep on this site goes to you!

[kjankoski]

Awesome, now I can spawn Dalaran at the old place and do some cinematics

[Masterkenshin]

You are god

[Dark_Spyro_003]

Thank you all, we will be releasing an update to this patch either soon or right after the cataclysm release for all that extra fun!! =)
Also, we'll weed out more of the crashy gameobjects, feel free to continue reporting them!

^.^ lurves from DS003 !!

[lyonar96]

+Rep to you mate. Thank you so much.

[lyonar96]

There is only one problem. Whenever I spawn npcs inside the building it falls halfway through the floor. Any help?

Sorry for double post.

[Dark_Spyro_003]

There is only one problem. Whenever I spawn npcs inside the building it falls halfway through the floor. Any help?

Sorry for double post.

.npc ongameobject 1 1
(Makes the NPC not fall down if the npc loads before the gameobject does)
If you use a different emulator (other than ArcEmu) you'll have to ask around a bit if it has a similar feature.

Note: There's an edit button.

Edit: You'll need to relog to see the NPCs fixed.

Regards

_____________________________________________________________________
[Posted at 22:27 GMT 2010-08-04]


An update has been released :: 335_001 (3.3.5 #1)
You have two options on how to perform the update:
Either install from scratch (follow default installation instructions, takes longer)
or execute the update:
- You still need to download the WoW patch at the standard location (see above)
- Execute this SQL batch file to update your database.

Changelog:
- These objects have now been made spawneable: Click Me!!
- Here's the full list of spawneable objects: Clicky
- In initial release, I forgot to remove the "000.wmo" crashy WMOs. These have been removed aswell, just like their other numbered brethren!


_____________________________________________________________________
[Posted at 22:30 GMT 2010-08-04]


Coming in several days: versions for MaNGOS and TrinityCore2. Am I missing any other "important" emulators other than those two?

[wour55]

Whenever i click the sql link it says it doesn't exist ;S

[Dark_Spyro_003]

Whenever i click the sql link it says it doesn't exist ;S

Sorry, my bad, fixed!

[lyonar96]

Ok thanks Ill make sure to use the command

[Warwenw]

Thank you +Rep

[deepsky211]

Hey guys.
I've got a HTML ID list for this release for you:
klickme
Pls rep to help me out of leech