| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Cryten Jones
C5 Flight
The Serenity Initiative
124
   |
Posted - 2015.08.25 16:46:40 -
[1] - Quote
I thought that I had this down in the past but something has slipped though the age gaps :-)
Taking a tristan as an example:
New Blueprint (In Game):
Trit: 23,333
10% ME Researched Blueprint (In Game):
Trit: 21,000
industryActivityMaterials sheet from Fuzzyworks.
Trit: 21,111
I can't get the numbers to work.. should the SDE number not be 23,333 ??? |
Ydnari
Estrale Frontiers
404
|
Posted - 2015.08.25 18:58:57 -
[2] - Quote
It is.
mysql> select quantity from industryActivityMaterials where typeID = 940 and activityID = 1 and materialTypeID = 34;
+----------+
| quantity |
+----------+
| 23333 |
+----------+
1 row in set (0.01 sec)
940 is Tristan Blueprint, activity ID 1 is manufacturing, type ID 34 is trit.
my teapot is ready
|
Cryten Jones
C5 Flight
The Serenity Initiative
124
|
Posted - 2015.08.25 19:28:06 -
[3] - Quote
Ydnari wrote:It is. mysql> select quantity from industryActivityMaterials where typeID = 940 and activityID = 1 and materialTypeID = 34;
+----------+
| quantity |
+----------+
| 23333 |
+----------+
1 row in set (0.01 sec) 940 is Tristan Blueprint, activity ID 1 is manufacturing, type ID 34 is trit.
This is exactly what I expected.. I think that Fuzysteve's export has an error in the xls files... |
Cryten Jones
C5 Flight
The Serenity Initiative
124
|
Posted - 2015.08.25 23:54:16 -
[4] - Quote
Ignore me.. stupid type error !
|
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
5524
|
Posted - 2015.08.26 02:18:36 -
[5] - Quote
Just as a quick note:
The xls file is just an export from the table  It's unlikely that they wouldn't match. (Yes, I know about a certain solar system name not working right. It's a hard one to fix without rewriting an export function. Which I may do, as I'm now far more comfortable with python and its csv handling.)
Not matching what's in game is more possible As it's a conversion from the blueprint.yaml file, into multiple tables. I haven't come across any errors (since I wrote it and tested it. That was recently for this one, as I recently moved from php to python for the script) but it's very dependant on the data structure staying the same.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |