aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2022-03-25Core: Updated allowed build to 9.2.0.42852Shauren
2022-03-22Core: Add 9.2.0.42825 build key for future useShauren
2022-03-12Scripts/Commands: Convert rbac commands to new systemCarbenium
Note: To enable rbac commands for administrators permissions 202-206 have to be linked to permission 196. Sample SQL for auth DB: INSERT INTO `rbac_linked_permissions` VALUES (196, 202), (196, 203), (196, 204), (196, 205), (196, 206); (cherry picked from commit f620befc37fd8a4aed917e1ebba6f268c44a0a99)
2022-03-12Core: Updated allowed build to 9.2.0.42698ModoX
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-11SQL: Update auth_database.sql with latest updatesjackpoz
(cherry picked from commit 13f1a9f117a1d2b16103079d07dc1bce39240312)
2022-03-08Core: Updated allowed build to 9.2.0.42614Shauren
2022-03-06TDB 920.22031 - 2022/03/06TDB920.22031TDB Release
2022-03-03Core: Updated allowed build to 9.2.0.42560Shauren
2022-03-02Core: Updated allowed build to 9.2.0.42538Shauren
2022-03-01Core: Updated allowed build to 9.2.0.42521Shauren
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-02-27Script/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> (cherry picked from commit 6215da0d640bd86a7c2bc144859c1542f09fc1a6)
2022-02-26Core: Updated allowed build to 9.2.0.42488Shauren
2022-02-25Core: Updated allowed build to 9.2.0.42423Shauren
2022-02-05Core/Authserver: Removal of sha_pass_hash, compatibility fields, and ↵Treeston
everything that uses them (PR #25156) (cherry picked from commit bcdbdd6f23ce65cc0e381e61d2840140dce79311)
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-26Core/Warden: Warden refactors (PR #25235)Treeston
(cherry picked from commit 6116e5b38522ccfb00f6c941c75482e05b4c0799)
2022-01-22Core: Updated allowed build to 9.1.5.42010Shauren
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-08Core: Updated allowed build to 9.1.5.41793ModoX
2022-01-02TDB 915.22011 - 2022/01/02TDB915.22011TDB Release
2022-01-01Add 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> (cherry picked from commit 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e)
2022-01-01Missing 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> (cherry picked from commit d962624d6107986fe7c349629878a121d27b186c)
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-31Typo fixShauren
2021-12-31DB: Convert databases to utf8mb4Shauren
2021-12-23Core/Channels: Limit channel length to 31 charactersjackpoz
(cherry picked from commit 2707877cf6ab34727c348190ca15499ef0205b1c)
2021-12-18[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 (cherry picked from commit 4211645834c467a03c60248e80818d3607be9ea7)
2021-12-16Core/DB: Add RBAC for .debug poolstatus, because I need it for the pooling ↵Treeston
branch. (cherry picked from commit a82bbeb101d64b89d9918ff5cbe4866591f1101b)
2021-12-16Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest ↵Treeston
reset. (cherry picked from commit 293ba08d21c4e9634229bb5015445ecc0cc08fef)
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: Updated allowed build to 9.1.5.41488Shauren
2021-12-16Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single ↵Treeston
`respawn` table (cherry picked from commit 374597c8e96c886f1e3647d405bf3160c8b98bf8)
2021-12-11Core/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 (cherry picked from commit 8163ea60c8d517ebe3a88f595dd8291df8338811)
2021-12-11Core/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 (cherry picked from commit ce3dcdcb1ad1887fb3a531aaea09482c12b5e4f3)
2021-12-10DB: Add new view vw_log_history to show database logs in a better wayjackpoz
(cherry picked from commit 9fc4ff9dd29968c1d64f47df4e721b468ac87362)
2021-12-08Core: Updated allowed build to 9.1.5.41359Shauren
2021-12-04Core: Updated allowed build to 9.1.5.41323Shauren
2021-12-02Core: Updated allowed build to 9.1.5.41288Shauren
2021-12-02Scripts/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) (cherry picked from commit 71d15ea25be3e86646faaa3266617a0b8177972f)
2021-11-25Core/BattlePets: Implemented BattlePetSpeciesFlags::NotAccountWide (#27303)Meji
Co-authored-by: Shauren <shauren.trinity@gmail.com>
2021-11-20Core/BattlePets: Implemented battle pet name query packet (#27294)Meji
Co-authored-by: Shauren <shauren.trinity@gmail.com>
2021-11-19Core: Updated allowed build to 9.1.5.41079Shauren
2021-11-17TDB 915.21111 - 2021/11/17TDB915.21111TDB Release
2021-11-12Core: Updated allowed build to 9.1.5.41031Shauren