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.
 

Retribution 1.0 SDE - Mysql Conversion
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2012-12-04 15:42:58 UTC
Hosted at eve files, as my own server has decided that it needed a rest and fell off the internet.

http://dl.eve-files.com/media/1212/mysql-retribution-1.0-82596.dmp.zip


For now, that's it. I'll get the other versions done when the people at my hosting service kick my lazy server back to life.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Thebriwan
LUX Uls Xystus
#2 - 2012-12-04 16:59:36 UTC
Thank you very much!
Somerset Mahm
Cognitive Distortion
#3 - 2012-12-04 19:39:19 UTC
Thanks much.

Here's a one-liner for those that only want a table or two:

Quote:
sed -n "/^-- Table structure for table \`invTypes\`/,/^-- Table structure for table/p" mysql-retribution-1.0-82596.dmp > invTypes-retribution.sql

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)
Kid Delicious
Caldari Provisions
Caldari State
#4 - 2012-12-04 20:56:21 UTC  |  Edited by: Kid Delicious
Thanks, I always appreciate your hard work.

Perhaps this is just me but there are problems with the market tree. Certain groups are repeated, Salvage Drones, Micro Jump Drives and the Fleet Assistance Modules market group is missing. (Can anyone else confirm this one way or the other?)

I'd verify where the problem is but I'm not sure where you got the source from, since I don't see the dump on the fansite kit section or a thread for it. (Edit - Oops I see it, going to check the official dump.)
Louis Vitton
Viziam
Amarr Empire
#5 - 2012-12-04 21:36:32 UTC
Cheers mate :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-12-04 21:53:21 UTC
Kid Delicious wrote:
Thanks, I always appreciate your hard work.

Perhaps this is just me but there are problems with the market tree. Certain groups are repeated, Salvage Drones, Micro Jump Drives and the Fleet Assistance Modules market group is missing. (Can anyone else confirm this one way or the other?)

I'd verify where the problem is but I'm not sure where you got the source from, since I don't see the dump on the fansite kit section or a thread for it. (Edit - Oops I see it, going to check the official dump.)



Apparently there's stuff missing from the export. It's been mentioned on PrismX's twitter feed.

I've done nothing to sort it. When there's a new release, I'll update.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kid Delicious
Caldari Provisions
Caldari State
#7 - 2012-12-04 22:00:18 UTC
Alright, thanks again. I'll go hunt down PrismX's feed.
Zifrian
The Frog Pond
Ribbit.
#8 - 2012-12-04 22:00:58 UTC
All I've found so far is these two typeId's in the invTypes table that don't have typeNames or any other data - 32894,351611. First one seems to be some sort of celestial (from the icon), not sure on the other.

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

Import CCP's SDE - EVE SDE Database Builder
Khorkrak
KarmaFleet
Goonswarm Federation
#9 - 2012-12-05 02:22:46 UTC  |  Edited by: Khorkrak
referential integrity or the lack thereof:


select distinct marketGroupID from invTypes t where not exists(select 1 from invMarketGroups where marketGroupID = t.marketGroupID) and marketGroupID is not null;
+---------------+
| marketGroupID |
+---------------+
| 363369 |
| 363370 |
| 363371 |
+---------------+

So these market group ids are referenced in the invTypes table but do not exist in the invMarketGroups table. Looks like Dust related stuff.

and then there's this:
select * from invMarketGroups where parentGroupID = 1610;
+---------------+---------------+------------------------------+-------------------------------+--------+----------+
| marketGroupID | parentGroupID | marketGroupName | description | iconID | hasTypes |
+---------------+---------------+------------------------------+-------------------------------+--------+----------+
| 1122 | 1610 | Amarr Engineering Subsystems | Amarr engineering subsystems. | 3636 | 1 |
| 1126 | 1610 | Amarr Defensive Subsystems | Amarr defensive subsystems. | 3631 | 1 |
| 1130 | 1610 | Amarr Offensive Subsystems | Amarr offensive subsystems. | 3641 | 1 |
| 1134 | 1610 | Amarr Propulsion Subsystems | Amarr propulsion subsystems. | 3646 | 1 |
| 1611 | 1610 | Amarr Electronic Subsystems | Amarr Electronic Subsystems | 3626 | 1 |
+---------------+---------------+------------------------------+-------------------------------+--------+----------+

select * from invMarketGroups where marketGroupID = 1610;
Empty set

Same goes for 1625, 1626, 1627 and 1633.

