TrinityCore / WowPacketParser

World of Warcraft Packet Parser
GNU General Public License v3.0
410 stars 352 forks source link

Error In Extraction WPP commit 9ab1f15 #317

Closed Taaboy closed 5 years ago

Taaboy commented 7 years ago

Used 3 version of sniffs 22937 , 24014 , 24330 Config File Setting, DB running

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <section name="Hotfix" type="WowPacketParser.Hotfix.HotfixSection, WowPacketParser" />
    </configSections>
    <appSettings>
        <!--
             Option:      Filters
             Description: List of strings separated by comma. Any opcode name that matches any of these filters will be parsed
             Default:     "" (All)
        -->
        <add key="Filters" value=""/>

        <!--
             Option:      IgnoreFilters
             Description: List of strings separated by comma. Any opcode name that matches any of these filters will be ignored
                          If one opcode matches Filters and IgnoreFilters at same time it will be ignored
             Default:     "" (None)
        -->
        <add key="IgnoreFilters" value=""/>

        <!--
             Option:      IgnoreByEntryFilters
             Description: List of List of Entries not to be included in output file. Any opcode that contains any of these entries will be ignored
             Format:      Type:Id1:Id2:Id3,Type2:Id4:Id5:Id6
             Example:     Unit:5000:10000:60000,Player:0
             Default:     "" (None)
        -->
        <add key="IgnoreByEntryFilters" value=""/>

        <!--
             Option:      AreaFilters
             Description: List of strings separated by comma. Any creature/gameobject spawn that matches any of these filters
                          will be dumped to sql file if creature/gameobject sql option is enabled
             Default:     "" (None)
        -->
        <add key="AreaFilters" value=""/>

        <!--
               Option:      MapFilters
               Description: List of strings separated by comma. Any creature/gameobject spawn that matches any of these filters
                            will be dumped to sql file if creature/gameobject sql option is enabled
               Default:     "" (None)
          -->
        <add key="MapFilters" value=""/>

        <!--
             Option:      FilterPacketsNum
             Description: Number of packets to read.
                          If this value is negative and DumpFormat is set to 2 (Binary (.pkt)), a number of .pkt files will be
                          created containing this value in number of packets (last .pkt created can have less packets than
                          the number defined by this value).
             Default:     "0" (All)
        -->
        <add key="FilterPacketsNum" value="0"/>

        <!--
             Option:      ClientBuild
             Description: Force client build version
             Default:     "" (Autodetect - build is calculated based on the date of sniff)
        -->
        <add key="ClientBuild" value=""/>

        <!--
             Option:      TargetedDatabase
             Description: Sets the database version for which the SQL output should be produced.
             Default:     "1" (Wrath of the Lich King)
             Values:      1: Wrath of the Lich King
                          2: Cataclysm
                          3: Warlords of Draenor
                          4: Legion
        -->
      <add key="TargetedDatabase" value="4"/>

        <!--
             Option:      DumpFormat
             Description: Format to write to output file
             Default:     "1" (Text)
             Values:      0: No dump
                          1: Text + SQL (if enabled)
                          2: Binary (.pkt)
                          3: Binary (.pkt) split output in multiple files with opcode name
                          4: SQL Only
                          5: SniffData only (.sql)
                          6: Few statistics in CSV format (does not parse packets)
                          7: Binary (.pkt) split output in multiple files by session (TC sniffs only)
                          8: Compress sniff files (.gz extension)
                          9: Calculate version and move sniff to its own folder version
                          10: Hex & packet header only
                          11: Binary (.pkt) split output in multiple files by direction
                          12: Output info about packet's connection indexes (<name>_connidx.txt)
                          13: Binary (.pkt) merge output in a file (fusion.pkt)
        -->
        <add key="DumpFormat" value="1"/>

      <!--
             Option:      SQLOutput
             Description: "true" defines if SQL file created contains a specific table, "false" otherwise

             Default:     "false" (No SQL output for specific table)
        -->
        <add key="ObjectNames"                            value="false"/>
        <add key="SniffData"                              value="false"/>
        <add key="SniffDataOpcodes"                       value="false"/>

        <add key="areatrigger_template"                   value="false"/>
        <add key="areatrigger_template_polygon_vertices"  value="false"/>
        <add key="broadcast_text"                         value="false"/>
        <add key="creature"                               value="false"/>
        <add key="creature_addon"                         value="false"/>
        <add key="creature_equip_template"                value="true"/>
        <add key="creature_model_info"                    value="true"/>
        <add key="creature_template"                      value="true"/>
        <add key="creature_template_addon"                value="true"/>
        <add key="creature_text"                          value="false"/>
        <add key="gameobject"                             value="false"/>
        <add key="gameobject_addon"                       value="false"/>
        <add key="gameobject_template"                    value="false"/>
        <add key="gameobject_template_addon"              value="false"/>
        <add key="gossip_menu"                            value="false"/>
        <add key="gossip_menu_option"                     value="false"/>
        <add key="item_template"                          value="false"/>
        <add key="locales_quest"                          value="false"/>
        <add key="locales_quest_objectives"               value="false"/>
        <add key="npc_spellclick_spells"                  value="false"/>
        <add key="npc_text"                               value="false"/>
        <add key="npc_trainer"                            value="false"/>
        <add key="npc_vendor"                             value="false"/>
        <add key="page_text"                              value="false"/>
        <add key="playercreateinfo"                       value="false"/>
        <add key="playercreateinfo_action"                value="false"/>
        <add key="points_of_interest"                     value="false"/>
        <add key="quest_poi"                              value="false"/>
        <add key="quest_poi_points"                       value="false"/>
        <add key="quest_template"                         value="false"/>
        <add key="scene_template"                         value="false"/>
        <add key="spell_target_position"                  value="false"/>
        <add key="spell_areatrigger"                      value="false"/>
        <add key="vehicle_template_accessory"             value="false"/>
        <add key="weather_updates"                        value="false"/>

        <add key="hotfix_data"                            value="false"/>

        <!--
             Option:      SQLFileName
             Description: Sets the file to write all sql data to. If is not set each file parsed will write it's own sql file
             Default:     "" (No global sql file output)
        -->
        <add key="SQLFileName" value="SQLUpdate.sql"/>

        <!--
             Option:      SQLOrderByKey
             Description: Order Sql Output by key
             Default:     "false" (No prompt)
        -->
        <add key="SQLOrderByKey" value="false"/>

        <!--
             Option:      SkipOnlyVerifiedBuildUpdateRows
             Description: Ship only VerifiedBuild row in update querys
             Default:     "false"
        -->
        <add key="SkipOnlyVerifiedBuildUpdateRows" value="false"/>

        <!--
             Option:      ShowEndPrompt
             Description: Show end prompt after parsing all files
             Default:     "false" (No prompt)
        -->
        <add key="ShowEndPrompt" value="false"/>

        <!--
             Option:      LogErrors
             Description: Log ReadEnum errors (Missing enum values)
             Default:     "false" (No enum errors log)
        -->
        <add key="LogErrors" value="true"/>

        <!--
             Option:      LogPacketErrors
             Description: Log packet headers that were skipped or have packet errors to <snifffile>_errors.txt
             Default:     "false" (No file created)
        -->
        <add key="LogPacketErrors" value="true"/>

        <!--
             Option:      OutputFlag
             Description: Configures what packets depending on parsing status are written to the .txt. 1 - Only success, 2 - Only with errors, 4 - Only skipped, 8 - Only wihtout structure
             Default:     "15" (Success, WithErrors, NotParsed and NoStructure)
        -->
        <add key="OutputFlag" value="15"/>

        <!--
             Option:      DebugReads
             Description: Show hexadecimal data when reading any numeric value
             Default:     "false" (Do not show hexadecimal output)
        -->
        <add key="DebugReads" value="false"/>

        <!--
             Option:      ParsingLog
             Description: Write to a text file what has been printed on console
             Default:     "false"
        -->
        <add key="ParsingLog" value="true"/>

        <!--
             Option:      Threads
             Description: Number of threads to parse packets. 0 is number of avail. processors.
             Default:     "1"
        -->
        <add key="Threads" value="1"/>

          <!--
                 Option:      UseDBC
                 Description: Use DBC/DB2
                 Default:     "false" (No prompt)
            -->
          <add key="UseDBC" value="true"/>

          <!--
                 Option:      DbcPath
                 Description: Set DBC/DB2 Path
                 Default:     "\dbc" (No prompt)
            -->
          <add key="DBCPath" value="\dbc"/>

          <!--
                 Option:      DbcLocale
                 Description: Set DBC/DB2 Locales
                 Default:     "enUS"
            -->
          <add key="DBCLocale" value="enUS"/>

          <!--
                 Option:      ParseSpellInfos
                 Description: Parse spell infos to output file (only *.txt)
                 Default:     "false" (No prompt)
            -->
          <add key="ParseSpellInfos" value="false"/>

        <!-- SSH Tunneling settings -->
        <add key="SSHEnabled"         value="false" />
        <add key="SSHHost"            value="" />
        <add key="SSHUsername"        value="" />
        <add key="SSHPassword"        value="" />
        <add key="SSHPort"            value="22" />
        <add key="SSHLocalPort"       value="3307" />

        <!-- Database settings -->
        <add key="DBEnabled"          value="true" />
        <add key="Server"             value="localhost" />
        <add key="Port"               value="3306" />
        <add key="Username"           value="root" />
        <add key="Password"           value="ascent" />
        <add key="WPPDatabase"        value="wpp" />
        <add key="TDBDatabase"        value="xworld" />
        <add key="HotfixesDatabase"   value="xhotfixes" />
        <add key="CharacterSet"       value="utf8" />
    </appSettings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
    </startup>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <probing privatePath="Parsers"/>
        </assemblyBinding>
    </runtime>

    <Hotfix>
        <FileHashes>
            <!--
                Collection of hotfix hashes
                Enabled is set to true by default

                Locales are autogenerated as long as the base is enabled.
            -->
            <HotfixElement FileHash="Achievement"                       Enabled="false" />
            <HotfixElement FileHash="AnimKit"                           Enabled="false" />
            <HotfixElement FileHash="AreaGroupMember"                   Enabled="false" />
            <HotfixElement FileHash="AreaTable"                         Enabled="false" />
            <HotfixElement FileHash="AreaTrigger"                       Enabled="false" />
            <HotfixElement FileHash="ArmorLocation"                     Enabled="false" />
            <HotfixElement FileHash="Artifact"                          Enabled="false" />
            <HotfixElement FileHash="ArtifactAppearance"                Enabled="false" />
            <HotfixElement FileHash="ArtifactAppearanceSet"             Enabled="false" />
            <HotfixElement FileHash="ArtifactCategory"                  Enabled="false" />
            <HotfixElement FileHash="ArtifactPower"                     Enabled="false" />
            <HotfixElement FileHash="ArtifactPowerLink"                 Enabled="false" />
            <HotfixElement FileHash="ArtifactPowerRank"                 Enabled="false" />
            <HotfixElement FileHash="ArtifactQuestXP"                   Enabled="false" />
            <HotfixElement FileHash="AuctionHouse"                      Enabled="false" />
            <HotfixElement FileHash="BankBagSlotPrices"                 Enabled="false" />
            <HotfixElement FileHash="BannedAddOns"                      Enabled="false" />
            <HotfixElement FileHash="BarberShopStyle"                   Enabled="false" />
            <HotfixElement FileHash="BattlePetBreedQuality"             Enabled="false" />
            <HotfixElement FileHash="BattlePetBreedState"               Enabled="false" />
            <HotfixElement FileHash="BattlePetSpecies"                  Enabled="false" />
            <HotfixElement FileHash="BattlePetSpeciesState"             Enabled="false" />
            <HotfixElement FileHash="BattlemasterList"                  Enabled="false" />
            <HotfixElement FileHash="BroadcastText"                     Enabled="false" />
            <HotfixElement FileHash="CharSections"                      Enabled="false" />
            <HotfixElement FileHash="CharStartOutfit"                   Enabled="false" />
            <HotfixElement FileHash="CharTitles"                        Enabled="false" />
            <HotfixElement FileHash="ChatChannels"                      Enabled="false" />
            <HotfixElement FileHash="ChrClasses"                        Enabled="false" />
            <HotfixElement FileHash="ChrClassesXPowerTypes"             Enabled="false" />
            <HotfixElement FileHash="ChrRaces"                          Enabled="false" />
            <HotfixElement FileHash="ChrSpecialization"                 Enabled="false" />
            <HotfixElement FileHash="CinematicCamera"                   Enabled="false" />
            <HotfixElement FileHash="CinematicSequences"                Enabled="false" />
            <HotfixElement FileHash="CreatureDifficulty"                Enabled="false" />
            <HotfixElement FileHash="CreatureDisplayInfo"               Enabled="false" />
            <HotfixElement FileHash="CreatureDisplayInfoExtra"          Enabled="false" />
            <HotfixElement FileHash="CreatureFamily"                    Enabled="false" />
            <HotfixElement FileHash="CreatureModelData"                 Enabled="false" />
            <HotfixElement FileHash="CreatureType"                      Enabled="false" />
            <HotfixElement FileHash="Criteria"                          Enabled="false" />
            <HotfixElement FileHash="CriteriaTree"                      Enabled="false" />
            <HotfixElement FileHash="CurrencyTypes"                     Enabled="false" />
            <HotfixElement FileHash="Curve"                             Enabled="false" />
            <HotfixElement FileHash="CurvePoint"                        Enabled="false" />
            <HotfixElement FileHash="DestructibleModelData"             Enabled="false" />
            <HotfixElement FileHash="Difficulty"                        Enabled="false" />
            <HotfixElement FileHash="DungeonEncounter"                  Enabled="false" />
            <HotfixElement FileHash="DurabilityCosts"                   Enabled="false" />
            <HotfixElement FileHash="DurabilityQuality"                 Enabled="false" />
            <HotfixElement FileHash="Emotes"                            Enabled="false" />
            <HotfixElement FileHash="EmotesText"                        Enabled="false" />
            <HotfixElement FileHash="EmotesTextSound"                   Enabled="false" />
            <HotfixElement FileHash="Faction"                           Enabled="false" />
            <HotfixElement FileHash="FactionTemplate"                   Enabled="false" />
            <HotfixElement FileHash="GameObjects"                       Enabled="false" />
            <HotfixElement FileHash="GameObjectDisplayInfo"             Enabled="false" />
            <HotfixElement FileHash="GarrAbility"                       Enabled="false" />
            <HotfixElement FileHash="GarrBuilding"                      Enabled="false" />
            <HotfixElement FileHash="GarrBuildingPlotInst"              Enabled="false" />
            <HotfixElement FileHash="GarrClassSpec"                     Enabled="false" />
            <HotfixElement FileHash="GarrFollower"                      Enabled="false" />
            <HotfixElement FileHash="GarrFollowerXAbility"              Enabled="false" />
            <HotfixElement FileHash="GarrPlot"                          Enabled="false" />
            <HotfixElement FileHash="GarrPlotBuilding"                  Enabled="false" />
            <HotfixElement FileHash="GarrPlotInstance"                  Enabled="false" />
            <HotfixElement FileHash="GarrSiteLevel"                     Enabled="false" />
            <HotfixElement FileHash="GarrSiteLevelPlotInst"             Enabled="false" />
            <HotfixElement FileHash="GemProperties"                     Enabled="false" />
            <HotfixElement FileHash="GlyphBindableSpell"                Enabled="false" />
            <HotfixElement FileHash="GlyphProperties"                   Enabled="false" />
            <HotfixElement FileHash="GlyphRequiredSpec"                 Enabled="false" />
            <HotfixElement FileHash="GuildColorBackground"              Enabled="false" />
            <HotfixElement FileHash="GuildColorBorder"                  Enabled="false" />
            <HotfixElement FileHash="GuildColorEmblem"                  Enabled="false" />
            <HotfixElement FileHash="GuildPerkSpells"                   Enabled="false" />
            <HotfixElement FileHash="Heirloom"                          Enabled="false" />
            <HotfixElement FileHash="Holidays"                          Enabled="false" />
            <HotfixElement FileHash="ImportPriceArmor"                  Enabled="false" />
            <HotfixElement FileHash="ImportPriceQuality"                Enabled="false" />
            <HotfixElement FileHash="ImportPriceShield"                 Enabled="false" />
            <HotfixElement FileHash="ImportPriceWeapon"                 Enabled="false" />
            <HotfixElement FileHash="Item"                              Enabled="false" />
            <HotfixElement FileHash="ItemAppearance"                    Enabled="false" />
            <HotfixElement FileHash="ItemArmorQuality"                  Enabled="false" />
            <HotfixElement FileHash="ItemArmorShield"                   Enabled="false" />
            <HotfixElement FileHash="ItemArmorTotal"                    Enabled="false" />
            <HotfixElement FileHash="ItemBagFamily"                     Enabled="false" />
            <HotfixElement FileHash="ItemBonus"                         Enabled="false" />
            <HotfixElement FileHash="ItemBonusListLevelDelta"           Enabled="false" />
            <HotfixElement FileHash="ItemBonusTreeNode"                 Enabled="false" />
            <HotfixElement FileHash="ItemChildEquipment"                Enabled="false" />
            <HotfixElement FileHash="ItemClass"                         Enabled="false" />
            <HotfixElement FileHash="ItemCurrencyCost"                  Enabled="false" />
            <HotfixElement FileHash="ItemDamageAmmo"                    Enabled="false" />
            <HotfixElement FileHash="ItemDamageOneHand"                 Enabled="false" />
            <HotfixElement FileHash="ItemDamageOneHandCaster"           Enabled="false" />
            <HotfixElement FileHash="ItemDamageTwoHand"                 Enabled="false" />
            <HotfixElement FileHash="ItemDamageTwoHandCaster"           Enabled="false" />
            <HotfixElement FileHash="ItemDisenchantLoot"                Enabled="false" />
            <HotfixElement FileHash="ItemEffect"                        Enabled="false" />
            <HotfixElement FileHash="ItemExtendedCost"                  Enabled="false" />
            <HotfixElement FileHash="ItemLimitCategory"                 Enabled="false" />
            <HotfixElement FileHash="ItemModifiedAppearance"            Enabled="false" />
            <HotfixElement FileHash="ItemPriceBase"                     Enabled="false" />
            <HotfixElement FileHash="ItemRandomProperties"              Enabled="false" />
            <HotfixElement FileHash="ItemRandomSuffix"                  Enabled="false" />
            <HotfixElement FileHash="ItemSearchName"                    Enabled="false" />
            <HotfixElement FileHash="ItemSet"                           Enabled="false" />
            <HotfixElement FileHash="ItemSetSpell"                      Enabled="false" />
            <HotfixElement FileHash="ItemSparse"                        Enabled="false" />
            <HotfixElement FileHash="ItemSpec"                          Enabled="false" />
            <HotfixElement FileHash="ItemSpecOverride"                  Enabled="false" />
            <HotfixElement FileHash="ItemUpgrade"                       Enabled="false" />
            <HotfixElement FileHash="ItemXBonusTree"                    Enabled="false" />
            <HotfixElement FileHash="KeyChain"                          Enabled="false" />
            <HotfixElement FileHash="LfgDungeons"                       Enabled="false" />
            <HotfixElement FileHash="Light"                             Enabled="false" />
            <HotfixElement FileHash="LiquidType"                        Enabled="false" />
            <HotfixElement FileHash="Lock"                              Enabled="false" />
            <HotfixElement FileHash="MailTemplate"                      Enabled="false" />
            <HotfixElement FileHash="Map"                               Enabled="false" />
            <HotfixElement FileHash="MapDifficulty"                     Enabled="false" />
            <HotfixElement FileHash="ModifierTree"                      Enabled="false" />
            <HotfixElement FileHash="Mount"                             Enabled="false" />
            <HotfixElement FileHash="MountCapability"                   Enabled="false" />
            <HotfixElement FileHash="MountTypeXCapability"              Enabled="false" />
            <HotfixElement FileHash="Movie"                             Enabled="false" />
            <HotfixElement FileHash="NameGen"                           Enabled="false" />
            <HotfixElement FileHash="NamesProfanity"                    Enabled="false" />
            <HotfixElement FileHash="NamesReserved"                     Enabled="false" />
            <HotfixElement FileHash="NamesReservedLocale"               Enabled="false" />
            <HotfixElement FileHash="OverrideSpellData"                 Enabled="false" />
            <HotfixElement FileHash="Phase"                             Enabled="false" />
            <HotfixElement FileHash="PhaseXPhaseGroup"                  Enabled="false" />
            <HotfixElement FileHash="PlayerCondition"                   Enabled="false" />
            <HotfixElement FileHash="PowerDisplay"                      Enabled="false" />
            <HotfixElement FileHash="PowerType"                         Enabled="false" />
            <HotfixElement FileHash="PvpDifficulty"                     Enabled="false" />
            <HotfixElement FileHash="QuestFactionReward"                Enabled="false" />
            <HotfixElement FileHash="QuestMoneyReward"                  Enabled="false" />
            <HotfixElement FileHash="QuestPackageItem"                  Enabled="false" />
            <HotfixElement FileHash="QuestSort"                         Enabled="false" />
            <HotfixElement FileHash="QuestV2"                           Enabled="false" />
            <HotfixElement FileHash="QuestXP"                           Enabled="false" />
            <HotfixElement FileHash="RandPropPoints"                    Enabled="false" />
            <HotfixElement FileHash="RulesetItemUpgrade"                Enabled="false" />
            <HotfixElement FileHash="ScalingStatDistribution"           Enabled="false" />
            <HotfixElement FileHash="Scenario"                          Enabled="false" />
            <HotfixElement FileHash="ScenarioStep"                      Enabled="false" />
            <HotfixElement FileHash="SceneScript"                       Enabled="false" />
            <HotfixElement FileHash="SceneScriptPackage"                Enabled="false" />
            <HotfixElement FileHash="SkillLine"                         Enabled="false" />
            <HotfixElement FileHash="SkillLineAbility"                  Enabled="false" />
            <HotfixElement FileHash="SkillRaceClassInfo"                Enabled="false" />
            <HotfixElement FileHash="SoundKit"                          Enabled="false" />
            <HotfixElement FileHash="SpecializationSpells"              Enabled="false" />
            <HotfixElement FileHash="Spell"                             Enabled="false" />
            <HotfixElement FileHash="SpellAuraOptions"                  Enabled="false" />
            <HotfixElement FileHash="SpellAuraRestrictions"             Enabled="false" />
            <HotfixElement FileHash="SpellCastTimes"                    Enabled="false" />
            <HotfixElement FileHash="SpellCastingRequirements"          Enabled="false" />
            <HotfixElement FileHash="SpellCategories"                   Enabled="false" />
            <HotfixElement FileHash="SpellCategory"                     Enabled="false" />
            <HotfixElement FileHash="SpellClassOptions"                 Enabled="false" />
            <HotfixElement FileHash="SpellCooldowns"                    Enabled="false" />
            <HotfixElement FileHash="SpellDuration"                     Enabled="false" />
            <HotfixElement FileHash="SpellEffect"                       Enabled="false" />
            <HotfixElement FileHash="SpellEffectScaling"                Enabled="false" />
            <HotfixElement FileHash="SpellEquippedItems"                Enabled="false" />
            <HotfixElement FileHash="SpellFocusObject"                  Enabled="false" />
            <HotfixElement FileHash="SpellInterrupts"                   Enabled="false" />
            <HotfixElement FileHash="SpellItemEnchantment"              Enabled="false" />
            <HotfixElement FileHash="SpellItemEnchantmentCondition"     Enabled="false" />
            <HotfixElement FileHash="SpellLearnSpell"                   Enabled="false" />
            <HotfixElement FileHash="SpellLevels"                       Enabled="false" />
            <HotfixElement FileHash="SpellMisc"                         Enabled="false" />
            <HotfixElement FileHash="SpellPower"                        Enabled="false" />
            <HotfixElement FileHash="SpellPowerDifficulty"              Enabled="false" />
            <HotfixElement FileHash="SpellProcsPerMinute"               Enabled="false" />
            <HotfixElement FileHash="SpellProcsPerMinuteMod"            Enabled="false" />
            <HotfixElement FileHash="SpellRadius"                       Enabled="false" />
            <HotfixElement FileHash="SpellRange"                        Enabled="false" />
            <HotfixElement FileHash="SpellReagents"                     Enabled="false" />
            <HotfixElement FileHash="SpellScaling"                      Enabled="false" />
            <HotfixElement FileHash="SpellShapeshift"                   Enabled="false" />
            <HotfixElement FileHash="SpellShapeshiftForm"               Enabled="false" />
            <HotfixElement FileHash="SpellTargetRestrictions"           Enabled="false" />
            <HotfixElement FileHash="SpellTotems"                       Enabled="false" />
            <HotfixElement FileHash="SpellXSpellVisual"                 Enabled="false" />
            <HotfixElement FileHash="SummonProperties"                  Enabled="false" />
            <HotfixElement FileHash="TactKey"                           Enabled="false" />
            <HotfixElement FileHash="Talent"                            Enabled="false" />
            <HotfixElement FileHash="TaxiNodes"                         Enabled="false" />
            <HotfixElement FileHash="TaxiPath"                          Enabled="false" />
            <HotfixElement FileHash="TaxiPathNode"                      Enabled="false" />
            <HotfixElement FileHash="TotemCategory"                     Enabled="false" />
            <HotfixElement FileHash="Toy"                               Enabled="false" />
            <HotfixElement FileHash="TransportAnimation"                Enabled="false" />
            <HotfixElement FileHash="TransportRotation"                 Enabled="false" />
            <HotfixElement FileHash="UnitPowerBar"                      Enabled="false" />
            <HotfixElement FileHash="Vehicle"                           Enabled="false" />
            <HotfixElement FileHash="VehicleSeat"                       Enabled="false" />
            <HotfixElement FileHash="WMOAreaTable"                      Enabled="false" />
            <HotfixElement FileHash="WorldMapArea"                      Enabled="false" />
            <HotfixElement FileHash="WorldMapOverlay"                   Enabled="false" />
            <HotfixElement FileHash="WorldMapTransforms"                Enabled="false" />
            <HotfixElement FileHash="WorldSafeLocs"                     Enabled="false" />
        </FileHashes>
    </Hotfix>
