aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
2020-10-15TDB 335.20101 - 2020/10/15TDB335.20101TDB Release
2020-09-17Script/Commands: Add ".pdump copy" command (#25455)Giacomo Pozzoni
* Script/Commands: Add ".pdump copy" command Syntax: .pdump copy $playerNameOrGUID $account [$newname] [$newguid] Copy character with name/guid $playerNameOrGUID into character list of $account with $newname, with first free or $newguid guid. * Add missing return * Restore eof check * Fix sql * Use forward declaration header Co-authored-by: Shauren <shauren.trinity@gmail.com> * Remove buffer when reading a line * Rename sql files Co-authored-by: Shauren <shauren.trinity@gmail.com>
2020-09-15TDB 335.20091 - 2020/09/15TDB335.20091TDB Release
2020-09-06Core/Authserver: Removal of sha_pass_hash, compatibility fields, and ↵Treeston
everything that uses them (PR #25156)
2020-08-22TDB 335.20082 - 2020/08/22TDB335.20082TDB Release
2020-08-15TDB 335.20081 - 2020/08/15TDB335.20081TDB Release
2020-08-11Core/Warden: Warden refactors (PR #25235)Treeston
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.
2020-08-03Core/Authserver: Compatibility change for master branchShauren
2020-08-02Core/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)
2020-07-15TDB 335.20071 - 2020/07/15TDB335.20071TDB Release
2020-06-20DB/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>
2020-06-15TDB 335.20061 - 2020/06/15TDB335.20061TDB Release
2020-05-15TDB 335.20051 - 2020/05/15TDB335.20051TDB Release
2020-04-18Add realm ID for actions based ip logging (#24453)zartech22
* Update SQL queries to insert realm id * Insert the realm id when logging actions based on IP * Adding the SQL update file * Update 9999_99_99_99_auth.sql * Update auth structure Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
2020-04-15TDB 335.20041 - 2020/04/15TDB335.20041TDB Release
2020-04-07Missing rbac permissions (#24253)Shadow
* Added missing RBAC permissions to auth database * Rename 9999_99_99_99_auth.sql to 2020_04_07_00_auth.sql * Update 2020_04_07_00_auth.sql * Update auth_database.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
2020-03-16TDB 335.20031 - 2020/03/16TDB335.20031TDB Release
2020-02-15TDB 335.20021 - 2020/02/15TDB335.20021TDB Release
2020-01-15TDB 335.20011 - 2020/01/15TDB335.20011TDB Release
2019-12-15TDB 335.19121 - 2019/12/15TDB335.19121TDB Release
2019-12-07Core/Realms: Move build info (and auth seeds) to databaseShauren
(cherry picked from commit 61f2eed3531ebfd2585ab05add31ae9e97598233)
2019-11-16TDB 335.19111 - 2019/11/16TDB335.19111TDB Release
2019-10-18TDB 335.19101 - 2019/10/18TDB335.19101TDB Release
2019-09-15TDB 335.19091 - 2019/09/15TDB335.19091TDB Release
2019-08-16TDB 335.19081 - 2019/08/16TDB335.19081TDB Release
2019-08-10[3.3.5] Core/Authserver: TOTP rewrite: (PR #23633)Treeston
- Proper management commands (.account 2fa) - Secrets can now be encrypted (set TOTPTokenSecret in .conf) - Secret now stored in binary - Argon2 and AES primitives - Base32/64 support
2019-07-17Core/DB: Add RBAC for .debug poolstatus, because I need it for the pooling ↵Treeston
branch.
2019-07-16Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest ↵Treeston
reset.
2019-07-15TDB 335.19071 - 2019/07/15TDB335.19071TDB Release
2019-06-21Core/RBAC: add permission that prevents accounts from earning all ↵Wyrserth
achievements or only realm firsts (#23459) * Core/RBAC: add permission that prevents accounts from earning all achievements or only realm firsts. * Kill evil spaces. * Rename 9999_99_99_99_auth.sql to 2019_06_21_00_auth.sql * Update auth_database.sql
2019-06-16Core/Commands: implement commands to look up a map/item/quest name for a ↵Wyrserth
given id (#23416) * Core/Commands: implement commands to look up a map/item/quest name for a given id. * Add entry to updates table. * Rename 9999_99_99_99_auth.sql to 2019_06_16_00_auth.sql * Add missed change, thanks jackpoz! * Update auth_database.sql
2019-06-15TDB 335.19061 - 2019/06/15TDB335.19061TDB Release
2019-06-06DB: Add new view vw_log_history to show database logs in a better wayjackpoz
2019-05-15TDB 335.19051 - 2019/05/15TDB335.19051TDB Release
2019-04-27Scripts/Commands: Add .debug asan commandsjackpoz
Add ".debug asan memoryleak" and ".debug asan outofbounds" commands to trigger Address Sanitizer warnings at runtime (or other dynamic analysis tools)
2019-04-15TDB 335.19041 - 2019/04/15TDB335.19041TDB Release
2019-03-19TDB 335.19031 - 2019/03/19TDB335.19031TDB Release
2018-12-30Renamed SQL with proper dateShauren
2018-12-30Core/Creatures: Port trainer changes from masterGhaster
Closes #20493
2018-09-17Scripts/Commands: Add .debug dummy. It does nothing, which means you can ↵Treeston
make it do anything.
2018-09-06Core/RBAC: Simplification part 1. Nobody needs different permissions for ↵Treeston
each type of .go command.
2018-08-30Scripts/Commands: New command ".go instance". Goes to an instance.Treeston
2018-06-23Common: Replace ip2nation by ip2location. (#21957)Gooyeth
Replace ip2nation by ip2location. Download: https://lite.ip2location.com/database/ip-country
2018-03-08Core/Creatures: Reworked setting move types in databaseShauren
* Each move type has its own field instead of trying to combine everything in InhabitType * Allow overriding movement separately for each spawn
2018-03-06Scripts/Commands: implemented command .server debugariel-
- Shows detailed information about server setup, useful when reporting a bug: * rev. hash * versions of mysql, openssl, boost, cmake * info about autoupdater * info about ports (realmlist and current) * vmap/map/mmap status and folder sizes * available DBC locales * TDB version Closes #19957
2018-02-18TDB 335.64 - 2018/02/18TDB335.64DDuarte
2018-01-24Scripts/Commands: new command '.debug instancespawn'Treeston
2018-01-09Scripts/Commands: New command: .debug threatinfoTreeston
2018-01-03DB: Made timestamp columns, those can have no date, nullable instead of ↵joschiwald
saving invalid date '0000-00-00 00:00:00' * This makes our tables mysql strict mode conform Ref #21113 (cherry picked from commit c2aead1da5b6cb9a3a69e276b3f12a2c76b9ab86)