aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-11-22 21:40:22 +0100
committerKillyana <morphone1@gmail.com>2017-11-22 21:40:22 +0100
commit1c07b178a0b69c05bf3a4d4ee3aa7b2e428b7395 (patch)
tree71bceccd77d2dbae59191fdb02c35ce39b9aaab5
parent96768319dea1d3905c0bbc78898c4d5d03f9045f (diff)
DB/Creature: Fix Unit flag for some Pilgrim's Bounty npcs
-rw-r--r--sql/updates/world/3.3.5/2017_11_22_04_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_22_04_world.sql b/sql/updates/world/3.3.5/2017_11_22_04_world.sql
new file mode 100644
index 00000000000..71619b3dc52
--- /dev/null
+++ b/sql/updates/world/3.3.5/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;