aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2020-08-14TDB 837.20081 - 2020/08/14TDB837.20081TDB Release
2020-06-17TDB 830.20061 - 2020/06/17TDB830.20061TDB Release
2020-06-12Core/Spells: Implement using different difficulty data from all spell ↵Shauren
related db2s, not just SpellEffect and SpellPower
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/Schema: add unsigned to some guid fields in charactersariel-
(cherry picked from commit 0c698b4567044f67eb52f6459308fb6edf693966)
2020-04-24Core/Items: Updated heart of azeroth level cap and knowledge starting date ↵Shauren
for 8.3
2020-04-23SQL: Fixed applying 2020_04_20_00_characters.sqlShauren
2020-04-20Core/AuctionHouse: After taking a break at the start of patch 8.3 auction ↵Shauren
house is now back in business.
2020-03-11DB/Characters: Fix encodingAokromes
2020-02-17Core/DataStores: Updated db2 structures to 8.3.0Shauren
2020-02-17Core/PacketIO: Updated packets to 8.3.0Shauren
2019-12-05Core/Items: Implement azerite empowered itemsShauren
2019-11-30Core/Spells: Fixed value of aura effects for stat mod auras applied by itemsShauren
2019-11-22Core/Items: Implement azerite essencesShauren
* Implement inspecting heart of azeroth data * Fixed heart of azeroth item level - bonuses now apply
2019-11-12Core/Items: Implemented AzeriteItemShauren
2019-11-03Core/RaF: Remove level granting (new RaF doesn't support this)Shauren
2019-10-27Core/DataStores: Updated db2 structures to 8.2.5Shauren
2019-10-27Core/PacketIO: Update opcodes and packet structures to 8.2.5Shauren
2019-07-15TDB 820.19071 - 2019/07/15TDB820.19071Aokromes
2019-06-25Core/Guilds: Extend motd size to 256 charactersShauren
2019-06-08Core/Items: Drop item random property and suffix - all random stats must be ↵Shauren
given using bonus lists
2019-06-08Core/PacketIO: Rewrite updatefield handlingShauren
2018-12-09SQL: Prepare mergeShauren
2018-12-02Core/Players: Update profession rank handling with new split skill values ↵Shauren
for each expansion
2018-10-10Core/Entities: Update updatefields to 8.0.1.27980Shauren
2018-09-26Core/Players: Updated pvp talent implementation to bfaShauren
2018-07-31Core/Artifact Handle Artifact tiers + Artifact unlock (3rd relic bonus) (#21593)Traesh
2018-07-28Core/Battlegrounds: Allow full range of uint32 values in pvpstats_players ↵Palabola
table (#22187)
2018-04-28Core/Items: Add loot scaling support (#21853)Roc13x
* Implement ITEM_BONUS_SCALING_STAT_DISTRIBUTION_FIXED. * Fix auctionhouse search with scaled items. * Fix RequiredLevel enforcement for scaled items. * Fix item enchants not scaling properly with bonuses.
2018-03-04Core/Player: Implement PvP Talents (#19962)Jeremy
* SPELL_AURA_119 -> SPELL_AURA_PVP_TALENTS * Learn Honorable Medallion when pvp rules are enabled
2018-02-19TDB 735.00 - 2018/02/19TDB735.00DDuarte
2018-02-18Core/PacketIO: Updated opcodes and packet structures to 7.3.5Shauren
2018-02-18Core/Entities: Update updatefields to 7.3.5.25928Shauren
2017-10-29Core/Taxi: Apply reputation discount to all points in multi-segment pathsShauren
2017-08-20Core/Players: Several gold handling improvementsroc13x
* Update gold limit to 10 million * Updated auction house gold handling to 64-bit * Fixed some vendor checks for when BuyCount > 1 * Tweaked some checks for available gold space * Updated guild bank gold handling to 64-bit and fix withdraw limits * Enforce gold limit on guild bank * Check correct rank right when withdrawing from bank * Other small changes to update money to 64-bit Closes #19195 Closes #20152
2017-08-20Core/Quests: Implemented criteria tree quest objective typeRoger Stebler
Closes #20161
2017-06-04Core/Players: Implement basics for the honor systemGolrag
Closes #18480 Closes #19277
2017-05-24Core/Player: Implemented saving PLAYER_FLAGS_EX in databaseTisk
2017-05-14Core/Guilds: Remove old Guild.UndeletableLevel configDDuarte
Send guild achievement points in SMSG_GUILD_INVITE instead of level Remove old references to guild levels Player still have PLAYER_GUILDLEVEL field which is always 25
2017-05-08Core/Items: Set and save item context fieldShauren
2017-04-19TDB 720.00 - 2016/04/18TDB720.00DDuarte
2017-04-15Core/PacketIO: Updated server packet structures to 7.2.0Shauren
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-01-29Core/Player: Moved character_template from character to world dbjoschiwald
2017-01-22Core/Players: Fixed accidentally deleting Talentsjoschiwald
Note: If you want to delete deprecated Talents from DB, enable the CharacterDatabaseCleaner
2016-12-26Core/Items: Implemented bonus list as a possible result of RandomSuffixShauren
Ref #18423
2016-12-09Core/Items: Fixed item level increases of gems with bonuses that give them ↵Shauren
scaling stat distribution
2016-11-06Core/Instances: Implemented base scenario system and objectives in dungeonsKrudor
Closes #17905 Closes #18034
2016-10-25Core/PacketIO: Updated packets to 7.1.0.22900Shauren