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.
 

Eve Market Items dump?
Author
Previous Topic Next Topic
Erebus Inkunen
Science and Trade Institute
Caldari State
#1 - 2013-02-15 18:55:41 UTC
Does anyone know of a static dump of just the items that are available for sale in the market? Basically just a static dump of the Item Database. I know eve-markets has a similar database and I'm building a tool that could use that DB if anyone has it hosted. I'm currently using the invTypes table from the static dump but there are a lot of items in there that aren't market items. If not, or if I'm missing something please let me know! Thanks.
Vessper
Dark Mason Society
#2 - 2013-02-15 19:11:40 UTC
If you're already using the invTypes table you can filter out all the items that have a marketGroupID of null, i.e.

SELECT * FROM invTypes WHERE marketGroupID IS NOT NULL and marketGroupID < 100000

The additional restriction is to remove DUST related items from the results.