From 495339a2c7741d0ad56dfbb8756ad6e1e7d19b8b 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
---
 sql/updates/world/3.3.5/2017_02_19_01_world.sql | 50 +++++++++++++++++++++++++
 1 file changed, 50 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2017_02_19_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2017_02_19_01_world.sql b/sql/updates/world/3.3.5/2017_02_19_01_world.sql
new file mode 100644
index 00000000000..4a79543cd28
--- /dev/null
+++ b/sql/updates/world/3.3.5/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