<system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data></configuration>

Error Log

Loading DB...
Connecting to MySQL server: Server=localhost;Port=3306;Username=root;Database=wpp;CharSet=utf8;ConnectionTimeout=5;
System.TypeInitializationException
The type initializer for 'WowPacketParser.DBC.DBC' threw an exception.
   at WowPacketParser.SQL.SQLDatabase.LoadBroadcastText() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLDatabase.cs:line 127
   at WowPacketParser.SQL.SQLDatabase.LoadSQL() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLDatabase.cs:line 70
   at WowPacketParser.SQL.SQLConnector.ReadDB() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLConnector.cs:line 111
Finished loading DB in 00:00:02.447.

DBC folder "F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\bin\Release\dbc\enUS\" found
File name                           LoadTime             Record count
---------------------------------------------------------------------
Faction                           00:00:00.0110291             601
FactionTemplate                   00:00:00.0020054             1400
Achievement                       00:00:00.0180476             5421
AreaTable                         00:00:00.0130274             5697
BroadcastText                     00:00:00.0060256             3745
CreatureDifficulty                00:00:00.0125754             9865
Item                              00:00:00.0411848             123714
Creature                          00:00:00.0140585             9451
CreatureDisplayInfo               00:00:00.1667953             64407
CreatureFamily                    00:00:00.0010031             75
CriteriaTree                      00:00:00.0511592             46141
Difficulty                        00:00:00.0009836             25
ItemSparse                        00:00:00.4180172             99407
DBC loaded in 00:00:00.495.

