aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2020-08-14TDB 837.20081 - 2020/08/14TDB837.20081TDB Release
2020-08-08Core: Add mac client support for build 35435Shauren
2020-08-06Core: Updated allowed build to 8.3.7.35435Shauren
2020-08-03Core/DB: Split `accounts`.`session_key` into `session_key_auth` (3.3.5) and ↵Treeston
`session_key_bnet` (master), so the branches will no longer break each other's realm switching. (cherry picked from commit 38de6d330711f0439d311a3c493cc82eaf9d09db)
2020-08-03Core/Authserver: Compatibility change for master branchShauren
(cherry picked from commit bfb041246f5c7c499ff365b38a281b0784f0bdb7)
2020-08-03Core/Authserver: Re-organize the `accounts` table (PR #25135)Treeston
- no longer use sha_pass_hash for anything else core-side (.account, SOAP, RA) - salt/verifier/session_key are now binary - old s/v/sha_pass_hash fields kept around for backwards compatibility - sha_pass_hash is still updated (for now), s/v are not - sha_pass_hash is only read if s/v have been manually changed - SRP6 b now uses the full 32 bytes of randomness (instead of randomly only using 19) (cherry picked from commit 3164b58c7d170810b69378950c0891e5f5b8678b)
2020-07-25Core: Add mac client support for build 35284Shauren
2020-07-24Core: Updated allowed build to 8.3.7.35284Shauren
2020-07-23Core: Updated to 8.3.7.35249Shauren
2020-07-16Combat/threat rewrite prep - merge RBAC/DB changes.treeston
(cherry picked from commit e35092c6a164e929f9684b350093b2beefee5d86)
2020-07-16Correct some missing auth DB changes from b59ca1c.treeston
(cherry picked from commit 41eddd59aa3c911ba77f9ffbb85af42a4e6c2b53)
2020-07-16Add new command 'npc showloot'. Does exactly what it says on the tin.treeston
(cherry picked from commit 6f29aac93626ce37922c3c9a85d20b2e4d9d3bbc)
2020-07-16Insert dynamic_spawning RBACs (already reserved in RBAC.h as of 55d8c2b) ↵treeston
into auth database to prevent constant base file conflicts on that branch. (cherry picked from commit 06c5d139f6ad7fedb920e0bafda88be57050a970)
2020-07-03Core: Add mac client support for build 34963Shauren
2020-07-02Core: Updated allowed build to 8.3.0.34963Shauren
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