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.
 

Item ID List
Author
Previous Topic Next Topic
real spacer
PANIC at the Mining Field
#1 - 2011-10-26 05:39:09 UTC
Is there a list somewhere that has been filtered to only items that are on market?

I know there is the list on chribba's site ( eve-files.com/chribba/typeid.txt ) but there's so much in there to filter I was hoping that someone might have done all the work already :P
Louis Vitton
Viziam
Amarr Empire
#2 - 2011-10-26 10:12:58 UTC
real spacer wrote:
Is there a list somewhere that has been filtered to only items that are on market?

I know there is the list on chribba's site ( eve-files.com/chribba/typeid.txt ) but there's so much in there to filter I was hoping that someone might have done all the work already :P


Have you checked the ccp data dump??
Trenker
#3 - 2011-10-26 12:58:45 UTC
In the datadump do a

SELECT *
FROM `invTypes`
WHERE `marketGroupID` IS NOT NULL