diff options
| author | Kittnz <frederik156@hotmail.com> | 2016-10-05 22:34:04 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-08-20 23:23:47 +0200 |
| commit | b8479333c25c92675909c2077e8e3bdd72d4d58a (patch) | |
| tree | 48b00a6a2cb4f91cce98c4b9b162debe3c84a7f4 /sql/updates | |
| parent | e04f75bd962006662bc0f77f0034f061605fb1c6 (diff) | |
Core/Event: Add Brewfest Music during the event
Note: Dark Iron invasion music can be added with a trigger at a later stage
(cherry picked from commit 002b0a7a65167d15969d98b41af7f91d222df664)
Update 2016_10_05_11_world_335.sql
(cherry picked from commit cccb1c5ddea21a4a457877aa698f2bdb162e2ab8)
Fix non PCH build.
(cherry picked from commit 81d4c02f34807f4e52689d0b99e9bb1f94f3bd96)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2017_08_20_03_world_2016_10_05_11_world_335.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_08_20_03_world_2016_10_05_11_world_335.sql b/sql/updates/world/master/2017_08_20_03_world_2016_10_05_11_world_335.sql new file mode 100644 index 00000000000..008cfe049a8 --- /dev/null +++ b/sql/updates/world/master/2017_08_20_03_world_2016_10_05_11_world_335.sql @@ -0,0 +1,9 @@ +-- Update Brewfest Music Doodad script +UPDATE `gameobject_template` SET `ScriptName`='go_brewfest_music' WHERE `entry`=186221; + +-- Add missing Brewfest Music Doodad spawns +SET @OGUID:=6037; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0 , 186221, 530, 1, 0, -1897.498, 5560.614, -12.34483, 4.363323, 0, 0, 0, 0, 120, 255, 1), +(@OGUID+1 , 186221, 530, 1, 0, 9325.442, -7276.318, 13.34217, 4.363323, 0, 0, 0, 0, 120, 255, 1); |