diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_02_25_10_world.sql | 138 |
1 files changed, 138 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_02_25_10_world.sql b/sql/updates/world/3.3.5/2024_02_25_10_world.sql new file mode 100644 index 00000000000..2f4fc64cd4b --- /dev/null +++ b/sql/updates/world/3.3.5/2024_02_25_10_world.sql @@ -0,0 +1,138 @@ +-- The Emblazoned Runeblade (12619) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=12619; + +-- Runeforging: Preparation For Battle (12842) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=12842; + +-- The Endless Hunger (12848) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12848; + +-- The Eye Of Acherus (12636) +UPDATE `quest_offer_reward` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12636; + +-- Death Comes From On High (12641) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12641; +UPDATE `quest_offer_reward` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12641; + +-- Report To Scourge Commander Thalanor (12850) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=5 WHERE `ID`=12850; + +-- If Chaos Drives, Let Suffering Hold The Reins (12678) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12678; + +-- Grand Theft Palomino (12680) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6 WHERE `ID`=12680; + +-- Tonight We Dine In Havenshire (12679) +UPDATE `quest_details` SET `Emote1`=396,`Emote2`=396,`Emote3`=396,`EmoteDelay1`=25 WHERE `ID`=12679; +UPDATE `quest_offer_reward` SET `Emote1`=396,`EmoteDelay1`=25 WHERE `ID`=12679; + +-- Into the Realm of Shadows (12687) +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=12687; + +-- Gothik the Harvester (12697) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12697; + +-- The Gift That Keeps On Giving (12698) +UPDATE `quest_details` SET `Emote1`=5,`Emote2`=25,`Emote3`=1,`Emote4`=1 WHERE `ID`=12698; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12698; + +-- An Attack Of Opportunity (12700) +UPDATE `quest_details` SET `Emote1`=5,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12700; + +-- Massacre At Light's Point (12701) +UPDATE `quest_details` SET `Emote1`=274,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12701; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12701; + +-- Victory At Death's Breach! (12706) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12706; + +-- The Will Of The Lich King (12714) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=273,`Emote4`=25 WHERE `ID`=12714; + +-- The Crypt of Remembrance (12715) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12715; + +-- The Plaguebringer's Request (12716) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=5,`Emote3`=1,`Emote4`=6 WHERE `ID`=12716; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6 WHERE `ID`=12716; + +-- Noth's Special Brew (12717) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12717; + +-- Nowhere To Run And Nowhere To Hide (12719) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12719; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=12719; + +-- Lambs To The Slaughter (12722) +UPDATE `quest_details` SET `Emote1`=0 WHERE `ID`=12722; + +-- How To Win Friends And Influence Enemies (12720) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12720; + +-- Behind Scarlet Lines (12723) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12723; + +-- The Path Of The Righteous Crusader (12724) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12724; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=12724; + +-- Brothers In Death (12725) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=5 WHERE `ID`=12725; + +-- A Cry For Vengeance! (12738) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12738; + +-- A Special Surprise (For all races) +DELETE FROM `quest_details` WHERE `ID` IN (12739,12742,12743,12744,12745,12746,12747,12748,12749,12750); +INSERT INTO `quest_details` (`ID`,`Emote1`,`Emote2`,`Emote3`,`Emote4`,`EmoteDelay1`,`EmoteDelay2`,`EmoteDelay3`,`EmoteDelay4`,`VerifiedBuild`) VALUES +(12739,1,1,1,1,0,0,0,0,0), +(12742,1,1,1,1,0,0,0,0,0), +(12743,1,1,1,1,0,0,0,0,0), +(12744,1,1,1,1,0,0,0,0,0), +(12745,1,1,1,1,0,0,0,0,0), +(12746,1,1,1,1,0,0,0,0,0), +(12747,1,1,1,1,0,0,0,0,0), +(12748,1,1,1,1,0,0,0,0,0), +(12749,1,1,1,1,0,0,0,0,0), +(12750,1,1,1,1,0,0,0,0,0); + +-- A Sort Of Homecoming (12751) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=66 WHERE `ID`=12751; + +-- Ambush At The Overlook (12754) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=25 WHERE `ID`=12754; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=12754; + +-- A Meeting With Fate (12755) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12755; + +-- The Scarlet Onslaught Emerges (12756) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=15 WHERE `ID`=12756; + +-- Scarlet Armies Approach... (12757) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=12757; + +-- The Scarlet Apocalypse (12778) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=1 WHERE `ID`=12778; +UPDATE `quest_offer_reward` SET `Emote1`=1,`Emote2`=1 WHERE `ID`=12778; + +-- An End To All Things... (12779) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=25 WHERE `ID`=12779; +UPDATE `quest_offer_reward` SET `Emote1`=25,`Emote2`=1,`Emote3`=1 WHERE `ID`=12779; + +-- The Lich King's Command (12800) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=25 WHERE `ID`=12800; + +-- The Light of Dawn (12801) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1,`Emote4`=15 WHERE `ID`=12801; + +-- Taking Back Acherus (13165) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=13165; + +-- The Battle For The Ebon Hold (13166) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=13166; +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=5 WHERE `ID`=13166; + +-- Where Kings Walk (13188) +UPDATE `quest_details` SET `Emote1`=1,`Emote2`=1,`Emote3`=1 WHERE `ID`=13188; |