DB/Gilneas: Updated quest_ related tables for Chapter 1

quest_offer_reward / quest_details / quest_requested_items

1 files changed, 30 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_10_11_01_world.sql b/sql/updates/world/master/2025_10_11_01_world.sql
new file mode 100644
index 00000000000..8dc21ff6d81
--- /dev/null
+++ b/sql/updates/world/master/2025_10_11_01_world.sql
@@ -0,0 +1,30 @@
+-- Quest related tables
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (14285 /*Safety in Numbers*/, 14269 /*Someone's Looking for You*/);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(14285, 0, 0, 0, 0, 0, 0, 0, 0, 'You\'ve done well in coming here.  If we Gilneans stick together we might yet defeat this terrible enemy.', 63796), -- Safety in Numbers
+(14269, 0, 0, 0, 0, 0, 0, 0, 0, 'Oh, hey!  There you are!', 63796); -- Someone's Looking for You
+
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=63796 WHERE `ID` IN (14222, 14221, 14218, 14212, 14294, 14293, 14214, 14204, 14159, 26129, 24930, 14154, 28850, 14157, 14099, 14094, 14098, 14093, 14091, 14078);
+
+UPDATE `quest_poi` SET `VerifiedBuild`=63796 WHERE (`QuestID`=14222 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14222 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14222 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14221 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=14221 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14221 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14218 AND `BlobIndex`=0 AND `Idx1`=8) OR (`QuestID`=14218 AND `BlobIndex`=6 AND `Idx1`=7) OR (`QuestID`=14218 AND `BlobIndex`=5 AND `Idx1`=6) OR (`QuestID`=14218 AND `BlobIndex`=4 AND `Idx1`=5) OR (`QuestID`=14218 AND `BlobIndex`=3 AND `Idx1`=4) OR (`QuestID`=14218 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=14218 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=14218 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14218 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14212 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14212 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14294 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14294 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14293 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14293 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14293 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14214 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14214 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14204 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14204 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14204 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14159 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14159 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=26129 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=26129 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14154 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14154 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14154 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=28850 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=28850 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=24930 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=24930 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24930 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14157 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14157 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14285 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14285 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14269 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14269 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14099 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14099 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14094 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14094 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14094 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14098 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=14098 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=14098 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14098 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14093 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=14093 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14093 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14091 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14091 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14078 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14078 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=90719 AND `BlobIndex`=4 AND `Idx1`=5) OR (`QuestID`=90719 AND `BlobIndex`=3 AND `Idx1`=4) OR (`QuestID`=90719 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=90719 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=90719 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=90719 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=63796 WHERE (`QuestID`=14222 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14222 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14222 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14221 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14221 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14221 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=8 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=7 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=7 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=7 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=6 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=6 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=6 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=5 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=5 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=5 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=6) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=5) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=4) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=10) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=9) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=8) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=7) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=6) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=5) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=4) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=8) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=7) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=6) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=5) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=4) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14218 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14218 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14212 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14212 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14294 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14294 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14293 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14293 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14293 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14214 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14214 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14204 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14204 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14204 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14159 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14159 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=26129 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=26129 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14154 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14154 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14154 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=28850 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=28850 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=24930 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=24930 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24930 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14157 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14157 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14285 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14285 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14269 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14269 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14099 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14099 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14094 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14094 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14094 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14098 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=6) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=5) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=4) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=3) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=2) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=1) OR (`QuestID`=14098 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14098 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14098 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14098 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14098 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14098 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14093 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=14093 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14093 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14091 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14091 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14078 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14078 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=90719 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID` IN (14285 /*Safety in Numbers*/, 14269 /*Someone's Looking for You*/);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(14285, 0, 0, 0, 0, 0, 0, 0, 0, 63796), -- Safety in Numbers
+(14269, 0, 0, 0, 0, 0, 0, 0, 0, 63796); -- Someone's Looking for You
+
+UPDATE `quest_details` SET `VerifiedBuild`=63796 WHERE `ID` IN (14222, 14221, 14218, 14212, 14294, 14293, 14214, 14204, 14159, 26129, 14154, 28850, 24930, 14157, 14099, 14094, 14098, 14093, 14091, 14078);
+
+DELETE FROM `quest_request_items` WHERE `ID` IN (14093 /*All Hell Breaks Loose*/, 14222 /*Last Stand*/, 14218 /*By Blood and Ash*/, 14098 /*Evacuate the Merchant Square*/);
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES
+(14093, 0, 0, 0, 0, 'Have the worgen been dealt with?', 63796), -- All Hell Breaks Loose
+(14222, 0, 0, 0, 0, 'We can do this, $n.', 63796), -- Last Stand
+(14218, 0, 0, 0, 0, 'We must take out as many of them as we can, $n.', 63796), -- By Blood and Ash
+(14098, 0, 0, 0, 0, 'Have you succeeded, $n?', 63796); -- Evacuate the Merchant Square
+
+UPDATE `quest_request_items` SET `CompletionText`='Have you salvaged the supplies, $n?', `VerifiedBuild`=63796 WHERE `ID`=14094; -- Salvage the Supplies
+UPDATE `quest_request_items` SET `CompletionText`='Is it done yet, $n?', `VerifiedBuild`=63796 WHERE `ID`=14204; -- From the Shadows
+UPDATE `quest_request_items` SET `CompletionText`='What is it then, $n?', `VerifiedBuild`=63796 WHERE `ID`=24930; -- While You're At It
+UPDATE `quest_request_items` SET `VerifiedBuild`=63796 WHERE `ID`=14154;