aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-10-29 13:43:33 +0100
committerKillyana <morphone1@gmail.com>2015-10-29 13:43:33 +0100
commitc4bee70fd4e2d61b4651efeabf0c78ad8abd59ab (patch)
treeb876b1676460bc4d8d4483196df8ef01ce4d39b6
parentbd16520ecc91d827abae7f0447cc292fe9e843e9 (diff)
DB/Event: Fix for Dalaran Hallow's End spawns
-rw-r--r--sql/updates/world/2015_10_29_00_world.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2015_10_29_00_world.sql b/sql/updates/world/2015_10_29_00_world.sql
new file mode 100644
index 00000000000..4a447b6bd9e
--- /dev/null
+++ b/sql/updates/world/2015_10_29_00_world.sql
@@ -0,0 +1,14 @@
+-- Fix for DB/Event: Add missing Hallow's End event spawns in Dalaran
+SET @OGUID:=77307;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+9 AND `eventEntry`=12;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9);