Created
November 23, 2010 21:20
-
-
Save outworlder/712560 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (include "orly") | |
| (define-model <inventory-categories> "invcategories" | |
| (categoryID categoryName description iconID published)) | |
| (has-many <inventory-categories> <inventory-groups> groups foreign-key: categoryID) | |
| (define-model <inventory-type-reactions> "invtypereactions" | |
| (reactionTypeID input typeID quantity)) | |
| (belongs-to <inventory-type-reactions> <inventory-types> inventory foreign-key: typeID) | |
| (define-model <inventory-groups> "invgroups" | |
| (groupID categoryID groupName description iconID useBasePrice allowManufacture allowRecycler anchored anchorable fittableNonSingleton published)) | |
| (belongs-to <inventory-groups> <inventory-categories> category foreign-key: categoryID) | |
| (has-many <inventory-groups> <inventory-types> inventories foreign-key: groupID) | |
| (define-model <inventory-types> "invtypes" | |
| (typeID groupID typeName description iconID radius mass volume capacity portionSize raceID basePrice published marketGroupID chanceOfDuplicating)) | |
| (define-method (print-object (obj <inventory-types>) #!optional (port (current-output-port))) | |
| (fprintf port "<#inventory-types typeID:[~A] typeName:[\"~A\"]>" (slot-value obj 'typeID) (slot-value obj 'typeName))) | |
| (belongs-to <inventory-types> <inventory-groups> group foreign-key: groupID) | |
| (has-many <inventory-types> <inventory-type-reactions> reactions foreign-key: typeID) | |
| (has-many <inventory-types> <planet-schematics-typemap> typemaps foreign-key: typeID) | |
| (define-model <planet-schematics> "planetSchematics" | |
| (schematicID schematicName cycleTime)) | |
| (define-method (print-object (obj <planet-schematics>) #!optional (port (current-output-port))) | |
| (fprintf port "<#planet-schematics schematicID:[~A] schematicName:[\"~A\"]>" (slot-value obj 'schematicID) (slot-value obj 'schematicName))) | |
| (has-many <planet-schematics> <planet-schematics-typemap> typemaps foreign-key: schematicID) | |
| (define-model <planet-schematics-typemap> "planetschematicstypemap" | |
| (schematicID typeID quantity isInput)) | |
| (belongs-to <planet-schematics-typemap> <planet-schematics> schematic foreign-key: schematicID) | |
| (belongs-to <planet-schematics-typemap> <inventory-types> inventory foreign-key: typeID primary-key: typeID) | |
| (define (get-planetary-category) | |
| (find-by-id <inventory-categories> 43)) | |
| (define (get-planetary-groups category-id) | |
| (find-by-id <inventory-groups> category-id)) | |
| (define (get-planetary-items) | |
| (let ([category (get-planetary-category)]) | |
| (map (lambda (group) | |
| (inventories group)) (groups category)))) | |
| (define (make-production-tree item #!optional acum) | |
| (let ([schematic (get-schematic item)]) | |
| (if (null? schematic) | |
| item | |
| (let ([inputs (get-inputs schematic)]) | |
| (if (null? inputs) | |
| schematic | |
| (list item (map | |
| (lambda (input) | |
| (make-production-tree (get-item input) acum)) inputs))))))) | |
| (define-method (get-inputs (schematic <planet-schematics>)) | |
| (filter (lambda (item) | |
| (= (slot-value item 'isInput) 1)) (typemaps schematic))) | |
| (define-method (get-output (schematic <planet-schematics>)) | |
| (car (filter (lambda (item) | |
| (= (slot-value item 'isInput) 0)) | |
| (typemaps schematic)))) | |
| (define-method (get-item (schematic <planet-schematics>)) | |
| (inventory (get-output schematic))) | |
| (define-method (get-item (schematic-typemap <planet-schematics-typemap>)) | |
| (inventory schematic-typemap)) | |
| (define-method (get-schematic (item <inventory-types>)) | |
| (let ([schematic-typemap | |
| (filter (lambda (item) | |
| (equal? (slot-value item 'isInput) 0)) (typemaps item))]) | |
| (if (null? schematic-typemap) | |
| schematic-typemap | |
| (schematic (car schematic-typemap))))) | |
| #;2> ,p (make-production-tree (get-item (find-by-id <planet-schematics> 119))) | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 119 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 119 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2876 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2876 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 119 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 119 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2349 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2349 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 96 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 96 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2328 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2328 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 72 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 72 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 9832 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 9832 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 66 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 66 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2390 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2390 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 123 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 123 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2309 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2309 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 9836 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 9836 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 76 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 76 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2400 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2400 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 128 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 128 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2272 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2272 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2401 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2401 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 129 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 129 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2306 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2306 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2358 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2358 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 104 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 104 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2463 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2463 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 78 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 78 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3725 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3725 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 84 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 84 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2395 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2395 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 133 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 133 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2287 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2287 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2396 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2396 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 134 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 134 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2288 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2288 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3828 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3828 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 74 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 74 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2400 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2400 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 128 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 128 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2272 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2272 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2367 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2367 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 111 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 111 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2319 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2319 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 86 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 86 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3691 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3691 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 68 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 68 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2390 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2390 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 123 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 123 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2309 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2309 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3683 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3683 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 124 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 124 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2310 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2310 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3693 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3693 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 82 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 82 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2395 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2395 | |
| Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 133 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 133 | |
| Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2287 | |
| Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2287 | |
| (<#inventory-types typeID:[2876] typeName:["Wetware Mainframe"]> | |
| ((<#inventory-types typeID:[2349] typeName:["Supercomputers"]> | |
| ((<#inventory-types typeID:[2328] typeName:["Water-Cooled CPU"]> | |
| ((<#inventory-types typeID:[2398] typeName:["Reactive Metals"]> | |
| (<#inventory-types typeID:[2267] typeName:["Base Metals"]>)) | |
| (<#inventory-types typeID:[3645] typeName:["Water"]> | |
| (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>)))) | |
| (<#inventory-types typeID:[9832] typeName:["Coolant"]> | |
| ((<#inventory-types typeID:[2390] typeName:["Electrolytes"]> | |
| (<#inventory-types typeID:[2309] typeName:["Ionic Solutions"]>)) | |
| (<#inventory-types typeID:[3645] typeName:["Water"]> | |
| (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>)))) | |
| (<#inventory-types typeID:[9836] typeName:["Consumer Electronics"]> | |
| ((<#inventory-types typeID:[2400] typeName:["Toxic Metals"]> | |
| (<#inventory-types typeID:[2272] typeName:["Heavy Metals"]>)) | |
| (<#inventory-types typeID:[2401] typeName:["Chiral Structures"]> | |
| (<#inventory-types typeID:[2306] typeName:["Non-CS Crystals"]>)))))) | |
| (<#inventory-types typeID:[2358] typeName:["Biotech Research Reports"]> | |
| ((<#inventory-types typeID:[2463] typeName:["Nanites"]> | |
| ((<#inventory-types typeID:[2393] typeName:["Bacteria"]> | |
| (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>)) | |
| (<#inventory-types typeID:[2398] typeName:["Reactive Metals"]> | |
| (<#inventory-types typeID:[2267] typeName:["Base Metals"]>)))) | |
| (<#inventory-types typeID:[3725] typeName:["Livestock"]> | |
| ((<#inventory-types typeID:[2395] typeName:["Proteins"]> | |
| (<#inventory-types typeID:[2287] typeName:["Complex Organisms"]>)) | |
| (<#inventory-types typeID:[2396] typeName:["Biofuels"]> | |
| (<#inventory-types typeID:[2288] typeName:["Carbon Compounds"]>)))) | |
| (<#inventory-types typeID:[3828] typeName:["Construction Blocks"]> | |
| ((<#inventory-types typeID:[2398] typeName:["Reactive Metals"]> | |
| (<#inventory-types typeID:[2267] typeName:["Base Metals"]>)) | |
| (<#inventory-types typeID:[2400] typeName:["Toxic Metals"]> | |
| (<#inventory-types typeID:[2272] typeName:["Heavy Metals"]>)))))) | |
| (<#inventory-types typeID:[2367] typeName:["Cryoprotectant Solution"]> | |
| ((<#inventory-types typeID:[2319] typeName:["Test Cultures"]> | |
| ((<#inventory-types typeID:[2393] typeName:["Bacteria"]> | |
| (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>)) | |
| (<#inventory-types typeID:[3645] typeName:["Water"]> | |
| (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>)))) | |
| (<#inventory-types typeID:[3691] typeName:["Synthetic Oil"]> | |
| ((<#inventory-types typeID:[2390] typeName:["Electrolytes"]> | |
| (<#inventory-types typeID:[2309] typeName:["Ionic Solutions"]>)) | |
| (<#inventory-types typeID:[3683] typeName:["Oxygen"]> | |
| (<#inventory-types typeID:[2310] typeName:["Noble Gas"]>)))) | |
| (<#inventory-types typeID:[3693] typeName:["Fertilizer"]> | |
| ((<#inventory-types typeID:[2393] typeName:["Bacteria"]> | |
| (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>)) | |
| (<#inventory-types typeID:[2395] typeName:["Proteins"]> | |
| (<#inventory-types typeID:[2287] typeName:["Complex Organisms"]>)))))))) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment