diff options
| author | Kittnz <frederik156@hotmail.com> | 2016-10-05 22:34:04 +0200 |
|---|---|---|
| committer | Kittnz <frederik156@hotmail.com> | 2016-10-05 22:34:04 +0200 |
| commit | 002b0a7a65167d15969d98b41af7f91d222df664 (patch) | |
| tree | 9a84a261566eab066c56221ad62255ed59a5d046 /sql | |
| parent | 4450d5b698d4c9a3dc787d2473c0e5005ef03dfb (diff) | |
Core/Event: Add Brewfest Music during the event
Note: Dark Iron invasion music can be added with a trigger at a later stage
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_10_05_11_world_335.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_05_11_world_335.sql b/sql/updates/world/3.3.5/2016_10_05_11_world_335.sql new file mode 100644 index 00000000000..2577db707c4 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_05_11_world_335.sql @@ -0,0 +1,8 @@ +-- Update Brewfest Music Doodad script +UPDATE `gameobject_template` SET `ScriptName`='go_brewfest_music' WHERE `entry`=186221; + +-- Add missing Brewfest Music Doodad spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+1; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0 , 186221, 530, 1, 1, -1897.498, 5560.614, -12.34483, 4.363323, 0, 0, 0, 0, 120, 255, 1), +(@OGUID+1 , 186221, 530, 1, 1, 9325.442, -7276.318, 13.34217, 4.363323, 0, 0, 0, 0, 120, 255, 1); |