Future of Missing Recipes

Quick and easy way to see what recipes your character is missing

Moderators: zeryl, Teta68

Which solution would you prefer?

Poll ended at Fri Sep 29, 2006 4:15 am

XML
8
47%
SQL
9
53%
 
Total votes : 17

Future of Missing Recipes

Postby zeryl » Fri Sep 15, 2006 4:15 am

Ok, so i'm thinking of version 2.0

I've got alot of problems in the current version (probelms w/ cURL, fopen, etc), not to mention the problems w/ localization.

So my question to you is this.

Do you guys want an XML based solution (that will load the proper XML for the language/profession), or do you want an SQL solution, that will involve loading all the SQL for every profession/item.

XML will be great for those using PHP5, as the XML functions are built in, and I would have to use an external library to make it backward compatible for PHP4.

SQL will be good, but the only downside is that I'm not sure how large SQL table will end up being with all the professions/items. (I will probably distribute a SQL file per language so you don't have to load the enUS table if you use deDE)

So please vote. If you have any other suggestions for data storage, PLEASE suggest it!

-Z
Last edited by zeryl on Wed Jun 25, 2008 5:37 pm, edited 1 time in total.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Future of Missing Recipes

Postby nightfighter » Fri Sep 29, 2006 8:51 pm

I missed the vote, but if you do the SQL way, please make it so it still would allow the loading of all the different localization versions to the data table.
User avatar
nightfighter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 169
Joined: Wed Jul 05, 2006 11:25 pm
Location: Boise, Idaho, USA

Re: Future of Missing Recipes

Postby zeryl » Sat Sep 30, 2006 7:02 pm

Ok, so i'm going to go full steam ahead with making this all done in SQL.

There probably won't be much in the way of visual/presentation, all the big stuff will be behind the scenes.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Future of Missing Recipes

Postby BlackRabbit » Fri Mar 02, 2007 8:01 pm

Is there a BC update coming out????
User avatar
BlackRabbit
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Sat Jul 08, 2006 12:40 am

Future of Missing Recipes

Postby zeryl » Fri Mar 02, 2007 8:13 pm

I don't think I will. I know that there are a couple threads here showing how to add jewelcrafting to the list. Unfortunately I don't have the time, nor regex know-how to make this work much better than it is.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Future of Missing Recipes

Postby robojerk » Fri Mar 02, 2007 8:35 pm

XML or SQL, Separate professions and faction better. What I mean is this for example, I'm a horde swordsmith. Obviously I can't learn alliance or other trade specific types of recipes of blacksmithing.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

Future of Missing Recipes

Postby ScratchMonkey » Fri Mar 02, 2007 11:55 pm

Don't exclude recipes that can only be purchased by the other faction. I regularly sell faction-specific recipes across the neutral AH at great profit and want to know which ones to sell. (The cooking recipes available from the Stormwind Master of Recipes are a good example, as are the leatherworking recipes in Arathi at Hammerfall and Refuge Point.)
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

Future of Missing Recipes

Postby ScratchMonkey » Fri Mar 02, 2007 11:58 pm

For flexibility, you could keep the data in XML and write a small conversion script to make a SQL file out of it. Keeping the data in the DB should give the web server better performance, but XML may be a more convenient source format to compile the data in.
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

Future of Missing Recipes

Postby BlackRabbit » Tue Mar 06, 2007 4:51 pm

Do you people actually read posts by the author... he says he wont be updating it, he's to busy these days...

I hope someone will be willing to update this addon, I think its great... wont be much use without the BC stuff though... :(

Zeryl, is there any way we can convince you to update it ???? I have some netherweave cloth you can have ;) maybe strech to primal mooncloth.
User avatar
BlackRabbit
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Sat Jul 08, 2006 12:40 am

Re: Future of Missing Recipes

Postby sendrome » Tue Mar 13, 2007 7:52 pm

I am in the process of reworking this addon for our guild i have made a nice little converter what will convert the data from alakazahm into whatever format you want using a template system i am including the xml and tsv version of the database and i will attach my script as well. I will be posting more info on my guild's website Fools Of Chaos
Attachments
mysql_schema.zip
mysql schema used for tsv file
(362 Bytes) Downloaded 334 times
dbmaker.zip
script used to generate the data files
(2.01 KiB) Downloaded 328 times
dbmaker.xml.zip
profession database in xml format
(97.2 KiB) Downloaded 355 times
dbmaker.tsv.zip
profession database in tsv format
(82.67 KiB) Downloaded 323 times
Last edited by sendrome on Tue Mar 13, 2007 7:53 pm, edited 1 time in total.
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm


Return to Missing Recipes

Who is online

Users browsing this forum: No registered users and 0 guests

cron