diff options
| author | Killyana <morphone1@gmail.com> | 2019-04-02 23:15:47 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-04-02 23:15:47 +0200 |
| commit | 2878db4eb0bb76f8713559609359b269933bb7ae (patch) | |
| tree | a630e51e18ac540f2d6527e063b390a850c7dcb3 | |
| parent | 750d89beed38f4af9efa3699b79f2950f430bfdd (diff) | |
DB/Quest: Gearing Up To Ride
Whistle of the Venomhide Ravasaur retrieving
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_02_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_02_00_world.sql b/sql/updates/world/3.3.5/2019_04_02_00_world.sql new file mode 100644 index 00000000000..ec8c1019439 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_02_00_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `quest_template_addon` WHERE `ID` IN(13908); +INSERT INTO `quest_template_addon` (`ID`, `SpecialFlags`) VALUES (13908,1); +DELETE FROM `creature_questender` WHERE `quest` IN (13908); +DELETE FROM `creature_queststarter` WHERE `quest` IN (13908); +INSERT INTO `creature_questender` (`id`, `quest`) VALUES +(11701, 13908); +INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES +(11701, 13908); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry` IN (13908); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 13908, 0, 0, 8, 0, 13906, 0, 0, 0, 0, 0, '', 'Quest Gearing Up To Ride available if quest They Grow Up So Fast has been rewarded.'), +(19, 0, 13908, 0, 0, 2, 0, 46102, 1, 1, 1, 0, 0, '', 'Quest Gearing Up To Ride available if the player doesnt have the item'), +(19, 0, 13908, 0, 0, 25, 0, 64659, 0, 0, 1, 0, 0, '', 'Quest Gearing Up To Ride available if the player doesnt learn the spell'); |