Wiki:WAR Database Layouts
The following tables define the Warhammer Online db tables that can be referenced using the Database Access Functions.
| Contents [hide] |
Warhammer Online
itemsets
| Field | Type(length) | Description |
|---|---|---|
| id | smallint(5) unsigned | A unique number defined by our system at the time the itemset record is first created |
| name | varchar(100) | The anme of this item exactly as it appears in-game |
| item_count | tinyint(3) unsigned | The number of items in this itemset |
| set_bonuses | text | The complete text of all bonuses that apply when multiple pieces of this set are equipped. Each line is separated with so that the field may be macro'd directly into a wiki page without the need for further manipulation |
| itemname0 | varchar(100) | The exact name of this item |
| itemslot0 | varchar(30) | The slot this item equips in, if known. Item Slot is not known until we actually capture the item from WarReader, even though we can create an itemset record from a single item in that set. |
| itemnamex | varchar(100) | x has a value range of 0 to 20. Content is the same as itemname0, above. |
| itemslotx | varchar(30) | x has a value range of 0 to 20. Content is the same as itemslot0, above. |
| career_id | tinyint(3) | A number representing the career |
| career | varchar(25) | The full text expansion of career_id |
| min_rank | tinyint(5) | Minumum PvE rank required to use this item |
| min_rr | tinyint(5) | Minumum Renown (PvP) rank required to use this item |
items
| Field | Type(length) | Description |
|---|---|---|
| armor | int | Armor value |
| blockrating | int | For shields |
| bonus_duration_x | int | Range for x: 1 to 10 |
| bonus_reference_x | int | Range for x: 1 to 10 |
| bonus_totalCooldownTime_x | int | Range for x: 1 to 10 |
| bonus_type_x | int | Range for x: 1 to 10 |
| bonus_value_x | int | Range for x: 1 to 10 |
| brokenIconNum | int | The # of the icon to show for this item when it is repairable |
| brokenName | varchar(100) | The name of the repairable version of this item |
| careers | int | A binary switch set that toggles which careers can use this item |
| craftingSkillRequirement | int | Skill level required for a crafter to use this item, if it is a crafting component |
| crc | varchar(22) | Checksum |
| cultivationType | int | |
| description | text | |
| dps | float(5.2) | Damage per Second |
| entered | datetime | Date and time this record was created in our database |
| entryid | int | Warhammer ID number for this item |
| equipSlot | int | hash value indicating slot(s) this item can be used in |
| first | int | |
| flags | int | |
| iLevel | int | Item Level |
| iconNum | int | icon number |
| itemSet | int | ItemSet ID Number indicating that this item is a member of an item set. |
| level | int | Rank this item can be equipped at |
| name | varchar(100) | The name of this item exactly as it appears in-game. |
| newest | int | |
| numEnhancementSlots | int | |
| races | int | |
| rarity | int | 1=Grey, 2=White, 3=Green, 4=Blue, 5=Purple, 6=Gold |
| renown | int | Minimum Renown Rank required for use |
| repairPrice | int | in Brass |
| repairedIconNum | int | When repaired, what will it's icon be? |
| repairedName | int | When repaired, what will it be called? |
| sellPrice | int | in Brass |
| skills | int | Any special skills required to use this item? Hash value... |
| speed | int | How fast does this weapon auto-attack? |
| submitter_id | int | ZAM ID # of WarReader submitter |
| submitter_ip | varchar(15) | IP address of WarReader submitter |
| type | int | |
| uniqueID | int | Generated by our system |
quests
mobs
zones
objects
abilities
 |
Warhammer Online Wikibase™ |
Category: Warhammer Online