aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2021-10-16Core/Characters: Made homebind location a WorldLocation (this implicitly ↵ModoX
adds orientation) (#27055)
2021-10-16Core/BattlePets: Store declined names (#27025)Meji
2021-10-15TDB 910.21101 - 2021/10/15TDB910.21101TDB Release
2021-10-13Core: Updated allowed build to 9.1.0.40593Shauren
2021-10-07SQL: Fix wrong delete queryShauren
2021-10-07Core: Updated allowed build to 9.1.0.40443Shauren
2021-10-06SQL: Fix 2021_10_02_00_characters.sql compatibility with mysql 5.7Shauren
2021-10-02Core/Players: Do not show zone on character list before first loginShauren
2021-10-02Core/Players: Store player creation timestamp and type (normal/npe)Shauren
2021-09-10Core: Updated allowed build to 9.1.0.40120Shauren
2021-09-02Core: Updated allowed build to 9.1.0.40000Shauren
2021-08-24Core/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 (cherry picked from commit 592516ae69d89da3bcb0ede144644a3d2e0186e0)
2021-08-19Core: Updated allowed build to 9.1.0.39804Shauren
2021-08-18TDB 910.21081 - 2021/08/18TDB910.21081TDB Release
2021-08-16SQL: Remove data that shouldnt be in initial character database structure importShauren
2021-08-11Core/Items: Implemented secondary shoulder transmog appearanceShauren
2021-08-08Core: Updated allowed build to 9.1.0.39653Shauren
2021-07-04TDB 905.21071 - 2021/07/04TDB905.21071TDB Release
2021-06-22SQL: Fix base/auth_database.sqlShauren
2021-06-16Scripts/Commands: new command '.debug instancespawn'Treeston
(cherry picked from commit 6ce078d8e885f61ebdff3eb905e4cf6a2911da90)