aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
AgeCommit message (Collapse)Author
2017-02-26DB/SmartScripts: Fix Jewelcrafting stone statues.treeston
(cherry picked from commit 0f7efc86d066ed614fa7b192da81c48d586f8b85)
2017-02-26DB/conditions: add condition Pet Type to Pet Trainers gossiptkrokli
Use ConditionTypeOrReference 45 (PetType in PetDefines.h): - Show gossip menu 4783 option id 1 if Pet Type is hunter pet ( follow-up to PR #17746 / commit 03bafe3 ) (cherry picked from commit 9d7cd93e0da110546c5a572096773901c54c7f2b)
2017-02-26Core/Fishing: implement retail-like fishing skill-up functionality (#17528)SnapperRy
Follow-up to 6f1e823. Forgot to update base characters database. Sorry.
2017-02-26DB/Quest: improvements for Test at Sea:SnapperRy
- Prevent player from entering combat when using the quest item. - The targeted NPCs should only yell sporadically. (cherry picked from commit 271c16fb60f7c0d3ada5d34e0dfc39eb8b1d2cb1) Rename 2016_09_12_03_world.sql to 2016_09_13_01_world.sql (cherry picked from commit 43968512ce88f0cbe37e23400437a753a84189ce)
2017-02-26DB/Quest: Let's Go Surfing NowSnapperRy
By @Rushor and @Killyana, finishing touches by yours truly. Closes #6845 (cherry picked from commit 3713b4e423949f2314a68b531ba7c091d4b64c3a)
2017-02-26DB/Spell: Add some attributes to Horsemen Creditariel-
Fixes achievement credit for dead players (cherry picked from commit e84d587ed47fcdcdbd3482315849d5c5f6fa18d8)
2017-02-26DB/SAI: fix wrong caster for a spell involved in quest "Towers of Certain Doom"SnapperRy
Was easily exploitable for experience, since it's a wide instakill spell. Change confirmed from sniffs. (cherry picked from commit 127825ee95214f67e217d9aff0c9683ff1aedfa8)
2017-02-26DB/Misc: replace wrong spell used in spell_area for Scalawag Point.SnapperRy
Also fix a smart script that relied on the old aura's behavior. (cherry picked from commit 927d00299847eeeebd17b4518e33046bb77ef3d7)
2017-02-26DB/Quest: small fixes for The Frost Wyrm and its Master.SnapperRy
- Fix wrong spawntime for spellfocus gameobject. - Add conditions for quest item's spell to prevent exploits, by @sirikfoll Updates #3541 (cherry picked from commit c5d190a85a2e8f6cec0affa74548e22435eaa449)
2017-02-26DB/Script: implement event for quest 9542 (Totem of Vark)SnapperRy
(cherry picked from commit 1f9abfd58511a5795ecf15d104a79d23d700a36c)
2017-02-26Scripts/Spells: Updated two Anraphet SpellScriptsjoschiwald
2017-02-26DB/Creature: remove wrong spell from NPC "Venture Co. Saboteur" and add ↵SnapperRy
correct one. They have aura "Torch Burn", they don't cast "Thorns". From sniffs. (cherry picked from commit adb2d8424bf4922f61f28a5a5ce69b6c4346a0b4)
2017-02-26DB/Gossip: fix gossip text for creature "Admiral Odesyus"SnapperRy
(cherry picked from commit c96fa033db23299f60c4e15e2f5f3a3eef507d5b)
2017-02-26DB/Spell: prevent serverside auras for Paladin talent Pursuit of Justice ↵SnapperRy
from vanishing after death. (cherry picked from commit a261e68aed4be53db7b61f601196ef9810da0d39)
2017-02-26Script/Quest: replace wrong test spell used for quest "Red Snapper - Very ↵SnapperRy
Tasty!" with actual summoning. The spell does not appear in sniffs, and the summoned NPC's spawn time was far too short to be appropriate (15 seconds). (cherry picked from commit 0479f08c3c07c4de3af4d2293b80d690e4bdf646) Script/Quest: fix and use proper serverside summon spell for quest "Red Snapper - Very Tasty!". (cherry picked from commit 2f493430c9f029867eb1699c54de853e06e850d9)
2017-02-26Core/Conditions: New CONDITION_QUESTSTATE (47). It's the existing quest ↵treeston
conditions collapsed into a bitmask value2 because I'm a lazy person that doesn't like having long SQL queries. Then use this new condition to fix Sniffing out the Perpetrator for Horde. Tagging issue #17914. (cherry picked from commit 62cffd11d0e9b33dd60cb5238f06d6dfd06415d8)
2017-02-26AI/SmartAI: Fix an issue where SmartAI creatures would not properly follow ↵treeston
their owner on evade. Also fix a bug where creatures with INHABIT_ROOT would get stuck in evade under certain conditions. This allows us to fix quest 12261 (No Place to Run). Closes #16291. (cherry picked from commit e69a483aa942c1c6c4bd9b5fa47139f89643b8d5) Derp. Build fix. (cherry picked from commit 9180bcd404ff0a89144bbe834a2efe189bd0eb86)
2017-02-26DB/Quest: Fix vehicle SAI for quests 12910 and 12855 (Sniffing out the ↵treeston
Perpetrator H/A). Tagging issue #17914. (cherry picked from commit 3219346888ba3beb43424c60764849ec0ea030c5)
2017-02-26Core/Scripts: Implement Flag of Ownership. Closes #12265ariel-
Core/Spells: Implemented TARGET_CORPSE_SRC_AREA_ENEMY. Closes #12803 (cherry picked from commit bc4b4f656cda98be06c03301f22750804fea8fa0)
2017-02-26DB/Instance: Black TempleKittnz
- Add missing aura's and Ashtongue Stalker's spawns. - Add paths for Illidari Nightlord's and formations (cherry picked from commit 0bb9da30d50b0a69bddded8f77b4e3efe89d78ad)
2017-02-25DB/Hotfixes: Added newer tact key for 7.1.5vincent-michael
2017-02-25DB/Quests: Updated quest_template data for 7.1.5 part 6vincent-michael
2017-02-20DB/Quests: Updated quest_template data for 7.1.5 part 5vincent-michael
2017-02-19DB/Areatrigger: Updated areatrigger_template data for 7.1.0vincent-michael
2017-02-19Merge branch '3.3.5-goshdangitsmartai' into 3.3.5 (PR #17738)treeston
(cherry picked from commit e9eacae7b2ca3c8899a6ee9c8b8146e21fca54db) Core/SmartScripts: Add missing break, 5f43e7b follow-up. (cherry picked from commit a4623efaa67be1cfea19e561be83f118a784b9d1)
2017-02-19[Core/Maps] Activate creatures and objects during opening cinematics and ↵r00ty-tc
other flyby cameras (sunwell etc). Requires re-running map extractor to extract camera m2 files from data files. These are very small.
2017-02-19Core/Creatures: Implemented all creature equipment modifiersShauren
* It is now possible to give creatures a mythic/heroic weapon Closes #19160
2017-02-19DB/Quests: Updated quest_template data for 7.1.5 part 4vincent-michael
2017-02-19DB/Areatrigger: Fix typo in 21006f82efc25f3597d992d38b56bb292f22f334vincent-michael
2017-02-19DB/Areatrigger: Updated areatrigger_template data for 7.0.3vincent-michael
2017-02-18DB: Add missing racial mounts to faction changeariel-
(cherry picked from commit 54c6fdba3f37e5a255f7c946d6a5f770a481c8fa)
2017-02-18DB/Creature: Hardened Steel Skycallerariel-
Fix correct spell, was 52775 Summon Escort (cherry picked from commit c4cb2d4e35aacd82470d0ca34e7ac079aa7c8da4)
2017-02-18DB/Creature: Make Coldarra Spellweavers cast Arcane Missiles (channel) ↵treeston
instead of Arcane Missile (triggered spell). (cherry picked from commit 69d871fc53f818aba5a2b9c7484833cfa5fa7d88)
2017-02-18DB/Creature: More fixes for that poor Cabal Abjurist! Plus bonus content for ↵treeston
Bleeding Hollow Darkcaster. I feel like a DB dev now. (cherry picked from commit f5cbc17387dcd8ac5d05436d3382053e8a0ab55f)
2017-02-18DB/Creature: Fix Cabal Abjurist SAItreeston
(cherry picked from commit 5f43e7b964d48d57ec7fabdbf36a832aee53dca4)
2017-02-18DB/Creature: Fix random inhabittype that was making an Outland world elite ↵treeston
permanently rooted. (cherry picked from commit b7112d0fbe457043418415f45f68f159896477d4)
2017-02-18Core/Scripts/DB: remove hardcoded text from npc_beaten_corpse (#16907)Trond B Krokli
- remove hardcoded text from script npc_beaten_corpse - remove OnGossipHello() hook, gossip text moved to DB - use sGossipSelect() hook instead of OnGossipSelect() - add npc_text 3557 and 3558 as text_id to gossip_menu - add gossip_menu_option 2871 to NPC 10668 Beaten Corpse - add condition for gossip_menu_option 2871 in Quest ID 4921 Tested on 4 different characters/classes, male & female. Thanks to joschiwald for the sGossipSelect() script change. (cherry picked from commit d82534a7bbd401f4b672786749f10f5a95f6e76c)
2017-02-18DB/SAI: Ahab WheathoofDr-J
* NPC should turn towards invoker and stay facing for a short duration before turning back towards pillar when says line asking about his dog. * Npc should only have fork equipped when he turns towards player at all other times has hammer equipped * Added script for when periodically hammers the notice pillar (cherry picked from commit 2b992d4cb0c1764c3b3e0f4d314b338fe74a96f6)
2017-02-18DB/Quest: The Journey Has Just BegunDr-J
http://www.wowhead.com/quest=7493/the-journey-has-just-begun should become available when either level 60 or 80 version of Onyxias head quest is turned not only the level 60 version (cherry picked from commit 01e5a5b4e799dc5448dd25ea663288bb3caf8593)
2017-02-18DB/Loot: Summoned ZombieDr-J
Remove all loot from summoned zombie http://www.wowhead.com/npc=10698/summoned-zombie as these npcs where rather generous on TC as they are meant to drop no loot. (cherry picked from commit 0a4b4dec0994d80a2409923511771bd662ea8dfb)
2017-02-18DB/SAI: remove wrong dynamicflag from creature Proto-Drake EggSnapperRy
Made the tooltip appear as if a Hunter used Beast Lore on them (cherry picked from commit 59f340b751ba1cc8bd58329db0b16d56933f64f9)
2017-02-18Core/Scripts Boss Skadi the Ruthless reworkGustavo
(cherry picked from commit 40114cacd37675a9cbe7d2eef15445340d87e814) Rename 2016_99_99_00_world.sql to 2016_08_25_06_world.sql (cherry picked from commit 738e3cf0020c16d85e7fdeca55128e71ba3d2aed) travis is lazy (cherry picked from commit 92876278fe163ffd8ecf9561f5b0044225559c48)
2017-02-18Core/Scripts: move npc_experience hardcoded text to DBtkrokli
(cherry picked from commit 8df4706992f0fa39af5892dce2c23a0dde5bd9c1) Rename 2016_08_28_17750_world.sql to 2016_08_25_05_world.sql (cherry picked from commit 9c41af16cae65c6a7cc97a22fd877993eb9dfa49)
2017-02-18DB/Spell: linked spell for Worg DisguiseSnapperRy
Allows players to remove it by right-clicking. Confirmed from sniffs. (cherry picked from commit 69bec9a02232c02fab676eae22305042c0aa9432)
2017-02-18Core/Scripts: move forge_of_souls gossip to DBtkrokli
(cherry picked from commit 537074a8092ae694cf5d797a2a8f0ffa5013d43c) Rename 2016_08_24_20_world.sql to 2016_08_25_03_world.sql (cherry picked from commit 8500d0f9e01964531f469e9bbf2f146e03915a8e)
2017-02-18DB/Gameobject: Fix respawn time of few Quest GameObjectsAokromes
Closes #17845 closes #17846 by Tauriella (cherry picked from commit ee204984c25d2a2f6d13ce38587f6ec7d48438a0)
2017-02-18Core/Scripts Implement Pit of Saron Cavern eventGustavo
(cherry picked from commit b459c6607f80701945cb822d8c7519998cad205f) Rename 2016_99_99_99_world.sql to 2016_08_25_01_world.sql (cherry picked from commit 05df3cc98813688247dc2ec0ce3899a1369ec0d5)
2017-02-18Scripts/Pet Implemented Argent Squire/Gruntling and Argent Pony BridleGustavo
(cherry picked from commit 989aaaa8b5284bc707c94c62e6c50e9df3cbfc84) Rename 2016_08_15_17779_world.sql to 2016_08_25_00_world.sql (cherry picked from commit 526dfca8643d3afb9976eb099281547003dffbb1)
2017-02-18DB/Conditions: fix target for spell Throw SnowballSnapperRy
Cannot be used to kill friendly targets anymore. (cherry picked from commit 17e267ed8b70390916f6f2e246499dbfb827466d) Forgot this (cherry picked from commit 0be073dacff97bc5ae5215368e28356a03b7767d)
2017-02-18Merge remote-tracking branch 'Treeston/3.3.5-kelthuzad' into 3.3.5 (PR #16634)treeston
(cherry picked from commit 47a9cb1e562b1132df2b7b14e01d9e4f01e85717) ...Huh. Wonder how this one didn't make travis complain on the PR. (cherry picked from commit 93a68d58814013a1c656bf17afcc94938457adfd) Was Travis completely napping on this one? (cherry picked from commit 2d7dec0d39765dbaad3d3f4c9e203070bcd772d5)