open All Channels
seplocked EVE Technology Lab
blankseplocked [Data Dump - SQL help] Blueprint navigation
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Roan Pico
Amarr
I- T I E -I
Posted - 2011.04.06 13:09:00 - [1]
 

Hi there,
could need some help with a SQL statement.
I want to do a navigation (for the web with PHP) which is similar to the one ingame, with categories and their subcategories like:

ammunition & charges
- frequency crystals
-- advanced beam...
--- XL
--- L
--- ...
-- advanced pulse...
etc.
etc.
etc.

Also i need it filtered to show only (sub)categories which have items buildable by players only (afaik the dump contains things like implants BPO and similar non-buildable stuff).

Needed tables are (as far as i got it):

invMarketGroups(marketGroupID) <-> invTypes(marketGroupID)
invTypes(typeID) <-> invBlueprintTypes(productTypeID) -> invBlueprintTypes(blueprintTypeID)

Didnīt do SQL stuff for a long while now = no clue. So im thankful for any tips, links or a complete solution.

Lost'In'Space
Posted - 2011.04.10 18:23:00 - [2]
 

Edited by: Lost''In''Space on 10/04/2011 18:27:11
..

Sidrat Flush
Caldari
Eve Industrial Corp
Posted - 2011.04.13 01:28:00 - [3]
 

I've just done an access version of a basic database from the Incursion datadump which MIGHT help you

http://eve-files.com/dl/241372

I'm sure you can get something from that if you have access.

Otherwise just take a look and tell me what you think.


 

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