Utilizador:Daveh/ESO Log Collector

A UESPWiki – Sua fonte de The Elder Scrolls desde 1995

General Stuff

Data to Log

  • General
  • Identifier for each entry parsed (to prevent parsing duplicate entries twice)
  • Entry counters for submitter name
  • Entry counters for IP address?
  • For Each Record
  • Who saw it first
  • History of changes
  • Times seen
  • Item
  • Locations found
  • Basic stats
  • NPC
  • Location
  • Basic stats
  • Loot Drop
  • Locations
  • Frequency
  • General Locations
  • Chests
  • Heavy Sacks
  • Resource Nodes
  • Skyshard
  • Quest
  • Quest stage/conditions
  • Location of stage
  • Related dialog?
  • Rewards
  • Dialog
  • NPC
  • Location
  • Related to quest?
  • Recipes
  • Ingredient list
  • Result
  • Achievements?
  • Global?

Record History

  • Time first seen
  • Time last seen
  • Game version?
  • Record diffs

Base Items

  • Data
  • Name
  • ID
  • Trait
  • Style?
  • Icon?
  • Craft type
  • Type
  • Equip Type?
  • Quality
  • Locked?

Base Enchantments

  • Data
  • Name
  • ID
  • Description

Items

  • Data
  • Name
  • Base ID
  • Item Level
  • Enchantment
  • Enchant Level
  • Style?
  • Icon
  • Value
  • Link color?
  • Raw link?
  • Other link data (20 integers, 6 referenced in other fields)

User

  • Data
  • Name (Primary)
  • LogEntryCount
  • DuplicateCount
  • ErrorCount
  • Enabled

IPAddress

  • Data
  • IPAddress (Primary)
  • Enabled

UserIP

  • UserName
  • IPAddress

Books

  • Data
  • Title
  • BodyText
  • Skill
  • Medium
  • IsLore
  • Icon
  • CategoryIndex
  • CollectionIndex
  • BookIndex
  • GuildIndex

Database Design

  • TimeStamp Table
Hold the combined gameTime and timeStamp for all parsed log entries to prevent entries from being parsed twice. An additional entry hash (CRC32) is also required to distinguish entries that happen within the same millisecond. There is a very low chance of different entries having identical values for these fields. Global and achievement logs will be identified by their field "start" time.
    CREATE TABLE IF NOT EXISTS logUniqueTime (
         gameTime INTEGER NOT NULL,
         timeStamp BIGINT NOT NULL,
         entryHash BIGINT NOT NULL,
         PRIMARY KEY (gameTime, timeStamp, entryHash)
    );
  • User Table
Holds basic user information.
    CREATE TABLE IF NOT EXISTS user (
         name TINYTEXT NOT NULL,
         entryCount INTEGER NOT NULL,
         errorCount INTEGER NOT NULL,
         duplicateCount INTEGER NOT NULL,
         newCount INTEGER NOT NULL,
         enabled TINYINT NOT NULL DEFAULT 1,
         PRIMARY KEY (name)
    );
  • IPAddress Table
Holds IPAddress information
    CREATE TABLE IF NOT EXISTS ipaddress (
         ipaddress TINYTEXT NOT NULL,
         enabled TINYINT NOT NULL DEFAULT 1,
         PRIMARY KEY (ipaddress)
    );
  • UserIPAddress Table
Relates which IPs each user has been seen from.
    CREATE TABLE IF NOT EXISTS useripaddress (
         userName TINYTEXT NOT NULL,
         ipaddress TINYTEXT NOT NULL,
         INDEX name_index(userName)
    );
  • Book Table
   CREATE TABLE IF NOT EXISTS book (
         id BIGINT NOT NULL,
         title TINYTEXT NOT NULL,
         body TEXT NOT NULL,
         skillIndex INTEGER NOT NULL,
         mediumIndex INTEGER NOT NULL,
         isLore INTEGER NOT NULL,
         icon TEXT NOT NULL,
         categoryIndex INTEGER NOT NULL,
         collectionIndex INTEGER NOT NULL,
         bookIndex INTEGER NOT NULL,
         guildIndex INTEGER NOT NULL,
         PRIMARY KEY (id)
    );


Log Viewer

The log viewer can be found online at: http://esolog.uesp.net/

  • Query Parameters
  • record -- The type of record to view (npc, item, location, etc...). If none the main menu is displayed.
  • search -- The search term to look look for.
  • raw -- A value of 1 indicates to display all fields with their raw values and not formatted or processed.
  • sortorder -- A value of 'a' or 'd' to indicate the sort order (Ascending or Descending).
  • action -- Specifies to display a specific view other than the default record listing:
  • view -- Display a record or record field as given by the other parameters.
  • id -- The record ID to display for action=view.
  • filter -- The field to filter according to filterid's value.
  • filterid -- The specific filter value to display record for.
  • start -- The starting index to begin displaying records at.
  • field -- The specific record field to display if viewing a record.
  • format -- The output format which can be one of the below:
  • html -- Default
  • csv -- Try to output in a semi-standard CSV format. Only works for the record and search views. Note that this removes the display limit so large tables may take a while to export.
  • Examples
    record=location&filter=bookId&filterid=1081
  • Display locations for book #1081.


    == Extended Item Database ==
  • Fields
  • Flags (could be combined or individual fields)
  • Unique
  • UniqueEquipped
  • Crafted
  • Siege
  • VendorTrash
  • ArmorDecay
  • Consumable
  • name
  • itemLink
  • itemId
  • internalLevel
  • internalSubType
  • enchantId
  • enchantLevel
  • enchantSubType
  • potionData
  • itemType
  • equipType
  • condition
  • reqLevel
  • value
  • quality
  • style
  • trait
  • icon
  • description
  • craftSkill
  • glyphMinLevel
  • glyphMaxLevel
  • Weapon Specific
  • weaponType
  • weaponPower
  • Armor Specific
  • armorType
  • armorRating
  • Enchantment Related
  • enchantName
  • enchantDesc
  • numCharges
  • maxCharges
  • Set Related
  • setName
  • setBonusCount
  • setMaxEquipCount
  • setBonusCount1
  • setBonusCount2
  • setBonusCount3
  • setBonusCount4
  • setBonusCount5
  • setBonusDesc1
  • setBonusDesc2
  • setBonusDesc3
  • setBonusDesc4
  • setBonusDesc5
  • Ability Use Related
  • abilityName
  • abilityDesc
  • abilityCooldown
  • Other
  • bookTitle
  • runeType
  • bindType
  • siegeHP
  • traitDescription
  • runeRank
  • craftSkillRank
  • recipeRank
  • recipeQuality
  • refinedItemLink
  • resultItemLink
  • ingredientName[1..N]
  • traitAbilityDescription
  • traitCooldown
  • materialLevelDescription
  • Field Notes
  • Level - Integer value from 1-64 (and beyond). Level 50 is V1, 51 V2 and so on. Technically a little different than how ESO handles levels but it makes it much simpler as there is really no level 50 in the game (you level from 49 to V1) and most level 50 items have identical stats as their V1 versions.
  • Invalid/Empty Values - Values of -1 will be used for most types/values (assuming the field in question has no meaningful negative values).
  • When parsing log ignore mined item entries before a timestamp of 4743729922978086912.
  • DB Table Structure
    CREATE TABLE IF NOT EXISTS minedItem (
                        id BIGINT NOT NULL AUTO_INCREMENT,
                        logId BIGINT NOT NULL,
                        link TINYTEXT NOT NULL,
                        itemId INTEGER NOT NULL DEFAULT 0,
                        internalLevel SMALLINT NOT NULL DEFAULT 0,
                        internalSubtype INTEGER NOT NULL DEFAULT 0,
                        potionData INTEGER NOT NULL DEFAULT 0,
                        name TINYTEXT NOT NULL,
                        description TEXT NOT NULL,
                        style TINYINT NOT NULL,
                        trait TINYINT NOT NULL,
                        quality TINYINT NOT NULL,
                        value INTEGER NOT NULL DEFAULT -1,
                        level TINYINT NOT NULL,
                        type TINYINT NOT NULL,
                        equipType TINYINT NOT NULL DEFAULT -1,
                        weaponType TINYINT NOT NULL DEFAULT -1,
                        armorType TINYINT NOT NULL DEFAULT -1,
                        craftType TINYINT NOT NULL DEFAULT -1,
                        armorRating INTEGER NOT NULL DEFAULT -1,
                        weaponPower INTEGER NOT NULL DEFAULT -1,
                        cond INTEGER NOT NULL DEFAULT -1,
                        enchantId INTEGER NOT NULL DEFAULT -1,
                        enchantLevel SMALLINT NOT NULL DEFAULT -1,
                        enchantSubtype INTEGER NOT NULL DEFAULT -1,
                        enchantName TINYTEXT,
                        enchantDesc TEXT NOT NULL,
                        numCharges INTEGER NOT NULL DEFAULT -1,
                        maxCharges INTEGER NOT NULL DEFAULT -1,
                        abilityName TINYTEXT,
                        abilityDesc TEXT NOT NULL,
                        abilityCooldown INTEGER NOT NULL DEFAULT -1,
                        setName TINYTEXT NOT NULL,
                        setBonusCount TINYINT NOT NULL DEFAULT -1,
                        setMaxEquipCount TINYINT NOT NULL DEFAULT -1,
                        setBonusCount1 TINYINT NOT NULL DEFAULT -1,
                        setBonusCount2 TINYINT NOT NULL DEFAULT -1,
                        setBonusCount3 TINYINT NOT NULL DEFAULT -1,
                        setBonusCount4 TINYINT NOT NULL DEFAULT -1,
                        setBonusCount5 TINYINT NOT NULL DEFAULT -1,
                        setBonusDesc1 TINYTEXT NOT NULL,
                        setBonusDesc2 TINYTEXT NOT NULL,
                        setBonusDesc3 TINYTEXT NOT NULL,
                        setBonusDesc4 TINYTEXT NOT NULL,
                        setBonusDesc5 TINYTEXT NOT NULL,
                        glyphMinLevel SMALLINT NOT NULL DEFAULT -1,
                        glyphMaxLevel SMALLINT NOT NULL DEFAULT -1,
                        runeType TINYINT NOT NULL DEFAULT -1,
                        runeRank TINYINT NOT NULL DEFAULT -1,
                        bindType TINYINT NOT NULL DEFAULT -1,
                        siegeHP INTEGER NOT NULL DEFAULT -1,
                        bookTitle TINYTEXT,
                        craftSkillRank TINYINT NOT NULL DEFAULT -1,
                        recipeRank TINYINT NOT NULL DEFAULT -1,
                        recipeQuality TINYINT NOT NULL DEFAULT -1,
                        refinedItemLink TINYTEXT NOT NULL,
                        resultItemLink TINYTEXT NOT NULL,
                        materialLevelDesc TINYTEXT NOT NULL,
                        traitDesc TINYTEXT,
                        traitAbilityDesc TINYTEXT NOT NULL,
                        traitCooldown TINYINT NOT NULL DEFAULT -1,
                        isUnique BIT NOT NULL DEFAULT 0,
                        isUniqueEquipped BIT NOT NULL DEFAULT 0,
                        isVendorTrash BIT NOT NULL DEFAULT 0,
                        isArmorDecay BIT NOT NULL DEFAULT 0,
                        isConsumable BIT NOT NULL DEFAULT 0,
                        icon TINYTEXT NOT NULL,
                        PRIMARY KEY (id),
                        INDEX index_link (link(64)),
                        INDEX index_itemId (itemId),
                        INDEX index_enchantId (enchantId),
                        FULLTEXT(name),
                        FULLTEXT(description),
                        FULLTEXT(setName),
                        FULLTEXT(abilityName),
                        FULLTEXT(abilityDesc),
                        FULLTEXT(setBonusDesc1, setBonusDesc2, setBonusDesc3, setBonusDesc4, setBonusDesc5),
                        FULLTEXT(bookTitle)
                );

