aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2021-11-10Core: Updated allowed build to 9.1.5.40966Shauren
2021-11-08Scripts/Commands: Add .debug dummy. It does nothing, which means you can ↵Treeston
make it do anything. (cherry picked from commit 97ade1321b6d18393202a1448f2b042fc1ff0546)
2021-11-06Core: Updated allowed build to 9.1.5.40944Shauren
2021-11-05Core: Updated allowed build to 9.1.5.40906Shauren
2021-11-04Core/PacketIO: 9.1.5 updatefields and SMSG_UPDATE_OBJECT structureShauren
2021-11-02Core/GuildFinder: Remove as preparation for 9.1.5Shauren
2021-10-26Fix typo in 2cf397c265380b366a5ab108963ad28cc0b7d9b7funjoker
2021-10-26Core: Updated allowed build to 9.1.0.40725Shauren
2021-10-23Core/RBAC: Simplification part 1. Nobody needs different permissions for ↵Treeston
each type of .go command. (cherry picked from commit 5843724debc3642434c055e5cf6f29a1eaf65358)
2021-10-23Scripts/Commands: New command ".go instance". Goes to an instance.Treeston
(cherry picked from commit 6a0870a9993f5a1016439644d4a9ab3fd89277e5)
2021-10-22Core/Scripts: Implement script name reloadingSeyden
* Authored by Seyden * Co-authored by Naios * We thank Shauren for your helpful feedback
2021-10-16Core/BattlePets: Misc fixes (#27057)Meji
* Rename WorldPackets::BattlePet::BattlePet::CollarID to WorldPackets::BattlePet::BattlePet::DisplayID * Use the DisplayID field to store the model of the battle pet. If the species has BattlePetSpeciesFlags::RandomDisplay, nothing is stored. Otherwise a random model is chosen from those available * Stored DisplayID in ITEM_MODIFIER_BATTLE_PET_DISPLAY_ID when caging the battle pet (previously the CreatureID was being stored) * Modified SendPlaySpellVisual function to allow sending Target and TargetPosition at the same time * Added SpellVisual when uncaging