| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Donde Esta
   |
Posted - 2008.08.13 18:30:00 -
[1]
I found Pwett's response to this post: http://oldforums.eveonline.com/?a=topic&threadID=481073
And I need to know where I can find what each activityID means. Wasn't able to find a lookup table in the data export, but I could easily have missed it. I appreciate the help from Pwett or anyone else that has the info.
|
Lord Fitz
Project Amargosa
|
Posted - 2008.08.13 19:10:00 -
[2]
The latest database export has it in the ramActivities table.
0None
1Manufacturing
2Researching Technology
3Researching Time Productivity
4Researching Material Productivity
5Copying
6Duplicating
7Reverse Engineering
8Invention
|
Donde Esta
|
Posted - 2008.08.13 19:29:00 -
[3]
Excellent, thanks. New question, do you, or anyone else, know why some Quantity values are negative in the Materials table? Example:
"24.306";"1";"34";"-92.584";"1,00"
I believe this says that a Minmatar Service Outpost Platform requires -92,584 units of isogen to build. Am I interpreting this correctly? If so, why is the value negative?
|
Lord Fitz
Project Amargosa
|
Posted - 2008.08.13 19:54:00 -
[4]
Minmatar Service outpost is typeID 21946 and requires
Station Construction Parts10
Station Hangar Array10
Station Storage Bay10
Station Factory20
Station Repair Facility10
Station Reprocessing Plant100
Station Docking Bay10
Station Medical Center10
Station Office Center80
Station Mission Network10
Item 24306 is the Modulated Deep Core Strip Miner II Blueprint it shows:
Tritanium-25989
Pyerite-17771
Mexallon-6050
Isogen-1500
Nocxium-1316
Megacyte-238
If you look at the items it consumes it uses a Deep Core Mining Laser I and Strip Miner I, it's possible it's just accounting for these minerals internally for some logging CCP do as they appear to match up. Personally for building I'd just ignore anything that uses qunatity < 0.
|
Donde Esta
|
Posted - 2008.08.13 20:00:00 -
[5]
Ahh, thats a pain. That means I need to figure out how to associate a bpo with an item it produces.
|
Lord Fitz
Project Amargosa
|
Posted - 2008.08.13 20:19:00 -
[6]
look at invBlueprintTypes
blueprintTypeID
productTypeID
|
Pwett
Minmatar
QUANT Corp.
QUANT Hegemony
|
Posted - 2008.08.13 20:19:00 -
[7]
Edited by: Pwett on 13/08/2008 20:19:36
Glad I could help :-p
invBlueprintTypes table connects the blueprintTypeID with the productTypeID
/edit: Fitz is on crack
_______________
Pwett
CEO, Founder, & Executor
<Q> QUANT Hegemony
|
Lord Fitz
Project Amargosa
|
Posted - 2008.08.13 20:24:00 -
[8]
Would you believe I've had a version of the data dump for a year or two now, and am no closer to doing anything useful with it (outside of writing a few SQL queries in managment studio). Need to spend less time on forums obviously.
|
Pwett
Minmatar
QUANT Corp.
QUANT Hegemony
|
Posted - 2008.08.13 20:27:00 -
[9]
I would :)
I did exactly the same thing.
_______________
Pwett
CEO, Founder, & Executor
<Q> QUANT Hegemony
|
Donde Esta
|
Posted - 2008.08.15 12:41:00 -
[10]
Is there any way to identify what items are not in game? Stuff like "TEST Citadel torpedo launcher blueprint" etc.
|
Burchov
Lyrus Associates
|
Posted - 2008.08.15 14:14:00 -
[11]
The "published" field in invTypes lists that, it's 1 if it exists ingame, 0 if not.
________
Invention profit calculator |
Donde Esta
|
Posted - 2008.08.15 14:56:00 -
[12]
You guys all rock.
|
Pwett
Minmatar
QUANT Corp.
QUANT Hegemony
|
Posted - 2008.08.15 15:11:00 -
[13]
 Originally by: Burchov
The "published" field in invTypes lists that, it's 1 if it exists ingame, 0 if not.
That's not always 100% accurate, but it is a good foundation. I had another filter somewhere, let me see if I can scrounge it up.
_______________
Pwett
CEO, Founder, & Executor
<Q> QUANT Hegemony
|
Donde Esta
|
Posted - 2008.08.25 16:59:00 -
[14]
Originally by: Donde Esta
Originally by: Matalino
You can find a list of activities here or here.
Is there a newer dump with eas, widows, hic's, etc?
Sorry to cross post, but I'm not sure the other board is that active. Can someone respond to my self quoted question above?
Thanks again.
|
Sikel
QUANT Corp.
QUANT Hegemony
|
Posted - 2008.08.25 18:03:00 -
[15]
Should be, they just did a dump a couple weeks ago.
http://myeve.eve-online.com/devblog.asp?a=blog&bid=575
|
Donde Esta
|
Posted - 2008.08.25 19:22:00 -
[16]
Wrote all my stuff around importing the data from the old csv files, which are no longer supported. fantastic.
|
Lord Fitz
Project Amargosa
|
Posted - 2008.08.26 06:41:00 -
[17]
Shouldn't be much different ? One of the table names was changed (the TL2TypeMaterials or whatever to just TypeMaterialsActivty)
|
Donde Esta
|
Posted - 2008.08.26 13:14:00 -
[18]
opening and parsing a .csv file is quite a bit different than querying a mssql db I think. ill try finding someone's exports to csv
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |