Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 5 post(s) |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4109
|
Posted - 2014.10.31 17:24:43 -
[1] - Quote
mysql: https://www.fuzzwork.co.uk/dump/mysql56-phoebe-1.0-107269.tbz2
postgres: https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/postgres-phoebe-1-107269.dmp.bz2 (https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/postgres-phoebe-1-107269-schema.dmp.bz2 is the same, but in an eve schema)
sqlite: https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/eve.db.bz2
Everything else: https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
CCP Phantom
C C P C C P Alliance
4888
|
Posted - 2014.10.31 18:56:57 -
[2] - Quote
Thank you!
Great work as always,Steve Ronuken
CCP Phantom - Senior Community Representative - Volunteer Manager
|
|
Mana Potion
Brave Operations - Lollipop Division Brave Collective
19
|
Posted - 2014.10.31 21:00:20 -
[3] - Quote
As always... stellar work!
Thanks Steve |
Tennoku
Mercury Nation House of Mercury
13
|
Posted - 2014.11.01 05:01:56 -
[4] - Quote
Thanks!
I noticed in another thread you posted the following query:
SELECT materialtypeid,typename,greatest(1,ceil(quantity*(1-(7/100)))) runquantity FROM industryActivityMaterials JOIN invTypes ON (industryActivityMaterials.materialtypeid=invTypes.typeid) WHERE industryActivityMaterials.typeid=22465 and activityid=1;
+----------------+-------------------------------+-------------+ | materialtypeid | typename | runquantity | +----------------+-------------------------------+-------------+ | 3828 | Construction Blocks | 22 | | 11399 | Morphite | 14 | | 11478 | R.A.M.- Starship Tech | 9 | | 11533 | Magpulse Thruster | 56 | | 11534 | Gravimetric Sensor Cluster | 70 | | 11540 | Quantum Microprocessor | 335 | | 11544 | Titanium Diborite Armor Plate | 1395 | | 11550 | Graviton Reactor Unit | 14 | | 11552 | Scalar Capacitor Unit | 140 | | 11558 | Sustained Shield Emitter | 36 | | 16238 | Cormorant | 1 | +----------------+-------------------------------+-------------+
When I run that, my output is (using the postgres DB, and query modified):
SELECT "materialTypeID","typeName",greatest(1,ceil(quantity*(1-(7/100)))) as runquantity FROM "industryActivityMaterials" JOIN "invTypes" ON ("industryActivityMaterials"."materialTypeID"="invTypes"."typeID") WHERE "industryActivityMaterials"."typeID"=22465 and "activityID"=1;
materialTypeID | typeName | runquantity ----------------+--------------------+------------- 0 | #System | 150 2 | Corporation | 60 3 | Region | 1 4 | Constellation | 23 5 | Solar System | 75 6 | Sun G5 (Yellow) | 9 7 | Sun K7 (Orange) | 1500 8 | Sun K5 (Red Giant) | 360 9 | Sun B0 (Blue) | 38 10 | Sun F0 (White) | 15 (10 rows
When I look at the DB data, the materialTypeID's in the industryActivityMaterials number 0 through 10 for most or all products, appearing to be an index relative to each blueprint rather than ID's to actual invTypes. It appears I could use the info from invTypeMaterials, but I would like to understand the discrepancy here.
Has the DB structure changed since you wrote that query a few months ago? What does materialTypeID refer to?
Also, the values for industryActivityProducts productTypeID appear to be missing.
If I look at the Oceanus sqlite DB, the values appear as I would have expected them.
Thanks! |
Captain Thunk
Sniggerdly Pandemic Legion
147
|
Posted - 2014.11.01 07:25:10 -
[5] - Quote
Seriously, the datadump needs to a unified structure.
It's ridiculous with yaml parts, mssql parts and sqlite parts.
Being dependent on effectively one or two guys to convert it into something people can use is stupid |
Althalus Stenory
Flying Blacksmiths
45
|
Posted - 2014.11.01 11:01:00 -
[6] - Quote
This is the exact same problem as I reported here for the early phoebe SDE : https://forums.eveonline.com/default.aspx?g=posts&m=5128325#post5128325
I was hoping it'll be fixed :/ |
|
CCP FoxFour
C C P C C P Alliance
3609
|
Posted - 2014.11.01 11:28:50 -
[7] - Quote
Captain Thunk wrote:Seriously, the datadump needs to a unified structure.
It's ridiculous with yaml parts, mssql parts and sqlite parts.
Being dependent on effectively one or two guys to convert it into something people can use is stupid
And we agree, it's on my list of things to look at. What I actually want to do is get it to be an artifact of our CI system, and then with the push of a button it be uploaded to our CDN and added to an RSS feed so that you guys can just follow that and get notified when a new version is released.
Thats the dream, and isn't actually that far off. There are just other things that I want to do that are taking higher priority. It's really hard to justify the effort of doing that work when someone like Steve is doing it and I could be doing other things.
CCP FoxFour // Game Designer // @CCP_FoxFour
|
|
|
CCP FoxFour
C C P C C P Alliance
3609
|
Posted - 2014.11.01 11:30:14 -
[8] - Quote
I have passed word of this on to others, but it's the weekend now and with the Phoebe release on Tuesday it may be a bit before a response.
CCP FoxFour // Game Designer // @CCP_FoxFour
|
|
Althalus Stenory
Flying Blacksmiths
45
|
Posted - 2014.11.01 12:01:46 -
[9] - Quote
CCP FoxFour wrote:I have passed word of this on to others, but it's the weekend now and with the Phoebe release on Tuesday it may be a bit before a response. No problems, thanks :)
But just to be sure, my previous post was about sde conversion issues (not taking the correct value in the yaml), and not data duplications (as it seems there is no more issues for this now :D) |
|
CCP FoxFour
C C P C C P Alliance
3610
|
Posted - 2014.11.01 13:18:43 -
[10] - Quote
Althalus Stenory wrote:CCP FoxFour wrote:I have passed word of this on to others, but it's the weekend now and with the Phoebe release on Tuesday it may be a bit before a response. No problems, thanks :) But just to be sure, my previous post was about sde conversion issues (not taking the correct value in the yaml), and not data duplications (as it seems there is no more issues for this now :D)
Ah yes, it does appear to have been an issue in the conversion as the YAML and such all seems fine.
CCP FoxFour // Game Designer // @CCP_FoxFour
|
|
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4111
|
Posted - 2014.11.01 20:29:59 -
[11] - Quote
CCP FoxFour wrote:Althalus Stenory wrote:CCP FoxFour wrote:I have passed word of this on to others, but it's the weekend now and with the Phoebe release on Tuesday it may be a bit before a response. No problems, thanks :) But just to be sure, my previous post was about sde conversion issues (not taking the correct value in the yaml), and not data duplications (as it seems there is no more issues for this now :D) Ah yes, it does appear to have been an issue in the conversion as the YAML and such all seems fine.
I screwed up.
It's the same problem as with the initial beta. I created a new loader script, and this time, forgot and ran the old one. I'll have a proper update soon.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4112
|
Posted - 2014.11.01 21:04:36 -
[12] - Quote
That's it updated.
If you need just the industry tables (on mysql) https://www.fuzzwork.co.uk/dump/phoebe-1.0-107269/industryTables.sql.bz2
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Tennoku
Mercury Nation House of Mercury
13
|
Posted - 2014.11.02 09:47:20 -
[13] - Quote
Great, thanks! I'll check that out as soon as I have time. |
Ydnari
Estrale Frontiers Project Wildfire
366
|
Posted - 2014.11.04 01:35:58 -
[14] - Quote
The blueprints.yaml and hence the conversion still have Data Interfaces as materials for invention.
e.g.
10679: activities: copying: time: 720 invention: materials: - quantity: 1 typeID: 20412 - quantity: 1 typeID: 20414 - quantity: 1 typeID: 25556
25556 is Incognito Data Interface, 10679 is 125mm Railgun I Blueprint.
http://community.eveonline.com/news/dev-blogs/invention-updates/ says Data Interfaces are going away.
my teapot is ready
|
Ydnari
Estrale Frontiers Project Wildfire
366
|
Posted - 2014.11.04 15:05:33 -
[15] - Quote
Ydnari wrote:The blueprints.yaml and hence the conversion still have Data Interfaces as materials for invention. e.g. 10679: activities: copying: time: 720 invention: materials: - quantity: 1 typeID: 20412 - quantity: 1 typeID: 20414 - quantity: 1 typeID: 25556 25556 is Incognito Data Interface, 10679 is 125mm Railgun I Blueprint. http://community.eveonline.com/news/dev-blogs/invention-updates/ says Data Interfaces are going away.
And this is also in game now with the Phoebe release; 125mm Railguns still need a Data Interface to invent, which no longer exist.
my teapot is ready
|
Aineko Macx
316
|
Posted - 2014.11.04 20:02:51 -
[16] - Quote
Before the removal of interfaces, we could get the groupID of compatible decryptors for invention via dgmAttributeType=1115 of the used interface. Now that they are gone, there doesn't seem to be a clean way to get this data.
iveeCore: PHP library for calculation of industrial activities
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4121
|
Posted - 2014.11.04 20:23:05 -
[17] - Quote
Aineko Macx wrote:Before the removal of interfaces, we could get the groupID of compatible decryptors for invention via dgmAttributeType=1115 of the used interface. Now that they are gone, there doesn't seem to be a clean way to get this data.
Now you use groupud 1304 (iirc).
Universal decryptors.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Desmont McCallock
408
|
Posted - 2014.11.04 20:28:20 -
[18] - Quote
Also I found data inconsistencies in blueprints.yaml data. https://forums.eveonline.com/default.aspx?g=posts&m=5174902#post5174902 |
Aineko Macx
316
|
Posted - 2014.11.05 18:51:51 -
[19] - Quote
ramAssemblyLineTypeDetailPerCategory is missing all rows for categoryID=9 (Blueprints)
iveeCore: PHP library for calculation of industrial activities
|
Aineko Macx
316
|
Posted - 2014.11.06 18:59:13 -
[20] - Quote
ignore
iveeCore: PHP library for calculation of industrial activities
|
|
Desmont McCallock
410
|
Posted - 2014.11.08 13:11:31 -
[21] - Quote
Ydnari wrote:Ydnari wrote:The blueprints.yaml and hence the conversion still have Data Interfaces as materials for invention. e.g. 10679: activities: copying: time: 720 invention: materials: - quantity: 1 typeID: 20412 - quantity: 1 typeID: 20414 - quantity: 1 typeID: 25556 25556 is Incognito Data Interface, 10679 is 125mm Railgun I Blueprint. http://community.eveonline.com/news/dev-blogs/invention-updates/ says Data Interfaces are going away. And this is also in game now with the Phoebe release; 125mm Railguns still need a Data Interface to invent, which no longer exist. Not only that. Datacores are mentioned as skill prerequisite in some blueprints (i.e 1121) instead of their skill counterpart. I'm currently fixing the blueprint.yaml file and will release along with the importation tool. |
Desmont McCallock
410
|
Posted - 2014.11.08 15:31:34 -
[22] - Quote
A fixed version of the blueprints.yaml file can be found here. Also I have released a new version of the importation tool. |
Zifrian
Licentia Ex Vereor Northern Associates.
1585
|
Posted - 2014.11.09 01:20:07 -
[23] - Quote
Anyone looking into all the ids after ID: 34267 issue? They all have different blueprintTypeIDs as Desmond M reported.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Ydnari
Estrale Frontiers Project Wildfire
384
|
Posted - 2014.11.09 01:40:06 -
[24] - Quote
The blueprint types in invTypes for the "Polarized" weapons are wrongly named, they are called "Stigmatic", one of the previous names.
mysql> select typeName from invTypes where typeName like 'Stigmatic%'; +----------------------------------------------------+ | typeName | +----------------------------------------------------+ | Stigmatic 200mm AutoCannon Blueprint | | Stigmatic 425mm AutoCannon Blueprint | | Stigmatic 800mm Repeating Cannon Blueprint | | Stigmatic Heavy Assault Missile Launcher Blueprint | | Stigmatic Heavy Neutron Blaster Blueprint | | Stigmatic Heavy Pulse Laser Blueprint | | Stigmatic Light Neutron Blaster Blueprint | | Stigmatic Mega Pulse Laser Blueprint | | Stigmatic Neutron Blaster Cannon Blueprint | | Stigmatic Rocket Launcher Blueprint | | Stigmatic Small Pulse Laser Blueprint | | Stigmatic Torpedo Launcher Blueprint | +----------------------------------------------------+ 12 rows in set (0.02 sec)
mysql> select typeName from invTypes where typeName like 'Polarized%'; +------------------------------------------+ | typeName | +------------------------------------------+ | Polarized 200mm AutoCannon | | Polarized 425mm AutoCannon | | Polarized 800mm Repeating Cannon | | Polarized Heavy Assault Missile Launcher | | Polarized Heavy Neutron Blaster | | Polarized Heavy Pulse Laser | | Polarized Light Neutron Blaster | | Polarized Mega Pulse Laser | | Polarized Neutron Blaster Cannon | | Polarized Rocket Launcher | | Polarized Small Pulse Laser | | Polarized Torpedo Launcher | +------------------------------------------+ 12 rows in set (0.00 sec)
my teapot is ready
|
Desmont McCallock
410
|
Posted - 2014.11.09 08:48:58 -
[25] - Quote
Ydnari wrote:The blueprint types in invTypes for the "Polarized" weapons are wrongly named, they are called "Stigmatic", one of the previous names. mysql> select typeName from invTypes where typeName like 'Stigmatic%'; +----------------------------------------------------+ | typeName | +----------------------------------------------------+ | Stigmatic 200mm AutoCannon Blueprint | | Stigmatic 425mm AutoCannon Blueprint | | Stigmatic 800mm Repeating Cannon Blueprint | | Stigmatic Heavy Assault Missile Launcher Blueprint | | Stigmatic Heavy Neutron Blaster Blueprint | | Stigmatic Heavy Pulse Laser Blueprint | | Stigmatic Light Neutron Blaster Blueprint | | Stigmatic Mega Pulse Laser Blueprint | | Stigmatic Neutron Blaster Cannon Blueprint | | Stigmatic Rocket Launcher Blueprint | | Stigmatic Small Pulse Laser Blueprint | | Stigmatic Torpedo Launcher Blueprint | +----------------------------------------------------+ 12 rows in set (0.02 sec)
mysql> select typeName from invTypes where typeName like 'Polarized%'; +------------------------------------------+ | typeName | +------------------------------------------+ | Polarized 200mm AutoCannon | | Polarized 425mm AutoCannon | | Polarized 800mm Repeating Cannon | | Polarized Heavy Assault Missile Launcher | | Polarized Heavy Neutron Blaster | | Polarized Heavy Pulse Laser | | Polarized Light Neutron Blaster | | Polarized Mega Pulse Laser | | Polarized Neutron Blaster Cannon | | Polarized Rocket Launcher | | Polarized Small Pulse Laser | | Polarized Torpedo Launcher | +------------------------------------------+ 12 rows in set (0.00 sec)
Confirmed.
|
creator85
Easy man... Easy...
3
|
Posted - 2014.11.11 08:07:58 -
[26] - Quote
Where Phoebe 1.2 SDE? |
Zifrian
Licentia Ex Vereor Northern Associates.
1586
|
Posted - 2014.11.11 21:56:17 -
[27] - Quote
The ramAssemblyLineTypeDetailPerCategory table is missing a bunch of data.
Noticeably, copying, ME and TE research assemblyLineTypeIDs
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Aineko Macx
316
|
Posted - 2014.11.12 06:01:27 -
[28] - Quote
Zifrian, that table is missing all assemblyLine Blueprint compatibility data. I had to implement a hack (ignoring possible cost bonuses) for cat=9 on activities 3, 4, 5 and 8 to make the normal compatibility logic not break, you'll probably have to do something similar until that data is returned to the SDE.
iveeCore: PHP library for calculation of industrial activities, now with Phoebe support.
|
Zifrian
Licentia Ex Vereor Northern Associates.
1586
|
Posted - 2014.11.13 01:06:44 -
[29] - Quote
Aineko Macx wrote:Zifrian, that table is missing all assemblyLine Blueprint compatibility data. I had to implement a hack (ignoring possible cost bonuses) for cat=9 on activities 3, 4, 5 and 8 to make the normal compatibility logic not break, you'll probably have to do something similar until that data is returned to the SDE. I just copied the table from oceanus into my build.
I'm wondering when we'll get an update. Foxfour apparently hasn't seen this thread.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
CCP FoxFour
C C P C C P Alliance
3682
|
Posted - 2014.11.13 09:07:35 -
[30] - Quote
Is the table missing from the actual SDE or the conversion?
CCP FoxFour // Game Designer // @CCP_FoxFour
|
|
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |