diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_14_01_world.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_14_01_world.sql b/sql/updates/world/3.3.5/2019_06_14_01_world.sql new file mode 100644 index 00000000000..7a2ac07503f --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_14_01_world.sql @@ -0,0 +1,39 @@ +-- Speak with Prospector Stonehewer and Speak with Voggah Deathgrip are deprecated +DELETE FROM disables WHERE sourceType=1 AND entry IN (7221, 7222); +INSERT INTO disables (sourceType, entry, flags, COMMENT) VALUES +(1, 7221, 0, "Deprecated quest"), +(1, 7222, 0, "Deprecated quest"); + +-- The Battle of Alterac and The Battle for Alterac have no prequest +UPDATE `quest_template_addon` SET `NextQuestId`=0 WHERE `ID` IN (7221, 7222); + +-- In Defense of Frostwolf is a breadcrumb to Proving Grounds +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=7161 WHERE `ID`=7241; +-- The Sovereign Imperative is a breadcrumb to Proving Grounds +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=7162 WHERE `ID`=7261; + +UPDATE `quest_request_items` SET `CompletionText`="<Warmaster Laggrond salutes you.>$B$BIt is your time, $N. You have done much for the Frostwolf Clan and in doing so, earned a place as not only a soldier of Frostwolf but also as a friend.$B$BWell done! Present your initiate's insignia." WHERE `ID`=7163; +UPDATE `quest_request_items` SET `CompletionText`="It is good to see you again, $C. I had not expected you to return. Alas, you have proven yourself a brave and honorable soldier of the Frostwolf.$B$BYour time has come again, $N. You have earned a new ranking and as such, a new insignia denoting this rise in stature.$B$BPresent your insignia." WHERE `ID`=7164; +UPDATE `quest_request_items` SET `CompletionText`="So many slain. Blood drenches the fields. Yet... You live... You have persevered. You have led our armies to many victories. For this, then, soldier, you have earned a new rank.$B$BPresent your insignia." WHERE `ID`=7165; +UPDATE `quest_request_items` SET `CompletionText`="Your radiate command and power, $C. Exalted in the eyes of Frostwolf - the enemy cowers at the mention of your name.$B$BRise, Hero of Frostwolf. Rise and be honored!$B$BPresent your insignia." WHERE `ID`=7166; +UPDATE `quest_request_items` SET `CompletionText`="Drek'Thar sings your praises. Kalimdor is abuzz with tales of your heroics. The Warchief glows - your stalwart defense of our clan has pleased him greatly.$B$BYou have earned the Eye of Command.$B$BPresent your insignia, Commander $N." WHERE `ID`=7167; +UPDATE `quest_request_items` SET `CompletionText`="Let them hear your voice, Commander $N! Let them know fear. Show them what power the Stormpike holds in their rank!" WHERE `ID`=7172; + +UPDATE `quest_offer_reward` SET `RewardText`="This new insignia reflects your rank amongst the Frostwolf. Keep it on you at all times.$B$BAnd $C... Die with honor!" WHERE `ID`=7163; +UPDATE `quest_offer_reward` SET `RewardText`="<Warmaster Laggrond roars.>$B$BThey have already begun telling tales of your deeds, soldier. The Stormpike shakes in fear when your name is uttered. Carry on!" WHERE `ID`=7165; +UPDATE `quest_offer_reward` SET `RewardText`="Surely it will be you who carries the Eye of Command!" WHERE `ID`=7171; + +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=729, `RequiredMinRepValue`=3000 WHERE `ID`=7163; +UPDATE `quest_template_addon` SET `PrevQuestID`=7163, `RequiredMinRepFaction`=729, `RequiredMinRepValue`=9000 WHERE `ID`=7164; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=729, `RequiredMinRepValue`=42000 WHERE `ID`=7166; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=729, `RequiredMinRepValue`=42999 WHERE `ID`=7167; + +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=730, `RequiredMinRepValue`=3000 WHERE `ID`=7168; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=730, `RequiredMinRepValue`=9000 WHERE `ID`=7169; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=730, `RequiredMinRepValue`=21000 WHERE `ID`=7170; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=730, `RequiredMinRepValue`=42000 WHERE `ID`=7171; +UPDATE `quest_template_addon` SET `RequiredMinRepFaction`=730, `RequiredMinRepValue`=42999 WHERE `ID`=7172; + +DELETE FROM `quest_template_addon` WHERE `ID`=7165; +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `RequiredMinRepFaction`, `RequiredMinRepValue`) VALUES +(7165, 7164, 729, 21000); |