aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-01-26 20:54:01 +0100
committerShauren <shauren.trinity@gmail.com>2021-11-22 23:25:08 +0100
commitf5ab650f9cdb73ca4fb9f7f81f39f8d752728eaa (patch)
tree9c268132d1bb3d413bf293d3df85a0277a285cba
parent2f2c7275f9c96b47679127d62824f24f9d9f1c29 (diff)
DB/Quest: Remove deprecated mount quests
(cherry picked from commit 75c553fe5900f9b52f04889e970221196ef27acf)
-rw-r--r--sql/updates/world/master/2021_11_22_02_world_2019_01_26_01_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_22_02_world_2019_01_26_01_world.sql b/sql/updates/world/master/2021_11_22_02_world_2019_01_26_01_world.sql
new file mode 100644
index 00000000000..831b80c0be7
--- /dev/null
+++ b/sql/updates/world/master/2021_11_22_02_world_2019_01_26_01_world.sql
@@ -0,0 +1,4 @@
+-- Remove deprecated mount quests
+DELETE FROM `creature_questender` WHERE `quest` IN (7664,7665,7678,7677,7671,7672,7663,7662,7674,7661,7660,7676,7675,7673);
+DELETE FROM `creature_queststarter` WHERE `quest` IN (7664,7665,7678,7677,7671,7672,7663,7662,7674,7661,7660,7676,7675,7673);
+UPDATE `creature_template` SET `npcflag`=129 WHERE `entry` IN (7952,384,4730,3685,1261,7955,3362);