diff options
| author | Killyana <morphone1@gmail.com> | 2017-01-22 03:36:22 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-01-22 03:36:22 +0100 |
| commit | 4d5017a057d6a98ad0d089a2da23bccd799f5f5f (patch) | |
| tree | 9c1fbcae44ec8368da43b9282d4124d2a8babba9 | |
| parent | 742c5f1e0b4690ef7ab3923e406b2599ea01b985 (diff) | |
DB/GameObject: Add missing spell focus for Lunar Festival Invitation
| -rw-r--r-- | sql/updates/world/3.3.5/2017_01_22_00_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_22_00_world_335.sql b/sql/updates/world/3.3.5/2017_01_22_00_world_335.sql new file mode 100644 index 00000000000..d447767ae74 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_01_22_00_world_335.sql @@ -0,0 +1,10 @@ +-- Greater Moonlight +DELETE FROM `gameobject` WHERE `id`=180867 AND `guid` IN (36,38,40); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(36, 180867, 571, 1, 1, 5820.25, 646.16, 647.851, 5.235990, 0, 0, 0.265429, 0.96413, 300, 0, 1), +(38, 180867, 530, 1, 1, 9479.35, -7295.02, 14.32, 0.536152, 0, 0, 0.422307, 0.906453, 300, 0, 1), +(40, 180867, 530, 1, 1, -4017.318, -11837.58, 0.081, 2.693128, 0, 0, 0.755281, -0.655401, 300, 0, 1); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=7 AND `guid` IN (36,38,40); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(7, 36),(7, 38),(7, 40); |