aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMalcrom <malcromdev@gmail.com>2014-07-25 14:54:47 -0230
committerMalcrom <malcromdev@gmail.com>2014-07-25 14:54:47 -0230
commitc60bdec16046c0bb908e84039f8b1c22368363bd (patch)
tree4f19ca07d189a69dd7db34fb5020ea9432044ac2
parent4f1d247dfba124c628feaa24c603cd5cc24f0349 (diff)
DB/Misc: Misc fixups in Dalaran
-rw-r--r--sql/updates/world/2014_07_25_02_world_misc.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_25_02_world_misc.sql b/sql/updates/world/2014_07_25_02_world_misc.sql
new file mode 100644
index 00000000000..e5124e3a56f
--- /dev/null
+++ b/sql/updates/world/2014_07_25_02_world_misc.sql
@@ -0,0 +1,5 @@
+-- Remove Dalaran Visitor spawns from DB
+DELETE FROM creature WHERE id IN (32596,32597,32598,32600,32601,32602);
+-- Fix Addon for Jean Pierre Poulain
+DELETE FROM `creature_addon` WHERE `guid`=85236;
+UPDATE `creature_template_addon` SET `mount`=22471, `auras`='63500' WHERE `entry`=34244;