|
|
| Line 1: |
Line 1: |
| − | == 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);
| |
| − |
| |
| − | * Reload your items
| |
| − |
| |
| − | /reload items
| |
| − |
| |
| − | == 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
| |
| − |
| |
| − | == Slots ==
| |
| − | * PRIMARY_SLOT 1
| |
| − | * SECONDARY_SLOT 2
| |
| − | * HEAD_SLOT 4
| |
| − | * CHEST_SLOT 8
| |
| − | * SHOULDERS_SLOT 16
| |
| − | * FOREARMS_SLOT 32
| |
| − | * HANDS_SLOT 64
| |
| − | * LEGS_SLOT 128
| |
| − | * FEET_SLOT 256
| |
| − | * LRING_SLOT 512
| |
| − | * RRING_SLOT 1024
| |
| − | * EARS_SLOT_1 2048
| |
| − | * EARS_SLOT_2 4096
| |
| − | * NECK_SLOT 8192
| |
| − | * LWRIST_SLOT 16384
| |
| − | * RWRIST_SLOT 32768
| |
| − | * RANGE_SLOT 65536
| |
| − | * AMMO_SLOT 131072
| |
| − | * WAIST_SLOT 262144
| |
| − | * CLOAK_SLOT 524288
| |
| − | * CHARM_SLOT_1 1048576
| |
| − | * CHARM_SLOT_2 2097152
| |
| − | * FOOD_SLOT 4194304
| |
| − | * DRINK_SLOT 8388608
| |
| − | * TEXTURES_SLOT 16777216
| |