You are viewing an old version of this page. Return to the latest version.
Version of 08:31, 25 September 2009 by Bolly
Difference between revisions of "Database:Items"
m (minor example) |
|||
| Line 16: | Line 16: | ||
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); | 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 | + | * Reload your items |
| − | SLASH 0 | + | |
| − | CRUSH 1 | + | /reload items |
| − | PIERCE 2 | + | |
| − | HEAT 3 | + | == Damage Types == |
| − | COLD 4 | + | * SLASH 0 |
| − | MAGIC 5 | + | * CRUSH 1 |
| − | MENTAL 6 | + | * PIERCE 2 |
| − | DIVINE 7 | + | * HEAT 3 |
| − | DISEASE 8 | + | * COLD 4 |
| − | POISON 9 | + | * MAGIC 5 |
| − | DROWN 10 | + | * MENTAL 6 |
| − | FALLING 11 | + | * DIVINE 7 |
| − | PAIN 12 | + | * DISEASE 8 |
| + | * POISON 9 | ||
| + | * DROWN 10 | ||
| + | * FALLING 11 | ||
| + | * PAIN 12 | ||
| − | Wield Styles | + | == Wield Styles == |
| − | Dual 1 | + | * Dual 1 |
| − | Single 2 | + | * Single 2 |
| − | Two Handed 3 | + | * 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 | ||
Revision as of 12:36, 25 September 2009
Contents
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