From 1c926d0171cfd2ddb60cea6ef2903314848da7aa Mon Sep 17 00:00:00 2001
From: Kittnz <Kittnz@users.noreply.github.com>
Date: Sun, 19 Feb 2017 20:47:40 +0100
Subject: 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)
---
 .../2019_07_24_02_world_2017_02_19_01_world.sql    | 50 ++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 sql/updates/world/master/2019_07_24_02_world_2017_02_19_01_world.sql

(limited to 'sql')

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
-- 
cgit v1.2.3