Global/Function Data

  • Desired Data
  • Functions
  • Definition
  • Calls
  • Global Variables
  • Value
  • Usage
  • Class
  • Methods
  • Members
  • Usage
  • Other
  • History/API changes
  • Source code browsing
  • font-family: "Consolas", "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important;
  • Actions
  • Global Value
  • Tooltip = value (number/string)
  • Link = jump to global page
  • Global Function
  • Tooltip = Function Def?
  • Link = jump to global page
  • Local Object
  • Tooltip = Line Number?
  • Link = jump to definition in file?
  • Global Value Page
  • Type + Value?
  • Definition + location
  • Usage locations
  • Global Function Page
  • Definition + location
  • Usage locations
  • Global Function Page
  • Global UserData/Meta/Index?
  • Methods
  • Members
  • Definition location?
  • Usage locations?


Item Link Image Test

[1]

ItemLink Documentation

The http://esoitem.uesp.net/itemLink.php script outputs an HTML page containing ESO item data in the same format as the in-game item tooltips.

Basic Description & Features

  • Output of item data in same format as the in-game tooltips.
  • Display of all item data in list format.
  • Dynamically adjust the level and quality of item to update data.
  • Output of image tooltip in HTML and image formats (see ItemLinkImage Documentation below).

Input Parameters

