Need help with a project

OnyxCougar · 11-17-2004, 01:17 PM

I'm not sure if this should go here or in internet, but here goes:

I'm playing Everquest 2, which has a pretty complex crafting system.

Each "recipe" has components which are made of "refined" materials, which is, in itself, a recipe, requiring other components.

Example: (*) indicates that this is a raw component and needs no processing.

To make a piece of rawhide armor, I need the following components:
Rawhide Hide Plate
Generic Pattern
Rawhide Cord
Filament (*)

Rahwide Hide Plate requires the following components:
stretch of rawhide
chloro oil
filament (*)

Stretch of Rawhide requires the following components:
Sullied Pelt (*)
Chlorowash
filament (*)

Chlorowash and chloro oil each require the following components:
Raw Root (*)
liquid (*)
candle (*)

Etcetera.

My question is this:
How do a make a system by which I enter in what I want to make, and it gives me an ingredients list, broken down into raw ingredients and the refined items to make from them?

It's been done for dark age of camelot spellcrafting, so I know it can be done, but EQ2 is so new that there isn't anything like this out yet, and I really need it if I'm going to get good at this.

Can anyone help?

SteveDallas · 11-17-2004, 01:30 PM

Sounds like you need a recipe filing database. (I'm not joking--I have seen ones where you put it the menu and it collates the recipes to provide a "shopping list" of what raw ingredients you need to make the stated menu.)

Cyber Wolf · 11-17-2004, 01:32 PM

Are you talking about making a database for your own personal use?

I've got something along those lines for the craftable stuff in Ultima Online.

OnyxCougar · 11-17-2004, 01:35 PM

Yes, just for me (and Arimoose -my husband- and Hawkwind -his best friend) but not for dissemination.

jaguar · 11-17-2004, 01:47 PM

The multilevel nature of it would be best suited to a decent DB and SQL and a frontend involving a few lines of code, it's not a cut and paste jobbie. Off the top of my head you'd need a database of every item in the game and then you enter an item, the query returns a list of ingredients, checks if any are non-raw then runs queries to get those ingredients...

The only other solution would be to find a constructive way to fill your time rather than evercrack

Cyber Wolf · 11-17-2004, 02:09 PM

I run mine with Access just fine.

Troubleshooter · 11-17-2004, 02:22 PM

Hey, I can quit any time I want.

OnyxCougar · 11-17-2004, 02:24 PM

Cyber, how do you have access set up?

jaguar · 11-17-2004, 02:37 PM

It's doable in access but it does involve a little coding to get the multi-level acspect to work automatically.

Cyber Wolf · 11-17-2004, 03:35 PM

For all of the details, I'd have to be at home to look at it...I built it a couple of years ago. But the quick, "easy" version is this:

I have Table A set up with all of the various components, things that do and don't need processing to create, each with its own primary key. Then I have Table B with all of the various craftables that I make, linked to Table A. Each record in Table B lists by name the craftable item, then has as attributes the primary key of all the components necessary to create it, as well as an attribute for the tool(s) needed to create an item.

For example, I search Table B for "bread" and get a return listing for "dough" as the item and "oven" as the tool. And since I know the "dough" also has to be crafted, I can then search "dough" and end up with "flour" and "pitcher of water".

On my To-Do list is to add some kind of indicator to show which returned items are things that need to be crafted. I know them already but with the new expansion coming out, there's new things to craft and I know I'm going to forget pretty quick.

Is something like that basically what you want?

OnyxCougar · 11-17-2004, 04:18 PM

well, to be honest, I'm completely lost. Gah.

perth · 11-17-2004, 04:40 PM

Haha! Nerds.

... Back to refreshing the World of Warcraft forums for more information on tradeskills.

Cyber Wolf · 11-17-2004, 04:52 PM

Lost you at 'For all of the details...', did I?

Ok, simpler version:

My Access database matches ingredients to craftable items.

OnyxCougar · 11-17-2004, 05:01 PM

tee hee. the problem inherent is not your explaination, rather, my lack of understanding on how access (or any other database) works.

jaguar · 11-17-2004, 05:03 PM

ah well, if you're willing to manually do the recursive searches....I was working on the assumption you wanted something automated.

11-17-2004, 01:17 PM	#1
OnyxCougar Junior Master Dwellar Join Date: Mar 2003 Location: Kingdom of Atlantia Posts: 2,979	Need help with a project I'm not sure if this should go here or in internet, but here goes: I'm playing Everquest 2, which has a pretty complex crafting system. Each "recipe" has components which are made of "refined" materials, which is, in itself, a recipe, requiring other components. Example: () indicates that this is a raw component and needs no processing. To make a piece of rawhide armor, I need the following components: Rawhide Hide Plate Generic Pattern Rawhide Cord Filament () Rahwide Hide Plate requires the following components: stretch of rawhide chloro oil filament () Stretch of Rawhide requires the following components: Sullied Pelt () Chlorowash filament () Chlorowash and chloro oil each require the following components: Raw Root () liquid () candle () Etcetera. My question is this: How do a make a system by which I enter in what I want to make, and it gives me an ingredients list, broken down into raw ingredients and the refined items to make from them? It's been done for dark age of camelot spellcrafting, so I know it can be done, but EQ2 is so new that there isn't anything like this out yet, and I really need it if I'm going to get good at this. Can anyone help? __________________ Impotentes defendere libertatem non possunt. "Repetition does not transform a lie into a truth." ~Franklin D. Roosevelt

11-17-2004, 01:32 PM	#3
Cyber Wolf As stable as a ring of PU-239 Join Date: Jun 2004 Location: On a huge rock covered in water, highly advanced moss and 7 billion parasites Posts: 1,264	Are you talking about making a database for your own personal use? I've got something along those lines for the craftable stuff in Ultima Online. __________________ "I don't see what's so triffic about creating people as people and then getting' upset 'cos they act like people." ~Adam Young, Good Omens "I don't see why it matters what is written. Not when it's about people. It can always be crossed out." ~Adam Young, Good Omens

11-17-2004, 01:35 PM	#4
OnyxCougar Junior Master Dwellar Join Date: Mar 2003 Location: Kingdom of Atlantia Posts: 2,979	Yes, just for me (and Arimoose -my husband- and Hawkwind -his best friend) but not for dissemination. __________________ Impotentes defendere libertatem non possunt. "Repetition does not transform a lie into a truth." ~Franklin D. Roosevelt

11-17-2004, 01:47 PM	#5
jaguar whig Join Date: Apr 2001 Posts: 5,075	The multilevel nature of it would be best suited to a decent DB and SQL and a frontend involving a few lines of code, it's not a cut and paste jobbie. Off the top of my head you'd need a database of every item in the game and then you enter an item, the query returns a list of ingredients, checks if any are non-raw then runs queries to get those ingredients... The only other solution would be to find a constructive way to fill your time rather than evercrack __________________ Good friends, good books and a sleepy conscience: this is the ideal life. - Twain

11-17-2004, 02:09 PM	#6
Cyber Wolf As stable as a ring of PU-239 Join Date: Jun 2004 Location: On a huge rock covered in water, highly advanced moss and 7 billion parasites Posts: 1,264	I run mine with Access just fine. __________________ "I don't see what's so triffic about creating people as people and then getting' upset 'cos they act like people." ~Adam Young, Good Omens "I don't see why it matters what is written. Not when it's about people. It can always be crossed out." ~Adam Young, Good Omens

11-17-2004, 01:30 PM	#2
SteveDallas Your Bartender Join Date: Jan 2002 Location: Philly Burbs, PA Posts: 7,651	Sounds like you need a recipe filing database. (I'm not joking--I have seen ones where you put it the menu and it collates the recipes to provide a "shopping list" of what raw ingredients you need to make the stated menu.)

11-17-2004, 02:22 PM	#7
Troubleshooter The urban Jane Goodall Join Date: Jan 2004 Location: Florida Posts: 3,012	Hey, I can quit any time I want. __________________ I have gained this from philosophy: that I do without being commanded what others do only from fear of the law. - Aristotle

11-17-2004, 02:24 PM	#8
OnyxCougar Junior Master Dwellar Join Date: Mar 2003 Location: Kingdom of Atlantia Posts: 2,979	Cyber, how do you have access set up? __________________ Impotentes defendere libertatem non possunt. "Repetition does not transform a lie into a truth." ~Franklin D. Roosevelt

11-17-2004, 02:37 PM	#9
jaguar whig Join Date: Apr 2001 Posts: 5,075	It's doable in access but it does involve a little coding to get the multi-level acspect to work automatically. __________________ Good friends, good books and a sleepy conscience: this is the ideal life. - Twain

11-17-2004, 03:35 PM	#10
Cyber Wolf As stable as a ring of PU-239 Join Date: Jun 2004 Location: On a huge rock covered in water, highly advanced moss and 7 billion parasites Posts: 1,264	For all of the details, I'd have to be at home to look at it...I built it a couple of years ago. But the quick, "easy" version is this: I have Table A set up with all of the various components, things that do and don't need processing to create, each with its own primary key. Then I have Table B with all of the various craftables that I make, linked to Table A. Each record in Table B lists by name the craftable item, then has as attributes the primary key of all the components necessary to create it, as well as an attribute for the tool(s) needed to create an item. For example, I search Table B for "bread" and get a return listing for "dough" as the item and "oven" as the tool. And since I know the "dough" also has to be crafted, I can then search "dough" and end up with "flour" and "pitcher of water". On my To-Do list is to add some kind of indicator to show which returned items are things that need to be crafted. I know them already but with the new expansion coming out, there's new things to craft and I know I'm going to forget pretty quick. Is something like that basically what you want? __________________ "I don't see what's so triffic about creating people as people and then getting' upset 'cos they act like people." ~Adam Young, Good Omens "I don't see why it matters what is written. Not when it's about people. It can always be crossed out." ~Adam Young, Good Omens

11-17-2004, 04:18 PM	#11
OnyxCougar Junior Master Dwellar Join Date: Mar 2003 Location: Kingdom of Atlantia Posts: 2,979	well, to be honest, I'm completely lost. Gah. __________________ Impotentes defendere libertatem non possunt. "Repetition does not transform a lie into a truth." ~Franklin D. Roosevelt

11-17-2004, 04:40 PM	#12
perth Strong Silent Type Join Date: Mar 2002 Location: Fort Collins, CO Posts: 1,949	Haha! Nerds. ... Back to refreshing the World of Warcraft forums for more information on tradeskills.

11-17-2004, 04:52 PM	#13
Cyber Wolf As stable as a ring of PU-239 Join Date: Jun 2004 Location: On a huge rock covered in water, highly advanced moss and 7 billion parasites Posts: 1,264	Lost you at 'For all of the details...', did I? Ok, simpler version: My Access database matches ingredients to craftable items. __________________ "I don't see what's so triffic about creating people as people and then getting' upset 'cos they act like people." ~Adam Young, Good Omens "I don't see why it matters what is written. Not when it's about people. It can always be crossed out." ~Adam Young, Good Omens

11-17-2004, 05:01 PM	#14
OnyxCougar Junior Master Dwellar Join Date: Mar 2003 Location: Kingdom of Atlantia Posts: 2,979	tee hee. the problem inherent is not your explaination, rather, my lack of understanding on how access (or any other database) works. __________________ Impotentes defendere libertatem non possunt. "Repetition does not transform a lie into a truth." ~Franklin D. Roosevelt

11-17-2004, 05:03 PM	#15
jaguar whig Join Date: Apr 2001 Posts: 5,075	ah well, if you're willing to manually do the recursive searches....I was working on the assumption you wanted something automated. __________________ Good friends, good books and a sleepy conscience: this is the ideal life. - Twain

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)