Loading...   

[Show Table of Contents]


Field Name Field Description Field Type Field Default Value
id Unique item identifier number. int(11) 0
minstatus The minimum status required to use the item. smallint(5) 0
Name Name of the item. varchar(64) Empty String
aagi Agility bonus. Valid values: -127 - 127 int(11) 0
ac AC bonus.  Valid values: -2147483647 - 2147483647 int(11) 0
accuracy Amount of accuracy on the item. int(11) 0
acha Charisma bonus. Valid values: -127 - 127 int(11) 0
adex Dexterity bonus. Valid values: -127 - 127 int(11) 0
aint Intelligence bonus. Valid values: -127 - 127 int(11) 0
artifactflag Determines whether or not an item gets the artifact flag. 0 - No, 1 - Yes tinyint(3) 0
asta Stamina bonus. Valid values: -127 - 127 int(11) 0
astr Strength bonus. Valid values: -127 - 127 int(11) 0
attack Attack bonus. int(11) 0
augrestrict Augment Type Reference int(11) 0
augslot1type The Type of Augment that the slot can hold. Augment Type Reference tinyint(3) 0
augslot1visible Whether or not the augment slot is visible. 0 - No, 1 - Yes tinyint(3) NULL
augslot2type The Type of Augment that the slot can hold. Augment Type Reference tinyint(3) 0
augslot2visible Whether or not the augment slot is visible. 0 - No, 1 - Yes tinyint(3) NULL
augslot3type The Type of Augment that the slot can hold. Augment Type Reference tinyint(3) 0
augslot3visible Whether or not the augment slot is visible. 0 - No, 1 - Yes tinyint(3) NULL
augslot4type The Type of Augment that the slot can hold. Augment Type Reference tinyint(3) 0
augslot4visible Whether or not the augment slot is visible. 0 - No, 1 - Yes tinyint(3) NULL
augslot5type The Type of Augment that the slot can hold. Augment Type Reference tinyint(3) 0
augslot5visible Whether or not the augment slot is visible. 0 - No, 1 - Yes tinyint(3) NULL
augtype Augment Type Reference int(11) 0
avoidance Amount of avoidance on the item. int(11) 0
awis Wisdom bonus. Value values: -127 - 127 int(11) 0
bagsize Bag Sizes int(11) 0
bagslots The number of bag slots a bag has. Keep it at a maximum of 10. int(11) 0
bagtype Bag Types int(11) 0
bagwr The amount of weight reduction on the bag. int(11) 0
banedmgamt The amount of bane damage. int(11) 0
banedmgraceamt The amount of race bane damage. int(11) 0
banedmgbody The bodytype the bane damages. int(11) 0
banedmgrace The race the bane damages. Races int(11) 0
bardtype Bard Types int(11) 0
bardvalue How much the instrument type is modified when equipped. int(11) 0
book The type of book displayed (scroll graphic, book, etc) int(11) 0
casttime The cast time of the spell in milliseconds. int(11) 0
casttime_ The cast time of the click effect. int(11) 0
charmfile The file used by the charm to scale. varchar(32) Empty String
charmfileid The ID of the file used by the charm to scale. varchar(32) Empty String
classes The classes that can use the item. Calculators int(11) 0
color The color of the item. Colors int(11) 0
combateffects Amount of combat effects on the item. varchar(10) Empty String
extradmgskill The skill you get extra damage in. Skills int(11) 0
extradmgamt The amount of extra damage you get in the skill. int(11) 0
price The price the item costs from a vendor. int(11) 0
cr Cold Resistance. Valid values: -127 - 127 int(11) 0
damage Amount of damage on the item. int(11) 0
damageshield Amount of damage shield on the item. int(11) 0
deity The deity that may use this item. Deity List int(11) 0
delay The delay of the item, determines how fast it hits. 0 Is for non-weapons. int(11) 0
augdistiller If this item is an augment, this is the id of the distiller that will remove it from an item safely. int(11) 0
dotshielding Amount of damage over time shielding on the item. int(11) 0
dr Disease Resistance. Valid values: -127 - 127 int(11) 0
clicktype The click type of the item. Click Types int(11) 0
clicklevel2

Level required to use the click effect.

int(11) 0
elemdmgtype The element damage type on the weapon. Element Types int(11) 0
elemdmgamt The amount of element damage on the weapon. int(11) 0
endur Endurance bonus. int(11) 0
factionamt1 The amount that the faction shops and be modified while using this item. int(11) 0
factionamt2 The amount that the faction shops and be modified while using this item. int(11) 0
factionamt3 The amount that the faction shops and be modified while using this item. int(11) 0
factionamt4 The amount that the faction shops and be modified while using this item. int(11) 0
factionmod1 The faction which factionamt1 will modify. Set this to the primary faction from the id field in the faction_list table. int(11) 0
factionmod2 The faction which factionamt2 will modify. Set this to the primary faction from the id field in the faction_list table. int(11) 0
factionmod3 The faction which factionamt3 will modify. Set this to the primary faction from the id field in the faction_list table. int(11) 0
factionmod4 The faction which factionamt4 will modify. Set this to the primary faction from the id field in the faction_list table. int(11) 0
filename If an item is a book, this determines what the actual book is. It corresponds to the name field in the books table. varchar(32) Empty String
focuseffect The spell ID of the focus effect you want the item to have. int(11) 0
fr Fire Resistance. Valid values: -127 - 127 int(11) 0
fvnodrop Requires the Rule World:FVNoDropFlag to be set to 1, disables /ooc and uses FVNoDrop for No Trade rather than No Drop. 0 = Tradeable, 1 = No Trade int(11) 0
haste Haste percentage the item has. int(11) 0
clicklevel This is the level at which the item can cast its fully powered spell. int(11) 0
hp Health bonus. int(11) 0
regen Health regeneration per tick. int(11) 0
icon The item's icon. int(11) 0
idfile The model of the item. Example: IT63 is non-weapon items like armour. varchar(30) Empty String
itemclass The item class of the item. Item Class int(11) 0
itemtype The type of item. Item Type Reference int(11) 0
ldonprice Amount of LDoN points you want the item to cost (price must be equal to this). int(11) 0
ldontheme The LDoN Theme used for the LDoN price. LDoN Themes int(11) 0
ldonsold Whether or not the item is sold by LDoN merchants. 0 = No, 1 = Yes int(11) 0
light Amount of Light generated by an item. int(11) 0
lore What is displayed when you identify an item. varchar(80) Empty String
loregroup The lore group of an item. Lore Groups int(11) 0
magic Whether or not an item is magic. 0 = Not Magic, 1 = Magic int(11) 0
mana Mana bonus. int(11) 0
manaregen Mana regeneration per tick. int(11) 0
enduranceregen Endurance regeneration per tick. int(11) 0
material The material of the item, used for armor. Materials int(11) 0
maxcharges Maximum spell charges on the item, -1 for infinite. int(11) 0
mr Magic Resistance. Valid values: -127 - 127 int(11) 0
nodrop Whether or not an item is tradeable. 0 = No Trade, 1 = Tradeable int(11) 0
norent Whether or not an item is temporary. 0 = Temporary, 1 = Permanent, 255 = Permanent. int(11) 0
pendingloreflag Unknown. tinyint(3) 0
pr Poison Resistance. Valid values: -127 - 127 int(11) 0
procrate The rate at which a weapon procs. Normal is 0, 150% is 50, 50% is -50. int(11) 0
races The races that can use this item. Calculators int(11) 0
range Range of the item's attack. Used for Bows and/or Projectile weapons. int(11) 0
reclevel Recommended level for the item. Stats scale down for players below this level. int(11) 0
recskill Recommended skill for the item. Stats scale down for players below skill. int(11) 0
reqlevel Required level for the item. int(11) 0
sellrate Modifies the way an item sells back to an NPC. float 0
shielding Amount of Shielding on an item. 1 = 1%, 5 = 5%. int(11) 0
size The size of the item. Sizes int(11) 0
skillmodtype The skill you're getting a modified value in. Skills int(11) 0
skillmodvalue The amount of the skill mod on the item. int(11) 0
slots The slots the item will fit into. Slots int(11) 0
clickeffect The spell ID of the click effect you want the item to have. int(11) 0
spellshield The spell shielding on an item. int(11) 0
strikethrough The strikethrough on an item. int(11) 0
stunresist The stunresist on an item. int(11) 0
summonedflag Unknown. tinyint(3) 0
tradeskills Whether or not the item displays a "Used in tradeskills" message. 0 = No, 1 = Yes int(11) 0
favor Amount of Person Favor this item shops and give when turned in to favor NPC. int(11) 0
weight Weight of the item, multiplied by 10. 2 = .2, 50 = 5. int(11) 0
UNK012 Unknown. int(11) 0
UNK013 Unknown. int(11) 0
benefitflag Unknown. int(11) 0
UNK054 Unknown. int(11) 0
UNK059 Unknown. int(11) 0
booktype The language a book is written in. int(11) 0
recastdelay Cooldown time on a clickable effect. Stored as seconds. int(11) 0
recasttype Determines which recast timer the item uses. Item A has a 5 minute Recast Delay w/ Recast Type 8. Item B also has Recast Type 8, so you won't be able to cast either until the 5 minutes are up. int(11) 0
guildfavor Amount of Guild Favor this item shops and give when turned in to guild favor NPC. int(11) 0
UNK123 Unknown. int(11) 0
UNK124 Unknown. int(11) 0
attuneable Whether or not an item is attuneable. 0 = Not Attuneable, 1 = Attuneable int(11) 0
nopet Whether or not pets may use this item. 0 = Usable By Pets, 1 = Not Usable By Pets int(11) 0
updated Date/Time the item was last updated in the database. datetime 00:00:00
comment A comment in this field that is viewable only in the database. varchar(255) Empty String
UNK127 Unknown. int(11) 0
pointtype Unknown. int(11) 0
potionbelt Whether or not this item is able to go into the potion belt. 0 = No, 1 = Yes int(11) 0
potionbeltslots How many potion belt slots the item gives you. int(11) 0
stacksize Amount of this item that players can fit into a stack. This field is irrelevant unless stackable is turned on. int(11) 0
notransfer Unknown. int(11) 0
stackable Whether or not an item is stackable. 0 = Not Stackable, 1 = Stackable int(11) 0
UNK134 Unknown. varchar(255) Empty String
UNK137 Unknown. int(11) 0
proceffect Spell ID of the proc spell you want the item to have. int(11) 0
proctype Keep this at 0. int(11) 0
proclevel2 Level that the proc will reach maximum power. int(11) 0
proclevel Level required for the item to proc. int(11) 0
UNK142 Unknown. int(11) 0
worneffect Spell ID of the worn effect you want the item to have. int(11) 0
worntype Use 2 if this is a worn item. int(11) 0
wornlevel2 Level that the worn effect will reach maximum power. int(11) 0
wornlevel Level required for the worn effect on the item to take effect. int(11) 0
UNK147 Unknown. int(11) 0
focustype Use 6 if the item has a focus effect. int(11) 0
focuslevel2 Level that the focus effect will reach maximum power. int(11) 0
focuslevel Level required for the focus effect on the item to take effect. int(11) 0
UNK152 Unknown. int(11) 0
scrolleffect The spell ID that the scroll scribes. int(11) 0
scrolltype Use 7 if the item is a scroll. int(11) 0
scrolllevel2 Leave this at 0. int(11) 0
scrolllevel Leave this at 0. int(11) 0
UNK157 Unknown. int(11) 0
serialized Unknown. datetime NULL
verified Unknown. datetime NULL
serialization Unknown. text NULL
source Who contributed the item to the database. varchar(20) NULL
UNK033 Unknown. int(11) 0
lorefile Unknown. varchar(32) Empty String
UNK014 Unknown. int(11) 0
svcorruption Corruption Resistance. Valid values: -127 - 127 int(11) 0
UNK038 Unknown. int(11) 0
UNK060 Unknown. int(11) 0
augslot1unk2 Unknown. int(11) 0
augslot2unk2 Unknown. int(11) 0
augslot3unk2 Unknown. int(11) 0
augslot4unk2 Unknown. int(11) 0
augslot5unk2 Unknown. int(11) 0
UNK120 Unknown. int(11) 0
UNK121 Unknown. int(11) 0
questitemflag Unknown. int(11) 0
UNK132 Unknown. text Empty String
clickunk5 Unknown. int(11) 0
clickunk6 Unknown. varchar(32) Empty String
clickunk7 Unknown. int(11) 0
procunk1 Unknown. int(11) 0
procunk2 Unknown. int(11) 0
procunk3 Unknown. int(11) 0
procunk4 Unknown. int(11) 0
procunk6 Unknown. varchar(32) Empty String
procunk7 Unknown. int(11) 0
wornunk1 Unknown. int(11) 0
wornunk2 Unknown. int(11) 0
wornunk3 Unknown. int(11) 0
wornunk4 Unknown. int(11) 0
wornunk5 Unknown. int(11) 0
wornunk6 Unknown. varchar(32) Empty String
wornunk7 Unknown. int(11) 0
focusunk1 Unknown. int(11) 0
focusunk2 Unknown. int(11) 0
focusunk3 Unknown. int(11) 0
focusunk4 Unknown. int(11) 0
focusunk5 Unknown. int(11) 0
focusunk6 Unknown. varchar(32) Empty String
focusunk7 Unknown. int(11) 0
scrollunk1 Unknown. int(11) 0
scrollunk2 Unknown. int(11) 0
scrollunk3 Unknown. int(11) 0
scrollunk4 Unknown. int(11) 0
scrollunk5 Unknown. int(11) 0
scrollunk6 Unknown. varchar(32) Empty String
scrollunk7 Unknown. int(11) 0
UNK193 Unknown. int(11) 0
purity The purity of an item. int(11) 0
evolvinglevel Unused. int(11) 0
clickname The click effect's name. varchar(64) Empty String
procname The proc effect's name. varchar(64) Empty String
wornname The worn effect's name. varchar(64) Empty String
focusname The focus effect's name. varchar(64) Empty String
scrollname The scroll effect's name. varchar(64) Empty String
dsmitigation The damage shield mitigation on an item. smallint(6) 0
heroic_str Heroic Strength bonus. smallint(6) 0
heroic_int Heroic Intelligence bonus. smallint(6) 0
heroic_wis Heroic Wisdom bonus. smallint(6) 0
heroic_agi Heroic Agility bonus. smallint(6) 0
heroic_dex Heroic Dexterity bonus. smallint(6) 0
heroic_sta Heroic Stamina bonus. smallint(6) 0
heroic_cha Heroic Charisma bonus. smallint(6) 0
heroic_pr Heroic Poison Resistance bonus. smallint(6) 0
heroic_dr Heroic Disease Resistance bonus. smallint(6) 0
heroic_fr Heroic Fire Resistance bonus. smallint(6) 0
heroic_cr Heroic Cold Resistance bonus. smallint(6) 0
heroic_mr Heroic Magic Resistance bonus. smallint(6) 0
heroic_svcorrup Heroic Corruption Resistance bonus. smallint(6) 0
healamt The heal amount on the item. smallint(6) 0
spelldmg The spell damage on the item. smallint(6) 0
clairvoyance The clairvoyance on the item. smallint(6) 0
backstabdmg The backstab damage on the item, 32767 is the maximum. smallint(6) 0
created Who created the item. varchar(64) Empty String
elitematerial Unused. smallint(6) 0
ldonsellbackrate Leave this at 70. smallint(6) 0
scriptfileid The script used by the item. smallint(6) 0
expendablearrow Determines whether or not an item is an expendable arrow. 0 = No, 1 = Yes smallint(6) 0
powersourcecapacity Unused. smallint(6) 0
bardeffect The spell ID of the bard effect on the item. smallint(6) 0
bardeffecttype The type of bard effect on the item. smallint(6) 0
bardlevel2 Level that the bard effect will reach maximum power. smallint(6) 0
bardlevel The level required for the bard effect. smallint(6) 0
bardunk1 Unknown. smallint(6) 0
bardunk2 Unknown. smallint(6) 0
bardunk3 Unknown. smallint(6) 0
bardunk4 Unknown. smallint(6) 0
bardunk5 Unknown. smallint(6) 0
bardname The name of the Bard effect. varchar(64) Empty String
bardunk7 Unknown. smallint(6) 0
UNK214 Unknown. smallint(6) 0

ยงItem

Used With
  • NPCs
  • Quests
  • Clients
Related Commands
  • #summonitem|#si [item id] [charges/amount]
  • #giveitem|#gi [item id] [charges/amount]
  • #nukeitem [item id]
  • #finditem|#itemsearch |#search [partial name]
  • #npcloot [add|remove] [item id]
  • #equipitem [slot]
  • #iteminfo
  • #setitemstatus [item id] [status]