aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-11-22 21:40:22 +0100
committerfunjoker <funjoker109@gmail.com>2021-02-15 19:13:25 +0100
commit7835c5ff97c7c1c58e4d94d2af98f709c43aa9fd (patch)
tree23f9868b891d3f90eb117f6f33d253024c034e5e
parent58de8141e5fbc0db6d3c50a5a1180755282e7dd4 (diff)
DB/Creature: Fix Unit flag for some Pilgrim's Bounty npcs
(cherry picked from commit 1c07b178a0b69c05bf3a4d4ee3aa7b2e428b7395)
-rw-r--r--sql/updates/world/master/2021_02_08_06_world_2017_11_22_04_world.sql3
1 files changed, 3 insertions, 0 deletions
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;