Skip to content

Instantly share code, notes, and snippets.

@outworlder
Created November 24, 2010 18:29
Show Gist options
  • Select an option

  • Save outworlder/714150 to your computer and use it in GitHub Desktop.

Select an option

Save outworlder/714150 to your computer and use it in GitHub Desktop.
#;10> ,p (make-production-tree (get-item (find-by-id <planet-schematics> 65)))
Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 65
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 65
Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 9838
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 9838
Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 65
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 65
Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2389
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2389
Executing: SELECT schematicID,schematicName,cycleTime FROM planetSchematics WHERE schematicID = 122
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE schematicID = 122
Executing: SELECT typeID,groupID,typeName,description,iconID,radius,mass,volume,capacity,portionSize,raceID,basePrice,published,marketGroupID,chanceOfDuplicating FROM invtypes WHERE typeID = 2308
Executing: SELECT schematicID,typeID,quantity,isInput FROM planetschematicstypemap WHERE typeID = 2308
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
(<#inventory-types typeID:[9838] typeName:["Superconductors"]>
((<#inventory-types typeID:[2389] typeName:["Plasmoids"]>
(<#inventory-types typeID:[2308] typeName:["Suspended Plasma"]>))
(<#inventory-types typeID:[3645] typeName:["Water"]>
(<#inventory-types typeID:[2268] typeName:["Aqueous Liquids"]>))))
#;10> ,p (marketstat '(9838 2389 2308 3645 2268))
(*TOP* (*PI* xml "version=\"1.0\" encoding=\"utf-8\" ")
(evec_api
(@ (version "2.0") (method "marketstat_xml"))
(marketstat
(type (@ (id "9838"))
(all (volume "11868941.00")
(avg "4234.35")
(max "150000.00")
(min "1.00")
(stddev "8312.25")
(median "3631.22"))
(buy (volume "6234944.00")
(avg "2026.21")
(max "4300.00")
(min "1.00")
(stddev "1197.20")
(median "1763.07"))
(sell (volume "5633997.00")
(avg "5673.71")
(max "150000.00")
(min "1200.00")
(stddev "10471.65")
(median "4638.50")))
(type (@ (id "2389"))
(all (volume "154027892.00")
(avg "4200.27")
(max "1000000.00")
(min "0.20")
(stddev "56871.43")
(median "341.00"))
(buy (volume "148331061.00")
(avg "27.40")
(max "350.00")
(min "0.20")
(stddev "107.71")
(median "120.31"))
(sell (volume "5696831.00")
(avg "603.74")
(max "1000000.00")
(min "15.00")
(stddev "75726.81")
(median "384.75")))
(type (@ (id "2308"))
(all (volume "1083207947.00")
(avg "4.52")
(max "140.70")
(min "0.16")
(stddev "13.36")
(median "1.99"))
(buy (volume "822980000.00")
(avg "0.93")
(max "1.75")
(min "0.16")
(stddev "0.42")
(median "0.75"))
(sell (volume "260227947.00")
(avg "3.83")
(max "140.70")
(min "0.64")
(stddev "15.78")
(median "2.62")))
(type (@ (id "3645"))
(all (volume "120209995.00")
(avg "17165.56")
(max "9999999.00")
(min "0.65")
(stddev "399959.14")
(median "250.00"))
(buy (volume "66595702.00")
(avg "113.16")
(max "252.33")
(min "0.65")
(stddev "72.52")
(median "150.05"))
(sell (volume "53614293.00")
(avg "524.72")
(max "9999999.00")
(min "100.00")
(stddev "496608.44")
(median "300.00")))
(type (@ (id "2268"))
(all (volume "2012541879.00")
(avg "9.06")
(max "1000.00")
(min "0.20")
(stddev "61.56")
(median "1.99"))
(buy (volume "1517626898.00")
(avg "0.91")
(max "1.51")
(min "0.20")
(stddev "0.39")
(median "0.90"))
(sell (volume "494914981.00")
(avg "3.57")
(max "1000.00")
(min "0.45")
(stddev "74.46")
(median "2.75"))))))
#;10>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment