diff options
| author | Kittnz <Kittnz@users.noreply.github.com> | 2017-02-19 20:47:40 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2019-08-17 20:04:14 +0200 |
| commit | 1c926d0171cfd2ddb60cea6ef2903314848da7aa (patch) | |
| tree | 80de6746ccc77ea6df66f3eb76908d26063c4729 /sql | |
| parent | 973c97777d8b7bba6e5832a6551f07ca4c2e65c6 (diff) | |
Script/GO: Alliance Bell, Horde Bell and Karazhan Bell will now send a bell sound on the start of each hour. (#19145)
* Script/GO: Alliance Bell, Horde Bell and Karazhan Bell will now send a bell sound on the start of each hour.
How many times it rings depence on the hour.
* fix little things from pr comments
* Added OnGameEvent
* Fix braces
* almost finished
* fix enum
* Add gameobjects to the game event
Fix override for InitializeAI
* enum squash
* remove braces
* Rename 9999_99_99_99_world.sql to 2017_02_19_01_world.sql
(cherrypicked from 495339a2c7741d0ad56dfbb8756ad6e1e7d19b8b)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2019_07_24_02_world_2017_02_19_01_world.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_07_24_02_world_2017_02_19_01_world.sql b/sql/updates/world/master/2019_07_24_02_world_2017_02_19_01_world.sql new file mode 100644 index 00000000000..c3f0ce7ede2 --- /dev/null +++ b/sql/updates/world/master/2019_07_24_02_world_2017_02_19_01_world.sql @@ -0,0 +1,50 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_bells' WHERE `entry` IN (175885, 176573, 182064); + +DELETE FROM `game_event` WHERE `eventEntry`=73; +INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`, `announce`) VALUES +(73, '2010-01-01 01:00:00', '2025-01-01 01:00:00', 60, 1, 0, 'Hourly Bells', 0, 2); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=73; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +-- (73, 45022), -- Horde Bell +-- (73, 20802), +-- (73, 18103), +-- (73, 18102), +-- (73, 18101), +-- (73, 18100), +-- (73, 18099), +-- (73, 18098), +-- (73, 18097), +-- (73, 15508), +-- (73, 12439), +-- (73, 12438), +-- (73, 12437), +(73, 18683), +-- (73, 12436), +-- (73, 12435), +-- (73, 42666), -- Alliance Bell +-- (73, 42905), +-- (73, 42906), +-- (73, 42924), +-- (73, 48107), +-- (73, 49811), +-- (73, 94), +-- (73, 619), +-- (73, 870), +-- (73, 1140), +-- (73, 4841), +-- (73, 6867), +-- (73, 20801), +-- (73, 9114), +-- (73, 9104), +-- (73, 14562), +(73, 18894), +-- (73, 18901), +-- (73, 18906), +-- (73, 26283), +-- (73, 26414), +-- (73, 26426), +-- (73, 26435), +-- (73, 26469), +-- (73, 26743), +(73, 24539); -- Karazhan Bell |