aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
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)
2021-12-22Part1: Modernize codebase with Clang-Tidy range based loops (#24164)Ujp8LfXBJ6wCPR
(cherry picked from commit fb75a958f02695f166481033203869940d98b537)
2021-12-21Core/Creature: Use proper name for wander distance. (#24133)ratkosrb
* Use proper name for wander distance. * Rename db field. * Fix query. * Remove underscore from chat command. * Rename the handler too. * Update chat command description. * Fix remaining issues. * Rename 2020_99_99_99_world_335.sql to 2020_02_16_01_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 6176ce92ea01fd33b11c2e7f8e9ebb509e80c944) # Conflicts: # sql/updates/world/master/2020_02_16_01_world.sql # src/server/database/Database/Implementation/WorldDatabase.cpp # src/server/game/Entities/Creature/Creature.cpp # src/server/game/Globals/ObjectMgr.cpp # src/server/game/Globals/ObjectMgr.h # src/server/scripts/Commands/cs_npc.cpp
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)