aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
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
2020-06-23Core/Misc: Replace Trinity::make_unique with std (#24869)Peter Keresztes Schmidt
2020-06-22DB/Account: update account_access table (#24788)ForesterDev
* DB/Account: update account_access table: - rename fields id -> AccountID, gmlevel -> SecurityLevel - add Comment field - rename command .acc set gmlevel to .acc set seclevel * Update auth database * Fix primary key * Temporary restore old command account set gmlevel with same handler as account set seclevel Use Optional for realmID - if not set, use -1 (for all realms) * Rename 2020_XX_XX_00_auth.sql to 2020_06_20_00_auth.sql * Update auth_database.sql * Rename 2020_XX_XX_00_world.sql to 2020_06_20_06_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 8e0365d8a6ca5628ad17e6684743d9ab2138c068)
2020-06-13Core/Items: Implemented corruption and corruption resistance statsShauren
2020-06-12Core/Spells: Implement using different difficulty data from all spell ↵Shauren
related db2s, not just SpellEffect and SpellPower
2020-06-06Core/DataStores: Allow custom hotfixes (VerifiedBuild <= 0, has loading ↵Shauren
priority) to coexist with sniffed data (VerifiedBuild > 0)
2020-06-04Core/Misc: Ensure that query used for .reload creature_template command ↵Shauren
always matches the one used for loading during startup
2020-05-21Core/Misc: GCC build and warning fixesShauren
2020-05-02Core/Creatures: Fixed level 240 guards and updated scaling level calculationShauren
2020-04-27Core/Instance: stop updating the instance resettimes based on creature respawnsariel-
- Rather update normal instance reset time to 2 hours after last creature kill - This fixes yet another integer overflow due to the possibility of having time_t max showing up - Also change respawntime and resettime fields to bigint on respawn/instance related tables - Start using prepared statements on the InstanceSaveMgr (cherry picked from commit 4c593f12caa162c1bfb831bdbed934bb39155ddb)
2020-04-27Core/Loot: implement Loot Item Storage (#19018)xinef1
* Created Item Loot Storage, no more synchronous DB selects * Fixed buyback case, where stored loot was not removed from db * Added Primary key, and changed field types to be unsigned for table item_loot_money (cherry picked from commit 9dc3de10f0044c35a95e9b72e7b874f4b5b8e867)
2020-04-25Core/DataStores: Speedup loading hotfix database and change hotfix database ↵Shauren
character set to utf8mb4
2020-04-25Core/DBLayer: Fix build using TRINITY_DEBUGShauren