aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-06-22 10:22:17 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-01 22:53:22 +0100
commitafb9ecdca29461fc56da7963bba8270e01de8f94 (patch)
tree64b4e1321ced20a493bc5789aa684779abcdf456
parent9733e084e6fd784e2029b1cd44c092931766f57d (diff)
DB/Quest: remove duplicate quests offered by some event-related questgivers
Closes #17435 by SnapperRy (cherry picked from commit 81ad97815d1f69f5520fc47d8f8840484cc71077) Rename 2016_06_23_00_world.sql to 2016_06_22_00_world.sql (cherry picked from commit abaf6fca5559f75ae43375f00908fe46857770d5)
-rw-r--r--sql/updates/world/master/2017_02_01_01_world_2016_06_22_00_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_01_01_world_2016_06_22_00_world.sql b/sql/updates/world/master/2017_02_01_01_world_2016_06_22_00_world.sql
new file mode 100644
index 00000000000..fd2d4d8743b
--- /dev/null
+++ b/sql/updates/world/master/2017_02_01_01_world_2016_06_22_00_world.sql
@@ -0,0 +1,2 @@
+--
+DELETE FROM `creature_queststarter` WHERE `quest` IN (SELECT `quest` FROM `game_event_creature_quest`);