Unhandled Exception: System.AggregateException: One or more errors occurred. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, Object[] args)
   at WowPacketParser.DBC.DBC.<>c.<Load>b__20_0(Type type) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 67
   at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
   at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object )
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)
   at WowPacketParser.DBC.DBC.<Load>d__20.MoveNext() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 80
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_1(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()

TrintyCore Version

TrinityCore rev. cf5aa01be7ee+ 2017-06-18 22:17:48 +0200 (master branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org                    \/__/

Using configuration file C:/TCSPLegion/worldserver.conf.
Using SSL version: OpenSSL 1.0.2j  26 Sep 2016 (library: OpenSSL 1.0.2j  26 Sep 2016)
Using Boost version: 1.63.0

Maps extracted and DBC used from Extraction Wow Retail Version wowversion

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/46348588-error-in-extraction-wpp-commit-9ab1f15?utm_campaign=plugin&utm_content=tracker%2F457228&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F457228&utm_medium=issues&utm_source=github).
Taaboy commented 7 years ago

New Complete WPP Pull Down and Deleted old folder. Only Errors with DBC enabled

Loading DB...
Connecting to MySQL server: Server=localhost;Port=3306;Username=root;Database=wpp;CharSet=utf8;ConnectionTimeout=5;
System.TypeInitializationException
The type initializer for 'WowPacketParser.DBC.DBC' threw an exception.
   at WowPacketParser.SQL.SQLDatabase.LoadBroadcastText() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLDatabase.cs:line 127
   at WowPacketParser.SQL.SQLDatabase.LoadSQL() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLDatabase.cs:line 70
   at WowPacketParser.SQL.SQLConnector.ReadDB() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\SQLConnector.cs:line 111
Finished loading DB in 00:00:02.442.

DBC folder "F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\bin\Release\dbc\enUS\" found
File name                           LoadTime             Record count
---------------------------------------------------------------------
Faction                           00:00:00.0035105             601
FactionTemplate                   00:00:00.0015043             1400
Achievement                       00:00:00.0140386             5421
AreaTable                         00:00:00.0080229             5697
BroadcastText                     00:00:00.0170458             3745
CreatureDifficulty                00:00:00.0050128             9865
Item                              00:00:00.0426143             123714
Creature                          00:00:00.0340913             9451
CreatureDisplayInfo               00:00:00.2007117             64407
CreatureFamily                    00:00:00.0009942             75
CriteriaTree                      00:00:00.0386037             46141
Difficulty                        00:00:00.0010021             25
ItemSparse                        00:00:00.4008168             99407
DBC loaded in 00:00:00.473.

Unhandled Exception: System.AggregateException: One or more errors occurred. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, Object[] args)
   at WowPacketParser.DBC.DBC.<>c.<Load>b__20_0(Type type) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 67
   at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
   at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object )
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)
   at WowPacketParser.DBC.DBC.<Load>d__20.MoveNext() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 80
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_1(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
Taaboy commented 7 years ago

Output Log No DBC = False Different added Creature=true Sniff Version 24015 Area Dustwallow Marsh

Loading DB...
Connecting to MySQL server: Server=localhost;Port=3306;Username=root;Database=wpp;CharSet=utf8;ConnectionTimeout=5;
SQL loaded in 00:00:00.674.
Finished loading DB in 00:00:02.364.

Loading module WowPacketParserModule.V6_0_2_19033.dll (fallback)
Loading module WowPacketParserModule.V7_0_3_22248.dll
[1/1 24015_2017-06-13_15-32-38_Dustwallow_Marsh_N.pkt]: Parsing 34.7MB of packets. Detected version V7_2_0_24015
[1/1 24015_2017-06-13_15-32-38_Dustwallow_Marsh_N.pkt]: Saved file to 'F:\PKTDATA\PKT2\V7_2_0_24015\24015_2017-06-13_15-32-38_Dustwallow_Marsh_N_parsed.txt'
[1/1 24015_2017-06-13_15-32-38_Dustwallow_Marsh_N.pkt]: Parsed 208544 (99.790%) packets successfully, 41 (0.020%) with errors, skipped 215 (0.103%) and without structure 182 (0.087%)  (total: 208982) in 00:00:20.865
1/45 - Write AreaTriggerTemplateData
2/45 - Write AreaTriggerTemplateVerticesData
3/45 - Write SpellAreaTriggersData
4/45 - Write GameObjectTemplateAddon
5/45 - Write Hotfixes
6/45 - Write HotfixData
7/45 - Write BroadcastText
8/45 - Write LocalesQuest
9/45 - Write LocalesQuestObjectives
10/45 - Write StartInformation
11/45 - Write ObjectNames
12/45 - Write SniffData
13/45 - Write WeatherUpdates
14/45 - Write SceneTemplates
15/45 - Write QuestOfferReward
16/45 - Write QuestPOI
17/45 - Write QuestGreeting
18/45 - Write QuestDetails
19/45 - Write QuestRequestItems
20/45 - Write Creature
20/45 - Error: Failed writing Creature
WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   at WowPacketParser.DBC.DBC..cctor() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 31
   --- End of inner exception stack trace ---
   at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\Store\Objects\WoWObject.cs:line 44
   at WowPacketParser.SQL.Builders.Spawns.Creature(Dictionary`2 units) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\Spawns.cs:line 128
21/45 - Write GameObject
22/45 - Write SpellTargetPosition
23/45 - Write CreatureTemplateAddon
24/45 - Write CreatureTemplateScalingData
25/45 - Write ModelData
26/45 - Write NpcTrainer
27/45 - Write NpcVendor
28/45 - Write CreatureEquip
29/45 - Write PointsOfInterest
30/45 - Write Gossip
31/45 - Write CreatureTemplateNonWDB
Entry: 47572 NpcFlag: Gossip, Trainer, ProfessionTrainer
Entry: 3013 NpcFlag: Gossip, Trainer, ProfessionTrainer
Entry: 3009 NpcFlag: Gossip, QuestGiver, Trainer, ProfessionTrainer
Entry: 3028 NpcFlag: Gossip, QuestGiver, Trainer, ProfessionTrainer
Entry: 3011 NpcFlag: Gossip, Trainer, ProfessionTrainer
32/45 - Write CreatureText
33/45 - Write VehicleAccessory
34/45 - Write NpcSpellClick
35/45 - Write NpcSpellClickMop
36/45 - Write QuestTemplate
37/45 - Write QuestObjective
38/45 - Write QuestVisualEffect
39/45 - Write CreatureTemplate
40/45 - Write CreatureTemplateQuestItem
41/45 - Write GameObjectTemplate
42/45 - Write GameObjectTemplateQuestItem
43/45 - Write ItemTemplate
44/45 - Write PageText
45/45 - Write NpcText
Dumping global sql: Saved file to 'UpdateSQL.sql'
Finished SQL file in 00:00:45.423.

This log output same setting above Black Temple OLD Raid 10man Version 24330

Loading DB...
Connecting to MySQL server: Server=localhost;Port=3306;Username=root;Database=wpp;CharSet=utf8;ConnectionTimeout=5;
SQL loaded in 00:00:00.665.
Finished loading DB in 00:00:02.323.

Loading module WowPacketParserModule.V6_0_2_19033.dll (fallback)
Loading module WowPacketParserModule.V7_0_3_22248.dll
[1/1 24330_2017-06-17_10-05-00.pkt]: Parsing 26.3MB of packets. Detected version V7_2_5_24330
[1/1 24330_2017-06-17_10-05-00.pkt]: Saved file to 'F:\PKTDATA\24330_2017-06-17_10-05-00_parsed.txt'
[1/1 24330_2017-06-17_10-05-00.pkt]: Parsed 196658 (99.195%) packets successfully, 65 (0.033%) with errors, skipped 404 (0.204%) and without structure 1126 (0.568%)  (total: 198253) in 00:00:17.257
1/45 - Write AreaTriggerTemplateData
2/45 - Write AreaTriggerTemplateVerticesData
3/45 - Write SpellAreaTriggersData
4/45 - Write GameObjectTemplateAddon
5/45 - Write Hotfixes
6/45 - Write HotfixData
7/45 - Write BroadcastText
8/45 - Write LocalesQuest
9/45 - Write LocalesQuestObjectives
10/45 - Write StartInformation
11/45 - Write ObjectNames
12/45 - Write SniffData
13/45 - Write WeatherUpdates
14/45 - Write SceneTemplates
15/45 - Write QuestOfferReward
16/45 - Write QuestPOI
17/45 - Write QuestGreeting
18/45 - Write QuestDetails
19/45 - Write QuestRequestItems
20/45 - Write Creature
20/45 - Error: Failed writing Creature
WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   at WowPacketParser.DBC.DBC..cctor() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 31
   --- End of inner exception stack trace ---
   at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\Store\Objects\WoWObject.cs:line 44
   at WowPacketParser.SQL.Builders.Spawns.Creature(Dictionary`2 units) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\Spawns.cs:line 128
21/45 - Write GameObject
22/45 - Write SpellTargetPosition
23/45 - Write CreatureTemplateAddon
24/45 - Write CreatureTemplateScalingData
25/45 - Write ModelData
26/45 - Write NpcTrainer
27/45 - Write NpcVendor
28/45 - Write CreatureEquip
29/45 - Write PointsOfInterest
30/45 - Write Gossip
31/45 - Write CreatureTemplateNonWDB
Entry: 33631 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33634 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33636 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33635 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33641 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
31/45 - Error: Failed writing CreatureTemplateNonWDB
WowPacketParser.exe Error: 0 : System.NullReferenceException: Object reference not set to an instance of an object.
   at WowPacketParser.SQL.Builders.UnitMisc.CreatureTemplateNonWDB(Dictionary`2 units) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\UnitMisc.cs:line 487
32/45 - Write CreatureText
33/45 - Write VehicleAccessory
34/45 - Write NpcSpellClick
35/45 - Write NpcSpellClickMop
36/45 - Write QuestTemplate
37/45 - Write QuestObjective
38/45 - Write QuestVisualEffect
39/45 - Write CreatureTemplate
40/45 - Write CreatureTemplateQuestItem
41/45 - Write GameObjectTemplate
42/45 - Write GameObjectTemplateQuestItem
43/45 - Write ItemTemplate
44/45 - Write PageText
45/45 - Write NpcText
Dumping global sql: Saved file to 'UpdateSQL.sql'
Finished SQL file in 00:00:14.621.

QuestFlags2 has undefined flags: Unk10000
Taaboy commented 7 years ago

Ok Tested with all options in Config Below

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <section name="Hotfix" type="WowPacketParser.Hotfix.HotfixSection, WowPacketParser" />
    </configSections>
    <appSettings>
        <!--
             Option:      Filters
             Description: List of strings separated by comma. Any opcode name that matches any of these filters will be parsed
             Default:     "" (All)
        -->
        <add key="Filters" value=""/>

        <!--
             Option:      IgnoreFilters
             Description: List of strings separated by comma. Any opcode name that matches any of these filters will be ignored
                          If one opcode matches Filters and IgnoreFilters at same time it will be ignored
             Default:     "" (None)
        -->
        <add key="IgnoreFilters" value=""/>

        <!--
             Option:      IgnoreByEntryFilters
             Description: List of List of Entries not to be included in output file. Any opcode that contains any of these entries will be ignored
             Format:      Type:Id1:Id2:Id3,Type2:Id4:Id5:Id6
             Example:     Unit:5000:10000:60000,Player:0
             Default:     "" (None)
        -->
        <add key="IgnoreByEntryFilters" value=""/>

        <!--
             Option:      AreaFilters
             Description: List of strings separated by comma. Any creature/gameobject spawn that matches any of these filters
                          will be dumped to sql file if creature/gameobject sql option is enabled
             Default:     "" (None)
        -->
        <add key="AreaFilters" value=""/>

        <!--
               Option:      MapFilters
               Description: List of strings separated by comma. Any creature/gameobject spawn that matches any of these filters
                            will be dumped to sql file if creature/gameobject sql option is enabled
               Default:     "" (None)
          -->
        <add key="MapFilters" value=""/>

        <!--
             Option:      FilterPacketsNum
             Description: Number of packets to read.
                          If this value is negative and DumpFormat is set to 2 (Binary (.pkt)), a number of .pkt files will be
                          created containing this value in number of packets (last .pkt created can have less packets than
                          the number defined by this value).
             Default:     "0" (All)
        -->
        <add key="FilterPacketsNum" value="0"/>

        <!--
             Option:      ClientBuild
             Description: Force client build version
             Default:     "" (Autodetect - build is calculated based on the date of sniff)
        -->
        <add key="ClientBuild" value=""/>

        <!--
             Option:      TargetedDatabase
             Description: Sets the database version for which the SQL output should be produced.
             Default:     "1" (Wrath of the Lich King)
             Values:      1: Wrath of the Lich King
                          2: Cataclysm
                          3: Warlords of Draenor
                          4: Legion
        -->
      <add key="TargetedDatabase" value="4"/>

        <!--
             Option:      DumpFormat
             Description: Format to write to output file
             Default:     "1" (Text)
             Values:      0: No dump
                          1: Text + SQL (if enabled)
                          2: Binary (.pkt)
                          3: Binary (.pkt) split output in multiple files with opcode name
                          4: SQL Only
                          5: SniffData only (.sql)
                          6: Few statistics in CSV format (does not parse packets)
                          7: Binary (.pkt) split output in multiple files by session (TC sniffs only)
                          8: Compress sniff files (.gz extension)
                          9: Calculate version and move sniff to its own folder version
                          10: Hex & packet header only
                          11: Binary (.pkt) split output in multiple files by direction
                          12: Output info about packet's connection indexes (<name>_connidx.txt)
                          13: Binary (.pkt) merge output in a file (fusion.pkt)
        -->
        <add key="DumpFormat" value="1"/>

      <!--
             Option:      SQLOutput
             Description: "true" defines if SQL file created contains a specific table, "false" otherwise

             Default:     "false" (No SQL output for specific table)
        -->
        <add key="ObjectNames"                            value="false"/>
        <add key="SniffData"                              value="false"/>
        <add key="SniffDataOpcodes"                       value="false"/>

        <add key="areatrigger_template"                   value="true"/>
        <add key="areatrigger_template_polygon_vertices"  value="true"/>
        <add key="broadcast_text"                         value="true"/>
        <add key="creature"                               value="true"/>
        <add key="creature_addon"                         value="true"/>
        <add key="creature_equip_template"                value="true"/>
        <add key="creature_model_info"                    value="true"/>
        <add key="creature_template"                      value="true"/>
        <add key="creature_template_addon"                value="true"/>
        <add key="creature_text"                          value="true"/>
        <add key="gameobject"                             value="true"/>
        <add key="gameobject_addon"                       value="true"/>
        <add key="gameobject_template"                    value="true"/>
        <add key="gameobject_template_addon"              value="true"/>
        <add key="gossip_menu"                            value="true"/>
        <add key="gossip_menu_option"                     value="true"/>
        <add key="item_template"                          value="true"/>
        <add key="locales_quest"                          value="true"/>
        <add key="locales_quest_objectives"               value="true"/>
        <add key="npc_spellclick_spells"                  value="true"/>
        <add key="npc_text"                               value="true"/>
        <add key="npc_trainer"                            value="true"/>
        <add key="npc_vendor"                             value="true"/>
        <add key="page_text"                              value="true"/>
        <add key="playercreateinfo"                       value="true"/>
        <add key="playercreateinfo_action"                value="true"/>
        <add key="points_of_interest"                     value="true"/>
        <add key="quest_poi"                              value="true"/>
        <add key="quest_poi_points"                       value="true"/>
        <add key="quest_template"                         value="true"/>
        <add key="scene_template"                         value="true"/>
        <add key="spell_target_position"                  value="true"/>
        <add key="spell_areatrigger"                      value="true"/>
        <add key="vehicle_template_accessory"             value="true"/>
        <add key="weather_updates"                        value="true"/>

        <add key="hotfix_data"                            value="false"/>

        <!--
             Option:      SQLFileName
             Description: Sets the file to write all sql data to. If is not set each file parsed will write it's own sql file
             Default:     "" (No global sql file output)
        -->
        <add key="SQLFileName" value="UpdateSQL.sql"/>

        <!--
             Option:      SQLOrderByKey
             Description: Order Sql Output by key
             Default:     "false" (No prompt)
        -->
        <add key="SQLOrderByKey" value="false"/>

        <!--
             Option:      SkipOnlyVerifiedBuildUpdateRows
             Description: Ship only VerifiedBuild row in update querys
             Default:     "false"
        -->
        <add key="SkipOnlyVerifiedBuildUpdateRows" value="false"/>

        <!--
             Option:      ShowEndPrompt
             Description: Show end prompt after parsing all files
             Default:     "false" (No prompt)
        -->
        <add key="ShowEndPrompt" value="false"/>

        <!--
             Option:      LogErrors
             Description: Log ReadEnum errors (Missing enum values)
             Default:     "false" (No enum errors log)
        -->
        <add key="LogErrors" value="true"/>

        <!--
             Option:      LogPacketErrors
             Description: Log packet headers that were skipped or have packet errors to <snifffile>_errors.txt
             Default:     "false" (No file created)
        -->
        <add key="LogPacketErrors" value="true"/>

        <!--
             Option:      OutputFlag
             Description: Configures what packets depending on parsing status are written to the .txt. 1 - Only success, 2 - Only with errors, 4 - Only skipped, 8 - Only wihtout structure
             Default:     "15" (Success, WithErrors, NotParsed and NoStructure)
        -->
        <add key="OutputFlag" value="15"/>

        <!--
             Option:      DebugReads
             Description: Show hexadecimal data when reading any numeric value
             Default:     "false" (Do not show hexadecimal output)
        -->
        <add key="DebugReads" value="false"/>

        <!--
             Option:      ParsingLog
             Description: Write to a text file what has been printed on console
             Default:     "false"
        -->
        <add key="ParsingLog" value="true"/>

        <!--
             Option:      Threads
             Description: Number of threads to parse packets. 0 is number of avail. processors.
             Default:     "1"
        -->
        <add key="Threads" value="1"/>

          <!--
                 Option:      UseDBC
                 Description: Use DBC/DB2
                 Default:     "false" (No prompt)
            -->
          <add key="UseDBC" value="false"/>

          <!--
                 Option:      DbcPath
                 Description: Set DBC/DB2 Path
                 Default:     "\dbc" (No prompt)
            -->
          <add key="DBCPath" value="\dbc"/>

          <!--
                 Option:      DbcLocale
                 Description: Set DBC/DB2 Locales
                 Default:     "enUS"
            -->
          <add key="DBCLocale" value="enUS"/>

          <!--
                 Option:      ParseSpellInfos
                 Description: Parse spell infos to output file (only *.txt)
                 Default:     "false" (No prompt)
            -->
          <add key="ParseSpellInfos" value="false"/>

        <!-- SSH Tunneling settings -->
        <add key="SSHEnabled"         value="false" />
        <add key="SSHHost"            value="" />
        <add key="SSHUsername"        value="" />
        <add key="SSHPassword"        value="" />
        <add key="SSHPort"            value="22" />
        <add key="SSHLocalPort"       value="3307" />

        <!-- Database settings -->
        <add key="DBEnabled"          value="true" />
        <add key="Server"             value="localhost" />
        <add key="Port"               value="3306" />
        <add key="Username"           value="root" />
        <add key="Password"           value="ascent" />
        <add key="WPPDatabase"        value="wpp" />
        <add key="TDBDatabase"        value="xworld" />
        <add key="HotfixesDatabase"   value="xhotfixes" />
        <add key="CharacterSet"       value="utf8" />
    </appSettings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
    </startup>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <probing privatePath="Parsers"/>
        </assemblyBinding>
    </runtime>

    <Hotfix>
        <FileHashes>
            <!--
                Collection of hotfix hashes
                Enabled is set to true by default

                Locales are autogenerated as long as the base is enabled.
            -->
            <HotfixElement FileHash="Achievement"                       Enabled="false" />
            <HotfixElement FileHash="AnimKit"                           Enabled="false" />
            <HotfixElement FileHash="AreaGroupMember"                   Enabled="false" />
            <HotfixElement FileHash="AreaTable"                         Enabled="false" />
            <HotfixElement FileHash="AreaTrigger"                       Enabled="false" />
            <HotfixElement FileHash="ArmorLocation"                     Enabled="false" />
            <HotfixElement FileHash="Artifact"                          Enabled="false" />
            <HotfixElement FileHash="ArtifactAppearance"                Enabled="false" />
            <HotfixElement FileHash="ArtifactAppearanceSet"             Enabled="false" />
            <HotfixElement FileHash="ArtifactCategory"                  Enabled="false" />
            <HotfixElement FileHash="ArtifactPower"                     Enabled="false" />
            <HotfixElement FileHash="ArtifactPowerLink"                 Enabled="false" />
            <HotfixElement FileHash="ArtifactPowerRank"                 Enabled="false" />
            <HotfixElement FileHash="ArtifactQuestXP"                   Enabled="false" />
            <HotfixElement FileHash="AuctionHouse"                      Enabled="false" />
            <HotfixElement FileHash="BankBagSlotPrices"                 Enabled="false" />
            <HotfixElement FileHash="BannedAddOns"                      Enabled="false" />
            <HotfixElement FileHash="BarberShopStyle"                   Enabled="false" />
            <HotfixElement FileHash="BattlePetBreedQuality"             Enabled="false" />
            <HotfixElement FileHash="BattlePetBreedState"               Enabled="false" />
            <HotfixElement FileHash="BattlePetSpecies"                  Enabled="false" />
            <HotfixElement FileHash="BattlePetSpeciesState"             Enabled="false" />
            <HotfixElement FileHash="BattlemasterList"                  Enabled="false" />
            <HotfixElement FileHash="BroadcastText"                     Enabled="false" />
            <HotfixElement FileHash="CharSections"                      Enabled="false" />
            <HotfixElement FileHash="CharStartOutfit"                   Enabled="false" />
            <HotfixElement FileHash="CharTitles"                        Enabled="false" />
            <HotfixElement FileHash="ChatChannels"                      Enabled="false" />
            <HotfixElement FileHash="ChrClasses"                        Enabled="false" />
            <HotfixElement FileHash="ChrClassesXPowerTypes"             Enabled="false" />
            <HotfixElement FileHash="ChrRaces"                          Enabled="false" />
            <HotfixElement FileHash="ChrSpecialization"                 Enabled="false" />
            <HotfixElement FileHash="CinematicCamera"                   Enabled="false" />
            <HotfixElement FileHash="CinematicSequences"                Enabled="false" />
            <HotfixElement FileHash="CreatureDifficulty"                Enabled="false" />
            <HotfixElement FileHash="CreatureDisplayInfo"               Enabled="false" />
            <HotfixElement FileHash="CreatureDisplayInfoExtra"          Enabled="false" />
            <HotfixElement FileHash="CreatureFamily"                    Enabled="false" />
            <HotfixElement FileHash="CreatureModelData"                 Enabled="false" />
            <HotfixElement FileHash="CreatureType"                      Enabled="false" />
            <HotfixElement FileHash="Criteria"                          Enabled="false" />
            <HotfixElement FileHash="CriteriaTree"                      Enabled="false" />
            <HotfixElement FileHash="CurrencyTypes"                     Enabled="false" />
            <HotfixElement FileHash="Curve"                             Enabled="false" />
            <HotfixElement FileHash="CurvePoint"                        Enabled="false" />
            <HotfixElement FileHash="DestructibleModelData"             Enabled="false" />
            <HotfixElement FileHash="Difficulty"                        Enabled="false" />
            <HotfixElement FileHash="DungeonEncounter"                  Enabled="false" />
            <HotfixElement FileHash="DurabilityCosts"                   Enabled="false" />
            <HotfixElement FileHash="DurabilityQuality"                 Enabled="false" />
            <HotfixElement FileHash="Emotes"                            Enabled="false" />
            <HotfixElement FileHash="EmotesText"                        Enabled="false" />
            <HotfixElement FileHash="EmotesTextSound"                   Enabled="false" />
            <HotfixElement FileHash="Faction"                           Enabled="false" />
            <HotfixElement FileHash="FactionTemplate"                   Enabled="false" />
            <HotfixElement FileHash="GameObjects"                       Enabled="false" />
            <HotfixElement FileHash="GameObjectDisplayInfo"             Enabled="false" />
            <HotfixElement FileHash="GarrAbility"                       Enabled="false" />
            <HotfixElement FileHash="GarrBuilding"                      Enabled="false" />
            <HotfixElement FileHash="GarrBuildingPlotInst"              Enabled="false" />
            <HotfixElement FileHash="GarrClassSpec"                     Enabled="false" />
            <HotfixElement FileHash="GarrFollower"                      Enabled="false" />
            <HotfixElement FileHash="GarrFollowerXAbility"              Enabled="false" />
            <HotfixElement FileHash="GarrPlot"                          Enabled="false" />
            <HotfixElement FileHash="GarrPlotBuilding"                  Enabled="false" />
            <HotfixElement FileHash="GarrPlotInstance"                  Enabled="false" />
            <HotfixElement FileHash="GarrSiteLevel"                     Enabled="false" />
            <HotfixElement FileHash="GarrSiteLevelPlotInst"             Enabled="false" />
            <HotfixElement FileHash="GemProperties"                     Enabled="false" />
            <HotfixElement FileHash="GlyphBindableSpell"                Enabled="false" />
            <HotfixElement FileHash="GlyphProperties"                   Enabled="false" />
            <HotfixElement FileHash="GlyphRequiredSpec"                 Enabled="false" />
            <HotfixElement FileHash="GuildColorBackground"              Enabled="false" />
            <HotfixElement FileHash="GuildColorBorder"                  Enabled="false" />
            <HotfixElement FileHash="GuildColorEmblem"                  Enabled="false" />
            <HotfixElement FileHash="GuildPerkSpells"                   Enabled="false" />
            <HotfixElement FileHash="Heirloom"                          Enabled="false" />
            <HotfixElement FileHash="Holidays"                          Enabled="false" />
            <HotfixElement FileHash="ImportPriceArmor"                  Enabled="false" />
            <HotfixElement FileHash="ImportPriceQuality"                Enabled="false" />
            <HotfixElement FileHash="ImportPriceShield"                 Enabled="false" />
            <HotfixElement FileHash="ImportPriceWeapon"                 Enabled="false" />
            <HotfixElement FileHash="Item"                              Enabled="false" />
            <HotfixElement FileHash="ItemAppearance"                    Enabled="false" />
            <HotfixElement FileHash="ItemArmorQuality"                  Enabled="false" />
            <HotfixElement FileHash="ItemArmorShield"                   Enabled="false" />
            <HotfixElement FileHash="ItemArmorTotal"                    Enabled="false" />
            <HotfixElement FileHash="ItemBagFamily"                     Enabled="false" />
            <HotfixElement FileHash="ItemBonus"                         Enabled="false" />
            <HotfixElement FileHash="ItemBonusListLevelDelta"           Enabled="false" />
            <HotfixElement FileHash="ItemBonusTreeNode"                 Enabled="false" />
            <HotfixElement FileHash="ItemChildEquipment"                Enabled="false" />
            <HotfixElement FileHash="ItemClass"                         Enabled="false" />
            <HotfixElement FileHash="ItemCurrencyCost"                  Enabled="false" />
            <HotfixElement FileHash="ItemDamageAmmo"                    Enabled="false" />
            <HotfixElement FileHash="ItemDamageOneHand"                 Enabled="false" />
            <HotfixElement FileHash="ItemDamageOneHandCaster"           Enabled="false" />
            <HotfixElement FileHash="ItemDamageTwoHand"                 Enabled="false" />
            <HotfixElement FileHash="ItemDamageTwoHandCaster"           Enabled="false" />
            <HotfixElement FileHash="ItemDisenchantLoot"                Enabled="false" />
            <HotfixElement FileHash="ItemEffect"                        Enabled="false" />
            <HotfixElement FileHash="ItemExtendedCost"                  Enabled="false" />
            <HotfixElement FileHash="ItemLimitCategory"                 Enabled="false" />
            <HotfixElement FileHash="ItemModifiedAppearance"            Enabled="false" />
            <HotfixElement FileHash="ItemPriceBase"                     Enabled="false" />
            <HotfixElement FileHash="ItemRandomProperties"              Enabled="false" />
            <HotfixElement FileHash="ItemRandomSuffix"                  Enabled="false" />
            <HotfixElement FileHash="ItemSearchName"                    Enabled="false" />
            <HotfixElement FileHash="ItemSet"                           Enabled="false" />
            <HotfixElement FileHash="ItemSetSpell"                      Enabled="false" />
            <HotfixElement FileHash="ItemSparse"                        Enabled="false" />
            <HotfixElement FileHash="ItemSpec"                          Enabled="false" />
            <HotfixElement FileHash="ItemSpecOverride"                  Enabled="false" />
            <HotfixElement FileHash="ItemUpgrade"                       Enabled="false" />
            <HotfixElement FileHash="ItemXBonusTree"                    Enabled="false" />
            <HotfixElement FileHash="KeyChain"                          Enabled="false" />
            <HotfixElement FileHash="LfgDungeons"                       Enabled="false" />
            <HotfixElement FileHash="Light"                             Enabled="false" />
            <HotfixElement FileHash="LiquidType"                        Enabled="false" />
            <HotfixElement FileHash="Lock"                              Enabled="false" />
            <HotfixElement FileHash="MailTemplate"                      Enabled="false" />
            <HotfixElement FileHash="Map"                               Enabled="false" />
            <HotfixElement FileHash="MapDifficulty"                     Enabled="false" />
            <HotfixElement FileHash="ModifierTree"                      Enabled="false" />
            <HotfixElement FileHash="Mount"                             Enabled="false" />
            <HotfixElement FileHash="MountCapability"                   Enabled="false" />
            <HotfixElement FileHash="MountTypeXCapability"              Enabled="false" />
            <HotfixElement FileHash="Movie"                             Enabled="false" />
            <HotfixElement FileHash="NameGen"                           Enabled="false" />
            <HotfixElement FileHash="NamesProfanity"                    Enabled="false" />
            <HotfixElement FileHash="NamesReserved"                     Enabled="false" />
            <HotfixElement FileHash="NamesReservedLocale"               Enabled="false" />
            <HotfixElement FileHash="OverrideSpellData"                 Enabled="false" />
            <HotfixElement FileHash="Phase"                             Enabled="false" />
            <HotfixElement FileHash="PhaseXPhaseGroup"                  Enabled="false" />
            <HotfixElement FileHash="PlayerCondition"                   Enabled="false" />
            <HotfixElement FileHash="PowerDisplay"                      Enabled="false" />
            <HotfixElement FileHash="PowerType"                         Enabled="false" />
            <HotfixElement FileHash="PvpDifficulty"                     Enabled="false" />
            <HotfixElement FileHash="QuestFactionReward"                Enabled="false" />
            <HotfixElement FileHash="QuestMoneyReward"                  Enabled="false" />
            <HotfixElement FileHash="QuestPackageItem"                  Enabled="false" />
            <HotfixElement FileHash="QuestSort"                         Enabled="false" />
            <HotfixElement FileHash="QuestV2"                           Enabled="false" />
            <HotfixElement FileHash="QuestXP"                           Enabled="false" />
            <HotfixElement FileHash="RandPropPoints"                    Enabled="false" />
            <HotfixElement FileHash="RulesetItemUpgrade"                Enabled="false" />
            <HotfixElement FileHash="ScalingStatDistribution"           Enabled="false" />
            <HotfixElement FileHash="Scenario"                          Enabled="false" />
            <HotfixElement FileHash="ScenarioStep"                      Enabled="false" />
            <HotfixElement FileHash="SceneScript"                       Enabled="false" />
            <HotfixElement FileHash="SceneScriptPackage"                Enabled="false" />
            <HotfixElement FileHash="SkillLine"                         Enabled="false" />
            <HotfixElement FileHash="SkillLineAbility"                  Enabled="false" />
            <HotfixElement FileHash="SkillRaceClassInfo"                Enabled="false" />
            <HotfixElement FileHash="SoundKit"                          Enabled="false" />
            <HotfixElement FileHash="SpecializationSpells"              Enabled="false" />
            <HotfixElement FileHash="Spell"                             Enabled="false" />
            <HotfixElement FileHash="SpellAuraOptions"                  Enabled="false" />
            <HotfixElement FileHash="SpellAuraRestrictions"             Enabled="false" />
            <HotfixElement FileHash="SpellCastTimes"                    Enabled="false" />
            <HotfixElement FileHash="SpellCastingRequirements"          Enabled="false" />
            <HotfixElement FileHash="SpellCategories"                   Enabled="false" />
            <HotfixElement FileHash="SpellCategory"                     Enabled="false" />
            <HotfixElement FileHash="SpellClassOptions"                 Enabled="false" />
            <HotfixElement FileHash="SpellCooldowns"                    Enabled="false" />
            <HotfixElement FileHash="SpellDuration"                     Enabled="false" />
            <HotfixElement FileHash="SpellEffect"                       Enabled="false" />
            <HotfixElement FileHash="SpellEffectScaling"                Enabled="false" />
            <HotfixElement FileHash="SpellEquippedItems"                Enabled="false" />
            <HotfixElement FileHash="SpellFocusObject"                  Enabled="false" />
            <HotfixElement FileHash="SpellInterrupts"                   Enabled="false" />
            <HotfixElement FileHash="SpellItemEnchantment"              Enabled="false" />
            <HotfixElement FileHash="SpellItemEnchantmentCondition"     Enabled="false" />
            <HotfixElement FileHash="SpellLearnSpell"                   Enabled="false" />
            <HotfixElement FileHash="SpellLevels"                       Enabled="false" />
            <HotfixElement FileHash="SpellMisc"                         Enabled="false" />
            <HotfixElement FileHash="SpellPower"                        Enabled="false" />
            <HotfixElement FileHash="SpellPowerDifficulty"              Enabled="false" />
            <HotfixElement FileHash="SpellProcsPerMinute"               Enabled="false" />
            <HotfixElement FileHash="SpellProcsPerMinuteMod"            Enabled="false" />
            <HotfixElement FileHash="SpellRadius"                       Enabled="false" />
            <HotfixElement FileHash="SpellRange"                        Enabled="false" />
            <HotfixElement FileHash="SpellReagents"                     Enabled="false" />
            <HotfixElement FileHash="SpellScaling"                      Enabled="false" />
            <HotfixElement FileHash="SpellShapeshift"                   Enabled="false" />
            <HotfixElement FileHash="SpellShapeshiftForm"               Enabled="false" />
            <HotfixElement FileHash="SpellTargetRestrictions"           Enabled="false" />
            <HotfixElement FileHash="SpellTotems"                       Enabled="false" />
            <HotfixElement FileHash="SpellXSpellVisual"                 Enabled="false" />
            <HotfixElement FileHash="SummonProperties"                  Enabled="false" />
            <HotfixElement FileHash="TactKey"                           Enabled="false" />
            <HotfixElement FileHash="Talent"                            Enabled="false" />
            <HotfixElement FileHash="TaxiNodes"                         Enabled="false" />
            <HotfixElement FileHash="TaxiPath"                          Enabled="false" />
            <HotfixElement FileHash="TaxiPathNode"                      Enabled="false" />
            <HotfixElement FileHash="TotemCategory"                     Enabled="false" />
            <HotfixElement FileHash="Toy"                               Enabled="false" />
            <HotfixElement FileHash="TransportAnimation"                Enabled="false" />
            <HotfixElement FileHash="TransportRotation"                 Enabled="false" />
            <HotfixElement FileHash="UnitPowerBar"                      Enabled="false" />
            <HotfixElement FileHash="Vehicle"                           Enabled="false" />
            <HotfixElement FileHash="VehicleSeat"                       Enabled="false" />
            <HotfixElement FileHash="WMOAreaTable"                      Enabled="false" />
            <HotfixElement FileHash="WorldMapArea"                      Enabled="false" />
            <HotfixElement FileHash="WorldMapOverlay"                   Enabled="false" />
            <HotfixElement FileHash="WorldMapTransforms"                Enabled="false" />
            <HotfixElement FileHash="WorldSafeLocs"                     Enabled="false" />
        </FileHashes>
    </Hotfix>
<system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data></configuration>

Results for creature and gameobject, 31/45 - Error: Failed writing CreatureTemplateNonWDB you told me that is a known error. Output Below

Loading DB...
Connecting to MySQL server: Server=localhost;Port=3306;Username=root;Database=wpp;CharSet=utf8;ConnectionTimeout=5;
SQL loaded in 00:00:00.667.
Finished loading DB in 00:00:02.338.

Loading module WowPacketParserModule.V6_0_2_19033.dll (fallback)
Loading module WowPacketParserModule.V7_0_3_22248.dll
[1/1 24330_2017-06-17_10-05-00.pkt]: Parsing 26.3MB of packets. Detected version V7_2_5_24330
[1/1 24330_2017-06-17_10-05-00.pkt]: Saved file to 'F:\PKTDATA\24330_2017-06-17_10-05-00_parsed.txt'
[1/1 24330_2017-06-17_10-05-00.pkt]: Parsed 196658 (99.195%) packets successfully, 65 (0.033%) with errors, skipped 404 (0.204%) and without structure 1126 (0.568%)  (total: 198253) in 00:00:17.301
1/45 - Write AreaTriggerTemplateData
2/45 - Write AreaTriggerTemplateVerticesData
3/45 - Write SpellAreaTriggersData
4/45 - Write GameObjectTemplateAddon
5/45 - Write Hotfixes
6/45 - Write HotfixData
7/45 - Write BroadcastText
8/45 - Write LocalesQuest
9/45 - Write LocalesQuestObjectives
10/45 - Write StartInformation
11/45 - Write ObjectNames
12/45 - Write SniffData
13/45 - Write WeatherUpdates
14/45 - Write SceneTemplates
15/45 - Write QuestOfferReward
16/45 - Write QuestPOI
17/45 - Write QuestGreeting
18/45 - Write QuestDetails
19/45 - Write QuestRequestItems
20/45 - Write Creature
20/45 - Error: Failed writing Creature
WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   at WowPacketParser.DBC.DBC..cctor() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 31
   --- End of inner exception stack trace ---
   at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\Store\Objects\WoWObject.cs:line 44
   at WowPacketParser.SQL.Builders.Spawns.Creature(Dictionary`2 units) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\Spawns.cs:line 128
21/45 - Write GameObject
21/45 - Error: Failed writing GameObject
WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected
   at DBFilesClient.NET.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader()
   at DBFilesClient.NET.Reader`1.Load()
   at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream)
   at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly)
   at WowPacketParser.DBC.DBC..cctor() in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\DBC\DBC.cs:line 31
   --- End of inner exception stack trace ---
   at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\Store\Objects\WoWObject.cs:line 44
   at WowPacketParser.SQL.Builders.Spawns.GameObject(Dictionary`2 gameObjects) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\Spawns.cs:line 346
