aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
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-18Core/Pooling: Quest pooling rewrite: (PR#23627)Treeston
- Split quest pooling from PoolMgr (into QuestPoolMgr) - Proper saving/restoring on server restart - No more hacking into sObjectMgr to insert/remove available quests (cherry picked from commit a5e73e41c0e813e674bb0a644e0052052435494e)
2021-12-17Core/Chat: Custom channel preservation rewrite. Channel data is now loaded ↵Treeston
at startup, and written to the DB periodically, instead of both things happening in real time. (cherry picked from commit fedf1f557b2aa1cbb0f4bc722b24afb59cc30855)
2021-12-16Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single ↵Treeston
`respawn` table (cherry picked from commit 374597c8e96c886f1e3647d405bf3160c8b98bf8)
2021-12-16Core/DB: Improved terrible assertion messageShauren
(cherry picked from commit eed92676858c9c10b1bd570894d562b21e72a905)
2021-12-15Scripts/Commands: .account ban no longer fails if an account containing the ↵Treeston
specified account name is already banned (f.ex. attempting to ban 'test' if 'test2' is already banned) - closes #22990 (cherry picked from commit daf423a6c3c0fdd13e421f02ccd791103f7bdd5b)
2021-12-15Scripts/Commands: update .wp commands to use orientation field from DB (PR ↵ForesterDev
#23566) Closes #23330 (cherry picked from commit e71773140c8efbea4abe612a71d4a65f041d450c)
2021-12-11Core/Instance : Fix instance resetting exploit (#23263)zartech22
* Push offline players out of instance Push offline players out of instance when reseting dungeon with a raid mode group * Add SQL request to character Add a SQL request to update the position of a player in a specified map * Teleport to graveyard instead (cherry picked from commit 678e0e606aa38e18fd361c33bc91833fdae76735)
2021-12-11Core/CreatureTemplate: Outsourced resistances and spells into creatur… ↵Giacomo Pozzoni
(#23343) * Core/CreatureTemplate: Outsourced resistances and spells into creature_template_spell and creature_template_resistance * Rename 2019_99_99_00_world.sql to 2019_06_15_01_world.sql (cherry picked from commit d5fb0a30ec62f3799416326d81d5d14992f9a6df)
2021-11-30Core/Database: Delete gameobject_addon data when deleting a GameObject from ↵jackpoz
the database Close #23076 (cherry picked from commit f88a5b12bd7511331ea27975fe26bfc98d92d20d)
2021-11-27Core/Database: Close the MySQL connection only after getting the last error codeGiacomo Pozzoni
(cherry picked from commit 3230ca74d21517204bb785e9ec799d995295ad28)
2021-11-25Core/BattlePets: Implemented BattlePetSpeciesFlags::NotAccountWide (#27303)Meji
Co-authored-by: Shauren <shauren.trinity@gmail.com>
2021-11-24Core/Misc: Fix GCC 8 warningsjackpoz
(cherry picked from commit 1d04a3b216901671eae0104547715a570b1ff3ab)
2021-11-24Core/Movement: Allow using run when moving randomly (#23081)Sorikoff
* Allow run when moving randomly (cherry picked from commit 34cfa69efd1857540f1f44b118086bb02334c100)
2021-11-24Core/Movement: Allow using walk when chasing v2 (#23073)Sorikoff
* Allow walk when chasing (cherry picked from commit dbadb6369cf0b6d394fffaa1dedc612dfb5cbe2a)
2021-11-23[3.3.5] Commands: lookup player shows which character is online (#23039)TheWinchesters
* Show 'online' for every online player in lookup player commands (cherry picked from commit a0056951f7e425341760ebf3a7770477ef7f4446)
2021-11-20Core/BattlePets: Implemented battle pet name query packet (#27294)Meji
Co-authored-by: Shauren <shauren.trinity@gmail.com>
2021-11-18Core/Spells: Fixed ErrorCube spell missilesShauren
(cherry picked from commit 3b5014fdae1b57add7fd204a9f9f10f3c2092b83)
2021-11-12Core/PacketIO: Implemented splash screen opcodesShauren
2021-11-10Core/SAI: Add a 4th target parameter to SAIjackpoz
(cherry picked from commit 7634a57f64a38e1151d648eeacae8480c83d19df)
2021-11-08Core/Misc: Re-generate HotfixDatabase.cppShauren
2021-11-08Misc: Update chr_races_locale field names toofunjoker
2021-11-07Misc: Rename db2 fields to official namefunjoker
2021-11-04Core/PacketIO: 9.1.5 updatefields and SMSG_UPDATE_OBJECT structureShauren
2021-11-01Core/DataStores: Updated db2 structures to 9.1.5Shauren
2021-11-03Core/DB: Rename SoundEntriesID to SoundKitID in BroadcastTextfunjoker
This is the correct naming
2021-11-03Core/DB: Fix AnimationData structurefunjoker
2021-11-02Core/GuildFinder: Remove as preparation for 9.1.5Shauren
2021-10-31Core/DataStores: Load CurrencyContainer, GarrMission, JournalEncounter, ↵Shauren
JournalEncounterSection, JournalInstance, JournalTier, KeystoneAffix, MapChallengeMode, MawPower and SoulbindConduitRank
2021-10-26Core/Conversations: Dropped time fields and calculate them using db2 data ↵ModoX
(#27151)
2021-10-23Core/CreatureTexts: Added new field SoundPlayType to enable usage of ↵ModoX
ObjectSounds within creature_text (#27136) * Also adjusted Vigilant Quoram texts to use ObjectSounds
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-15Core/DataStores: Fixed ItemSparse.db2 structureShauren
Closes #27065
2021-10-10Core/Spells: Implemented SpellReagentsCurrency.db2Shauren
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-26Core/Player: Skip the cinematic of the first login if the character is ↵Gooyeth
teleported before. (#21776) (cherry picked from commit 8cec3ffe43fe3dc144e1475f7bb360ac142c7e5f)
2021-09-23Core/Database: Add columns on *_banned (#21748)Gooyeth
* Add columns on ban character query * Add columns on ban account query (cherry picked from commit 768968f0c0801738d3cdee1ee664a63369b9ffe0)
2021-09-06Buildsystem: Separate strict database type checks from ↵Shauren
TRINITY_DEBUG/WITH_COREDEBUG option (cherry picked from commit ddd60a948c432aaac1d9a9ff05c9cf22ada35813)
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-11Core/Items: Implemented secondary shoulder transmog appearanceShauren
2021-08-08Core/DataStores: 9.1.0 db2 structuresShauren
2021-08-08Core/PacketIO: 9.1.0 opcodes and packet structuresShauren
2021-06-19Shared/Database: Improve dead-lock error handlingjackpoz
Improve dead-lock error handling in async transactions by retrying the transaction for up to 60 seconds instead of just 5 times (cherry picked from commit 54b0b8f5ead41f936b12e97d1b4fbacd9b89ab53)
2021-06-06Core/DataStores: Load QuestLineXQuest.db2Shauren
2021-06-06Core/DataStores: Load PvpTier.db2Shauren
2021-06-06Core/DataStores: Load ItemModifiedAppearanceExtra.db2Shauren
2021-06-06Core/Players: Add PlayerExtraFlags for tracking race change, level boost, ↵Shauren
and raf level grant usage