diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-11-01 13:57:34 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-11-26 16:18:01 +0100 |
| commit | 03384215431130171dd47d40a2d2e8d70e1d41c3 (patch) | |
| tree | 28e3d57cd09d6c16367ec28480e9002394ecbd9c /sql | |
| parent | cedc2644688a6338ea3510d24c35ce62212015ed (diff) | |
DB/Creature: Augustus the Untouched
Move from cpp to db, also added some missing detail
(cherry picked from commit cefed89c38bcd7bb7562df51f9e932878084c5da)
Remove obsolete file
(cherry picked from commit 9be0362606971e40f47543462f133125e995279d)
Remove reference to eastern plaguelands script
(cherry picked from commit 1fc8e2d5f28964bfb69304760e0d9333a45aee28)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_11_26_04_world_2016_11_01_02_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_11_26_04_world_2016_11_01_02_world.sql b/sql/updates/world/master/2017_11_26_04_world_2016_11_01_02_world.sql new file mode 100644 index 00000000000..eb3f95e3e6d --- /dev/null +++ b/sql/updates/world/master/2017_11_26_04_world_2016_11_01_02_world.sql @@ -0,0 +1,16 @@ +DELETE FROM `gossip_menu_option` WHERE `MenuID`=4085; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcflag`, `VerifiedBuild`) VALUES +(4085, 0, 1, 'Yes, Augustus. I would like to do business.', 7623, 3, 128, 0); + +DELETE FROM `gossip_menu` WHERE `MenuID`=4085; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(4085, 4979, 0), +(4085, 4980, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`IN(14,15) AND `SourceGroup`=4085; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 4085, 4979, 0, 0, 8, 0, 6164, 0, 0, 1, 0, 0, '', 'Augustus - Show Gossip Menu text 4979 if Quest 6164 is not rewarded'), +(14, 4085, 4980, 0, 0, 8, 0, 6164, 0, 0, 0, 0, 0, '', 'Augustus - Show Gossip Menu text 4980 if Quest 6164 is rewarded'), +(15, 4085, 0, 0, 0, 8, 0, 6164, 0, 0, 0, 0, 0, '', 'Augustus - Only allow players who have completed Augustus Receipt Book to access vendor'); + +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=12384; |