These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page12
 

Phoebe 1.0 SDE is out.

First post First post
Author
Desmont McCallock
#21 - 2014-11-08 13:11:31 UTC  |  Edited by: Desmont McCallock
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
#22 - 2014-11-08 15:31:34 UTC  |  Edited by: Desmont McCallock
A fixed version of the blueprints.yaml file can be found here.
Also I have released a new version of the importation tool.

Edit: Link to yaml file restored.
Zifrian
The Frog Pond
Ribbit.
#23 - 2014-11-09 01:20:07 UTC  |  Edited by: Zifrian
Anyone looking into all the ids after ID: 34267 issue as Desmont M reported?

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

Ydnari
Estrale Frontiers
#24 - 2014-11-09 01:40:06 UTC
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)

--

Desmont McCallock
#25 - 2014-11-09 08:48:58 UTC
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
Caldari Provisions
Caldari State
#26 - 2014-11-11 08:07:58 UTC
Where Phoebe 1.2 SDE?
Zifrian
The Frog Pond
Ribbit.
#27 - 2014-11-11 21:56:17 UTC
The ramAssemblyLineTypeDetailPerCategory table is missing a bunch of data.

Noticeably, copying, ME and TE research assemblyLineTypeIDs

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

Aineko Macx
#28 - 2014-11-12 06:01:27 UTC
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.
Zifrian
The Frog Pond
Ribbit.
#29 - 2014-11-13 01:06:44 UTC
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.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

CCP FoxFour
C C P
C C P Alliance
#30 - 2014-11-13 09:07:35 UTC
Is the table missing from the actual SDE or the conversion?

@CCP_FoxFour // Technical Designer // Team Tech Co

Third-party developer? Check out the official developers site for dev blogs, resources, and more.

Aineko Macx
#31 - 2014-11-13 13:12:20 UTC
The table isn't missing. The rows for categoryID=9 are.
Zifrian
The Frog Pond
Ribbit.
#32 - 2014-11-20 02:27:26 UTC
All storyline blueprints that used racial decryptors pre Pheobe still have the decryptors in their material lists for the blueprints. Those were removed this patch but the tables still have them.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

Haunting Widow
Honor Forge
Joint Operation Involving Nobodys
#33 - 2014-11-24 01:33:23 UTC
What happened to the .bak files I used to use for databases in microsoft sql server? I loved working with those files for all my eve data needs.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#34 - 2014-11-24 02:04:02 UTC  |  Edited by: Steve Ronuken
Haunting Widow wrote:
What happened to the .bak files I used to use for databases in microsoft sql server? I loved working with those files for all my eve data needs.


https://developers.eveonline.com/resource/static-data-export


This post is about conversions of it, into different formats Smile

(I forgot to add the link)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Khanadien Karlov
Wu Xi Holdings
#35 - 2014-12-07 06:05:31 UTC
In the blueprints.yaml, why is blueprintTypeID duplicated across some fields? For example, blueprintTypeID: 31158

34309:
  activities:
...
      products:
      - quantity: 1
        typeID: 34308
...
  blueprintTypeID: 31158
  maxProductionLimit: 30


31158:
  activities:
...
      products:
      - quantity: 1
        typeID: 31157
....
  blueprintTypeID: 31158
  maxProductionLimit: 30



The primary key here exists in industryBlueprints table so I don't understand what the blueprintTypeID is suppose to represent exactly.
Khanadien Karlov
Wu Xi Holdings
#36 - 2014-12-07 08:43:48 UTC  |  Edited by: Khanadien Karlov
34189:
  activities:
    copying:
      time: 480
    manufacturing:
      materials:
      - quantity: 4
        typeID: 40
      - quantity: 13
        typeID: 25335
      products:
      - quantity: 1
        typeID: 34188   <<<<------------
      time: 600
    research_material:
      time: 210
    research_time:
      time: 210
  blueprintTypeID: 34189
  maxProductionLimit: 1000


What is this product? It doesn't seem to be defined in the types table.
Desmont McCallock
#37 - 2014-12-07 10:43:18 UTC
Khanadien Karlov wrote:
34189:
  activities:
    copying:
      time: 480
    manufacturing:
      materials:
      - quantity: 4
        typeID: 40
      - quantity: 13
        typeID: 25335
      products:
      - quantity: 1
        typeID: 34188   <<<<------------
      time: 600
    research_material:
      time: 210
    research_time:
      time: 210
  blueprintTypeID: 34189
  maxProductionLimit: 1000


What is this product? It doesn't seem to be defined in the types table.
https://forums.eveonline.com/default.aspx?g=posts&m=5190247#post5190247
Khanadien Karlov
Wu Xi Holdings
#38 - 2014-12-07 19:06:12 UTC
Desmont McCallock wrote:
Khanadien Karlov wrote:


typeID: 34188 <<<<------------

What is this product? It doesn't seem to be defined in the types table.
https://forums.eveonline.com/default.aspx?g=posts&m=5190247#post5190247


Thanks, but this does not answer the question. I've already fixed this yaml issue by adding a dummy type into the database. I would still like to know what is missing, and why is it missing.
iwannadig
Doomheim
#39 - 2014-12-28 20:54:39 UTC
Previous page12