aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2022-05-03Core: Updated allowed build to 9.2.0.43345Shauren
2022-04-22Core: Updated allowed build to 9.2.0.43340Shauren
2022-04-14Core: Updated allowed build to 9.2.0.43206ModoX
2022-04-08Core: Updated allowed build to 9.2.0.43114Shauren
2022-03-30Core: Updated allowed build to 9.2.0.42979ModoX
2022-03-30DB/Auth: Syntax fixfunjoker
2022-03-30Core: Add 9.2.0.42937 build key for future useShauren
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