| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Nealla Fraer
Gallente
Stonewall Interstellar
   |
Posted - 2007.09.06 05:27:00 -
[1]
I'm relatively new to working with the data export and have been fiddling around with it for a few days now and I had a simple question.
What does the published column in invTypes stand for? I can tell that there is a relation between it and what is listed in the market, but is it as simple as that? If published is FALSE does that mean that the item is not available at all or just not on the market, specifically referring to blueprints?
Thanks for any and all help.
|
La Tortura
Sebiestor tribe
|
Posted - 2007.09.06 07:30:00 -
[2]
What is listed on market and what is not is determined by MarketGroupID field in the same table. If it is not null, the item is listed on market, else it isn't.
I'll look on this one more time today evening, but as far as I remember "published" determines if it is possible to search for the item in contracts or hotlink item type by right clicking on the string in the chat input window.
--
ignorance is bliss |
Gilgamoth
Imperium Technologies
Firmus Ixion
|
Posted - 2007.09.06 08:48:00 -
[3]
Be aware however Published means available on the market, not available in game. There are items and skills that are set to published=0, but are active in game (Black Market Trading skill as one example).
Regards,
Gil
Future Falcon EVE Tools - Project Leader.
|
Nealla Fraer
Gallente
Stonewall Interstellar
|
Posted - 2007.09.06 16:29:00 -
[4]
Is there a filter that I could set up that will only give me blueprint originals that are available to be produced by players? Not just the ones that are listed on the market, but any blueprint originals that a resident could possibly have access to.
Thanks for the responses so far and any other help you can give me.
|
La Tortura
Sebiestor tribe
|
Posted - 2007.09.07 14:13:00 -
[5]
 Originally by: Nealla Fraer
Is there a filter that I could set up that will only give me blueprint originals that are available to be produced by players? Not just the ones that are listed on the market, but any blueprint originals that a resident could possibly have access to.
Afaik both set are equivalent. There are no available BPOs that aren't listed on market, and there're BPO's on market that can't be produced by players.
Players could only get BPC's if the BPO isn't listed on market.
--
ignorance is bliss |
Wyehr
Shadow Of The Light
R i s e
|
Posted - 2007.09.08 23:14:00 -
[6]
Edited by: Wyehr on 08/09/2007 23:15:20
SELECT t1.*,t2.* FROM invBlueprintTypes AS t1
LEFT JOIN invTypes AS t2 ON t1.blueprintTypeID=t2.typeID
[ 2007.03.18 18:45:59 ] (notify) Typhoon belonging to Gandolf self-destructs. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |