aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-04-20 11:57:48 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-04-20 11:57:48 +0200
commit6efe5d9603e17de30e941d9b10466219c62b2760 (patch)
treeedd685874bb4b06480d1e3f3d6cab95b5df95df7
parentfb6365ac689419a2e5dd758d4bf70c1a20ff41ff (diff)
DB/Creature: Fix Birgitte Cranston
By untaught, closes #11842
-rw-r--r--sql/updates/world/2014_04_20_00_world_misc.sql6
1 files changed, 6 insertions, 0 deletions
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');