Brewfest Scripting

http://images2.wikia.nocookie.net/__cb20090920182328/wowwiki/images/a/a0/Brewfest.png

Topic of development, enjoy. /emoticons/default_smile.png

If there are no credits given it means that it’s me who wrote it.

Tapper Swindlekeg

Ipfelkofer Ironkeg

http://paste2.org/p/1679325

Areatrigger script (welcome) - thanks to Shauren for adding the cooldown!

http://paste2.org/p/1663709

http://paste2.org/p/1663711

[Q] Catch the Wild Wolpertinger!

http://paste2.org/p/1667502

[Q] Pink Elekks On Parade - thanks to Kapoeira for aura not present line

http://paste2.org/p/1663718

Miscellaneous stuff. (e.g. npc_vendor, quest_relations, creature_template(_*) updates)

http://paste2.org/p/1679322

Down With The Dark Iron

http://paste2.org/p/1679295 - C++

http://paste2.org/p/1679300 - SQL

This script is still missing a few features but nearly everything works like it should. A lot of thanks go to Josh for helping me out when I really needed me and pushing me into the right directions. Thanks a lot buddy!

Apart from that all credits go to me, if you are going to use this piece of code for your public private server I’d appreciate to get credits. You have no idea how it feels to see when someone uses your work and takes the pride of making it as well. Thanks.

Don’t change sniffed faction values.

Catch the Wild Wolpertinger! dosent work i still get the net on me not on creatures is it just me ?

Are you sure the unit_flag does not have OCC_NOT_ATTACKABLE anymore? It seems like when using Truice it doesn’t always work when updating this way. /emoticons/default_tongue.png

All of em that dosent work? because Chug and Chuck! dose not work tow /emoticons/default_smile.png

Maybe that’s why it has written unfinished above the spoiler. Stop posting bs on this topic.

Almost done with scripting the Dark Iron event on alliance side. Feel free to test!

http://paste2.org/p/1661857

Just waiting some 11 minutes for it to start.

edit: okay it’s starting and the commoners left the snowy field screaming.

The barrels require the character to have an Empty Brewfest Stein which is nowhere to be found (it maybe has to do with complimentary samplers being thrown into nowhere). The Super Steins are also usable but not produce the desired effect. I tried using having my Green Brewfest Stein in inventory and it didn’t help.

The mobs gather near the gallows-like structure on the back of the field and sit there undisturbed, unattackable and immovable.

Clicking on a barrel returns “You must have an empty stein” if you don’t have any in inventory.

“You must have a proper item equipped” if you have some in inventory

And no messages if you have a stein equipped; it plays the “barrel beer shot” animation, though.

The Complimentary Brewfest Samplers do not seem to have any throwing affect attached to them aside from character making a throwing animation.

The Guzzlers mobiles seem to only spawn from one point instead of how in retail they spawn from the “drill-lifts” as seen in Ulduar Razorscale encounter), the drills however kept on appearing for some time (stopped by 3rd minute of invasion). They also walk to one point and sit there (it’s around -5162, -600, 400 gps) near the banners and scene with big barrel of beer.

We’re now entering the 5th minute of invasion and the mobs keep coming and standing looking dumb at the barrel of beer. There are maybe 200 of them at this moment.

We’re in ten minutes into the Great invasion and the mobs are still coming! At least they disappear after a few seconds of standing there in one spot, as far as I notice. There is like a hundred of them standing here watching grass grow at any time since the start of event.

While the stuff is still going on I guess I’ll try other quest fixes. (edit: er, I’ll have to wait until 4-00 to try, I guess).

Drunken stupor achievement doesn’t appear to work when the player is Ice blocked or in a bubble. Nor does it work when the player is not invulnerable (tried with goggles and getting completely smashed). Tested in my usual location for this kind of things Exodar (02:28:10 X: -3842.595215 Y: -11671.397461 Z: -112.164230 Orientation: 2.384514) jumping up and falling down the ramp. I fail to see if any of your snippets fixes the achievement. I know it’s completable at the point where I try on retail since I has just done it on retail on one of my characters.

Yeah, I figured this out right before I went to bed. They should be spawned along with the Complimentary ones I believe.

As for the steins, those are missing object templates which are being sniffed soon. Please note that the spell works exactly like it should now with the conditions also posted in this file. /emoticons/default_smile.png

That’s because of bad way of handling waypoints in my SAI at the moment. /emoticons/default_smile.png It was just a test.

Known, I want to focus on Dark Iron even first.

Also known, just no idea how to solve this yet… I’m hoping Anubiss found a way, he’s been working on Chug and Chuck! quest which includes this kind of spell behaviour.

That’s because we are missing another object template. In this case for the summoned object. I’ve been told it’s being sniffed as it was also missing last yea.

You’re incorrect. Try removing the waypoint, they just visually teleport to their spawn position when they reached WP 1.

Same as above.

