Page 1 of 1

EQ2 Recipe Database

Posted: December 14th, 2004, 3:28 pm
by darkfire5252
Ok, so I was going to sit down and write a VBScript that would allow one to look up the components required for any recipie, potential profit per craft, vendor prices, etc, but for that I need a database listing all the ingredients for recipes. Has anyone found something like this?

I know there is one for cookers at Register to unlock hidden link, but I was looking for one that covered all the crafts. I imagine this would help crafting scripts a lot.

Posted: December 14th, 2004, 7:27 pm
by wyvernx
Ever thought of making one for this site?

Re: EQ2 Recipe Database

Posted: December 14th, 2004, 8:51 pm
by darkfire5252
Heh, thought of and dismissed. I program, cataloging data isn't my thing, I was hoping it was someone's out there.

Re: EQ2 Recipe Database

Posted: December 17th, 2004, 2:26 pm
by darkfire5252
As of 12/17 I am working on a recipie database. It will have a backend built in VBScript, and will be able to save and load databases from files.

As soon as I have a set interface, if there is demand, I will post it here so that it can be included in scripts before it is done. Also post any feature requests (sellback cost to merchants, etc.)

I am an alchemist, so I have the basic 1-9, the scholar 10-19, and the beginning alchemy recipies, but I will be needing more later. The script will have means for creating recipies, so you guys can help with the fleshing out of it later.

Re: EQ2 Recipe Database

Posted: December 17th, 2004, 3:18 pm
by darkfire5252
I need information about what you need from a recipie database, i have no clue what to put in aside from the basics.

Re: EQ2 Recipe Database

Posted: December 17th, 2004, 4:52 pm
by darkfire5252
Update: Here is the interface for the class that I have so far, this looks to be semi-final, let me know asap about missing features

Code: Register to unlock hidden link

'Recipe class:  Coded by Darkfire for EQ2, suppose it could be used for other 
'	crafting things.  Interface is as follows, don't fret about version numbers
'	all future releases will be backwards compatible.

'Properties (all properties are read only, unless specified)
'
' Name - the name of the finished item, with no quality clarifiers (shaped, etc)
'
' Level - the skill level of the recipie.  0 for primary ingredients
'
' Skill - the skill used in this rec, Chemistry, etc.  returns string
'
' numParts - the total number of ingredients, including fuel and primary, will be 0
'	if the entry is a primary ingredient
'
' Parts - returns an array of all ingredients. returns an array of objects, not just names
'	note, ingredients may be recipies all their own, check before assuming
'
' merSell - the price that the NPC SELLS the item for - 0 is not availible
'
' merBuy - the price that the NPC BUYS the item for.  0 is NO-VALUE
'
' makeCost - returns an array: array(0) is the cost of the parts that can be
'	bought from merchants.  from 1 to UBound - 1 consists of a list of items
'	that cannot be bought from merchants
'
' estProfit - returns output just like makeCost, but array(0) is the estimated
'	profit if everything was bought from NPC, and sold to NPC.  the other elements need
'	to be gotten
'
' fromBook - the name of the book that scribes the recipie, may not be avalible, so
'	USE ERROR CHECKING
'
' Sellable - True unless NO-VALUE
' Buyable - True if buyable from NPC
' isRec - True if it is a recipe (false if its a primary ingredient)
' isIng - Inverse of isRec

'Methods
'
' Load(FileName, RecipieName) - Loads the specified entry from a file, returns the name
'	on a successful load, "NoFile" on file not found, "NoEntry" on file found, but entry doenst exist
'
' Save(FileName, RefFileName) - Adds entry to FileName, optionally putting a reference in RefFileName
'	Pass "" as RefFileName for no reference entries
'

Re: EQ2 Recipe Database

Posted: December 22nd, 2004, 5:09 pm
by Cyanbane
Kinda unorganized... but currently working on for Alchemist Potions and Poisons.

Register to unlock hidden link