Offering to help collect recipes

[Wolfysins]

Hey there... I'm wondering if it would be possible to help collect recipes for you. For instance, I could provide a spread sheet of recipes, if you had a format that would be useful. Or I could even produce SQL insert statements, if you cared to share the format of your tables and maybe an example (to help cover the differences in various forms of SQL).

I have a 21 carpenter and 20 alchemist and could take care of recipes from the purchased books for either of them.

[Inyidd]

If you have recipes that don't show up when you search for them, please put them in the Database Submissions forum! As much data on recipes as possible is best. What book, level, skill, knowledge, tradeskill device, etc... We welcome any and all submissions. Things are a bit slow right now due to the holidays, and the fact that Denmum MUST sleep (*ahem*).

Thanks for any help you can give. :)

[Ngreth Thergn]

well, the structure for 2 of the 3 important tables is here:

http://www.mboards.eqtraders.com/eq2/showthread.php?t=1525

the other is

#
# Table structure for table `recipes_map`
#

CREATE TABLE recipes_map (
recipe_id int(11) unsigned NOT NULL default '0',
item_id int(11) unsigned NOT NULL default '0',
slot enum('pc','b1','b2','b3','b4') NOT NULL default 'pc',
UNIQUE KEY recipe_id (recipe_id,item_id,slot),
KEY item_id (item_id)
) TYPE=MyISAM COMMENT='Main Recipe Map';


the map is the complex part where individual items that fit the slots (pc = primary component, then b1-4 is build 1-4) are entered.

so... a spreadsheet of every field you can think of helps :)

[Lordebon]

That's some nice database work =)

One question, what do you use to actually input data into the database? What jumps to mind would be a couple .php files, or even one that you just enter everything into and it does all the work. But thats still a lot of work, hehe.

[Ngreth Thergn]

currently sets of php driven forms, in a pasworded area of the site :)

[Wolfysins]

Ngeth, the link you provided is currently broken (some sort of message board error), so I can't see that format right now.

I'd like to provide the recipes in a fashion that gets them into the database most quickly. Maybe you want to give me access to the pages? Otherwise I can provide a spreadsheet, and you can tell me what I could do with the spreadsheet that would make it load most easily for you, and I'll adjust until the format is best.

If you're wondering whether I'm trustworthy, I can provide references. Reference #1 -- I'm the guy who wrote:

http://www.innoruuk.com

That is, my EQ1 serverwide web site runs on my equipment (although we use EzBoard for the forums, and I stay away from that side). I have a pretty decent rep on my server. I'm also the person who founded Team Epic on my server a couple of years ago. I'm told the entire concept of people helping each other was unique, but it seemed pretty straightforward to me.

So... whatever works for you. It's your site. I'd just like to help get recipes in, using whatever process is most efficient.

If I don't hear something different from you, I'll post the spreadsheet I have so far when I get home tonight.

[Ngreth Thergn]

the boards were jsut having problems :)

the link again is http://www.mboards.eqtraders.com/eq2/showpost.php?p=20221&postcount=8

the items are easy... just the simple insert.

recipes on the other hand take an insert to the recipes table, then inserts into the map table for every item that can be put in the pc,b1,b2,b3,b4 slot for that recipe. (primary component, build 1-4) The insert of the map cannot be cleanly made until a recipe ID is achieved through the insert of the recipe. So a CVS (spreadsheet) would work best here so I can make a php script to parse the CVS and make the apropriate inserts.

[Lordebon]

Lol, I'd say at most 5-10% of those reading this understand what is being discussed. Isn't it CSV (comma delimited / Comma Separated Values)? CVS is a pharmacy chain hehe. Whenever I've done anything with .csv files I always think how odd it is to take a set of data, use part of it and generate more data, then use the rest, some repeats, and that new data to finish up hehe.

[Inyidd]

Heh. Probably CSV, yes. :)

CVS is a fairly standard versioning system that developers use.

[Ngreth Thergn]

so I made a typo :)