DB/Spawns: Lunar Festival, Rocket Clusters, Moonglade

Closes #4993

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/2012_02_08_13_world_gameobject.sql b/sql/updates/world/2012_02_08_13_world_gameobject.sql
new file mode 100644
index 00000000000..0a43dda67d4
--- /dev/null
+++ b/sql/updates/world/2012_02_08_13_world_gameobject.sql
@@ -0,0 +1,13 @@
+-- Lunar festival: Rocket Clusters placed near Omen's summon place (Moonglade)
+SET @CLUSTER := 180874;
+SET @LUNARFESTIVAL := 7;
+
+DELETE FROM `gameobject` WHERE `id`=@CLUSTER AND `guid` IN (230,231);
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`) VALUES
+(230,@CLUSTER,1,1,1,7531.662,-2851.228,458.9172),
+(231,@CLUSTER,1,1,1,7561.145,-2872.45,461.0998);
+
+DELETE FROM `game_event_gameobject` WHERE `guid` IN (230,231) AND `eventEntry`=@LUNARFESTIVAL;
+INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES
+(@LUNARFESTIVAL,230),
+(@LUNARFESTIVAL,231);