aboutsummaryrefslogtreecommitdiff
path: root/src/server/database
AgeCommit message (Collapse)Author
2024-08-18Core/Realms: Realmlist refactorsShauren
* Removed global realm variable from World and use RealmList everywhere * Match auth build key with client version * Restored allowedSecurityLevel checks for realmlist packet building * Restored updating population field, mysteriously removed 15 years ago in f20b25d1c90f608deab28c9957b3b376ab2a0d50 (cherry picked from commit c4b710446d62c95eb8124175203fa5f394912594) # Conflicts: # sql/base/auth_database.sql
2024-07-28Core/Players: updated glyph handling for CataclysmOvahlord
2024-07-27Core/Player: initial work on implementing talents for CataclysmOvahlord
- use a new structure to hold talent group data which will eventually replace the old master branch implementation - added support for unlocking dual talent specialization and switching specs - added basic support for learning and resetting talents
2024-07-18Build: Fixed CMake 3.30 FindBoost deprecation warningShauren
(cherry picked from commit ab5fab5ee9fd0dde509d19ffc26503379a02c41b)
2024-07-18Core/Logging: Minor internal refactorShauren
* Avoid formatting to output with fprintf * Use vector instead of unordered_map to store appenders in Logger (cherry picked from commit 81bec6954fa6640e2942d836a856e6bc9d421bce)
2024-07-18Build: CMake cleanupShauren
* Migrate all add_definitions to target_compile_definitions * Remove -D from preprocessor definitions added by target_compile_definitions (unneccessary, cmake strips it anyway) * Fixed NO_BUFFERPOOL not being set on g3d if jemalloc is used * Moved library/compiler specific compile flag settings spread all over various CMakeLists to their related library/compiler file * Remove ancient manual link flag settings for worldserver (cherry picked from commit 77fe2745febab9e4362b09750093d831325e6091)
2024-07-14Core/DBLayer: Add field metadata getters to query result classesShauren
(cherry picked from commit d4998bd04a27237aba635401d5aff0d7aafa12e5)
2024-07-06Core/Database: Fixed WITH_COREDEBUG + WITH_DYNAMIC_LINKING incompatibility ↵Shauren
on windows (cherry picked from commit f895d04b7d6ee054e34cb7b87cb3b3762569bedc)
2024-06-25Core/Misc: dropped several db2 storages which are empty/unused in classic ↵Ovahlord
and removed many unused opcode handlers and packet classes
2024-06-25Core/Items: dropped artifact weapon implementationOvahlord
2024-06-24Core/AreaTriggers: Check actionset flags for client areatriggers to allow ↵Meji
some areatriggers to trigger while dead (#30042) (cherry picked from commit d51d6b0abeec25a7c7fd4903ddbca0124ee8c723)
2024-06-20Core/Database: Rewrite QueryCallback with std::variantShauren
(cherry picked from commit 2b4c7dec2979b1327d6e1ea5fefdf3deb7c3bcd8)
2024-06-20Core/Database: Remove future/promise typedefs from a public header (these ↵Shauren
are internal to database project) (cherry picked from commit 7fcb126fcb7cff945936a7f5e051b07ce0de8a7f)
2024-06-20Core/Misc: Remove separate storage for custom messages in exception types ↵Antonio Martín Berti
and store it directly in base class from <stdexcept> (#30012) (cherry picked from commit 15e995b3b3cb7b96048b6b7830285c78bd901fb0)
2024-06-20Core/AreaTriggers: Implement height check for polygon db2 areatriggersShauren
(cherry picked from commit 1c3268155d0165e150d239c3a808d5a8dddeae18)
2024-06-20Core/AreaTriggers: Fix triggering of client areatriggers for some shapesMeji
(cherry picked from commit b070e63fa867f7f25e73e9ef3aafbe18902a50e9) # Conflicts: # sql/updates/auth/cata_classic/2024_05_27_00_hotfixes.sql
2024-06-18Core/DataStores: named new columns in ChrCustomizationOption which have been ↵Ovahlord
added in 11.x
2024-06-18Core/DataStores: update DB2 structures to 55141Ovahlord
2024-06-05Core/Player: dropped PvP talent implementationOvahlord
2024-06-02Core/Datastores: load new glyph and talent related db2 filesOvahlord
2024-06-01Core/Items: implement reforging itemsOvahlord
2024-05-28Core/Datastores: named unknown fields for CurrencyTypesOvahlord
2024-05-28Core/Updater: Fix gcc build (this time for older gcc versions that didn't ↵Shauren
trigger the warning fixed in previous commit) (cherry picked from commit 78aef0bd75a16953b09abe6449468de81fcc622d)
2024-05-28Core/Updater: Fix gcc warningShauren
(cherry picked from commit b288fceb792b5571eb7b79033408588fe4bede24)
2024-05-28Core/Misc: Support boost 1.85Shauren
(cherry picked from commit cfa838df5de5a36f6ecef5211e9a3ea8e3774d1b)
2024-05-28Core/Items: Implemented CreateTime item field and changed refund/soulbound ↵Shauren
trade timers to also count time offline (cherry picked from commit 69da702b930d43738bcaf49ce57b333dfc19ecfd) # Conflicts: # sql/base/characters_database.sql
2024-05-28Core/Items: Fix loading secondaryItemModifiedAppearanceSpec5 (#29917)Gosha
(cherry picked from commit 8c274a8e8d496bf2ac1beafd31e0967e6659f967)
2024-05-28Core/SAI: Added support for StringIds to creature and gameobject targets ↵Meji
(#29910) Co-authored-by: Shauren <shauren.trinity@gmail.com> (cherry picked from commit 2ce40684595a0e49a7b2355012c2806952698ce4)
2024-05-28Core/DBLayer: Support retrieving DATE/DATETIME/TIMESTAMP column values ↵Shauren
directly without casting in sql (cherry picked from commit 404bb5b3c21b445ae21fbbfcfd7f51d255e07c39)
2024-05-28Core/Creatures: Changed the spawn health field in creature table to a ↵Meji
percentage (#29801) (cherry picked from commit def601b4ff82ec8a90af60408a87cac92fdf070d)
2024-05-23Core/Datastores: updated DB2 structures to 4.4.0.54737Ovahlord
2024-03-25Core/Objects: Implemented vignettesShauren
(cherry picked from commit fccf6fb72b60b08dfbe6d5fb17fba55239944fca)
2024-03-14Core/DataStores: updated DB2 structures to 4.4.0.53750Ovahlord
2024-03-13Core/Creatures: added PetSpellDataId and Civilian fields to ↵Ovahlord
creature_template, replaced level delta fields with MinLevel and MaxLevel in creature_template_difficulty and backported creature_classlevel_stats from 4.3.4
2024-03-13Core/PacketIO: Update to 4.4.0.53627 (#29805)MaxtorCoder
* Core/PacketIO: Update to 4.4.0.53627 * Core/IO: Remove duplicate declaration of PetSpellDataID * Core/IO: Assign STATUS_UNHANDLED to some azerite packets
2024-03-12Core/Maps: dropped Garrison implementationOvahlord
2024-03-10Core/DataStores: duc-taped buildOvahlord
2024-03-01Core/Database: Silence deprecation warning on mysql_stmt_bind_paramShauren
2024-02-29Core/Creatures: implemented most movement related static flags and migrated ↵Ovahlord
existing movement data into static flags (#29541) * implemented CREATURE_STATIC_FLAG_AQUATIC - creatures cannot leave liquids * implemented CREATURE_STATIC_FLAG_AMPHIBIOUS - creatures can enter and leave liquids but remain on the ocean floor when swimming is not enabled until engaged * implemented CREATURE_STATIC_FLAG_FLOATING - creatures have their gravity on spawn / reset disabled * implemented CREATURE_STATIC_FLAG_SESSILE - creatures are rooted in place * implemented CREATURE_STATIC_FLAG_CAN_SWIM - creature can swim in liquids * implemented CREATURE_STATIC_FLAG_3_CANNOT_SWIM - Amphibious creatures cannot toggle on swimming * implemented CREATURE_STATIC_FLAG_3_CANNOT_TURN - Creatures cannot turn at all * implemented CREATURE_STATIC_FLAG_4_PREVENT_SWIM - Amphibious creatures won't toggle on swimming until their victim starts leaving the ocean floor * partially implemented CREATURE_STATIC_FLAG_3_CANNOT_PENETRATE_WATER * deprecated CREATURE_FLAG_EXTRA_NO_MOVE_FLAGS_UPDATE as this flag was a hackfix to a wrong implementation that is now gone
2024-01-30Core/Creatures: Move immunities to separate table and implemented setting ↵Shauren
immunties to dispel, spell effects, aura types, aoe and chain targeting
2024-01-16Core/Bnet: Prevent crashes cauised be invalid values in salt column in ↵Shauren
battlenet_accounts
2024-01-05Core/Waypoints: Refactor to split data into path and node related info in db ↵ModoX
(#29506)
2023-12-29Core/Database: Fixed a shutdown crash happening if worldserver did not fully ↵Shauren
start up (for example applying a db update failed)
2023-12-28Fix bfbda8dcce8d19dda0ee3d8f96d176901902e102Shauren
2023-12-27Core/Database: Replace union with std::variant in TransactionShauren
2023-12-26Core/Bnet: Implemented new SRP6 variants, and migrate old sha_pass_hash in ↵Shauren
battlenet_accounts to separate salt and verifier columns * passwords can now be case sensitive and up to 128 characters long
2023-12-21Core/Database: Fixed worldserver hanging if opening a connection to database ↵Shauren
failed
2023-12-17Core/Bnet: Rewrite LoginRESTService using boost::beast instead of gsoap as ↵Shauren
http backend and extract generic http code to be reusable elsewhere
2023-12-15Core/Database: Replace DatabaseWorker with asio io_contextShauren
2023-12-14Core/Database: Refactor MySQLConnection constructors and async thread creationShauren