aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2021-12-15DB/Quest: restore ExclusiveGroup data for breadcrumb quests, as they're ↵Wyrserth
mutually exclusive. Also restore PrevQuestId/NextQuestId error logs involving breadcrumb quests. Special cases must be handled via conditions. (cherry picked from commit 7f63c504d5cf5a9ad2f3d77ff2c67ca9d7586dd5)
2021-12-15DB/Quest: fix some more breadcrumbs and some offer_reward emotes.Wyrserth
(cherry picked from commit 4dbdc22b3b5770ff8252ea057bf7a7a92dcb31cb)
2021-12-15DB/Quest: fix some breadcrumb quests.Wyrserth
(cherry picked from commit 2a9c038fc8bf87b968a94b23bd0ddb79fecf8b17)
2021-12-15DB/Creature: add out of combat events and fix pathing for Conjurer Tyren.Wyrserth
(cherry picked from commit b9d1e665075ffbd94f3ec96a3e8819615bd3d24a)
2021-12-15DB/Quest: improvements for quest Hampering Their Escape:Wyrserth
- Add missing flames on item use. - Prevent trigger creatures from wandering around and falling off the platform - Add conditions to the item Gnomish Grenade (cherry picked from commit 76beda3768ebbcbf42f96e2f8596c95b24327dfe)
2021-12-15DB/SAI: add waypoints and out-of-combat texts for Ambassador Kelemar, Dela ↵Wyrserth
Runetotem, Cheneta, Kristine Denny and Tatai. Closes #14485. (cherry picked from commit 90a04adb408726c66d115b0053aad54e51d934d1)
2021-12-15Scripts/Spells: Brittle Armor & Mercurial Shield (#23576)Sorikoff
(cherry picked from commit a64d7df6623d90c529fab76dc6b41e2db5a3abd4)
2021-12-14DB/Creature: prevent floating Gjalerbron Prisoners from falling to the ground.Wyrserth
Also fix mistake in DELETE query for previously committed SQL file. (cherry picked from commit d18b7572f40360d6f47d48faa306665b008e7dd8)
2021-12-14Script/TheOculus: adapt Mage-Lord Urom's script to use EventMap, fix various ↵Wyrserth
issues with Teleport and Empowered Arcane Explosion, add missing heroic-mode spell Frost Buffet. Closes #19452. (cherry picked from commit 37862942ce61ceffe5440d67efe7db553fa22f9b)
2021-12-14TypoKillyana
(cherry picked from commit 3b07a0452acdd9f71666b78187305f3b26cd1da7)
2021-12-14DB/Quest: Tails UpKillyana
(cherry picked from commit 66e755679f64fb2135022ee3a92342442fbb6a2b)
2021-12-14DB/GameObject: Fix Ysida's Cage base positionKillyana
(cherry picked from commit 5771e093788d6de4481e83d06771a6b30f61667d)
2021-12-14Script/BlackrockDepths: fix Ironhand Guardian's Gout of Flame spell cast. ↵Martin Topholm
(#21816) (cherry picked from commit 4529a94e0d093fb01c6ae4a98dade46ce75f82a9)
2021-12-14DB/SAI: remove useless actions from Regthar Deathgate's script.Wyrserth
Fixes #23543. (cherry picked from commit a8d232a92158bb9782e0895e6788692ee4729eb7)
2021-12-14DB/SAI: script end event for quest To Serve Kum'isha.ZenoX92
(cherry picked from commit 515f47eec7263bfb593a2697c0be8afa40ed0324)
2021-12-14Script/Acherus: script out of combat event for Frost Death Knight trainer ↵Wyrserth
Amal'thazad. (cherry picked from commit 8fcc82138fee2bbea7b7f82d4b0475e4f53f100c)
2021-12-14DB/SAI: add emotestate and OOC text for creature Zeh'gehn and improve end ↵Wyrserth
event for quest A Carver and a Croaker. (cherry picked from commit 9530c33af0847ac13826d20f21d2447f0817bfa5)
2021-12-14DB/Quest: Tome of CabalKillyana
Closes #23560 (cherry picked from commit 1557a806104a886672bb421f9c12c0f39989f6b1)
2021-12-14DB/Creature: remove wrong repairer npcflag from NPC Perascamin.Wyrserth
(cherry picked from commit cc5088369b43f25f68443e1018e994694158c2c2)
2021-12-14DB/SAI: add some missing RP events to Culling of Stratholme.Wyrserth
Scripted RP events involving NPCs Stephanie Sindree, Brandon Eiredeck and Patricia O'Reilly. (cherry picked from commit c63bbb97b4850abfd60917bd9b668f276f9ecedb)
2021-12-13DB/Vendor: rework Griftah's inventory.Wyrserth
Remove deprecated items and fix slot ordering. (cherry picked from commit f05891405ab40502cfa67fdcff0edb1391ff8719)
2021-12-13DB/Hotfixes: Add missing hotfix optional data for each localeShauren
2021-12-13Scripts/Spells: Dimensional Ripper - Everlook (#23547)Sorikoff
(cherry picked from commit 5c09ff51f7015b775def8d5cc1f678eaef37200f)
2021-12-13DB/SAI: remove delay between clicking gossip and creature text/change ↵Wyrserth
faction for NPC Victorious Challenger involved in quest Taking on All Challengers. (cherry picked from commit 5a9516cd9c27fc9f4f444d8658d9bd6ac3afc027)
2021-12-13DB/Creature: Hyldsmeet Warbear shouldn't have random movement.Wyrserth
(cherry picked from commit 4a875ec392b41030ea8f394335edc2860079fbb9)
2021-12-13DB/Creature: add emote state and out of combat emote for NPC Brunnhildar ↵Wyrserth
Challenger. (cherry picked from commit dd870a141fd521d1e760f984bc93db6101d8e733)
2021-12-13DB/Conditions: allow gossip option for NPC Agnetta Tyrsdottar to show only ↵Wyrserth
if the quest Is That Your Goblin? is taken but not completed. (cherry picked from commit e621d40ddcb7b8d70012ea27aa78baf81d0a7902)
2021-12-13DB/Quest: fix chaining for quests offered by Lantresor of the Blade.Rynem
Closes #22440. (cherry picked from commit 72917d5036be071a7243c1faa602dd1ad17543ba)
2021-12-13DB/SAI: implement out-of-combat event for NPC Ranger Sareyn.Wyrserth
Closes #23538. (cherry picked from commit ce3820031d4185d4124fa062baa99619e483a84c)
2021-12-13DB/SAI: implement out-of-combat event for NPC Ranger Jaela.Wyrserth
Closes #23535. (cherry picked from commit fa0fc13fd06e1af3dc6cb2ea611c4012660bfbdb)
2021-12-13DB/SAI: add out-of-combat texts to Instructor HroegarWyrserth
(cherry picked from commit 45a2388bc0c8c0825f2f59c277da8d77f3b74942)
2021-12-13DB/SAI: script creature Mjordin Combatant involved in the quest Honor Challenge.Wyrserth
(cherry picked from commit e803ba77326fd5a274ee1fb54a9e9c32e01b39c6)
2021-12-13Scripts/ICC: base support for Ymirjar Vrykuls AIccrs
(cherry picked from commit 3dbf3fed7c10b5808d2c20bdd3a8a3598ddd7cf6)
2021-12-13DB/Creature: fix spawns and emote state for Mjordin Combatants in Icecrown.Wyrserth
(cherry picked from commit e1787b883e1dc4cd67d6b30c8a1ca6db4abb2660)
2021-12-13DB/Quest: remove quest requirements from the Consortium monthly quests.Wyrserth
Only one is available each month, based on reputation standing. They're not chained. (cherry picked from commit 5aedc4a5102858f4bab35721fd5ff8e2234f3181)
2021-12-13DB/SAI: improvements for quest Powering our Defenses:Wyrserth
- There are two waves of three Enraged Wraith each - The quest does not fail when the Infused Crystal is killed, as the quest item is not consumable so the player can try again straight away (cherry picked from commit d213970719bfcfeba16dd400217aa722e63b2615)
2021-12-13Scripts/Spells: Ultrasafe Transporter: Toshley's Station (#23537)Sorikoff
* Scripts/Spells: Ultrasafe Transporter: Toshley's Station * Rename 9999_99_99_99_world.sql to 2019_06_29_01_world.sql (cherry picked from commit 33b4ad5a89cae0d3d527b58e1a438772450d7e32)
2021-12-13Scripts/Spells: Remove Collapsing Cave Aura (#23533)Sorikoff
* Scripts/Spells: Remove Collapsing Cave Aura * Rename 9999_99_99_99_world.sql to 2019_06_29_00_world.sql (cherry picked from commit 8d1a5fa1266dc98438cabfb1ced7891791245ff0)
2021-12-13Scripts/Spells: Deathbolt (#23531)Sorikoff
* Scripts/Spells: Deathbolt * Rename 9999_99_99_99_world.sql to 2019_06_28_01_world.sql (cherry picked from commit 62b2c379b37b843076eb4df379e7de86b18303eb)
2021-12-13Scripts/Spells: Dimensional Ripper - Area 52 (#23505)Sorikoff
* Scripts/Spells: Dimensional Ripper - Area 52 * Rename 9999_99_99_99_world.sql to 2019_06_28_00_world.sql (cherry picked from commit 63f548921c268cc9f30af68bf9b41c80df0492ac)
2021-12-13Script/ZulGurub: rewrite High Priest Thekal's encounter script (#23429)Wyrserth
(cherry picked from commit 365e2f191efa5576c0045a9ebdffe63e1ea3bac7)
2021-12-13DB/Loot: remove wrong loot from gameobjects Worn Wooden Chest and Captain's ↵Killyana
Footlocker. (cherry picked from commit 1c373f29ff178ae3562963f85734cc75b4b4b437)
2021-12-13DB/SAI: fix issue with quest "Still At It" introduced in 2b1cde25.Wyrserth
Closes #23525. (cherry picked from commit 6aa3ec8fb10e6916fd00368af40471ef8dbeb5d6)
2021-12-13DB/Creature: Fix RS, ICC, ToC and VoA melee dmgAokromes
By Fluffybully closes #21598 (cherry picked from commit 81939b96855489815f45795b9941f6d956d2dd89)
2021-12-13DB/Quest: Wolfsbane RootKillyana
Closes #16545 (cherry picked from commit cc788bb8bbd280194a2618e1c7d935b2e37ca31c)
2021-12-13DB/Quest: The Stones That Bind UsZenoX92
Closes #11687 (cherry picked from commit 9f1144ac2dfb7b5b584ed34d1f91a36d5fcbc389)
2021-12-13DB/SAI: script event for quest Rescuing the Rescuers.Wyrserth
Closes #23444 Co-authored-by: Killyana <morphone1@gmail.com> (cherry picked from commit afbd4bbe59f57e0d4ed8e400bc35efc95c54dd8a)
2021-12-13DB: Add cosmetic spawns to The Culling of StratholmeKillyana
(cherry picked from commit 07e76baf77867b488871c7614d8b34a813442c9c)
2021-12-13DB/Waypoint: add pathing for Nishera the Garden Keeper.Wyrserth
(cherry picked from commit fcae8b1bff2ba109a9aad6dade0d61a84caa2e99)
2021-12-13Script/CoS: fix DB error and remove wrong on-death text for Chrono-Lord Epoch.Wyrserth
(cherry picked from commit 22b222b44e2f26900568af2ebdb92bf19185cfb9)