Database:Items

About

The items tables offer an extremely flexible system for generating new armour, tradeskill items, food and much more!

Example

• Step 1: Create the item in the items table

INSERT INTO items (name,item_type,icon,skill_id_req,slots) VALUES ('A dagger','Weapon',47,418532101,1); Find a skill_id_req by SELECT id,name FROM skills WHERE name LIKE '%Slashing%';

• Step 2: Assign an appearance in the appearance table

INSERT INTO item_appearances (item_id,equip_type) VALUES (7,7415); Find an appearance (equip_type) by SELECT appearance_id, name FROM appearances WHERE name LIKE '%dagger%'

• Step 3: Assign weapon information in the weapons table

INSERT INTO item_details_weapon (item_id, wield_style,damage_type,damage_low1, damage_high1,delay, damage_rating) VALUES (7,2,0,10,30,30,1);

Damage Types SLASH 0 CRUSH 1 PIERCE 2 HEAT 3 COLD 4 MAGIC 5 MENTAL 6 DIVINE 7 DISEASE 8 POISON 9 DROWN 10 FALLING 11 PAIN 12

Wield Styles: Dual 1 Single 2 Two Handed 3

• Reload your items

/reload items