Craftables Guide

General assistance and guidelines for editing the server side of Soma.

Craftables Guide

Postby Tiffany » Tue Feb 26, 2008 8:56 am

Originated on Pirate Forum
Keywords : CRAFTING, UPGRADES, GUIDE

Haven't seen a help topic on how to add craftable items yet so here goes..

item_mirture (Non specific item crafting)
Code: Select all
Guide to Columns;

sId = ID number (must be unique)
sType01 = Where item is crafted(Which crafting box).
sType02 = sNum of item in basicitem
sExpType = Type of skill needed to craft
sNeedExp = Skill Exp needed (200 armour etc.)
sMaxAb = Maximum max df/attack
sMetal = Amount of metal needed
sWood = Amount of wood needed
sLeather = Amount of leather needed
sBone = Amount of bones/claws needed
sCloth = Amount of cloth needed (linen etc)
sPlant = Not sure what item
sMeat = Amount of meat needed
sPowder = Not sure (Wheat flower??)
sSpice = Not sure (Blue flavor??)
sGems = Amount of gems needed
sGender = Gender of item

Options of Columns;

sType01:
0 - Anywhere
1 - Forge One handed sword
2 - Forge Two handed sword
4 - Forge Axe
5 - Forge Bow
6 - Forge Spear
7 - Forge Knuckle
8 - Forge Staff
9 - Forge Armour (Top)
10 - Forge Armour (Pads)
11 - Forge Armour (Boots)
12 - Loom Robe
13 - Loom Clothing (Top)
14 - Loom Clothing (Pads)
15 - Loom Shoes
16 - Anvil Ring
17 - Anvil Bracelet
18 - Anvil Necklace
19 - Anvil Earring
20 - Reagent Table
21 - Oven (Meat cooking)
22 - Forge Armour (Helm)
23 - Forge Armour (Shield)

sExpType:

0 - Weapons
1 - Armour
2 - Accessory Crafting
3 - Potion Crafting
4 - Cooking
10 - Gem crafting

sNeedExp:
Anything from 0-200 for normal crafting, -1 for 100% success rate regardless of skill (not tested)

sGender:
0 - UniSex
1 - Female
2 - Male


item_mirture_special
Code: Select all
 (These are items that require a specific item e.g. "Orcish metal" rather than just "a metal")

Guide to Columns;

sId = ID number (must be unique)
sType = Where item is crafted (Which crafting box)
sItem = sNum from basicitem of the item you want to craft (end result)
sExpType = Type of skill needed to craft
sNeedExp = Skill Exp needed (200 etc.)
sNeedItem_01 = sNum from basicitem of the "material"
sNeedItemNum_01 = Amount of the "material" needed
sNeedItem_02 = sNum from basicitem of the "material"
sNeedItemNum_02 = Amount of the "material" needed
sNeedItem_03 = sNum from basicitem of the "material"
sNeedItemNum_03 = Amount of the "material" needed
sNeedItem_04 = sNum from basicitem of the "material"
sNeedItemNum_04 = Amount of the "material" needed
sNeedItem_05 = sNum from basicitem of the "material"
sNeedItemNum_05 = Amount of the "material" needed

For options for columns see above post.


item_mirture_gems
Code: Select all
Guide to Columns;

sId = ID number (must be unique)
sGemsType = sNum from basicitem of the gem
sTypeSword/Axe/Bow/Spear/Knuckle/Staff/Armor/Acc = What the gem adds to the crafted item
sCalcSword/Axe/Bow/Spear/Knuckle/Staff/Armor/Acc = What the gem changes
sMinSword/Axe/Bow/Spear/Knuckle/Staff/Armor/Acc = Minimum variable for the added effect
sMaxSword/Axe/Bow/Spear/Knuckle/Staff/Armor/Acc = Maximum variable for the added effect

Options of Columns;

sTypeSword/Axe/Bow/Spear/Knuckle/Staff:
1 - Attack increase
2 - Durability increase
3 - Weight increase/decrease (not 100% sure)
4 - Speed increase

sTypeArmor:
1 - Defense increase
2 - Durability increase
3 - Weight increase/decrease (not 100% sure)
9 - Blue magic defense increase
10 - White magic defense increase
11 - Black magic defense increase

sTypeAcc:
None of the types seem to do anything.

sCalcSword/Axe/Bow/Spear/Knuckle/Staff:
1 - Attack increase
2 - Anything else it seems (Speed/Dura/Weight)

sCalcArmor:
1 - Defense increase+Blue/Black/White magic defense
2 - Anything else (Weight/Dura)

sCalcAcc:
No idea as none of the types do anything for me.


item_upgrade
Code: Select all
Guide to Columns;

sId = ID number (must be unique)
sType = What type of upgrade
sMaxUpgrade = Maximum times you can upgrade
sItemNum = sNum from basicitem of the upgrade
sTypeWeapon/Armor/Acc = Effect of upgrade (Physical changes to the actual weapon)
sCalcWeapon/Armor/Acc = Type of effect
sMinWeapon/Armor/Acc = Minimum modifier of effect
sMaxWeapon/Armor/Acc = Maximum modifier of effect
sSpecialWeapon/Armor/Acc = Special item effect to be added (Orange writing at bottom)
sOpt1~3Weapon/Armor/Acc = Modifiers of the sSpecial effect (Same as basicitem's)
sOpt4~6Weapon/Armor/Acc = What the upgrade adds to a previously successful upgrade of the same item. (eg DP adding 2% extra rather than 5%)

Options of Columns;

sTypeWeapon/Armor/Acc:
1 - Adds min and max attack
2 - Adds durability
3 - Weight decrease
4 - Speed increase (positive = slower, negative = faster)
24 - Minimum attack increase
25 - Maximum attack increase
(Some do not work on armor/acc)

sCalcWeapon/Armor/Acc:
1 - Attack/Weight change
2 - Speed/Durability change

sSpecialWeapon/Armor/Acc:
Refer to here for sSpecial values/effects.

Hope some of this was useful for you.

Making new materials

Add them into Basicitem table.

What you should put in each column

sNum - ID Number (must be unique, between 1 and 2000)
sPicNum - Whatever you want the item to look like in inventory
sPicNum2~4 - 0
strName - Whatever you want to call the item.
bType - 11
bArm;
Metal - 1
Wood - 2
Leather - 3
Bone - 4
Cloth - 5
Plant - 6
Meat - 7
Powder - 8
Spice - 9
Gem - 10
Gender - 0
sAb1 - Minimum effectiveness (e.g. Red Iron Bar has 40 sAb1) (Only for Metal/Wood/Leather/Bone/Cloth)
sAb2 - Maximum effectiveness (e.g. Red Iron Bar has 100 sAb2) (Only for Metal/Wood/Leather/Bone/Cloth)
sWg - Whatever weight of item you want
iCost - Cost of 1 of the item.
sDur - 1
All 0 after that.


Makeskill_itemmix
Code: Select all
Not too sure on certain parts of this table.

Guide to Columns;

sId = ID number (must be unique)
sType - Skill used
sItem - sNum from basicitem of the item used/created
sItemNum - Amount of sItem (always 1 in the table)
sMtr1~5 - Material gained from the skill/Material needed to create item
sMtrNum1~5 - Maximum materials gained from the skill/Amount of materials needed to create item

Options for Columns;

sType:
2 - Disassemble
5 - Prepare
Tiffany
SD Pro 2 Star
SD Pro 2 Star
 
Posts: 428
Joined: Sat Jan 12, 2008 1:17 pm

Return to Server Development

Who is online

Users browsing this forum: No registered users and 2 guests

cron