I’m planning to finish alliance version today. /emoticons/default_smile.png Thanks for testing. Did you get any config errors? (please don’t say you got ‘Gameobject <Entry: 202401> not exist …’ because I already know that.

Updated version for alliance, still needs work (of course).

http://paste2.org/p/1662816

please note that the wolpertinger quest is ONLY on US realms, the EU realms (where im playing at) have the pet @ 47 silver on the vendor

also the pink eleks are only 2009 and are no longer active

That’s already known, we discussed it on IRC and we decided to remove it from the vendor and use the quest. /emoticons/default_smile.png

History never repeats itself…

Here’s yet another update, still unfinished. We’ll need support for target type UNK which, according to Shauren, will be done by QAston soon. /emoticons/default_smile.png

http://paste2.org/p/1663012

Also according to this video the should say their texts common/orcish and should not attack. Updated that as well. /emoticons/default_smile.png

http://www.youtube.com/watch?v=KboRWphxzwk

UPDATE

Updated Brewfest Organizers again. They now support a small on-quest-complete event.

19:24

Okay. Time for something many have been waiting for. /emoticons/default_smile.png

The script for Dun Morogh is done. Sadly, I just realized that I should have used C++ in order to make the event work (for the Dark Iron Guzzler) on both Durotar AND Dun Morogh, so that’s going to happen the upcoming few days. Here’s a version that’ll make it work pretty neat already:

Only show gossip X if player has aura 43156 after attack

They come every 30 minutes for 5 minutes.

  1. During that time you should drink the freeze booze on the table (at least 1) while aiming at a Dark Dwarf. You’ll throw the mug at them, and an NPC will throw you a new mug.
  2. Map this to a key and spam it while turning left and right.
  3. If they destroy all the kegs, you will not be able to loot the gear.
  4. You can loot the gear once every 12 hours.
  5. The gear will be available from :05 to :20 and :35 to :50 (eg 1:05 is when they stop attacking, it’ll be there for 15 minutes)
  6. This is worth 10 tokens
  7. The “whirlwind” effect is picked up from big mugs that randomly appear on the ground
  8. Stand on tables and you’re less likely to be hit by a DD (serious knockback)

Spawn NPCs inside the kegs for keg arrow marker spell 42761

209 alliance mail
210 horde mail

23808 - [DND] Brewfest Keg Move to Target
24766 - [DND] Brewfest Face Me Bunny
24109 - [DND] Brewfest Target Dummy Move To Target
23894 - [DND] Brewfest Dark Iron Spawn Bunny
23703 - [DND] Brewfest Dark Iron Event Generator

188508 - Dark Iron Mole Machine (Minion Summoner)

42676 - Holiday - Brewfest - Dark Iron Knockback Aura

SCRIPT SUMMARY
We are scripting them on GUID because there’s only one event generator which we use for both factions.
We are making the Event Generator run a script every 30 minutes. On this script it will summon plenty of Spawn Bunnies. All of those Spawn Bunnies will summon their Mole Machine after a specified time and also die and despawn
on cast (TEMPSUMMON_TIMED_OR_DEAD_DESPAWN) to prevent there being cast more than once per bunny. The reason the Dark Iron Guzzlers are always facing correctly is because we are setting orientation of every spawn dummy the
exact same way, together with target_type 1 and target_0 it will always walk outside the ‘door’ of the Mole Machine

Brewers only throw in phase 1

*/

– Misc.
DELETE FROM gameobject WHERE id=186881; – Dark Iron Dwarf Plans should be summoned by event
UPDATE creature_template SET flags_extra=flags_extra|128 WHERE entry=24109; – [DND] Brewfest Target Dummy Move To Target
UPDATE creature_template SET unit_flags=unit_flags|260 WHERE entry IN (23702,23700,23706,24373,24372); – Thunderbrew/Barleybrew/Gordok/T’chalis’s/Drohn’s Festive Keg

– Make the Event Generator spawns only spawn if Brewfest is active Brewfest
DELETE FROM game_event_creature WHERE eventEntry=24 AND guid IN (10045953);
INSERT INTO game_event_creature (eventEntry,guid) VALUES
(24,10045953);

– Add aura ‘Brewfest - Dark Iron Attack - Keg Marker’ to Thunderbrew/Barleybrew/Gordok/T’chalis’s/Drohn’s Festive Keg
DELETE FROM creature_template_addon WHERE entry IN (23702,23700,23706,24373,24372);
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(23702,0,0,0,0,‘42761’),
(23700,0,0,0,0,‘42761’),
(23706,0,0,0,0,‘42761’),
(24373,0,0,0,0,‘42761’),
(24372,0,0,0,0,‘42761’);

– Add Dark Iron Guzzler’s equipment template (taken from sniff)
DELETE FROM creature_equip_template WHERE entry=2477 AND itemEntry1=33125;
INSERT INTO creature_equip_template (entry,itemEntry1,itemEntry2,itemEntry3) VALUES
(2477,33125,0,0);

– Spawn [DND] Brewfest Dark Iron Event Generator
DELETE FROM creature WHERE id=23703 AND guid=10045953;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(10045953,23703,0,1,1,0,0,-5152.3,-603.529,398.356,2.50732,300,0,0,37800,0,0,0,0,0);

– Drunken Master’s triggered spells conditions
DELETE FROM conditions WHERE SourceEntry IN (42695,42794) AND ConditionValue2 IN (23709);
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(13,0,42695,0,18,1,23709,0,0,‘’,“Spell Holiday - Brewfest - Dark Iron Knock-down Power-up can only be cast at Dark Iron Guzzler”),
(13,0,42794,0,18,1,23709,0,0,‘’,“Spell Holiday - Brewfest - Random Mug Fling can only be cast at Dark Iron Guzzler”);

– Insert missing object template for spell Drunken Master’s - it’s a trap and these do not come from sniffs, so WDBVerified on 0.
DELETE FROM gameobject_template WHERE entry=186471;
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,AIName,ScriptName,WDBVerified) VALUES
(186471,6,0,‘Super Brew Stein’,‘’,‘’,‘’,14,0,3,0,0,0,0,0,0,0,0,5,42696,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,‘’,‘’,0);

