aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
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
2021-06-06Core/Reputation: Implemented paragon reputationShauren
2021-06-04Core/Spells: Load spell label data for future useShauren
2021-06-04Core/Reputation: Implemented "friendship reputation"Shauren
2021-06-03Core/DataStores: Load Achievement_Category.db2Shauren
2021-05-16Core/Creature: improve DB linked_respawn handling (#21172)kelno
* Fixed SetCreatureLinkedRespawn function possible erasing/replacing a GameObject link (instead of a creature one) (cherry picked from commit 70eb18d0e58ecf0cfcda4f410a183c671fbafe5c)
2021-05-11Core/Quests: Set quest accept time updatefieldShauren
2021-05-11Core/Quests: Un-deprecate QUEST_SPECIAL_FLAGS_EXPLORATION_OR_EVENTShauren
2021-04-29Core/DataStores: Load LanguageWords.db2 and Languages.db2 for future useMatan Shukry
2021-04-15Core/Creature: implement school immunity for creatures in creature_template ↵Wyreth
(#20709) (cherry picked from commit ae878e18ef121b7b1960f40f2b0f99debd2155d8)
2021-04-09Core/DataStores: Updated db2 structures to 9.0.5Shauren
2021-03-28Core/Spells: Implement SPELL_EFFECT_TELEPORT_TO_RETURN_POINT (#26217)Matan Shukry
2021-03-14Core/AdventureMap: Handle CMSG_ADVENTURE_MAP_START_QUESTShauren
2021-03-14Core/AdventureJournal: Check if player can access adventure journal with ↵Shauren
ChrClassUIDisplay.db2
2021-03-14Core/AdventureJournal: Fix broken hotfix database structure from ↵Shauren
3addbe7dd418259149c39fc3b9423f7809de696a
2021-03-14Core/AdventureJournal: Handle CMSG_ADVENTURE_JOURNAL_OPEN_QUEST and ↵Osleyder85
CMSG_ADVENTURE_JOURNAL_UPDATE_SUGGESTIONS Merges #26000
2021-02-07Core/Players: Implemented secondary stat diminishingShauren
2021-01-02Core/Instances: Use level requirements from MapDifficultyXCondition.db2 ↵Shauren
instead of access_requirement db table
2020-12-22Core/Corpses: Fixed crash during loading corpsesShauren
Closes #25748 Closes #25744
2020-12-13Core/Corpses: Fixed client crashes with player corpsesShauren
Closes #25714
2020-12-11Core/Quests: Fixed questgiver iconsShauren
Closes #25702
2020-12-08Core/DataStores: Updated db2 structures to 9.0.2Shauren
* Includes support for new character customization
2020-12-08Core/Misc: First set of required db changes for 9.0Shauren
2020-09-04Core/Misc: Port all the refactors sneaked in master to 3.3.5 include cleanup ↵Shauren
port
2020-08-22Dynamic Creature/Go spawning:r00ty-tc
- True blizzlike creature spawn/respawn behavior - new creature = new object - Toggleable spawn groups (with C++/SAI/command options to use them) - Custom feature: dynamic spawn rate scaling. Accelerates respawn rate based on players in the zone. - Backward compatibility mode (set via group and for summons) to support creatures/gos that currently don't work well with this (this should be removed once the exceptions are fixed) Fixes and closes #2858 Tags #8661 as fixable. Fixes and closes #13787 Fixes #15222. (cherry picked from commit 59db2eeea0a35028779fd76372ae06cc98c8086f)
2020-08-14Core/Misc: Replace NULL with nullptrShauren
2020-08-03Core/DB: Split `accounts`.`session_key` into `session_key_auth` (3.3.5) and ↵Treeston
`session_key_bnet` (master), so the branches will no longer break each other's realm switching. (cherry picked from commit 38de6d330711f0439d311a3c493cc82eaf9d09db)
2020-08-03Core/Authserver: Re-organize the `accounts` table (PR #25135)Treeston
- no longer use sha_pass_hash for anything else core-side (.account, SOAP, RA) - salt/verifier/session_key are now binary - old s/v/sha_pass_hash fields kept around for backwards compatibility - sha_pass_hash is still updated (for now), s/v are not - sha_pass_hash is only read if s/v have been manually changed - SRP6 b now uses the full 32 bytes of randomness (instead of randomly only using 19) (cherry picked from commit 3164b58c7d170810b69378950c0891e5f5b8678b)
2020-08-03Core/Authserver: Split SRP6 into its own file (PR #25131)Treeston
(cherry picked from commit 7f7fa8b23d71297f75ff4ca3c1d6e38333a5cc76)
2020-08-03Core/Authserver: Authserver cleanup (PR#25093)Treeston
- Fix a handful of 1/256 bugs with most significant byte zero in BigNumber - Get rid of (most of) the C-style arrays in authserver - CryptoRandom as a unified source for cryptographic randomness - Bring our other crypto APIs into 2020 - BigNumber usability improvements - Authserver is now actually readable as a result of all of the above (cherry picked from commit 210176fd915cf4ba16f428d3c1a249a71f4aa7a7)
2020-07-13Core/DataStores: Replace harcoded prepared statement offsets with named ↵Shauren
constants
2020-07-05Core/DBLayer: Optimize string based query results by eliminating unneeded ↵Shauren
buffer copies