22/45 - Write SpellTargetPosition
23/45 - Write CreatureTemplateAddon
24/45 - Write CreatureTemplateScalingData
25/45 - Write ModelData
26/45 - Write NpcTrainer
27/45 - Write NpcVendor
28/45 - Write CreatureEquip
29/45 - Write PointsOfInterest
30/45 - Write Gossip
31/45 - Write CreatureTemplateNonWDB
Entry: 33631 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33634 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33636 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33635 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
Entry: 33641 NpcFlag: Gossip, Trainer, ProfessionTrainer, Vendor
31/45 - Error: Failed writing CreatureTemplateNonWDB
WowPacketParser.exe Error: 0 : System.NullReferenceException: Object reference not set to an instance of an object.
   at WowPacketParser.SQL.Builders.UnitMisc.CreatureTemplateNonWDB(Dictionary`2 units) in F:\Trinty Sourcecode\WowPacketParser\WowPacketParser\SQL\Builders\UnitMisc.cs:line 487
32/45 - Write CreatureText
33/45 - Write VehicleAccessory
34/45 - Write NpcSpellClick
35/45 - Write NpcSpellClickMop
36/45 - Write QuestTemplate
37/45 - Write QuestObjective
38/45 - Write QuestVisualEffect
39/45 - Write CreatureTemplate
40/45 - Write CreatureTemplateQuestItem
41/45 - Write GameObjectTemplate
42/45 - Write GameObjectTemplateQuestItem
43/45 - Write ItemTemplate
44/45 - Write PageText
45/45 - Write NpcText
Dumping global sql: Saved file to 'UpdateSQL.sql'
Finished SQL file in 00:00:14.713.

QuestFlags2 has undefined flags: Unk10000
Brodywood900 commented 7 years ago

I'm having the same type of problems as well it seems it doesn't like the latest version I get a problem with MapDifficultyEntry with dbc on and off

Errors:

Unhandled Exception: System.AggregateException: One or more errors occurred. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected at DBFilesClient.NET.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.Reader`1.Load() at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream) at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, Object[] args) at WowPacketParser.DBC.DBC.<>c.b__20_0(Type type) in C:\projects\wowpacketparser-191\WowPacketParser\DBC\DBC.cs:line 67 at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.b__1() at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask) at System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object ) --- End of inner exception stack trace --- at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally) at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally) at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body) at WowPacketParser.DBC.DBC.d__20.MoveNext() in C:\projects\wowpacketparser-191\WowPacketParser\DBC\DBC.cs:line 80 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.b__6_1(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() at System.Threading.ThreadPoolWorkQueue.Dispatch() 20/45 - Error: Failed writing Creature WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected at DBFilesClient.NET.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.Reader`1.Load() at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream) at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly) at WowPacketParser.DBC.DBC..cctor() in C:\projects\wowpacketparser-191\WowPacketParser\DBC\DBC.cs:line 31 --- End of inner exception stack trace --- at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in C:\projects\wowpacketparser-191\WowPacketParser\Store\Objects\WoWObject.cs:line 44 at WowPacketParser.SQL.Builders.Spawns.Creature(Dictionary`2 units) in C:\projects\wowpacketparser-191\WowPacketParser\SQL\Builders\Spawns.cs:line 128 21/45 - Write GameObject 21/45 - Error: Failed writing GameObject WowPacketParser.exe Error: 0 : System.TypeInitializationException: The type initializer for 'WowPacketParser.DBC.DBC' threw an exception. ---> System.InvalidOperationException: Structure MapDifficultyEntry is missing fields (8 found, 9 expected at DBFilesClient.NET.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.WDB6.Reader`1.GenerateRecordLoader() at DBFilesClient.NET.Reader`1.Load() at DBFilesClient.NET.Storage`1.FromStream(Stream dataStream) at DBFilesClient.NET.Storage`1..ctor(String fileName, Boolean readOnly) at WowPacketParser.DBC.DBC..cctor() in C:\projects\wowpacketparser-191\WowPacketParser\DBC\DBC.cs:line 31 --- End of inner exception stack trace --- at WowPacketParser.Store.Objects.WoWObject.GetDefaultSpawnTime(UInt32 difficultyID) in C:\projects\wowpacketparser-191\WowPacketParser\Store\Objects\WoWObject.cs:line 44 at WowPacketParser.SQL.Builders.Spawns.GameObject(Dictionary`2 gameObjects) in C:\projects\wowpacketparser-191\WowPacketParser\SQL\Builders\Spawns.cs:line 346 **Config:**
****
Taaboy commented 7 years ago

Yeah using 24015 DBC works fine, with the latest , but 24330/24367 and above DBC extractions, fail when running if used, causing errors. On top of that, updating WPP and not the sniffer version. Is making things harder to run for the updated client/wpp/emu. And Errors Persist with no word from anyone for update of problem.

funjoker commented 5 years ago

7.3.5 7.2.5 DBCs are unsupported by DBFilesClient.NET

7.2.0 last workin DBC

funjoker commented 5 years ago

WDC2 is now supported BfA DBC needed.

Close

Aokromes commented 5 years ago

d980e72b130e5cf2d336d1bdf9d92db07c7314a3