 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. |