aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2021-12-16Core/DB: Add a world state for daily quest reset time to `characters`. Not ↵Treeston
used right now, but written to allow easier transition later. (cherry picked from commit 1277c542638522b210addd22966c32db89cb29b6)
2021-12-16Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single ↵Treeston
`respawn` table (cherry picked from commit 374597c8e96c886f1e3647d405bf3160c8b98bf8)
2021-11-17TDB 915.21111 - 2021/11/17TDB915.21111TDB Release
2021-11-04Core/PacketIO: 9.1.5 updatefields and SMSG_UPDATE_OBJECT structureShauren
2021-11-02Core/GuildFinder: Remove as preparation for 9.1.5Shauren
2021-10-16Core/Characters: Made homebind location a WorldLocation (this implicitly ↵ModoX
adds orientation) (#27055)
2021-10-15TDB 910.21101 - 2021/10/15TDB910.21101TDB Release
2021-10-06SQL: Fix 2021_10_02_00_characters.sql compatibility with mysql 5.7Shauren
2021-10-02Core/Players: Do not show zone on character list before first loginShauren
2021-10-02Core/Players: Store player creation timestamp and type (normal/npe)Shauren
2021-08-18TDB 910.21081 - 2021/08/18TDB910.21081TDB Release
2021-08-11Core/Items: Implemented secondary shoulder transmog appearanceShauren
2021-07-04TDB 905.21071 - 2021/07/04TDB905.21071TDB Release
2021-05-11Core/Quests: Set quest accept time updatefieldShauren
2021-05-11Core/Quests: Un-deprecate QUEST_SPECIAL_FLAGS_EXPLORATION_OR_EVENTShauren
2021-04-06SQL: Add missing `updates` entryShauren
2021-04-05Core/Misc: Change all unix time columns in character database to bigint (signed)Shauren
2021-03-28Core/Spells: Implement SPELL_EFFECT_TELEPORT_TO_RETURN_POINT (#26217)Matan Shukry
2020-12-13Core/Corpses: Fixed client crashes with player corpsesShauren
Closes #25714
2020-12-08Core/DataStores: Updated db2 structures to 9.0.2Shauren
* Includes support for new character customization
2020-10-20TDB 837.20101 - 2020/10/20TDB837.20101TDB Release
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)