TrinityCore/TrinityCore — Issue #4993: DB/Spawns: Lunar Festival, Rocket Clusters, Moonglade
Author: Odyssey
Created: 2012-01-29 19:30:38+00:00
State: open

The two rocket clusters placed near Omen's summon place

```sql
SET @GUID := XXXXXX; -- need 2
SET @CLUSTER := 180874;
SET @LUNARFESTIVAL := 7;

DELETE FROM `gameobject` WHERE `id`=@CLUSTER;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`) VALUES
(@GUID,@CLUSTER,1,1,1,7531.662,-2851.228,458.9172),
(@GUID+1,@CLUSTER,1,1,1,7561.145,-2872.45,461.0998);

DELETE FROM `game_event_gameobject` WHERE `guid` IN (@GUID,@GUID+1);
INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES
(@LUNARFESTIVAL,@GUID),
(@LUNARFESTIVAL,@GUID+1);
```

[Source](http://paste2.org/p/1887849)