aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
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)
2022-01-23Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) (#24997)Giacomo Pozzoni
* Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) Original research by @xvwyh. * Add missing sql update * Fix some build errors * Remove unused enum values * Change artkits from 0-4 to 0-3 * Remove unused code * Code review feedback * Fix sql * Remove artkit4 special case handling * Default initialize artKits * Code review feedback * Split sql into structure and data files Co-authored-by: Warpten <vertozor@gmail.com> (cherry picked from commit 203573db83fb1d3f141b5aadbf1d1ca0a637bf94)
2022-01-22Core/DBLayer: Fixed false positive msvc analysis warningShauren
2022-01-14Core/DataStores: Load UnitCondition.db2Shauren
2022-01-09Core/Guilds: Separate guild rank id from guild rank orderShauren
Co-authored-by: aquadeus <efectokoleos13@gmail.com>
2022-01-06fixed indentation for cmake filesipriver
(cherry picked from commit a46d047f9466c6f16597755bb7c771a9d1a147f2)
2022-01-06DB/Account: update account_access table cherry-pick take 2 (with refactors)ForesterDev
(cherry picked from commit 8e0365d8a6ca5628ad17e6684743d9ab2138c068)
2022-01-01Core/Database: fix wrong password logging (#24487)ForesterDev
(cherry picked from commit 48c700347c91b1748427a8c5b09b8d4099c9a105)
2022-01-01Add realm ID for actions based ip logging (#24453)zartech22
* Update SQL queries to insert realm id * Insert the realm id when logging actions based on IP * Adding the SQL update file * Update 9999_99_99_99_auth.sql * Update auth structure Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e)
2022-01-01Core/DBUpdater: Fixed db auto updater for mysql 8 when ssl connections are ↵kvolk2git
enabled (#27298) (cherry picked from commit 57617e215b2f45ba1636e0002714792326c3e57c)
2022-01-01Core/DBLayer: Fix compilation with mysql 8Shauren
(cherry picked from commit 579d41acc5ca3af9900b546dc3e910a595cee066)
2022-01-01Added the ability to use TLS when connecting to a database. (#24348)myuzhobcplidtkieno
* Added the ability to use TLS when connecting to a database. * Trying to kickstart CI checks * Revert the kickstart change Co-authored-by: myuzhobcplidtkieno <myuzhobcplidtkieno@github.com> Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit ae553f89664a4baade80020856c9ff66323de963)
2021-12-31DB: Convert databases to utf8mb4Shauren
2021-12-27Core/DB: Add missing prepared statement parameters to CHAR_SEL_WAR_MODE_TUNINGShauren
2021-12-26Core/Player: Initial War Mode support (#25926)Matan Shukry
* Enable PvP talents * War Mode buff aura * Forced PvP flagging Co-authored-by: Shauren <shauren.trinity@gmail.com>
2021-12-22Core/Database: Fix build with Maria DB on some distros (#24248)Giacomo Pozzoni
(cherry picked from commit 0752584856b0d9c2a1a5b179cf90d3bc765fa2c1)
2021-12-22Core/DBLayer: Use std::variant's stored type instead of relying on our own ↵Shauren
separate enum for prepared statement parameters (cherry picked from commit 30482038559d65648d9bcfa29cd426a6f266eeba)
2021-12-22Core/DBLayer: Refactor PreparedStatement class to not depend on ↵Shauren
MySQLPreparedStatement (cherry picked from commit 5b0a32d164ba91207360d8b8a266b69dd0db9869)
2021-12-22Core/Misc: Fix buildjackpoz
(cherry picked from commit 9ba4694ff29a9b782625fb88a528675f2d6a115c)
2021-12-22Replace MySQL prepared statement union with std::variant (#24158)Ujp8LfXBJ6wCPR
(cherry picked from commit 3ebcb71c3dc80e0bea9a36207401a033712bda88)