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.
 

Hyperion 1.0 SDE is out.

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#21 - 2014-07-26 16:44:27 UTC
Desmont McCallock wrote:
Well I guess that I have to include them in the invBlueprints table, although technically they aren't blueprints and I will have to introduce another column called reverseEngeneeringTime as they have a time factor for that activity.

No one said that this would be easy, importing the yaml files back to a DB, that is.



It's why I broke the data out into six completely new tables. Sure, it's not backwards compatible, but there's so much changed anyway, that it's not really worth it.

I was /tempted/ to break out a seventh, for dealing with consume on materials; so non-invention activities didn't have redundant data, but figured that in the end, it wasn't important.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Lukas Rox
Aideron Technologies
#22 - 2014-07-27 12:16:30 UTC
Steve Ronuken wrote:
Desmont McCallock wrote:
Well I guess that I have to include them in the invBlueprints table, although technically they aren't blueprints and I will have to introduce another column called reverseEngeneeringTime as they have a time factor for that activity.

No one said that this would be easy, importing the yaml files back to a DB, that is.



It's why I broke the data out into six completely new tables. Sure, it's not backwards compatible, but there's so much changed anyway, that it's not really worth it.

I was /tempted/ to break out a seventh, for dealing with consume on materials; so non-invention activities didn't have redundant data, but figured that in the end, it wasn't important.


I actually did the backward copatibility conversion, because it was easier to do that than to rewrite whole LMeve grounds up.

Function recreateLegacyTables does it (based on YAML data imported beforehand)

https://github.com/roxlukas/lmeve/blob/master/include/yaml_blueprints.php

Proud developer of LMeve: Industry Contribution and Mass Production Tracker: https://github.com/roxlukas/lmeve | Blogging about EVE on http://pozniak.pl/wp/
Desmont McCallock
#23 - 2014-07-27 15:25:47 UTC  |  Edited by: Desmont McCallock
Beta release of the EVEMonSDEExternalsToSql tool for Crius. You will find it here.

Edit: Tool has moved to RC stage.
Legedric Striker
State War Academy
Caldari State
#24 - 2014-07-28 16:11:11 UTC
Quick question: Where do I find information about the requred skill levels?
I know there are attributes for requiredSkill1, requiredSkill2 etc. but I don't see the information about what level of this skill is being required for example to learn a speciel skill. I thought this would just be another attribute like "requiredSkillLevel1" etc. but it isn't...

EVE-Skillplan.net - Plan your pilot skill training online on PC, Mac, tablet or smartphone!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#25 - 2014-07-28 17:15:21 UTC
Legedric Striker wrote:
Quick question: Where do I find information about the requred skill levels?
I know there are attributes for requiredSkill1, requiredSkill2 etc. but I don't see the information about what level of this skill is being required for example to learn a speciel skill. I thought this would just be another attribute like "requiredSkillLevel1" etc. but it isn't...



you mean like: requiredSkill1Level which is attribute 277 ?

select dta.attributeID,coalesce(valueInt,valueFloat),attributeName from dgmTypeAttributes dta join dgmAttributeTypes dat on (dta.attributeid=dat.attributeid) where typeid=1319;
+-------------+-------------------------------+-------------------------+
| attributeID | coalesce(valueInt,valueFloat) | attributeName |
+-------------+-------------------------------+-------------------------+
| 9 | 40 | hp |
| 149 | 1.275 | cargoCapacityMultiplier |
| 150 | 0.8 | structureHPMultiplier |
| 182 | 3394 | requiredSkill1 |
| 277 | 2 | requiredSkill1Level |
| 306 | 0.9 | maxVelocityBonus |
| 422 | 2 | techLevel |
| 633 | 5 | metaLevel |
+-------------+-------------------------------+-------------------------+

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Legedric Striker
State War Academy
Caldari State
#26 - 2014-07-28 18:31:13 UTC
Ah thanks... I know what caused my "blindness"...
I thought only "published" data records are valid or important but apperantly this attribute has published = 0 and so I didn't see it as I thought I could ignore the unpublished data.

Thanks for pointing me to the right direction, again Blink

EVE-Skillplan.net - Plan your pilot skill training online on PC, Mac, tablet or smartphone!
Acid Kanshi
AIFAM
#27 - 2014-07-31 13:09:03 UTC
Any CCP person can check this out?

Scourge Fury Heavy Missile manufacturing

http://i.imgur.com/HsNnJNZ.png

But in SDE there are materials Tritanium, Zydrine etc. Outdated materials.

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
Ydnari
Estrale Frontiers
#28 - 2014-07-31 18:07:45 UTC  |  Edited by: Ydnari
Patch notes today say:

Quote:
Fixed Tech II blueprints that still contained Tech I components for maufacturing.
Fixed Tech III blueprint requirements.
Numerous other adjustments to blueprint build requirements and times.


Is there an updated SDE to match?

edit: tomorrow https://forums.eveonline.com/default.aspx?g=posts&t=362217&find=unread

--
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#29 - 2014-08-01 16:32:10 UTC  |  Edited by: Steve Ronuken
Ydnari
Estrale Frontiers
#30 - 2014-08-01 17:14:01 UTC
404 not found for mysql link, you've missed the 2 off the end of the tbz2 extension

