API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 25th, 2012
459
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 74.70 KB | None | 0 0
raw download clone embed print report
  1. /*Dark Iron Attack
  2.  
  3. 23808 - [DND] Brewfest Keg Move to Target
  4. 24766 - [DND] Brewfest Face Me Bunny
  5. 24109 - [DND] Brewfest Target Dummy Move To Target
  6. 23894 - [DND] Brewfest Dark Iron Spawn Bunny
  7. 23703 - [DND] Brewfest Dark Iron Event Generator
  8.  
  9. 188508 - Dark Iron Mole Machine (Minion Summoner)
  10.  
  11. 42676 - Holiday - Brewfest - Dark Iron Knockback Aura
  12.  
  13. Full horde video    http://www.wegame.com/watch/world-of-warcraft-brewfest-dailies-part-1-horde-dark-iron-attack-part-3/
  14. Proof of despawn    http://www.wegame.com/watch/brewfest-after-a-dark-iron-dwarf-attack/
  15.  
  16. */
  17. -- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  18. -- Misc.
  19. DELETE FROM `gameobject` WHERE `id`=186881; -- Dark Iron Sabotage Plans were used for the event in 2007
  20. DELETE FROM `game_event_gameobject` WHERE `guid` IN (11140,18015); -- Dark Iron Sabotage Plans
  21. UPDATE `creature_template` SET `unit_flags`=`unit_flags`|256 WHERE `entry`=23706; -- Gordok Festive Keg
  22. UPDATE `creature_model_info` SET `bounding_radius`=0.9,`combat_reach`=1.8,`gender`=2 WHERE `modelid`=24860; -- Gordok Festive Keg
  23. UPDATE `creature_template_addon` SET `bytes1`=0,`bytes2`=1,`mount`=0,`emote`=0,`auras`=NULL WHERE `entry` IN (23702,23700,23706,24373,24372); -- Festive Kegs
  24.  
  25. -- Brewfest - Attack Keg can only target kegs
  26. DELETE FROM `conditions` WHERE `SourceEntry` IN (42393) AND `ConditionValue2` IN (23702,23700,23706,24373,24372);
  27. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  28. (13,0,42393,0,18,1,23702,0,0,'',"Spell Brewfest - Attack Keg can only be cast at Thunderbrew Festive Keg"),
  29. (13,0,42393,0,18,1,23700,0,0,'',"Spell Brewfest - Attack Keg can only be cast at Barleybrew Festive Keg"),
  30. (13,0,42393,0,18,1,23706,0,0,'',"Spell Brewfest - Attack Keg can only be cast at Gordok Festive Keg"),
  31. (13,0,42393,0,18,1,24373,0,0,'',"Spell Brewfest - Attack Keg can only be cast at T'chalis's Festive Keg"),
  32. (13,0,42393,0,18,1,24372,0,0,'',"Spell Brewfest - Attack Keg can only be cast at Drohn's Festive Keg");
  33.  
  34. -- Holiday - Brewfest - Dark Iron Knockback Target Test
  35. -- DELETE FROM `spell_script_names` WHERE `spell_id`=42674;
  36. -- INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
  37. -- (42674,'spell_gen_dark_iron_knockback_test');
  38.  
  39. -- Brewfest - Dark Iron Knockback
  40. DELETE FROM `conditions` WHERE `SourceEntry`=42299 AND `ConditionValue2`=0;
  41. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  42. (13,0,42299,0,18,1,0,0,0,'',"Spell Brewfest - Dark Iron Knockback can only be cast at players");
  43.  
  44. SET @GUID := XXXX;
  45. -- Spawn [DND] Brewfest Dark Iron Event Generator and Dark Iron Herald
  46. DELETE FROM `creature` WHERE `id` IN (23703,24536) AND `guid` IN (@GUID+0,@GUID+1,@GUID+2,@GUID+3);
  47. 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
  48. (@GUID+0,23703,0,1,1,0,0,-5152.3,-603.529,398.356,2.50732,300,0,0,37800,0,0,0,0,0),
  49. (@GUID+2,24536,0,1,1,0,0,-5152.3,-603.529,398.356,2.50732,300,0,0,37800,0,0,0,0,0),
  50. (@GUID+3,23703,1,1,1,0,0,1197.6,-4293.571,21.243,5.20232,300,0,0,37800,0,0,0,0,0),
  51. (@GUID+1,24536,1,1,1,0,0,1197.6,-4293.571,21.243,5.20232,300,0,0,37800,0,0,0,0,0);
  52.  
  53. -- Fix the equipment templates of the brewers
  54. DELETE FROM `creature_equip_template` WHERE `entry`=2478;
  55. INSERT INTO `creature_equip_template` (`entry`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES
  56. (2478,33161,33161,0);
  57.  
  58. -- Update the templates for the Brewmaidens (the golden mugs)
  59. UPDATE `creature_template` SET `equipment_id`=2478 WHERE `entry` IN (23684,23683,23685,24493,24492);
  60.  
  61. -- Make the Event Generator spawns only spawn if Brewfest is active
  62. DELETE FROM `game_event_creature` WHERE `eventEntry`=24 AND `guid` IN (@GUID+0,@GUID+1,@GUID+2,@GUID+3);
  63. INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES
  64. (24,@GUID+0),(24,@GUID+2),(24,@GUID+1),(24,@GUID+3);
  65.  
  66. -- Make the Dark Iron Mole Machine Wreckage give the quests
  67. DELETE FROM `gameobject_questrelation` WHERE `id` IN (189990,189989);
  68. INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES
  69. (189990,12192), -- Horde
  70. (189989,12020); -- Alliance
  71.  
  72. -- Add aura 'Brewfest - Dark Iron Attack - Keg Marker' to Thunderbrew/Barleybrew/Gordok/T'chalis's/Drohn's Festive Keg
  73. DELETE FROM `creature_template_addon` WHERE `entry` IN (23702,23700,23706,24373,24372);
  74. INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
  75. (23702,0,0,0,0,'42761'),(23700,0,0,0,0,'42761'),(23706,0,0,0,0,'42761'),
  76. (24373,0,0,0,0,'42761'),(24372,0,0,0,0,'42761');
  77.  
  78. -- Brewfest Chick Chucks Mug should also add an Complimentary Brewfest Sampler
  79. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=42535 AND `spell_effect`=42518;
  80. INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
  81. (42535,42518,1,'Brewfest Chick Chucks Mug should also add an Complimentary Brewfest Sampler');
  82.  
  83. -- Add Dark Iron Guzzler's equipment template (taken from sniff)
  84. DELETE FROM `creature_equip_template` WHERE `entry`=2477;
  85. INSERT INTO `creature_equip_template` (`entry`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES
  86. (2477,33125,0,0);
  87.  
  88. -- Add aura 'Holiday - Brewfest - Dark Iron Knockback Target Test' to Dark Iron Guzzler
  89. DELETE FROM `creature_template_addon` WHERE `entry`=23709;
  90. INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
  91. (23709,0,0,0,0,'42676');
  92.  
  93. -- Drunken Master & Dark Iron Retreat
  94. DELETE FROM `conditions` WHERE `SourceEntry` IN (42695,42794,42341) AND `ConditionValue2` IN (23709);
  95. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
  96. (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"),
  97. (13,0,42794,0,18,1,23709,0,0,'',"Spell Holiday - Brewfest - Random Mug Fling can only be cast at Dark Iron Guzzler"),
  98. (13,0,42341,0,18,1,23709,0,0,'',"Spell Dark Iron Retreat can only be cast at Dark Iron Guzzler");
  99.  
  100. -- Insert missing object template for spell Drunken Master's - it's a trap and these do not come from sniffs, so WDBVerified on 1
  101. DELETE FROM `gameobject_template` WHERE `entry`=186471;
  102. 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
  103. (186471,6,6371,'Super Brew Stein','','','',35,0,3,0,0,0,0,0,0,0,0,8,42696,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1);
  104.  
  105. -- Insert missing triggered objectsummons - they dissapear through another object which makes the despawn animation
  106. DELETE FROM `gameobject_template` WHERE `entry` IN (202401,186462);
  107. 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
  108. (202401,1,7510,'Dark Iron Mole Machine','','','',0,0,1,0,0,0,0,0,0,1,95,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1), -- Retreat and big version
  109. (186462,1,7510,'Dark Iron Mole Machine','','','',0,0,0.6,0,0,0,0,0,0,1,95,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1);
  110.  
  111. -- [Q] [A/H] This One Time, When I Was Drunk...
  112. -- Shouldn't be related to Chug and Chuck! quest at all
  113. UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `id`=12020;
  114.  
  115. -- [DND] Brewfest Dark Iron Event Generator SAI
  116. SET @ENTRY := 23703;
  117. SET @SPELL_RETREAT := 42341;
  118. SET @SPELL_MOLE_MACHINE_SPAWN := 73074;
  119. UPDATE `creature_template` SET `AIName`='SmartAI',`flags_extra`=`flags_extra`|128 WHERE `entry`=@ENTRY;
  120. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-(@GUID+0),-(@GUID+3),@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2,@ENTRY*100+3);
  121. 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
  122. -- DUN MOROGH
  123. (-(@GUID+0),0,0,1,1,0,100,0,1800000,1800000,1800000,1800000,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - Out of Combat - Run Script"),
  124. (-(@GUID+0),0,1,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,24536,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - Out of Combat - Set Data Dark Iron Herald"),
  125. (-(@GUID+0),0,2,0,38,0,100,0,5,5,0,0,80,@ENTRY*100+3,0,2,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Data Set - Run Script"),
  126. (@ENTRY*100,9,1,0,0,0,100,0,10000,10000,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5168.79,-597.261,398.101,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"), -- Time this to give the Brewfest Revelers some time to run away
  127. (@ENTRY*100,9,2,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5154.99,-589.22,397.346,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  128. (@ENTRY*100,9,3,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5168.34,-585.515,397.688,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  129. (@ENTRY*100,9,4,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5160.86,-606.37,398.063,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  130. (@ENTRY*100,9,5,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5163.08,-592.054,398.022,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  131. (@ENTRY*100,9,6,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5160.24,-579.148,397.18,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  132. (@ENTRY*100,9,7,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5172.88,-576.9,397.339,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  133. (@ENTRY*100,9,8,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5180.1,-583.465,397.775,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  134. (@ENTRY*100,9,9,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5176.84,-592.674,397.622,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  135. (@ENTRY*100,9,10,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5172.06,-606.161,397.352,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  136. (@ENTRY*100,9,11,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5162.5,-614.447,397.741,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  137. (@ENTRY*100,9,12,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5153.05,-618.085,398.125,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  138. (@ENTRY*100,9,13,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5148.92,-607.028,398.537,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  139. (@ENTRY*100,9,14,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5155.28,-598.89,398.092,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  140. (@ENTRY*100,9,15,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5146.97,-591.708,397.372,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  141. (@ENTRY*100,9,16,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5136.8,-598.046,397.426,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  142. (@ENTRY*100,9,17,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5162.125000,-599.126953,398.169250,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  143. (@ENTRY*100,9,18,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5155.227051,-611.064087,398.384796,5.58,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  144. (@ENTRY*100,9,19,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5172.685547,-617.705200,397.190582,0.80,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  145. (@ENTRY*100,9,20,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5165.557129,-602.531067,397.959229,2.48,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  146. (@ENTRY*100,9,21,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5162.540039,-596.897278,398.152252,5.58,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  147. (@ENTRY*100,9,22,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5171.027832,-590.153503,397.964874,0.80,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  148. (@ENTRY*100,9,23,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5177.630371,-600.892029,397.344421,2.48,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  149. (@ENTRY*100,9,24,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5175.105957,-585.409302,397.801575,5.58,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  150. (@ENTRY*100,9,25,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5160.901367,-585.973755,397.494049,0.80,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  151. (@ENTRY*100,9,26,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5149.727051,-598.186523,398.000702,2.48,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  152. (@ENTRY*100,9,27,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5140.413574,-606.157715,398.110840,0.80,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  153. (@ENTRY*100,9,28,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5148.443359,-613.181458,398.464478,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  154. (@ENTRY*100,9,29,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5139.434570,-612.224487,398.017578,5.58,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  155. (@ENTRY*100,9,30,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5160.227051,-622.226868,397.487183,2.53,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  156. (@ENTRY*100,9,31,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5165.484863,-608.644226,397.621552,3.85,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  157. (@ENTRY*100,9,32,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5154.422852,-605.168152,398.364655,1.23,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  158. (@ENTRY*100,9,33,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5156.091309,-594.039612,397.730194,0.32,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  159. (@ENTRY*100,9,34,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5151.526855,-593.310730,397.529968,0.32,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  160. (@ENTRY*100,9,35,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5143.669922,-603.026917,398.192719,0.80,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  161. (@ENTRY*100,9,36,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5142.348633,-595.296265,397.526245,3.32,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  162. (@ENTRY*100,9,37,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5154.107910,-582.890503,397.179108,6.32,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  163. (@ENTRY*100,9,38,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5166.127930,-578.236206,397.194489,4.12,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  164. (@ENTRY*100,9,39,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5182.114746,-589.290283,397.433838,3.21,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  165. (@ENTRY*100,9,40,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5173.672363,-598.698364,397.764160,5.21,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  166. (@ENTRY*100,9,41,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5170.576660,-612.272156,397.254028,1.12,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  167. (@ENTRY*100,9,42,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5157.810059,-615.534058,398.061340,3.21,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  168. (@ENTRY*100,9,43,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5170.45,-619.995,397.201,5.03293,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  169. (@ENTRY*100,9,44,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5178.76,-596.961,397.377,1.7539,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  170. (@ENTRY*100,9,45,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5156.98,-580.003,397.177,0.120272,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  171. (@ENTRY*100,9,46,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5179.38,-586.717,397.709,4.49259,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  172. (@ENTRY*100,9,47,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5165.36,-587.727,397.835,1.67301,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  173. (@ENTRY*100,9,48,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5153.73,-615.453,398.279,0.856196,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  174. (@ENTRY*100,9,49,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5152.15,-595.603,397.77,4.901,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  175. (@ENTRY*100,9,50,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5162.17,-574.909,397.177,5.99506,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  176. (@ENTRY*100,9,51,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5168.06,-574.334,397.179,4.72586,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  177. (@ENTRY*100,9,52,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5175.6,-580.338,397.672,1.99189,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  178. (@ENTRY*100,9,53,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5173.89,-589.037,397.868,2.61942,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  179. (@ENTRY*100,9,54,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5174.16,-610.4,397.19,1.88822,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  180. (@ENTRY*100,9,55,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5168.59,-608.303,397.421,3.79124,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  181. (@ENTRY*100,9,56,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5139.81,-601.143,397.845,5.16019,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  182. (@ENTRY*100,9,57,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5148.49,-602.523,398.322,5.16019,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  183. (@ENTRY*100,9,58,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5150.64,-587.595,397.217,5.8317,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  184. (@ENTRY*100,9,59,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5164.38,-582.486,397.347,5.68012,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  185. (@ENTRY*100,9,60,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5170.38,-581.177,397.41,1.41776,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  186. (@ENTRY*100,9,61,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,-5172.32,-594.611,397.974,1.78454,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  187. (@ENTRY*100,9,62,0,0,0,100,0,0,0,0,0,12,23702,1,300000,0,0,0,8,0,0,0,-5159.85,-632.055,397.179,1.46772,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon Thunderbrew Festive Keg"),
  188. (@ENTRY*100,9,63,0,0,0,100,0,0,0,0,0,12,23706,1,300000,0,0,0,8,0,0,0,-5146.283691,-576.265930,397.176514,0.09009,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon Gordok Festive Keg"),
  189. (@ENTRY*100,9,64,0,0,0,100,0,0,0,0,0,12,23700,1,300000,0,0,0,8,0,0,0,-5186.539551,-599.753662,397.176453,0.024872,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon Barleybrew Festive Keg"),
  190. (@ENTRY*100,9,66,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 Barker"),
  191. (@ENTRY*100,9,67,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"),
  192. (@ENTRY*100,9,68,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"),
  193.  
  194. -- DUROTAR
  195. (-(@GUID+3),0,0,1,1,0,100,0,1800000,1800000,1800000,1800000,80,@ENTRY*100+1,0,2,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - Out of Combat - Run Script"),
  196. (-(@GUID+3),0,1,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,24536,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - Out of Combat - Set Data Dark Iron Herald"),
  197. (-(@GUID+3),0,2,0,38,0,100,0,5,5,0,0,80,@ENTRY*100+2,0,2,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Data Set - Run Script"),
  198. (@ENTRY*100+1,9,2,0,0,0,100,0,10000,10000,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1204.37,-4279.81,21.1922,3.84123,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  199. (@ENTRY*100+1,9,3,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1198.54,-4276.24,21.1922,0.617165,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  200. (@ENTRY*100+1,9,4,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1204.52,-4282.65,21.1922,3.73127,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  201. (@ENTRY*100+1,9,5,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1195.59,-4282.27,21.1928,0.42867,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  202. (@ENTRY*100+1,9,6,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1190.5,-4279.52,21.1916,5.64764,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  203. (@ENTRY*100+1,9,7,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1186.5,-4281.45,21.1916,0.526844,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  204. (@ENTRY*100+1,9,8,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1182.72,-4285.52,21.1916,0.994156,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  205. (@ENTRY*100+1,9,9,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1198.15,-4286.48,21.197,3.531,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  206. (@ENTRY*100+1,9,10,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1191.91,-4286.18,21.194,3.32287,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  207. (@ENTRY*100+1,9,11,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1188.62,-4289.83,21.1958,4.45777,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  208. (@ENTRY*100+1,9,12,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1182.62,-4292.68,21.1755,4.34388,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  209. (@ENTRY*100+1,9,13,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1185.53,-4297.08,21.2927,0.456159,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  210. (@ENTRY*100+1,9,14,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1189.84,-4296.02,21.3273,6.2524,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  211. (@ENTRY*100+1,9,15,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1194.04,-4291.03,21.2161,1.28475,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  212. (@ENTRY*100+1,9,16,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1196.33,-4295.06,21.2993,6.05997,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  213. (@ENTRY*100+1,9,17,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1200.13,-4290.59,21.2003,0.797805,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  214. (@ENTRY*100+1,9,18,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1203.6,-4287.35,21.1943,1.36329,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  215. (@ENTRY*100+1,9,19,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1199.9,-4281.51,21.1974,3.80588,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  216. (@ENTRY*100+1,9,20,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1187.18,-4285.77,21.1921,3.69592,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  217. (@ENTRY*100+1,9,21,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1185.34,-4289.22,21.1921,4.52844,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  218. (@ENTRY*100+1,9,22,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1190.7,-4293.48,21.258,6.11102,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  219. (@ENTRY*100+1,9,23,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1200.36,-4293.36,21.2189,0.322628,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  220. (@ENTRY*100+1,9,24,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1204.04,-4291.89,21.1951,0.683911,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  221. (@ENTRY*100+1,9,25,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1207.19,-4286.44,21.192,1.35935,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  222. (@ENTRY*100+1,9,26,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1210.33,-4284.73,21.192,5.65548,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  223. (@ENTRY*100+1,9,27,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1212.97,-4288.85,21.192,4.25748,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  224. (@ENTRY*100+1,9,28,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1208.33,-4291.2,21.192,3.49957,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  225. (@ENTRY*100+1,9,29,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1206.46,-4294.69,21.1925,4.63054,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  226. (@ENTRY*100+1,9,30,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1208.4,-4297.3,21.1929,0.915605,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  227. (@ENTRY*100+1,9,31,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1213.24,-4292.98,21.1929,0.518979,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  228. (@ENTRY*100+1,9,32,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1215.26,-4296.66,21.1929,4.1004,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  229. (@ENTRY*100+1,9,33,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1212.44,-4299.5,21.1929,3.6645,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  230. (@ENTRY*100+1,9,34,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1206.24,-4300.01,21.1978,2.72595,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  231. (@ENTRY*100+1,9,35,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1199.34,-4298.13,21.377,3.02047,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  232. (@ENTRY*100+1,9,36,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1197.71,-4300.08,21.4586,4.93684,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  233. (@ENTRY*100+1,9,37,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1203.39,-4297.49,21.2196,2.00338,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  234. (@ENTRY*100+1,9,38,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1201.1,-4301.55,21.3483,2.99691,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  235. (@ENTRY*100+1,9,39,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1196.24,-4303.98,21.2509,2.66311,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  236. (@ENTRY*100+1,9,40,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1193.57,-4298.09,21.4725,2.84768,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  237. (@ENTRY*100+1,9,41,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1189.9,-4300.33,21.3319,3.9708,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  238. (@ENTRY*100+1,9,42,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1192.37,-4303.41,21.2629,5.4395,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  239. (@ENTRY*100+1,9,43,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1207.39,-4303.19,21.3475,0.350117,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  240. (@ENTRY*100+1,9,44,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1213.96,-4302.97,21.192,5.67905,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  241. (@ENTRY*100+1,9,45,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1214.59,-4305.26,21.192,4.47739,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  242. (@ENTRY*100+1,9,46,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1210.72,-4304.51,21.3555,2.41179,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  243. (@ENTRY*100+1,9,47,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1209.12,-4308.69,21.243,2.71417,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  244. (@ENTRY*100+1,9,48,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1203.82,-4303.28,21.2771,2.12512,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  245. (@ENTRY*100+1,9,49,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1204.53,-4306.97,21.2342,3.62523,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  246. (@ENTRY*100+1,9,50,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1204.76,-4310.99,21.252,3.72341,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  247. (@ENTRY*100+1,9,51,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1201.8,-4309.15,21.2576,2.2233,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  248. (@ENTRY*100+1,9,52,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1200.39,-4305.57,21.2246,1.91307,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  249. (@ENTRY*100+1,9,53,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1197.17,-4310.19,21.292,3.37391,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  250. (@ENTRY*100+1,9,54,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1195.19,-4307.9,21.2921,1.79918,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  251. (@ENTRY*100+1,9,55,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1192.68,-4309.06,21.2945,2.078,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  252. (@ENTRY*100+1,9,56,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1189.37,-4304.97,21.2507,2.60422,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  253. (@ENTRY*100+1,9,57,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1185.69,-4301.03,21.2623,2.2233,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  254. (@ENTRY*100+1,9,58,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1194.77,-4300.84,21.3994,0.892044,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  255. (@ENTRY*100+1,9,59,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1197.76,-4291.57,21.213,1.19442,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  256. (@ENTRY*100+1,9,60,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1194.9,-4285.23,21.196,0.703549,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  257. (@ENTRY*100+1,9,61,0,0,0,100,0,0,0,0,0,12,23894,1,300000,0,0,0,8,0,0,0,1201.07,-4285.3,21.1986,6.13458,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon [DND] Brewfest Dark Iron Spawn Bunny"),
  258. (@ENTRY*100+1,9,62,0,0,0,100,0,0,0,0,0,12,24373,1,300000,0,0,0,8,0,0,0,1182.845,-4273.276,21.27497,1.46772,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon T'chali's Voodoo Brew Festive Keg"),
  259. (@ENTRY*100+1,9,63,0,0,0,100,0,0,0,0,0,12,23706,1,300000,0,0,0,8,0,0,0,1222.903,-4296.746,21.27534,0.09009,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon Gordok Festive Keg"),
  260. (@ENTRY*100+1,9,64,0,0,0,100,0,0,0,0,0,12,24372,1,300000,0,0,0,8,0,0,0,1184.316,-4314.621,21.37921,0.024872,"[DND] Brewfest Dark Iron Event Generator - On Script - Summon Drohn's Distillery Festive Keg"),
  261. (@ENTRY*100+1,9,66,0,0,0,100,0,59000,79000,90000,90000,45,2,2,0,0,0,0,11,23685,70,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Gordok Brew Barker"),
  262. (@ENTRY*100+1,9,67,0,0,0,100,0,10000,29000,90000,90000,45,3,3,0,0,0,0,11,24492,70,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Drohn's Distillery Barker"),
  263. (@ENTRY*100+1,9,68,0,0,0,100,0,3000,11000,90000,90000,45,4,4,0,0,0,0,11,24493,70,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data T'chalis's Voodoo Brewewry Barket"),
  264.  
  265. (@ENTRY*100+2,9,0,0,0,0,100,0,0,0,0,0,11,@SPELL_RETREAT,0,0,0,0,0,11,23709,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Cast Brewfest Retreat"),
  266. (@ENTRY*100+2,9,1,0,0,0,100,0,0,0,0,0,11,@SPELL_MOLE_MACHINE_SPAWN,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Cast Brewfest Retreat"),
  267. (@ENTRY*100+2,9,2,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,11,24493,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data T'chali's Voodoo Brewery Barker"),
  268. (@ENTRY*100+2,9,3,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,11,24492,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Drohn's Distillery Barker"),
  269. (@ENTRY*100+2,9,4,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,10,88864,23685,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Gordok Brew Barker"),
  270. (@ENTRY*100+2,9,5,0,0,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Despawn"),
  271.  
  272. (@ENTRY*100+3,9,0,0,0,0,100,0,0,0,0,0,11,@SPELL_RETREAT,0,0,0,0,0,11,23709,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Cast Brewfest Retreat"),
  273. (@ENTRY*100+3,9,1,0,0,0,100,0,0,0,0,0,11,@SPELL_MOLE_MACHINE_SPAWN,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Cast Brewfest Retreat"),
  274. (@ENTRY*100+3,9,2,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,11,23683,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Maeve Barleybrew"),
  275. (@ENTRY*100+3,9,3,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,11,23684,100,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Ita Thunderbrew"),
  276. (@ENTRY*100+3,9,4,0,0,0,100,0,0,0,0,0,45,4,4,0,0,0,0,10,88955,23685,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Set Data Gordok Brew Barker"),
  277. (@ENTRY*100+3,9,5,0,0,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Event Generator - On Script - Despawn");
  278.  
  279. -- [DND] Brewfest Dark Iron Spawn Bunny SAI
  280. SET @ENTRY := 23894;
  281. SET @SPELL_MOLE_MACHINE_SPAWN := 43563;
  282. SET @SPELL_GROUND_SHAKE := 44210;
  283. UPDATE `creature_template` SET `AIName`='SmartAI',`flags_extra`=`flags_extra`|128 WHERE `entry`=@ENTRY;
  284. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@ENTRY*100);
  285. 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
  286. (@ENTRY,0,0,1,1,0,100,0,5000,275000,280000,280000,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"),
  287. (@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"),
  288. (@ENTRY*100,9,0,0,0,0,100,0,5000,5000,0,0,12,23709,1,300000,0,0,0,1,0,0,0,0,0,0,3.85,"[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"),
  289. (@ENTRY*100,9,1,0,0,0,100,0,4000,4000,0,0,12,23709,1,300000,0,0,0,1,0,0,0,0,0,0,5.58,"[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"),
  290. (@ENTRY*100,9,2,0,0,0,100,0,3000,3000,0,0,12,23709,1,300000,0,0,0,1,0,0,0,0,0,0,0.80,"[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"),
  291. (@ENTRY*100,9,3,0,0,0,100,0,2000,2000,0,0,12,23709,1,300000,0,0,0,1,0,0,0,0,0,0,2.48,"[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"),
  292. (@ENTRY,0,2,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"[DND] Brewfest Dark Iron Spawn Bunny - On Data Set - Despawn");
  293.  
  294. -- Dark Iron Herald SAI
  295. -- We are making him invisible (model 16925) at all times because else we can not run the event properly (since we spawned it).
  296. -- We are also setting phase so the yells and such will only happen during the event
  297. SET @ENTRY := 24536;
  298. SET @SPELL_PLANS_A := 48145;
  299. SET @SPELL_PLANS_H := 49318;
  300. UPDATE `creature_template` SET `AIName`='SmartAI',`modelid1`=16925,`flags_extra`=`flags_extra`|128 WHERE `entry`=@ENTRY;
  301. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-(@GUID+1),-(@GUID+2),@ENTRY*100,@ENTRY*100+1,@ENTRY*100+2);
  302. 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
  303. -- Durotar
  304. (-(@GUID+1),0,0,1,38,0,100,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Yell Line 0"),
  305. (-(@GUID+1),0,1,2,61,0,100,0,0,0,0,0,45,2,2,0,0,0,0,11,24484,100,0,0,0,0,0,"Dark Iron Herald - On Data Set - Set Data Brewfest Reveler"),
  306. (-(@GUID+1),0,2,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Set Phase 1"),
  307. (-(@GUID+1),0,3,0,1,1,100,0,25000,45000,60000,90000,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Say Line 1 (random)"),
  308. (-(@GUID+1),0,4,5,1,1,100,1,295000,295000,300000,300000,45,5,5,0,0,0,0,10,@GUID+0,23703,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Set Data Dark Iron Event Generator"), -- Almost 5 minutes passed, retreat
  309. (-(@GUID+1),0,5,0,61,1,100,0,0,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Run Script"),
  310. (@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Yell Line 3"),
  311. (@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23702,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Thunderbrew Festive Keg"),
  312. (@ENTRY*100,9,2,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23706,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Gordok Festive Keg"),
  313. (@ENTRY*100,9,3,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23700,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Barleybrew Festive Keg"),
  314. (@ENTRY*100,9,4,0,0,0,100,0,6000,6000,0,0,11,@SPELL_PLANS_H,2,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Cast Players Won - H - Summon Dark Iron Dwarf Plans"),
  315. (@ENTRY*100,9,5,0,0,0,100,0,3000,3000,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Despawn"),
  316. (-(@GUID+1),0,6,0,38,1,100,0,20,20,0,0,80,@ENTRY*100+2,0,2,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Run Script"), -- Runs same script the alliance version does
  317. -- Dun Morogh
  318. (-(@GUID+2),0,0,1,38,0,100,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Yell Line 0"),
  319. (-(@GUID+2),0,1,2,61,0,100,0,0,0,0,0,45,3,3,0,0,0,0,11,24484,100,0,0,0,0,0,"Dark Iron Herald - On Data Set - Set Data Brewfest Reveler"),
  320. (-(@GUID+2),0,2,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Set Phase 1"),
  321. (-(@GUID+2),0,3,0,1,1,100,0,25000,45000,60000,90000,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Say Line 1 (random)"),
  322. (-(@GUID+2),0,4,5,1,1,100,1,295000,295000,300000,300000,45,5,5,0,0,0,0,10,@GUID+3,23703,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Set Data Dark Iron Event Generator"), -- Almost 5 minutes passed, retreat
  323. (-(@GUID+2),0,5,0,61,1,100,0,0,0,0,0,80,@ENTRY*100+1,0,2,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - Out of Combat - Run Script"),
  324. (@ENTRY*100+1,9,0,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Yell Line 2"),
  325. (@ENTRY*100+1,9,1,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23702,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Thunderbrew Festive Keg"),
  326. (@ENTRY*100+1,9,2,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23706,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Gordok Festive Keg"),
  327. (@ENTRY*100+1,9,3,0,0,0,100,0,0,0,0,0,45,5,5,0,0,0,0,11,23700,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Barleybrew Festive Keg"),
  328. (@ENTRY*100+1,9,4,0,0,0,100,0,6000,6000,0,0,11,@SPELL_PLANS_A,2,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Cast Players Won - A - Summon Dark Iron Dwarf Plans"),
  329. (@ENTRY*100+1,9,5,0,0,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Despawn"),
  330. (-(@GUID+2),0,6,0,38,1,100,0,20,20,0,0,80,@ENTRY*100+2,0,2,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Data Set - Run Script"), -- Runs same script the horde version does
  331.  
  332. -- This script is used for both Durotar and Dun Morogh version
  333. (@ENTRY*100+2,9,0,0,0,0,100,0,0,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Yell Line 3"),
  334. (@ENTRY*100+2,9,1,0,0,0,100,0,0,0,0,0,78,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Call Script Reset"),
  335. (@ENTRY*100+2,9,2,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Herald - On Script - Despawn"),
  336. (@ENTRY*100+2,9,3,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,11,23894,100,0,0,0,0,0,"Dark Iron Herald - On Script - Set Data Brewfest Dark Iron Spawn Bunny"); -- Unsummon the spawn bunnies so they won't summon more dwarfs while we are retreating
  337. /*(@GUID+2,24536,0,1,1,0,0,-5152.3,-603.529,398.356,2.50732,300,0,0,37800,0,0,0,0,0),
  338. (@GUID+1,24536,1,1,1,0,0,1197.6,-4293.571,21.243,5.20232,300,0,0,37800,0,0,0,0,0);*/
  339. -- Text
  340. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  341. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  342. (@ENTRY,0,0,"No one expects the Dark Iron dwarves!",14,0,100,0,0,11832,"Dark Iron Herald"), -- This is where we play the sound
  343.  
  344. (@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"),
  345. (@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"),
  346. (@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"),
  347. (@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"),
  348. (@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"),
  349.  
  350. -- Shauren told me to use 0 for the counter because it is also bugged on retail
  351. (@ENTRY,2,0,"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"), -- Alliance
  352. (@ENTRY,3,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"); -- Horde
  353.  
  354. -- Dark Iron Guzzler
  355. -- We are setting AIName because some people applied the SAI for this NPC
  356. UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_dark_iron_guzzler',`equipment_id`=2477,`unit_flags`=33024 WHERE `entry`=23709;
  357. -- Text
  358. DELETE FROM `creature_text` WHERE `entry`=23709;
  359. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  360. (23709,0,0,"Did someone say 'Free Brew'?",12,0,20,0,0,0,"Dark Iron Guzzler"),
  361. (23709,0,1,"DRINK! BRAWL! DRINK! BRAWL!",12,0,100,0,0,0,"Dark Iron Guzzler"),
  362. (23709,0,2,"Drink it all boys!",12,0,50,0,0,0,"Dark Iron Guzzler"),
  363. (23709,0,3,"It's not a party without some crashers!",12,0,30,0,0,0,"Dark Iron Guzzler");
  364.  
  365. -- Festive Keg SAI (creatures)
  366. -- The unit_flags are taken from sniffs - we are setting react state passive so it won't EVER fight back
  367. SET @ENTRY1 := 23702; -- Thunderbrew Festive Keg
  368. SET @ENTRY2 := 23700; -- Barleybrew Festive Keg
  369. SET @ENTRY3 := 23706; -- Gordok Festive Keg
  370. SET @ENTRY4 := 24373; -- T'chalis's Festive Keg
  371. SET @ENTRY5 := 24372; -- Drohn's Festive Keg
  372. UPDATE `creature_template` SET `AIName`='SmartAI',`unit_flags`=`unit_flags`|256,`RegenHealth`=0 WHERE `entry` IN (@ENTRY1,@ENTRY2,@ENTRY3,@ENTRY4,@ENTRY5);
  373. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY1,@ENTRY2,@ENTRY3,@ENTRY4,@ENTRY5);
  374. 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
  375. -- Thunderbrew Festive Keg
  376. (@ENTRY1,0,0,0,1,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thunderbrew Festive Keg - Out of Combat - Set React State Passive"),
  377. (@ENTRY1,0,1,0,6,0,100,0,0,0,0,0,45,1,1,0,0,0,0,20,186184,0,0,0,0,0,0,"Thunderbrew Festive Keg - On Death - Set Data Thunderbrew Festive Keg (OBJECT)"),
  378. (@ENTRY1,0,2,0,38,0,100,0,5,5,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thunderbrew Festive Keg - On Data Set - Forced Despawn"),
  379. (@ENTRY1,0,3,0,6,0,100,0,0,0,0,0,45,10,10,0,0,0,0,11,23709,3,0,0,0,0,0,"Thunderbrew Festive Keg - On Death - Set Data Dark Iron Guzzler"),
  380. -- Barleybrew Festive Keg
  381. (@ENTRY2,0,0,0,1,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Barleybrew Festive Keg - Out of Combat - Set React State Passive"),
  382. (@ENTRY2,0,1,0,6,0,100,0,0,0,0,0,45,1,1,0,0,0,0,20,186189,0,0,0,0,0,0,"Barleybrew Festive Keg - On Death - Set Data Barleybrew Festive Keg (OBJECT)"),
  383. (@ENTRY2,0,2,0,38,0,100,0,5,5,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Barleybrew Festive Keg - On Data Set - Forced Despawn"),
  384. (@ENTRY2,0,3,0,6,0,100,0,0,0,0,0,45,11,11,0,0,0,0,11,23709,3,0,0,0,0,0,"Barleybrew Festive Keg - On Death - Set Data Dark Iron Guzzler"),
  385. -- Gordok Festive Keg
  386. (@ENTRY3,0,0,0,1,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Festive Keg - Out of Combat - Set React State Passive"),
  387. (@ENTRY3,0,1,0,6,0,100,0,0,0,0,0,45,1,1,0,0,0,0,20,186185,0,0,0,0,0,0,"Gordok Festive Keg - On Death - Set Data Gordok Festive Keg (OBJECT)"),
  388. (@ENTRY3,0,2,0,38,0,100,0,5,5,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Festive Keg - On Data Set - Forced Despawn"),
  389. (@ENTRY3,0,3,0,6,0,100,0,0,0,0,0,45,12,12,0,0,0,0,11,23709,3,0,0,0,0,0,"Gordok Festive Keg - On Death - Set Data Dark Iron Guzzler"),
  390. -- T'chalis's Festive Keg
  391. (@ENTRY4,0,0,0,1,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chalis's Festive Keg - Out of Combat - Set React State Passive"),
  392. (@ENTRY4,0,1,0,6,0,100,0,0,0,0,0,45,1,1,0,0,0,0,20,186187,0,0,0,0,0,0,"T'chalis's Festive Keg - On Death - Set Data T'chalis's Festive Keg (OBJECT)"),
  393. (@ENTRY4,0,2,0,38,0,100,0,5,5,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chalis's Festive Keg - On Data Set - Forced Despawn"),
  394. (@ENTRY4,0,3,0,6,0,100,0,0,0,0,0,45,10,10,0,0,0,0,11,23709,3,0,0,0,0,0,"T'chalis's Festive Keg - On Death - Set Data Dark Iron Guzzler"),
  395. -- Drohn's Festive Keg
  396. (@ENTRY5,0,0,0,1,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Festive Keg - Out of Combat - Set React State Passive"),
  397. (@ENTRY5,0,1,0,6,0,100,0,0,0,0,0,45,1,1,0,0,0,0,20,186186,0,0,0,0,0,0,"Drohn's Festive Keg - On Death - Set Data Drohn's Festive Keg (OBJECT)"),
  398. (@ENTRY5,0,2,0,38,0,100,0,5,5,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Festive Keg - On Data Set - Forced Despawn"),
  399. (@ENTRY5,0,3,0,6,0,100,0,0,0,0,0,45,10,10,0,0,0,0,11,23709,3,0,0,0,0,0,"Drohn's Festive Keg - On Death - Set Data Dark Iron Guzzler");
  400.  
  401. -- Festive Keg SAI (gameobjects)
  402. -- Currently we can not despawn the objects through SAI because it misses proper support. I'm still adding it because it might be of use for when this gets fixed
  403. SET @ENTRY1 := 186184;
  404. SET @ENTRY2 := 186189;
  405. SET @ENTRY3 := 186185;
  406. SET @ENTRY4 := 186187;
  407. SET @ENTRY5 := 186186;
  408. UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (@ENTRY1,@ENTRY2,@ENTRY3,@ENTRY4,@ENTRY5);
  409. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY1,@ENTRY2,@ENTRY3,@ENTRY4,@ENTRY5);
  410. 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
  411. (@ENTRY1,1,0,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thunderbrew Festive Keg - On Data Set - Despawn"),
  412. (@ENTRY2,1,0,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Barleybrew Festive Keg - On Data Set - Despawn"),
  413. (@ENTRY3,1,0,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Festive Keg - On Data Set - Despawn"),
  414. (@ENTRY4,1,0,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chalis's Festive Keg - On Data Set - Despawn"),
  415. (@ENTRY5,1,0,0,38,0,100,0,1,1,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Festive Keg - On Data Set - Despawn");
  416.  
  417. -- Brewfest Reveler SAI
  418. SET @ENTRY := 24484;
  419. SET @SPELL_THROW_MUG := 50696;
  420. SET @SPELL_CREATE_MUG := 42518;
  421. SET @SPELL_TOAST := 41586;
  422. UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY;
  423. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  424. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@ENTRY*100,@ENTRY*100+1); -- We are adding new lines so don't remove complete SAI
  425. 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
  426. (@ENTRY,0,0,0,22,0,100,0,101,5000,5000,0,11,@SPELL_CREATE_MUG,2,0,0,0,0,7,0,0,0,0,0,0,0,"Brewfest Reveler - Emote Receive 'Wave' - Cast Create Complimentary Brewfest Sampler"),
  427. (@ENTRY,0,1,0,22,0,100,0,34,5000,5000,0,11,@SPELL_TOAST,2,0,0,0,0,7,0,0,0,0,0,0,0,"Brewfest Reveler - Emote Receive 'Dance' - Cast Brewfest Toast"),
  428. (@ENTRY,0,2,0,1,0,100,0,4000,11000,15000,20000,10,92,1,4,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - Out of Combat - Play Random Emote"),
  429. -- Dun Morogh
  430. (@ENTRY,0,3,0,38,0,100,0,2,2,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Data Set - Run Script"),
  431. (@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,53,1,@ENTRY,0,0,0,2,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Script - Start WP"),
  432. (@ENTRY*100,9,1,0,0,0,100,0,1000,5000,5000,5000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Script - Say Line 0 (random)"),
  433. (@ENTRY*100,9,2,0,0,0,100,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 Script - Cast Throw Mug"),
  434. (@ENTRY,0,4,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"),
  435. -- Durotar
  436. (@ENTRY,0,5,0,38,0,100,0,3,3,0,0,80,@ENTRY*100+1,0,2,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Data Set - Run Script"),
  437. (@ENTRY*100+1,9,0,0,0,0,100,0,0,0,0,0,53,1,@ENTRY*10,0,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Script - Start WP"),
  438. (@ENTRY*100+1,9,1,0,0,0,100,0,1000,5000,5000,5000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Script - Say Line 0 (random)"),
  439. (@ENTRY*100+1,9,2,0,0,0,100,0,1000,3000,3000,3000,11,@SPELL_THROW_MUG,0,0,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On Script - Cast Throw Mug"),
  440. (@ENTRY,0,6,0,58,0,100,0,4,@ENTRY*10,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Brewfest Reveler - On WP 4 - Despawn");
  441. -- Text
  442. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  443. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  444. (@ENTRY,0,0,"Dark Iron dwarves!",12,0,100,0,0,0,"Brewfest Reveler"),
  445. (@ENTRY,0,1,"Run! It's the Dark Iron dwarves!",12,0,100,0,0,0,"Brewfest Reveler"),
  446. (@ENTRY,0,2,"They're after the beer!",12,0,100,0,0,0,"Brewfest Reveler"),
  447. (@ENTRY,0,3,"Someone has to save the beer!",12,0,100,0,0,0,"Brewfest Reveler"),
  448. (@ENTRY,0,4,"If you value your beer, run for it!",12,0,100,0,0,0,"Brewfest Reveler");
  449. -- Waypoints
  450. DELETE FROM `waypoints` WHERE `entry` IN (@ENTRY,@ENTRY*10);
  451. INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
  452. -- Dun Morogh
  453. (@ENTRY,1,-5184.680176,-562.372009,397.260010,'Brewfest Reveler'),
  454. (@ENTRY,2,-5192.152832,-547.358459,397.177094,'Brewfest Reveler'),
  455. (@ENTRY,3,-5198.825684,-530.586243,392.940155,'Brewfest Reveler'),
  456. -- Durotar
  457. (@ENTRY*10,1,1209.775879,-4342.093750,21.295063,'Brewfest Reveler'),
  458. (@ENTRY*10,2,1203.770874,-4356.925781,21.967909,'Brewfest Reveler'),
  459. (@ENTRY*10,3,1202.042725,-4370.892578,24.852894,'Brewfest Reveler'),
  460. (@ENTRY*10,4,1199.489868,-4389.286621,23.865566,'Brewfest Reveler');
  461.  
  462. -- Gordok Brew Barker SAI
  463. SET @ENTRY := 23685;
  464. SET @SPELL_DRINK := 42518;
  465. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  466. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  467. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-88864,-88955,@ENTRY);
  468. 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
  469. -- Dun Morogh version
  470. (-88864,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"),
  471. (-88864,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)"),
  472. (-88864,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - On Data Set - Set Phase 1"),
  473. (-88864,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Gordok Brew Barker - Out of Combat - Say Line 2 (random) (P1)"),
  474. (-88864,0,4,0,1,1,100,1,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - Out of Combat - Yell Line 1 (P1)"),
  475. (-88864,0,5,0,52,1,100,0,1,@ENTRY,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 Text Over - Summon Super Brew Stein Trap (P1)"),
  476. (-88864,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - On Data Set - Set Phase 0"), -- Event is over, so set phase 0
  477.  
  478. -- Durotar version
  479. (-88955,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"),
  480. (-88955,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)"),
  481. (-88955,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - On Data Set - Set Phase 1"),
  482. (-88955,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Gordok Brew Barker - Out of Combat - Say Line 2 (random) (P1)"),
  483. (-88955,0,4,0,1,1,100,1,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - Out of Combat - Yell Line 1 (P1)"),
  484. (-88955,0,5,0,52,1,100,0,1,@ENTRY,0,0,50,186471,15000,0,0,0,0,8,0,0,0,1216.599976,-4284.270020,21.290300,3.787360,"Gordok Brew Barker - On Text Over - Summon Super Brew Stein Trap (P1)"),
  485. (-88955,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gordok Brew Barker - On Data Set - Set Phase 0"); -- Event is over, so set phase 0
  486. -- Text
  487. DELETE FROM `script_texts` WHERE `entry` BETWEEN -717 AND -719; -- Old entries used in EAI
  488. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  489. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  490. (@ENTRY,0,0,"YOU TRY DA' BEST, NOW TRY DA' REST! OGRE BREW!",14,0,100,0,0,0,"Gordok Brew Barker"),
  491. (@ENTRY,0,1,"HEY YOU! DRINK OGRE BREWS! MAKE YOU BIG AND STRONG!",14,0,100,0,0,0,"Gordok Brew Barker"),
  492. (@ENTRY,0,2,"YOU WANT DRINK? WE GOT DRINK!",14,0,100,0,0,0,"Gordok Brew Barker"),
  493.  
  494. (@ENTRY,1,0,"SOMEONE TRY THIS SUPER BREW!",14,0,100,0,0,0,"Gordok Brew Barker");
  495.  
  496. -- Maeve Barleybrew SAI
  497. SET @ENTRY := 23683;
  498. SET @SPELL_DRINK := 42518;
  499. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  500. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  501. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  502. 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
  503. (@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"),
  504. (@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)"),
  505.  
  506. (@ENTRY,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Maeve Barleybrew - On Data Set - Set Phase 1"),
  507. (@ENTRY,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Maeve Barleybrew - Out of Combat - Say Line 2 (random) (P1)"),
  508. (@ENTRY,0,4,0,1,1,100,1,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Maeve Barleybrew - Out of Combat - Yell Line 1 (P1)"),
  509. (@ENTRY,0,5,0,52,1,100,0,1,@ENTRY,0,0,50,186471,15000,0,0,0,0,8,0,0,0,-5161.600586,-611.307861,397.917419,2.39,"Maeve Barleybrew - On Text Over - Summon Super Brew Stein Trap (P1)"),
  510. (@ENTRY,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Maeve Barleybrew - On Data Set - Set Phase 0"); -- Event is over, so set phase 0
  511. -- Text
  512. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  513. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  514. (@ENTRY,0,0,"Come try our Barleybrew Dark!",12,0,100,0,0,0,"Maeve Barleybrew"),
  515. (@ENTRY,0,1,"Barleybrew, finest brewery in Azeroth!",12,0,100,0,0,0,"Maeve Barleybrew"),
  516. (@ENTRY,0,2,"The Barleybrews have always been leaders in brewery innovation. Check out our newest creation, Barleybrew Clear!",12,0,100,0,0,0,"Maeve Barleybrew"),
  517.  
  518. (@ENTRY,1,0,"SOMEONE TRY THIS SUPER BREW!",14,0,100,0,0,0,"Maeve Barleybrew"),
  519.  
  520. (@ENTRY,2,0,"Chug and chuck! Chug and chuck!",12,0,100,0,0,0,"Maeve Barleybrew"),
  521. (@ENTRY,2,1,"Down the free brew and pelt the Guzzlers with your mug!",12,0,100,0,0,0,"Maeve Barleybrew");
  522.  
  523. -- Ita Thunderbrew SAI
  524. SET @ENTRY := 23684;
  525. SET @SPELL_DRINK := 42518;
  526. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  527. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  528. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  529. 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
  530. (@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"),
  531. (@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)"),
  532.  
  533. (@ENTRY,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ita Thunderbrew - On Data Set - Set Phase 1"),
  534. (@ENTRY,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ita Thunderbrew - Out of Combat - Say Line 2 (random) (P1)"),
  535. (@ENTRY,0,4,0,1,1,100,1,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ita Thunderbrew - Out of Combat - Yell Line 1 (P1)"),
  536. (@ENTRY,0,5,0,52,1,100,0,1,@ENTRY,0,0,50,186471,15000,0,0,0,0,8,0,0,0,-5149.791992,-590.198792,397.323730,4.39,"Ita Thunderbrew - On Text Over - Summon Super Brew Stein Trap (P1)"),
  537. (@ENTRY,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ita Thunderbrew - On Data Set - Set Phase 0"); -- Event is over, so set phase 0
  538. -- Text
  539. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  540. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  541. (@ENTRY,0,0,"Thunderbrew, finest brewery in all the realms.",12,0,100,0,0,0,"Ita Thunderbrew"),
  542. (@ENTRY,0,1,"THUNDER! THUNDER! THUNDER! THUNDERBREW, HO!",12,0,100,0,0,0,"Ita Thunderbrew"),
  543. (@ENTRY,0,2,"You look like you could use a cold one. Thunderbrew's got ya covered!",12,0,100,0,0,0,"Ita Thunderbrew"),
  544.  
  545. (@ENTRY,1,0,"SOMEONE TRY THIS SUPER BREW!",14,0,100,0,0,0,"Ita Thunderbrew"),
  546.  
  547. (@ENTRY,2,0,"Chug and chuck! Chug and chuck!",12,0,100,0,0,0,"Ita Thunderbrew"),
  548. (@ENTRY,2,1,"Down the free brew and pelt the Guzzlers with your mug!",12,0,100,0,0,0,"Ita Thunderbrew");
  549.  
  550. -- Drohn's Distillery Barker SAI
  551. SET @ENTRY := 24492;
  552. SET @SPELL_DRINK := 42518;
  553. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  554. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  555. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  556. 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
  557. (@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,"Drohn's Distillery Barker - Emote Receive 'Wave' - Cast Create Complimentary Brewfest Sampler"),
  558. (@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,"Drohn's Distillery Barker - Out of Combat - Yell Line 0 (random)"),
  559.  
  560. (@ENTRY,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Distillery Barker - On Data Set - Set Phase 1"),
  561. (@ENTRY,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Drohn's Distillery Barker - Out of Combat - Say Line 2 (random) (P1)"),
  562. (@ENTRY,0,4,0,1,1,100,1,3,3,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Distillery Barker - Out of Combat - Yell Line 1 (P1)"),
  563. (@ENTRY,0,5,0,52,1,100,0,1,@ENTRY,0,0,50,186471,15000,0,0,0,0,8,0,0,0,1191.014404,-4299.663574,21.381546,4.39,"Drohn's Distillery Barker - On Text Over - Summon Super Brew Stein Trap (P1)"),
  564. (@ENTRY,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drohn's Distillery Barker - On Data Set - Set Phase 0"); -- Event is over, so set phase 0
  565. -- Text
  566. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  567. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  568. (@ENTRY,0,0,"Drohn's brew is the stuff legends are made of! Come taste the legend!",12,0,100,0,0,0,"Drohn's Distillery Barker"),
  569. (@ENTRY,0,1,"We drink for the Horde! Do you drink for the Horde? Come show us at Drohn's Distillery!",12,0,100,0,0,0,"Drohn's Distillery Barker"),
  570. (@ENTRY,0,2,"Hey you, the tall one... Want to put some hair on your chest? Drohn's Distillery can help you out!",12,0,100,0,0,0,"Drohn's Distillery Barker"),
  571. (@ENTRY,0,3,"Hey you! T'chali's Voodoo Brewers have got a brew that won't kill you! But they've also got a brew that might...",12,0,100,0,0,0,"Drohn's Distillery Barker"),
  572.  
  573. (@ENTRY,1,0,"SOMEONE TRY THIS SUPER BREW!",14,0,100,0,0,0,"Drohn's Distillery Barker"),
  574.  
  575. (@ENTRY,2,0,"Chug and chuck! Chug and chuck!",12,0,100,0,0,0,"Drohn's Distillery Barker"),
  576. (@ENTRY,2,1,"Down the free brew and pelt the Guzzlers with your mug!",12,0,100,0,0,0,"Drohn's Distillery Barker");
  577.  
  578. -- T'chali's Voodoo Brewery Barker SAI
  579. SET @ENTRY := 24493;
  580. SET @SPELL_DRINK := 42518;
  581. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  582. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
  583. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  584. 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
  585. (@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,"T'chali's Voodoo Brewery Barker - Emote Receive 'Wave' - Cast Create Complimentary Brewfest Sampler"),
  586. (@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,"T'chali's Voodoo Brewery Barker - Out of Combat - Yell Line 0 (random)"),
  587.  
  588. (@ENTRY,0,2,0,38,0,100,0,3,3,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chali's Voodoo Brewery Barker - On Data Set - Set Phase 1"),
  589. (@ENTRY,0,3,0,1,1,100,0,10000,35000,45000,50000,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"T'chali's Voodoo Brewery Barker - Out of Combat - Say Line 2 (random) (P1)"),
  590. (@ENTRY,0,4,0,1,1,100,1,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chali's Voodoo Brewery Barker - Out of Combat - Yell Line 1 (P1)"),
  591. (@ENTRY,0,5,0,52,1,100,0,1,@ENTRY,0,0,50,186471,15000,0,0,0,0,8,0,0,0,1190.705688,-4285.604004,21.193674,4.39,"T'chali's Voodoo Brewery Barker - On Text Over - Summon Super Brew Stein Trap (P1)"),
  592. (@ENTRY,0,6,0,38,0,100,0,4,4,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"T'chali's Voodoo Brewery Barker - On Data Set - Set Phase 0"); -- Event is over, so set phase 0
  593. -- Text
  594. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  595. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  596. (@ENTRY,0,0,"If you wanna live life to the fullest, you gotta try T'chali's Voodoo Brew!",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  597. (@ENTRY,0,1,"T'chali's Voodoo Brews helps keep the party going! Check out the party at Brewfest!",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  598. (@ENTRY,0,2,"Hey you! T'chali's Voodoo Brewers have got a brew that won't kill you! But they've also got a brew that might...",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  599. (@ENTRY,0,3,"T'chali's Voodoo Brewery has the best brew you can find! They were voted 'Best Brew' by the Goblin Brew Weekly!",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  600.  
  601. (@ENTRY,1,0,"SOMEONE TRY THIS SUPER BREW!",14,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  602.  
  603. (@ENTRY,2,0,"Chug and chuck! Chug and chuck!",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker"),
  604. (@ENTRY,2,1,"Down the free brew and pelt the Guzzlers with your mug!",12,0,100,0,0,0,"T'chali's Voodoo Brewery Barker");
  605.  
  606. -- Drunken Brewfest Reveler SAI
  607. SET @ENTRY := 23698;
  608. SET @SPELL_VOMIT := 67468;
  609. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  610. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-88896,-88960);
  611. 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
  612. -- Alliance
  613. (-88896,0,0,0,1,0,100,0,10000,45000,180000,240000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drunken Brewfest Reveler - Out of Combat - Say Line 0 (random)"),
  614. (-88896,0,1,0,1,0,100,0,10000,45000,180000,240000,11,@SPELL_VOMIT,2,0,0,0,0,1,0,0,0,0,0,0,0,"Drunken Brewfest Reveler - Out of Combat - Cast Drunken Vomit"),
  615. -- Horde
  616. (-88960,0,0,0,1,0,100,0,10000,45000,180000,240000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Drunken Brewfest Reveler - Out of Combat - Say Line 1 (random)"),
  617. (-88960,0,1,0,1,0,100,0,10000,45000,180000,240000,11,@SPELL_VOMIT,2,0,0,0,0,1,0,0,0,0,0,0,0,"Drunken Brewfest Reveler - Out of Combat - Cast Drunken Vomit");
  618. -- Text
  619. DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
  620. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  621. -- Alliance
  622. (@ENTRY,0,0,"Uh oh...",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  623. (@ENTRY,0,1,"Good times! <hic>",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  624. (@ENTRY,0,2,"What's all the fuss about here?",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  625. (@ENTRY,0,3,"The besht part about drinking is pretending to be drunk... I'm jusht pretending guys.",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  626. (@ENTRY,0,4,"Hey fellas! How's it going?",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  627. (@ENTRY,0,5,"Hey! Anyone shee that cute blond dwarf? I shwear they were jusht here...",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  628. (@ENTRY,0,6,"Hey! Lishten up! I've got... I have something important to talk about! Shee... Wait... What wash I shaying? Something aboutsh boats and floating... Yeah! Sho don't float on a boat... Thank you...",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  629. -- Horde
  630. (@ENTRY,1,0,"Uh oh...",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  631. (@ENTRY,1,1,"Good times! <hic>",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  632. (@ENTRY,1,2,"What's all the fuss about here?",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  633. (@ENTRY,1,3,"The besht part about drinking is pretending to be drunk... I'm jusht pretending guys.",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  634. (@ENTRY,1,4,"You guys have gotta try thish...",12,0,100,0,0,0,"Drunken Brewfest Reveler"),
  635. (@ENTRY,1,5,"Hey! You for the Horde? <hic> I'm for the Horde!",12,0,100,0,0,0,"Drunken Brewfest Reveler");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!