Sniffing & Parsing

Owned by Heaven31415
Last updated: sept 25, 2021 by MDic
8 min read

This guide is to assist in obtaining thorough sniffs with ymir.

This guide is written to assume you are familiar with both setting up and running the ymir sniffer at: https://github.com/TrinityCore/ymir
Parsing deals with the translations of sniffs with the tool, Instructions and software at: https://github.com/TrinityCore/WowPacketParser

Disclaimer: There is no guaranteed safe way to gather sniffs, and you may face an account ban or suspension. Do this only at your own risk of your account and lost invested progress.


*Starting off

Ensure proper version of the sniffer is obtained and running before you start your wow client.

Ensure your wow cache folder is cleared before starting your wow client.

Start the game and login


*What is sniffed while logging and playing


At Login:
Everything from your ACCOUNT information, such as user name, Full name for billing, expansions authorization, bnet friends list, and bshop transactions is logged and registered.


At Character Creation\Character selection:
Character names\ class\race variations is logged durning sniffing. Realm Information is as well.


At Game play following realm login:

Area information is logged that is within visible range. Stuff such as npcs, gameobjects, attack rotations, spells, holiday stuff, phases, various stats, gossips, cutscene triggers, spells, auras, phases, and placements.

Overall:

Anything that causes a packet send or received gets logged by the sniffer.


Where to send the sniffs to help contribute to Trinitycore:
https://community.trinitycore.org/forum/13-wdbadbsniffs


Warning: Do not sell or publically post your pkt file as it contains highly sensitive information identifying the sniffing account used, from ip address, billing name, friends list, and various other personal information you do not want to have released on the internet.


*Obtaining Specifics being logged.


NPCs:

Display id: Just be in visual range

Stats: Visual range.

Broadcasting random speech: Ensure you are in visible range.

Emotes: Ensure you are in visible range.

Equipment \ gear load out: Just be in visual range

NPC flag: Visual Range and must be interacted with.

Gossips: Must be interacted with, Each gossip option must be clicked on.

Professions list: Must be interacted with and view, does not have to be bought.

Vendor List: Must be interacted with and view, does not have to be bough.

Quest Start \ Quest End: Must be in visible range with the ! Or ? Showing. Best interacted with to ensure proper quest name is showed.

Loot: Kill the npc and loot. We get most accurate loot results depending on how many sniffs we get or something like that is more accurate, such as data mining like how wowhead does it, since a single person will never kill a mob a thousand times.

Spells ID and Effects and Visuals: Visual range, and if possible, be receiving victim

Attack Rotation: Visual Range.

Scripting: Visual Range, and \ or interaction.

Waypoints: Just be in visual range however you may be required to stalk the npc to ensure accurate points and scripted random scenes are logged.


Gameobjects:
Display id: Just be in visual range

Gameobject Flag: Visual Range and must be interacted with.
Gameobject Gossip: Must be interacted with, Each gossip option must be clicked on.

Type: Just be in visual range if none interactive, if interactive, you will need to click it.

Gossips: Must be interacted with, Each gossip option must be clicked on.

Quest Start \ End: Must be in visible range with the ! Or ? Showing. Best interacted with to ensure proper quest name is showed.

Loot: Must be interacted, if profession related, must have profession to view loot. We get most accurate loot results depending on how many sniffs we get or something like that is more accurate, such as data mining like how wowhead does it, since a single person will never loot a game object a thousand times.

Scripting: Visual Range, and \ or interaction.

Waypoints: Just be in visual range however you may be required to stalk\ride the transport \ flight path to ensure accurate points and scripted random scenes are logged.


Pets:

Same as NPCs with a few exceptions:

Abilities: Must be captured and pet journal viewed.

Stats: Must be viewed as they will vary by rarity and zones.

Mounts:

Same as NPCs with a few exceptions:

Select stats: Mount must be used to have their stats logged

Restrictions: Mount must be used to view restrictions that are allowed or denied or both


Items:

Same as Gameobjects with a few exceptions:

Quests Start \ In-progressed \ End: Use the item, and \ or have in possession for quest progression.

Spell Item: Item must be used

Charges: Item only has to be viewed or in possession

Restrictions: Item only has to be viewed or in possessions


Spells and Auras:

Player spells: Must be both acquired and used

Stats and display and Effects: Must be used and \ or Viewed with in Visible range.

Receiving effects: Must be cast on self or target from the caster who is sniffing.

Damaging effects: Must be cast on self or target from the caster who is sniffing.


Quests:

Flags: Quest must be accepted. Accept and abandon and Accept to ensure phasing is captured if any.

