aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-04-24 19:02:22 +0200
committerfunjoker <funjoker109@gmail.com>2020-04-28 12:56:09 +0200
commit2c60638883aed40136d5d0617dac7c10c86788cd (patch)
tree1f2bca323a3e036c677f4e1e137a06c903b95f96 /sql/updates
parentec508fbdba0beaf33684f5aa5fa64d30bdcd9815 (diff)
DB/Gossip: Maddix and Alieshor
Updates #19432 (cherry picked from commit 2885dc92d03fd3b08ae6a33dcef99393891727b6)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2020_04_27_05_world_2017_04_24_09_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_27_05_world_2017_04_24_09_world.sql b/sql/updates/world/master/2020_04_27_05_world_2017_04_24_09_world.sql
new file mode 100644
index 00000000000..bc8c6c33c1a
--- /dev/null
+++ b/sql/updates/world/master/2020_04_27_05_world_2017_04_24_09_world.sql
@@ -0,0 +1,13 @@
+--
+DELETE FROM `gossip_menu` WHERE `MenuId`=8558 AND `textid`=10722;
+INSERT INTO `gossip_menu` (`MenuId`,`textid`) VALUES
+(8558,10722);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup` IN (8558,8560);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,8558,7778,0,0,5,0,932,16,0,0,0,0,'',"Show gossip text if player is Friendly with The Aldor"),
+(14,8558,10722,0,0,5,0,932,16,0,1,0,0,'',"Show gossip text if player is not Friendly with The Aldor"),
+(14,8560,7778,0,0,5,0,934,16,0,0,0,0,'',"Show gossip text if player is Friendly with The Scryers"),
+(14,8560,10723,0,0,5,0,934,16,0,1,0,0,'',"Show gossip text if player is not Friendly with The Scryers"),
+(15,8558,0,0,0,5,0,932,16,0,0,0,0,'',"Show gossip menu option if player is Friendly with The Aldor"),
+(15,8560,0,0,0,5,0,934,16,0,0,0,0,'',"Show gossip menu option if player is Friendly with The Scryers");