aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/FULL/world_scripts_full.sql1
-rw-r--r--sql/FULL/world_trinity_string_full.sql3
-rw-r--r--sql/updates/4836_world_announce.sql (renamed from sql/updates/XXX_world_announce.sql)1
-rw-r--r--sql/world.sql11
4 files changed, 15 insertions, 1 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql
index c2c872abda4..f9873ddef7b 100644
--- a/sql/FULL/world_scripts_full.sql
+++ b/sql/FULL/world_scripts_full.sql
@@ -1022,6 +1022,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_dragonflayer_forge_master' WHER
/* VAULT OF ARCHAVON */
UPDATE `creature_template` SET `ScriptName`='boss_archavon' WHERE `entry`=31125;
UPDATE `creature_template` SET `ScriptName`='mob_archavon_warder' WHERE `entry`=32353;
+UPDATE `creature_template` SET `ScriptName`='boss_emalon' WHERE `entry`=33993;
/* WAILING CAVERNS */
diff --git a/sql/FULL/world_trinity_string_full.sql b/sql/FULL/world_trinity_string_full.sql
index 56eea9d053e..edbab4ff593 100644
--- a/sql/FULL/world_trinity_string_full.sql
+++ b/sql/FULL/world_trinity_string_full.sql
@@ -795,4 +795,5 @@ INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `conte
(10052, 'Take me to Eastwall Tower.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10053, 'Take me to Crown Guard Tower.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10054, 'Give me the flag, I''ll take it to the central beacon for the glory of the Alliance!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-(10055, 'Give me the flag, I''ll take it to the central beacon for the glory of the Horde!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+(10055, 'Give me the flag, I''ll take it to the central beacon for the glory of the Horde!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(11000, '|cffffff00[|c00077766Autobroadcast|cffffff00]: |cFFF222FF%s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/XXX_world_announce.sql b/sql/updates/4836_world_announce.sql
index 59accbfc9bb..1e8920baa7c 100644
--- a/sql/updates/XXX_world_announce.sql
+++ b/sql/updates/4836_world_announce.sql
@@ -1,3 +1,4 @@
+DROP TABLE IF EXISTS `autobroadcast`;
CREATE TABLE `autobroadcast` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` longtext NOT NULL,
diff --git a/sql/world.sql b/sql/world.sql
index 4d1313c4c65..21ae1fe7a35 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -139,6 +139,17 @@ CREATE TABLE `areatrigger_teleport` (
SET character_set_client = @saved_cs_client;
--
+-- Table structure for table `autobroadcast`
+--
+
+DROP TABLE IF EXISTS `autobroadcast`;
+CREATE TABLE `autobroadcast` (
+`id` int(11) NOT NULL AUTO_INCREMENT,
+`text` longtext NOT NULL,
+PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `battleground_template`
--