Page 1 of 2

Crafting...

PostPosted: Fri Jul 23, 2004 10:43 am
by DocShoe
Hi,

currently I´m working on the crafting issue and facing a serious problem:
There´s a packet sent by the client (packet type 0x45 ^ 0xa8) that specifies the item to be crafted. The only information provided is a 16bit object id, so I need to do the following:

1) Create a table that translates the oid to an itemtemplate id, then create an item from the itemtemplate table. I need to store the required tradeskill and the tradeskill level of that item in this table, too.

2) Create a table that holds the material requirements for that item. Because items need multiple materials there will be 2-4 db entries for each craftable items.

Unfortunately there´s a large number of craftable item, weaponcrafters in albion are able to craft about 800 different items. Most of these item can be grouped because the amount of materials stays the same, only the material changes. Daggers for example need X Material A and Y Material B. Bronze Daggers need X bars of Bronze and Y other stuff, Asterite Daggers need X bars of Asterite and Y other stuff. I plan to make a tool that takes care of this, so I need to enter data for the first (Bronze) item and that tool generates entries for the remaining items. This tool will be able to cover 90% of the items and reduces the amout of data to 10%.
The IDs provided by the client are hard coded in no specific order except for items of the same group (if a Bronze Sword has the item id 0x1500 then the Arcanite Sword hat the id 0x1509).
I´ve determined all IDs for albion weapons, the remaining IDs for all other tradeskills need to be figured out.
The icons for each item have to be set manually, too, so there´s a lot of work to do.

Please post advices and ideas, I´d be glad.

Regards,
Doc

PostPosted: Fri Jul 23, 2004 12:48 pm
by Schaf
i think its calculated some way (like emblems and so on, material, model, etc)

PostPosted: Fri Jul 23, 2004 1:21 pm
by nor
Maybe looking at data\ifd.mpk will help.
0,6,0,1,0,494,0,Metalworking,0,.......
;ametal
3451,6,1,1,0,2233,0,bracket,BRON,0,0,metal bars,BRON,1,0,.....
3452,6,1,1,0,2233,0,bracket,IRON,0,100,metal bars,IRON,1,0,0,....

...

0,1,0,1,0,499,0,Weaponcrafting,0,0,......
;aweapons
5605,1,1,1,0,202,4,dagger,FALL,21,415,metal bars,FALL,8,6,385,wood boards,WOO5,1,14,385,leather,LEA5,2,7,385,0,0,........
5606,1,1,1,0,202,5,dagger,MITH,26,515,metal bars,MITH,8,6,485,wood boards,WOO6,1,14,485,leather,LEA6,2,7,485,0,0,......

...

0,2,0,1,0,498,0,Armorcraft,0,0,.....
;aarmor
701,2,6,1,0,161,0,studded vest,BRON,2,95,leather,LEA1,19,7,0,thread,CLO1,4,8,0,metal bars,BRON,5,6,0,0,......

...

0,4,0,2,0,496,0,Alchemy,0,0,......
;malchemy
7001,4,1,2,0,555,99,Cloth Dyes,0,0,9999,0,0,.....
7002,4,1,2,0,168,0,light brown,GENE,0,40,ground tea,GENE,1,10,15,glass flask,GENE,1,10,15,alum,GENE,1,10,15,flask of water,GENE,1,10,15,0,0,.......

etc.

PostPosted: Fri Jul 23, 2004 9:14 pm
by DocShoe
Two words: GREAT JOB!

Thank you nor, you just saved us a lot of work.

I have turned the file into a db table already and figured out what most of the fields are used for.
There are two fields left I couldn´t figure out what they´re used for (index zero based):

Index 4:
Always 0

Index 6:
Maybe crafting duration. For secondary skills like metalworking its values range from 0 to 8 (Bronze 0, Iron 0, Steel 1, Alloy 2, Fine Alloy 3, Mithril 4, Adamant 5, Asterite 6, Netherite 7, Arcanite 8) and for "true" tradeskills its values range from 0 to 9 (incrementing by 1 for each material level).

I´ll put that xml file online on monday.

Regards,
Doc

PostPosted: Wed Oct 27, 2004 12:00 pm
by Glitch
hi there i am reading that there is a working well sort of working crafting modle in the game and that there was going to be an xml db posted any other info? i can find i did do a search

Thanks DOL team :)

PostPosted: Wed Oct 27, 2004 12:15 pm
by Atlan
Doc Shoe has paused..
Duff is on the Implementation of Crafting now.

PostPosted: Wed Oct 27, 2004 4:21 pm
by duff
yep and i will have a lot of work to make the db ;'((

PostPosted: Thu Oct 28, 2004 12:48 am
by Glitch
Well by all means tell me if there is something i can do to assist you in any way i know your plate is always full :) I love the work you guys are doing and want to get invol--- with it

Thanks

PostPosted: Thu Oct 28, 2004 7:00 am
by duff
what is your skill programation db sql c# c++ ???

PostPosted: Thu Oct 28, 2004 7:21 am
by Atlan
DB? Didnt you read into my Post further down with the Comments?

I dont think the DB issue is a Big one, and maybe i can be of some Help. Just need to get a hang of what you planned exactly.
Maybe as first step comment on my Post if this is a First Start...

regards
Atlan

PostPosted: Thu Oct 28, 2004 10:44 am
by duff
it s not a lot of work but it is not as funny as coding so i am boring to do that but i will!!