Developer of http://www.decloaked.com and http://sourceforge.net/projects/pykb/
Artem Valiant
NecroRise Squadron
Galaxy Spiritus
#10 - 2012-12-05 06:29:18 UTC
Can somebody make sqlite conversion?
Thank you.
M Kernel
Cayman Applied Kinetics
#11 - 2012-12-05 10:11:52 UTC  |  Edited by: M Kernel
Stupid question, but where did you get the dump for Retribution? The newest one I can find is the one for Inferno...

After having a coffe, I found it!

Oh, and before I forget: Thank you for your work!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2012-12-05 11:58:35 UTC
I'll redo the conversion, with the next release.

In the mean time:
http://www.fuzzwork.co.uk/dump/mysql-retribution-1.0-82596.dmp.bz2 - The same as above
http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/ - Individual table exports, sql as well as xls/csv
http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/eve.sqlite.bz2 - sqlite database (just the database, bziped up. not an export)

If you need to unzip any of them on windows, 7zip will handle them.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Artem Valiant
NecroRise Squadron
Galaxy Spiritus
#13 - 2012-12-05 12:31:32 UTC
Steve Ronuken wrote:
I'll redo the conversion, with the next release.

In the mean time:
http://www.fuzzwork.co.uk/dump/mysql-retribution-1.0-82596.dmp.bz2 - The same as above
http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/ - Individual table exports, sql as well as xls/csv
http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/eve.sqlite.bz2 - sqlite database (just the database, bziped up. not an export)

If you need to unzip any of them on windows, 7zip will handle them.


Thanks, mate.
Buuuh Erquilenne
The Scope
Gallente Federation
#14 - 2012-12-08 01:22:15 UTC
Steve Ronuken wrote:

http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/eve.sqlite.bz2 - sqlite database (just the database, bziped up. not an export)


Seems not to be up to date.
Querying Vexor BPO material requirements still return the pre-retribution values and doesn't match what the ingame details show for the BPO (~300k Trit instead of ~500k Trit).
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#15 - 2012-12-08 03:10:55 UTC
Buuuh Erquilenne wrote:
Steve Ronuken wrote:

http://www.fuzzwork.co.uk/dump/retribution-1.0-82596/eve.sqlite.bz2 - sqlite database (just the database, bziped up. not an export)


Seems not to be up to date.
Querying Vexor BPO material requirements still return the pre-retribution values and doesn't match what the ingame details show for the BPO (~300k Trit instead of ~500k Trit).


Check ramTypeRequirements.

They'll be extra materials.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Letocaries
Lonestar Distribution Inc.
#16 - 2012-12-12 12:37:32 UTC  |  Edited by: Letocaries
Don't suppose you have any idea where the invTypes.iconID has gone?

I can't find it :<

Also, any idea how to get 'variations' of an object (i.e. all small autocannons) I was thinking the group but that would contain all size autocannons if I recall correctly
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#17 - 2012-12-12 15:26:07 UTC
Letocaries wrote:
Don't suppose you have any idea where the invTypes.iconID has gone?

I can't find it :<

Also, any idea how to get 'variations' of an object (i.e. all small autocannons) I was thinking the group but that would contain all size autocannons if I recall correctly



It's in one of the yaml files that comes along with the datadump from CCP. I've not touched them at all.


As for the variations, I'd suggest the market group for them. If you were wanting 'all the 125mm ACs' then you'd use the invMetaTypes table, using the meta 0 one as the parenttypeid. If you want all the small autocannon, then you want to use the marketgroupid, in invTypes. for small autocannon, that'd be 574

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Letocaries
Lonestar Distribution Inc.
#18 - 2012-12-13 00:24:17 UTC
Steve Ronuken wrote:
Letocaries wrote:
Don't suppose you have any idea where the invTypes.iconID has gone?

I can't find it :<

Also, any idea how to get 'variations' of an object (i.e. all small autocannons) I was thinking the group but that would contain all size autocannons if I recall correctly



It's in one of the yaml files that comes along with the datadump from CCP. I've not touched them at all.


As for the variations, I'd suggest the market group for them. If you were wanting 'all the 125mm ACs' then you'd use the invMetaTypes table, using the meta 0 one as the parenttypeid. If you want all the small autocannon, then you want to use the marketgroupid, in invTypes. for small autocannon, that'd be 574



Thank you :) not looking forward to using yaml if I'm honest :<

I actually think what I was looking for was the invMetaTypes as you said, lots of items aren't in market groups.