aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
AgeCommit message (Collapse)Author
2022-03-11[Exploit/Dupe] Container item (#26689)robinsch
* Core/Item: Fixed possible dupe with container items containing non unique non stackable items * Fixed build * Update sql script and related base structure Co-authored-by: jackpoz <giacomopoz@gmail.com> (cherry picked from commit d1e913162e0a96918c70ba4ec3f62f4186ee4707)
2022-03-06TDB 920.22031 - 2022/03/06TDB920.22031TDB Release
2022-02-28Core/Auction House: Eliminate blocking db queries for account permissions ↵Shauren
when expiring auctions that have offline bidders (cherry picked from commit d0d0f51f325e4ae42c9bef7606fed4f4c00c98d6)
2022-01-31Core/Pets: Change PET_SAVE_NOT_IN_SLOT constant from 100 to -1 to truly ↵Shauren
avoid conflicts when growing stable size and change PET_SAVE_AS_DELETED from -1 to -2
2022-01-31Core/Pets: Save last summoned pet number in characters tableShauren
2022-01-31Core/Pets: Removed storing stable slot count in dbShauren
2022-01-15TDB 915.22012 - 2022/01/15TDB915.22012TDB Release
2022-01-09Core/Guilds: Separate guild rank id from guild rank orderShauren
Co-authored-by: aquadeus <efectokoleos13@gmail.com>
2022-01-02TDB 915.22011 - 2022/01/02TDB915.22011TDB Release
2021-12-31DB: Purge mediumint columns from character db (change to full int)Shauren
2021-12-31DB: Convert all databases to InnoDB engineShauren
2021-12-31DB: Convert databases to utf8mb4Shauren
2021-12-23Core/Channels: Limit channel length to 31 charactersjackpoz
(cherry picked from commit 2707877cf6ab34727c348190ca15499ef0205b1c)
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