aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2020-05-01Merge pull request #24500 from funjoker/cherry-picksShauren
2020-04-30Core: Updated allowed build to 8.3.0.34220Shauren
2020-04-29DB/Map: Add missing npcs and gameobjects on the old Champion's Hall & Hall ↵Kittnz
of Legends instances. Notes: this areas is not accessible for normal players. (cherry picked from commit 21b2042840e05ebeba365c54d47c07c13fde123f)
2020-04-28DB/Creature: Add some missing spawns to Naxxanar areaKillyana
(cherry picked from commit 5a3a9381e445a7d70464d1b97364778e07bbc6f2)
2020-04-28DB: Some Pathing on Coldarra areaKillyana
(cherry picked from commit 01d9df27d5661088aae88cb672a412a6d5b9ef2f)
2020-04-28DB/Creature: Caer darrow areaKillyana
Closes #19256 By Rushor, cala (cherry picked from commit 4c09b8a02f983e54bdd8049af130f7ca0bde218d)
2020-04-28DB/Gossip: Maddix and AlieshorKillyana
Updates #19432 (cherry picked from commit 2885dc92d03fd3b08ae6a33dcef99393891727b6)
2020-04-28DB/Gossip: Apprentice Shatharia and Magister QuallestisXyventh
Closes #19509 (cherry picked from commit c423b37143f09080c15682fadd88941e35895e73)
2020-04-28DB/Creature: Hargin MundarXyventh
Closes #19508 (cherry picked from commit beceb0a83fb45c9fc1d3b1f96b925afdc6ffc8f0)
2020-04-28DB/Creature: R-3D0Xyventh
Closes #19506 (cherry picked from commit caed8b43c8913122429d2d2bcbc9ddcfc3b8328a)
2020-04-28DB: RP event for Dame Auriferous, High Executor Mavren, Advisor Valwyn and ↵Xyventh
Deathstalker Maltendis Closes #19503 (cherry picked from commit 7559d837b93a2d316a80c7d05f04e1b17676f975)
2020-04-28DB/Gossip: Add Missing gossip texts for some NPCs in Sunstrider IsleXyventh
Closes #19501 (cherry picked from commit 95ef73901299555daca1d5f72b4055f947b716d3)
2020-04-27DB/Creature: Add missing Spirit HealersKillyana
All graveyards are checked (cherry picked from commit 3028be49296cd2d7efaadd7ab64e3520a934254c)
2020-04-27Rename last 2 SQL files with correct datetkrokli
(cherry picked from commit 912351febd43043798746a2f5bd46595ffea467f)
2020-04-27DB: Fix some DB errorsKillyana
(cherry picked from commit 10d7ae488e32b51b66e0ab3fb44feca68aaa7a8b)
2020-04-27DB/Creature: Add some Winterfin Tadpole missing spawnsKillyana
(cherry picked from commit 5563b14d7a780bd3cb51135d3f62f5594730215b)
2020-04-27DB/Spell: Egg of mortal essence should proc with HoTsariel-
Closes #19441 (cherry picked from commit 947a1f7be3080270b921e9bf69155bfc068ea301)
2020-04-27Core/Instance: stop updating the instance resettimes based on creature respawnsariel-
- Rather update normal instance reset time to 2 hours after last creature kill - This fixes yet another integer overflow due to the possibility of having time_t max showing up - Also change respawntime and resettime fields to bigint on respawn/instance related tables - Start using prepared statements on the InstanceSaveMgr (cherry picked from commit 4c593f12caa162c1bfb831bdbed934bb39155ddb)
2020-04-27Core/Loot: implement Loot Item Storage (#19018)xinef1
* Created Item Loot Storage, no more synchronous DB selects * Fixed buyback case, where stored loot was not removed from db * Added Primary key, and changed field types to be unsigned for table item_loot_money (cherry picked from commit 9dc3de10f0044c35a95e9b72e7b874f4b5b8e867)
2020-04-27DB/Gossip: Add broadcast gossip text for Argent Gruntling/Argent SquireKillyana
Closes #19402 (cherry picked from commit 33ce20b021a0d848a3c33058e8757bc3bddee970)
2020-04-27DB/Script: Fix Captain Dranarus sound rangeKillyana
By offl Closes #19427 (cherry picked from commit f7bb1d899da27b62a54193e158c1400ef107015a)
2020-04-27DB/Schema: add unsigned to some guid fields in charactersariel-
(cherry picked from commit 0c698b4567044f67eb52f6459308fb6edf693966)
2020-04-27DB/Misc: Fix error in my last commitDr-J
(cherry picked from commit 650a2d3d5062badb58c806901f4db6217a81e05e)
2020-04-27DB/SAI: UnderbogDr-J
* Rescript underbog lord has regrowth is not linked to hp as was previously scripted infact you don't even have to damage npc for it to use this abilitie and it should stack 10 times increasing damage by 150% not only cast once hp is below 50%, also cast knock-away on range instead of ic so it only uses this abilitie If there is a target in range rather than ic even if there is no target in range * Naturalist bite - make gossip and option available in heroic mode too not only normal mode (cherry picked from commit 7bfc62639a8d6d378900c7878a0d1763e62344ee)
2020-04-27DB/LinkedRespawn: Fixed evade issue in Ruby Sanctum mini-bossesKeader
(cherry picked from commit 43c19f17abcf58a7edf3a17e419f4991e1ad100e)
2020-04-27DB/Spell: fix some enchants proc chances and reduced effects for levels > 60ariel-
- Deathfrost: Slow effect should not work on targets 73 or higher. - Icy Weapon: proc chance reduced, made to a %-per-hit, should only proc on white hits - Unholy Weapon: proc chance increased to 3 PPM (based on comments data) - Battlemaster: should only proc on white hits - Crusader: effect reduced for players above 60 Closes #7789 (cherry picked from commit e0376d56444f3fa895d321e88b98848a9c9074c7)
2020-04-25Scripts/Antorus: implement Garothi Worldbreaker encounter for normal and ↵Ovah
heroic difficulty * added base script support for the encounter for normal and heroic difficulty * added instance script for Antorus the Burning Throne * added sniffed template data for involved gameobjects * added encounter related spawns to Antorus the Burning Throne * added instance encounter entry for Garothi Worldbreaker
2020-04-25Core/DataStores: Speedup loading hotfix database and change hotfix database ↵Shauren
character set to utf8mb4
2020-04-24Core/Items: Updated heart of azeroth level cap and knowledge starting date ↵Shauren
for 8.3
2020-04-24DB/Creature: fix regenerating health for vehicles in Wintergrasp and BGsariel-
Closes #950 (cherry picked from commit b9d456fad1e39943502218b3fe065be36810e139)
2020-04-24DB/SAI: Restore some deleted SAI scriptsKillyana
Closes #19381 By @Vyrsenth (cherry picked from commit ae624c7d8189e7964a69425a9edde05724d51f72)
2020-04-24Rename 2017_04_27_01_world.sql to 2017_03_27_01_world.sqlAokromes
(cherry picked from commit d0a1a5de0bd438e3bf491b688de203ff183931d4)
2020-04-24DB: Fix Some DB errorsKillyana
Ref #18542 (cherry picked from commit 97e54fe4582e59c268bd77020c59f467d0b20327)
2020-04-24Rename 2017_99_99_99_world_335.sql to 2017_03_27_00_world_335.sqlAokromes
(cherry picked from commit 05cbe86455e34b9c8039f692dfa43c6801e3e6de)
2020-04-24Added new creature extra flag which makes npc visible only to dead unitsxinef1
closes #19333 * Rename 9999_99_99_99_world.sql to 2017_99_99_99_world_335.sql - file affects creature removed in patch 4.0.3a * Update Creature.cpp (cherry picked from commit e72b380b9374c92e5688002bf3a15065419a2ea0)
2020-04-24DB/Quest: Challenge Overlord Mok'MorokkAokromes
By Fearless18, closes #5208 (cherry picked from commit de4043097e31d7ba968425f0a2ec55a9a1e5b117)
2020-04-24DB/Item: Improved Land MinesAokromes
By Rushor, closes #10205 (cherry picked from commit ff816f404dea49773678090f20923e25d0565ee0)
2020-04-24DB/Creature: Fix Verifonix faction and reputationAokromes
By offl, Closes #19323 (cherry picked from commit 5b3819424706ae34a787ba3e8112ff181a744011)
2020-04-24DB/Creature: Fix Guardian of Icecrown creature_text typoAokromes
By TecDian Closes #19226 (cherry picked from commit e4492dd0bdda6e9f778993c24889c8aea10f79ab)
2020-04-24Rename 2017_03_25_00_world.sql to 2017_03_25_01_world.sqlAokromes
(cherry picked from commit 9d6902331b4d70152623154964ca0308408ada72)
2020-04-24Core/Movement: 96f4c7c followupccrs
(cherry picked from commit 9be7f5f57b897888983a9ca6f441479f3571513c)
2020-04-24Core/Scripts: minor fixes in boss_the_lich_king (#19311)Gustavo
Closes #4427 Closes #7091 (cherry picked from commit 2792046dc7a229180d27dfdc4ce37ccfb84c8a27)
2020-04-24DB/Creature: Doctor RazorgrinKillyana
(cherry picked from commit 957d3cda1eca1f4cf7936f587ba2b1c11c9a99b3)
2020-04-24DB/Misc: Fix startup errors / typo fixAokromes
(cherry picked from commit 3d43a92fb3aa6de3109581b04ed3795eb14b5354)
2020-04-24Core/Quests: changed quest_template_addon.NextQuestID to unsignedariel-
- No reason to keep this anymore after 4349adf0f25210e5b26201523a09bc26b4a83394, this is a broken functionality. (cherry picked from commit dca276716fecb819fec668f59954113a77f9e393)
2020-04-24DB/Creature: Fix a type on creature text related to Lord ThorvalKillyana
Ref https://github.com/TrinityCore/TrinityCore/commit/80a0c3cfc779abab18447fbeca78dd0024294f94 (cherry picked from commit 63236f97af03b9745e1a12d1df56a0c885230caf)
2020-04-24DB/Spell: Recently Bandaged debuff shouldn't break stealthariel-
Closes #18951 By Noryad (cherry picked from commit 5f901d3d75660118f705c27c84e1ae895ad8e3e7)
2020-04-24DB/Creature: Savage Hill Brute/Mystic/ScavengerRushor
Closes #18922 (cherry picked from commit abed5e1586d01dfa75bd4102f8be3d8b645d9f9d)
2020-04-24Core/Scripts: implemented Gnomish Harm Prevention Beltariel-
Updates #18542 (cherry picked from commit 2db3e86d9bf200e5049e553160bc47b7bacac621)
2020-04-24DB/Creature: Footman Rob, Footman Chuck and Footman GeorgeRushor
Closes #18770 (cherry picked from commit 6732c1c2e1d26c52d0ab0817a7a19e013a3ea57d)