From 368e7113ceb2f5f9ca4ea58095c6504f49ae5168 Mon Sep 17 00:00:00 2001 From: Nay Date: Sun, 23 Dec 2012 17:54:19 +0000 Subject: DB/Players: Fix message sent when DND is enabled Closes #8428 Also update some sql file names --- sql/updates/world/2012_12_20_00_world_conditions (2).sql | 1 + sql/updates/world/2012_12_20_0_world_conditions.sql | 1 - sql/updates/world/2012_12_23_00_creature_text.sql | 8 -------- sql/updates/world/2012_12_23_00_world_creature_text.sql | 8 ++++++++ sql/updates/world/2012_12_23_01_creature_text.sql | 13 ------------- sql/updates/world/2012_12_23_01_world_creature_text.sql | 13 +++++++++++++ sql/updates/world/2012_12_23_02_world_trinity_string.sql | 1 + 7 files changed, 23 insertions(+), 22 deletions(-) create mode 100644 sql/updates/world/2012_12_20_00_world_conditions (2).sql delete mode 100644 sql/updates/world/2012_12_20_0_world_conditions.sql delete mode 100644 sql/updates/world/2012_12_23_00_creature_text.sql create mode 100644 sql/updates/world/2012_12_23_00_world_creature_text.sql delete mode 100644 sql/updates/world/2012_12_23_01_creature_text.sql create mode 100644 sql/updates/world/2012_12_23_01_world_creature_text.sql create mode 100644 sql/updates/world/2012_12_23_02_world_trinity_string.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_20_00_world_conditions (2).sql b/sql/updates/world/2012_12_20_00_world_conditions (2).sql new file mode 100644 index 00000000000..f07b18ed2e4 --- /dev/null +++ b/sql/updates/world/2012_12_20_00_world_conditions (2).sql @@ -0,0 +1 @@ +UPDATE `conditions` SET `ConditionTarget`=1 WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52781 AND `ConditionTypeOrReference`=31; diff --git a/sql/updates/world/2012_12_20_0_world_conditions.sql b/sql/updates/world/2012_12_20_0_world_conditions.sql deleted file mode 100644 index f07b18ed2e4..00000000000 --- a/sql/updates/world/2012_12_20_0_world_conditions.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `conditions` SET `ConditionTarget`=1 WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=52781 AND `ConditionTypeOrReference`=31; diff --git a/sql/updates/world/2012_12_23_00_creature_text.sql b/sql/updates/world/2012_12_23_00_creature_text.sql deleted file mode 100644 index 37b4d66b3fe..00000000000 --- a/sql/updates/world/2012_12_23_00_creature_text.sql +++ /dev/null @@ -1,8 +0,0 @@ -UPDATE `creature_text` SET `sound`=11222 WHERE `entry`=20904 AND `groupid`=0; -UPDATE `creature_text` SET `sound`=11223 WHERE `entry`=20904 AND `groupid`=1; -UPDATE `creature_text` SET `sound`=11224 WHERE `entry`=20904 AND `groupid`=2; -UPDATE `creature_text` SET `sound`=11225 WHERE `entry`=20904 AND `groupid`=3; -UPDATE `creature_text` SET `sound`=11226 WHERE `entry`=20904 AND `groupid`=4; -UPDATE `creature_text` SET `sound`=11227 WHERE `entry`=20904 AND `groupid`=5; -UPDATE `creature_text` SET `sound`=11228 WHERE `entry`=20904 AND `groupid`=6; -UPDATE `creature_text` SET `sound`=11229 WHERE `entry`=20904 AND `groupid`=7; diff --git a/sql/updates/world/2012_12_23_00_world_creature_text.sql b/sql/updates/world/2012_12_23_00_world_creature_text.sql new file mode 100644 index 00000000000..37b4d66b3fe --- /dev/null +++ b/sql/updates/world/2012_12_23_00_world_creature_text.sql @@ -0,0 +1,8 @@ +UPDATE `creature_text` SET `sound`=11222 WHERE `entry`=20904 AND `groupid`=0; +UPDATE `creature_text` SET `sound`=11223 WHERE `entry`=20904 AND `groupid`=1; +UPDATE `creature_text` SET `sound`=11224 WHERE `entry`=20904 AND `groupid`=2; +UPDATE `creature_text` SET `sound`=11225 WHERE `entry`=20904 AND `groupid`=3; +UPDATE `creature_text` SET `sound`=11226 WHERE `entry`=20904 AND `groupid`=4; +UPDATE `creature_text` SET `sound`=11227 WHERE `entry`=20904 AND `groupid`=5; +UPDATE `creature_text` SET `sound`=11228 WHERE `entry`=20904 AND `groupid`=6; +UPDATE `creature_text` SET `sound`=11229 WHERE `entry`=20904 AND `groupid`=7; diff --git a/sql/updates/world/2012_12_23_01_creature_text.sql b/sql/updates/world/2012_12_23_01_creature_text.sql deleted file mode 100644 index b663c5269e9..00000000000 --- a/sql/updates/world/2012_12_23_01_creature_text.sql +++ /dev/null @@ -1,13 +0,0 @@ -UPDATE `creature_text` SET `sound`=11171, `text`='Where in Bonzo''s Brass Buttons am I? And who are-- yaaghh, that''s one mother of a headache!' WHERE `entry`=20977 AND `groupid`=0; -UPDATE `creature_text` SET `sound`=11172, `text`='\"Lowly\"? I don''t care who you are, friend: no one refers to the mighty Millhouse Manastorm as \"lowly\"!' WHERE `entry`=20977 AND `groupid`=1; -UPDATE `creature_text` SET `sound`=11173, `text`='I just need to get some things ready first. You guys go ahead and get started. I need to summon up some water....' WHERE `entry`=20977 AND `groupid`=2; -UPDATE `creature_text` SET `sound`=11174, `text`='Fantastic! Next, some protective spells. Yeah, now we''re cookin''!' WHERE `entry`=20977 AND `groupid`=3; -UPDATE `creature_text` SET `sound`=11175, `text`='And of course I''ll need some mana. You guys are gonna love this; just wait....' WHERE `entry`=20977 AND `groupid`=4; -UPDATE `creature_text` SET `sound`=11176 WHERE `entry`=20977 AND `groupid`=5; -UPDATE `creature_text` SET `sound`=11177 WHERE `entry`=20977 AND `groupid`=6 AND `id`=0; -UPDATE `creature_text` SET `sound`=11178 WHERE `entry`=20977 AND `groupid`=6 AND `id`=1; -UPDATE `creature_text` SET `sound`=11179 WHERE `entry`=20977 AND `groupid`=7; -UPDATE `creature_text` SET `sound`=11180 WHERE `entry`=20977 AND `groupid`=8; -UPDATE `creature_text` SET `sound`=11181 WHERE `entry`=20977 AND `groupid`=9; -UPDATE `creature_text` SET `sound`=11182 WHERE `entry`=20977 AND `groupid`=10; -UPDATE `creature_text` SET `sound`=11183 WHERE `entry`=20977 AND `groupid`=11; diff --git a/sql/updates/world/2012_12_23_01_world_creature_text.sql b/sql/updates/world/2012_12_23_01_world_creature_text.sql new file mode 100644 index 00000000000..b663c5269e9 --- /dev/null +++ b/sql/updates/world/2012_12_23_01_world_creature_text.sql @@ -0,0 +1,13 @@ +UPDATE `creature_text` SET `sound`=11171, `text`='Where in Bonzo''s Brass Buttons am I? And who are-- yaaghh, that''s one mother of a headache!' WHERE `entry`=20977 AND `groupid`=0; +UPDATE `creature_text` SET `sound`=11172, `text`='\"Lowly\"? I don''t care who you are, friend: no one refers to the mighty Millhouse Manastorm as \"lowly\"!' WHERE `entry`=20977 AND `groupid`=1; +UPDATE `creature_text` SET `sound`=11173, `text`='I just need to get some things ready first. You guys go ahead and get started. I need to summon up some water....' WHERE `entry`=20977 AND `groupid`=2; +UPDATE `creature_text` SET `sound`=11174, `text`='Fantastic! Next, some protective spells. Yeah, now we''re cookin''!' WHERE `entry`=20977 AND `groupid`=3; +UPDATE `creature_text` SET `sound`=11175, `text`='And of course I''ll need some mana. You guys are gonna love this; just wait....' WHERE `entry`=20977 AND `groupid`=4; +UPDATE `creature_text` SET `sound`=11176 WHERE `entry`=20977 AND `groupid`=5; +UPDATE `creature_text` SET `sound`=11177 WHERE `entry`=20977 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `sound`=11178 WHERE `entry`=20977 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `sound`=11179 WHERE `entry`=20977 AND `groupid`=7; +UPDATE `creature_text` SET `sound`=11180 WHERE `entry`=20977 AND `groupid`=8; +UPDATE `creature_text` SET `sound`=11181 WHERE `entry`=20977 AND `groupid`=9; +UPDATE `creature_text` SET `sound`=11182 WHERE `entry`=20977 AND `groupid`=10; +UPDATE `creature_text` SET `sound`=11183 WHERE `entry`=20977 AND `groupid`=11; diff --git a/sql/updates/world/2012_12_23_02_world_trinity_string.sql b/sql/updates/world/2012_12_23_02_world_trinity_string.sql new file mode 100644 index 00000000000..ac99945d5a5 --- /dev/null +++ b/sql/updates/world/2012_12_23_02_world_trinity_string.sql @@ -0,0 +1 @@ +UPDATE `trinity_string` SET `content_default` = '%s does not wish to be disturbed: %s' WHERE `entry`=707; -- cgit v1.2.3