From 7835c5ff97c7c1c58e4d94d2af98f709c43aa9fd Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Wed, 22 Nov 2017 21:40:22 +0100
Subject: DB/Creature: Fix Unit flag for some Pilgrim's Bounty npcs

(cherry picked from commit 1c07b178a0b69c05bf3a4d4ee3aa7b2e428b7395)
---
 sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql b/sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql
new file mode 100644
index 00000000000..dd3879e5964
--- /dev/null
+++ b/sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql
@@ -0,0 +1,3 @@
+-- 
+UPDATE  `creature_template` SET `unit_flags`=33536 WHERE `entry` IN (35337,35338,35340,35341,35342,35343,34714, 34679, 34768, 34653);
+-- DELETE FROM `game_event_creature` WHERE `guid`=43465;
-- 
cgit v1.2.3