aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2020-06-22DB/Account: update account_access table (#24788)ForesterDev
* DB/Account: update account_access table: - rename fields id -> AccountID, gmlevel -> SecurityLevel - add Comment field - rename command .acc set gmlevel to .acc set seclevel * Update auth database * Fix primary key * Temporary restore old command account set gmlevel with same handler as account set seclevel Use Optional for realmID - if not set, use -1 (for all realms) * Rename 2020_XX_XX_00_auth.sql to 2020_06_20_00_auth.sql * Update auth_database.sql * Rename 2020_XX_XX_00_world.sql to 2020_06_20_06_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 8e0365d8a6ca5628ad17e6684743d9ab2138c068)
2020-06-17TDB 830.20061 - 2020/06/17TDB830.20061TDB Release
2020-06-17Core: Updated allowed build to 8.3.0.34769Shauren
2020-06-14Scripts/Command: implement .debug play music commandForesterDev
Closes #19809 (cherry picked from commit dd4ff1fe5458c89fc1d988fcc6ba5792ee482dcf)
2020-06-12Core/Spells: Implement using different difficulty data from all spell ↵Shauren
related db2s, not just SpellEffect and SpellPower
2020-06-04Core: Updated allowed build to 8.3.0.34601Shauren
2020-05-01Merge pull request #24500 from funjoker/cherry-picksShauren
2020-04-30Core: Updated allowed build to 8.3.0.34220Shauren
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-04-04Core: Updated allowed build to 8.3.0.33941Shauren
2020-03-31Core: Add mac client support for build 33775Shauren
2020-03-25Typo fix.Aokromes
closes #24352
2020-03-23Core: Updated allowed build to 8.3.0.33775Shauren
2020-03-20Core: Updated allowed build to 8.3.0.33724Shauren
2020-03-11DB/Characters: Fix encodingAokromes
2020-03-04Update characters_database.sqlAokromes
2020-03-03Core: Updated allowed build to 8.3.0.33528Shauren
2020-02-24Core: Add mac client support for build 33369Shauren
2020-02-17Core: Updated allowed build to 8.3.0.33369Shauren
2020-02-17Core/DataStores: Updated db2 structures to 8.3.0Shauren
2020-01-12Core: Add mac client support for build 32978Shauren
2020-01-11Core: Updated allowed build to 8.2.5.32978Shauren
2019-12-14Core: Add mac client support for build 32750Shauren
2019-12-10Core: Updated allowed build to 8.2.5.32750Shauren
2019-12-07Core/Realms: Move build info (and auth seeds) to databaseShauren
2019-12-05Core/Items: Implement azerite empowered itemsShauren
2019-12-04Core: Updated allowed build to 8.2.5.32722Shauren
2019-11-30Core/Spells: Fixed value of aura effects for stat mod auras applied by itemsShauren
2019-11-23Core: Updated allowed build to 8.2.5.32638Shauren
2019-11-22Core/Items: Implement azerite essencesShauren
* Implement inspecting heart of azeroth data * Fixed heart of azeroth item level - bonuses now apply
2019-11-20Core: Updated allowed build to 8.2.5.32580Shauren
2019-11-13Core: Updated allowed build to 8.2.5.32494Shauren
2019-11-12Core/Items: Implemented AzeriteItemShauren
2019-11-03Core/RaF: Remove level granting (new RaF doesn't support this)Shauren
2019-10-27Core: Updated allowed build to 8.2.5.32305Shauren
2019-10-27Core/DataStores: Updated db2 structures to 8.2.5Shauren
2019-08-18Core: Updated allowed build to 8.2.0.31478Shauren
2019-08-11Core: Updated allowed build to 8.2.0.31429Shauren
2019-07-26Core: Updated allowed build to 8.2.0.31229Shauren
2019-07-15TDB 820.19071 - 2019/07/15TDB820.19071Aokromes
2019-07-14Core: Updated allowed build to 8.2.0.30993Shauren
2019-06-25Core/Guilds: Extend motd size to 256 charactersShauren
2019-06-08Core: Updated allowed build to 8.1.5.30706Shauren
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