[Share] BrewFest Pack (GObjects, templates, spawns, vendors, items, quests)

[latruwski]

Posted on emupedia by dokgonzo... finally a full brewfest collection with spawns and all

Hello everybody, i'm sorry in advance for my bad english!

What is it?

This patch add the Brewfest in all the major cities, not just in Ironforge and orgrimmar.
It also contains the vendors, the items and fixed quests...

80 creatures templates added
242 creatures Spawns added
38 gameobject templates added
459 gameobject spawns added (no more double or triple spawns)
57 Items added
21 quests added
18 vendors added

Patch for Ascent rev.39+, ok with rev.4268.
It should work on the lastest NCDB. (tested with 1210)

Download:

Filebeam - Free Fast File Hosting

alternate links:
Qsave™ - Quick Save™ - Easy way to share your files
RapidShare: 1-Click Webhosting

Installation

The pack come with 3 sql files:

01-Install.sql (Run this first for installing all the needed stuff)

If you have an error about the quests, just run that query:

ALTER TABLE `quests` ADD COLUMN `RequiredTradeskillValue` INT(5) UNSIGNED DEFAULT 0 NOT NULL AFTER `RequiredTradeskill`;

02-Start_Brewfest_Event.sql (This one will spawn the NPC's and the GO's)

03-End_Brewfest_Event.sql (The last is for closing the event, it will just despawn all the NPC's and the GO's)

It also contain a LUA script for the racing quests, but because of the RegisterQuestEvent function don't work
properly with Ascent, i stopped the work at the beginning...
By the way, maybe LUA is not the best way for scripting that!

Many quests works fine and also most of the items, but not everything, so if someone is interested in keeping
up the work, feel free, and good luck!

Sources & Credits:

worldofwarcraft.com/info/events/brewfest/
thottbot.com
wowhead.com
wow.allakhazam.com
wowwiki.com

Original file from NCDB svn by Walla.
Converted from: Board Message
Thanks to Blackfinal, DarkMessiah, linuxfreak93, ParamYsticK and all the others for their work.
Obviously great thanks to the Ascent creators...
dokgonzo for posting this on emupedia!

Some screenshots:

Brewfest-Outside of Orgrimmar


Brewfest-Outside of Ironforge


Brewfest-Outside of Undercity


Brewfest-Outside of the Exodar


Have fun!
Original thread: Emupedia
note1: if you wnt to thank the poster personaly check the original thread! (or maybe he is here too?)
note2: i havent got the chance to fully test this yet becuz my ISP is ****ing with me ><
note3: i must say, even though there is a lot of brewfest stuff posted already... its nice to finally have a full pack

[b!atch]

Shizzle mah nipple! This is awesome:b

[Snailz]

<3 ty
+rep

[Jamick]

Awesome, Thank you for sharing this. I can remember when brewfest came around I was riding from razor hill to orgrimmar and all the Brewfest objects spawned right when i rode by, Why I was up that early no clue.

Thanks again for sharing this though. it makes for a awesome server event.:wave:

[latruwski]

Thank you for comment

[Lich King]

Awsome! I love brewfest, so fun.. thanks for sharing

[latruwski]

thx for comment