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.