aboutsummaryrefslogtreecommitdiff
path: root/src/server/database/Database
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-11-19 21:40:49 +0100
committerShauren <shauren.trinity@gmail.com>2024-11-19 21:40:49 +0100
commit6dd5fb9d88e7a8b7da696bbe7b96947217b1ace2 (patch)
tree69930d805b8de5a6314cd0d24bfd05914bc37ab2 /src/server/database/Database
parent6d78230d6b45d370b9cf3656c84dd59963179bae (diff)
Core/Auras: Implemented mount equipment
Diffstat (limited to 'src/server/database/Database')
-rw-r--r--src/server/database/Database/Implementation/HotfixDatabase.cpp5
-rw-r--r--src/server/database/Database/Implementation/HotfixDatabase.h3
2 files changed, 8 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp
index 735d11d7574..89abafe7c36 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.cpp
+++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp
@@ -1194,6 +1194,11 @@ void HotfixDatabaseConnection::DoPrepareStatements()
"ReqMapID, PlayerConditionID, FlightCapabilityID FROM mount_capability WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
PREPARE_MAX_ID_STMT(HOTFIX_SEL_MOUNT_CAPABILITY, "SELECT MAX(ID) + 1 FROM mount_capability", CONNECTION_SYNCH);
+ // MountEquipment.db2
+ PrepareStatement(HOTFIX_SEL_MOUNT_EQUIPMENT, "SELECT ID, Item, BuffSpell, Unknown820, LearnedBySpell FROM mount_equipment"
+ " WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
+ PREPARE_MAX_ID_STMT(HOTFIX_SEL_MOUNT_EQUIPMENT, "SELECT MAX(ID) + 1 FROM mount_equipment", CONNECTION_SYNCH);
+
// MountTypeXCapability.db2
PrepareStatement(HOTFIX_SEL_MOUNT_TYPE_X_CAPABILITY, "SELECT ID, MountTypeID, MountCapabilityID, OrderIndex FROM mount_type_x_capability"
" WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h
index 41732618ffb..a77157ff1bd 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.h
+++ b/src/server/database/Database/Implementation/HotfixDatabase.h
@@ -685,6 +685,9 @@ enum HotfixDatabaseStatements : uint32
HOTFIX_SEL_MOUNT_CAPABILITY,
HOTFIX_SEL_MOUNT_CAPABILITY_MAX_ID,
+ HOTFIX_SEL_MOUNT_EQUIPMENT,
+ HOTFIX_SEL_MOUNT_EQUIPMENT_MAX_ID,
+
HOTFIX_SEL_MOUNT_TYPE_X_CAPABILITY,
HOTFIX_SEL_MOUNT_TYPE_X_CAPABILITY_MAX_ID,