– [DND] Brewfest Dark Iron Event Generator SAI
SET @ENTRY := 23703;
UPDATE creature_template SET AIName=‘SmartAI’,flags_extra=flags_extra|128 WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid IN (-10045953,@ENTRY100,@ENTRY100+1);
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(-10045953,0,0,0,1,0,100,0,10000,10000,1800000,1800000,80,@ENTRY100,0,2,0,0,0,1,0,0,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - Out of Combat - Run Script”),
(@ENTRY
100,9,0,0,0,0,100,0,14000,14000,0,0,12,24536,1,300000000,0,0,0,1,0,0,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn Dark Iron Herald”),
(@ENTRY100,9,1,0,0,0,100,0,14000,14000,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5168.79,-597.261,398.101,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”), – Time this to give the Brewfest Revelers some time to run away
(@ENTRY
100,9,2,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5154.99,-589.22,397.346,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,3,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5168.34,-585.515,397.688,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,4,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5160.86,-606.37,398.063,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,5,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5163.08,-592.054,398.022,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,6,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5160.24,-579.148,397.18,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,7,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5172.88,-576.9,397.339,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,8,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5180.1,-583.465,397.775,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,9,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5176.84,-592.674,397.622,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,10,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5172.06,-606.161,397.352,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,11,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5162.5,-614.447,397.741,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,12,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5153.05,-618.085,398.125,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,13,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5148.92,-607.028,398.537,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,14,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5155.28,-598.89,398.092,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,15,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5146.97,-591.708,397.372,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,16,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5136.8,-598.046,397.426,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,17,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5162.125000,-599.126953,398.169250,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,18,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5155.227051,-611.064087,398.384796,5.58,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,19,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5172.685547,-617.705200,397.190582,0.80,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,20,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5165.557129,-602.531067,397.959229,2.48,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,21,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5162.540039,-596.897278,398.152252,5.58,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,22,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5171.027832,-590.153503,397.964874,0.80,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,23,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5177.630371,-600.892029,397.344421,2.48,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,24,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5175.105957,-585.409302,397.801575,5.58,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,25,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5160.901367,-585.973755,397.494049,0.80,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,26,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5149.727051,-598.186523,398.000702,2.48,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,27,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5140.413574,-606.157715,398.110840,0.80,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,28,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5148.443359,-613.181458,398.464478,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,29,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5139.434570,-612.224487,398.017578,5.58,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,30,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5160.227051,-622.226868,397.487183,2.53,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,31,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5165.484863,-608.644226,397.621552,3.85,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,32,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5154.422852,-605.168152,398.364655,1.23,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,33,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5156.091309,-594.039612,397.730194,0.32,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,34,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5151.526855,-593.310730,397.529968,0.32,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,35,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5143.669922,-603.026917,398.192719,0.80,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,36,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5142.348633,-595.296265,397.526245,3.32,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,37,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5154.107910,-582.890503,397.179108,6.32,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,38,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5166.127930,-578.236206,397.194489,4.12,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,39,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5182.114746,-589.290283,397.433838,3.21,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,40,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5173.672363,-598.698364,397.764160,5.21,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY100,9,41,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5170.576660,-612.272156,397.254028,1.12,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),
(@ENTRY
100,9,42,0,0,0,100,0,0,0,0,0,12,23894,1,300000000,0,0,0,8,0,0,0,-5157.810059,-615.534058,398.061340,3.21,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn [DND] Brewfest Dark Iron Spawn Bunny”),

