diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2021-09-21 18:36:06 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-09-21 18:36:06 +0200 |
| commit | 61d6e8aaf036c5e236d839ccd07cc07745efe0f1 (patch) | |
| tree | 772c3e1fe4452081343f3252186867168b905297 | |
| parent | 6139afe927ab3f6ec803f5dffb4df0cce37c203d (diff) | |
DB/Quest: Missing quest_poi and quest_poi_points for Solanian's Belongings quest
closes #26910 by @osleyder85
| -rw-r--r-- | sql/updates/world/master/2021_09_21_03_world.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_21_03_world.sql b/sql/updates/world/master/2021_09_21_03_world.sql new file mode 100644 index 00000000000..6ed3f430380 --- /dev/null +++ b/sql/updates/world/master/2021_09_21_03_world.sql @@ -0,0 +1,26 @@ +-- 37443 Solanian's Belongings +UPDATE `quest_template` SET `RewardMoney`=200, `RewardBonusMoney`=270, `FlagsEx`=0, `VerifiedBuild`=40120 WHERE `ID`=37443; + +UPDATE `quest_template_addon` SET `PrevQuestID`=8326 WHERE `ID`=37443; + +UPDATE `quest_offer_reward` SET `VerifiedBuild`=40120 WHERE `ID`=37443; + +DELETE FROM `quest_poi` WHERE (`QuestID`=37443 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=37443 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=37443 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=37443 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=37443 AND `BlobIndex`=0 AND `Idx1`=0); +INSERT INTO `quest_poi` (`QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `UiMapID`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `NavigationPlayerConditionID`, `SpawnTrackingID`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`) VALUES +(37443, 0, 4, 32, 0, 0, 530, 467, 0, 0, 0, 0, 0, 120439, 0, 40120), +(37443, 0, 3, 2, 276222, 20472, 530, 467, 0, 0, 0, 0, 0, 120395, 0, 40120), +(37443, 0, 2, 1, 276221, 20471, 530, 467, 0, 0, 0, 0, 0, 120392, 0, 40120), +(37443, 0, 1, 0, 276220, 20470, 530, 467, 0, 0, 0, 0, 0, 120390, 0, 40120), +(37443, 0, 0, -1, 0, 0, 530, 467, 0, 0, 0, 0, 0, 120439, 0, 40120); + +DELETE FROM `quest_poi_points` WHERE (`QuestID`=37443 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=37443 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=37443 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=37443 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=37443 AND `Idx1`=0 AND `Idx2`=0); +INSERT INTO `quest_poi_points` (`QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `Z`, `VerifiedBuild`) VALUES +(37443, 4, 0, 10376, -6407, 50, 40120), +(37443, 3, 0, 10224, -6344, 31, 40120), +(37443, 2, 0, 10295, -6030, 28, 40120), +(37443, 1, 0, 10093, -6218, 17, 40120), +(37443, 0, 0, 10376, -6407, 50, 40120); + +UPDATE `quest_details` SET `VerifiedBuild`=40120 WHERE `ID`=37443; + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6, `VerifiedBuild`=40120 WHERE `ID`=37443; |