--
Airi Cho
Dark-Rising
Wrecking Machine.
#31 - 2014-08-01 21:33:06 UTC
Steve Ronuken wrote:

Postgres
https://www.fuzzwork.co.uk/dump/crius-16-100370/postgres-crius-1.6-100370.dmp.bz2

Postgres dump is now done in postgres format, for restoration with pg_restore. excludes privileges.


actually i can only find https://www.fuzzwork.co.uk/dump/crius-1.6-100370/postgres-crius-1.6-1000370.sql.bz2

which is actually a pg_dump format :)


remember to use pg_restore --no-owner when restoring.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#32 - 2014-08-01 22:27:47 UTC
oops.

URLs updated.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#33 - 2014-08-02 21:28:12 UTC
Acid Kanshi wrote:
Any CCP person can check this out?

Scourge Fury Heavy Missile manufacturing

http://i.imgur.com/HsNnJNZ.png

But in SDE there are materials Tritanium, Zydrine etc. Outdated materials.
Has been fixed in Crius 1.6 SDE. Looks like it's time to work on updating EVEMon's data.
Desmont McCallock
#34 - 2014-08-03 09:36:58 UTC  |  Edited by: Desmont McCallock
Just a heads up, MarketGroupID: 1912 (* Outpost Platform Blueprint) and MarketGroupID: 1913 (Station * Blueprint) are missing from the invMarketGroups table.

Edit 1: Further more this seems to be totally wrong as those items as showing up ingame under the same market group thus they should have the same marketGroupID.

Edit 2: For your own sanity here is a fix for the above issue. It introduces a new market group id (1911) and assigns that to the items with the faulty market group ids. The ID :1911 is pretty safe to use as I didn't found it to be used anywhere else.
Quote:
insert into invMarketGroups values (1911, 800, 'Outpost Components', 'Blueprints of Outpost Components.', 2703, 1)
update invTypes set marketGroupID = 1911 where marketGroupID in (1912,1913)


Edit 3: I also came across two (2) entries in the blueprints.yaml file that correspond to two blueprints (IDs: 34119, 34121) but there are no entries for them in the invTypes table or for there products (IDs: 34118, 34120). Anyone can shed a ray of light on those?
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#35 - 2014-08-03 11:02:47 UTC
Can some one help me

in the database if i do this
-- Base materials
SELECT t.typeName, m.quantity
FROM invTypeMaterials AS m
INNER JOIN invTypes AS t
ON m.materialTypeID = t.typeID
WHERE m.typeID = 11400--jaguar

I'm asking because i was trying to build my sheet using the conversion that Steve made to xls and the materials are also there, so i went to the DB and checked

I get materials as tritanium and others
But if use Steve Ronuken site i dont see this materials
I'm i doing something wrong? because i think that now most of the T2 dont have any tritanium and other low minerals.

Regards
Tim
Desmont McCallock
#36 - 2014-08-03 11:17:59 UTC  |  Edited by: Desmont McCallock
Timcanpy Yvormes wrote:
Can some one help me

in the database if i do this
-- Base materials
SELECT t.typeName, m.quantity
FROM invTypeMaterials AS m
INNER JOIN invTypes AS t
ON m.materialTypeID = t.typeID
WHERE m.typeID = 11400--jaguar

I'm asking because i was trying to build my sheet using the conversion that Steve made to xls and the materials are also there, so i went to the DB and checked

I get materials as tritanium and others
But if use Steve Ronuken site i dont see this materials
I'm i doing something wrong? because i think that now most of the T2 dont have any tritanium and other low minerals.

Regards
Tim

If I'm not mistaken InvTypeMaterials table is now referring to what the item reprocess to. If you are looking for the manufacturing materials you need to look at Steve's industryActivityMaterials table. Further more if you are using MSSQL DB you can use my YAML/SqLite files importer for your sanity.
Laendra
University of Caille
Gallente Federation
#37 - 2014-08-09 04:43:37 UTC
So what genius decided that the activity data needed to be moved out into YAML files? And for what purpose? I mean seriously, a "human readable format"...have they even looked at it, it's not "human readable" at all. Let's look at what that data is used for...3rd party development, and what do they put the rest of the SDE out in, hmmm, a sql database....because that is what 3rd party developers use...databases

:end-rant
Aineko Macx
#38 - 2014-08-09 05:36:11 UTC  |  Edited by: Aineko Macx
Laendra wrote:
Let's look at what that data is used for...3rd party development, and what do they put the rest of the SDE out in, hmmm, a sql database....

It's not even SQL, but a dump in a closed, proprietary format of a closed, proprietary database.
It's beyond me why they don't release standard SQL, which would be easy through ODBC...

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Desmont McCallock
#39 - 2014-08-09 17:33:52 UTC
Guys, let's face it, the entire SDE will be moved to YAML files. It was announces (for CCP standards) ages ago.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#40 - 2014-08-09 19:35:00 UTC
Why is data being put out in yaml files?

Because that's how they're storing it in their versioning system. Because it allows them easy diffing, to see when something was changed, and how it changed. As someone who supports a development team, I can see that's a good reason.


As for why they put it out as a backup file, well, that's just easy for them. Anything else would be extra effort.

As for 'standard SQL', heh. heh heh heh. hehehehehehehehehehehehehehehe. *keels over* Sure, there are SQL standards. The vast majority of databases only kind of stick to them.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter