EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » typeIDs for all market items for current expansion

Topic is locked indefinitely.

typeIDs for all market items for current expansion
Author

Previous Topic Next Topic

Wingmate

Perkone

Caldari State

Likes received: 271

#1 - 2013-04-08 13:44:17 UTC | Edited by: Wingmate

i found the thread where Fuzzworks put up the list of market IDs as of 11/12, but i'd like one that's current. does anyone have it?

thanks!

edit: specifically i'm looking for mods, though, so if you could include the slot that they go in, that'd be even better!

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433

Fuzzwork Enterprises Vote Steve Ronuken for CSM 6,759
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#2 - 2013-04-08 14:09:44 UTC Don't suppose you could throw up a link for the thread? iirc, I stuck the sql into it. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Wingmate Perkone Caldari State Likes received: 271	#3 - 2013-04-08 14:13:26 UTC \| Edited by: Wingmate https://forums.eveonline.com/default.aspx?g=posts&t=148139 like i said, if you can include the class or slot for the items, that'd be awesome for organization purposes. thanks. i make spreadsheets for pretty cheap. contact me for more info. https://forums.eveonline.com/default.aspx?g=posts&t=197433


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#4 - 2013-04-08 15:09:11 UTC Drat. I didn't. I'll have to remember to do it this time. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#5 - 2013-04-08 15:48:34 UTC | Edited by: Steve Ronuken

select invTypes.typeid,typename,groupname,invTypes.typeid,case effectid when 11 then 'Low' when 12 then 'High' when 13 then 'Medium' when 2663 then 'Rig' else 'na' end slot from invTypes join invGroups on (invGroups.groupid=invTypes.groupid) left join dgmTypeEffects on (dgmTypeEffects.typeid=invTypes.typeid and dgmTypeEffects.effectid in (11,12,13,2663)) where invTypes.marketGroupID is not null and invTypes.published=1 into outfile '/tmp/marketwslots.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';

http://www.fuzzwork.co.uk/resources/marketwslots.csv

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter


Wingmate Perkone Caldari State Likes received: 271	#6 - 2013-04-08 15:52:07 UTC almost! highs are mids, mids are lows, and lows are na. it's close enough, though, i can do some scanning to get it in the right order. thanks again, man, fuzz comes through all the time. i make spreadsheets for pretty cheap. contact me for more info. https://forums.eveonline.com/default.aspx?g=posts&t=197433


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#7 - 2013-04-08 16:03:05 UTC oops. That should be it fixed in the original. misread my dgmEffects lookup. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Wingmate Perkone Caldari State Likes received: 271	#8 - 2013-04-08 16:04:16 UTC looks great, dude. thanks so much. i make spreadsheets for pretty cheap. contact me for more info. https://forums.eveonline.com/default.aspx?g=posts&t=197433