25#define PREPARE_MAX_ID_STMT(stmtBase, sql, con) \
26 static_assert((stmtBase) + HOTFIX_MAX_ID_STMT_OFFSET == stmtBase##_MAX_ID, "Invalid prepared statement index for " #stmtBase "_MAX_ID"); \
27 PrepareStatement(stmtBase##_MAX_ID, sql, con)
30#define PREPARE_LOCALE_STMT(stmtBase, sql, con) \
31 static_assert((stmtBase) + HOTFIX_LOCALE_STMT_OFFSET == stmtBase##_LOCALE, "Invalid prepared statement index for " #stmtBase "_LOCALE"); \
32 PrepareStatement(stmtBase##_LOCALE, sql, con)
40 PrepareStatement(
HOTFIX_SEL_ACHIEVEMENT,
"SELECT Description, Title, Reward, ID, InstanceID, Faction, Supercedes, Category, MinimumCriteria, "
41 "Points, Flags, UiOrder, IconFileID, RewardItemID, CriteriaTree, SharesCriteria, CovenantID, HiddenBeforeDisplaySeason, LegacyAfterTimeEvent"
55 "PlayerConditionID, Flags, ButtonActionType, TextureFileDataID, LfgDungeonID, QuestID, BattleMasterListID, PriorityMin, PriorityMax, "
56 "CurrencyType, CurrencyQuantity, UiMapID, BonusPlayerConditionID1, BonusPlayerConditionID2, BonusValue1, BonusValue2 FROM adventure_journal"
60 "ContinueDescription_lang FROM adventure_journal_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
64 "LfgDungeonID, RewardItemID, UiTextureAtlasMemberID, UiTextureKitID, MapID, AreaTableID FROM adventure_map_poi WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
85 "SoundProviderPrefUnderwater, AmbienceID, UwAmbience, ZoneMusic, UwZoneMusic, IntroSound, UwIntroSound, FactionGroupMask, AmbientMultiplier, "
86 "MountFlags, PvpCombatWorldStateID, WildBattlePetLevelMin, WildBattlePetLevelMax, WindSettingsID, ContentTuningID, Flags1, Flags2, "
87 "LiquidTypeID1, LiquidTypeID2, LiquidTypeID3, LiquidTypeID4 FROM area_table WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
92 PrepareStatement(
HOTFIX_SEL_AREA_TRIGGER,
"SELECT PosX, PosY, PosZ, ID, ContinentID, PhaseUseFlags, PhaseID, PhaseGroupID, Radius, BoxLength, "
93 "BoxWidth, BoxHeight, BoxYaw, ShapeType, ShapeID, AreaTriggerActionSetID, Flags FROM area_trigger WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
107 "ChrSpecializationID, Flags, ArtifactCategoryID, UiModelSceneID, SpellVisualKitID FROM artifact WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
113 "ItemAppearanceModifierID, UiSwatchColor, UiModelSaturation, UiModelOpacity, OverrideShapeshiftFormID, OverrideShapeshiftDisplayID, "
114 "UiItemAppearanceID, UiAltItemAppearanceID, Flags, UiCameraID, UsablePlayerConditionID FROM artifact_appearance"
122 "ForgeAttachmentOverride, Flags, ArtifactID FROM artifact_appearance_set WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
146 " FROM artifact_power_rank WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
151 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM artifact_quest_xp WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
156 "MinimumEmpowerKnowledge FROM artifact_tier WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
183 "MinorPowerDescription, MajorPowerActual, MinorPowerActual FROM azerite_essence_power WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
194 " FROM azerite_item_milestone_power WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
203 " FROM azerite_level_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
213 " FROM azerite_power_set_member WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
218 " FROM azerite_tier_unlock WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
227 "AzeriteUnlockMappingSetID FROM azerite_unlock_mapping WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
232 "PurchasePromptConfirmation, TabCleanupConfirmation, TabNameEditBoxHeader FROM bank_tab WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
248 " FROM battle_pet_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
265 "Flags, SourceTypeEnum, CardUIModelSceneID, LoadoutUIModelSceneID, CovenantID FROM battle_pet_species WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
277 "MaxLevel, RatedPlayers, MinPlayers, MaxPlayers, GroupsAllowed, MaxGroupSize, HolidayWorldState, Flags, IconFileDataID, "
278 "RequiredPlayerConditionID FROM battlemaster_list WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
281 " FROM battlemaster_list_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
290 "VoiceOverPriorityID, SoundKitID1, SoundKitID2, EmoteID1, EmoteID2, EmoteID3, EmoteDelay1, EmoteDelay2, EmoteDelay3 FROM broadcast_text"
303 "OnlyStallIf, UiQuestDetailsThemeID, Flags, DisplayPriority, SortAsNormalQuest, UseMinimalHeader FROM campaign WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
326 "RequiredTimeEventPassed, RequiredTimeEventNotPassed, SrcItemBonusTreeID FROM challenge_mode_item_bonus_override"
342 " FROM character_loadout WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
359 " FROM chr_class_ui_display WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
364 "HyphenatedNameMale, HyphenatedNameFemale, CreateScreenFileDataID, SelectScreenFileDataID, IconFileDataID, LowResScreenFileDataID, Flags, "
365 "StartingLevel, SpellTextureBlobFileDataID, ArmorTypeMask, CharStartKitUnknown901, MaleCharacterCreationVisualFallback, "
366 "MaleCharacterCreationIdleVisualFallback, FemaleCharacterCreationVisualFallback, FemaleCharacterCreationIdleVisualFallback, "
367 "CharacterCreationIdleGroundVisualFallback, CharacterCreationGroundVisualFallback, AlteredFormCharacterCreationIdleVisualFallback, "
368 "CharacterCreationAnimLoopWaitTimeMsFallback, CinematicSequenceID, DefaultSpec, ID, HasStrengthBonus, PrimaryStatPriority, DisplayPower, "
369 "RangedAttackPowerPerAgility, AttackPowerPerAgility, AttackPowerPerStrength, SpellClassSet, ClassColorR, ClassColorG, ClassColorB, RolesMask, "
370 "DamageBonusStat, HasRelicSlot FROM chr_classes WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
373 "DisabledString_lang, HyphenatedNameMale_lang, HyphenatedNameFemale_lang FROM chr_classes_locale WHERE (`VerifiedBuild` > 0) = ?"
383 "ChrCustomizationVisReqID, SortOrder, UiOrderIndex, Flags, AddedInPatch, SoundKitID, SwatchColor1, SwatchColor2 FROM chr_customization_choice"
391 "BarberShopHeightOffset, BarberShopCameraZoomOffset FROM chr_customization_display_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
396 "ChrCustomizationGeosetID, ChrCustomizationSkinnedModelID, ChrCustomizationMaterialID, ChrCustomizationBoneSetID, "
397 "ChrCustomizationCondModelID, ChrCustomizationDisplayInfoID, ChrCustItemGeoModifyID, ChrCustomizationVoiceID, AnimKitID, ParticleColorID, "
398 "ChrCustGeoComponentLinkID FROM chr_customization_element WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
403 "OptionType, BarberShopCostModifier, ChrCustomizationID, ChrCustomizationReqID, UiOrderIndex, AddedInPatch FROM chr_customization_option"
411 "OverrideArchive, ItemModifiedAppearanceID, RaceMask_1, RaceMask_2 FROM chr_customization_req WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
418 " FROM chr_customization_req_choice WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
423 "CustomizeOffset2, CustomizeOffset3, ID, Sex, DisplayID, CharComponentTextureLayoutID, Flags, SkeletonFileDataID, ModelFallbackChrModelID, "
424 "TextureFallbackChrModelID, HelmVisFallbackChrModelID, CustomizeScale, CustomizeFacing, CameraDistanceOffset, BarberShopCameraOffsetScale, "
425 "BarberShopCameraHeightOffsetScale, BarberShopCameraRotationOffset FROM chr_model WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
435 "LoreName, LoreNameFemale, LoreNameLower, LoreNameLowerFemale, LoreDescription, ShortName, ShortNameFemale, ShortNameLower, "
436 "ShortNameLowerFemale, Flags, FactionID, CinematicSequenceID, ResSicknessSpellID, SplashSoundID, CreateScreenFileDataID, "
437 "SelectScreenFileDataID, LowResScreenFileDataID, AlteredFormStartVisualKitID1, AlteredFormStartVisualKitID2, AlteredFormStartVisualKitID3, "
438 "AlteredFormFinishVisualKitID1, AlteredFormFinishVisualKitID2, AlteredFormFinishVisualKitID3, HeritageArmorAchievementID, StartingLevel, "
439 "UiDisplayOrder, PlayableRaceBit, TransmogrifyDisabledSlotMask, AlteredFormCustomizeOffsetFallback1, AlteredFormCustomizeOffsetFallback2, "
440 "AlteredFormCustomizeOffsetFallback3, AlteredFormCustomizeRotationFallback, Unknown910_11, Unknown910_12, Unknown910_13, Unknown910_21, "
441 "Unknown910_22, Unknown910_23, BaseLanguage, CreatureType, Alliance, RaceRelated, UnalteredVisualRaceID, DefaultClassID, NeutralRaceID, "
442 "MaleModelFallbackRaceID, MaleModelFallbackSex, FemaleModelFallbackRaceID, FemaleModelFallbackSex, MaleTextureFallbackRaceID, "
443 "MaleTextureFallbackSex, FemaleTextureFallbackRaceID, FemaleTextureFallbackSex, HelmetAnimScalingRaceID, UnalteredVisualCustomizationRaceID"
447 "LoreNameFemale_lang, LoreNameLower_lang, LoreNameLowerFemale_lang, LoreDescription_lang, ShortName_lang, ShortNameFemale_lang, "
448 "ShortNameLower_lang, ShortNameLowerFemale_lang FROM chr_races_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
451 PrepareStatement(
HOTFIX_SEL_CHR_SPECIALIZATION,
"SELECT Name, FemaleName, Description, ID, ClassID, OrderIndex, PetTalentType, Role, Flags, "
452 "SpellIconFileID, PrimaryStatPriority, AnimReplacements, MasterySpellID1, MasterySpellID2 FROM chr_specialization"
460 " FROM cinematic_camera WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
464 PrepareStatement(
HOTFIX_SEL_CINEMATIC_SEQUENCES,
"SELECT ID, SoundID, Camera1, Camera2, Camera3, Camera4, Camera5, Camera6, Camera7, Camera8"
465 " FROM cinematic_sequences WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
470 "ChrCustomizationCategoryID FROM conditional_chr_model WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
475 "ParentContentTuningID FROM conditional_content_tuning WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
480 "HealthPrimaryStatCurveID, DamagePrimaryStatCurveID, PrimaryStatScalingModPlayerDataElementCharacterID, "
481 "PrimaryStatScalingModPlayerDataElementCharacterMultiplier, MinLevel, MaxLevel, MinLevelType, MaxLevelType, TargetLevelDelta, "
482 "TargetLevelMaxDelta, TargetLevelMin, TargetLevelMax, MinItemLevel, QuestXpMultiplier FROM content_tuning WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
487 "ContentTuningID FROM content_tuning_x_expected WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
497 "NextConversationLineID, AnimKitID, SpeechType, StartAnimation, EndAnimation FROM conversation_line WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
512 "ExtendedDisplayInfoID, NPCSoundID, ParticleColorID, PortraitCreatureDisplayInfoID, PortraitTextureFileDataID, ObjectEffectPackageID, "
513 "AnimReplacementSetID, Flags, StateSpellVisualKitID, PlayerOverrideScale, PetInstanceScale, UnarmedWeaponType, MountPoofSpellVisualKitID, "
514 "DissolveEffectID, Gender, DissolveOutEffectID, CreatureModelMinLod, ConditionalCreatureModelID, Unknown_1100_1, Unknown_1100_2, "
515 "TextureVariationFileDataID1, TextureVariationFileDataID2, TextureVariationFileDataID3, TextureVariationFileDataID4 FROM creature_display_info"
521 "HDBakeMaterialResourcesID FROM creature_display_info_extra WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
526 "CategoryEnumID, IconFileID, SkillLine1, SkillLine2 FROM creature_family WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
535 PrepareStatement(
HOTFIX_SEL_CREATURE_MODEL_DATA,
"SELECT ID, GeoBox1, GeoBox2, GeoBox3, GeoBox4, GeoBox5, GeoBox6, Flags, FileDataID, WalkSpeed, "
536 "RunSpeed, BloodID, FootprintTextureID, FootprintTextureLength, FootprintTextureWidth, FootprintParticleScale, FoleyMaterialID, "
537 "FootstepCameraEffectID, DeathThudCameraEffectID, SoundID, SizeClass, CollisionWidth, CollisionHeight, WorldEffectScale, "
538 "CreatureGeosetDataID, HoverHeight, AttachedEffectScale, ModelScale, MissileCollisionRadius, MissileCollisionPush, MissileCollisionRaise, "
539 "MountHeight, OverrideLootEffectScale, OverrideNameScale, OverrideSelectionRadius, TamedPetBaseScale, MountScaleOtherIndex, MountScaleSelf, "
540 "Unknown1100, MountScaleOther1, MountScaleOther2 FROM creature_model_data WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
549 PrepareStatement(
HOTFIX_SEL_CRITERIA,
"SELECT ID, Type, Asset, ModifierTreeId, StartEvent, StartAsset, StartTimer, FailEvent, FailAsset, Flags, "
550 "EligibilityWorldStateID, EligibilityWorldStateValue FROM criteria WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
562 "ContainerQuality, OnLootSpellVisualKitID, CurrencyTypesID FROM currency_container WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
569 "MaxEarnablePerWeek, Quality, FactionID, ItemGroupSoundsID, XpQuestDifficulty, AwardConditionID, MaxQtyWorldStateID, "
570 "RechargingAmountPerCycle, RechargingCycleDurationMS, AccountTransferPercentage, OrderIndex, RecraftReagentCountPercentage, OrderSource, "
571 "MCRCurrencyID, Flags1, Flags2 FROM currency_types WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
587 "State1DestructionDoodadSet, State1ImpactEffectDoodadSet, State1AmbientDoodadSet, State2Wmo, State2DestructionDoodadSet, "
588 "State2ImpactEffectDoodadSet, State2AmbientDoodadSet, State3Wmo, State3InitDoodadSet, State3AmbientDoodadSet, EjectDirection, DoNotHighlight, "
589 "State0Wmo, HealEffect, HealEffectSpeed, State0NameSet, State1NameSet, State2NameSet, State3NameSet FROM destructible_model_data"
595 "Flags, ItemContext, ToggleDifficultyID, GroupSizeHealthCurveID, GroupSizeDmgCurveID, GroupSizeSpellPointsCurveID, Unknown1105 FROM difficulty"
602 "SpellIconFileID, Faction, Unknown1115 FROM dungeon_encounter WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
609 "WeaponSubClassCost5, WeaponSubClassCost6, WeaponSubClassCost7, WeaponSubClassCost8, WeaponSubClassCost9, WeaponSubClassCost10, "
610 "WeaponSubClassCost11, WeaponSubClassCost12, WeaponSubClassCost13, WeaponSubClassCost14, WeaponSubClassCost15, WeaponSubClassCost16, "
611 "WeaponSubClassCost17, WeaponSubClassCost18, WeaponSubClassCost19, WeaponSubClassCost20, WeaponSubClassCost21, ArmorSubClassCost1, "
612 "ArmorSubClassCost2, ArmorSubClassCost3, ArmorSubClassCost4, ArmorSubClassCost5, ArmorSubClassCost6, ArmorSubClassCost7, ArmorSubClassCost8"
613 " FROM durability_costs WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
622 "SpellVisualKitID, ClassMask, RaceMask_1, RaceMask_2 FROM emotes WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
636 "PlayerMana, PlayerPrimaryStat, PlayerSecondaryStat, ArmorConstant, CreatureSpellDamage, ContentSetID, Lvl FROM expected_stat"
642 "PlayerManaMod, PlayerPrimaryStatMod, PlayerSecondaryStatMod, ArmorConstantMod, CreatureSpellDamageMod FROM expected_stat_mod"
648 "Description, ReputationIndex, ParentFactionID, Expansion, FriendshipRepID, Flags, ParagonFactionID, RenownFactionID, RenownCurrencyID, "
649 "ReputationClassMask1, ReputationClassMask2, ReputationClassMask3, ReputationClassMask4, ReputationFlags1, ReputationFlags2, "
650 "ReputationFlags3, ReputationFlags4, ReputationBase1, ReputationBase2, ReputationBase3, ReputationBase4, ReputationMax1, ReputationMax2, "
651 "ReputationMax3, ReputationMax4, ParentFactionMod1, ParentFactionMod2, ParentFactionCap1, ParentFactionCap2, ReputationRaceMask1_1, "
652 "ReputationRaceMask1_2, ReputationRaceMask2_1, ReputationRaceMask2_2, ReputationRaceMask3_1, ReputationRaceMask3_2, ReputationRaceMask4_1, "
653 "ReputationRaceMask4_2 FROM faction WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
658 PrepareStatement(
HOTFIX_SEL_FACTION_TEMPLATE,
"SELECT ID, Faction, Flags, FactionGroup, FriendGroup, EnemyGroup, Enemies1, Enemies2, Enemies3, "
659 "Enemies4, Enemies5, Enemies6, Enemies7, Enemies8, Friend1, Friend2, Friend3, Friend4, Friend5, Friend6, Friend7, Friend8"
660 " FROM faction_template WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
665 "GlideStartMinHeight, AddImpulseMaxSpeed, BankingRateMin, BankingRateMax, PitchingRateDownMin, PitchingRateDownMax, PitchingRateUpMin, "
666 "PitchingRateUpMax, TurnVelocityThresholdMin, TurnVelocityThresholdMax, SurfaceFriction, OverMaxDeceleration, Unknown1000_17, Unknown1000_18, "
667 "Unknown1000_19, Unknown1000_20, Unknown1000_21, LaunchSpeedCoefficient, VigorRegenMaxVelCoefficient, SpellID FROM flight_capability"
673 " FROM friendship_rep_reaction WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
680 " FROM friendship_reputation WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
683 " FROM friendship_reputation_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
687 "TextureVariationFileID3 FROM gameobject_art_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
692 "FileDataID, ObjectEffectPackageID, OverrideLootEffectScale, OverrideNameScale, AlternateDisplayType, ClientCreatureDisplayInfoID, "
693 "ClientItemID, Unknown1100 FROM gameobject_display_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
701 PrepareStatement(
HOTFIX_SEL_GAMEOBJECTS,
"SELECT Name, PosX, PosY, PosZ, Rot1, Rot2, Rot3, Rot4, ID, OwnerID, DisplayID, Scale, TypeID, "
702 "PhaseUseFlags, PhaseID, PhaseGroupID, Unknown1100, PropValue1, PropValue2, PropValue3, PropValue4, PropValue5, PropValue6, PropValue7, "
703 "PropValue8 FROM gameobjects WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
709 "FactionChangeGarrAbilityID, Flags FROM garr_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
716 "HordeGameObjectID, AllianceGameObjectID, GarrSiteID, UpgradeLevel, BuildSeconds, CurrencyTypeID, CurrencyQty, HordeUiTextureKitID, "
717 "AllianceUiTextureKitID, IconFileDataID, AllianceSceneScriptPackageID, HordeSceneScriptPackageID, MaxAssignments, ShipmentCapacity, "
718 "GarrAbilityID, BonusGarrAbilityID, GoldCost, Flags FROM garr_building WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
721 " FROM garr_building_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
725 "UiTextureAtlasMemberID FROM garr_building_plot_inst WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
730 "FollowerClassLimit, Flags FROM garr_class_spec WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
737 "HordeCreatureID, AllianceCreatureID, HordeGarrFollRaceID, AllianceGarrFollRaceID, HordeGarrClassSpecID, AllianceGarrClassSpecID, Quality, "
738 "FollowerLevel, ItemLevelWeapon, ItemLevelArmor, HordeSourceTypeEnum, AllianceSourceTypeEnum, HordeIconFileDataID, AllianceIconFileDataID, "
739 "HordeGarrFollItemSetID, AllianceGarrFollItemSetID, HordeUITextureKitID, AllianceUITextureKitID, Vitality, HordeFlavorGarrStringID, "
740 "AllianceFlavorGarrStringID, HordeSlottingBroadcastTextID, AllySlottingBroadcastTextID, ChrClassID, Flags, Gender, AutoCombatantID, "
741 "CovenantID FROM garr_follower WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
748 " FROM garr_follower_x_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
752 PrepareStatement(
HOTFIX_SEL_GARR_MISSION,
"SELECT ID, Name, Location, Description, MapPosX, MapPosY, WorldPosX, WorldPosY, GarrTypeID, "
753 "GarrMissionTypeID, GarrFollowerTypeID, MaxFollowers, MissionCost, MissionCostCurrencyTypesID, OfferedGarrMissionTextureID, UiTextureKitID, "
754 "EnvGarrMechanicID, EnvGarrMechanicTypeID, PlayerConditionID, GarrMissionSetID, TargetLevel, TargetItemLevel, MissionDuration, "
755 "TravelDuration, OfferDuration, BaseCompletionChance, BaseFollowerXP, OvermaxRewardPackID, FollowerDeathChance, AreaID, Flags, "
756 "AutoMissionScalar, AutoMissionScalarCurveID, AutoCombatantEnvCasterID FROM garr_mission WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
763 "UpgradeRequirement2 FROM garr_plot WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
776 "UiTextureKitID, MaxBuildingLevel, UpgradeCost, UpgradeGoldCost FROM garr_site_level WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
781 " FROM garr_site_level_plot_inst WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
786 "GarrTalentTreeType, PlayerConditionID, FeatureTypeIndex, FeatureSubtypeIndex, CurrencyID FROM garr_talent_tree"
815 "GarrTalentTreeID, UiMapID, UiItemInteractionID, Unknown_1000_8, Unknown_1000_9, CovenantID, GossipOptionID, TraitTreeID, ProfessionID, "
816 "Unknown_1002_14, NeighborhoodMapID, SkillLineID FROM gossip_npc_option WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
837 "LegacyItemID, UpgradeItemID1, UpgradeItemID2, UpgradeItemID3, UpgradeItemID4, UpgradeItemID5, UpgradeItemID6, UpgradeItemBonusListID1, "
838 "UpgradeItemBonusListID2, UpgradeItemBonusListID3, UpgradeItemBonusListID4, UpgradeItemBonusListID5, UpgradeItemBonusListID6 FROM heirloom"
845 "Duration1, Duration2, Duration3, Duration4, Duration5, Duration6, Duration7, Duration8, Duration9, Duration10, Date1, Date2, Date3, Date4, "
846 "Date5, Date6, Date7, Date8, Date9, Date10, Date11, Date12, Date13, Date14, Date15, Date16, Date17, Date18, Date19, Date20, Date21, Date22, "
847 "Date23, Date24, Date25, Date26, CalendarFlags1, CalendarFlags2, CalendarFlags3, CalendarFlags4, CalendarFlags5, CalendarFlags6, "
848 "CalendarFlags7, CalendarFlags8, CalendarFlags9, CalendarFlags10, TextureFileDataID1, TextureFileDataID2, TextureFileDataID3 FROM holidays"
871 "ItemGroupSoundsID, ContentTuningID, ModifiedCraftingReagentItemID, Unknown1200, CraftingQualityID, ItemSquishEraID, "
872 "RecraftReagentCountPercentage, OrderSource FROM item WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
882 "Qualitymod7 FROM item_armor_quality WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
887 " FROM item_armor_shield WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
907 "ItemExtendedCostID, PlayerConditionID, Flags, ItemLogicalCostGroupID FROM item_bonus_list_group_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
921 "ChildItemBonusListGroupID, IblGroupPointsModSetID, MinMythicPlusLevel, MaxMythicPlusLevel, ItemCreationContextGroupID, Flags, "
922 "ParentItemBonusTreeID FROM item_bonus_tree_node WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
937 "ItemContextPickerID FROM item_context_picker_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
951 " FROM item_damage_ammo WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
956 " FROM item_damage_one_hand WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
961 "Quality7 FROM item_damage_one_hand_caster WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
966 " FROM item_damage_two_hand WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
971 "Quality7 FROM item_damage_two_hand_caster WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
976 " FROM item_disenchant_loot WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
981 "SpellID, ChrSpecializationID, PlayerConditionID FROM item_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
986 "RequiredAchievement, ItemID1, ItemID2, ItemID3, ItemID4, ItemID5, ItemCount1, ItemCount2, ItemCount3, ItemCount4, ItemCount5, CurrencyID1, "
987 "CurrencyID2, CurrencyID3, CurrencyID4, CurrencyID5, CurrencyCount1, CurrencyCount2, CurrencyCount3, CurrencyCount4, CurrencyCount5"
988 " FROM item_extended_cost WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
993 " FROM item_level_selector WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
998 " FROM item_level_selector_quality WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1014 " FROM item_limit_category_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1019 "TransmogSourceTypeEnum, Flags FROM item_modified_appearance WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1024 "DisplayWeaponSubclassID, DisplayInventoryType FROM item_modified_appearance_extra WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1043 " FROM item_scaling_config WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1048 "AllowableClass, RequiredLevel, RequiredSkill, RequiredSkillRank, RequiredAbility, ItemLevel, Flags1, Flags2, Flags3, Flags4, Flags5, "
1049 "AllowableRace_1, AllowableRace_2 FROM item_search_name WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1055 PrepareStatement(
HOTFIX_SEL_ITEM_SET,
"SELECT ID, Name, SetFlags, RequiredSkill, RequiredSkillRank, ItemID1, ItemID2, ItemID3, ItemID4, ItemID5, "
1056 "ItemID6, ItemID7, ItemID8, ItemID9, ItemID10, ItemID11, ItemID12, ItemID13, ItemID14, ItemID15, ItemID16, ItemID17 FROM item_set"
1067 PrepareStatement(
HOTFIX_SEL_ITEM_SPARSE,
"SELECT ID, AllowableRace, Description, Display3, Display2, Display1, Display, ExpansionID, DmgVariance, "
1068 "LimitCategory, DurationInInventory, QualityModifier, BagFamily, StartQuestID, LanguageID, ItemRange, StatPercentageOfSocket1, "
1069 "StatPercentageOfSocket2, StatPercentageOfSocket3, StatPercentageOfSocket4, StatPercentageOfSocket5, StatPercentageOfSocket6, "
1070 "StatPercentageOfSocket7, StatPercentageOfSocket8, StatPercentageOfSocket9, StatPercentageOfSocket10, StatPercentEditor1, StatPercentEditor2, "
1071 "StatPercentEditor3, StatPercentEditor4, StatPercentEditor5, StatPercentEditor6, StatPercentEditor7, StatPercentEditor8, StatPercentEditor9, "
1072 "StatPercentEditor10, StatModifierBonusStat1, StatModifierBonusStat2, StatModifierBonusStat3, StatModifierBonusStat4, StatModifierBonusStat5, "
1073 "StatModifierBonusStat6, StatModifierBonusStat7, StatModifierBonusStat8, StatModifierBonusStat9, StatModifierBonusStat10, Stackable, "
1074 "MaxCount, MinReputation, RequiredAbility, AllowableRace_1, AllowableRace_2, SellPrice, BuyPrice, VendorStackCount, PriceVariance, "
1075 "PriceRandomValue, Flags1, Flags2, Flags3, Flags4, Flags5, FactionRelated, ModifiedCraftingReagentItemID, ContentTuningID, "
1076 "PlayerLevelToItemLevelCurveID, ItemLevelOffsetCurveID, ItemLevelOffsetItemLevel, ItemSquishEraID, ItemNameDescriptionID, "
1077 "RequiredTransmogHoliday, RequiredHoliday, GemProperties, SocketMatchEnchantmentId, TotemCategoryID, InstanceBound, ZoneBound1, ZoneBound2, "
1078 "ItemSet, LockID, PageID, ItemDelay, MinFactionID, RequiredSkillRank, RequiredSkill, ItemLevel, AllowableClass, ArtifactID, SpellWeight, "
1079 "SpellWeightCategory, SocketType1, SocketType2, SocketType3, SheatheType, Material, PageMaterialID, Bonding, DamageDamageType, "
1080 "ContainerSlots, RequiredPVPMedal, RequiredPVPRank, RequiredLevel, InventoryType, OverallQualityID FROM item_sparse"
1084 " FROM item_sparse_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1109 "FirstSectionID, UiMapID, MapDisplayConditionID, Flags, DifficultyMask FROM journal_encounter WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1116 "FirstChildSectionID, NextSiblingSectionID, Type, IconCreatureDisplayInfoID, UiModelSceneID, SpellID, IconFileDataID, Flags, IconFlags, "
1117 "DifficultyMask FROM journal_encounter_section WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1124 "ButtonSmallFileDataID, LoreFileDataID, Flags, AreaID, CovenantID FROM journal_instance WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1135 PrepareStatement(
HOTFIX_SEL_KEYCHAIN,
"SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, "
1136 "Key16, Key17, Key18, Key19, Key20, Key21, Key22, Key23, Key24, Key25, Key26, Key27, Key28, Key29, Key30, Key31, Key32 FROM keychain"
1158 "PopupBgTextureFileID, ExpansionLevel, MapID, DifficultyID, MinGear, GroupID, OrderIndex, RequiredPlayerConditionId, RandomID, ScenarioID, "
1159 "FinalEncounterID, CountTank, CountHealer, CountDamage, MinCountTank, MinCountHealer, MinCountDamage, MaxPremadeCountTank, "
1160 "MaxPremadeCountHealer, MaxPremadeCountDamage, BonusReputationAmount, MentorItemLevel, MentorCharLevel, MaxPremadeGroupSize, ContentTuningID, "
1161 "Flags1, Flags2 FROM lfg_dungeons WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1168 "LightParamsID1, LightParamsID2, LightParamsID3, LightParamsID4, LightParamsID5, LightParamsID6, LightParamsID7, LightParamsID8 FROM light"
1173 PrepareStatement(
HOTFIX_SEL_LIQUID_TYPE,
"SELECT ID, Name, Texture1, Texture2, Texture3, Texture4, Texture5, Texture6, Flags, SoundBank, SoundID, "
1174 "SpellID, MaxDarkenDepth, FogDarkenIntensity, AmbDarkenIntensity, DirDarkenIntensity, LightID, ParticleScale, ParticleMovement, "
1175 "ParticleTexSlots, MaterialID, MinimapStaticCol, FrameCountTexture1, FrameCountTexture2, FrameCountTexture3, FrameCountTexture4, "
1176 "FrameCountTexture5, FrameCountTexture6, Color1, Color2, Color3, Float1, Float2, Float3, `Float4`, Float5, Float6, Float7, `Float8`, Float9, "
1177 "Float10, Float11, Float12, Float13, Float14, Float15, Float16, Float17, Float18, Float19, Float20, Float21, Float22, Float23, Float24, "
1178 "Float25, Float26, Float27, Float28, Float29, Float30, Float31, Float32, Float33, Float34, Float35, Float36, Float37, Float38, `Int1`, "
1179 "`Int2`, `Int3`, `Int4`, Coefficient1, Coefficient2, Coefficient3, Coefficient4 FROM liquid_type WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1187 PrepareStatement(
HOTFIX_SEL_LOCK,
"SELECT ID, Flags, Index1, Index2, Index3, Index4, Index5, Index6, Index7, Index8, Skill1, Skill2, Skill3, "
1188 "Skill4, Skill5, Skill6, Skill7, Skill8, Type1, Type2, Type3, Type4, Type5, Type6, Type7, Type8, Action1, Action2, Action3, Action4, Action5, "
1189 "Action6, Action7, Action8 FROM `lock` WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1199 "CorpseX, CorpseY, MapType, InstanceType, ExpansionID, AreaTableID, LoadingScreenID, TimeOfDayOverride, ParentMapID, CosmeticParentMapID, "
1200 "TimeOffset, MinimapIconScale, CorpseMapID, MaxPlayers, WindSettingsID, ZmpFileDataID, WdtFileDataID, NavigationMaxDistance, "
1201 "PreloadFileDataID, Flags1, Flags2, Flags3 FROM map WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1204 "PvpLongDescription_lang FROM map_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1208 "CriteriaCount2, CriteriaCount3, CriteriaCount4, CriteriaCount5, FirstRewardQuestID1, FirstRewardQuestID2, FirstRewardQuestID3, "
1209 "FirstRewardQuestID4, FirstRewardQuestID5, FirstRewardQuestID6, RewardQuestID1, RewardQuestID2, RewardQuestID3, RewardQuestID4, "
1210 "RewardQuestID5, RewardQuestID6 FROM map_challenge_mode WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1217 "ItemContextPickerID, Flags, ContentTuningID, WorldStateExpressionID, MapID FROM map_difficulty WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1223 " FROM map_difficulty_x_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1244 "PlayerConditionID, MountFlyRideHeight, UiModelSceneID, MountSpecialRiderAnimKitID, MountSpecialSpellVisualKitID FROM mount"
1252 "ReqMapID, PlayerConditionID, FlightCapabilityID, DriveCapabilityID FROM mount_capability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1278 " FROM mythic_plus_season WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1299 " FROM num_talents_at_level WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1303 PrepareStatement(
HOTFIX_SEL_OVERRIDE_SPELL_DATA,
"SELECT ID, Spells1, Spells2, Spells3, Spells4, Spells5, Spells6, Spells7, Spells8, Spells9, "
1304 "Spells10, PlayerActionBarFileDataID, Flags FROM override_spell_data WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1326 "Priority FROM perks_activity WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1341 "MinLanguage, MaxLanguage, MaxFactionID, MaxReputation, ReputationLogic, CurrentPvpFaction, PvpMedal, PrevQuestLogic, CurrQuestLogic, "
1342 "CurrentCompletedQuestLogic, SpellLogic, ItemLogic, ItemFlags, AuraSpellLogic, WorldStateExpressionID, WeatherID, PartyStatus, "
1343 "LifetimeMaxPVPRank, AchievementLogic, Gender, NativeGender, AreaLogic, LfgLogic, CurrencyLogic, QuestKillID, QuestKillLogic, "
1344 "MinExpansionLevel, MaxExpansionLevel, MinAvgItemLevel, MaxAvgItemLevel, MinAvgEquippedItemLevel, MaxAvgEquippedItemLevel, PhaseUseFlags, "
1345 "PhaseID, PhaseGroupID, Flags, ChrSpecializationIndex, ChrSpecializationRole, ModifierTreeID, PowerType, PowerTypeComp, PowerTypeValue, "
1346 "WeaponSubclassMask, MaxGuildLevel, MinGuildLevel, MaxExpansionTier, MinExpansionTier, MinPVPRank, MaxPVPRank, ContentTuningID, CovenantID, "
1347 "TraitNodeEntryLogic, SkillID1, SkillID2, SkillID3, SkillID4, MinSkill1, MinSkill2, MinSkill3, MinSkill4, MaxSkill1, MaxSkill2, MaxSkill3, "
1348 "MaxSkill4, MinFactionID1, MinFactionID2, MinFactionID3, MinReputation1, MinReputation2, MinReputation3, PrevQuestID1, PrevQuestID2, "
1349 "PrevQuestID3, PrevQuestID4, CurrQuestID1, CurrQuestID2, CurrQuestID3, CurrQuestID4, CurrentCompletedQuestID1, CurrentCompletedQuestID2, "
1350 "CurrentCompletedQuestID3, CurrentCompletedQuestID4, SpellID1, SpellID2, SpellID3, SpellID4, ItemID1, ItemID2, ItemID3, ItemID4, ItemCount1, "
1351 "ItemCount2, ItemCount3, ItemCount4, Explored1, Explored2, Time1, Time2, AuraSpellID1, AuraSpellID2, AuraSpellID3, AuraSpellID4, AuraStacks1, "
1352 "AuraStacks2, AuraStacks3, AuraStacks4, Achievement1, Achievement2, Achievement3, Achievement4, AreaID1, AreaID2, AreaID3, AreaID4, "
1353 "LfgStatus1, LfgStatus2, LfgStatus3, LfgStatus4, LfgCompare1, LfgCompare2, LfgCompare3, LfgCompare4, LfgValue1, LfgValue2, LfgValue3, "
1354 "LfgValue4, CurrencyID1, CurrencyID2, CurrencyID3, CurrencyID4, CurrencyCount1, CurrencyCount2, CurrencyCount3, CurrencyCount4, "
1355 "QuestKillMonster1, QuestKillMonster2, QuestKillMonster3, QuestKillMonster4, QuestKillMonster5, QuestKillMonster6, MovementFlags1, "
1356 "MovementFlags2, RaceMask_1, RaceMask_2, TraitNodeEntryID1, TraitNodeEntryID2, TraitNodeEntryID3, TraitNodeEntryID4, TraitNodeEntryMinRank1, "
1357 "TraitNodeEntryMinRank2, TraitNodeEntryMinRank3, TraitNodeEntryMinRank4, TraitNodeEntryMaxRank1, TraitNodeEntryMaxRank2, "
1358 "TraitNodeEntryMaxRank3, TraitNodeEntryMaxRank4 FROM player_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1390 "DefaultPower, DisplayModifier, RegenInterruptTimeMS, RegenPeace, RegenCombat, Flags FROM power_type WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1395 " FROM prestige_level_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1416 "LevelRequired, PlayerConditionID FROM pvp_talent WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1426 " FROM pvp_talent_slot_unlock WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1437 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM quest_faction_reward WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1452 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM quest_money_reward WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1471 "Difficulty8, Difficulty9, Difficulty10 FROM quest_xp WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1476 "EpicF2, EpicF3, EpicF4, EpicF5, SuperiorF1, SuperiorF2, SuperiorF3, SuperiorF4, SuperiorF5, GoodF1, GoodF2, GoodF3, GoodF4, GoodF5, Epic1, "
1477 "Epic2, Epic3, Epic4, Epic5, Superior1, Superior2, Superior3, Superior4, Superior5, Good1, Good2, Good3, Good4, Good5 FROM rand_prop_points"
1483 "TreasurePickerID FROM reward_pack WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1504 "OrderIndex, Flags, VisibilityPlayerConditionID, WidgetSetID FROM scenario_step WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1533 "CategoryID, SpellIconFileID, CanLink, ParentSkillLineID, ParentTierIndex, Flags, SpellBookSpellID, ExpansionNameSharedStringID, "
1534 "HordeExpansionNameSharedStringID FROM skill_line WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1537 " FROM skill_line_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1541 "SupercedesSpell, AcquireMethod, TrivialSkillLineRankHigh, TrivialSkillLineRankLow, Flags, NumSkillUps, UniqueBit, TradeSkillCategoryID, "
1542 "SkillupSkillLineID, RaceMask_1, RaceMask_2 FROM skill_line_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1554 "RaceMask_1, RaceMask_2 FROM skill_race_class_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1559 " FROM soulbind_conduit_rank WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1564 "VolumeVariationPlus, VolumeVariationMinus, PitchVariationPlus, PitchVariationMinus, DialogType, PitchAdjust, BusOverwriteID, MaxInstances, "
1565 "SoundMixGroupID FROM sound_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1570 " FROM specialization_spells WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1581 "SpellProcsPerMinuteID, ProcTypeMask1, ProcTypeMask2, SpellID FROM spell_aura_options WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1586 "ExcludeTargetAuraState, CasterAuraSpell, TargetAuraSpell, ExcludeCasterAuraSpell, ExcludeTargetAuraSpell, CasterAuraType, TargetAuraType, "
1587 "ExcludeCasterAuraType, ExcludeTargetAuraType, SpellID FROM spell_aura_restrictions WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1596 "RequiredAuraVision, RequiresSpellFocus FROM spell_casting_requirements WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1601 "PreventionType, StartRecoveryCategory, ChargeCategory, SpellID FROM spell_categories WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1612 "SpellClassMask3, SpellClassMask4 FROM spell_class_options WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1617 "SpellID FROM spell_cooldowns WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1627 "EffectAuraPeriod, EffectBonusCoefficient, EffectChainAmplitude, EffectChainTargets, EffectItemType, EffectMechanic, EffectPointsPerResource, "
1628 "EffectPosFacing, EffectRealPointsPerLevel, EffectTriggerSpell, BonusCoefficientFromAP, PvpMultiplier, Coefficient, Variance, "
1629 "ResourceCoefficient, GroupSizeBasePointsCoefficient, EffectBasePoints, ScalingClass, TargetNodeGraph, EffectMiscValue1, EffectMiscValue2, "
1630 "EffectRadiusIndex1, EffectRadiusIndex2, EffectSpellClassMask1, EffectSpellClassMask2, EffectSpellClassMask3, EffectSpellClassMask4, "
1631 "ImplicitTarget1, ImplicitTarget2, SpellID FROM spell_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1645 " FROM spell_equipped_items WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1656 "ChannelInterruptFlags1, ChannelInterruptFlags2, SpellID FROM spell_interrupts WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1661 "EffectScalingPoints1, EffectScalingPoints2, EffectScalingPoints3, IconFileDataID, MinItemLevel, MaxItemLevel, TransmogUseConditionID, "
1662 "TransmogCost, EffectPointsMin1, EffectPointsMin2, EffectPointsMin3, ItemVisual, RequiredSkillID, RequiredSkillRank, ItemLevel, Charges, "
1663 "Effect1, Effect2, Effect3, ScalingClass, ScalingClassRestricted, ConditionID, MinLevel, MaxLevel FROM spell_item_enchantment"
1671 "LtOperandType5, LtOperand1, LtOperand2, LtOperand3, LtOperand4, LtOperand5, Operator1, Operator2, Operator3, Operator4, Operator5, "
1672 "RtOperandType1, RtOperandType2, RtOperandType3, RtOperandType4, RtOperandType5, RtOperand1, RtOperand2, RtOperand3, RtOperand4, RtOperand5, "
1673 "Logic1, Logic2, Logic3, Logic4, Logic5 FROM spell_item_enchantment_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1697 "Attributes8, Attributes9, Attributes10, Attributes11, Attributes12, Attributes13, Attributes14, Attributes15, Attributes16, Attributes17, "
1698 "DifficultyID, CastingTimeIndex, DurationIndex, PvPDurationIndex, RangeIndex, SchoolMask, Speed, LaunchDelay, MinDuration, "
1699 "SpellIconFileDataID, ActiveIconFileDataID, ContentTuningID, ShowFutureSpellPlayerConditionID, SpellVisualScript, ActiveSpellVisualScript, "
1700 "SpellID FROM spell_misc WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1710 "PowerCostPct, PowerCostMaxPct, OptionalCostPct, PowerPctPerSecond, PowerType, RequiredAuraSpellID, OptionalCost, SpellID FROM spell_power"
1741 PrepareStatement(
HOTFIX_SEL_SPELL_REAGENTS,
"SELECT ID, SpellID, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, "
1742 "ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, "
1743 "ReagentRecraftCount1, ReagentRecraftCount2, ReagentRecraftCount3, ReagentRecraftCount4, ReagentRecraftCount5, ReagentRecraftCount6, "
1744 "ReagentRecraftCount7, ReagentRecraftCount8, ReagentSource1, ReagentSource2, ReagentSource3, ReagentSource4, ReagentSource5, ReagentSource6, "
1745 "ReagentSource7, ReagentSource8 FROM spell_reagents WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1750 "OrderSource FROM spell_reagents_currency WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1760 "ShapeshiftMask2 FROM spell_shapeshift WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1765 "CombatRoundTime, DamageVariance, MountTypeID, PresetSpellID1, PresetSpellID2, PresetSpellID3, PresetSpellID4, PresetSpellID5, "
1766 "PresetSpellID6, PresetSpellID7, PresetSpellID8 FROM spell_shapeshift_form WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1773 "Targets, Width, SpellID FROM spell_target_restrictions WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1783 "MissileImpactOffset2, MissileImpactOffset3, StateKit, AnimEventSoundID, Flags, MissileAttachment, MissileDestinationAttachment, "
1784 "MissileCastPositionerID, MissileImpactPositionerID, MissileTargetingKit, HostileSpellVisualID, CasterSpellVisualID, SpellVisualMissileSetID, "
1785 "DamageNumberDelay, LowViolenceSpellVisualID, RaidSpellVisualMissileSetID, ReducedUnexpectedCameraMovementSpellVisualID FROM spell_visual"
1791 "Alpha, Flags, TextureFileDataID, EffectRadius, Type, GenericID, RibbonQualityID, DissolveEffectID, ModelPosition, Unknown901, Unknown1100"
1792 " FROM spell_visual_effect_name WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1797 "MinimumSpellVisualDensityFilterType, MinimumSpellVisualDensityFilterParam, ReducedSpellVisualDensityFilterType, "
1798 "ReducedSpellVisualDensityFilterParam, Flags1, Flags2 FROM spell_visual_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1803 "SpellVisualEffectNameID, SoundEntriesID, Attachment, DestinationAttachment, CastPositionerID, ImpactPositionerID, FollowGroundHeight, "
1804 "FollowGroundDropSpeed, FollowGroundApproach, Flags, SpellMissileMotionID, AnimKitID, ClutterLevel, DecayTimeAfterImpact, Unused1100, "
1805 "SpellVisualMissileSetID FROM spell_visual_missile WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1810 "ActiveIconFileID, ViewerUnitConditionID, ViewerPlayerConditionID, CasterUnitConditionID, CasterPlayerConditionID, SpellID"
1811 " FROM spell_x_spell_visual WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1820 PrepareStatement(
HOTFIX_SEL_TACT_KEY,
"SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, "
1825 PrepareStatement(
HOTFIX_SEL_TALENT,
"SELECT ID, Description, TierID, Flags, ColumnIndex, TabID, ClassID, SpecID, SpellID, OverridesSpellID, "
1826 "RequiredSpellID, CategoryMask1, CategoryMask2, SpellRank1, SpellRank2, SpellRank3, SpellRank4, SpellRank5, SpellRank6, SpellRank7, "
1827 "SpellRank8, SpellRank9, PrereqTalent1, PrereqTalent2, PrereqTalent3, PrereqRank1, PrereqRank2, PrereqRank3 FROM talent"
1833 PrepareStatement(
HOTFIX_SEL_TAXI_NODES,
"SELECT Name, PosX, PosY, PosZ, MapOffsetX, MapOffsetY, FlightMapOffsetX, FlightMapOffsetY, ID, "
1834 "ContinentID, ConditionID, CharacterBitNumber, Flags, UiTextureKitID, MinimapAtlasMemberID, Facing, SpecialIconConditionID, "
1835 "VisibilityConditionID, MountCreatureID1, MountCreatureID2 FROM taxi_nodes WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1844 PrepareStatement(
HOTFIX_SEL_TAXI_PATH_NODE,
"SELECT LocX, LocY, LocZ, ID, PathID, NodeIndex, ContinentID, Flags, Delay, ArrivalEventID, "
1845 "DepartureEventID FROM taxi_path_node WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1865 "TraitNodeID, TraitNodeEntryID, TraitCurrencyID, SpentAmountRequired, Flags, RequiredLevel, FreeSharedStringID, SpendMoreSharedStringID, "
1866 "TraitCondAccountElementID FROM trait_cond WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1871 "PlayerDataElementCharacterID FROM trait_cond_account_element WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1880 "PlayerDataElementCharacterID FROM trait_currency WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1885 "TraitNodeEntryID, OrderIndex FROM trait_currency_source WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1892 "OverridesSpellID, VisibleSpellID FROM trait_definition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1895 " FROM trait_definition_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1899 " FROM trait_definition_effect_points WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1975 "MaxZoom, UiTextureKitID FROM trait_tree WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1986 "OrderIndex FROM trait_tree_loadout_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2006 " FROM transmog_outfit_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2013 "Unused1200, TransmogCollectionType, SecondarySlotID, InventorySlotID, UnassignedAtlasID, UnassignedDisplayAtlasID, ItemCostMultiplier, "
2014 "IllusionCostMultiplier FROM transmog_outfit_slot_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2019 "ItemCostMultiplier, IllusionCostMultiplier FROM transmog_outfit_slot_option WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2026 "ParentTransmogSetID, Unknown810, ExpansionID, PatchID, UiOrder, PlayerConditionID FROM transmog_set WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2043 " FROM transmog_situation WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2072 "VisibilityPlayerConditionID, HelpTextPosition, BkgAtlasID, AlternateUiMapGroup, ContentTuningID, AdventureMapTextureKitID, "
2073 "MapArtZoneTextPosition FROM ui_map WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2078 PrepareStatement(
HOTFIX_SEL_UI_MAP_ASSIGNMENT,
"SELECT UiMinX, UiMinY, UiMaxX, UiMaxY, Region1X, Region1Y, Region1Z, Region2X, Region2Y, "
2079 "Region2Z, ID, UiMapID, OrderIndex, MapID, AreaID, WmoDoodadPlacementID, WmoGroupID, Unknown1125 FROM ui_map_assignment"
2084 PrepareStatement(
HOTFIX_SEL_UI_MAP_LINK,
"SELECT UiMinX, UiMinY, UiMaxX, UiMaxY, ID, ParentUiMapID, OrderIndex, ChildUiMapID, PlayerConditionID, "
2085 "OverrideHighlightFileDataID, OverrideHighlightAtlasID, Flags FROM ui_map_link WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2094 "BottomLeftFeatureDesc, RightFeatureTitle, RightFeatureDesc, AllianceQuestID, HordeQuestID, ScreenType, TextureKitID, SoundKitID, "
2095 "PlayerConditionID, CharLevelConditionID, RequiredTimeEventPassed FROM ui_splash_screen WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2098 "BottomLeftFeatureTitle_lang, BottomLeftFeatureDesc_lang, RightFeatureTitle_lang, RightFeatureDesc_lang FROM ui_splash_screen_locale"
2102 PrepareStatement(
HOTFIX_SEL_UNIT_CONDITION,
"SELECT ID, Flags, Variable1, Variable2, Variable3, Variable4, Variable5, Variable6, Variable7, "
2103 "Variable8, Op1, Op2, Op3, Op4, Op5, Op6, Op7, Op8, Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8 FROM unit_condition"
2108 PrepareStatement(
HOTFIX_SEL_UNIT_POWER_BAR,
"SELECT ID, Name, Cost, OutOfError, ToolTip, MinPower, MaxPower, StartPower, CenterPower, "
2109 "RegenerationPeace, RegenerationCombat, BarType, Flags, StartInset, EndInset, FileDataID1, FileDataID2, FileDataID3, FileDataID4, "
2110 "FileDataID5, FileDataID6, Color1, Color2, Color3, Color4, Color5, Color6 FROM unit_power_bar WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2117 "CameraFadeDistScalarMin, CameraFadeDistScalarMax, CameraPitchOffset, FacingLimitRight, FacingLimitLeft, CameraYawOffset, "
2118 "VehicleUIIndicatorID, MissileTargetingID, VehiclePOITypeID, SeatID1, SeatID2, SeatID3, SeatID4, SeatID5, SeatID6, SeatID7, SeatID8, "
2119 "PowerDisplayID1, PowerDisplayID2, PowerDisplayID3 FROM vehicle WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2124 "CameraOffsetZ, Flags, FlagsB, FlagsC, AttachmentID, EnterPreDelay, EnterSpeed, EnterGravity, EnterMinDuration, EnterMaxDuration, "
2125 "EnterMinArcHeight, EnterMaxArcHeight, EnterAnimStart, EnterAnimLoop, RideAnimStart, RideAnimLoop, RideUpperAnimStart, RideUpperAnimLoop, "
2126 "ExitPreDelay, ExitSpeed, ExitGravity, ExitMinDuration, ExitMaxDuration, ExitMinArcHeight, ExitMaxArcHeight, ExitAnimStart, ExitAnimLoop, "
2127 "ExitAnimEnd, VehicleEnterAnim, VehicleEnterAnimBone, VehicleExitAnim, VehicleExitAnimBone, VehicleRideAnimLoop, VehicleRideAnimLoopBone, "
2128 "PassengerAttachmentID, PassengerYaw, PassengerPitch, PassengerRoll, VehicleEnterAnimDelay, VehicleExitAnimDelay, VehicleAbilityDisplay, "
2129 "EnterUISoundID, ExitUISoundID, UiSkinFileDataID, CameraEnteringDelay, CameraEnteringDuration, CameraExitingDelay, CameraExitingDuration, "
2130 "CameraPosChaseRate, CameraFacingChaseRate, CameraEnteringZoom, CameraSeatZoomMin, CameraSeatZoomMax, EnterAnimKitID, RideAnimKitID, "
2131 "ExitAnimKitID, VehicleEnterAnimKitID, VehicleRideAnimKitID, VehicleExitAnimKitID, CameraModeID FROM vehicle_seat"
2137 "MinHeight, VignetteType, RewardQuestID, UiWidgetSetID, UiMapPinInfoID, ObjectiveType FROM vignette WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2142 PrepareStatement(
HOTFIX_SEL_WARBAND_SCENE,
"SELECT Name, Description, PositionX, PositionY, PositionZ, LookAtX, LookAtY, LookAtZ, ID, MapID, Fov, "
2143 "TimeOfDay, Flags, SoundAmbienceID, Quality, TextureKit, DefaultScenePriority FROM warband_scene WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2150 "AmbienceID, UwAmbience, ZoneMusic, UwZoneMusic, IntroSound, UwIntroSound, AreaTableID, Flags FROM wmo_area_table"
2157 "CombatConditionID FROM world_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
2162 "HitRectLeft, HitRectRight, PlayerConditionID, Flags, AreaID1, AreaID2, AreaID3, AreaID4 FROM world_map_overlay"
#define PREPARE_LOCALE_STMT(stmtBase, sql, con)
#define PREPARE_MAX_ID_STMT(stmtBase, sql, con)
@ HOTFIX_SEL_GARR_ABILITY
@ HOTFIX_SEL_CRITERIA_TREE
@ HOTFIX_SEL_MODIFIED_CRAFTING_ITEM
@ HOTFIX_SEL_TRANSMOG_SITUATION_TRIGGER
@ HOTFIX_SEL_MAIL_TEMPLATE
@ HOTFIX_SEL_BATTLEMASTER_LIST_X_MAP
@ HOTFIX_SEL_PHASE_X_PHASE_GROUP
@ HOTFIX_SEL_PARAGON_REPUTATION
@ HOTFIX_SEL_CONDITIONAL_CONTENT_TUNING
@ HOTFIX_SEL_CINEMATIC_CAMERA
@ HOTFIX_SEL_ITEM_SEARCH_NAME
@ HOTFIX_SEL_REWARD_PACK_X_ITEM
@ HOTFIX_SEL_TRANSMOG_SET
@ HOTFIX_SEL_PLAYER_DATA_FLAG_CHARACTER
@ HOTFIX_SEL_WORLD_MAP_OVERLAY
@ HOTFIX_SEL_ITEM_BONUS_TREE
@ HOTFIX_SEL_FACTION_TEMPLATE
@ HOTFIX_SEL_TRAIT_TREE_X_TRAIT_CURRENCY
@ HOTFIX_SEL_ITEM_OFFSET_CURVE
@ HOTFIX_SEL_ARTIFACT_QUEST_XP
@ HOTFIX_SEL_PATH_PROPERTY
@ HOTFIX_SEL_PLAYER_DATA_FLAG_ACCOUNT
@ HOTFIX_SEL_ARTIFACT_POWER_RANK
@ HOTFIX_SEL_ITEM_DAMAGE_AMMO
@ HOTFIX_SEL_ITEM_SCALING_CONFIG
@ HOTFIX_SEL_CHARACTER_LOADOUT
@ HOTFIX_SEL_CHR_CUSTOMIZATION_CHOICE
@ HOTFIX_SEL_GUILD_COLOR_EMBLEM
@ HOTFIX_SEL_BATTLE_PET_BREED_QUALITY
@ HOTFIX_SEL_SCENE_SCRIPT_PACKAGE
@ HOTFIX_SEL_NUM_TALENTS_AT_LEVEL
@ HOTFIX_SEL_CREATURE_DISPLAY_INFO_EXTRA
@ HOTFIX_SEL_TRAIT_TREE_LOADOUT_ENTRY
@ HOTFIX_SEL_CONVERSATION_LINE
@ HOTFIX_SEL_AREA_TRIGGER_ACTION_SET
@ HOTFIX_SEL_SUMMON_PROPERTIES
@ HOTFIX_SEL_TRANSMOG_SITUATION_GROUP
@ HOTFIX_SEL_SPELL_LEVELS
@ HOTFIX_SEL_GLOBAL_CURVE
@ HOTFIX_SEL_SPELL_TARGET_RESTRICTIONS
@ HOTFIX_SEL_SPELL_VISUAL_MISSILE
@ HOTFIX_SEL_TRAIT_DEFINITION_EFFECT_POINTS
@ HOTFIX_SEL_TRAIT_NODE_GROUP_X_TRAIT_COND
@ HOTFIX_SEL_GLYPH_REQUIRED_SPEC
@ HOTFIX_SEL_CONDITIONAL_CHR_MODEL
@ HOTFIX_SEL_EMOTES_TEXT_SOUND
@ HOTFIX_SEL_ITEM_DAMAGE_TWO_HAND
@ HOTFIX_SEL_WORLD_EFFECT
@ HOTFIX_SEL_SPELL_VISUAL
@ HOTFIX_SEL_SPELL_REAGENTS
@ HOTFIX_SEL_CRAFTING_QUALITY
@ HOTFIX_SEL_TRAIT_NODE_GROUP_X_TRAIT_COST
@ HOTFIX_SEL_ITEM_BONUS_TREE_NODE
@ HOTFIX_SEL_WMO_AREA_TABLE
@ HOTFIX_SEL_SPELL_POWER_DIFFICULTY
@ HOTFIX_SEL_GUILD_COLOR_BORDER
@ HOTFIX_SEL_CREATURE_LABEL
@ HOTFIX_SEL_AZERITE_ITEM
@ HOTFIX_SEL_GARR_PLOT_BUILDING
@ HOTFIX_SEL_SCENE_SCRIPT_TEXT
@ HOTFIX_SEL_ANIMATION_DATA
@ HOTFIX_SEL_SPEC_SET_MEMBER
@ HOTFIX_SEL_QUEST_MONEY_REWARD
@ HOTFIX_SEL_SPELL_LEARN_SPELL
@ HOTFIX_SEL_ADVENTURE_MAP_POI
@ HOTFIX_SEL_FRIENDSHIP_REP_REACTION
@ HOTFIX_SEL_SPELL_PROCS_PER_MINUTE
@ HOTFIX_SEL_CAMPAIGN_X_QUEST_LINE
@ HOTFIX_SEL_AZERITE_EMPOWERED_ITEM
@ HOTFIX_SEL_CHR_CUSTOMIZATION_REQ_CHOICE
@ HOTFIX_SEL_GARR_SITE_LEVEL_PLOT_INST
@ HOTFIX_SEL_POWER_DISPLAY
@ HOTFIX_SEL_CHR_RACE_X_CHR_MODEL
@ HOTFIX_SEL_SPELL_ITEM_ENCHANTMENT_CONDITION
@ HOTFIX_SEL_CFG_CATEGORIES
@ HOTFIX_SEL_SPELL_EFFECT
@ HOTFIX_SEL_SOULBIND_CONDUIT_RANK
@ HOTFIX_SEL_MAP_CHALLENGE_MODE
@ HOTFIX_SEL_SKILL_LINE_ABILITY
@ HOTFIX_SEL_MOUNT_EQUIPMENT
@ HOTFIX_SEL_TRAIT_NODE_ENTRY_X_TRAIT_COST
@ HOTFIX_SEL_ARTIFACT_UNLOCK
@ HOTFIX_SEL_TRANSMOG_OUTFIT_SLOT_INFO
@ HOTFIX_SEL_JOURNAL_ENCOUNTER_SECTION
@ HOTFIX_SEL_NAMES_RESERVED
@ HOTFIX_SEL_ITEM_ARMOR_QUALITY
@ HOTFIX_SEL_IMPORT_PRICE_WEAPON
@ HOTFIX_SEL_BATTLE_PET_BREED_STATE
@ HOTFIX_SEL_ITEM_LEVEL_SELECTOR
@ HOTFIX_SEL_ARTIFACT_POWER_LINK
@ HOTFIX_SEL_AZERITE_TIER_UNLOCK
@ HOTFIX_SEL_ARTIFACT_POWER_PICKER
@ HOTFIX_SEL_TRAIT_TREE_LOADOUT
@ HOTFIX_SEL_TRAIT_CURRENCY
@ HOTFIX_SEL_SERVER_MESSAGES
@ HOTFIX_SEL_SPELL_SCALING
@ HOTFIX_SEL_ITEM_NAME_DESCRIPTION
@ HOTFIX_SEL_PVP_TALENT_CATEGORY
@ HOTFIX_SEL_SPELL_ITEM_ENCHANTMENT
@ HOTFIX_SEL_SPELL_DURATION
@ HOTFIX_SEL_SPELL_EMPOWER
@ HOTFIX_SEL_CHR_SPECIALIZATION
@ HOTFIX_SEL_AZERITE_POWER_SET_MEMBER
@ HOTFIX_SEL_ARTIFACT_POWER
@ HOTFIX_SEL_ITEM_BONUS_LIST_LEVEL_DELTA
@ HOTFIX_SEL_SPELL_CASTING_REQUIREMENTS
@ HOTFIX_SEL_TRANSPORT_ANIMATION
@ HOTFIX_SEL_ARTIFACT_APPEARANCE_SET
@ HOTFIX_SEL_ITEM_SQUISH_ERA
@ HOTFIX_SEL_EXPECTED_STAT_MOD
@ HOTFIX_SEL_ITEM_BONUS_LIST_GROUP_ENTRY
@ HOTFIX_SEL_SPELL_EMPOWER_STAGE
@ HOTFIX_SEL_GARR_FOLLOWER
@ HOTFIX_SEL_ITEM_APPEARANCE
@ HOTFIX_SEL_ITEM_LIMIT_CATEGORY_CONDITION
@ HOTFIX_SEL_GARR_TALENT_TREE
@ HOTFIX_SEL_SPELL_REAGENTS_CURRENCY
@ HOTFIX_SEL_VEHICLE_SEAT
@ HOTFIX_SEL_SPELL_CLASS_OPTIONS
@ HOTFIX_SEL_CURRENCY_CONTAINER
@ HOTFIX_SEL_SPELL_COOLDOWNS
@ HOTFIX_SEL_GAMEOBJECT_LABEL
@ HOTFIX_SEL_CREATURE_MODEL_DATA
@ HOTFIX_SEL_SPELL_X_SPELL_VISUAL
@ HOTFIX_SEL_SPELL_AURA_RESTRICTIONS
@ HOTFIX_SEL_MOUNT_CAPABILITY
@ HOTFIX_SEL_TRANSMOG_ILLUSION
@ HOTFIX_SEL_CORRUPTION_EFFECTS
@ HOTFIX_SEL_TRAIT_SYSTEM
@ HOTFIX_SEL_ITEM_LEVEL_SELECTOR_QUALITY_SET
@ HOTFIX_SEL_RAND_PROP_POINTS
@ HOTFIX_SEL_TRANSMOG_SITUATION
@ HOTFIX_SEL_OVERRIDE_SPELL_DATA
@ HOTFIX_SEL_SCENARIO_STEP
@ HOTFIX_SEL_REWARD_PACK_X_CURRENCY_TYPE
@ HOTFIX_SEL_BATTLEMASTER_LIST
@ HOTFIX_SEL_JOURNAL_INSTANCE
@ HOTFIX_SEL_AUCTION_HOUSE
@ HOTFIX_SEL_LFG_DUNGEONS
@ HOTFIX_SEL_ITEM_X_BONUS_TREE
@ HOTFIX_SEL_TRAIT_TREE_X_TRAIT_COST
@ HOTFIX_SEL_ITEM_MODIFIED_APPEARANCE_EXTRA
@ HOTFIX_SEL_PRESTIGE_LEVEL_INFO
@ HOTFIX_SEL_GLYPH_BINDABLE_SPELL
@ HOTFIX_SEL_ITEM_DAMAGE_TWO_HAND_CASTER
@ HOTFIX_SEL_UNIT_POWER_BAR
@ HOTFIX_SEL_SCENE_SCRIPT
@ HOTFIX_SEL_IMPORT_PRICE_QUALITY
@ HOTFIX_SEL_PLAYER_DATA_ELEMENT_CHARACTER
@ HOTFIX_SEL_GARR_FOLLOWER_X_ABILITY
@ HOTFIX_SEL_JOURNAL_ENCOUNTER
@ HOTFIX_SEL_SPELL_EQUIPPED_ITEMS
@ HOTFIX_SEL_AZERITE_ITEM_MILESTONE_POWER
@ HOTFIX_SEL_GAMEOBJECT_ART_KIT
@ HOTFIX_SEL_ARTIFACT_APPEARANCE
@ HOTFIX_SEL_GOSSIP_NPC_OPTION
@ HOTFIX_SEL_QUEST_PACKAGE_ITEM
@ HOTFIX_SEL_ITEM_DAMAGE_ONE_HAND
@ HOTFIX_SEL_CREATURE_TYPE
@ HOTFIX_SEL_ITEM_PRICE_BASE
@ HOTFIX_SEL_BROADCAST_TEXT
@ HOTFIX_SEL_DURABILITY_COSTS
@ HOTFIX_SEL_TRAIT_NODE_ENTRY_X_TRAIT_COND
@ HOTFIX_SEL_MYTHIC_PLUS_SEASON
@ HOTFIX_SEL_SPELL_CATEGORIES
@ HOTFIX_SEL_CONTENT_TUNING_X_LABEL
@ HOTFIX_SEL_BATTLE_PET_ABILITY
@ HOTFIX_SEL_AZERITE_ESSENCE_POWER
@ HOTFIX_SEL_TOTEM_CATEGORY
@ HOTFIX_SEL_PVP_DIFFICULTY
@ HOTFIX_SEL_CONTENT_TUNING_X_EXPECTED
@ HOTFIX_SEL_SPELL_CATEGORY
@ HOTFIX_SEL_CREATURE_DISPLAY_INFO
@ HOTFIX_SEL_CHR_CLASS_UI_DISPLAY
@ HOTFIX_SEL_TRANSPORT_ROTATION
@ HOTFIX_SEL_TRAIT_DEFINITION
@ HOTFIX_SEL_KEYSTONE_AFFIX
@ HOTFIX_SEL_UI_MAP_X_MAP_ART
@ HOTFIX_SEL_GARR_PLOT_INSTANCE
@ HOTFIX_SEL_SPELL_RADIUS
@ HOTFIX_SEL_CHR_CUSTOMIZATION_REQ
@ HOTFIX_SEL_UI_SPLASH_SCREEN
@ HOTFIX_SEL_ITEM_LIMIT_CATEGORY
@ HOTFIX_SEL_GLYPH_PROPERTIES
@ HOTFIX_SEL_GEM_PROPERTIES
@ HOTFIX_SEL_MAP_DIFFICULTY_X_CONDITION
@ HOTFIX_SEL_PERKS_ACTIVITY
@ HOTFIX_SEL_EXPECTED_STAT
@ HOTFIX_SEL_BARBER_SHOP_STYLE
@ HOTFIX_SEL_WARBAND_SCENE
@ HOTFIX_SEL_ITEM_ARMOR_SHIELD
@ HOTFIX_SEL_BATTLE_PET_SPECIES
@ HOTFIX_SEL_UI_MAP_ASSIGNMENT
@ HOTFIX_SEL_TRANSMOG_HOLIDAY
@ HOTFIX_SEL_ITEM_X_ITEM_EFFECT
@ HOTFIX_SEL_TRAIT_NODE_ENTRY
@ HOTFIX_SEL_SPELL_FOCUS_OBJECT
@ HOTFIX_SEL_QUEST_FACTION_REWARD
@ HOTFIX_SEL_ITEM_DAMAGE_ONE_HAND_CASTER
@ HOTFIX_SEL_CHR_CUSTOMIZATION_DISPLAY_INFO
@ HOTFIX_SEL_TRAIT_NODE_X_TRAIT_NODE_ENTRY
@ HOTFIX_SEL_SKILL_LINE_X_TRAIT_TREE
@ HOTFIX_SEL_ARTIFACT_CATEGORY
@ HOTFIX_SEL_ITEM_DISENCHANT_LOOT
@ HOTFIX_SEL_TAXI_PATH_NODE
@ HOTFIX_SEL_TRAIT_SUB_TREE
@ HOTFIX_SEL_GARR_MISSION
@ HOTFIX_SEL_MOUNT_X_DISPLAY
@ HOTFIX_SEL_CONTENT_TUNING
@ HOTFIX_SEL_TRANSMOG_SET_ITEM
@ HOTFIX_SEL_ITEM_MODIFIED_APPEARANCE
@ HOTFIX_SEL_CHARACTER_LOADOUT_ITEM
@ HOTFIX_SEL_BANNED_ADDONS
@ HOTFIX_SEL_MOUNT_TYPE_X_CAPABILITY
@ HOTFIX_SEL_GAMEOBJECT_DISPLAY_INFO
@ HOTFIX_SEL_WORLD_STATE_EXPRESSION
@ HOTFIX_SEL_SPELL_AURA_OPTIONS
@ HOTFIX_SEL_FLIGHT_CAPABILITY
@ HOTFIX_SEL_TRAIT_NODE_X_TRAIT_COND
@ HOTFIX_SEL_GARR_CLASS_SPEC
@ HOTFIX_SEL_TRAIT_CURRENCY_SOURCE
@ HOTFIX_SEL_ITEM_ARMOR_TOTAL
@ HOTFIX_SEL_GUILD_COLOR_BACKGROUND
@ HOTFIX_SEL_SKILL_RACE_CLASS_INFO
@ HOTFIX_SEL_ARMOR_LOCATION
@ HOTFIX_SEL_ITEM_CURRENCY_COST
@ HOTFIX_SEL_SPELL_PROCS_PER_MINUTE_MOD
@ HOTFIX_SEL_GARR_SITE_LEVEL
@ HOTFIX_SEL_DUNGEON_ENCOUNTER
@ HOTFIX_SEL_ITEM_EXTENDED_COST
@ HOTFIX_SEL_CHAR_BASE_INFO
@ HOTFIX_SEL_UNIT_CONDITION
@ HOTFIX_SEL_SPELL_KEYBOUND_OVERRIDE
@ HOTFIX_SEL_BATTLE_PET_SPECIES_STATE
@ HOTFIX_SEL_PVP_TALENT_SLOT_UNLOCK
@ HOTFIX_SEL_AZERITE_POWER
@ HOTFIX_SEL_CINEMATIC_SEQUENCES
@ HOTFIX_SEL_BROADCAST_TEXT_DURATION
@ HOTFIX_SEL_AZERITE_UNLOCK_MAPPING
@ HOTFIX_SEL_SCENE_SCRIPT_GLOBAL_TEXT
@ HOTFIX_SEL_TRAIT_NODE_X_TRAIT_COST
@ HOTFIX_SEL_TRANSMOG_OUTFIT_ENTRY
@ HOTFIX_SEL_GUILD_PERK_SPELLS
@ HOTFIX_SEL_NAMES_PROFANITY
@ HOTFIX_SEL_FRIENDSHIP_REPUTATION
@ HOTFIX_SEL_MAP_DIFFICULTY
@ HOTFIX_SEL_CHR_CLASSES_X_POWER_TYPES
@ HOTFIX_SEL_TRANSMOG_SET_GROUP
@ HOTFIX_SEL_TRAIT_NODE_GROUP_X_TRAIT_NODE
@ HOTFIX_SEL_AZERITE_KNOWLEDGE_MULTIPLIER
@ HOTFIX_SEL_CHR_CUSTOMIZATION_ELEMENT
@ HOTFIX_SEL_SPELL_VISUAL_KIT
@ HOTFIX_SEL_DURABILITY_QUALITY
@ HOTFIX_SEL_SPELL_INTERRUPTS
@ HOTFIX_SEL_MODIFIER_TREE
@ HOTFIX_SEL_LANGUAGE_WORDS
@ HOTFIX_SEL_TRAIT_NODE_GROUP
@ HOTFIX_SEL_ACHIEVEMENT_CATEGORY
@ HOTFIX_SEL_AZERITE_ESSENCE
@ HOTFIX_SEL_JOURNAL_TIER
@ HOTFIX_SEL_SPECIALIZATION_SPELLS
@ HOTFIX_SEL_ITEM_CHILD_EQUIPMENT
@ HOTFIX_SEL_SPELL_VISUAL_EFFECT_NAME
@ HOTFIX_SEL_ITEM_CONTEXT_PICKER_ENTRY
@ HOTFIX_SEL_ITEM_CREATION_CONTEXT
@ HOTFIX_SEL_CHALLENGE_MODE_ITEM_BONUS_OVERRIDE
@ HOTFIX_SEL_PLAYER_CONDITION
@ MAX_HOTFIXDATABASE_STATEMENTS
@ HOTFIX_SEL_TRANSMOG_OUTFIT_SLOT_OPTION
@ HOTFIX_SEL_SPELL_CAST_TIMES
@ HOTFIX_SEL_ITEM_LEVEL_SELECTOR_QUALITY
@ HOTFIX_SEL_GARR_BUILDING
@ HOTFIX_SEL_CREATURE_FAMILY
@ HOTFIX_SEL_AREA_GROUP_MEMBER
@ HOTFIX_SEL_SPELL_SHAPESHIFT
@ HOTFIX_SEL_PLAYER_DATA_ELEMENT_ACCOUNT
@ HOTFIX_SEL_ITEM_BAG_FAMILY
@ HOTFIX_SEL_AZERITE_TIER_UNLOCK_SET
@ HOTFIX_SEL_SPELL_TOTEMS
@ HOTFIX_SEL_AREA_TRIGGER
@ HOTFIX_SEL_SPELL_SHAPESHIFT_FORM
@ HOTFIX_SEL_ARTIFACT_TIER
@ HOTFIX_SEL_ITEM_SET_SPELL
@ HOTFIX_SEL_TRAIT_COND_ACCOUNT_ELEMENT
@ HOTFIX_SEL_NAMES_RESERVED_LOCALE
@ HOTFIX_SEL_CURRENCY_TYPES
@ HOTFIX_SEL_CHR_CUSTOMIZATION_OPTION
@ HOTFIX_SEL_CHAT_CHANNELS
@ HOTFIX_SEL_ITEM_SPEC_OVERRIDE
@ HOTFIX_SEL_IMPORT_PRICE_ARMOR
@ HOTFIX_SEL_AZERITE_LEVEL_INFO
@ HOTFIX_SEL_ADVENTURE_JOURNAL
@ HOTFIX_SEL_IMPORT_PRICE_SHIELD
@ HOTFIX_SEL_GARR_BUILDING_PLOT_INST
@ HOTFIX_SEL_DESTRUCTIBLE_MODEL_DATA
@ HOTFIX_SEL_QUEST_LINE_X_QUEST
void DoPrepareStatements() override
HotfixDatabaseConnection(MySQLConnectionInfo &connInfo, ConnectionFlags connectionFlags)
~HotfixDatabaseConnection()
void PrepareStatement(uint32 index, std::string_view sql, ConnectionFlags flags)
PreparedStatementContainer m_stmts
PreparedStatements storage.
bool m_reconnecting
Are we reconnecting?