diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2017-10-06 22:29:17 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2020-12-31 23:23:50 +0100 |
| commit | e7acc770ba0a4321ae51c1a688cac0a674f428a9 (patch) | |
| tree | 03e8f8988b70d9cfa3c8d0ee1f16be53462fe218 /sql | |
| parent | 4a1c738b80895b930930ae0a1a6e13ba8e984d02 (diff) | |
DB/Quest: Breadcrumbs
More fixes to make these behave properly ie the first quest been optional (not necessary) but if quest it leads to is already taken
(cherry picked from commit 8f70cc8d792d5e494d65269da5c08135ddf4cc6d)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2020_11_01_03_world_2017_10_06_01_world.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_11_01_03_world_2017_10_06_01_world.sql b/sql/updates/world/master/2020_11_01_03_world_2017_10_06_01_world.sql new file mode 100644 index 00000000000..b19a8acbfcc --- /dev/null +++ b/sql/updates/world/master/2020_11_01_03_world_2017_10_06_01_world.sql @@ -0,0 +1,22 @@ + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry`IN(12451,12161,12425, 11175,11406,12182,12189,11573,11995,12469,12542,11996,12511,12208,12210); + + + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 11175, 0, 0, 14, 0, 11176, 0, 0, 0, 0, 0, '', 'My Daughter is optional BreadCrumb Quest'), +(19, 0, 11406, 0, 0, 14, 0, 11269, 0, 0, 0, 0, 0, '', 'Everything Must Be Ready is optional BreadCrumb Quest'), +(19, 0, 12182, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'To Venomspite! is optional BreadCrumb Quest'), +(19, 0, 12189, 0, 0, 14, 0, 12188, 0, 0, 0, 0, 0, '', 'Imbeciles Abound! is optional BreadCrumb Quest'), +(19, 0, 11573, 0, 0, 14, 0, 11504, 0, 0, 0, 0, 0, '', 'Orfus of Kamagua is optional BreadCrumb Quest'), +(19, 0, 11995, 0, 0, 14, 0, 12000, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Stars'' Rest is optional BreadCrumb Quest'), +(19, 0, 12469, 0, 0, 14, 0, 12044, 0, 0, 0, 0, 0, '', 'Return to Sender is optional BreadCrumb Quest'), +(19, 0, 12542, 0, 0, 14, 0, 12545, 0, 0, 0, 0, 0, '', 'The Call Of The Crusade is optional BreadCrumb Quest'), +(19, 0, 11996, 0, 0, 14, 0, 11999, 0, 0, 0, 0, 0, '', 'Your Presence is Required at Agmar''s Hammer is optional BreadCrumb Quest'), +(19, 0, 12511, 0, 0, 14, 0, 12292, 0, 0, 0, 0, 0, '', 'The Hills Have Us is optional BreadCrumb Quest'), +(19, 0, 12208, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Good Troll Hunting is optional BreadCrumb Quest'), +(19, 0, 12210, 0, 0, 14, 0, 11984, 0, 0, 0, 0, 0, '', 'Troll Season! is optional BreadCrumb Quest'), +(19, 0, 12451, 0, 0, 14, 0, 12195, 0, 0, 0, 0, 0, '', 'Onward to Camp Oneqwah is optional BreadCrumb Quest'), +(19, 0, 12161, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest'), +(19, 0, 12425, 0, 0, 14, 0, 12328, 0, 0, 0, 0, 0, '', 'Ruuna the Blind is optional BreadCrumb Quest'); + |