aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2021_01_07_00_world.sql37
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_01_07_00_world.sql b/sql/updates/world/3.3.5/2021_01_07_00_world.sql
new file mode 100644
index 00000000000..7e79805e6a6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_01_07_00_world.sql
@@ -0,0 +1,37 @@
+--
+UPDATE `creature_template` SET `unit_flags2` = `unit_flags2` | 32768 WHERE `entry` IN (
+-- Cata 464, -- Guard Parker
+-- Cata 823, -- Deputy Willem
+-- Cata 2238, -- Tog'thar
+-- Cata 2239, -- Drull
+-- Cata 3203, -- Fizzle Darkstorm
+-- Cata 7024, -- Agent Kearnen
+-- Cata 15192, -- Anachronos
+22258, -- Demoniac Scryer
+31897, -- Lightwell
+32826, -- Sturdy Seat
+32930, -- Kologarn
+33288, -- Yogg-Saron
+33329, -- Heart of the Deconstructor
+33883, -- Yogg-Saron (Transform Only)
+33890, -- Brain of Yogg-Saron
+33909, -- Kologarn (1)
+33954, -- Brain of Yogg-Saron (1)
+33955, -- Yogg-Saron (1)
+33995, -- Heart of the Deconstructor (1)
+34297, -- Kologarn
+34812, -- The Turkey Chair
+34819, -- The Stuffing Chair
+34822, -- The Pie Chair
+34823, -- The Cranberry Chair
+34824, -- The Sweet Potato Chair
+38316, -- Ormus the Penitent
+38454, -- Kinetic Bomb
+38775, -- Kinetic Bomb (1)
+38776, -- Kinetic Bomb (2)
+38777, -- Kinetic Bomb (3)
+39509, -- Aronen
+39820, -- Rocket Launcher
+39934, -- Zeppelin Sentry
+40220, -- [ph] Summoned Crab - Pet
+40492); -- Zild'jian