Skip to content

items

Relationships

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    books {
        int id
    }
    alternate_currency {
        int id
        int item_id
    }
    bot_inventories {
        varchar bot_id
        varchar item_id
        varchar augment_1
        varchar augment_2
        varchar augment_3
        varchar augment_4
        varchar augment_5
        varchar augment_6
    }
    bot_pet_inventories {
        varchar pets_index
        varchar item_id
    }
    items ||--o{ spells_new : "One-to-One"
    items ||--o{ books : "One-to-One"
    items ||--o{ spells_new : "One-to-One"
    items ||--o{ spells_new : "One-to-One"
    items ||--o{ alternate_currency : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_inventories : "Has-Many"
    items ||--o{ bot_pet_inventories : "Has-Many"
    items ||--o{ spells_new : "One-to-One"
    items ||--o{ spells_new : "One-to-One"
    items ||--o{ spells_new : "One-to-One"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    character_bandolier {
        intunsigned id
        intunsigned item_id
    }
    character_corpse_items {
        intunsigned corpse_id
        intunsigned item_id
        intunsigned aug_1
        intunsigned aug_2
        intunsigned aug_3
        intunsigned aug_4
        intunsigned aug_5
        int aug_6
    }
    character_pet_inventory {
        int char_id
        int item_id
    }
    character_potionbelt {
        intunsigned id
        intunsigned icon
        intunsigned item_id
    }
    discovered_items {
        varchar char_name
        intunsigned item_id
    }
    items ||--o{ character_bandolier : "Has-Many"
    items ||--o{ character_corpse_items : "Has-Many"
    items ||--o{ character_pet_inventory : "Has-Many"
    items ||--o{ character_potionbelt : "Has-Many"
    items ||--o{ discovered_items : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    }
    fishing {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
        int npc_id
    }
    forage {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
    }
    ground_spawns {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned item
        smallint version
        intunsigned zoneid
    }
    inventory {
        intunsigned charid
        intunsigned itemid
        mediumintunsigned augslot1
        mediumintunsigned augslot2
        mediumintunsigned augslot3
        mediumintunsigned augslot4
        mediumintunsigned augslot5
        mediumint augslot6
    }
    items ||--o{ doors : "Has-Many"
    items ||--o{ fishing : "Has-Many"
    items ||--o{ forage : "Has-Many"
    items ||--o{ ground_spawns : "Has-Many"
    items ||--o{ inventory : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    item_tick {
        varchar it_itemid
        varchar it_qglobal
    }
    keyring {
        int char_id
        int item_id
    }
    lootdrop_entries {
        int item_id
        intunsigned lootdrop_id
    }
    merc_inventory {
        varchar item_id
        varchar merc_subtype_id
    }
    merchantlist {
        varchar content_flags
        varchar content_flags_disabled
        varchar bucket_name
        int item
        varchar merchant_id
        int merchantid
    }
    items ||--o{ item_tick : "Has-Many"
    items ||--o{ keyring : "Has-Many"
    items ||--o{ lootdrop_entries : "Has-Many"
    items ||--o{ merc_inventory : "Has-Many"
    items ||--o{ merchantlist : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    merchantlist_temp {
        intunsigned itemid
        intunsigned npcid
    }
    object {
        varchar content_flags
        varchar content_flags_disabled
        int itemid
        int id
        smallint version
        intunsigned zoneid
    }
    object_contents {
        intunsigned itemid
        intunsigned parentid
        mediumintunsigned augslot1
        mediumintunsigned augslot2
        mediumintunsigned augslot3
        mediumintunsigned augslot4
        mediumintunsigned augslot5
        mediumint augslot6
        intunsigned zoneid
    }
    pets_equipmentset_entries {
        int item_id
        int set_id
    }
    qs_merchant_transaction_record_entries {
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    items ||--o{ merchantlist_temp : "Has-Many"
    items ||--o{ object : "Has-Many"
    items ||--o{ object_contents : "Has-Many"
    items ||--o{ pets_equipmentset_entries : "Has-Many"
    items ||--o{ qs_merchant_transaction_record_entries : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    qs_player_delete_record_entries {
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    qs_player_handin_record_entries {
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    qs_player_move_record_entries {
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    qs_player_trade_record_entries {
        int from_id
        int to_id
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    starting_items {
        varchar content_flags
        varchar content_flags_disabled
        varchar itemid
        varchar zone_id
        varchar zoneid
    }
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_delete_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_handin_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_move_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ qs_player_trade_record_entries : "Has-Many"
    items ||--o{ starting_items : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    tool_gearup_armor_sets {
        int item_id
    }
    trader {
        intunsigned char_id
        intunsigned item_id
    }
    tradeskill_recipe_entries {
        int item_id
        int recipe_id
    }
    tribute_levels {
        intunsigned item_id
        intunsigned tribute_id
    }
    veteran_reward_templates {
        intunsigned claim_id
        intunsigned item_id
    }
    items ||--o{ tool_gearup_armor_sets : "Has-Many"
    items ||--o{ trader : "Has-Many"
    items ||--o{ tradeskill_recipe_entries : "Has-Many"
    items ||--o{ tribute_levels : "Has-Many"
    items ||--o{ veteran_reward_templates : "Has-Many"

erDiagram
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    trader_audit {
        varchar buyer
        varchar seller
        varchar itemname
    }
    character_item_recast {
        intunsigned id
        intunsigned recast_type
    }
    items ||--o{ trader_audit : "Has-Many"
    items ||--o{ character_item_recast : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One bardeffect spells_new id
One-to-One book books id
One-to-One clickeffect spells_new id
One-to-One focuseffect spells_new id
Has-Many id alternate_currency item_id
Has-Many id bot_inventories item_id
Has-Many id bot_inventories augment_1
Has-Many id bot_inventories augment_2
Has-Many id bot_inventories augment_3
Has-Many id bot_inventories augment_4
Has-Many id bot_inventories augment_5
Has-Many id bot_inventories augment_6
Has-Many id bot_pet_inventories item_id
Has-Many id character_bandolier item_id
Has-Many id character_corpse_items item_id
Has-Many id character_pet_inventory item_id
Has-Many id character_potionbelt item_id
Has-Many id discovered_items item_id
Has-Many id doors keyitem
Has-Many id fishing Itemid
Has-Many id forage Itemid
Has-Many id ground_spawns item
Has-Many id inventory itemid
Has-Many id item_tick it_itemid
Has-Many id keyring item_id
Has-Many id lootdrop_entries item_id
Has-Many id merc_inventory item_id
Has-Many id merchantlist item
Has-Many id merchantlist_temp itemid
Has-Many id object itemid
Has-Many id object_contents itemid
Has-Many id pets_equipmentset_entries item_id
Has-Many id qs_merchant_transaction_record_entries item_id
Has-Many id qs_player_delete_record_entries item_id
Has-Many id qs_player_delete_record_entries aug_1
Has-Many id qs_player_delete_record_entries aug_2
Has-Many id qs_player_delete_record_entries aug_3
Has-Many id qs_player_delete_record_entries aug_4
Has-Many id qs_player_delete_record_entries aug_5
Has-Many id qs_player_handin_record_entries item_id
Has-Many id qs_player_handin_record_entries aug_1
Has-Many id qs_player_handin_record_entries aug_2
Has-Many id qs_player_handin_record_entries aug_3
Has-Many id qs_player_handin_record_entries aug_4
Has-Many id qs_player_handin_record_entries aug_5
Has-Many id qs_player_move_record_entries item_id
Has-Many id qs_player_move_record_entries aug_1
Has-Many id qs_player_move_record_entries aug_2
Has-Many id qs_player_move_record_entries aug_3
Has-Many id qs_player_move_record_entries aug_4
Has-Many id qs_player_move_record_entries aug_5
Has-Many id qs_player_trade_record_entries item_id
Has-Many id qs_player_trade_record_entries aug_1
Has-Many id qs_player_trade_record_entries aug_2
Has-Many id qs_player_trade_record_entries aug_3
Has-Many id qs_player_trade_record_entries aug_4
Has-Many id qs_player_trade_record_entries aug_5
Has-Many id starting_items itemid
Has-Many id tool_gearup_armor_sets item_id
Has-Many id trader item_id
Has-Many id tradeskill_recipe_entries item_id
Has-Many id tribute_levels item_id
Has-Many id veteran_reward_templates item_id
Has-Many name trader_audit itemname
One-to-One proceffect spells_new id
Has-Many recasttype character_item_recast recast_type
One-to-One scrolleffect spells_new id
One-to-One worneffect spells_new id

Schema

Column Data Type Description
id int Unique Item Identifier
minstatus smallint Minimum Status
Name varchar Name
aagi int Agility: -128 to 127
ac int Armor Class
accuracy int Accuracy
acha int Charisma: -128 to 127
adex int Dexterity: -128 to 127
aint int Intelligence: -128 to 127
artifactflag tinyint Artifact: 0 = False, 1 = True
asta int Stamina: -128 to 127
astr int Strenght: -128 to 127
attack int Attack
augrestrict int Augment Restriction
augslot1type tinyint Augment Slot 1 Type
augslot1visible tinyint Augment Slot 1 Visible: 0 = False, 1 = True
augslot2type tinyint Augment Slot 2 Type
augslot2visible tinyint Augment Slot 2 Visible: 0 = False, 1 = True
augslot3type tinyint Augment Slot 3 Type
augslot3visible tinyint Augment Slot 3 Visible: 0 = False, 1 = True
augslot4type tinyint Augment Slot 4 Type
augslot4visible tinyint Augment Slot 4 Visible: 0 = False, 1 = True
augslot5type tinyint Augment Slot 5 Type
augslot5visible tinyint Augment Slot 5 Visible: 0 = False, 1 = True
augslot6type tinyint Augment Slot 6 Type
augslot6visible tinyint Augment Slot 6 Visible: 0 = False, 1 = True
augtype int Augment Type
avoidance int Avoidance
awis int Wisdom: -128 to 127
bagsize int Bag Size
bagslots int Bag Slots: 1 = Minimum, 10 = Maximum
bagtype int Bag Type
bagwr int Bag Weight Reduction: 0 = 0%, 100 = 100%
banedmgamt int Bane Damage Amount
banedmgraceamt int Bane Damage Race Amount
banedmgbody int Bane Damage Body Type
banedmgrace int Bane Damage Race
bardtype int Bard Type
bardvalue int Bard Value
book int Book
casttime int Cast Time in Seconds
casttime_ int Cast Time in Seconds
charmfile varchar Charm File
charmfileid varchar Charm File Identifier
classes int Classes
color int Color
combateffects varchar Combat Effects
extradmgskill int Extra Damage Skill
extradmgamt int Extra Damage Amount
price int Price in Copper
cr int Cold Resistance: -128 to 127
damage int Damage
damageshield int Damage Shield
deity int Deity
delay int Delay
augdistiller int Augment Distiller Item Identifier
dotshielding int Damage Over Time Shielding
dr int Disease Resistance: -128 to 127
clicktype int Click Type
clicklevel2 int Click Level 2
elemdmgtype int Elemental Damage Type
elemdmgamt int Elemental Damage Amount
endur int Endurance
factionamt1 int Faction Amount 1
factionamt2 int Faction Amount 2
factionamt3 int Faction Amount 3
factionamt4 int Faction Amount 4
factionmod1 int Faction Modifier 1
factionmod2 int Faction Modifier 2
factionmod3 int Faction Modifier 3
factionmod4 int Faction Modifier 4
filename varchar File Name
focuseffect int Focus Effect Identifier
fr int Fire Resistance: -128 to 127
fvnodrop int Firiona Vie No Drop: 0 = False, 1 = True
haste int Haste: 0 = 0%, 255 = 255%
clicklevel int Click Level
hp int Health
regen int Health Regeneration
icon int Icon
idfile varchar Item Texture
itemclass int Item Class
itemtype int Item Type
ldonprice int LDoN Price
ldontheme int LDoN Theme
ldonsold int LDoN Sold: 0 = False, 1 = True
light int Light
lore varchar Lore Description
loregroup int Lore Group
magic int Magic: 0 = False, 1 = True
mana int Mana
manaregen int Mana Regeneration
enduranceregen int Endurance Regeneration
material int Material
herosforgemodel int Hero's Forge Model
maxcharges int Maximum Charges
mr int Magic Resistance: -128 to 127
nodrop int No Drop: 0 = True, 1 = False
norent int No Rent: 0 = True, 1 = False
pendingloreflag tinyint Pending Lore Flag: 0 = False, 1 = True
pr int Poison Resistance: -128 to 127
procrate int Proc Rate: 0 = 100%, 50 = 150%, 100 = 200%
races int Races
range int Range: 0 to 255
reclevel int Recommended Level
recskill int Recommended Skill Level
reqlevel int Required Level
sellrate float Sell Rate
shielding int Shielding: 5 = 5%, 20 = 20%, 50 = 50%
size int Size
skillmodtype int Skill Modifier Type
skillmodvalue int Skill Modifier Value
slots int Slots
clickeffect int Click Effect Identifier
spellshield int Spell Shielding
strikethrough int Strikethrough
stunresist int Stun Resist
summonedflag tinyint Unknown
tradeskills int Tradeskill Item: 0 = False, 1= True
favor int Favor
weight int Weight: 10 = 1.0, 25 = 2.5, 100 = 10.0
UNK012 int Unknown
UNK013 int Unknown
benefitflag int Unknown
UNK054 int Unknown
UNK059 int Unknown
booktype int Book Language
recastdelay int Recast Delay in Seconds
recasttype int Recast Type: -1 = None, >0 = Recast Type used across all items
guildfavor int Guild Favor
UNK123 int Unknown
UNK124 int Unknown
attuneable int Attuneable: 0 = False, 1 = True
nopet int No Pet: 0 = False, 1 = True
updated datetime Updated Datetime
comment varchar Comment
UNK127 int Unknown
pointtype int Unknown
potionbelt int Potion Belt: 0 = False, 1 = True
potionbeltslots int Potion Belt Slots
stacksize int Stack Size
notransfer int No Transfer: 0 = False, 1 = True
stackable int Stackable: 0 = False, 1 = True
UNK134 varchar Unknown
UNK137 int Unknown
proceffect int Proc Effect Identifier
proctype int Proc Type: 0
proclevel2 int Proc Level 2
proclevel int Proc Level
UNK142 int Unknown
worneffect int Worn Effect Identifier
worntype int Worn Type: 2 = Worn
wornlevel2 int Worn Level 2
wornlevel int Worn Level
UNK147 int Unknown
focustype int Focus Type: 6 = Focus
focuslevel2 int Focus Level 2
focuslevel int Focus Level
UNK152 int Unknown
scrolleffect int Scroll Effect Identifier
scrolltype int Scroll Type: 7 = Scroll
scrolllevel2 int Scroll Level 2
scrolllevel int Scroll Level
UNK157 int Unknown
serialized datetime Serialized Datetime
verified datetime Verified Datetime
serialization text Serialization
source varchar Source
UNK033 int Unknown
lorefile varchar Lore File
UNK014 int Unknown
svcorruption int Corruption Resistance: -128 to 127
skillmodmax int Skill Modifier Max
UNK060 int Unknown
augslot1unk2 int Unknown
augslot2unk2 int Unknown
augslot3unk2 int Unknown
augslot4unk2 int Unknown
augslot5unk2 int Unknown
augslot6unk2 int Unknown
UNK120 int Unknown
UNK121 int Unknown
questitemflag int Quest Item: 0 = False, 1 = True
UNK132 text Unknown
clickunk5 int Unknown
clickunk6 varchar Unknown
clickunk7 int Unknown
procunk1 int Unknown
procunk2 int Unknown
procunk3 int Unknown
procunk4 int Unknown
procunk6 varchar Unknown
procunk7 int Unknown
wornunk1 int Unknown
wornunk2 int Unknown
wornunk3 int Unknown
wornunk4 int Unknown
wornunk5 int Unknown
wornunk6 varchar Unknown
wornunk7 int Unknown
focusunk1 int Unknown
focusunk2 int Unknown
focusunk3 int Unknown
focusunk4 int Unknown
focusunk5 int Unknown
focusunk6 varchar Unknown
focusunk7 int Unknown
scrollunk1 int Unknown
scrollunk2 int Unknown
scrollunk3 int Unknown
scrollunk4 int Unknown
scrollunk5 int Unknown
scrollunk6 varchar Unknown
scrollunk7 int Unknown
UNK193 int Unknown
purity int Purity
evoitem int Evolving Item: 0 = False, 1 = True
evoid int Evolving Identifier
evolvinglevel int Evolving Level
evomax int Evolving Max
clickname varchar Click Name
procname varchar Proc Name
wornname varchar Worn Name
focusname varchar Focus Name
scrollname varchar Scroll Name
dsmitigation smallint Damage Shield Mitigation
heroic_str smallint Heroic Strength
heroic_int smallint Heroic Intelligence
heroic_wis smallint Heroic Wisdom
heroic_agi smallint Heroic Agility
heroic_dex smallint Heroic Dexterity
heroic_sta smallint Heroic Stamina
heroic_cha smallint Heroic Charisma
heroic_pr smallint Heroic Poison Resistance
heroic_dr smallint Heroic Disease Resistance
heroic_fr smallint Heroic Fire Resistance
heroic_cr smallint Heroic Cold Resistance
heroic_mr smallint Heroic Magic Resistance
heroic_svcorrup smallint Heroic Corruption Resistance
healamt smallint Heal Amount: 0 to 32767
spelldmg smallint Spell Damage: 0 to 32767
clairvoyance smallint Clairvoyance
backstabdmg smallint Backstab Damage
created varchar Created
elitematerial smallint Elite Material
ldonsellbackrate smallint LDoN Sellback Rate
scriptfileid mediumint Script File Name
expendablearrow smallint Expendable Arrow: 0 = False, 1 = True
powersourcecapacity mediumint Powersource Capacity
bardeffect mediumint Bard Effect Identifier
bardeffecttype smallint Bard Effect Type
bardlevel2 smallint Bard Level 2
bardlevel smallint Bard Level
bardunk1 smallint Unknown
bardunk2 smallint Unknown
bardunk3 smallint Unknown
bardunk4 smallint Unknown
bardunk5 smallint Unknown
bardname varchar Bard Name
bardunk7 smallint Unknown
UNK214 smallint Unknown
subtype int Sub Type
UNK220 int Unknown
UNK221 int Unknown
heirloom int Heirloom: 0 = False, 1 = True
UNK223 int Unknown
UNK224 int Unknown
UNK225 int Unknown
UNK226 int Unknown
UNK227 int Unknown
UNK228 int Unknown
UNK229 int Unknown
UNK230 int Unknown
UNK231 int Unknown
UNK232 int Unknown
UNK233 int Unknown
UNK234 int Unknown
placeable int Placeable: 0 = False, 1 = True
UNK236 int Unknown
UNK237 int Unknown
UNK238 int Unknown
UNK239 int Unknown
UNK240 int Unknown
UNK241 int Unknown
epicitem int Epic Item: 0 = False, 1 = True