aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
2020-03-31Core/DBLayer: Remove unused class forward declarationsjackpoz
2020-03-31Core/DBLayer: Prevent mixing databases with query holdersShauren
(cherry picked from commit 13440434c34da28a5106af8419aabc8e5783faf0) # Conflicts: # src/server/game/Server/WorldSession.cpp # src/server/game/Server/WorldSession.h
2020-03-31Core/DBLayer: Prevent committing transactions started on a different databaseShauren
(cherry picked from commit f6e2b8cdc1c8a3dd291947f67566b41dac116622) # Conflicts: # src/server/bnetserver/REST/LoginRESTService.cpp # src/server/database/Database/DatabaseWorkerPool.cpp # src/server/database/Database/DatabaseWorkerPool.h # src/server/database/Database/Implementation/HotfixDatabase.h # src/server/database/Database/MySQLConnection.h # src/server/database/Database/Transaction.cpp # src/server/database/Database/Transaction.h # src/server/game/Achievements/AchievementMgr.cpp # src/server/game/Achievements/AchievementMgr.h # src/server/game/AuctionHouse/AuctionHouseMgr.cpp # src/server/game/AuctionHouse/AuctionHouseMgr.h # src/server/game/BattlePets/BattlePetMgr.cpp # src/server/game/BattlePets/BattlePetMgr.h # src/server/game/BlackMarket/BlackMarketMgr.cpp # src/server/game/BlackMarket/BlackMarketMgr.h # src/server/game/Entities/Creature/Creature.cpp # src/server/game/Entities/Item/Item.cpp # src/server/game/Entities/Item/Item.h # src/server/game/Entities/Player/CollectionMgr.cpp # src/server/game/Entities/Player/CollectionMgr.h # src/server/game/Entities/Player/Player.cpp # src/server/game/Entities/Player/Player.h # src/server/game/Garrison/Garrison.cpp # src/server/game/Garrison/Garrison.h # src/server/game/Groups/Group.cpp # src/server/game/Guilds/Guild.cpp # src/server/game/Guilds/Guild.h # src/server/game/Guilds/GuildFinderMgr.cpp # src/server/game/Handlers/BlackMarketHandler.cpp # src/server/game/Handlers/CalendarHandler.cpp # src/server/game/Handlers/CharacterHandler.cpp # src/server/game/Handlers/MailHandler.cpp # src/server/game/Handlers/PetHandler.cpp # src/server/game/Handlers/PetitionsHandler.cpp # src/server/game/Mails/Mail.cpp # src/server/game/Pools/PoolMgr.cpp # src/server/game/Quests/QuestObjectiveCriteriaMgr.cpp # src/server/game/Quests/QuestObjectiveCriteriaMgr.h # src/server/game/Scenarios/InstanceScenario.cpp # src/server/game/Server/WorldSession.cpp # src/server/game/Server/WorldSession.h # src/server/game/Spells/SpellHistory.cpp # src/server/game/Support/SupportMgr.cpp # src/server/game/Tools/PlayerDump.cpp # src/server/scripts/Commands/cs_misc.cpp
2020-03-31Core/DBLayer: Prevent using prepared statements on wrong databaseShauren
(cherry picked from commit e8e89f58fb800014f53341f12505f60ee2b5fb6f) # Conflicts: # src/server/bnetserver/REST/LoginRESTService.cpp # src/server/bnetserver/Server/Session.cpp # src/server/database/Database/DatabaseWorkerPool.cpp # src/server/database/Database/Implementation/HotfixDatabase.h # src/server/database/Database/MySQLConnection.cpp # src/server/database/Database/MySQLConnection.h # src/server/database/Database/PreparedStatement.cpp # src/server/database/Database/PreparedStatement.h # src/server/database/Database/QueryHolder.cpp # src/server/database/Database/SQLOperation.h # src/server/database/Database/Transaction.h # src/server/game/Accounts/BattlenetAccountMgr.cpp # src/server/game/Achievements/AchievementMgr.cpp # src/server/game/AuctionHouse/AuctionHouseMgr.cpp # src/server/game/AuctionHouseBot/AuctionHouseBot.cpp # src/server/game/AuctionHouseBot/AuctionHouseBotBuyer.cpp # src/server/game/BattlePets/BattlePetMgr.cpp # src/server/game/Battlegrounds/ArenaTeam.cpp # src/server/game/BlackMarket/BlackMarketMgr.cpp # src/server/game/Chat/Channels/Channel.cpp # src/server/game/Entities/Corpse/Corpse.cpp # src/server/game/Entities/Creature/Creature.cpp # src/server/game/Entities/GameObject/GameObject.cpp # src/server/game/Entities/Item/Item.cpp # src/server/game/Entities/Pet/Pet.cpp # src/server/game/Entities/Player/CollectionMgr.cpp # src/server/game/Entities/Player/Player.cpp # src/server/game/Garrison/Garrison.cpp # src/server/game/Globals/ObjectMgr.cpp # src/server/game/Groups/Group.cpp # src/server/game/Guilds/Guild.cpp # src/server/game/Guilds/GuildFinderMgr.cpp # src/server/game/Guilds/GuildMgr.cpp # src/server/game/Handlers/AuctionHouseHandler.cpp # src/server/game/Handlers/CharacterHandler.cpp # src/server/game/Handlers/ItemHandler.cpp # src/server/game/Handlers/MailHandler.cpp # src/server/game/Handlers/MiscHandler.cpp # src/server/game/Handlers/PetitionsHandler.cpp # src/server/game/Handlers/SpellHandler.cpp # src/server/game/Handlers/TicketHandler.cpp # src/server/game/Loot/Loot.cpp # src/server/game/Mails/Mail.cpp # src/server/game/Maps/Map.cpp # src/server/game/Movement/Waypoints/WaypointManager.cpp # src/server/game/OutdoorPvP/OutdoorPvP.cpp # src/server/game/Pools/PoolMgr.cpp # src/server/game/Quests/QuestObjectiveCriteriaMgr.cpp # src/server/game/Reputation/ReputationMgr.cpp # src/server/game/Scenarios/InstanceScenario.cpp # src/server/game/Server/WorldSession.cpp # src/server/game/Server/WorldSocket.cpp # src/server/game/Spells/SpellHistory.cpp # src/server/game/Support/SupportMgr.cpp # src/server/game/Tools/PlayerDump.cpp # src/server/game/World/World.cpp # src/server/scripts/Commands/cs_account.cpp # src/server/scripts/Commands/cs_ban.cpp # src/server/scripts/Commands/cs_battlenet_account.cpp # src/server/scripts/Commands/cs_group.cpp # src/server/scripts/Commands/cs_lfg.cpp # src/server/scripts/Commands/cs_list.cpp # src/server/scripts/Commands/cs_message.cpp # src/server/scripts/Commands/cs_misc.cpp # src/server/scripts/Commands/cs_npc.cpp # src/server/scripts/Commands/cs_tele.cpp # src/server/scripts/Commands/cs_wp.cpp # src/server/shared/DataStores/DB2DatabaseLoader.cpp # src/server/shared/Realm/RealmList.cpp
2020-03-05Core/Database: Fix build with Maria DB on some distros (#24248)Giacomo Pozzoni
2020-03-02Core/DBLayer: Use std::variant's stored type instead of relying on our own ↵Shauren
separate enum for prepared statement parameters
2020-03-02Core/DBLayer: Refactor PreparedStatement class to not depend on ↵Shauren
MySQLPreparedStatement
2020-03-01Core/Misc: Fix buildjackpoz
2020-02-29Replace MySQL prepared statement union with std::variant (#24158)Ujp8LfXBJ6wCPR
2020-02-29Part1: Modernize codebase with Clang-Tidy range based loops (#24164)Ujp8LfXBJ6wCPR
2020-02-16Core/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>
2020-01-02New yearAokromes
Say bye bye to every year changing dates
2019-11-09Build fix - include went missing when resolving merge conflictsShauren
2019-11-09Build fixShauren
(cherry picked from commit 7c168fb6eb1c0fea76096e87d13194983c130a08)
2019-11-09Fix dynamic linking builds for msvcShauren
(cherry picked from commit a6635436ce7899aa7e402544ed633037013afc31)
2019-11-09Core/DBUpdater: Fixed db updater for mysql 8 on windows using named pipe ↵Shauren
connections (cherry picked from commit f689f6e9bd02cb1fa202ff4206428d677ff79295)
2019-11-09Core/DBLayer: Support using mysql 8Shauren
(cherry picked from commit c3a9d56b56b665133707f587ecb1bd1c272f6911)
2019-08-10[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
2019-08-04Core/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
2019-08-01Core/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.
2019-07-14Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single ↵Treeston
`respawn` table
2019-07-14Core/DB: Improved terrible assertion messageShauren
2019-07-12Scripts/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
2019-07-08Scripts/Commands: update .wp commands to use orientation field from DB (PR ↵ForesterDev
#23566) Closes #23330
2019-06-22Core/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
2019-06-15Core/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
2019-06-09Scirpts/Commands: Fix crash in ".reload creature_template <entry>"jackpoz
2019-04-17Core/Database: Delete gameobject_addon data when deleting a GameObject from ↵jackpoz
the database Close #23076
2019-04-12Core/Database: Close the MySQL connection only after getting the last error codeGiacomo Pozzoni
2019-04-05Core/Database: Correction for later MariaDB versionr00ty-tc
- Removed unused define CR_INVALID_CONN_HANDLE which was removed entirely in more modern MariaDB versions
2019-03-31Core/Misc: Fix GCC 8 warningsjackpoz
2019-02-15[3.3.5] Commands: lookup player shows which character is online (#23039)TheWinchesters
* Show 'online' for every online player in lookup player commands
2019-01-01Happy New Year, folks. It's 2019!Treeston
2018-12-30Core/Creatures: Port trainer changes from masterGhaster
Closes #20493
2018-11-09Core/Auras: Fixed saving auras with same spell id but different item sourceShauren
2018-09-21Core/SAI: Add a 4th target parameter to SAIjackpoz
2018-09-16Core/Guild: Implement character gender and send in packet. (#22436)Kittnz
Closes #22433 Credit xvwyh
2018-07-09Core/Players: Fixed saving quest item progressShauren
2018-06-23Typo fix contry -> country (#22075)Gooyeth
2018-06-23Common: Replace ip2nation by ip2location. (#21957)Gooyeth
Replace ip2nation by ip2location. Download: https://lite.ip2location.com/database/ip-country
2018-05-20Core/DBLayer: Escape more keywordsShauren
2018-05-20Core/DBLayer: Escape new mysql 8 keywordsShauren
2018-04-27Core/Player: Skip the cinematic of the first login if the character is ↵Gooyeth
teleported before. (#21776)
2018-04-01Core/Database: Add columns on *_banned (#21748)Gooyeth
* Add columns on ban character query * Add columns on ban account query
2018-03-14Buildsystem: Separate strict database type checks from ↵Shauren
TRINITY_DEBUG/WITH_COREDEBUG option
2018-03-08Core/Creatures: Reworked setting move types in databaseShauren
* Each move type has its own field instead of trying to combine everything in InhabitType * Allow overriding movement separately for each spawn
2018-02-24Core/DBUpdater: Code cleanupjackpoz
2018-02-24Core/DBUpdater: Fix error messagejackpoz
Fix error message when trying to populate the database showing free'd memory data instead of the sql file name
2018-02-18Core/DBUpdater: Improve message when base SQL file is missingDDuarte
(cherry picked from commit 844755aa07b4a7f9f2f0c49f351a817198c9a56a) GCC build fix (cherry picked from commit a15985edc620d2ecbd9a44f13f6fec15e13b338d)
2018-02-11Whitespace cleanup in Transaction.cppJildor
Removing white space after commit 54b0b8f5ead41f936b12e97d1b4fbacd9b89ab53