aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
2022-10-11Core/Garrisons: Implement SMSG_GARRISON_OPEN_TALENT_NPC opcode (#28256)Aqua Deus
Co-authored-by: ModoX <moardox@gmail.com> Co-authored-by: Shauren <shauren.trinity@gmail.com>
2022-10-04Core/Commands: Restore instance management commandsShauren
2022-10-04Core/Instances: Add prepared statements for InstanceLockMgrShauren
2022-10-04Core/Scenarios: Attempt to restore scenario state from completed encounter infoShauren
2022-10-04Core/Instances: Remove old database statements (WIP)Shauren
2022-09-19Core/Misc: Changed string formatting functions to accept std::string_view as ↵Shauren
format argument instead being templated on it to slightly improve compile times and reduce executable size
2022-09-13Core/bnetserver: Implemented reconnecting with launcherloginShauren
2022-09-05Fixed MariaDB build the easy way for the client version check (#28039)daMaex
depending on https://jira.mariadb.org/browse/CONC-509 (cherry picked from commit f922a7dff644451a05a6b0088b652fbe86dafebc)
2022-09-05MariaDB support for Ubuntu 22.04 (#28031)daMaex
(cherry picked from commit bceb5b606068b8ef29a55338bcaa8fb611be4e33)
2022-07-14Core/WorldStates: Move custom worldstates to separate table and move saving ↵Shauren
worldstate values to WorldStateMgr
2022-07-03Core/Quests: Reset seasonal quests based on saved completion time and ↵Shauren
intended holiday start time
2022-06-09Core/Transmog: Implemented Transmog Illusions + Spelleffect to unlock themfluxurion
2022-06-02Core/DataStores: Updated structures to 9.2.5Shauren
2022-06-01Core/PacketIO: Updated packet structures to 9.2.5Shauren
2022-03-13Core/DB: Improve MySQL version check messages (#26866)Giacomo Pozzoni
* Core/DB: Improve MySQL version check messages * Make it more clear that any version above the required one is supported * Implement feedback (cherry picked from commit d9a0db79a8f74254afa31bbc26ab506fa00203c1)
2022-03-13Don't count character pending deletion towards character per account limit ↵Kelno
(#26837) * Don't count character pending deletion towards character per account limit * Never show more than 10 characters char enum * Use constants (cherry picked from commit e2f20aff8ab3f526f513203e08915e7291386f50)
2022-03-13Core/DB: Updated missing check (#26834)Aokromes
* Core/DB: Updated missing check TrinityCore does not support MySQL versions below 5.7, please update your MySQL server (cherry picked from commit 3c84972a36cf5f621f4b8c052d07c7ede4a78495)
2022-03-11Core/DBLayer: Add QueueSize() method (#26733)Giacomo Pozzoni
* Core/DBLayer: Add QueueSize() method Add QueueSize() method to database objects (Login, Character and World) that returns how many tasks are queued. Include the queue size of the 3 databases in ".server debug" command * Make the code less threadsafe * Send data to InfluxDB * Update grafana dashboard (cherry picked from commit 96dc110f4a353871ac74c82ff4b1bcc4c34156f3)
2022-03-11[Exploit/Dupe] Container item (#26689)robinsch
* Core/Item: Fixed possible dupe with container items containing non unique non stackable items * Fixed build * Update sql script and related base structure Co-authored-by: jackpoz <giacomopoz@gmail.com> (cherry picked from commit d1e913162e0a96918c70ba4ec3f62f4186ee4707)
2022-03-09Core/DBLayer: escape MySQL keywords in page_text, page_text_locale, ↵Ovahlord
broadcast_text and broadcast_text_locale select queries (cherry picked from commit d4f71131f032ecc68545acd838de5a3ccfadc331) (cherry picked from commit edcaac6c959e944dc6d6dc224666b832521412b4)
2022-03-06Core/Creature: Add new db field InteractionPauseTimer (#25880)Giacomo Pozzoni
* Core/Creature: Add new db field InteractionPauseTimer Add new db field InteractionPauseTimer to allow to define different interaction pause timers for each creature (the previous system was a global setting in worldserver.conf Creature.MovingStopTimeForPlayer) * Set all columns in creature_template_movement as optional (can be NULL, default NULL). Fill only the columns that should override the default C++ value * Use the InteractionPauseTimer value throughout the code instead of Creature.MovingStopTimeForPlayer * Handle InteractionPauseTimer set to 0 as "don't stop at all" * Implement InteractionPauseTimer in creature_movement_override creature_movement_override allows NULL values, in which case the values from creature_template_movement will be used for those columns that are NULL, falling back to default C++ values if creature_template_movement has NULL values too (or no rows for the creature) * Read default InteractionPauseTimer from worldserver.conf * Rename 2021_99_99_99_world.sql to 2021_01_22_00_world.sql (cherry picked from commit a22bc236ebc038c723774e5b38cd93e814ccc43d)
2022-03-05Core: whitespace cleanup, reduce double blank line to single (#25795)Kargatum
* Core/Misc: fix double empty line * worldserver.conf (cherry picked from commit a32b6b8ac4c81128a56b282f20837fb085bdd9e7)
2022-02-28Core/DBLayer: Fixed memory leaks with existing SQLQueryHolder uses and ↵Shauren
eliminated the possibilty of adding more in future (replaced manual memory management with smart pointers) (cherry picked from commit 53482f729995889936ad8fba9fc5789d9cdba85a)
2022-02-28Core/Mail: Replaced blocking db query in mail sending with async versionShauren
(cherry picked from commit 0a9e239c12ceb1d4a5ef5cdc796320a403b3da2b)
2022-02-28Core/Auction House: Eliminate blocking db queries for account permissions ↵Shauren
when expiring auctions that have offline bidders (cherry picked from commit d0d0f51f325e4ae42c9bef7606fed4f4c00c98d6)
2022-02-271eca51b follow-up, nuke `command`.`permission` from orbit; it was only ↵Treeston
duplicating data already stored in the core. (cherry picked from commit 991dc8e050777b5e33ff22b008ab2125bae22437)
2022-02-27Core/SAI: Add orientation and delay columns to waypoints table (#25472)Giacomo Pozzoni
* Core/SAI: Add orientation and delay columns to waypoints table * Rename 2020_99_99_99_world.sql to 2020_09_19_00_world.sql (cherry picked from commit 4b7d19c91bde2cabb8498809dee935c7efb2660a)
2022-02-25Core/DataStores: Updated db2 structures to 9.2.0Shauren
2022-02-13Core/Misc: Cleanup unused includesShauren
2022-02-11Core/Misc: database PCH tuningShauren
2022-02-11Core/Misc: Explicitly include required headers instead of relying on them to ↵Shauren
be included by other headers
2022-02-06Core/BattlePets: Delete declined names of non-account battle pets when ↵Meji
deleting character permanently (#27706)
2022-02-06Core/Characters: Replace 2 database statements with 1jackpoz
Replace DELETE + INSERT with REPLACE when updating realmcharacters table (cherry picked from commit a33ff74d92bde847b051da9fe483676fa1228c5b)
2022-02-05Scripts/Commands: .character command conversionTreeston
(cherry picked from commit 00dd337b5d2c91907424828d7eebe3191931b036)
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-02-05Core/Arena: Fix Arena.ArenaStartPersonalRating setting not having effect if ↵jackpoz
the player didn't do any arena match before next server restart Ref #16609 (cherry picked from commit cc64762f068749bbee0ef96580614f5a8cdfc867)
2022-02-04Core/Common: Tokenizer -> Trinity::Tokenize (PR: #25327)Treeston
(cherry picked from commit 534a2388b7c662c8796aabb1ec8cb424879799b6)
2022-02-02Core/Pets: Updated pet summoning for latest client version (5 Call Pet ↵Shauren
spells and stable size 200)
2022-01-31Core/Pets: Adjust pet slot saving logic after constant changes in ↵Shauren
22e823b5f9693e461ee158913c1caf3484eeb039
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-31Core/Pets: Pet management refactoring (#25191)Shauren
* Core/Pets: Pet management refactoring * Preload basic pet data on character login with async query * Load additional pet data (declined names/auras/spells/cooldowns) using async query after we are sure pet loading will succeed * Remove all select queries related to pet stable/unstable * Remove all silent pet deletions except explicit UI-triggered abandons * Fixed displaying stable master content when current pet is not summoned * Allow to stable/swap unsummoned current pet Closes #3610 Closes #21266 (cherry picked from commit 5c1fc5e3876549f5ed2b9051fffb6f3d94a67d7a)
2022-01-30Core/DBUpdater: Apply each sql update file in a separate transactionShauren
2022-01-26Core/Updater: Fix detection of the mysql binary when a directory is given as ↵Carbenium
path This ensures that we never pass a directory path StartProcess which results in a crash. Closes #25216 (cherry picked from commit 98b1b20d6beea5e2fdea7e404e8d880953d4b2fb)
2022-01-24Core/DBLayer: Add nicer api for SQLQueryHoldersShauren
(cherry picked from commit 9b806c6b5d9e83f8614523317a44742954f97744)
2022-01-24Log sync db queries in World::Update() loop (#25174)Giacomo Pozzoni
* Core/Misc: Log sync queries on critical path * Fix build * Rename * Fix warning * Fix no-pch * Change WarnAboutSyncQueries() to be header-only (cherry picked from commit deceb11b5fc52c8036f249d628ccc69ca5d022b3)
2022-01-24Core/Mail: Load mails at login instead of on demand when queried by packets ↵Shauren
(logging in always sends one of the packets that cause mail loading anyway) (cherry picked from commit 57eaab80d9e1f6f25274f376da16e1f2f67ab4bc)
2022-01-24Core/Misc: Replace database query in WorldSession::HandleAddFriendOpcode ↵Shauren
with async version (cherry picked from commit 2f0893d279ddab86ae7c3e4fd1d7a47b15e938f7)
2022-01-23Misc: Use [[fallthrough]] attribute instead of comment to mark intentional ↵Peter Keresztes Schmidt
fallthroughs (#25054) Related: #25006 (cherry picked from commit 85b5b842ca6c05d4e51081e6c3282940a80f3761)
2022-01-23Dep: Switch to boost process instead of old standalone versionShauren
(cherry picked from commit 524d16739861d0b2279e2270e319b0c77ec9b03b)