These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Planetary data in SQL
Author
Previous Topic Next Topic
Salani
Salani Corp
#1 - 2011-12-13 12:12:27 UTC
Hello,

Does anyone know where i can find prices on planetary data in the database?

Base data on extractors, upgrade cost of command center, high-tech factory and so forth?

what about statistics on different planetary items (CPU cost of basic factory etc.)

Basically all the data form http://wiki.eveonline.com/en/wiki/Command_Center

Would be nice if i did not have to make my own tables.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2011-12-13 13:50:35 UTC
select * from invTypes where typename like '%extractor%';

select * from invTypes where typename like '%High-Tech%';


Look at 'basePrice'

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Salani
Salani Corp
#3 - 2011-12-13 15:02:26 UTC
Thanks Steve now i just need to find the command center upgrade prices.(Those baseprices in invTypes are wrong/outdated)

Anyone know if you can look up in database what resources you can potentially harvest from a type of planet? (base metal from barren and so forth)