The following input parameters are supported.

  • itemid=[id] -- Required parameter that specifies the ESO item ID to display. The item ID can be found using the uespLog add-on and the "Show Item Info" context menu.
  • level=[value] -- Desired initial item level from 1 to 65. Veteran rank V1 can be specified as either "51" or "V1".
  • quality=[value] -- Desired initial item quality from 1 (Normal) to 5 (Legendary).
  • intlevel=[value] -- The internal "level" of the item from 1 to 50. See Item Link Format for more information.
  • inttype=[value] -- The internal subtype of the item from 1 to 400. See Item Link Format for more information.
  • link=[itemlink] -- Submit a complete item link. See Item Link Format for more information.
  • show -- If present all fields for the item are shown in the raw data section, even if empty.
  • output=[type] -- One of html or text. HTML is the default and shows the regular page. TEXT just lists all the item's fields in a basic text format.
  • summary -- If present the item will be displayed as a summary of all levels and qualities if available.
  • version=[value] or v=[value] -- Use data from an older version of the item database. Valid values are "1.5" (associated with game update 1.5) and eventually "1.6" and "1.7".

Typically you will just use the itemid parameter or a combination of itemid + level + quality or itemid + intlevel + inttype".

Examples

Notes

  • The page in IE is half-broken. Font is not correct and the slider controls do not work.

ItemLinkImage Documentation

The http://esoitem.uesp.net/itemLinkImage.php script outputs a PNG image containing ESO item data in the same format as the in-game item tooltips.

Basic Description & Features

item-70-1-2.png itemint-70-50-308.png

Input Parameters

The following input parameters are supported (basically identical to the itemLink.php script).

  • itemid=[id] -- Required parameter that specifies the ESO item ID to display. The item ID can be found using the uespLog add-on and the "Show Item Info" context menu.
  • level=[value] -- Desired initial item level from 1 to 65. Veteran rank V1 can be specified as either "51" or "V1".
  • quality=[value] -- Desired initial item quality from 1 (Normal) to 5 (Legendary).
  • intlevel=[value] -- The internal "level" of the item from 1 to 50. See Item Link Format for more information.
  • inttype=[value] -- The internal subtype of the item from 1 to 400. See Item Link Format for more information.
  • link=[itemlink] -- Submit a complete item link. See Item Link Format for more information.
  • nocache -- Force the item image to be regenereated instead of looking for it in the existing image cache. This also updates the item image in the cache.
  • summary -- If present the item will be displayed as a summary of all levels and qualities if available.
  • version=[value] or v=[value] -- Use data from an older version of the item database. Valid values are "1.5" (associated with game update 1.5) and eventually "1.6" and "1.7".