(@ENTRY100,9,43,0,0,0,100,0,0,0,0,0,12,23702,1,300000000,0,0,0,8,0,0,0,-5159.85,-632.055,397.179,1.46772,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn Thunderbrew Festive Keg”),
(@ENTRY
100,9,44,0,0,0,100,0,0,0,0,0,12,23706,1,300000000,0,0,0,8,0,0,0,-5146.283691,-576.265930,397.176514,0.09009,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn Gordok Festive Keg”),
(@ENTRY*100,9,45,0,0,0,100,0,0,0,0,0,12,23700,1,300000000,0,0,0,8,0,0,0,-5186.539551,-599.753662,397.176453,0.024872,“[DND] Brewfest Dark Iron Event Generator - On Script - Spawn Barleybrew Festive Keg”),

(@ENTRY100,9,46,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,11,24484,50,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Brewfest Reveler”),
– These are used to spawn Stein Traps
(@ENTRY
100,9,47,0,0,0,100,0,59000,79000,90000,90000,45,2,2,0,0,0,0,11,23685,50,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Gordok Brew Baker”),
(@ENTRY100,9,48,0,0,0,100,0,10000,29000,90000,90000,45,3,3,0,0,0,0,11,23683,50,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Maeve Barleybrew”),
(@ENTRY
100,9,49,0,0,0,100,0,3000,11000,90000,90000,45,4,4,0,0,0,0,11,23684,50,0,0,0,0,0,“[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Ita Thunderbrew”);

– (@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - "),

– [DND] Brewfest Dark Iron Spawn Bunny SAI
SET @ENTRY := 23894;
SET @SPELL_MOLE_MACHINE_SPAWN := 73071;
UPDATE creature_template SET AIName=‘SmartAI’,flags_extra=flags_extra|128 WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid IN (@ENTRY,@ENTRY100);
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,1,1,0,100,1,5000,285000,270000,270000,11,@SPELL_MOLE_MACHINE_SPAWN,2,0,0,0,0,1,0,0,0,0,0,0,0,“[DND] Brewfest Dark Iron Spawn Bunny - Out of Combat - Cast Mole Machine Spawn”),
(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,80,@ENTRY
100,0,2,0,0,0,1,0,0,0,0,0,0,0,“[DND] Brewfest Dark Iron Spawn Bunny - On Mole Machine Spawn - Run Script”),
(@ENTRY100,9,0,0,0,0,100,0,5000,5000,0,0,12,23709,1,300000000,0,0,0,1,0,0,0,0,0,0,3.85,“[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler”),
(@ENTRY
100,9,1,0,0,0,100,0,4000,4000,0,0,12,23709,1,300000000,0,0,0,1,0,0,0,0,0,0,5.58,“[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler”),
(@ENTRY100,9,2,0,0,0,100,0,3000,3000,0,0,12,23709,1,300000000,0,0,0,1,0,0,0,0,0,0,0.80,“[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler”),
(@ENTRY
100,9,3,0,0,0,100,0,2000,2000,0,0,12,23709,1,300000000,0,0,0,1,0,0,0,0,0,0,2.48,“[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler”);

– Dark Iron Guzzler SAI
www.youtube.com/watch?v=4neherfsaEE&feature=related
– 0:47 - attack keg
SET @ENTRY := 23709;
– SET @SPELL_THROW_MUG := xx;
SET @SPELL_KNOCKBACK := 42299;
SET @SPELL_ATTACK_KEG := 42393;
UPDATE creature_template SET AIName=‘SmartAI’,unit_flags=unit_flags|33024,equipment_id=2477 WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid BETWEEN @ENTRY100+0 AND @ENTRY100+8;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,0,0,100,0,1000,5000,9000,11000,11,@SPELL_KNOCKBACK,1,0,0,0,0,2,0,0,0,0,0,0,0,“Dark Iron Guzzler - In Combat - Cast Brewfest - Dark Iron Knockback”),
– (@ENTRY,0,1,0,8,0,100,0,@SPELL_THROW_MUG,0,0,0,45,5,5,0,0,0,0,19,x,0,0,0,0,0,0,“Dark Iron Guzzler - On Spellhit - Set Data Ita Thunderbrew”),
(@ENTRY,0,1,0,1,0,20,1,5000,50000,50000,50000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,“Dark Iron Guzzler - Out of Combat - Say Line 0 (random)”), – We gotta time this REALLY randomly (5k-50k)
(@ENTRY,0,2,0,54,0,100,1,0,0,0,0,46,3,0,0,0,0,0,1,0,0,0,0,0,0,0,“Dark Iron Guzzler - On Spawn - Move Forward”),
(@ENTRY,0,3,0,1,0,100,0,1000,1000,7000,11000,88,@ENTRY100+0,@ENTRY100+8,0,0,0,0,1,0,0,0,0,0,0,0,“Dark Iron Guzzler - On Spawn - Run Random Range Script”),

(@ENTRY100+0,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 0 - Start WP 0”),
(@ENTRY
100+1,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+1,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 1 - Start WP 1”),
(@ENTRY100+2,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+2,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 2 - Start WP 2”),
(@ENTRY
100+3,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+3,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 3 - Start WP 3”),
(@ENTRY100+4,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+4,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 4 - Start WP 4”),
(@ENTRY
100+5,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+5,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 5 - Start WP 5”),
(@ENTRY100+6,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+6,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 6 - Start WP 6”),
(@ENTRY
100+7,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+7,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 7 - Start WP 7”),
(@ENTRY*100+8,9,0,0,0,0,100,0,0,0,0,0,53,0,@ENTRY+8,0,0,0,0,2,1,0,0,0,0,0,0,“Dark Iron Guzzler - On Script 8 - Start WP 8”);

– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“Did someone say ‘Free Brew’?”,12,0,100,0,0,0,“Dark Iron Guzzler”),
(@ENTRY,0,1,“DRINK! BRAWL! DRINK! BRAWL!”,12,0,100,0,0,0,“Dark Iron Guzzler”),
(@ENTRY,0,2,“No one expects the Dark Iron Dwarves!”,12,0,100,0,0,0,“Dark Iron Guzzler”),
(@ENTRY,0,3,“Drink it all boys!”,12,0,100,0,0,0,“Dark Iron Guzzler”),
(@ENTRY,0,4,“It’s not a party without some crashers!”,12,0,100,0,0,0,“Dark Iron Guzzler”);

– Waypoints
DELETE FROM waypoints WHERE entry IN (@ENTRY+0,@ENTRY+1,@ENTRY+2,@ENTRY+3,@ENTRY+4,@ENTRY+5,@ENTRY+6,@ENTRY+7,@ENTRY+8);
INSERT INTO waypoints (entry,pointid,position_x,position_y,position_z,point_comment) VALUES
(@ENTRY+0,1,-5146.489258,-605.807678,398.446594,‘Dark Iron Guzzler WP 0’),
(@ENTRY+0,2,-5158.338379,-588.102844,397.464233,‘Dark Iron Guzzler WP 0’),
(@ENTRY+0,3,-5175.240723,-587.899719,397.828186,‘Dark Iron Guzzler WP 0’),
(@ENTRY+0,4,-5182.802734,-598.817505,397.188171,‘Dark Iron Guzzler WP 0’),

(@ENTRY+1,1,-5160.037598,-628.135010,397.238342,‘Dark Iron Guzzler WP 1’),
(@ENTRY+1,2,-5147.790527,-624.794861,397.458496,‘Dark Iron Guzzler WP 1’),
(@ENTRY+1,3,-5146.746582,-580.459961,397.177063,‘Dark Iron Guzzler WP 1’),
(@ENTRY+1,4,-5169.381348,-588.704102,397.934326,‘Dark Iron Guzzler WP 1’),

(@ENTRY+2,1,-5148.005371,-580.531311,397.177277,‘Dark Iron Guzzler WP 2’),
(@ENTRY+2,2,-5154.990234,-608.568787,398.423004,‘Dark Iron Guzzler WP 2’),
(@ENTRY+2,3,-5140.381348,-608.689941,398.133859,‘Dark Iron Guzzler WP 2’),
(@ENTRY+2,4,-5160.680176,-597.021606,398.129120,‘Dark Iron Guzzler WP 2’),

(@ENTRY+3,1,-5140.218750,-595.395020,397.449127,‘Dark Iron Guzzler WP 3’),
(@ENTRY+3,2,-5139.114258,-616.757080,397.802094,‘Dark Iron Guzzler WP 3’),
(@ENTRY+3,3,-5164.573730,-614.278748,397.572937,‘Dark Iron Guzzler WP 3’),
(@ENTRY+3,4,-5162.012695,-599.030029,398.166107,‘Dark Iron Guzzler WP 3’),
(@ENTRY+3,5,-5182.972656,-599.895813,397.184326,‘Dark Iron Guzzler WP 3’),

(@ENTRY+4,1,-5172.705566,-618.836182,397.180695,‘Dark Iron Guzzler WP 4’),
(@ENTRY+4,2,-5175.108398,-600.439087,397.553497,‘Dark Iron Guzzler WP 4’),
(@ENTRY+4,3,-5157.900879,-578.498596,397.177094,‘Dark Iron Guzzler WP 4’),
(@ENTRY+4,4,-5141.636719,-589.796387,397.236328,‘Dark Iron Guzzler WP 4’),

(@ENTRY+5,1,-5170.463379,-607.621582,397.349915,‘Dark Iron Guzzler WP 5’),
(@ENTRY+5,2,-5182.373535,-601.089172,397.179413,‘Dark Iron Guzzler WP 5’),
(@ENTRY+5,3,-5161.325195,-628.776978,397.210480,‘Dark Iron Guzzler WP 5’),
(@ENTRY+5,4,-5140.576172,-594.936035,397.439728,‘Dark Iron Guzzler WP 5’),

(@ENTRY+6,1,-5146.001953,-580.146606,397.176392,‘Dark Iron Guzzler WP 6’),
(@ENTRY+6,2,-5165.176270,-593.882263,398.167328,‘Dark Iron Guzzler WP 6’),
(@ENTRY+6,3,-5168.957031,-612.063538,397.331970,‘Dark Iron Guzzler WP 6’),
(@ENTRY+6,4,-5143.728516,-617.111938,398.086945,‘Dark Iron Guzzler WP 6’),
(@ENTRY+6,5,-5140.344238,-601.234619,397.896271,‘Dark Iron Guzzler WP 6’),

(@ENTRY+7,1,-5168.468750,-623.256653,397.194763,‘Dark Iron Guzzler WP 7’),
(@ENTRY+7,2,-5161.566406,-628.660950,397.211334,‘Dark Iron Guzzler WP 7’), – Thunderbrew
(@ENTRY+7,3,-5149.291016,-623.285828,397.648651,‘Dark Iron Guzzler WP 7’),
(@ENTRY+7,4,-5138.262695,-602.349854,397.771912,‘Dark Iron Guzzler WP 7’),
(@ENTRY+7,5,-5146.134766,-579.840759,397.177277,‘Dark Iron Guzzler WP 7’), – Gordok

(@ENTRY+8,1,-5137.287109,-593.654053,397.267273,‘Dark Iron Guzzler WP 8’),
(@ENTRY+8,2,-5157.076660,-628.726929,397.259186,‘Dark Iron Guzzler WP 8’), – Thunderbrew
(@ENTRY+8,3,-5183.316406,-602.313110,397.177277,‘Dark Iron Guzzler WP 8’); – Barleybrew

– Dark Iron Herald SAI
– Shauren told me to use 0 because the counter is also bugged on retail atm /emoticons/default_tongue.png
SET @ENTRY := 24536;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,1,0,100,1,11000,11000,20000,20000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,“Dark Iron Herald - On Spawn - Yell Line 0”),
(@ENTRY,0,1,0,1,0,100,0,30000,45000,60000,80000,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,“Dark Iron Herald - Out of Combat - Yell Line 1 (random)”);

– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“No one expects the Dark Iron dwarves!”,14,0,100,0,0,0,“Dark Iron Herald”),

(@ENTRY,1,0,“We’ll drink yer stout and lager,$BDrain all the pints and kegs!$BWe’ll drink and brawl and brawl and drink,$B’til we can’t feel our legs!”,12,0,100,0,0,0,“Dark Iron Herald”),
(@ENTRY,1,1,“So lift a mug to Coren,$BAnd Hurley Blackbreath too!$BThis drink is weak, without much kick,$BBut oi! At least it’s brew!”,12,0,100,0,0,0,“Dark Iron Herald”),
(@ENTRY,1,2,“And when the brew’s all missin’$BTa Shadowforge we’ll hop,$BA bitter toast ta Ragnaros…$B… but bring him not a drop!”,12,0,100,0,0,0,“Dark Iron Herald”),
(@ENTRY,1,3,“Oh, we’re from Blackrock Mountain,$BWe’ve come ta drink yer brew!$BDark Iron dwarves, they do not lie,$BAnd so yeh know it’s true!”,12,0,100,0,0,0,“Dark Iron Herald”),
(@ENTRY,1,4,“Yeh will not try our bitter,$BYeh will not serve our ale!$BBut have Brewfest without our lot?$BJust try it, and ye’ll fail!”,12,0,100,0,0,0,“Dark Iron Herald”),

(@ENTRY,2,0,“We did it boys! Now back to the Grim Guzzler and we’ll drink to the 0 that were injured!!”,14,0,100,0,0,0,“Dark Iron Herald”),
(@ENTRY,2,1,“RETREAT! We’ve taken a beating and had 0 casualties! We can’t keep taking these losses! FALL BACK!”,14,0,100,0,0,0,“Dark Iron Herald”);

– Brewfest Reveler SAI
SET @ENTRY := 24484;
SET @SPELL_THROW_MUG := 50696;
UPDATE creature_template SET AIName=‘SmartAI’,ScriptName=‘’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid IN (@ENTRY) AND id IN (3,4,5,6); – We are adding new lines so don’t remove complete SAI
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,3,0,58,0,100,0,3,@ENTRY,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,“Brewfest Reveler - On WP 3 - Despawn”),
(@ENTRY,0,4,5,38,0,100,0,1,1,0,0,53,1,@ENTRY,0,0,0,2,1,0,0,0,0,0,0,0,“Brewfest Reveler - On Data Set 1 1 - Start WP”),
(@ENTRY,0,5,6,61,0,10,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,“Brewfest Reveler - On Data Set 1 1 - Say Line 0 (random)”), – Very low chance it seems
(@ENTRY,0,6,0,61,0,60,0,0,0,0,0,11,@SPELL_THROW_MUG,0,0,0,0,0,1,0,0,0,0,0,0,0,“Brewfest Reveler - On Data Set 1 1 - Cast Throw Mug”); – Low chance it seems
– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“Dark Iron dwarves!”,12,0,100,0,0,0,“Brewfest Reveler”),
(@ENTRY,0,1,“Run! It’s the Dark Iron dwarves!”,12,0,100,0,0,0,“Brewfest Reveler”),
(@ENTRY,0,2,“They’re after the beer!”,12,0,100,0,0,0,“Brewfest Reveler”),
(@ENTRY,0,3,“Someone has to save the beer!”,12,0,100,0,0,0,“Brewfest Reveler”),
(@ENTRY,0,4,“If you value your beer, run for it!”,12,0,100,0,0,0,“Brewfest Reveler”);