Quest Rewards: Quest must be accepted and completed at turn in to ensure special boosted is logged.

POI \ Bread Crumbs: Quest Must be accepted and in progress. View the Map to ensure area pois are registered.


Phasing:

Quest Phase ids: If special phasing, take and abandon quest and retake to ensure logging. If possible.

NPC Phase Ids: If special phasing, take and abandon quest and retake to ensure logging. If possible.

Gameobject Phase Ids: If special phasing, take and abandon quest and retake to ensure logging. If possible.


Transport\Map\Zone\Area:

Ids: just be present in the map\zone\id for the id to be logged.

Spell id: Must be present before, during, and \ or after spell effect of the area is present. Which every occurrence it may be. (Bizmo Brawl Pub is a good example as you need the brawler invite consumed to be present in the area. Horde Brawler Arena as they have a vip blimp.)

Calendar\UI:

Anything dealing with these must be viewed and interacted with.

Transmogs:

Anything dealing with these must be obtained and viewed from the journal or transmongifer.


Fields that are Sniffed

Tables and Fields thats are sniffed out (Targeted DB SL Master): Not all tables and fields listed as of yet.

  • achievement:
    `Description`, `Title`, `Reward`, `ID`, `InstanceID`, `Faction`, `Supercedes`, `Category`, `MinimumCriteria`, `Points`, `Flags`, `UiOrder`, `IconFileID`, `RewardItemID`, `CriteriaTree`, `SharesCriteria`, `CovenantID`, `VerifiedBuild`
  • broadcast_text:
    `Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `SoundEntriesID1`, `SoundEntriesID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`
  • cfg_regions:
    `ID`, `Tag`, `RegionID`, `Raidorigin`, `RegionGroupMask`, `ChallengeOrigin`, `VerifiedBuild`
  • creature:
    `guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`
  • creature_addon:
    `guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`
  • creature_equip_template:
    `CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`
  • creature_model_info:
    `DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`
  • creature_template: (one is data from creature query response (same data which is saved in wdb cache))
    `entry`, `gossip_menu_id`, `minlevel`, `maxlevel`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `BaseAttackTime`, `RangeAttackTime`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `VehicleId`, `HoverHeight`
  • creature_template: (Yes i am aware there is a creature_template above mentioned already but two is shown during parsing, (dynamic data, seen in update fields for mobs of this entry) May the odds forever be in your favor)
    `entry`, `KillCredit1`, `KillCredit2`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `HealthScalingExpansion`, `RequiredExpansion`, `VignetteID`, `unit_class`, `WidgetSetID`, `WidgetSetUnitConditionID`, `rank`, `family`, `type`, `type_flags`, `type_flags2`, `HealthModifier`, `ManaModifier`, `RacialLeader`, `movementId`, `CreatureDifficultyID`, `VerifiedBuild`
  • creature_template_addon:
    `entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`
  • creature_template_model:
    `CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`
  • creature_template_scaling:
    `Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`
  • creature_text:
    `CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`
  • creature_trainer:
    `CreatureId`, `TrainerId`, `MenuID`, `OptionIndex`
  • criteria_tree: 
    `ID`, `Description`, `Parent`, `Amount`, `Operator`, `CriteriaID`, `OrderIndex`, `Flags`, `VerifiedBuild`
  • currency_types:
    `ID`, `Name`, `Description`, `CategoryID`, `InventoryIconFileID`, `SpellWeight`, `SpellCategory`, `MaxQty`, `MaxEarnablePerWeek`, `Quality`, `FactionID`, `ItemGroupSoundsID`, `XpQuestDifficulty`, `AwardConditionID`, `MaxQtyWorldStateID`, `Flags1`, `Flags2`, `VerifiedBuild`
  • curve:
    `ID`, `Type`, `Flags`, `VerifiedBuild`
  • curve_point:
    `ID`, `PosX`, `PosY`, `PosPreSquishX`, `PosPreSquishY`, `CurveID`, `OrderIndex`, `VerifiedBuild`
  • dungeon_encounter:
    `Name`, `ID`, `MapID`, `DifficultyID`, `OrderIndex`, `CompleteWorldStateID`, `Bit`, `CreatureDisplayID`, `Flags`, `SpellIconFileID`, `Faction`, `VerifiedBuild`
  • gameobject:
    `guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`
  • gameobject_addon:
    `guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`
  • gameobject_questitem:
    `GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`
  • gameobject_template:
    `entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `ContentTuningId`, `VerifiedBuild`
  • gameobject_template_addon:
    `entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`
  • gossip_menu:
    `MenuId`, `TextId`, `VerifiedBuild`
  • gossip_menu_option:
    `MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`
  • gossip_menu_option_action:
    `MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`
  • hotfix_blob:
    `TableHash`, `RecordId`, `locale`, `Blob`, `VerifiedBuild`
  • hotfix_data:
    `Id`, `TableHash`, `RecordId`, `Status`, `VerifiedBuild`
  • hotfix_optional_data:
    `TableHash`, `RecordId`, `locale`, `Key`, `Data`, `VerifiedBuild
  • item:
    `ID`, `ClassID`, `SubclassID`, `Material`, `InventoryType`, `SheatheType`, `SoundOverrideSubclassID`, `IconFileDataID`, `ItemGroupSoundsID`, `ModifiedCraftingReagentItemID`, `VerifiedBuild`
  • item_spec_override:
    `ID`, `SpecID`, `ItemID`, `VerifiedBuild
  • item_search_name:
    `ID`, `AllowableRace`, `Display`, `OverallQualityID`, `ExpansionID`, `MinFactionID`, `MinReputation`, `AllowableClass`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredAbility`, `ItemLevel`, `Flags1`, `Flags2`, `Flags3`, `Flags4`, `VerifiedBuild`
  • item_sparse:
    `ID`, `AllowableRace`, `Description`, `Display3`, `Display2`, `Display1`, `Display`, `ExpansionID`, `DmgVariance`, `LimitCategory`, `DurationInInventory`, `QualityModifier`, `BagFamily`, `ItemRange`, `StatPercentageOfSocket1`, `StatPercentageOfSocket2`, `StatPercentageOfSocket3`, `StatPercentageOfSocket4`, `StatPercentageOfSocket5`, `StatPercentageOfSocket6`, `StatPercentageOfSocket7`, `StatPercentageOfSocket8`, `StatPercentageOfSocket9`, `StatPercentageOfSocket10`, `StatPercentEditor1`, `StatPercentEditor2`, `StatPercentEditor3`, `StatPercentEditor4`, `StatPercentEditor5`, `StatPercentEditor6`, `StatPercentEditor7`, `StatPercentEditor8`, `StatPercentEditor9`, `StatPercentEditor10`, `Stackable`, `MaxCount`, `RequiredAbility`, `SellPrice`, `BuyPrice`, `VendorStackCount`, `PriceVariance`, `PriceRandomValue`, `Flags1`, `Flags2`, `Flags3`, `Flags4`, `FactionRelated`, `ModifiedCraftingReagentItemID`, `ContentTuningID`, `PlayerLevelToItemLevelCurveID`, `ItemNameDescriptionID`, `RequiredTransmogHoliday`, `RequiredHoliday`, `GemProperties`, `SocketMatchEnchantmentId`, `TotemCategoryID`, `InstanceBound`, `ZoneBound1`, `ZoneBound2`, `ItemSet`, `LockID`, `StartQuestID`, `PageID`, `ItemDelay`, `MinFactionID`, `RequiredSkillRank`, `RequiredSkill`, `ItemLevel`, `AllowableClass`, `ArtifactID`, `SpellWeight`, `SpellWeightCategory`, `SocketType1`, `SocketType2`, `SocketType3`, `SheatheType`, `Material`, `PageMaterialID`, `LanguageID`, `Bonding`, `DamageDamageType`, `StatModifierBonusStat1`, `StatModifierBonusStat2`, `StatModifierBonusStat3`, `StatModifierBonusStat4`, `StatModifierBonusStat5`, `StatModifierBonusStat6`, `StatModifierBonusStat7`, `StatModifierBonusStat8`, `StatModifierBonusStat9`, `StatModifierBonusStat10`, `ContainerSlots`, `MinReputation`, `RequiredPVPMedal`, `RequiredPVPRank`, `RequiredLevel`, `InventoryType`, `OverallQualityID`, `VerifiedBuild`
  • item_bonus_tree_node:
    `ID`, `ItemContext`, `ChildItemBonusTreeID`, `ChildItemBonusListID`, `ChildItemLevelSelectorID`, `ItemBonusListGroupID`, `ParentItemBonusTreeNodeID`, `ParentItemBonusTreeID`, `VerifiedBuild`
  • item_level_selector:
    `ID`, `MinItemLevel`, `ItemLevelSelectorQualitySetID`, `AzeriteUnlockMappingSet`, `VerifiedBuild`
  • item_modified_appearance:
    `ID`, `ItemID`, `ItemAppearanceModifierID`, `ItemAppearanceID`, `OrderIndex`, `TransmogSourceTypeEnum`, `VerifiedBuild`
  • mount:
    `Name`, `SourceText`, `Description`, `ID`, `MountTypeID`, `Flags`, `SourceTypeEnum`, `SourceSpellID`, `PlayerConditionID`, `MountFlyRideHeight`, `UiModelSceneID`, `MountSpecialRiderAnimKitID`, `MountSpecialSpellVisualKitID`, `VerifiedBuild`
  • npc_spellclick_spells:
    `npc_entry`, `spell_id`, `cast_flags`, `user_type`
  • npc_text:
    `ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`
  • npc_vendor:
    `entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`
  • object_names:
    `ObjectType`, `Id`, `Name`
  • page_text:
    `ID`, `Text`, `NextPageID`, `PlayerConditionID`, `Flags`, `VerifiedBuild`
  • player_condition:
    `ID`, `RaceMask`, `FailureDescription`, `ClassMask`, `SkillLogic`, `LanguageID`, `MinLanguage`, `MaxLanguage`, `MaxFactionID`, `MaxReputation`, `ReputationLogic`, `CurrentPvpFaction`, `PvpMedal`, `PrevQuestLogic`, `CurrQuestLogic`, `CurrentCompletedQuestLogic`, `SpellLogic`, `ItemLogic`, `ItemFlags`, `AuraSpellLogic`, `WorldStateExpressionID`, `WeatherID`, `PartyStatus`, `LifetimeMaxPVPRank`, `AchievementLogic`, `Gender`, `NativeGender`, `AreaLogic`, `LfgLogic`, `CurrencyLogic`, `QuestKillID`, `QuestKillLogic`, `MinExpansionLevel`, `MaxExpansionLevel`, `MinAvgItemLevel`, `MaxAvgItemLevel`, `MinAvgEquippedItemLevel`, `MaxAvgEquippedItemLevel`, `PhaseUseFlags`, `PhaseID`, `PhaseGroupID`, `Flags`, `ChrSpecializationIndex`, `ChrSpecializationRole`, `ModifierTreeID`, `PowerType`, `PowerTypeComp`, `PowerTypeValue`, `WeaponSubclassMask`, `MaxGuildLevel`, `MinGuildLevel`, `MaxExpansionTier`, `MinExpansionTier`, `MinPVPRank`, `MaxPVPRank`, `ContentTuningID`, `CovenantID`, `SkillID1`, `SkillID2`, `SkillID3`, `SkillID4`, `MinSkill1`, `MinSkill2`, `MinSkill3`, `MinSkill4`, `MaxSkill1`, `MaxSkill2`, `MaxSkill3`, `MaxSkill4`, `MinFactionID1`, `MinFactionID2`, `MinFactionID3`, `MinReputation1`, `MinReputation2`, `MinReputation3`, `PrevQuestID1`, `PrevQuestID2`, `PrevQuestID3`, `PrevQuestID4`, `CurrQuestID1`, `CurrQuestID2`, `CurrQuestID3`, `CurrQuestID4`, `CurrentCompletedQuestID1`, `CurrentCompletedQuestID2`, `CurrentCompletedQuestID3`, `CurrentCompletedQuestID4`, `SpellID1`, `SpellID2`, `SpellID3`, `SpellID4`, `ItemID1`, `ItemID2`, `ItemID3`, `ItemID4`, `ItemCount1`, `ItemCount2`, `ItemCount3`, `ItemCount4`, `Explored1`, `Explored2`, `Time1`, `Time2`, `AuraSpellID1`, `AuraSpellID2`, `AuraSpellID3`, `AuraSpellID4`, `AuraStacks1`, `AuraStacks2`, `AuraStacks3`, `AuraStacks4`, `Achievement1`, `Achievement2`, `Achievement3`, `Achievement4`, `AreaID1`, `AreaID2`, `AreaID3`, `AreaID4`, `LfgStatus1`, `LfgStatus2`, `LfgStatus3`, `LfgStatus4`, `LfgCompare1`, `LfgCompare2`, `LfgCompare3`, `LfgCompare4`, `LfgValue1`, `LfgValue2`, `LfgValue3`, `LfgValue4`, `CurrencyID1`, `CurrencyID2`, `CurrencyID3`, `CurrencyID4`, `CurrencyCount1`, `CurrencyCount2`, `CurrencyCount3`, `CurrencyCount4`, `QuestKillMonster1`, `QuestKillMonster2`, `QuestKillMonster3`, `QuestKillMonster4`, `QuestKillMonster5`, `QuestKillMonster6`, `MovementFlags1`, `MovementFlags2`, `VerifiedBuild`
  • playerchoice:
    `ChoiceId`, `UiTextureKitId`, `SoundKitId`, `Question`, `HideWarboardHeader`, `KeepOpenAfterChoice`, `VerifiedBuild`
  • playerchoice_response:
    `ChoiceId`, `ResponseId`, `ResponseIdentifier`, `Index`, `ChoiceArtFileId`, `Flags`, `WidgetSetId`, `UiTextureAtlasElementID`, `SoundKitId`, `GroupId`, `Header`, `Subheader`, `ButtonTooltip`, `Answer`, `Description`, `Confirmation`, `RewardQuestID`, `UiTextureKitID`, `VerifiedBuild`
  • playercreateinfo:
    `race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`
  • points_of_interest:
    `ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `VerifiedBuild`
  • quest_details:
    `ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`
  • quest_greeting:
    `ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`
  • quest_objectives:
    `ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`
  • quest_offer_reward:
    `ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`
  • quest_poi:
    `QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `UiMapID`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `NavigationPlayerConditionID`, `SpawnTrackingID`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`
  • quest_poi_points:
    `QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `Z`, `VerifiedBuild`
  • quest_request_items:
    `ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`
  • quest_template:
    `ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`
  • quest_v2:
     `ID`, `UniqueBitFlag`, `VerifiedBuild`
  • quest_visual_effect:
    `ID`, `Index`, `VisualEffect`, `VerifiedBuild`
  • sniff_data:
    `Build`, `SniffName`, `ObjectType`, `Id`, `Data`
  • spell_aura_options:
    `ID`, `DifficultyID`, `CumulativeAura`, `ProcCategoryRecovery`, `ProcChance`, `ProcCharges`, `SpellProcsPerMinuteID`, `ProcTypeMask1`, `ProcTypeMask2`, `SpellID`, `VerifiedBuild`
  • spell_aura_restrictions:
    `ID`, `DifficultyID`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `SpellID`, `VerifiedBuild`
  • spell_categories:
    `ID`, `DifficultyID`, `Category`, `DefenseType`, `DispelType`, `Mechanic`, `PreventionType`, `StartRecoveryCategory`, `ChargeCategory`, `SpellID`, `VerifiedBuild`
  • spell_cooldowns:
    `ID`, `DifficultyID`, `CategoryRecoveryTime`, `RecoveryTime`, `StartRecoveryTime`, `SpellID`, `VerifiedBuild`
  • spell_effect:
    `ID`, `EffectAura`, `DifficultyID`, `EffectIndex`, `Effect`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `ScalingClass`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`, `SpellID`, `VerifiedBuild`
  • spell_name: 
    `ID`, `Name`, `VerifiedBuild`
  • spell_misc:
    `ID`, `Attributes1`, `Attributes2`, `Attributes3`, `Attributes4`, `Attributes5`, `Attributes6`, `Attributes7`, `Attributes8`, `Attributes9`, `Attributes10`, `Attributes11`, `Attributes12`, `Attributes13`, `Attributes14`, `Attributes15`, `DifficultyID`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `SchoolMask`, `Speed`, `LaunchDelay`, `MinDuration`, `SpellIconFileDataID`, `ActiveIconFileDataID`, `ContentTuningID`, `ShowFutureSpellPlayerConditionID`, `SpellVisualScript`, `ActiveSpellVisualScript`, `SpellID`, `VerifiedBuild`
  • spell_target_restrictions:
    `ID`, `DifficultyID`, `ConeDegrees`, `MaxTargets`, `MaxTargetLevel`, `TargetCreatureType`, `Targets`, `Width`, `SpellID`, `VerifiedBuild`
  • summon_properties:
    `ID`, `Control`, `Faction`, `Title`, `Slot`, `Flags`, `VerifiedBuild`
  • tact_key:
    `ID`, `Key1`, `Key2`, `Key3`, `Key4`, `Key5`, `Key6`, `Key7`, `Key8`, `Key9`, `Key10`, `Key11`, `Key12`, `Key13`, `Key14`, `Key15`, `Key16`, `VerifiedBuild`
  • toy:
    `SourceText`, `ID`, `ItemID`, `Flags`, `SourceTypeEnum`, `VerifiedBuild`
  • trainer:
    `Id`, `Type`, `Greeting`, `VerifiedBuild`
  • trainer_spell:
    `TrainerId`, `SpellId`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqAbility1`, `ReqAbility2`, `ReqAbility3`, `ReqLevel`, `VerifiedBuild`
  • vehicle_template_accessory:
    entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`
  • weather_update:
    `map_id`, `zone_id`, `weather_state`, `grade`, `unk`