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 FROM achievement WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
54 "PlayerConditionID, Flags, ButtonActionType, TextureFileDataID, LfgDungeonID, QuestID, BattleMasterListID, PriorityMin, PriorityMax, ItemID, "
55 "ItemQuantity, CurrencyType, CurrencyQuantity, UiMapID, BonusPlayerConditionID1, BonusPlayerConditionID2, BonusValue1, BonusValue2"
56 " FROM adventure_journal WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
59 "ContinueDescription_lang FROM adventure_journal_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
63 "LfgDungeonID, RewardItemID, UiTextureAtlasMemberID, UiTextureKitID, MapID, AreaTableID FROM adventure_map_poi WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
84 "SoundProviderPrefUnderwater, AmbienceID, UwAmbience, ZoneMusic, UwZoneMusic, IntroSound, UwIntroSound, FactionGroupMask, AmbientMultiplier, "
85 "MountFlags, PvpCombatWorldStateID, WildBattlePetLevelMin, WildBattlePetLevelMax, WindSettingsID, ContentTuningID, Flags1, Flags2, "
86 "LiquidTypeID1, LiquidTypeID2, LiquidTypeID3, LiquidTypeID4 FROM area_table WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
91 PrepareStatement(
HOTFIX_SEL_AREA_TRIGGER,
"SELECT PosX, PosY, PosZ, ID, ContinentID, PhaseUseFlags, PhaseID, PhaseGroupID, Radius, BoxLength, "
92 "BoxWidth, BoxHeight, BoxYaw, ShapeType, ShapeID, AreaTriggerActionSetID, Flags FROM area_trigger WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
102 "ChrSpecializationID, Flags, ArtifactCategoryID, UiModelSceneID, SpellVisualKitID FROM artifact WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
108 "ItemAppearanceModifierID, UiSwatchColor, UiModelSaturation, UiModelOpacity, OverrideShapeshiftFormID, OverrideShapeshiftDisplayID, "
109 "UiItemAppearanceID, UiAltItemAppearanceID, Flags, UiCameraID, UsablePlayerConditionID FROM artifact_appearance"
117 "ForgeAttachmentOverride, Flags, ArtifactID FROM artifact_appearance_set WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
141 " FROM artifact_power_rank WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
146 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM artifact_quest_xp WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
151 "MinimumEmpowerKnowledge FROM artifact_tier WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
178 "MinorPowerDescription, MajorPowerActual, MinorPowerActual FROM azerite_essence_power WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
189 " FROM azerite_item_milestone_power WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
198 " FROM azerite_level_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
208 " FROM azerite_power_set_member WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
213 " FROM azerite_tier_unlock WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
222 "AzeriteUnlockMappingSetID FROM azerite_unlock_mapping WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
242 " FROM battle_pet_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
259 "Flags, SourceTypeEnum, CardUIModelSceneID, LoadoutUIModelSceneID, CovenantID FROM battle_pet_species WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
271 "RatedPlayers, MinPlayers, MaxPlayers, GroupsAllowed, MaxGroupSize, HolidayWorldState, Flags, IconFileDataID, RequiredPlayerConditionID, "
272 "MapID1, MapID2, MapID3, MapID4, MapID5, MapID6, MapID7, MapID8, MapID9, MapID10, MapID11, MapID12, MapID13, MapID14, MapID15, MapID16"
273 " FROM battlemaster_list WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
276 " FROM battlemaster_list_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
280 "VoiceOverPriorityID, SoundKitID1, SoundKitID2, EmoteID1, EmoteID2, EmoteID3, EmoteDelay1, EmoteDelay2, EmoteDelay3 FROM broadcast_text"
304 "MythicPlusSeasonID, PvPSeasonID, SrcItemBonusTreeID FROM challenge_mode_item_bonus_override WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
332 " FROM chr_class_ui_display WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
337 "HyphenatedNameMale, HyphenatedNameFemale, ID, CreateScreenFileDataID, SelectScreenFileDataID, IconFileDataID, LowResScreenFileDataID, Flags, "
338 "SpellTextureBlobFileDataID, ArmorTypeMask, CharStartKitUnknown901, MaleCharacterCreationVisualFallback, "
339 "MaleCharacterCreationIdleVisualFallback, FemaleCharacterCreationVisualFallback, FemaleCharacterCreationIdleVisualFallback, "
340 "CharacterCreationIdleGroundVisualFallback, CharacterCreationGroundVisualFallback, AlteredFormCharacterCreationIdleVisualFallback, "
341 "CharacterCreationAnimLoopWaitTimeMsFallback, CinematicSequenceID, DefaultSpec, PrimaryStatPriority, DisplayPower, "
342 "RangedAttackPowerPerAgility, AttackPowerPerAgility, AttackPowerPerStrength, SpellClassSet, ClassColorR, ClassColorG, ClassColorB, RolesMask"
346 "DisabledString_lang, HyphenatedNameMale_lang, HyphenatedNameFemale_lang FROM chr_classes_locale WHERE (`VerifiedBuild` > 0) = ?"
356 "ChrCustomizationVisReqID, SortOrder, UiOrderIndex, Flags, AddedInPatch, SoundKitID, SwatchColor1, SwatchColor2 FROM chr_customization_choice"
364 "BarberShopHeightOffset, BarberShopCameraZoomOffset FROM chr_customization_display_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
369 "ChrCustomizationGeosetID, ChrCustomizationSkinnedModelID, ChrCustomizationMaterialID, ChrCustomizationBoneSetID, "
370 "ChrCustomizationCondModelID, ChrCustomizationDisplayInfoID, ChrCustItemGeoModifyID, ChrCustomizationVoiceID, AnimKitID, ParticleColorID, "
371 "ChrCustGeoComponentLinkID FROM chr_customization_element WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
376 "OptionType, BarberShopCostModifier, ChrCustomizationID, ChrCustomizationReqID, UiOrderIndex, AddedInPatch FROM chr_customization_option"
384 "ItemModifiedAppearanceID FROM chr_customization_req WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
391 " FROM chr_customization_req_choice WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
396 "CustomizeOffset2, CustomizeOffset3, ID, Sex, DisplayID, CharComponentTextureLayoutID, Flags, SkeletonFileDataID, ModelFallbackChrModelID, "
397 "TextureFallbackChrModelID, HelmVisFallbackChrModelID, CustomizeScale, CustomizeFacing, CameraDistanceOffset, BarberShopCameraOffsetScale, "
398 "BarberShopCameraHeightOffsetScale, BarberShopCameraRotationOffset FROM chr_model WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
408 "LoreName, LoreNameFemale, LoreNameLower, LoreNameLowerFemale, LoreDescription, ShortName, ShortNameFemale, ShortNameLower, "
409 "ShortNameLowerFemale, Flags, FactionID, CinematicSequenceID, ResSicknessSpellID, SplashSoundID, Alliance, RaceRelated, "
410 "UnalteredVisualRaceID, DefaultClassID, CreateScreenFileDataID, SelectScreenFileDataID, NeutralRaceID, LowResScreenFileDataID, "
411 "AlteredFormStartVisualKitID1, AlteredFormStartVisualKitID2, AlteredFormStartVisualKitID3, AlteredFormFinishVisualKitID1, "
412 "AlteredFormFinishVisualKitID2, AlteredFormFinishVisualKitID3, HeritageArmorAchievementID, StartingLevel, UiDisplayOrder, "
413 "MaleModelFallbackRaceID, FemaleModelFallbackRaceID, MaleTextureFallbackRaceID, FemaleTextureFallbackRaceID, PlayableRaceBit, "
414 "HelmetAnimScalingRaceID, TransmogrifyDisabledSlotMask, UnalteredVisualCustomizationRaceID, AlteredFormCustomizeOffsetFallback1, "
415 "AlteredFormCustomizeOffsetFallback2, AlteredFormCustomizeOffsetFallback3, AlteredFormCustomizeRotationFallback, Unknown910_11, "
416 "Unknown910_12, Unknown910_13, Unknown910_21, Unknown910_22, Unknown910_23, Unknown1000, BaseLanguage, CreatureType, MaleModelFallbackSex, "
417 "FemaleModelFallbackSex, MaleTextureFallbackSex, FemaleTextureFallbackSex FROM chr_races WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
420 "LoreNameFemale_lang, LoreNameLower_lang, LoreNameLowerFemale_lang, LoreDescription_lang, ShortName_lang, ShortNameFemale_lang, "
421 "ShortNameLower_lang, ShortNameLowerFemale_lang FROM chr_races_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
424 PrepareStatement(
HOTFIX_SEL_CHR_SPECIALIZATION,
"SELECT Name, FemaleName, Description, ID, ClassID, OrderIndex, PetTalentType, Role, Flags, "
425 "SpellIconFileID, PrimaryStatPriority, AnimReplacements, MasterySpellID1, MasterySpellID2 FROM chr_specialization"
433 " FROM cinematic_camera WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
437 PrepareStatement(
HOTFIX_SEL_CINEMATIC_SEQUENCES,
"SELECT ID, SoundID, Camera1, Camera2, Camera3, Camera4, Camera5, Camera6, Camera7, Camera8"
438 " FROM cinematic_sequences WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
443 "ChrCustomizationCategoryID FROM conditional_chr_model WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
448 " FROM conditional_content_tuning WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
453 "TargetLevelMaxDelta, TargetLevelMin, TargetLevelMax, MinItemLevel, QuestXpMultiplier FROM content_tuning WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
458 "ContentTuningID FROM content_tuning_x_expected WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
468 "NextConversationLineID, AnimKitID, SpeechType, StartAnimation, EndAnimation FROM conversation_line WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
478 "ExtendedDisplayInfoID, NPCSoundID, ParticleColorID, PortraitCreatureDisplayInfoID, PortraitTextureFileDataID, ObjectEffectPackageID, "
479 "AnimReplacementSetID, Flags, StateSpellVisualKitID, PlayerOverrideScale, PetInstanceScale, UnarmedWeaponType, MountPoofSpellVisualKitID, "
480 "DissolveEffectID, Gender, DissolveOutEffectID, CreatureModelMinLod, TextureVariationFileDataID1, TextureVariationFileDataID2, "
481 "TextureVariationFileDataID3, TextureVariationFileDataID4 FROM creature_display_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
486 "HDBakeMaterialResourcesID FROM creature_display_info_extra WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
491 "IconFileID, SkillLine1, SkillLine2 FROM creature_family WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
496 PrepareStatement(
HOTFIX_SEL_CREATURE_MODEL_DATA,
"SELECT ID, GeoBox1, GeoBox2, GeoBox3, GeoBox4, GeoBox5, GeoBox6, Flags, FileDataID, WalkSpeed, "
497 "RunSpeed, BloodID, FootprintTextureID, FootprintTextureLength, FootprintTextureWidth, FootprintParticleScale, FoleyMaterialID, "
498 "FootstepCameraEffectID, DeathThudCameraEffectID, SoundID, SizeClass, CollisionWidth, CollisionHeight, WorldEffectScale, "
499 "CreatureGeosetDataID, HoverHeight, AttachedEffectScale, ModelScale, MissileCollisionRadius, MissileCollisionPush, MissileCollisionRaise, "
500 "MountHeight, OverrideLootEffectScale, OverrideNameScale, OverrideSelectionRadius, TamedPetBaseScale, Unknown820_1, Unknown820_2, "
501 "Unknown820_31, Unknown820_32 FROM creature_model_data WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
510 PrepareStatement(
HOTFIX_SEL_CRITERIA,
"SELECT ID, Type, Asset, ModifierTreeId, StartEvent, StartAsset, StartTimer, FailEvent, FailAsset, Flags, "
511 "EligibilityWorldStateID, EligibilityWorldStateValue FROM criteria WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
523 "ContainerQuality, OnLootSpellVisualKitID, CurrencyTypesID FROM currency_container WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
530 "MaxEarnablePerWeek, Quality, FactionID, ItemGroupSoundsID, XpQuestDifficulty, AwardConditionID, MaxQtyWorldStateID, "
531 "RechargingAmountPerCycle, RechargingCycleDurationMS, Flags1, Flags2 FROM currency_types WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
547 "State1DestructionDoodadSet, State1ImpactEffectDoodadSet, State1AmbientDoodadSet, State2Wmo, State2DestructionDoodadSet, "
548 "State2ImpactEffectDoodadSet, State2AmbientDoodadSet, State3Wmo, State3InitDoodadSet, State3AmbientDoodadSet, EjectDirection, DoNotHighlight, "
549 "State0Wmo, HealEffect, HealEffectSpeed, State0NameSet, State1NameSet, State2NameSet, State3NameSet FROM destructible_model_data"
555 "Flags, ItemContext, ToggleDifficultyID, GroupSizeHealthCurveID, GroupSizeDmgCurveID, GroupSizeSpellPointsCurveID FROM difficulty"
562 "SpellIconFileID, Faction FROM dungeon_encounter WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
569 "WeaponSubClassCost5, WeaponSubClassCost6, WeaponSubClassCost7, WeaponSubClassCost8, WeaponSubClassCost9, WeaponSubClassCost10, "
570 "WeaponSubClassCost11, WeaponSubClassCost12, WeaponSubClassCost13, WeaponSubClassCost14, WeaponSubClassCost15, WeaponSubClassCost16, "
571 "WeaponSubClassCost17, WeaponSubClassCost18, WeaponSubClassCost19, WeaponSubClassCost20, WeaponSubClassCost21, ArmorSubClassCost1, "
572 "ArmorSubClassCost2, ArmorSubClassCost3, ArmorSubClassCost4, ArmorSubClassCost5, ArmorSubClassCost6, ArmorSubClassCost7, ArmorSubClassCost8"
573 " FROM durability_costs WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
582 "SpellVisualKitID, ClassMask FROM emotes WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
596 "PlayerMana, PlayerPrimaryStat, PlayerSecondaryStat, ArmorConstant, CreatureSpellDamage, Lvl FROM expected_stat"
602 "PlayerManaMod, PlayerPrimaryStatMod, PlayerSecondaryStatMod, ArmorConstantMod, CreatureSpellDamageMod FROM expected_stat_mod"
608 "Description, ReputationIndex, ParentFactionID, Expansion, FriendshipRepID, Flags, ParagonFactionID, RenownFactionID, RenownCurrencyID, "
609 "ReputationClassMask1, ReputationClassMask2, ReputationClassMask3, ReputationClassMask4, ReputationFlags1, ReputationFlags2, "
610 "ReputationFlags3, ReputationFlags4, ReputationBase1, ReputationBase2, ReputationBase3, ReputationBase4, ReputationMax1, ReputationMax2, "
611 "ReputationMax3, ReputationMax4, ParentFactionMod1, ParentFactionMod2, ParentFactionCap1, ParentFactionCap2 FROM faction"
617 PrepareStatement(
HOTFIX_SEL_FACTION_TEMPLATE,
"SELECT ID, Faction, Flags, FactionGroup, FriendGroup, EnemyGroup, Enemies1, Enemies2, Enemies3, "
618 "Enemies4, Enemies5, Enemies6, Enemies7, Enemies8, Friend1, Friend2, Friend3, Friend4, Friend5, Friend6, Friend7, Friend8"
619 " FROM faction_template WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
624 " FROM friendship_rep_reaction WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
631 " FROM friendship_reputation WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
634 " FROM friendship_reputation_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
638 "TextureVariationFileID3 FROM gameobject_art_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
643 "FileDataID, ObjectEffectPackageID, OverrideLootEffectScale, OverrideNameScale, AlternateDisplayType, ClientCreatureDisplayInfoID, "
644 "ClientItemID FROM gameobject_display_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
648 PrepareStatement(
HOTFIX_SEL_GAMEOBJECTS,
"SELECT Name, PosX, PosY, PosZ, Rot1, Rot2, Rot3, Rot4, ID, OwnerID, DisplayID, Scale, TypeID, "
649 "PhaseUseFlags, PhaseID, PhaseGroupID, PropValue1, PropValue2, PropValue3, PropValue4, PropValue5, PropValue6, PropValue7, PropValue8"
656 "FactionChangeGarrAbilityID, Flags FROM garr_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
663 "HordeGameObjectID, AllianceGameObjectID, GarrSiteID, UpgradeLevel, BuildSeconds, CurrencyTypeID, CurrencyQty, HordeUiTextureKitID, "
664 "AllianceUiTextureKitID, IconFileDataID, AllianceSceneScriptPackageID, HordeSceneScriptPackageID, MaxAssignments, ShipmentCapacity, "
665 "GarrAbilityID, BonusGarrAbilityID, GoldCost, Flags FROM garr_building WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
668 " FROM garr_building_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
672 "UiTextureAtlasMemberID FROM garr_building_plot_inst WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
677 "FollowerClassLimit, Flags FROM garr_class_spec WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
684 "HordeCreatureID, AllianceCreatureID, HordeGarrFollRaceID, AllianceGarrFollRaceID, HordeGarrClassSpecID, AllianceGarrClassSpecID, Quality, "
685 "FollowerLevel, ItemLevelWeapon, ItemLevelArmor, HordeSourceTypeEnum, AllianceSourceTypeEnum, HordeIconFileDataID, AllianceIconFileDataID, "
686 "HordeGarrFollItemSetID, AllianceGarrFollItemSetID, HordeUITextureKitID, AllianceUITextureKitID, Vitality, HordeFlavorGarrStringID, "
687 "AllianceFlavorGarrStringID, HordeSlottingBroadcastTextID, AllySlottingBroadcastTextID, ChrClassID, Flags, Gender, AutoCombatantID, "
688 "CovenantID FROM garr_follower WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
695 " FROM garr_follower_x_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
699 PrepareStatement(
HOTFIX_SEL_GARR_MISSION,
"SELECT ID, Name, Location, Description, MapPosX, MapPosY, WorldPosX, WorldPosY, GarrTypeID, "
700 "GarrMissionTypeID, GarrFollowerTypeID, MaxFollowers, MissionCost, MissionCostCurrencyTypesID, OfferedGarrMissionTextureID, UiTextureKitID, "
701 "EnvGarrMechanicID, EnvGarrMechanicTypeID, PlayerConditionID, GarrMissionSetID, TargetLevel, TargetItemLevel, MissionDuration, "
702 "TravelDuration, OfferDuration, BaseCompletionChance, BaseFollowerXP, OvermaxRewardPackID, FollowerDeathChance, AreaID, Flags, "
703 "AutoMissionScalar, AutoMissionScalarCurveID, AutoCombatantEnvCasterID FROM garr_mission WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
710 "UpgradeRequirement1, UpgradeRequirement2 FROM garr_plot WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
723 "UiTextureKitID, MaxBuildingLevel, UpgradeCost, UpgradeGoldCost FROM garr_site_level WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
728 " FROM garr_site_level_plot_inst WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
733 "GarrTalentTreeType, PlayerConditionID, FeatureTypeIndex, FeatureSubtypeIndex, CurrencyID FROM garr_talent_tree"
762 "GarrTalentTreeID, UiMapID, UiItemInteractionID, Unknown_1000_8, Unknown_1000_9, CovenantID, GossipOptionID, TraitTreeID, ProfessionID, "
763 "Unknown_1002_14 FROM gossip_npc_option WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
784 "LegacyItemID, UpgradeItemID1, UpgradeItemID2, UpgradeItemID3, UpgradeItemID4, UpgradeItemID5, UpgradeItemID6, UpgradeItemBonusListID1, "
785 "UpgradeItemBonusListID2, UpgradeItemBonusListID3, UpgradeItemBonusListID4, UpgradeItemBonusListID5, UpgradeItemBonusListID6 FROM heirloom"
792 "Duration1, Duration2, Duration3, Duration4, Duration5, Duration6, Duration7, Duration8, Duration9, Duration10, Date1, Date2, Date3, Date4, "
793 "Date5, Date6, Date7, Date8, Date9, Date10, Date11, Date12, Date13, Date14, Date15, Date16, Date17, Date18, Date19, Date20, Date21, Date22, "
794 "Date23, Date24, Date25, Date26, CalendarFlags1, CalendarFlags2, CalendarFlags3, CalendarFlags4, CalendarFlags5, CalendarFlags6, "
795 "CalendarFlags7, CalendarFlags8, CalendarFlags9, CalendarFlags10, TextureFileDataID1, TextureFileDataID2, TextureFileDataID3 FROM holidays"
818 "ItemGroupSoundsID, ContentTuningID, ModifiedCraftingReagentItemID, CraftingQualityID FROM item WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
828 "Qualitymod7 FROM item_armor_quality WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
833 " FROM item_armor_shield WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
853 "ItemExtendedCostID, PlayerConditionID, Flags, ItemLogicalCostGroupID FROM item_bonus_list_group_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
867 "ChildItemBonusListGroupID, IblGroupPointsModSetID, MinMythicPlusLevel, MaxMythicPlusLevel, ParentItemBonusTreeID FROM item_bonus_tree_node"
883 "ItemContextPickerID FROM item_context_picker_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
892 " FROM item_damage_ammo WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
897 " FROM item_damage_one_hand WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
902 "Quality7 FROM item_damage_one_hand_caster WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
907 " FROM item_damage_two_hand WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
912 "Quality7 FROM item_damage_two_hand_caster WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
917 " FROM item_disenchant_loot WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
922 "SpellID, ChrSpecializationID FROM item_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
927 "RequiredAchievement, ItemID1, ItemID2, ItemID3, ItemID4, ItemID5, ItemCount1, ItemCount2, ItemCount3, ItemCount4, ItemCount5, CurrencyID1, "
928 "CurrencyID2, CurrencyID3, CurrencyID4, CurrencyID5, CurrencyCount1, CurrencyCount2, CurrencyCount3, CurrencyCount4, CurrencyCount5"
929 " FROM item_extended_cost WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
934 " FROM item_level_selector WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
939 " FROM item_level_selector_quality WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
955 " FROM item_limit_category_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
960 "TransmogSourceTypeEnum FROM item_modified_appearance WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
965 "DisplayWeaponSubclassID, DisplayInventoryType FROM item_modified_appearance_extra WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
980 "AllowableClass, RequiredLevel, RequiredSkill, RequiredSkillRank, RequiredAbility, ItemLevel, Flags1, Flags2, Flags3, Flags4"
981 " FROM item_search_name WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
987 PrepareStatement(
HOTFIX_SEL_ITEM_SET,
"SELECT ID, Name, SetFlags, RequiredSkill, RequiredSkillRank, ItemID1, ItemID2, ItemID3, ItemID4, ItemID5, "
988 "ItemID6, ItemID7, ItemID8, ItemID9, ItemID10, ItemID11, ItemID12, ItemID13, ItemID14, ItemID15, ItemID16, ItemID17 FROM item_set"
999 PrepareStatement(
HOTFIX_SEL_ITEM_SPARSE,
"SELECT ID, AllowableRace, Description, Display3, Display2, Display1, Display, ExpansionID, DmgVariance, "
1000 "LimitCategory, DurationInInventory, QualityModifier, BagFamily, StartQuestID, LanguageID, ItemRange, StatPercentageOfSocket1, "
1001 "StatPercentageOfSocket2, StatPercentageOfSocket3, StatPercentageOfSocket4, StatPercentageOfSocket5, StatPercentageOfSocket6, "
1002 "StatPercentageOfSocket7, StatPercentageOfSocket8, StatPercentageOfSocket9, StatPercentageOfSocket10, StatPercentEditor1, StatPercentEditor2, "
1003 "StatPercentEditor3, StatPercentEditor4, StatPercentEditor5, StatPercentEditor6, StatPercentEditor7, StatPercentEditor8, StatPercentEditor9, "
1004 "StatPercentEditor10, Stackable, MaxCount, MinReputation, RequiredAbility, SellPrice, BuyPrice, VendorStackCount, PriceVariance, "
1005 "PriceRandomValue, Flags1, Flags2, Flags3, Flags4, FactionRelated, ModifiedCraftingReagentItemID, ContentTuningID, "
1006 "PlayerLevelToItemLevelCurveID, ItemNameDescriptionID, RequiredTransmogHoliday, RequiredHoliday, GemProperties, SocketMatchEnchantmentId, "
1007 "TotemCategoryID, InstanceBound, ZoneBound1, ZoneBound2, ItemSet, LockID, PageID, ItemDelay, MinFactionID, RequiredSkillRank, RequiredSkill, "
1008 "ItemLevel, AllowableClass, ArtifactID, SpellWeight, SpellWeightCategory, SocketType1, SocketType2, SocketType3, SheatheType, Material, "
1009 "PageMaterialID, Bonding, DamageDamageType, StatModifierBonusStat1, StatModifierBonusStat2, StatModifierBonusStat3, StatModifierBonusStat4, "
1010 "StatModifierBonusStat5, StatModifierBonusStat6, StatModifierBonusStat7, StatModifierBonusStat8, StatModifierBonusStat9, "
1011 "StatModifierBonusStat10, ContainerSlots, RequiredPVPMedal, RequiredPVPRank, RequiredLevel, InventoryType, OverallQualityID FROM item_sparse"
1015 " FROM item_sparse_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1036 "FirstSectionID, UiMapID, MapDisplayConditionID, Flags, DifficultyMask FROM journal_encounter WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1043 "FirstChildSectionID, NextSiblingSectionID, Type, IconCreatureDisplayInfoID, UiModelSceneID, SpellID, IconFileDataID, Flags, IconFlags, "
1044 "DifficultyMask FROM journal_encounter_section WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1051 "ButtonSmallFileDataID, LoreFileDataID, Flags, AreaID FROM journal_instance WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1062 PrepareStatement(
HOTFIX_SEL_KEYCHAIN,
"SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, "
1063 "Key16, Key17, Key18, Key19, Key20, Key21, Key22, Key23, Key24, Key25, Key26, Key27, Key28, Key29, Key30, Key31, Key32 FROM keychain"
1085 "PopupBgTextureFileID, ExpansionLevel, MapID, DifficultyID, MinGear, GroupID, OrderIndex, RequiredPlayerConditionId, RandomID, ScenarioID, "
1086 "FinalEncounterID, CountTank, CountHealer, CountDamage, MinCountTank, MinCountHealer, MinCountDamage, BonusReputationAmount, MentorItemLevel, "
1087 "MentorCharLevel, ContentTuningID, Flags1, Flags2 FROM lfg_dungeons WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1094 "LightParamsID1, LightParamsID2, LightParamsID3, LightParamsID4, LightParamsID5, LightParamsID6, LightParamsID7, LightParamsID8 FROM light"
1099 PrepareStatement(
HOTFIX_SEL_LIQUID_TYPE,
"SELECT ID, Name, Texture1, Texture2, Texture3, Texture4, Texture5, Texture6, Flags, SoundBank, SoundID, "
1100 "SpellID, MaxDarkenDepth, FogDarkenIntensity, AmbDarkenIntensity, DirDarkenIntensity, LightID, ParticleScale, ParticleMovement, "
1101 "ParticleTexSlots, MaterialID, MinimapStaticCol, FrameCountTexture1, FrameCountTexture2, FrameCountTexture3, FrameCountTexture4, "
1102 "FrameCountTexture5, FrameCountTexture6, Color1, Color2, Float1, Float2, Float3, `Float4`, Float5, Float6, Float7, `Float8`, Float9, Float10, "
1103 "Float11, Float12, Float13, Float14, Float15, Float16, Float17, Float18, `Int1`, `Int2`, `Int3`, `Int4`, Coefficient1, Coefficient2, "
1104 "Coefficient3, Coefficient4 FROM liquid_type WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1108 PrepareStatement(
HOTFIX_SEL_LOCK,
"SELECT ID, Flags, Index1, Index2, Index3, Index4, Index5, Index6, Index7, Index8, Skill1, Skill2, Skill3, "
1109 "Skill4, Skill5, Skill6, Skill7, Skill8, Type1, Type2, Type3, Type4, Type5, Type6, Type7, Type8, Action1, Action2, Action3, Action4, Action5, "
1110 "Action6, Action7, Action8 FROM `lock` WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1120 "CorpseX, CorpseY, MapType, InstanceType, ExpansionID, AreaTableID, LoadingScreenID, TimeOfDayOverride, ParentMapID, CosmeticParentMapID, "
1121 "TimeOffset, MinimapIconScale, CorpseMapID, MaxPlayers, WindSettingsID, ZmpFileDataID, WdtFileDataID, NavigationMaxDistance, Flags1, Flags2, "
1125 "PvpLongDescription_lang FROM map_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1129 "CriteriaCount2, CriteriaCount3 FROM map_challenge_mode WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1136 "ItemContextPickerID, Flags, ContentTuningID, MapID FROM map_difficulty WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1142 " FROM map_difficulty_x_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1158 "PlayerConditionID, MountFlyRideHeight, UiModelSceneID, MountSpecialRiderAnimKitID, MountSpecialSpellVisualKitID FROM mount"
1166 "ReqMapID, PlayerConditionID, FlightCapabilityID FROM mount_capability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1211 PrepareStatement(
HOTFIX_SEL_OVERRIDE_SPELL_DATA,
"SELECT ID, Spells1, Spells2, Spells3, Spells4, Spells5, Spells6, Spells7, Spells8, Spells9, "
1212 "Spells10, PlayerActionBarFileDataID, Flags FROM override_spell_data WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1230 "MaxLanguage, MaxFactionID, MaxReputation, ReputationLogic, CurrentPvpFaction, PvpMedal, PrevQuestLogic, CurrQuestLogic, "
1231 "CurrentCompletedQuestLogic, SpellLogic, ItemLogic, ItemFlags, AuraSpellLogic, WorldStateExpressionID, WeatherID, PartyStatus, "
1232 "LifetimeMaxPVPRank, AchievementLogic, Gender, NativeGender, AreaLogic, LfgLogic, CurrencyLogic, QuestKillID, QuestKillLogic, "
1233 "MinExpansionLevel, MaxExpansionLevel, MinAvgItemLevel, MaxAvgItemLevel, MinAvgEquippedItemLevel, MaxAvgEquippedItemLevel, PhaseUseFlags, "
1234 "PhaseID, PhaseGroupID, Flags, ChrSpecializationIndex, ChrSpecializationRole, ModifierTreeID, PowerType, PowerTypeComp, PowerTypeValue, "
1235 "WeaponSubclassMask, MaxGuildLevel, MinGuildLevel, MaxExpansionTier, MinExpansionTier, MinPVPRank, MaxPVPRank, ContentTuningID, CovenantID, "
1236 "TraitNodeEntryLogic, SkillID1, SkillID2, SkillID3, SkillID4, MinSkill1, MinSkill2, MinSkill3, MinSkill4, MaxSkill1, MaxSkill2, MaxSkill3, "
1237 "MaxSkill4, MinFactionID1, MinFactionID2, MinFactionID3, MinReputation1, MinReputation2, MinReputation3, PrevQuestID1, PrevQuestID2, "
1238 "PrevQuestID3, PrevQuestID4, CurrQuestID1, CurrQuestID2, CurrQuestID3, CurrQuestID4, CurrentCompletedQuestID1, CurrentCompletedQuestID2, "
1239 "CurrentCompletedQuestID3, CurrentCompletedQuestID4, SpellID1, SpellID2, SpellID3, SpellID4, ItemID1, ItemID2, ItemID3, ItemID4, ItemCount1, "
1240 "ItemCount2, ItemCount3, ItemCount4, Explored1, Explored2, Time1, Time2, AuraSpellID1, AuraSpellID2, AuraSpellID3, AuraSpellID4, AuraStacks1, "
1241 "AuraStacks2, AuraStacks3, AuraStacks4, Achievement1, Achievement2, Achievement3, Achievement4, AreaID1, AreaID2, AreaID3, AreaID4, "
1242 "LfgStatus1, LfgStatus2, LfgStatus3, LfgStatus4, LfgCompare1, LfgCompare2, LfgCompare3, LfgCompare4, LfgValue1, LfgValue2, LfgValue3, "
1243 "LfgValue4, CurrencyID1, CurrencyID2, CurrencyID3, CurrencyID4, CurrencyCount1, CurrencyCount2, CurrencyCount3, CurrencyCount4, "
1244 "QuestKillMonster1, QuestKillMonster2, QuestKillMonster3, QuestKillMonster4, QuestKillMonster5, QuestKillMonster6, MovementFlags1, "
1245 "MovementFlags2, TraitNodeEntryID1, TraitNodeEntryID2, TraitNodeEntryID3, TraitNodeEntryID4, TraitNodeEntryMinRank1, TraitNodeEntryMinRank2, "
1246 "TraitNodeEntryMinRank3, TraitNodeEntryMinRank4, TraitNodeEntryMaxRank1, TraitNodeEntryMaxRank2, TraitNodeEntryMaxRank3, "
1247 "TraitNodeEntryMaxRank4 FROM player_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1259 "DefaultPower, DisplayModifier, RegenInterruptTimeMS, RegenPeace, RegenCombat, Flags FROM power_type WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1264 " FROM prestige_level_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1289 "LevelRequired, PlayerConditionID FROM pvp_talent WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1299 " FROM pvp_talent_slot_unlock WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1310 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM quest_faction_reward WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1325 "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM quest_money_reward WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1344 "Difficulty8, Difficulty9, Difficulty10 FROM quest_xp WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1349 "EpicF2, EpicF3, EpicF4, EpicF5, SuperiorF1, SuperiorF2, SuperiorF3, SuperiorF4, SuperiorF5, GoodF1, GoodF2, GoodF3, GoodF4, GoodF5, Epic1, "
1350 "Epic2, Epic3, Epic4, Epic5, Superior1, Superior2, Superior3, Superior4, Superior5, Good1, Good2, Good3, Good4, Good5 FROM rand_prop_points"
1356 "TreasurePickerID FROM reward_pack WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1376 "OrderIndex, Flags, VisibilityPlayerConditionID, WidgetSetID FROM scenario_step WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1405 "CategoryID, SpellIconFileID, CanLink, ParentSkillLineID, ParentTierIndex, Flags, SpellBookSpellID, ExpansionNameSharedStringID, "
1406 "HordeExpansionNameSharedStringID FROM skill_line WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1409 " FROM skill_line_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1413 "SupercedesSpell, AcquireMethod, TrivialSkillLineRankHigh, TrivialSkillLineRankLow, Flags, NumSkillUps, UniqueBit, TradeSkillCategoryID, "
1414 "SkillupSkillLineID FROM skill_line_ability WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1426 " FROM skill_race_class_info WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1431 " FROM soulbind_conduit_rank WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1436 "VolumeVariationPlus, VolumeVariationMinus, PitchVariationPlus, PitchVariationMinus, DialogType, PitchAdjust, BusOverwriteID, MaxInstances, "
1437 "SoundMixGroupID FROM sound_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1442 " FROM specialization_spells WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1453 "SpellProcsPerMinuteID, ProcTypeMask1, ProcTypeMask2, SpellID FROM spell_aura_options WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1458 "ExcludeTargetAuraState, CasterAuraSpell, TargetAuraSpell, ExcludeCasterAuraSpell, ExcludeTargetAuraSpell, CasterAuraType, TargetAuraType, "
1459 "ExcludeCasterAuraType, ExcludeTargetAuraType, SpellID FROM spell_aura_restrictions WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1468 "RequiredAuraVision, RequiresSpellFocus FROM spell_casting_requirements WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1473 "StartRecoveryCategory, ChargeCategory, SpellID FROM spell_categories WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1484 "SpellClassMask3, SpellClassMask4 FROM spell_class_options WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1489 "SpellID FROM spell_cooldowns WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1498 "EffectAuraPeriod, EffectBonusCoefficient, EffectChainAmplitude, EffectChainTargets, EffectItemType, EffectMechanic, EffectPointsPerResource, "
1499 "EffectPosFacing, EffectRealPointsPerLevel, EffectTriggerSpell, BonusCoefficientFromAP, PvpMultiplier, Coefficient, Variance, "
1500 "ResourceCoefficient, GroupSizeBasePointsCoefficient, EffectBasePoints, ScalingClass, EffectMiscValue1, EffectMiscValue2, EffectRadiusIndex1, "
1501 "EffectRadiusIndex2, EffectSpellClassMask1, EffectSpellClassMask2, EffectSpellClassMask3, EffectSpellClassMask4, ImplicitTarget1, "
1502 "ImplicitTarget2, SpellID FROM spell_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1507 " FROM spell_equipped_items WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1518 "ChannelInterruptFlags1, ChannelInterruptFlags2, SpellID FROM spell_interrupts WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1523 "EffectScalingPoints1, EffectScalingPoints2, EffectScalingPoints3, IconFileDataID, MinItemLevel, MaxItemLevel, TransmogUseConditionID, "
1524 "TransmogCost, EffectPointsMin1, EffectPointsMin2, EffectPointsMin3, ItemVisual, Flags, RequiredSkillID, RequiredSkillRank, ItemLevel, "
1525 "Charges, Effect1, Effect2, Effect3, ScalingClass, ScalingClassRestricted, ConditionID, MinLevel, MaxLevel FROM spell_item_enchantment"
1533 "LtOperandType5, LtOperand1, LtOperand2, LtOperand3, LtOperand4, LtOperand5, Operator1, Operator2, Operator3, Operator4, Operator5, "
1534 "RtOperandType1, RtOperandType2, RtOperandType3, RtOperandType4, RtOperandType5, RtOperand1, RtOperand2, RtOperand3, RtOperand4, RtOperand5, "
1535 "Logic1, Logic2, Logic3, Logic4, Logic5 FROM spell_item_enchantment_condition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1559 "Attributes8, Attributes9, Attributes10, Attributes11, Attributes12, Attributes13, Attributes14, Attributes15, DifficultyID, "
1560 "CastingTimeIndex, DurationIndex, RangeIndex, SchoolMask, Speed, LaunchDelay, MinDuration, SpellIconFileDataID, ActiveIconFileDataID, "
1561 "ContentTuningID, ShowFutureSpellPlayerConditionID, SpellVisualScript, ActiveSpellVisualScript, SpellID FROM spell_misc"
1572 "PowerCostPct, PowerCostMaxPct, OptionalCostPct, PowerPctPerSecond, PowerType, RequiredAuraSpellID, OptionalCost, SpellID FROM spell_power"
1603 PrepareStatement(
HOTFIX_SEL_SPELL_REAGENTS,
"SELECT ID, SpellID, Reagent1, Reagent2, Reagent3, Reagent4, Reagent5, Reagent6, Reagent7, Reagent8, "
1604 "ReagentCount1, ReagentCount2, ReagentCount3, ReagentCount4, ReagentCount5, ReagentCount6, ReagentCount7, ReagentCount8, "
1605 "ReagentRecraftCount1, ReagentRecraftCount2, ReagentRecraftCount3, ReagentRecraftCount4, ReagentRecraftCount5, ReagentRecraftCount6, "
1606 "ReagentRecraftCount7, ReagentRecraftCount8, ReagentSource1, ReagentSource2, ReagentSource3, ReagentSource4, ReagentSource5, ReagentSource6, "
1607 "ReagentSource7, ReagentSource8 FROM spell_reagents WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1622 "ShapeshiftMask2 FROM spell_shapeshift WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1627 "CombatRoundTime, DamageVariance, MountTypeID, PresetSpellID1, PresetSpellID2, PresetSpellID3, PresetSpellID4, PresetSpellID5, "
1628 "PresetSpellID6, PresetSpellID7, PresetSpellID8 FROM spell_shapeshift_form WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1635 "Targets, Width, SpellID FROM spell_target_restrictions WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1645 "MissileImpactOffset2, MissileImpactOffset3, AnimEventSoundID, Flags, MissileAttachment, MissileDestinationAttachment, "
1646 "MissileCastPositionerID, MissileImpactPositionerID, MissileTargetingKit, HostileSpellVisualID, CasterSpellVisualID, SpellVisualMissileSetID, "
1647 "DamageNumberDelay, LowViolenceSpellVisualID, RaidSpellVisualMissileSetID, ReducedUnexpectedCameraMovementSpellVisualID FROM spell_visual"
1653 "Alpha, Flags, TextureFileDataID, EffectRadius, Type, GenericID, RibbonQualityID, DissolveEffectID, ModelPosition, Unknown901"
1654 " FROM spell_visual_effect_name WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1659 "SpellVisualEffectNameID, SoundEntriesID, Attachment, DestinationAttachment, CastPositionerID, ImpactPositionerID, FollowGroundHeight, "
1660 "FollowGroundDropSpeed, FollowGroundApproach, Flags, SpellMissileMotionID, AnimKitID, ClutterLevel, DecayTimeAfterImpact, "
1661 "SpellVisualMissileSetID FROM spell_visual_missile WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1666 " FROM spell_visual_kit WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1671 "ActiveIconFileID, ViewerUnitConditionID, ViewerPlayerConditionID, CasterUnitConditionID, CasterPlayerConditionID, SpellID"
1672 " FROM spell_x_spell_visual WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1681 PrepareStatement(
HOTFIX_SEL_TACT_KEY,
"SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, "
1686 PrepareStatement(
HOTFIX_SEL_TALENT,
"SELECT ID, Description, TierID, Flags, ColumnIndex, ClassID, SpecID, SpellID, OverridesSpellID, "
1687 "CategoryMask1, CategoryMask2 FROM talent WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1692 PrepareStatement(
HOTFIX_SEL_TAXI_NODES,
"SELECT Name, PosX, PosY, PosZ, MapOffsetX, MapOffsetY, FlightMapOffsetX, FlightMapOffsetY, ID, "
1693 "ContinentID, ConditionID, CharacterBitNumber, Flags, UiTextureKitID, MinimapAtlasMemberID, Facing, SpecialIconConditionID, "
1694 "VisibilityConditionID, MountCreatureID1, MountCreatureID2 FROM taxi_nodes WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1703 PrepareStatement(
HOTFIX_SEL_TAXI_PATH_NODE,
"SELECT LocX, LocY, LocZ, ID, PathID, NodeIndex, ContinentID, Flags, Delay, ArrivalEventID, "
1704 "DepartureEventID FROM taxi_path_node WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1724 "TraitNodeID, TraitCurrencyID, SpentAmountRequired, Flags, RequiredLevel, FreeSharedStringID, SpendMoreSharedStringID FROM trait_cond"
1738 "TraitNodeEntryID, OrderIndex FROM trait_currency_source WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1745 "OverridesSpellID, VisibleSpellID FROM trait_definition WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1748 " FROM trait_definition_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?",
CONNECTION_SYNCH);
1752 " FROM trait_definition_effect_points WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1815 "Unused1000_3 FROM trait_tree WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1825 "OrderIndex FROM trait_tree_loadout_entry WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1845 "ParentTransmogSetID, Unknown810, ExpansionID, PatchID, UiOrder, PlayerConditionID FROM transmog_set WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1872 "VisibilityPlayerConditionID2, VisibilityPlayerConditionID, HelpTextPosition, BkgAtlasID, AlternateUiMapGroup, ContentTuningID FROM ui_map"
1878 PrepareStatement(
HOTFIX_SEL_UI_MAP_ASSIGNMENT,
"SELECT UiMinX, UiMinY, UiMaxX, UiMaxY, Region1X, Region1Y, Region1Z, Region2X, Region2Y, "
1879 "Region2Z, ID, UiMapID, OrderIndex, MapID, AreaID, WmoDoodadPlacementID, WmoGroupID FROM ui_map_assignment WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1883 PrepareStatement(
HOTFIX_SEL_UI_MAP_LINK,
"SELECT UiMinX, UiMinY, UiMaxX, UiMaxY, ID, ParentUiMapID, OrderIndex, ChildUiMapID, PlayerConditionID, "
1884 "OverrideHighlightFileDataID, OverrideHighlightAtlasID, Flags FROM ui_map_link WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1893 "BottomLeftFeatureDesc, RightFeatureTitle, RightFeatureDesc, AllianceQuestID, HordeQuestID, ScreenType, TextureKitID, SoundKitID, "
1894 "PlayerConditionID, CharLevelConditionID, RequiredTimeEventPassed FROM ui_splash_screen WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1897 "BottomLeftFeatureTitle_lang, BottomLeftFeatureDesc_lang, RightFeatureTitle_lang, RightFeatureDesc_lang FROM ui_splash_screen_locale"
1901 PrepareStatement(
HOTFIX_SEL_UNIT_CONDITION,
"SELECT ID, Flags, Variable1, Variable2, Variable3, Variable4, Variable5, Variable6, Variable7, "
1902 "Variable8, Op1, Op2, Op3, Op4, Op5, Op6, Op7, Op8, Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8 FROM unit_condition"
1907 PrepareStatement(
HOTFIX_SEL_UNIT_POWER_BAR,
"SELECT ID, Name, Cost, OutOfError, ToolTip, MinPower, MaxPower, StartPower, CenterPower, "
1908 "RegenerationPeace, RegenerationCombat, BarType, Flags, StartInset, EndInset, FileDataID1, FileDataID2, FileDataID3, FileDataID4, "
1909 "FileDataID5, FileDataID6, Color1, Color2, Color3, Color4, Color5, Color6 FROM unit_power_bar WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1916 "CameraFadeDistScalarMin, CameraFadeDistScalarMax, CameraPitchOffset, FacingLimitRight, FacingLimitLeft, CameraYawOffset, "
1917 "VehicleUIIndicatorID, MissileTargetingID, VehiclePOITypeID, SeatID1, SeatID2, SeatID3, SeatID4, SeatID5, SeatID6, SeatID7, SeatID8, "
1918 "PowerDisplayID1, PowerDisplayID2, PowerDisplayID3 FROM vehicle WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1923 "CameraOffsetZ, Flags, FlagsB, FlagsC, AttachmentID, EnterPreDelay, EnterSpeed, EnterGravity, EnterMinDuration, EnterMaxDuration, "
1924 "EnterMinArcHeight, EnterMaxArcHeight, EnterAnimStart, EnterAnimLoop, RideAnimStart, RideAnimLoop, RideUpperAnimStart, RideUpperAnimLoop, "
1925 "ExitPreDelay, ExitSpeed, ExitGravity, ExitMinDuration, ExitMaxDuration, ExitMinArcHeight, ExitMaxArcHeight, ExitAnimStart, ExitAnimLoop, "
1926 "ExitAnimEnd, VehicleEnterAnim, VehicleEnterAnimBone, VehicleExitAnim, VehicleExitAnimBone, VehicleRideAnimLoop, VehicleRideAnimLoopBone, "
1927 "PassengerAttachmentID, PassengerYaw, PassengerPitch, PassengerRoll, VehicleEnterAnimDelay, VehicleExitAnimDelay, VehicleAbilityDisplay, "
1928 "EnterUISoundID, ExitUISoundID, UiSkinFileDataID, CameraEnteringDelay, CameraEnteringDuration, CameraExitingDelay, CameraExitingDuration, "
1929 "CameraPosChaseRate, CameraFacingChaseRate, CameraEnteringZoom, CameraSeatZoomMin, CameraSeatZoomMax, EnterAnimKitID, RideAnimKitID, "
1930 "ExitAnimKitID, VehicleEnterAnimKitID, VehicleRideAnimKitID, VehicleExitAnimKitID, CameraModeID FROM vehicle_seat"
1936 "MinHeight, VignetteType, RewardQuestID, UiWidgetSetID FROM vignette WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1942 "AmbienceID, UwAmbience, ZoneMusic, UwZoneMusic, IntroSound, UwIntroSound, AreaTableID, Flags FROM wmo_area_table"
1949 "CombatConditionID FROM world_effect WHERE (`VerifiedBuild` > 0) = ?",
CONNECTION_SYNCH);
1954 "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_MAIL_TEMPLATE
@ 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_WORLD_MAP_OVERLAY
@ HOTFIX_SEL_ITEM_BONUS_TREE
@ HOTFIX_SEL_FACTION_TEMPLATE
@ HOTFIX_SEL_TRAIT_TREE_X_TRAIT_CURRENCY
@ HOTFIX_SEL_ARTIFACT_QUEST_XP
@ HOTFIX_SEL_ARTIFACT_POWER_RANK
@ HOTFIX_SEL_ITEM_DAMAGE_AMMO
@ 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_SUMMON_PROPERTIES
@ 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_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_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_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_TRAIT_NODE_ENTRY_X_TRAIT_COST
@ HOTFIX_SEL_ARTIFACT_UNLOCK
@ 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_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_EXPECTED_STAT_MOD
@ HOTFIX_SEL_ITEM_BONUS_LIST_GROUP_ENTRY
@ 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_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_ITEM_LEVEL_SELECTOR_QUALITY_SET
@ HOTFIX_SEL_RAND_PROP_POINTS
@ 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_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_BANK_BAG_SLOT_PRICES
@ 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_EXPECTED_STAT
@ HOTFIX_SEL_BARBER_SHOP_STYLE
@ 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_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_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_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_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_CHALLENGE_MODE_ITEM_BONUS_OVERRIDE
@ HOTFIX_SEL_PLAYER_CONDITION
@ MAX_HOTFIXDATABASE_STATEMENTS
@ 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_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_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?