User:Daveh/ESO Log Collector

The UESPWiki – Your source for The Elder Scrolls since 1995
Jump to: navigation, search

General Stuff[edit]

Data to Log[edit]

  • 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[edit]

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

Base Items[edit]

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

Base Enchantments[edit]

  • Data
  • Name
  • ID
  • Description

Items[edit]

  • 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[edit]

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

IPAddress[edit]

  • Data
  • IPAddress (Primary)
  • Enabled

UserIP[edit]

  • UserName
  • IPAddress

Books[edit]

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

Database Design[edit]

  • 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[edit]

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[edit]

  • 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[edit]

[1]

ItemLink Documentation[edit]

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[edit]

  • 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[edit]

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 Link Format Details for more information.
  • inttype=[value] -- The internal subtype of the item from 0 to 370. See SubType Values for more information.
  • link=[itemlink] -- Submit a complete item link. See Link Format Details 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".
  • stolen=[0|1] -- Specifies whether the item is stolen or not.
  • enchantfactor=[value] -- Increase the enchantment by the given value (floating point number, 0.0 is no change, 1.0 would be double).
  • style=[value] -- Use a custom style for the item.
  • setcount=[value] -- If present this indicates the number of set items currently equipped by the player (0-5).
  • potiondata=[value] -- The raw potion data for potions and poisons.
  • writ1=[value]
  • writ2=[value]
  • writ3=[value]
  • writ4=[value]
  • writ5=[value]
  • writ6=[value] -- Specific values for master writs.
  • vouchers=[value] -- Number of reward vouchers for master writs. Note that this is the raw value which is the voucher number multiplied by 10000 and rounded (so 12000 = 1 voucher, 16000 = 2 vouchers).
  • trait=[value] -- Added in update 16 to support transmuted items with modified traits.
  • set=[setname] -- Displays a set only tooltip for the given set.

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

Examples[edit]

Notes[edit]

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

ItemLinkImage Documentation[edit]

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[edit]

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

Input Parameters[edit]

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.
  • 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".
  • set=[setname] -- Displays a set only tooltip for the given set.
  • See the itemLink.php parameters above for additional item related parameters.

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

Direct Image Linking[edit]

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[edit]

Notes[edit]

DumpMinedItems Documentation[edit]

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

Basic Description & Features[edit]

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

Input Parameters[edit]

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[edit]

Field Names[edit]

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[edit]

  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[edit]

  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[edit]

  1. Light
  2. Medium
  3. Heavy

Weapon Types[edit]

  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[edit]


Skill Browser[edit]

The skill browser is available at Special:EsoSkills.

Input Parameters[edit]

The following input parameters are supported:

  • showall or showall=1 -- Force the display of all ranks of active skills and ultimates. By default only Rank IV of these skills will be displayed.
  • skillid=[id] -- Set the initially focused skill to the given ability ID. Note that if the given skill is not shown it will not be displayed.
  • level=[value] -- Set the initial level for the calculator. Can be a value from 1-66 or a veteran rank v1-v16.
  • health=[value]
  • magicka=[value]
  • stamina=[value]
  • weapondamage=[value]
  • spelldamage=[value] -- Set the initial value for the given statistic in the calculator.


Skill Tooltip[edit]

You can use the <esoskill> tag in a Wiki article to display a popup skill tooltip.

Format[edit]

The <esoskill> has the following format:

    <esoskill skillid="[id]" level="#" health="#" magicka="#" stamina="#" spelldamage="#" weapondamage="#" showall="[0|1]">Text...</esoskill>
  • skillid="[id]" -- The only required parameter that specifies the skill to display.
  • level="[value]" -- Specifies the skill level as a value from 1-66 or veteran rank from v1-v16. The tooltip will choose appropriate values for any omitted parameters based on the given level (stats range from 1000-20000, and damage from 100-2000). Default value is v16.
  • health="[value]"
  • magicka="[value]"
  • stamina="[value]" -- The stat values for the skill. Default value is 1000-20000 based on level.
  • spelldamage="[value]"
  • weapondamage="[value]" -- The damage values for the skill. Default value is 100-2000 based on level.
  • showall="[0|1]" -- Manually specify the showall parameter for the skill link. Default value is 1.

The destination of the skill link when clicked will be the Skills Browser with the given skill highlighted.

Examples[edit]

WikiEsoItemLink Documentation[edit]

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[edit]

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[edit]

