12 366
edições
Alterações
→Direct Image Linking: add version linking
== 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/ 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 ==
[http://content3.uesp.net/esolog/itemLinkImage.php?itemid=27036&level=60&quality=5&test=file.png]
== ItemLink Documentation ==
The '''[http://esoitem.uesp.net/itemLink.php 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| 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 [[User:Daveh/ESO_Notes#Item_Link_Format|Item Link Format]] for more information.
:* ''inttype=[value]'' -- The internal subtype of the item from 1 to 400. See [[User:Daveh/ESO_Notes#Item_Link_Format|Item Link Format]] for more information.
:* ''link=[itemlink]'' -- Submit a complete item link. See [[User:Daveh/ESO_Notes#Item_Link_Format|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 ===
:* [http://esoitem.uesp.net/itemLink.php?itemid=70 http://esoitem.uesp.net/itemLink.php?itemid=70] -- Show item #70 with initial default level/quality.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70&level=25 http://esoitem.uesp.net/itemLink.php?itemid=70&level=25] -- Show item #70 with initial level of 25 and default quality.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70&level=40&quality=5 http://esoitem.uesp.net/itemLink.php?itemid=70&level=40&quality=5] -- Show item #70 with initial level of 40 and legendary quality.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70&level=55 http://esoitem.uesp.net/itemLink.php?itemid=55] -- Show item #70 with initial level of V5.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70&level=v5 http://esoitem.uesp.net/itemLink.php?itemid=v5] -- Show item #70 with initial level of V5.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70?itemid=70&intlevel=50&inttype=308 http://esoitem.uesp.net/itemLink.php?itemid=70&intlevel=50&inttype=308] -- Show item #70 with internal level of 50 and type 308.
:* [http://esoitem.uesp.net/itemLink.php?link=|H0:item:70:6:49:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|hName|h http://esoitem.uesp.net/itemLink.php?link=|H0:item:70:6:49:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|hName|h] -- Use an item link.
:* [http://esoitem.uesp.net/itemLink.php?itemid=70?itemid=70&summary http://esoitem.uesp.net/itemLink.php?itemid=70&summary ] -- Show item #70 with the summary data representing the range of values the item can have.
=== 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 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 ===
:* Output of item data in same format as the in-game tooltips.
:* Caching of images for future use. The script only generates the image once...future requests for that item simply return the previously generated image.
:* Direct linking to images using the [http://esoitem.uesp.net/item-70-1-2.png <nowiki>http://esoitem.uesp.net/item-70-1-2.png</nowiki>] and [http://esoitem.uesp.net/itemint-70-50-308.png <nowiki>http://esoitem.uesp.net/itemint-70-50-308.png</nowiki>] link formats.
http://esoitem.uesp.net/item-70-1-2.png http://esoitem.uesp.net/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 [[User:Daveh/ESO_Notes#Item_Link_Format|Item Link Format]] for more information.
:* ''inttype=[value]'' -- The internal subtype of the item from 1 to 400. See [[User:Daveh/ESO_Notes#Item_Link_Format|Item Link Format]] for more information.
:* ''link=[itemlink]'' -- Submit a complete item link. See [[User:Daveh/ESO_Notes#Item_Link_Format|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
<nowiki>http://esoitem.uesp.net/item-ID-LEVEL-QUALITY.png</nowiki>
<nowiki>http://esoitem.uesp.net/itemint-ID-INTLEVEL-INTTYPE.png</nowiki>
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:
<nowiki>http://esoitem.uesp.net/vVERSION/item-ID-LEVEL-QUALITY.png</nowiki>
<nowiki>http://esoitem.uesp.net/vVERSION/itemint-ID-INTLEVEL-INTTYPE.png</nowiki>
Where ''VERSION'' is 1.5, 1.6, 1.7, 1.8, 1.8pts, 1.9pts, etc...
=== Examples ===
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70 http://esoitem.uesp.net/itemLinkImage.php?itemid=70] -- Show item #70 with initial default level/quality.
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=25 http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=25] -- Show item #70 with initial level of 25 and default quality.
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=40&quality=5 http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=40&quality=5] -- Show item #70 with initial level of 40 and legendary quality.
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=55 http://esoitem.uesp.net/itemLinkImage.php?itemid=55] -- Show item #70 with initial level of V5.
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70&level=v5 http://esoitem.uesp.net/itemLinkImage.php?itemid=v5] -- Show item #70 with initial level of V5.
:* [http://esoitem.uesp.net/itemLinkImage.php?itemid=70?itemid=70&intlevel=50&inttype=308 http://esoitem.uesp.net/itemLinkImage.php?itemid=70&intlevel=50&inttype=308] -- Show item #70 with internal level of 50 and type 308.
:* [http://esoitem.uesp.net/itemLinkImage.php?link=|H0:item:70:6:49:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|hName|h http://esoitem.uesp.net/itemLinkImage.php?link=|H0:item:70:6:49:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0|hName|h] -- Use an item link.
:* [http://esoitem.uesp.net/item-70-25-3.png <nowiki>http://esoitem.uesp.net/item-70-25-3.png</nowiki>] -- Directly link to image of item ID #70, level 25, superior quality.
:* [http://esoitem.uesp.net/itemint-70-50-308.png <nowiki>http://esoitem.uesp.net/itemint-70-50-308.png</nowiki>] -- Directly link to image of item ID #70, internal level 50 and type 308.
=== Notes ===
:*
== DumpMinedItems Documentation ==
The '''[http://esoitem.uesp.net/dumpMinedItems.php 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 ===
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70 http://esoitem.uesp.net/dumpMinedItems.php?itemid=70] -- Dump data for item #70.
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&sort=armorRating http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&sort=armorRating] -- Dump data for item #70 but sort by the armor rating.
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=all http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=all] -- Dump data for item #70 and show all fields that aren't empty or invariant.
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=all&keepblank&keepinvariant&output=html http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=all&keepblank&keepinvariant&output=html] -- Dump data for item #70 and show all fields, even blank ones and fields that don't change in html format.
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=level,value http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&fields=level,value] -- Show only two fields for item #70.
:* [http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&showlimit&sort=value&output=wiki http://esoitem.uesp.net/dumpMinedItems.php?itemid=70&showlimit&sort=value&output=wiki] -- Show the min/max rows for item #70 by value in a wiki table format.
:* [http://esoitem.uesp.net/dumpMinedItems.php?type=1&output=html http://esoitem.uesp.net/dumpMinedItems.php?type=1&output=html] -- Show a summary Html table of all weapons.
:* [http://esoitem.uesp.net/dumpMinedItems.php?weapontype=8&output=html http://esoitem.uesp.net/dumpMinedItems.php?weapontype=8&output=html] -- Show a summary Html table of all bow weapons.
:* [http://esoitem.uesp.net/dumpMinedItems.php?equiptype=3&armortype=1&output=html http://esoitem.uesp.net/dumpMinedItems.php?equiptype=3&armortype=1&output=html] -- Show a summary Html table of all light chest armor pieces.
=== 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 ===
:# Weapon
:# Armor
:# Plug
:# Food
:# Trophy
:# Siege
:# Potion
:# Scroll
:# Tool
:# Ingredient
:# Additive
:# Drink
:# Costume
:# Disguise
:# Tabard
:# Lure
:# Raw Material
:# Container
:# Soul Gem
:# Weapon Glyph
:# Armor Glyph
:# Lockpick
:# Weapon Booster
:# Armor Booster
:# Enchantment Booster
:# Jewelry Glyph
:# Spice
:# Flavoring
:# Recipe
:# Poison
:# Reagent
:# Enchanting Rune
:# Alchemy Base
:# Collectible
:# Blacksmithing Raw Material
:# Blacksmithing Material
:# Woodworking Raw Material
:# Woodworking Material
:# Clothier Raw Material
:# Clothier Material
:# Blacksmithing Booster
:# Woodworking Booster
:# Clothier Booster
:# Style Material
:# Armor Trait
:# Weapon Trait
:# Ava Repair
:# Trash
:# Spellcrafting Tablet
:# Mount
:# Potency Rune
:# Aspect Rune
:# Essence Rune
=== Equip Types ===
:# Head
:# Neck
:# Chest
:# Shoulders
:# One Hand
:# Two Hand
:# Off Hand
:# Waist
:# Legs
:# Feet
:# Costume
:# Ring
:# Hand
:# Main Hand
=== Armor Types ===
:# Light
:# Medium
:# Heavy
=== Weapon Types ===
:# Axe
:# Hammer
:# Sword
:# Two handed Sword
:# Two handed Axe
:# Two handed Hammer
:# Prop
:# Bow
:# Healing Staff
:# Rune
:# Dagger
:# Fire Staff
:# Frost Staff
:# Shield
:# Lightning Staff
=== Notes ===
:* All the ESO game icons are available from [http://esoicons.uesp.net/ esoicons.uesp.net]. Simply append the icon filename as stored in the item: e.g. ''/esoui/art/icons/gear_breton_medium_shoulders_d.dds'' can be found as http://esoicons.uesp.net/esoui/art/icons/gear_breton_medium_shoulders_d.dds. File extensions can either be ''.dds'' or ''.png'' (DDS files are redirected to the PNG version). In order for the image to show up in the Wiki it should have the PNG extension.
== WikiEsoItemLink Documentation ==
''WikiEsoItemLink'' is a MediaWiki extension that adds the ''<nowiki><esoitemlink></nowiki>'' HTML tag which permits a popup item link to be displayed for ESO items, for example: <esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink>. 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 ''<nowiki><esoitemlink></nowiki>'' tag when editing a wiki article like:
<pre><nowiki><esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink></nowiki></pre>
=== 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 ===
:* Typical usage using the item's ID, level and quality: <esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink>
<pre> <esoitemlink itemid="54885" level="v5" quality="4">[Hammer of the Resilient Yokuda]</esoitemlink></pre>
:* Same item but showing the summary instead of a specific level/quality: <esoitemlink itemid="54885" summary="1">[Hammer of the Resilient Yokuda]</esoitemlink>
<pre> <esoitemlink itemid="54885" summary="1">[Hammer of the Resilient Yokuda]</esoitemlink></pre>
:* Using the internal level and type for an item: <esoitemlink itemid="54885" intlevel="49" inttype="6" quality="5">[Hammer of the Resilient Yokuda]</esoitemlink> (the quality parameter is used only to set the color of the link)
<pre> <esoitemlink itemid="54885" intlevel="49" inttype="6" quality="5">[Hammer of the Resilient Yokuda]</esoitemlink></pre>
:* Using an item link: <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> (this is currently the only way to get popup item links with enchantments)
<pre> <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></pre>
=== Notes ===
:* Either the ''itemid'' or ''link'' has to be present.