– Waypoints
DELETE FROM waypoints WHERE entry=@ENTRY;
INSERT INTO waypoints (entry,pointid,position_x,position_y,position_z,point_comment) VALUES
(@ENTRY,1,-5184.680176,-562.372009,397.260010,‘Brewfest Reveler’),
(@ENTRY,2,-5192.152832,-547.358459,397.177094,‘Brewfest Reveler’),
(@ENTRY,3,-5198.825684,-530.586243,392.940155,‘Brewfest Reveler’);

– Gordok Brew Barker SAI
SET @ENTRY := 23685;
SET @SPELL_DRINK := 42518;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,22,0,100,0,101,5000,5000,0,11,@SPELL_DRINK,2,0,0,0,0,7,0,0,0,0,0,0,0,“Gordok Brew Barker - Emote Receive ‘Wave’ - Cast Create Complimentary Brewfest Sampler”),
(@ENTRY,0,1,0,1,0,100,0,30000,45000,180000,240000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,“Gordok Brew Barker - Out of Combat - Yell Line 0 (random)”),
(@ENTRY,0,2,3,38,0,100,0,2,2,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,“Gordok Brew Barker - On Data Set - Yell Line 1”),
(@ENTRY,0,3,4,61,0,100,0,0,0,0,0,50,186478,15000,0,0,0,0,8,0,0,0,-5149.791992,-590.198792,397.323730,4.39,“Gordok Brew Barker - On Data Set 1 1 - Summon Super Brew Stein”),
(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,50,186471,15000,0,0,0,0,8,0,0,0,-5149.791992,-590.198792,397.323730,4.39,“Gordok Brew Barker - On Data Set 1 1 - Summon Super Brew Stein Trap”);

