I- T I E -I
Posted - 2011.04.06 13:09:00 - [1
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...
-- advanced pulse...
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.