From 6efe5d9603e17de30e941d9b10466219c62b2760 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 20 Apr 2014 11:57:48 +0200 Subject: DB/Creature: Fix Birgitte Cranston By untaught, closes #11842 --- sql/updates/world/2014_04_20_00_world_misc.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2014_04_20_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_20_00_world_misc.sql b/sql/updates/world/2014_04_20_00_world_misc.sql new file mode 100644 index 00000000000..2e98abdbd8a --- /dev/null +++ b/sql/updates/world/2014_04_20_00_world_misc.sql @@ -0,0 +1,6 @@ +-- +UPDATE `gossip_menu_option` SET `option_id`=5, `npc_option_npcflag`=16 WHERE `menu_id`=4825; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup`=4825; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14,4825,5881,0,0,15,0,128,0,0,0,0,0,'','Show gossip text if player is a Mage'), +(15,4825,0,0,0,15,0,128,0,0,0,0,0,'','Show gossip option if player is a Mage'); -- cgit v1.2.3 From d4e355d5344d98e127e9d33082262649812062a9 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 20 Apr 2014 14:01:44 +0200 Subject: DB/Creature Text: Add texts for Injured Soldiers By untaught closes #11872 NOTE: don't posts multiple unrelated bugs on a single ticket. --- sql/updates/world/2014_04_20_01_world_creature_text.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_04_20_01_world_creature_text.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_20_01_world_creature_text.sql b/sql/updates/world/2014_04_20_01_world_creature_text.sql new file mode 100644 index 00000000000..8e8ac1813bc --- /dev/null +++ b/sql/updates/world/2014_04_20_01_world_creature_text.sql @@ -0,0 +1,5 @@ +DELETE FROM `creature_text` WHERE `entry` IN (12923,12924,12925); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(12923,0,0,'I''m saved! Thank you, doctor!',12,0,100,0,0,0,''), +(12924,0,0,'I''m saved! Thank you, doctor!',12,0,100,0,0,0,''), +(12925,0,0,'I''m saved! Thank you, doctor!',12,0,100,0,0,0,''); -- cgit v1.2.3 From 2132fc41fa20151d9e8db6a8bf890b2b0345d6a4 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 20 Apr 2014 19:10:50 +0200 Subject: DB/Creature: Fix Earthcaller Ryga By untaught, closes #11827 --- sql/updates/world/2014_04_20_02_creature_text.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2014_04_20_02_creature_text.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_20_02_creature_text.sql b/sql/updates/world/2014_04_20_02_creature_text.sql new file mode 100644 index 00000000000..0a5a064a72d --- /dev/null +++ b/sql/updates/world/2014_04_20_02_creature_text.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `creature_text` WHERE `entry`=17123; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `broadcasttextid`) VALUES +(17123,0,0,'Welcome, kind spirit. What has brought you to us?',12,0,100,0,0,0,'',13512); -- cgit v1.2.3 From c26dec8dbba6ae6480018c571513f75e0b151a65 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 20 Apr 2014 19:48:08 +0200 Subject: DB/Misc: Adition to 29dccd9 By dr-j, closes #11911 --- sql/updates/world/2014_04_20_03_gossip_menu_option.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2014_04_20_03_gossip_menu_option.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_20_03_gossip_menu_option.sql b/sql/updates/world/2014_04_20_03_gossip_menu_option.sql new file mode 100644 index 00000000000..7e6b7224173 --- /dev/null +++ b/sql/updates/world/2014_04_20_03_gossip_menu_option.sql @@ -0,0 +1,2 @@ +-- +UPDATE `gossip_menu_option` SET `option_text`='Chief Ashtotem, I have misplaced the token that you gave me.', `OptionBroadcastTextID`=22811 WHERE `menu_id`=8898 AND `id`=0; -- cgit v1.2.3