aboutsummaryrefslogtreecommitdiff
path: root/src/server/database/Database
diff options
context:
space:
mode:
authorTraesh <nicolas.queniro@gmail.com>2024-10-06 14:36:32 +0200
committerShauren <shauren.trinity@gmail.com>2024-10-06 14:36:32 +0200
commitadbe74a1a466b3af257b5c04a0e6c7a6d28c51ac (patch)
tree5e52a991c91c41cbf335330fb6889e66f8d396b2 /src/server/database/Database
parent81276097648abe484d720c8ee9e3e77173825c8c (diff)
Core/DataStores: Load FlightCapability.db2
Diffstat (limited to 'src/server/database/Database')
-rw-r--r--src/server/database/Database/Implementation/HotfixDatabase.cpp8
-rw-r--r--src/server/database/Database/Implementation/HotfixDatabase.h3
2 files changed, 11 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp
index 712c1c4f08e..30febfb2746 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.cpp
+++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp
@@ -635,6 +635,14 @@ void HotfixDatabaseConnection::DoPrepareStatements()
" FROM faction_template WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
PREPARE_MAX_ID_STMT(HOTFIX_SEL_FACTION_TEMPLATE, "SELECT MAX(ID) + 1 FROM faction_template", CONNECTION_SYNCH);
+ // FlightCapability.db2
+ PrepareStatement(HOTFIX_SEL_FLIGHT_CAPABILITY, "SELECT ID, AirFriction, MaxVel, Unknown1000_2, DoubleJumpVelMod, LiftCoefficient, "
+ "GlideStartMinHeight, AddImpulseMaxSpeed, BankingRateMin, BankingRateMax, PitchingRateDownMin, PitchingRateDownMax, PitchingRateUpMin, "
+ "PitchingRateUpMax, TurnVelocityThresholdMin, TurnVelocityThresholdMax, SurfaceFriction, OverMaxDeceleration, Unknown1000_17, Unknown1000_18, "
+ "Unknown1000_19, Unknown1000_20, Unknown1000_21, LaunchSpeedCoefficient, VigorRegenMaxVelCoefficient, SpellID FROM flight_capability"
+ " WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
+ PREPARE_MAX_ID_STMT(HOTFIX_SEL_FLIGHT_CAPABILITY, "SELECT MAX(ID) + 1 FROM flight_capability", CONNECTION_SYNCH);
+
// FriendshipRepReaction.db2
PrepareStatement(HOTFIX_SEL_FRIENDSHIP_REP_REACTION, "SELECT ID, Reaction, FriendshipRepID, ReactionThreshold, OverrideColor"
" FROM friendship_rep_reaction WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH);
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h
index 7dc81074692..41732618ffb 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.h
+++ b/src/server/database/Database/Implementation/HotfixDatabase.h
@@ -364,6 +364,9 @@ enum HotfixDatabaseStatements : uint32
HOTFIX_SEL_FACTION_TEMPLATE,
HOTFIX_SEL_FACTION_TEMPLATE_MAX_ID,
+ HOTFIX_SEL_FLIGHT_CAPABILITY,
+ HOTFIX_SEL_FLIGHT_CAPABILITY_MAX_ID,
+
HOTFIX_SEL_FRIENDSHIP_REP_REACTION,
HOTFIX_SEL_FRIENDSHIP_REP_REACTION_MAX_ID,
HOTFIX_SEL_FRIENDSHIP_REP_REACTION_LOCALE,