diff options
| author | Kittnz <frederik156@hotmail.com> | 2016-10-23 23:16:02 +0200 |
|---|---|---|
| committer | Kittnz <frederik156@hotmail.com> | 2016-10-23 23:16:02 +0200 |
| commit | 9d922ea043311e74b035ba2214c5c6c4fdef4e59 (patch) | |
| tree | 3167e8d92d163f4c79905fecd191feb8deb2d5b7 | |
| parent | 3d7a86bf1e7596b040ebaada23d377368096da0f (diff) | |
DB/Event: Add new event Darkmoon Faire Building (Mulgore)
- Set objects to correct event
- Set npc 14849 to correct event, ie darkmoon mulgore
Closes #18131
Updates #18043
| -rw-r--r-- | sql/updates/world/3.3.5/2016_10_23_00_world_335.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_23_00_world_335.sql b/sql/updates/world/3.3.5/2016_10_23_00_world_335.sql new file mode 100644 index 00000000000..2d4ba2f10be --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_23_00_world_335.sql @@ -0,0 +1,23 @@ +DELETE FROM `game_event` WHERE `eventEntry`=71; +INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`, `announce`) VALUES +(71, '2013-01-06 01:01:00', '2020-12-31 06:00:00', 131040, 8639, 0, 'Darkmoon Faire Building (Mulgore)', 0, 2); + +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31878 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31874 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31875 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31877 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31879 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31876 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31918 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31919 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31872 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31915 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31916 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31913 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31912 AND `eventEntry`=24; +UPDATE `game_event_gameobject` SET `eventEntry`=71 WHERE `guid`=31914 AND `eventEntry`=24; + +-- Add 14849 to full darkmoon molgure event +DELETE FROM `game_event_creature` WHERE `guid`=137686; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(5, 137686); |