The following input parameters are supported:

  • questid=[id] -- Specifies the ESO quest item ID to display. See here for a list of valid quest item IDs.
  • collectid=[id] -- Specifies the ESO collectible item ID to display. See here for list of valid collectible item IDs.
  • itemid=[id] -- Specifies the ESO item ID to display. See here for a list of valid item IDs.
  • 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[edit]

     <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>
     <esoitemlink questid="2944">[A Gift of Sanctuary]</esoitemlink>
     <esoitemlink collectid="1">[Palomino Horse]</esoitemlink>

Notes[edit]

  • Either the itemid or link has to be present.

Export JSON[edit]

The esolog.uesp.net/exportJson.php service is available to export some of the collected data to a simple JSON format.

Input Parameters[edit]

  • table=TABLENAME -- Specify a single table to export. See below for a list of valid table names.
    ex: esolog.uesp.net/exportJson.php?table=setSummary
  • table[]=TABLENAME -- Specify one or more tables to export. Do not mix table and table[] input parameters as results may be not what you expect.
    ex: esolog.uesp.net/exportJson.php?table[]=setSummary&table[]=minedItemSummary
  • id=NAME -- Specify a record ID to limit output to records having that ID value. This may be required for some tables (see below). Field names associated with ID are:
      cpDisciplines         = name
      cpSkills              = abilityId
      cpSkillDescriptions   = abilityId
      minedItem             = itemId (required)
      minedItemSummary      = itemId
      minedSkills           = id
      skillCoef             = id
      playerSkills          = id
      setSummary            = setName
      achievementCategories = name
      achievementCriteria   = achievementId
      achievements          = id
      
      ex: esolog.uesp.net/exportJson.php?table=minedItem&id=70
  • ids=#,#,#,#... -- Specify one or more integer ids to load seperated by commas. If you specify the id parameter this is ignored. Be careful when specifying too many ids as it can take a while to load (depends on the table). Split into multiple requests if it takes more than a few seconds.
  • level=[1-66]
  • quality=[1-5] -- Only valid for the minedItem table in combination with an id. Using these will request data for the given item with only the specified level and quality. Level is a value from 1 to 66 with 66 being VR16 (cp160). Quality is a value from 1 (normal) to 5 (Legendary). Note that there may be more than one item returned in the result.
  • intlevel=[1-50]
  • inttype=[1-400] -- Only valid for the minedItem table in combination with an id. Using these will request data for the given item with only the specified internal level and type (the 2nd and 3rd data numbers in an item link). The internal level is a value from 0 to 50 and corresponds to the internalLevel field of a minedItem. The internal type is a value from 1-400 and corresponds to the internalSubtype field of a minedItem. Only 1 (or 0) items will be returned. These parameters cannot be mixed with level and quality.
  • type=[1-58] -- Only valid for the minedItemSummary table this parameter requests data for items of a specific type. See below for possible values.
  • equiptype=[1-15] -- Only valid for the minedItemSummary table this parameter requests data for items of a specific equip type. See below for possible values.
  • weapontype=[1-15] -- Only valid for the minedItemSummary table this parameter requests data for items of a specific weapon type. See below for possible values.
  • armortype=[1-3] -- Only valid for the minedItemSummary table this parameter requests data for items of a specific armor type. See below for possible values.
  • fields=field1,field2... -- Optional parameter that specifies which fields(columns) from the database are to be returned. Specify one or more fields separated by commas. By default all fields are returned. Note that an invalid field will result in an error.

Output Format[edit]

Output will be a JSON object with one element for each requested table and other elements indicating status. General elements include:

  • error -- If this field is present one or more errors occurred. The value of this element is an array of strings giving the specific error message. It will not be present if no errors occurred. Depending on the exact error there may be none or some record data included in the object. The HTTP status code will also be changed to a relevant 400/500 code on any error.
  • numRecords -- The total number of records exported to JSON. This will be the combined record count if multiple tables are requested.

Table elements will have the name of the table(s) as passed in with the table or table[] parameters. Format of these elements will be an array of objects with table field names and their values for each row. See esoitem.uesp.net/viewlog.php and select the relevant table to see the list of field names for each table.

For Example: esolog.uesp.net/exportJson.php?table=cpDisciplines results in the following JSON object:

    {
         "numRecords": 9,
         "cpDisciplines": [
         {
              "id": "163",
              "disciplineIndex": "1",
              "name": "The Tower",
              "description": "Under the Thief's influence, the Tower raises your Stamina and makes you more efficient with Spells and Abilities.",
              "attribute": "3"
         },
         {
              "id": "164",
              "disciplineIndex": "2",
              "name": "The Lord",
              "description": "Under the Warrior's influence, the Lord grants you Health and improves your Vitality.",
              "attribute": "1"
         },
         ...
         {
              "id": "171",
              "disciplineIndex": "9",
              "name": "The Lover",
              "description": "Under the Thief's influence, the Lover gives you Stamina and accelerates your Regeneration.",
              "attribute": "3"
         }]
    }

Example of error message: esolog.uesp.net/exportJson.php?table=none

    {
         "numRecords": 0,
         "error": [
              "Error: 'none' is not a valid table for JSON export!"
         ]
    }

Table Names[edit]

The following table names are currently supported:

    cpDisciplines
    cpSkills
    cpSkillDescriptions
    minedItem
    minedItemSummary
    minedSkills
    skillCoef
    playerSkills
    setSummary
    achievementCategories
    achievementCriteria
    achievements

Some of the above tables are "virtual" in that they are special filters over other tables:

  • playerSkills -- A view of minedSkills with only player accessible skills returned.
  • skillCoef -- A view of minedSkills with only skills having valid calculated skill coefficients returned.

If you need access to other tables from here you can contact Daveh to request access.


Examples[edit]

  • All achievement data:
    esolog.uesp.net/exportJson.php?table[]=achievements&table[]=achievementCriteria&table[]=achievementCategories
  • Summary of all equippable armor (includes rings, necklaces):
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=2
  • Summary of all equippable weapons (includes shields):
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=1
  • Summary of all armor glyphs:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=21
  • Summary of all jewelry glyphs:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=26
  • Summary of all weapon glyphs:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=20
  • Summary of all food:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=4
  • Summary of all drinks:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=12
  • Summary of all non-crafted potions:
    esolog.uesp.net/exportJson.php?table=minedItemSummary&type=7
  • Base data for crafted potions:
    esolog.uesp.net/exportJson.php?table=minedItem&id=1234567

Usage Notes[edit]

  • Some table sets are relatively large and may not be suitable for loading on every client load.
  • Usage is public and free for everyone. However, excessive usage may result in site blacklisting and IP blocking. If you're not sure you can contact Daveh and ask for details on what is considered "excessive".
  • Some result sets are relatively large (>30k records) especially if multiple tables are specified. Results are compressed but it can still be several MB in size. Some browsers (notably Chrome) seem to have a problem displaying such large JSON data sets.
  • For some tables the id field is an internal ID which may change. Tables that have a game related ID field include:
  • minedSkills (ID field is the game's abilityId)
  • achievements (ID field is the game's achievementId)

Quality Values[edit]

  • -1 = Unknown
  • 0 = Trash (light gray)
  • 1 = Normal (white)
  • 2 = Fine (green)
  • 3 = Superior (blue)
  • 4 = Epic (purple)
  • 5 = Legendary (gold)


Armor Type Values[edit]

  • -1 = Unknown
  • 0 = None
  • 1 = Light
  • 2 = Medium
  • 3 = Heavy


Weapon Type Values[edit]

Note that these are the weapon type values used by the game and may be modified/changed by the latest game version.

  • -1 = Unknown
  • 0 = None
  • 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


Equip Type Values[edit]

Note that these are the equip type values used by the game and may be modified/changed by the latest game version.

  • -1 = Unknown
  • 0 = None
  • 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
  • 15 = Poison


Item Type Values[edit]

Note that these are the item type values used by the game and may be modified/changed by the latest game version.

  • -1 = Unknown
  • 0 = None
  • 1 = Weapon
  • 2 = Armor
  • 3 = Plug
  • 4 = Food
  • 5 = Trophy
  • 6 = Siege
  • 7 = Potion
  • 8 = Motif
  • 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 = Potion Base (Used to be Alchemy Base prior to update 10)
  • 34 = Collectible
  • 35 = Blacksmith Raw Material
  • 36 = Blacksmith Material
  • 37 = Woodwork Raw Material
  • 38 = Woodwork Material
  • 39 = Clothier Raw Material
  • 40 = Clothier Material
  • 41 = Blacksmith Booster
  • 42 = Woodwork 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
  • 54 = Fish
  • 55 = Crown Repair
  • 56 = Treasure
  • 57 = Crown Store
  • 58 = Poison Base
Retrieved from "https://en.uesp.net/w/index.php?title=User:Daveh/ESO_Log_Collector&oldid=2639087"