summaryrefslogtreecommitdiff
path: root/src/server/database/Database/Implementation
AgeCommit message (Collapse)Author
24 hoursrefactor(Core/Creature): port TC handling of Trainers (#23040)sogladev
Co-authored-by: Shauren <shauren.trinity@gmail.com> Co-authored-by: Ghaster <defscam@gmail.com>
2025-11-14fix(docs/license): use GPLv2 as MaNGOS-based project (#23655)Francesco Borzì
2025-09-02feat(core): implement 31-bit safe petition_id for improved database ↵Yehonal
integrity (#22774)
2025-08-22fix(Core/DB): Update connection type for character settings select (#22712)Andrew
2025-07-28refactor(World/WorldState): use prepared statements (#22582)Jelle Meeus
2025-07-27refactor(Core/Account): Move account flag logic from AccountMgr to ↵Kitzunu
WorldSession (#22558)
2025-07-24fix(Core/Account): Change account flag updates to async connection (#22547)Kitzunu
2025-07-24feat(Core/Account): Add account flags support (#22533)Kitzunu
2025-07-19fix(Core/Authserver): HandleLogonProof query as async (#22510)天鹭
Co-authored-by: Shauren <shauren.trinity@gmail.com>
2025-06-27feat(Script/Commands): allow to pass email in account create (#22310)SHIHUANG214
Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2025-02-07chore(Core/EventMgr): Align code to Code standard & improve LoadFromDB ↵Exitare
function (#21151) Co-authored-by: Jelle Meeus <sogladev@gmail.com> Co-authored-by: Ludwig <sudlud@users.noreply.github.com>
2025-01-27refactor(Core/Motd): improve and simplify (#21252)Kitzunu
2025-01-26feat(Core/Autobroacast): Add autobroadcast locale (#20946)Exitare
2024-12-22refactor(Core/Event): Load event vendors seperatly (#20906)Exitare
2024-12-15feat(Core/Motd): Allow localized motd (#20542)Exitare
* Initial commit for localized motd * Rename function that created world packages * Update to satisfy code check * Update code to accomodate localized motd * Update command to support multiple optionales & adjusted db * Code cleanup * Update sql name * Fix codestyle issues * Remove hardcoded schema * Add check for valid player in reload command * Update to better code style * Add missing include * Fix redundant code usage * Add missing include * Remove sql files and create new rev sql files * Address minor code reviews * Fix code style * Update code to address code revisions. - Remove two unused functions - Remove map - Use available function to resolve LocaleConstant * Fix code style * Add check for base motd and update locale to DEFAULT_LOCALE * Code docs * Removed some docs, readd defaultd motd formatting * Fix oversight in variable declaration * Code style fix * Update code based on code review * ready for merge * Fix set motd command due to changes to DEFAULT_LOCALE * Fix CI * Fix trailing whitespace --------- Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2024-11-30fix(Core/Database): prevent crash due to special chars in branch name (#20776)Jelle Meeus
add prepared statements to escape special characters in branch name
2024-09-22feat(Core/Items): Delete old item id from recovery item (#18332)IntelligentQuantum
2024-09-03feat(Core/Achievements): Add possibility to complete achievements and update ↵Anton Popovichenko
achievement criteria for offline players. (#19851)
2024-07-30feat(Scripts/Commands): account set email (#19481)Justin Hanley
* added worldserver command to set email address * reverted sql, added Tail args * removed pointer * Added helper text via updatescript * fix build * fix build * fixed db update * Update data/sql/updates/db_world/2024_07_26_01.sql Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update data/sql/updates/db_world/2024_07_26_01.sql Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * fixed hander * refactor with named params * refactor with named params --------- Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2024-07-02Revert "Add (core\db): Support for Homebind Orientation (#13389)" (#19257)Kitzunu
* Revert "Add (core\db): Support for Homebind Orientation (#13389)" This reverts commit 2e6f6e26da8f01cd67bbb56e0e7aa961ffd5f51f. Changes to be committed: modified: src/server/database/Database/Implementation/CharacterDatabase.cpp modified: src/server/game/DungeonFinding/LFGScripts.cpp modified: src/server/game/Entities/Player/Player.cpp modified: src/server/game/Entities/Player/Player.h modified: src/server/game/Entities/Player/PlayerStorage.cpp modified: src/server/game/Entities/Player/PlayerUpdates.cpp modified: src/server/game/Handlers/CharacterHandler.cpp modified: src/server/game/Handlers/MiscHandler.cpp modified: src/server/game/Handlers/MovementHandler.cpp modified: src/server/game/Maps/Map.cpp modified: src/server/game/Spells/Spell.cpp modified: src/server/scripts/Commands/cs_misc.cpp modified: src/server/scripts/Commands/cs_tele.cpp modified: src/server/scripts/Northrend/VaultOfArchavon/instance_vault_of_archavon.cpp Untracked files: data/sql/updates/pending_db_world/rev_1719945200692175000.sql * Revert "Add (core\db): Support for Homebind Orientation (#13389)" * whoops
2024-06-16refactor(Core/ObjectMgr): Implement display probabilities. (#19068)Benjamin Jackson
* Init. Cherry-picked from TC commits https://github.com/TrinityCore/TrinityCore/commit/9d210476e57949094fdd286001ef4900564edca5 and https://github.com/TrinityCore/TrinityCore/commit/c488fb219ab080031488593a0b86ac785a7d2cae Co-Authored-By: Traesh <9392905+traesh@users.noreply.github.com> Co-Authored-By: Shauren <shauren.trinity@gmail.com> * Add brute data. Needs validation against what existed before, i.e. Classic change prevention. * Add validation info for brute data. * Remove incomplete data queries. * Requested changes. * Whitespace. * Requested change. Table name. Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Requested change. Table name. Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Resolve the funny merge conflicts. I wonder why git blame doesn't work on a file with 20k lines in it that's odd huh champ. * Remove unused parameter. * Remove uses of unused parameter. * Use unused parameter. Hopefully? * I will cry. * Sobbing endlessly. * Remove comment. * Adjust table structure query. Remove length parameters and allow null for build value. Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Adjust column datatype and add check constraint. --------- Co-authored-by: Traesh <9392905+traesh@users.noreply.github.com> Co-authored-by: Shauren <shauren.trinity@gmail.com> Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2024-06-09chore(Command/unstuck) use command with offline players (#18913)Walter Pagani
Co-authored-by: Andrew <47818697+Nyeriah@users.noreply.github.com> Co-authored-by: Anton Popovichenko <walkline.ua@gmail.com>
2024-04-17fix(Core/Characters): Fix crash on characters deletion with COD mails. (#18754)Anton Popovichenko
fix(Core/Characters): Fix crash on characters deletion.
2024-02-20fix(Core/ItemStorage): Fix container items count on server load (#18367)Angelo Venturini
2024-01-01refactor(Core/GameObject): Move the GameObject state save handling to… ↵Andrew
(#18080) * refactor(Core/GameObject): Move the GameObject state save handling to instance level * Update GameObject.h * remove leftover * small improvements
2023-09-21fix(Core/Achivement): Implement ACHIEVEMENT_FLAG_AVERAGE (#17263)Ludwig
2023-08-12feat(Core/SmartAI): Add new event parameter, event_param6 (#16944)Gultask
* init * pt2 * this template stuff must go * also for my other event
2023-04-22fix(Core): Save bonus talent points to DB (#14099)ZhengPeiRu21
* fix(Core): Save bonus talent points to DB * fix(Core): Save bonus talent points to DB * Oxford comma in comment
2023-04-19chore(core): Cleanup code (#16012)天鹿
* Update SmartScript.cpp * Update M2Stores.cpp * Update PetHandler.cpp * Update WaypointMovementGenerator.cpp * Update WorldSession.cpp * Update spell_item.cpp * Update LoginDatabase.cpp
2023-03-04feat(Core/Character): Implement profanity_name (#15156)Kitzunu
2023-02-20refactor(Core/Motd): Move motd from conf to db (#15111)Kitzunu
2023-01-28fix(Core/Auth): Cleanup PrepareStatements (#14220)SoalHuang
Co-authored-by: soalhuang <soniceme@163.com>
2022-12-06fix(Core/Session): Fixed loading global account data and tutorials. S… ↵UltraNix
(#14038) fix(Core/Session): Fixed loading global account data and tutorials. Source: TrinityCore. Fixes #11974
2022-10-12Add (core\db): Support for Homebind Orientation (#13389)M'Dic
Add (core\db) Support for Homebind Orientation
2022-08-07fix(Core): Crashfix. (#12643)UltraNix
2022-05-27fix(Scripts/Commands): fix baninfo command issues (#11871)Axel Cocat
2022-05-24feat(Core/GameObjects): Instance gameobject save data implementation (#11113)Hanabi
* fix(Core): Save gameobject state on instances Currently, azerothcore doesn't save gameobject states on instances. Whenever there's a re-start or crash, the instance's gameobjects and their states aren't saved, producing un-wanted behaviours and blocking instances at times. Implemented CRUD for new table `instance_saved_data` that holds the states of gameobjects. - When worldserver launches and gameobjects are loaded, this will check if this object's state exists on the DB and sets the previous state. - On instance deletion (reset) these states are also removed based on the instance ID. - Whenever a gameobject state changes inside a dungeon or raid, we save on the database the set state. * Select query to synchronous and used FindMap() * loading gameobject states on create * reseting instance saved data * missing reset methods and on create state * database structure * Update src/server/game/Entities/GameObject/GameObject.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Entities/GameObject/GameObject.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Entities/GameObject/GameObject.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Entities/GameObject/GameObject.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Entities/Player/PlayerMisc.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Groups/Group.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * codestyle * table changes * table style * codestyle * table changes for columns * data sanitization * todo: - Finish loading db data into the containers - Using containers to find data - How to get data from ObjectMGR inside Gameobject? * loading on start up and db changes * Removing unused data structure * Uninitialised integer * Whitespace * clean-up and hooks to save states on memory * Codestyle MySQL deprecated backticks * i dont understand codefactor * build * Update data/sql/updates/pending_db_world/rev_1643395587559675400.sql Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Globals/ObjectMgr.h Co-authored-by: Kargatum <dowlandtop@yandex.com> * review changes * unecessary removal * pushback instead of emplace * wrong database update * Update ObjectMgr.cpp * missing check * removing entry from the PR * missing removals * last delete * build * aha! Found the culprit for the sudden assert errors * type safety, save only important gameobjects * static cast to unsigned short * Update data/sql/updates/pending_db_characters/rev_1643629468629316100.sql Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * type changes * queries fix * fix build * enabling which gameobjects to save on the database * deadmines iron clad door * Adjustment to gameobject onj create state and instances: - Gnomeregan doors and Grubbis boss state - Deadmines missing doors - Stratholme gameobjects state saved * forgot emi blastfuse change to despawn * Leaving group logic * codestyle * fixing merge issues * prevent bad behaviour * brain meltdown * Update data/sql/updates/pending_db_characters/rev_1643629468629316100.sql * Update data/sql/updates/pending_db_world/rev_1649359139539727000.sql Co-authored-by: Claudiodfc <54484196+claudiodfc@users.noreply.github.com> Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Co-authored-by: Kargatum <dowlandtop@yandex.com> Co-authored-by: Skjalf <47818697+Nyeriah@users.noreply.github.com>
2022-04-19feat(Core/Mail): Server mail (#10628)Kitzunu
2022-03-15feat(Core/Characters): Replace DELETE + INSERT with REPLACE (#10862)IntelligentQuantum
2022-03-01fix(Core/Mail): do not show expired mails in packets (#10560)UltraNix
Fixed #5920
2022-02-27fix(Core/Database): use char guid if character order is null (#10243)Axel Cocat
Co-authored-by: temperrr <temperrr@users.noreply.github.com>
2022-02-03feat(Guild/Commands): guild rename (#10323)Kitzunu
* feat(Guild/Commands): guild rename * cherry-pick commit (https://github.com/TrinityCore/TrinityCore/commit/678cade1163080263bdea9e349fbb67b7af15ea7#) * Update cs_guild.cpp
2022-02-02fix(Core/Player): Align SaveSeasonQuestStatus() with TrinityCore (#10503)Skjalf
2022-01-17refactor(Core): apply clang-tidy modernize-* (#9975)Francesco Borzì
Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2022-01-14feat(Core/Creature): Allow 3 ids per spawn point. TESTING (#10169)Malcrom
* feat(Core/Creature): Allow 3 ids per spawn point. * Move GetRandomId to a function * Update id to id1 * Fixed some errors crashing core and text * Set ids to lowercase for GetRandomId function * Update src/server/database/Database/Implementation/WorldDatabase.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Co-authored-by: acidmanifesto <joshua.lee.betts@gmail.com> Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2022-01-10feat(Core/Creature): Dual id Spawning WIP (#10115)Malcrom
* feat(Core/Creature): Multi id Spawning WIP * Update Creature.cpp * Update PR * Add Sql * Update rev_1641837958335217980.sql * Update src/server/game/Globals/ObjectMgr.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update src/server/game/Globals/ObjectMgr.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> * Update rev_1641837958335217980.sql * Update cs_npc.cpp * Create changes_1641842959398297300.md * Fixed issue added with random model PR * Update GameEventMgr.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2022-01-10BREAKING CHANGE:(DB/Creature) Remove modelId field in creature table (#10071)Malcrom
* fix(DB/Creature) Clear modelId field in creature table * Change clear column to remove column * Update src/server/game/Globals/ObjectMgr.cpp * Update ObjectMgr.cpp Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Co-authored-by: acidmanifesto <joshua.lee.betts@gmail.com>
2022-01-09feat(DB/Creature): Allow to set swim and flight speeds (#10067)Kitzunu
2022-01-06refactor(Core/Creature): Remove Inhabit Type (#9272)acidmanifesto
This is in reference to issue: https://github.com/azerothcore/azerothcore-wotlk/issues/4361 This is comprised of a cherry pick and partial tc cherry pick: https://github.com/TrinityCore/TrinityCore/commit/592516ae69d89da3bcb0ede144644a3d2e0186e0 https://github.com/TrinityCore/TrinityCore/commit/dbadb6369cf0b6d394fffaa1dedc612dfb5cbe2a https://github.com/TrinityCore/TrinityCore/commit/34cfa69efd1857540f1f44b118086bb02334c100 https://github.com/TrinityCore/TrinityCore/commit/12de860b4aefc02cc77b7487ef218fb584cdb552 https://github.com/TrinityCore/TrinityCore/commit/a22bc236ebc038c723774e5b38cd93e814ccc43d
2021-12-30feat(Core/Pets): Management refactoring (#9712)Kargatum
* feat(Core/Pets): rework managment * 1 * 2 * 3 * 4 * 5 * cs pet * check before ressurect * pet DECLINED_NAMES * display - https://github.com/azerothcore/azerothcore-wotlk/issues/9297 * ArenaSpectator * 1