API tools faq
paste
Guest User

Untitled

a guest
Jul 15th, 2018
55
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.57 KB | None | 0 0
raw download clone embed print report
  1. (include "orly")
  2.  
  3. (define-model <inventory-categories> "invcategories"
  4. (categoryID categoryName description iconID published))
  5.  
  6. (has-many <inventory-categories> <inventory-groups> groups foreign-key: categoryID)
  7.  
  8. (define-model <inventory-type-reactions> "invtypereactions"
  9. (reactionTypeID input typeID quantity))
  10.  
  11. (belongs-to <inventory-type-reactions> <inventory-types> inventory foreign-key: typeID)
  12.  
  13. (define-model <inventory-groups> "invgroups"
  14. (groupID categoryID groupName description iconID useBasePrice allowManufacture allowRecycler anchored anchorable fittableNonSingleton published))
  15.  
  16. (belongs-to <inventory-groups> <inventory-categories> category foreign-key: categoryID)
  17. (has-many <inventory-groups> <inventory-types> inventories foreign-key: groupID)
  18.  
  19. (define-model <inventory-types> "invtypes"
  20. (typeID groupID typeName description iconID radius mass volume capacity portionSize raceID basePrice published marketGroupID chanceOfDuplicating))
  21.  
  22. (define-method (print-object (obj <inventory-types>) #!optional (port (current-output-port)))
  23. (fprintf port "<#inventory-types typeID:[~A] typeName:[\"~A\"]>" (slot-value obj 'typeID) (slot-value obj 'typeName)))
  24.  
  25. (belongs-to <inventory-types> <inventory-groups> group foreign-key: groupID)
  26. (has-many <inventory-types> <inventory-type-reactions> reactions foreign-key: typeID)
  27. (has-many <inventory-types> <planet-schematics-typemap> typemaps foreign-key: typeID)
  28.  
  29. (define-model <planet-schematics> "planetSchematics"
  30. (schematicID schematicName cycleTime))
  31.  
  32. (define-method (print-object (obj <planet-schematics>) #!optional (port (current-output-port)))
  33. (fprintf port "<#planet-schematics schematicID:[~A] schematicName:[\"~A\"]>" (slot-value obj 'schematicID) (slot-value obj 'schematicName)))
  34.  
  35.  
  36. (has-many <planet-schematics> <planet-schematics-typemap> typemaps foreign-key: schematicID)
  37.  
  38. (define-model <planet-schematics-typemap> "planetschematicstypemap"
  39. (schematicID typeID quantity isInput))
  40.  
  41. (belongs-to <planet-schematics-typemap> <planet-schematics> schematic foreign-key: schematicID)
  42. (belongs-to <planet-schematics-typemap> <inventory-types> inventory foreign-key: typeID primary-key: typeID)
  43.  
  44. (define (get-planetary-category)
  45. (find-by-id <inventory-categories> 43))
  46.  
  47. (define (get-planetary-groups category-id)
  48. (find-by-id <inventory-groups> category-id))
  49.  
  50. (define (get-planetary-items)
  51. (let ([category (get-planetary-category)])
  52. (map (lambda (group)
  53. (inventories group)) (groups category))))
  54.  
  55. (define (make-production-tree item #!optional acum)
  56. (let ([schematic (get-schematic item)])
  57. (if (null? schematic)
  58. item
  59. (let ([inputs (get-inputs schematic)])
  60. (if (null? inputs)
  61. schematic
  62. (list item (map
  63. (lambda (input)
  64. (make-production-tree (get-item input) acum)) inputs)))))))
  65.  
  66.  
  67. (define-method (get-inputs (schematic <planet-schematics>))
  68. (filter (lambda (item)
  69. (= (slot-value item 'isInput) 1)) (typemaps schematic)))
  70.  
  71. (define-method (get-output (schematic <planet-schematics>))
  72. (car (filter (lambda (item)
  73. (= (slot-value item 'isInput) 0))
  74. (typemaps schematic))))
  75.  
  76. (define-method (get-item (schematic <planet-schematics>))
  77. (inventory (get-output schematic)))
  78.  
  79. (define-method (get-item (schematic-typemap <planet-schematics-typemap>))
  80. (inventory schematic-typemap))
  81.  
  82. (define-method (get-schematic (item <inventory-types>))
  83. (let ([schematic-typemap
  84. (filter (lambda (item)
  85. (equal? (slot-value item 'isInput) 0)) (typemaps item))])
  86. (if (null? schematic-typemap)
  87. schematic-typemap
  88. (schematic (car schematic-typemap)))))
  89.  
  90.  
  91.  
  92.  
  93.  
  94. #;2> ,p (make-production-tree (get-item (find-by-id <planet-schematics> 119)))
  95. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 119
  96. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 119
  97. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2876
  98. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2876
  99. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 119
  100. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 119
  101. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2349
  102. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2349
  103. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 96
  104. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 96
  105. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2328
  106. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2328
  107. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 72
  108. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 72
  109. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398
  110. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398
  111. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126
  112. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126
  113. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267
  114. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267
  115. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645
  116. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645
  117. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121
  118. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121
  119. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268
  120. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268
  121. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 9832
  122. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 9832
  123. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 66
  124. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 66
  125. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2390
  126. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2390
  127. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 123
  128. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 123
  129. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2309
  130. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2309
  131. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645
  132. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645
  133. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121
  134. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121
  135. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268
  136. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268
  137. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 9836
  138. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 9836
  139. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 76
  140. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 76
  141. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2400
  142. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2400
  143. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 128
  144. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 128
  145. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2272
  146. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2272
  147. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2401
  148. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2401
  149. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 129
  150. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 129
  151. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2306
  152. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2306
  153. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2358
  154. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2358
  155. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 104
  156. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 104
  157. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2463
  158. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2463
  159. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 78
  160. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 78
  161. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393
  162. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393
  163. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131
  164. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131
  165. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073
  166. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073
  167. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398
  168. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398
  169. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126
  170. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126
  171. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267
  172. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267
  173. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3725
  174. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3725
  175. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 84
  176. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 84
  177. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2395
  178. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2395
  179. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 133
  180. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 133
  181. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2287
  182. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2287
  183. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2396
  184. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2396
  185. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 134
  186. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 134
  187. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2288
  188. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2288
  189. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3828
  190. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3828
  191. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 74
  192. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 74
  193. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2398
  194. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2398
  195. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 126
  196. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 126
  197. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2267
  198. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2267
  199. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2400
  200. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2400
  201. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 128
  202. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 128
  203. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2272
  204. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2272
  205. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2367
  206. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2367
  207. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 111
  208. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 111
  209. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2319
  210. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2319
  211. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 86
  212. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 86
  213. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393
  214. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393
  215. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131
  216. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131
  217. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073
  218. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073
  219. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3645
  220. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3645
  221. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 121
  222. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 121
  223. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2268
  224. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2268
  225. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3691
  226. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3691
  227. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 68
  228. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 68
  229. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2390
  230. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2390
  231. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 123
  232. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 123
  233. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2309
  234. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2309
  235. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3683
  236. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3683
  237. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 124
  238. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 124
  239. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2310
  240. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2310
  241. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 3693
  242. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 3693
  243. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 82
  244. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 82
  245. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2393
  246. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2393
  247. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 131
  248. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 131
  249. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2073
  250. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2073
  251. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2395
  252. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2395
  253. Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 133
  254. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 133
  255. Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2287
  256. Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2287
  257. (<#inventory-types typeID:[2876] typeName:["Wetware Mainframe"]>
  258. ((<#inventory-types typeID:[2349] typeName:["Supercomputers"]>
  259. ((<#inventory-types typeID:[2328] typeName:["Water-Cooled CPU"]>
  260. ((<#inventory-types typeID:[2398] typeName:["Reactive Metals"]>
  261. (<#inventory-types typeID:[2267] typeName:["Base Metals"]>))
  262. (<#inventory-types typeID:[3645] typeName:["Water"]>
  263. (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>))))
  264. (<#inventory-types typeID:[9832] typeName:["Coolant"]>
  265. ((<#inventory-types typeID:[2390] typeName:["Electrolytes"]>
  266. (<#inventory-types typeID:[2309] typeName:["Ionic Solutions"]>))
  267. (<#inventory-types typeID:[3645] typeName:["Water"]>
  268. (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>))))
  269. (<#inventory-types typeID:[9836] typeName:["Consumer Electronics"]>
  270. ((<#inventory-types typeID:[2400] typeName:["Toxic Metals"]>
  271. (<#inventory-types typeID:[2272] typeName:["Heavy Metals"]>))
  272. (<#inventory-types typeID:[2401] typeName:["Chiral Structures"]>
  273. (<#inventory-types typeID:[2306] typeName:["Non-CS Crystals"]>))))))
  274. (<#inventory-types typeID:[2358] typeName:["Biotech Research Reports"]>
  275. ((<#inventory-types typeID:[2463] typeName:["Nanites"]>
  276. ((<#inventory-types typeID:[2393] typeName:["Bacteria"]>
  277. (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>))
  278. (<#inventory-types typeID:[2398] typeName:["Reactive Metals"]>
  279. (<#inventory-types typeID:[2267] typeName:["Base Metals"]>))))
  280. (<#inventory-types typeID:[3725] typeName:["Livestock"]>
  281. ((<#inventory-types typeID:[2395] typeName:["Proteins"]>
  282. (<#inventory-types typeID:[2287] typeName:["Complex Organisms"]>))
  283. (<#inventory-types typeID:[2396] typeName:["Biofuels"]>
  284. (<#inventory-types typeID:[2288] typeName:["Carbon Compounds"]>))))
  285. (<#inventory-types typeID:[3828] typeName:["Construction Blocks"]>
  286. ((<#inventory-types typeID:[2398] typeName:["Reactive Metals"]>
  287. (<#inventory-types typeID:[2267] typeName:["Base Metals"]>))
  288. (<#inventory-types typeID:[2400] typeName:["Toxic Metals"]>
  289. (<#inventory-types typeID:[2272] typeName:["Heavy Metals"]>))))))
  290. (<#inventory-types typeID:[2367] typeName:["Cryoprotectant Solution"]>
  291. ((<#inventory-types typeID:[2319] typeName:["Test Cultures"]>
  292. ((<#inventory-types typeID:[2393] typeName:["Bacteria"]>
  293. (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>))
  294. (<#inventory-types typeID:[3645] typeName:["Water"]>
  295. (<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>))))
  296. (<#inventory-types typeID:[3691] typeName:["Synthetic Oil"]>
  297. ((<#inventory-types typeID:[2390] typeName:["Electrolytes"]>
  298. (<#inventory-types typeID:[2309] typeName:["Ionic Solutions"]>))
  299. (<#inventory-types typeID:[3683] typeName:["Oxygen"]>
  300. (<#inventory-types typeID:[2310] typeName:["Noble Gas"]>))))
  301. (<#inventory-types typeID:[3693] typeName:["Fertilizer"]>
  302. ((<#inventory-types typeID:[2393] typeName:["Bacteria"]>
  303. (<#inventory-types typeID:[2073] typeName:["Micro Organisms"]>))
  304. (<#inventory-types typeID:[2395] typeName:["Proteins"]>
  305. (<#inventory-types typeID:[2287] typeName:["Complex Organisms"]>))))))))
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!