diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-16 01:46:37 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-10-03 17:33:23 +0200 |
| commit | ab15413aad46f6802f940a46153a61e84dea3eb2 (patch) | |
| tree | 253ab6a6231aed744dfac923f16921b4395da223 | |
| parent | 2ecd46c58fac0db50fdc45aa89f8d5ec06cdac1c (diff) | |
DB/Conditions: show correct gossip for Baron Revilgaz if event Pirates' Day is not running.
Also fix small typo in npc_text.
(cherry picked from commit 8aa798a9b05a5827613ad0626836cd5123ce1309)
DB/Gossip: Wizlo Bearingshiner.
(cherry picked from commit 718d3e88c42d43106a7883e41bdfa9bf7b755e59)
| -rw-r--r-- | sql/updates/world/master/2017_10_03_12_world_2016_10_16_01_world_335.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/master/2017_10_03_13_world_2016_10_16_02_world_335.sql | 5 |
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_10_03_12_world_2016_10_16_01_world_335.sql b/sql/updates/world/master/2017_10_03_12_world_2016_10_16_01_world_335.sql new file mode 100644 index 00000000000..2b0c1d2bfa1 --- /dev/null +++ b/sql/updates/world/master/2017_10_03_12_world_2016_10_16_01_world_335.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=6685; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 6685, 13062, 0, 0, 12, 0, 50, 0, 0, 0, 0, 0, "", "Show gossip text 13062 for Baron Revilgaz if event Pirates' Day is running"); diff --git a/sql/updates/world/master/2017_10_03_13_world_2016_10_16_02_world_335.sql b/sql/updates/world/master/2017_10_03_13_world_2016_10_16_02_world_335.sql new file mode 100644 index 00000000000..6c7a0c65caf --- /dev/null +++ b/sql/updates/world/master/2017_10_03_13_world_2016_10_16_02_world_335.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=10941 WHERE `entry`=10941; +DELETE FROM `gossip_menu` WHERE `entry`=10941; +INSERT INTO `gossip_menu` (`entry`, `text_id`, `VerifiedBuild`) VALUES +(10941, 10299, 0); |