Typically you will just use the itemid parameter or a combination of itemid + level + quality or itemid + intlevel + inttype".

Direct Image Linking

Using the itemLink.php won't let you directly link an image into a Wiki page. The following link formats can be used

    http://esoitem.uesp.net/item-ID-LEVEL-QUALITY.png
    http://esoitem.uesp.net/itemint-ID-INTLEVEL-INTTYPE.png

Substitute the appropriate values for LEVEL, etc... in the links. You can also specify the explicit game version of the item you wish to view in the format:

    http://esoitem.uesp.net/vVERSION/item-ID-LEVEL-QUALITY.png
    http://esoitem.uesp.net/vVERSION/itemint-ID-INTLEVEL-INTTYPE.png

Where VERSION is 1.5, 1.6, 1.7, 1.8, 1.8pts, 1.9pts, etc...

Examples

Notes

DumpMinedItems Documentation

The http://esoitem.uesp.net/dumpMinedItems.php script outputs a simple table of data for a single ESO item.

Basic Description & Features

  • Outputs a table of data on a single ESO item.
  • Output in CSV, HTML or Wiki format.

Input Parameters

The following input parameters are supported:

  • itemid=[id] -- Required parameter that specifies the ESO item ID to display. The item ID can be found using the uespLog add-on and the "Show Item Info" context menu.
  • sort=[field1,field2,...] -- Specifies the sort order. Can be any number of field names separated by commas. Specifying "none" will remove any sort order. By default the sort order is level, quality, value.
  • output=[type] -- Specifies the type of output to show. Can be one of "html", "csv", or "wiki". Default is "csv".
  • fields=[field1,field2,...] -- Sets the fields to output in the given order. Can be any number of field name separated by commas. Can also be special values of "default" or "all". Note that duplicate and invalid field names will be removed and blank or invariant fields will not be shown by default.
  • notransform -- If present no fields will be transformed and will be displayed as their raw value.
  • keepblank -- By default fields that are entirely empty will be removed from the table. If this parameter is present any blank fields will be kept.
  • keepinvariant -- By default fields that don't change will be removed from the table. If this parameter is present any such invariant fields will be kept.
  • showlimit -- Only displays two rows, the first and last. Note that "first" and "last" will depend on the sort order. The purpose of this is to easily find the range of data for the item.
  • type=[type] -- Show a summary table of all items with the given type (1-53).
  • equiptype=[type] -- Show a summary table of all items with the given equip type (1-14).
  • weapontype=[type] -- Show a summary table of all items with the given weapon type (1-15).
  • armortype=[type] -- Show a summary table of all items with the given armor type (1-3).
  • All four type fields can be combined to further limit which items are displayed. See below for explicit type values.
  • extrait -- If present trait names will be displayed as Trait (Value) instead of simply like Trait.
  • version=[name] or v=[name] -- Load a specific version of the item data. Valid versions are currently:
  • 1.5
  • 1.6
  • 1.7
  • 1.8
  • 1.8pts
  • 1.9pts
  • etc... (for future updates)

Examples

Field Names

Current valid field names are listed below:

  • id
  • logId
  • link
  • itemId
  • internalLevel
  • internalSubtype
  • potionData
  • name
  • description
  • icon
  • style
  • trait
  • quality
  • type
  • equipType
  • weaponType
  • armorType
  • craftType
  • armorRating
  • weaponPower
  • value
  • level
  • cond
  • enchantId
  • enchantLevel
  • enchantSubtype
  • enchantName
  • enchantDesc
  • maxCharges
  • abilityName
  • abilityDesc
  • abilityCooldown
  • setName
  • setBonusCount
  • setMaxEquipCount
  • setBonusCount1
  • setBonusCount2
  • setBonusCount3
  • setBonusCount4
  • setBonusCount5
  • setBonusDesc1
  • setBonusDesc2
  • setBonusDesc3
  • setBonusDesc4
  • setBonusDesc5
  • glyphMinLevel
  • glyphMaxLevel
  • runeType
  • runeRank
  • bindType
  • siegeHP
  • bookTitle
  • craftSkillRank
  • recipeRank
  • recipeQuality
  • refinedItemLink
  • resultItemLink
  • traitDesc
  • traitAbilityDesc
  • traitCooldown
  • materialLevelDesc
  • isUnique
  • isUniqueEquipped
  • isVendorTrash
  • isArmorDecay
  • isConsumable
  • tags
  • comment

