aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-01-26 20:54:01 +0100
committerKillyana <morphone1@gmail.com>2019-01-26 20:54:01 +0100
commit75c553fe5900f9b52f04889e970221196ef27acf (patch)
tree075ad69da97c2565d64f6afe89dc6fa250e3c393
parent1972760a86d9056c9465c946dac8e28e5931908a (diff)
DB/Quest: Remove deprecated mount quests
-rw-r--r--sql/updates/world/3.3.5/2019_01_26_01_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_26_01_world.sql b/sql/updates/world/3.3.5/2019_01_26_01_world.sql
new file mode 100644
index 00000000000..831b80c0be7
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);