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 page123Next page
 

Kronos SDE is out

First post First post
Author
Previous Topic Next Topic
Manhim
Garoun Investment Bank
Gallente Federation
#21 - 2014-06-02 19:33:22 UTC
Zifrian
The Frog Pond
Ribbit.
#22 - 2014-06-03 01:11:21 UTC
Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:

INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large
INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital

I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.

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

Import CCP's SDE - EVE SDE Database Builder
Cryten Jones
Advantage Inc
#23 - 2014-06-05 15:50:35 UTC
Not sure if this has been mentioned before but the parent blueprint types are missing from the inv_blueprints table.

I am having to do some major SQL-Fu to workout what T1 BPO is needed for a specific T2 type..


Or I could be totally missing how this is done and have wasted my time :-)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#24 - 2014-06-05 16:00:28 UTC  |  Edited by: Steve Ronuken
They've been missing for a long time.

I assume you mean to go from T2 to T1 for invention?

To do that, you join via invMetaTypes on the producttypeid

I've written the core query below, then wrapped it up in some display code so you can see names. Smile It doesn't have the entries where there is no parent, but that could be introduced by using outer joins instead of inner. (If I needed it, I'd probably just update the base table.)


select it1.typename,it2.typename from
(

select parent.blueprintTypeID parent,child.blueprintTypeID child
from invBlueprintTypes child
join invMetaTypes on (child.productTypeID=invMetaTypes.typeID)
join invBlueprintTypes parent on (invMetaTypes.parentTypeID=parent.productTypeID)


) parentchild
join invTypes it1 on (it1.typeid=parent)
join invTypes it2 on (it2.typeid=child)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Cryten Jones
Advantage Inc
#25 - 2014-06-05 16:04:29 UTC
I did something similar, think I looked at what t1 was using the the build, found the T1 bpo from that.

Mine screws up when you have more than one T1 item used in production of a T2 (Modulated Deep core mining lasers for example) so I will have another look with yours
Zifrian
The Frog Pond
Ribbit.
#26 - 2014-06-06 01:16:08 UTC
Zifrian wrote:
Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:

INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large
INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital

I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.

This is still a problem in Kronos_1.0_98534. Straight

I saw someone said they had issues trying to invent these. Is this related? I remember in the past the datadump issues seemed to mimic invention issues like this in game.

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

Import CCP's SDE - EVE SDE Database Builder
Desmont McCallock
#27 - 2014-06-07 10:51:56 UTC
Zifrian wrote:
Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:

INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large
INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital

I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.
I confirm this.
Aquila Sagitta
Blue-Fire
#28 - 2014-06-15 06:30:30 UTC
Anyone wanna help a newbro (to building eve tools) out?

I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...

I understand basic sql, I understand php, I don't understand how to import this :3 pls help!

Blue-Fire Best Fire
Desmont McCallock
#29 - 2014-06-15 07:42:54 UTC  |  Edited by: Desmont McCallock
Aquila Sagitta wrote:
Anyone wanna help a newbro (to building eve tools) out?

I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...

I understand basic sql, I understand php, I don't understand how to import this :3 pls help!
On my adventures learning WAMP I too encounter this nerve breaking behavior of phpmyadmin. I ended up using an alternative way of importing the MySql version of the SDE. HeidiSQL (which handles MySQL) was my first sw but I ended up using Navicat (which can handle all DBs). So I strongly recommend you to find something else than phpmyadmin to do what you are after.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#30 - 2014-06-15 15:42:18 UTC
Aquila Sagitta wrote:
Anyone wanna help a newbro (to building eve tools) out?

I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...

I understand basic sql, I understand php, I don't understand how to import this :3 pls help!



The other option is just to use the actual mysql tools.

log into the command line tool.

use databasename;
\. filename.sql

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Aquila Sagitta
Blue-Fire
#31 - 2014-06-15 18:36:56 UTC
I don't think I have access to a command line for sql thru Wamp.

Could I just make a php script that builds the database with the files and put the dump files in my Wamp www directory?

What are the .yaml files for?

Blue-Fire Best Fire
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#32 - 2014-06-15 20:08:13 UTC
Aquila Sagitta wrote:
I don't think I have access to a command line for sql thru Wamp.

Could I just make a php script that builds the database with the files and put the dump files in my Wamp www directory?

What are the .yaml files for?



Some of the data isn't in the original export (or in the version I provide. I've loaded some of it)

As for the command line, I'm surprised. you'd be looking for an exe called mysql

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Aquila Sagitta
Blue-Fire
#33 - 2014-06-15 21:18:33 UTC
Oh wow I'm dumb... totally passed over MySql Console the first time thinking thats not it derp. Thanks for the help!

Blue-Fire Best Fire
Aquila Sagitta
Blue-Fire
#34 - 2014-06-15 23:52:22 UTC
Ok got kronos.sql file to build the tables. What do I do with the .yaml files?

Blue-Fire Best Fire
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#35 - 2014-06-16 00:20:02 UTC
Aquila Sagitta wrote:
Ok got kronos.sql file to build the tables. What do I do with the .yaml files?


In general, ignore them. unless you need the data in them Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Doctor Goldsmith
Isk Happens
#36 - 2014-06-19 01:19:44 UTC
What is an SDE? What?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#37 - 2014-06-19 03:44:14 UTC
Doctor Goldsmith wrote:
What is an SDE? What?



Static Data Extract.

It's the data which doesn't change day to day, about EVE.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#38 - 2014-06-22 18:11:45 UTC  |  Edited by: Desmont McCallock
Steve Ronuken wrote:
Doctor Goldsmith wrote:
What is an SDE? What?



Static Data Extract.

It's the data which doesn't change day to day, about EVE.
I thought SDE stand for Static Data Export but.... what the heck, at the end it's all static data after all. Pirate
Zifrian
The Frog Pond
Ribbit.
#39 - 2014-07-06 00:16:38 UTC
Found another data error.

In the invTypeReactions table, the output (input = 0) for all Metamaterials Reactions is 1 but the reaction in game provides 300 units.

reactionTypeIDs are 33363,33364,33365,33366

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

Import CCP's SDE - EVE SDE Database Builder
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#40 - 2014-07-07 01:21:01 UTC
Zifrian wrote:
Found another data error.

In the invTypeReactions table, the output (input = 0) for all Metamaterials Reactions is 1 but the reaction in game provides 300 units.

reactionTypeIDs are 33363,33364,33365,33366



Reactions have always been a bit funky.

https://github.com/fuzzysteve/reactions/blob/master/reactionmodifier.sql


There's a reason I put together a table to handle the input/output multipliers.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Previous page123Next page