From da0235dca3e0f023ded619c4647ceaceed65d77c Mon Sep 17 00:00:00 2001 From: Odyssey Date: Wed, 8 Feb 2012 20:56:47 +0000 Subject: DB/Spawns: Lunar Festival, Rocket Clusters, Moonglade Closes #4993 --- sql/updates/world/2012_02_08_13_world_gameobject.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2012_02_08_13_world_gameobject.sql (limited to 'sql/updates') 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); -- cgit v1.2.3