– Text
DELETE FROM script_texts WHERE entry BETWEEN -717 AND -719;
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“YOU TRY DA’ BEST, NOW TRY DA’ REST! OGRE BREW!”,14,0,100,1,0,0,“Gordok Brew Barker”),
(@ENTRY,0,1,“HEY YOU! DRINK OGRE BREWS! MAKE YOU BIG AND STRONG!”,14,0,100,1,0,0,“Gordok Brew Barker”),
(@ENTRY,0,2,“YOU WANT DRINK? WE GOT DRINK!”,14,0,100,1,0,0,“Gordok Brew Barker”),

(@ENTRY,1,0,“SOMEONE TRY THIS SUPER BREW!”,14,0,100,0,0,0,“Gordok Brew Barker”);

– Maeve Barleybrew SAI
SET @ENTRY := 23683;
SET @SPELL_DRINK := 42518;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,22,0,100,0,101,5000,5000,0,11,@SPELL_DRINK,2,0,0,0,0,7,0,0,0,0,0,0,0,“Maeve Barleybrew - Emote Receive ‘Wave’ - Cast Create Complimentary Brewfest Sampler”),
(@ENTRY,0,1,0,1,0,100,0,30000,45000,180000,240000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,“Maeve Barleybrew - Out of Combat - Yell Line 0 (random)”),
(@ENTRY,0,2,3,38,0,100,0,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,“Maeve Barleybrew - On Data Set - Yell Line 1”),
(@ENTRY,0,3,4,61,0,100,0,0,0,0,0,50,186478,15000,0,0,0,0,8,0,0,0,-5161.600586,-611.307861,397.917419,2.39,“Maeve Barleybrew - On Data Set 1 1 - Summon Super Brew Stein”),
(@ENTRY,0,4,5,61,0,100,0,0,0,0,0,50,186471,15000,0,0,0,0,8,0,0,0,-5161.600586,-611.307861,397.917419,2.39,“Maeve Barleybrew - On Data Set 1 1 - Summon Super Brew Stein Trap”),
(@ENTRY,0,5,0,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Maeve Barleybrew - On Data Set - Yell Line 2 (random)”);

– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“Come try our Barleybrew Dark!”,12,0,100,1,0,0,“Maeve Barleybrew”),
(@ENTRY,0,1,“Barleybrew, finest brewery in Azeroth!”,12,0,100,1,0,0,“Maeve Barleybrew”),
(@ENTRY,0,2,“The Barleybrews have always been leaders in brewery innovation. Check out our newest creation, Barleybrew Clear!”,12,0,100,1,0,0,“Maeve Barleybrew”),

(@ENTRY,1,0,“SOMEONE TRY THIS SUPER BREW!”,14,0,100,0,0,0,“Maeve Barleybrew”),

(@ENTRY,2,0,“Chug and chuck! Chug and chuck!”,12,0,100,1,0,0,“Maeve Barleybrew”),
(@ENTRY,2,1,“Down the free brew and pelt the Guzzlers with your mug!”,12,0,100,1,0,0,“Maeve Barleybrew”);

– Ita Thunderbrew SAI
SET @ENTRY := 23684;
SET @SPELL_DRINK := 42518;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,22,0,100,0,101,5000,5000,0,11,@SPELL_DRINK,2,0,0,0,0,7,0,0,0,0,0,0,0,“Ita Thunderbrew - Emote Receive ‘Wave’ - Cast Create Complimentary Brewfest Sampler”),
(@ENTRY,0,1,0,1,0,100,0,30000,45000,180000,240000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,“Ita Thunderbrew - Out of Combat - Yell Line 0 (random)”),
(@ENTRY,0,2,3,38,0,100,0,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,“Ita Thunderbrew - On Data Set - Yell Line 1”),
(@ENTRY,0,3,4,61,0,100,0,0,0,0,0,50,186478,15000,0,0,0,0,8,0,0,0,-5143.592285,-611.210510,398.339081,4.39,“Ita Thunderbrew - On Data Set 1 1 - Summon Super Brew Stein”),
(@ENTRY,0,4,5,61,0,100,0,0,0,0,0,50,186471,15000,0,0,0,0,8,0,0,0,-5149.791992,-590.198792,397.323730,4.39,“Ita Thunderbrew - On Data Set 1 1 - Summon Super Brew Stein Trap”),
(@ENTRY,0,5,0,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,“Ita Thunderbrew - On Data Set - Yell Line 2 (random)”);

