open All Channels
seplocked EVE Technology Lab
blankseplocked Rigbuilding Calculator [in development]
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Chumber
Posted - 2011.07.19 12:11:00 - [1]
 

Edited by: Chumber on 19/07/2011 12:11:09
Since there seems to be no tool around where you input your salvages and it tells you what you can build / almost build i'll create one myself.

Anyone experienced with the ccp database dump can point me in the right dirrection of what groupIds are Rigs?

DejaPeaux
Mine 'N' Refine
The Unforgiven Alliance
Posted - 2011.07.19 12:26:00 - [2]
 

EVEHQ has a rig builder

Steve Ronuken
Posted - 2011.07.19 15:17:00 - [3]
 

Edited by: Steve Ronuken on 19/07/2011 15:20:59
https://www.fuzzysteve.co.uk/eve/salvage/

Threw it together a few days ago.

Just takes the one, and tells you the rest. Try it from the IGB for the links to do something.


The core of it is:

select itemname(invTypeMaterials.typeID) what ,bpid,invTypes.typeName name,quantity,invTypeMaterials.typeID topitem,invTypeMaterials.materialTypeID mainitem from invTypes,invTypeMaterials,bplookup where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID in (select distinct invTypeMaterials.typeID from invTypeMaterials where materialTypeID =? and itemname(invTypeMaterials.typeID) like ?) and bplookup.itemid=invTypeMaterials.TypeID

input parameters are:
salvage typeid
Small%
Medium%
Large%

With a custom function to simplify the lookup of itemnames, and a table to link items to their blueprints. I couldn't find the latter, so I built it myself. Doing it on the fly took too long.

Chumber
Posted - 2011.07.19 15:40:00 - [4]
 

eveHQ is perfect, i want to supply what i got and see what i can build, eveHQ uses my API so get my salvages so it's even easier than i thought - alot of time saved on my end HAHA

Thanks!

DejaPeaux
Mine 'N' Refine
The Unforgiven Alliance
Posted - 2011.07.19 21:28:00 - [5]
 

Edited by: DejaPeaux on 19/07/2011 21:31:18
http://salvage.arthurcanal.com/ is another site i have used.. but it doesn't import but i like the interface.
And http://www.xn7.de/ has a rigbuilder section but it doesn't import either.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only