aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2021-08-16DB/Hotfixes: Update esES hotfixesfunjoker
2021-08-16DB/Hotfixes: Update esES broadcast_text_localefunjoker
2021-08-12DB/Locales: Update deDE quest localesfunjoker
2021-08-12DB/Locales: Update deDE creature localesfunjoker
2021-08-12DB/Hotfixes: Update deDE broadcast_text_localefunjoker
2021-08-12DB/Hotfixes: Update deDE hotfixesfunjoker
2021-08-12DB/Misc: Correct some mistakesfunjoker
2021-08-12DB/Hotfixes: delete and insert is faster than updatingfunjoker
2021-08-12DB/Hotfixes: Truncate optional_data instead of updating themfunjoker
Blob update is way too slow
2021-08-12DB/Template: Update quest_poi via 39653 bruteforcefunjoker
2021-08-12DB/Template: Update quest_template via 39653 bruteforcefunjoker
2021-08-12DB/Template: Update creature_template via 39653 bruteforcefunjoker
2021-08-12DB/Hotfixes: Update broadcast_text and optional_data to 39653funjoker
2021-08-11Core/Items: Implemented secondary shoulder transmog appearanceShauren
2021-08-09DB/Scaling: Update creature_template_scaling (2)funjoker
2021-08-08DB/Scaling: Update creature_template_scalingfunjoker
2021-08-08DB/Hotfixes: Update hotfixes to 9.1.0.39653funjoker
2021-08-08DB/GameObject: Make spawned Bountiful Feast not selectableKillyana
Closes #20957 (cherry picked from commit acdf7be800ec937c2334caf629d3376037d4b863)
2021-08-08Core/GameObject: implemented gameobject_overrides table to change faction ↵ariel-
and flags values on a per-spawn basis Updates #20957 Closes #20958 (cherry picked from commit 34967e9c32b2c7e871bb93f41609a3b08ad92931)
2021-08-08DB/Gossip: Midsummer Fire Festival - Fix wrong gossip option conditionsTecDian
Closes #21495 (cherry picked from commit 8f66695ac008f1889a6f595d5b333cb61c802ad1)
2021-08-08DB/Conditions: Flaming spear could be casted only if the player is in taxiKillyana
Ref #15560 (cherry picked from commit e8094badf7fe42ba2d22198a1053585d6455cf50)
2021-08-08DB: Fix DB errors related to the respawn actionKillyana
Action 70 will be used only for gobs and requires always an action_param1=respawntime (the time which the gob will remain spawned) Action 133 will be used for Npcs and in some cases for gobs if they must remain spawned for ever (this action uses always target_type=1 and action_param1=0/1 (npc/gob) and action_param2= guid of the unit Closes #21494 (cherry picked from commit e24282d41f8dddb8de840cc82d66c44eb0c7b1c8)
2021-08-08DB/Spells: Fixed Alchemy stones procs with potions like endless mana potionKeader
(cherry picked from commit 19cb62c0bf442bd402428a8cb775225896cd5c06)
2021-08-08DB/Creature: assign SmartAI to Apothecary Keever's test subjects + typo fixKillyana
- missing row number in one of the DELETE FROM queries in commit 20a0d27b5bcbc2c3a334edef37f6a05e653ca401 Closes #21488 (cherry picked from commit 4c791ec376fdf5c7717a6249604502ec15656902)
2021-08-08DB/Creature: Deathguard Elite & Stormwind City Guard use Crossbow on ranged ↵ZenoX92
attack - also add some missing emote responses to Stormwind City Guard Closes #21470 (cherry picked from commit 20a0d27b5bcbc2c3a334edef37f6a05e653ca401)
2021-08-08DB/SpawnGroup: Reserve group IDs 52 through 56 for Culling of Stratholme rewriteTreeston
(cherry picked from commit b197529f1e89dbde283d22b0eb53cc83bd1f353a)
2021-08-08DB/Loot: Reference template 24048 & 24050 correctionsTeppic
Closes #21457 (cherry picked from commit 1cc3d33cfe7e51d66925d5df536a952165a88094)
2021-08-08DB/SAI: Fix text target related to Sasha questsKillyana
(cherry picked from commit 76b57eeba837130a44e31c9eac8225d96a7b5809)
2021-08-08DB/SAI: Fix text target related to The Amphitheater of Anguish questsKillyana
(cherry picked from commit 645627e652a63614edd9c9b6ff465ee472972631)
2021-08-08DB/SAI: Fix text target related to The Ring of Blood questsKillyana
(cherry picked from commit fdadecc806fe907d166a34b7996b849a0d4921fe)
2021-08-08DB/SAI: Fix text target related to Battle at Valhalas questsKillyana
(cherry picked from commit ec9bf9afe7d6bd732947cf207b24aef14d3b36a1)
2021-08-08DB/Loot: Reference template 24066 correctionsTeppic1
Closes #21409 (cherry picked from commit b71b3c66724e18fe8a19e01cae2582678a459dc1)
2021-08-08DB/Loot: Reference template 24068 correctionsTeppic1
Closes #21416 (cherry picked from commit d38031715d3f9494bbc07f45f768f2151c9d9cf0)
2021-08-08Core: Updated allowed build to 9.1.0.39653Shauren
2021-08-08Core/DataStores: 9.1.0 db2 structuresShauren
2021-08-08Core/PacketIO: 9.1.0 opcodes and packet structuresShauren
2021-07-04TDB 905.21071 - 2021/07/04TDB905.21071TDB Release
2021-06-22SQL: Fix base/auth_database.sqlShauren
2021-06-22Core/Scripts: implemented Fungal Decay & Tail Stingariel-
Refs #18542 (cherry picked from commit 7dc78d8e3f437ad7f3ad40bf1ef6801ac1ed5fc2)
2021-06-22DB/Creature: Fixed number of Laughing Skull summoned on Yogg SaronKeader
(cherry picked from commit 80a52b65e2f1a4a9735a22776079de035d61426f)
2021-06-22DB/SAI: Chief Plaguebringer HarrisKillyana
(cherry picked from commit 38afb55b882f51697b5475b9e3d94277bcc1e31f)
2021-06-22DB: Fix last part of DB errorsKillyana
(cherry picked from commit a974707d471f169a5e744437d5207f46858f781d)
2021-06-21DB: Fix mode DB errorsKillyana
(cherry picked from commit 671665aec638ab22e6c90237351cc784b1d4f4fb)
2021-06-21DB/SAI: Fix some DB errors related to the event "health pct" used with ↵Killyana
"invoker target" (cherry picked from commit 637dda815c39952dd7eee22577a6a22dececa95b)
2021-06-21DB/SAI: Fix some DB errors related to the event "on text over" used with ↵Killyana
"invoker target" (cherry picked from commit c5eed8a1833b3e427416524f326a08e9a646a106)
2021-06-21DB: Fix some DB errors related to wrong SAI targetKillyana
(cherry picked from commit a478d78a769294816111c15023de74e65d8d1aae)
2021-06-21DB/SAI: Update SAI that was using threat list target on aggroKillyana
target_type 2, 3, 4, 5, 6 musn't be used with the event 4 (cherry picked from commit 3135aaea9d6ef268d769e2a51d78c8d62bc692dd)
2021-06-20DB: Fixing a typo from a previous commitKillyana
Ref https://github.com/TrinityCore/TrinityCore/commit/9f59fb54fc16e06f81a1e99df4076c939bdb3339 (cherry picked from commit 826b3cf09e1638c27f6d47bef35cc041f4a17381)
2021-06-20DB/Condition: Placing Beacon TorchKillyana
Closes #21244 (cherry picked from commit f91a9f8b14e6c8276e620caa77a7e36a5af5f755)
2021-06-20DB/Quest: Rescue from Town SquareKillyana
Closes #20102 (cherry picked from commit 2f575f09746571151be0c43032be6532760ab624)