– Text
DELETE FROM creature_text WHERE entry=@ENTRY;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@ENTRY,0,0,“Thunderbrew, finest brewery in all the realms.”,12,0,100,1,0,0,“Ita Thunderbrew”),
(@ENTRY,0,1,“THUNDER! THUNDER! THUNDER! THUNDERBREW, HO!”,12,0,100,1,0,0,“Ita Thunderbrew”),
(@ENTRY,0,2,“You look like you could use a cold one. Thunderbrew’s got ya covered!”,12,0,100,1,0,0,“Ita Thunderbrew”),

(@ENTRY,1,0,“SOMEONE TRY THIS SUPER BREW!”,14,0,100,0,0,0,“Ita Thunderbrew”),

(@ENTRY,2,0,“Chug and chuck! Chug and chuck!”,12,0,100,1,0,0,“Ita Thunderbrew”),
(@ENTRY,2,1,“Down the free brew and pelt the Guzzlers with your mug!”,12,0,100,1,0,0,“Ita Thunderbrew”);

/*Dark Iron Attack

Oh wow, nice script Discover.

Now a little issue: http://img851.imageshack.us/img851/4074/asdfasdfh.jpg

Don’t ask me how.

Don’t worry about that, I’ve decided to script the Dark Iron Guzzlers in C++ in order to make it work fine and use the correct spells as well instead of hacking it up. /emoticons/default_tongue.png

Ok, if you need a tester let me know.

Just a little report (if you need it)

[H] - Horde Only

[A] - Ally Only

[N] - Both Factions

[LOW] - Minor Bug

[HIGH] - Major Bug

– You cant buy Brewfest Ram, Even after finishing There and Back Again. [HIGH][N]

– After finishing both of ram racing quests, You should be able to talk with npc every day, so it gives you a ram and Ram Racing Reins. You have to Return more kegs, you have 4 minutes and every time you return one keg you get 2 Brewfest Prize Token and 25 seconds more, you can do it until time overs. [HIGH][N]

Coren Direbrew doesnt drop any mount in normal way, you have to queue Dungeon Finder and it drops a bag everyday, in that bag mounts contains with a low rate.

Bugs :

1- Well, i cant see Coren Direbrew in my Dungeon Finder list, some people can and some cant.[LOW]

2- If you queue for Coren Direbrew, you will be spawned at enterace of Molten Core, (it is same if you relog inside BRD), so it is impossible to reach him, the only way is teleporting out and entering BRD manually. [HIGH] There’s a teleport at the beginning of the instance that teleports you at the end

3- Some people tested it with the way above and they got no bag (Not tested by me yet.) [HIGH]

[Down With The Dark Iron] Whole event is bugged. [HIGH][H] (Can any ally confirm if it works on alliance side or no?)

Brew of the Month I Didnt test it cause i did not have enough tokens to buy ticket, but whenever i talk with the npc there is no option to buy, maybe it is because i dont have enough tokens or it is bugged?

Why even report Dark Iron if you know I’m working on it? =P

As for Brew of the Month I am also un-sure. I did find the mails that should be send to the player, will probably start at that later. First I want to finish Dark Iron and Tapping of the Keg.

I’d like some more reports. I know there are many issues with the database (http://paste2.org/p/1666191) which are easily resolved so go and fill up the tracker!