PostPosted: Thu Oct 28, 2004 11:42 am
by Glitch
i could help with db i am sure very little c or c++

I have one of every crafter on mids bors server all lgm minus an alch but i have use of it if needed maybe some logs? hehe i am the 1 outta 1000000 peeps that play to craft :P I also have tons of 50s so i can help with loggin or anything I will gladly do so

PostPosted: Thu Oct 28, 2004 12:43 pm
by duff
for moment i need sentence from master when enter in guild or when talk to him after enter in his order of craft.
what the master say when promote

PostPosted: Fri Oct 29, 2004 10:20 am
by Glitch
ok i will have them for you tonight, the join crafters guilds at very least. and tomorw I should have the names of the lvl ups along with what the trainer says :) unless rl come into play?

for midgaurd I will try to get hib and alb but might take so time

PostPosted: Fri Oct 29, 2004 12:20 pm
by Glitch
Taylor

(NPC NAME HERE), "says" would you like to join the order of [taylor]?<------¡¨this is a link¡¨ As a Taylor you can expect to sew cloth and leather armor. While you will excel in Tayloring and have good skills in Fletching, you can expect great Difficulty in Weapons crafting and Armor Crafting. A well trained Taylor also has a small bit of skill to perform Siege Crafting should it be needed


"then at this point after you click Taylor link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons" {accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Taylors!
You gain skill in:
Weaponscraft
Armorcraft
Siegecraft
Metalworking
Leatherworking
Clothworking
Tayloring
Fletching
Woodworking




Weapons crafting

(NPC NAME HERE), "says" would you like to join the order of [Weaponscrafter]?<----"this is a link" As a crafter of weapons you can expect to forge swords axes hammers and spears. While you will excel in weaponscrafting and have good skills in Armor crafting, you can expect great Difficulty in Tayloring and Fletching. A well trained Weapons crafter also has a Great bit of skill to perform Siege Crafting should it be needed


"then at this point after you click Weaponscrafter link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons" {accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Weaponsmiths!
You gain skill in:
Weaponscraft
Armorcraft
Siegecraft
Metalworking
Leatherworking
Clothworking
Tayloring
Fletching
Woodworking



Armorsmiths

(NPC NAME HERE), "says" would you like to join the order of [Armorcrafter]? <----"this is a link" As a crafter of armor you can expect to creat armor of virus types from studded leather to chain mail armor. While you will excel in Armorcrafting and have good skills in Tayloring and Weaponscrafting, you can expect great Difficulty in Fletching. A well trained Armor crafter also has a small bit of skill to perform Siege Crafting should it be needed


"then at this point after you click Armorcrafters link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons" {accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Armorsmiths!
You gain skill in:
Weaponscraft
Armorcraft
Siegecraft
Metalworking
Leatherworking
Clothworking
Tayloring
Fletching
Woodworking



Fletchers

(NPC NAME HERE), "says" would you like to join the order of [Fletchers]? <----"this is a link" As a Fletcher you can expect to create bows arrows and staves. While you will excel in Fletching and have good skills in Weaponscrafting, you can expect great Difficulty in Armorcrafting and Tayloring. A well trained Armor crafter also has a great bit of skill to perform Siege Crafting should it be needed


"then at this point after you click Armorcrafters link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons" {accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Fletchers!
You gain skill in:
Weaponscraft
Armorcraft
Siegecraft
Metalworking
Leatherworking
Clothworking
Tayloring
Fletching
Woodworking


Alchemists

(NPC NAME HERE), "says," would you like to join the order of [Alchemists]?<----"this is a link" As a Alchemist you have the ability to make Dye, Poisons, and various magical potions. You also have the ability to make magical Tintures that can add both offensive and defensive magical effects to crafted items, you have some skill in spellcrafting as well as being able to jewel craft with great skill.


"then at this point after you click Alchemists link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons"{accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Alchemists!
You gain skill in;
Siegecrafting
Alchemy
Jewelcrafting
Gemcutting
Herbalcrafting
Spell crafting



Spellcrafter

(NPC NAME HERE), "says," would you like to join the order of [Spellcrafters]?<--------"this is a link" As a Spellcrafter you have the ability to create gems, that can be imbued onto crafted items to give them new amazing magical properties, you have some skill in Alchemy as well as being able to jewel craft with great skill.


"then at this point after you click Spellcrafters link a small window pops open and ask you to confirm it says" ( are you sure you want to join this order? Once you select a primary skill you cant switch) "two buttons" {accept} {decline}

after you hit accept you get in the puls window

You've been accepted by the Spellcrafters!
You gain skill in:
Siegecrafting
Alchemy
Jewelcrafting
Gemcutting
Herbalcrafting
Spell crafting



ok here r the ranks and there names. I will get what is said once you hit top of rank when you have to see your trainer tomorow if you want.

but i think it goes "you must see your trainer to raise your skill "

this would be at say 99, 199, 299 so on so forth

then it says "you have been promoted to (start with rank name below and add your primary skill after"

0-99 - Helper
100-199 - Junior Apprentice
200-299 - Apprentice
300-399 - Neophyte
400-499 - Assistant
500-599 - Junior
600-699 - Journeyman
700-799 - Senior
800-899 - Master
900-999 - Grandmaster
1000+ - Legendary

so say 99

he would say "you have been promoted to Junior Apprentice weaponsmith" not sure if he adds the primary skill but for this dont think that realy matters just the ranking.
all this in the puls window