Item Types

  1. Weapon
  2. Armor
  3. Plug
  4. Food
  5. Trophy
  6. Siege
  7. Potion
  8. Scroll
  9. Tool
  10. Ingredient
  11. Additive
  12. Drink
  13. Costume
  14. Disguise
  15. Tabard
  16. Lure
  17. Raw Material
  18. Container
  19. Soul Gem
  20. Weapon Glyph
  21. Armor Glyph
  22. Lockpick
  23. Weapon Booster
  24. Armor Booster
  25. Enchantment Booster
  26. Jewelry Glyph
  27. Spice
  28. Flavoring
  29. Recipe
  30. Poison
  31. Reagent
  32. Enchanting Rune
  33. Alchemy Base
  34. Collectible
  35. Blacksmithing Raw Material
  36. Blacksmithing Material
  37. Woodworking Raw Material
  38. Woodworking Material
  39. Clothier Raw Material
  40. Clothier Material
  41. Blacksmithing Booster
  42. Woodworking Booster
  43. Clothier Booster
  44. Style Material
  45. Armor Trait
  46. Weapon Trait
  47. Ava Repair
  48. Trash
  49. Spellcrafting Tablet
  50. Mount
  51. Potency Rune
  52. Aspect Rune
  53. Essence Rune

Equip Types

  1. Head
  2. Neck
  3. Chest
  4. Shoulders
  5. One Hand
  6. Two Hand
  7. Off Hand
  8. Waist
  9. Legs
  10. Feet
  11. Costume
  12. Ring
  13. Hand
  14. Main Hand

Armor Types

  1. Light
  2. Medium
  3. Heavy

Weapon Types

  1. Axe
  2. Hammer
  3. Sword
  4. Two handed Sword
  5. Two handed Axe
  6. Two handed Hammer
  7. Prop
  8. Bow
  9. Healing Staff
  10. Rune
  11. Dagger
  12. Fire Staff
  13. Frost Staff
  14. Shield
  15. Lightning Staff

Notes


WikiEsoItemLink Documentation

WikiEsoItemLink is a MediaWiki extension that adds the <esoitemlink> HTML tag which permits a popup item link to be displayed for ESO items, for example: [Hammer of the Resilient Yokuda]. Hovering over the link will show an item popup similar to the in-game display. Clicking the item link will bring you to the a page showing the item data in more detail.

Basic Usage

Simply use the <esoitemlink> tag when editing a wiki article like:

<esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink>

Tag Parameters

The following input parameters are supported:

  • itemid=[id] -- Specifies the ESO item ID to display.
  • link=[itemlink] -- The complete item link text.
  • level=[value] -- The item level from 1-v14.
  • quality=[value] -- The item's quality from 1-5.
  • intlevel=[value] -- The item's internal level from 1-50.
  • inttype=[value] -- The item's internal type.
  • summary=[value] -- A non-zero value will show the item summary data.

Examples

     <esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink>
     <esoitemlink itemid="54885" summary="1">[Hammer of the Resilient Yokuda]</esoitemlink>
     <esoitemlink itemid="54885" intlevel="49" inttype="6" quality="5">[Hammer of the Resilient Yokuda]</esoitemlink>
     <esoitemlink link="|H0:item:54885:6:49:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|hName|h">[Hammer of the Resilient Yokuda]</esoitemlink>

Notes

  • Either the itemid or link has to be present.