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.
 

Rubicon SDE is out.

First post
Author
Previous Topic Next Topic
Ydnari
Estrale Frontiers
#101 - 2014-03-10 22:37:37 UTC
Steve Ronuken wrote:
That's rubicon 1.3 converted. Data looks to be better.

https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.3-95173.tbz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/postgres-rubicon-1.3-95173.sql.bz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/rubicon13.sqlite.bz2

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/


Any chance you could make mapDenormalize.itemName a VARCHAR column again? Can't add an index on it when it's LONGTEXT (without faffing around making it a prefix index or something).

Thanks as always for the conversions into a usable format Cool

--
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#102 - 2014-03-10 22:47:15 UTC
Ydnari wrote:
Steve Ronuken wrote:
That's rubicon 1.3 converted. Data looks to be better.

https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.3-95173.tbz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/postgres-rubicon-1.3-95173.sql.bz2
https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/rubicon13.sqlite.bz2

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/


Any chance you could make mapDenormalize.itemName a VARCHAR column again? Can't add an index on it when it's LONGTEXT (without faffing around making it a prefix index or something).

Thanks as always for the conversions into a usable format Cool



alter table mapDenormalize change itemName itemName varchar(80);

Big smile

Took 21 seconds.

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/mapDenormalize-varcharname.sql.bz2

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ydnari
Estrale Frontiers
#103 - 2014-03-10 23:03:23 UTC
Yep I changed it locally already, was wondering if you would change it as part of the conversion process for future dumps? Ta. (Otherwise I'll just bung it into my post-processing scripts).

--
Juderet Belmar
The Scope
Gallente Federation
#104 - 2014-03-10 23:05:08 UTC
Steve Ronuken wrote:
Juderet Belmar wrote:

While coding a tool for EVE I noticed a bug in the table invtraits mysql56-rubicon-1.2-94438.sql found in mysql-latest.tar.bz2: The bonus attribute is an INT but it should be a DOUBLE since some trait boni have float values like the scan strength bonus of the Astero.



Ahh, I'll update it for next time. Smile


Ah, you lied Shocked ... I am sure you will fix it next time Cool

Something else:
Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#105 - 2014-03-10 23:30:45 UTC  |  Edited by: Steve Ronuken
Juderet Belmar wrote:
Steve Ronuken wrote:
Juderet Belmar wrote:

While coding a tool for EVE I noticed a bug in the table invtraits mysql56-rubicon-1.2-94438.sql found in mysql-latest.tar.bz2: The bonus attribute is an INT but it should be a DOUBLE since some trait boni have float values like the scan strength bonus of the Astero.



Ahh, I'll update it for next time. Smile


Ah, you lied Shocked ... I am sure you will fix it next time Cool

Something else:
Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes?



oop Sad

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/invTraits.sql.bz2

I've updated the loader.



I suspect the missing attributes are because they manually pick the ones which get exported.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Juderet Belmar
The Scope
Gallente Federation
#106 - 2014-03-10 23:51:41 UTC
Steve Ronuken wrote:
Juderet Belmar wrote:
Steve Ronuken wrote:
Juderet Belmar wrote:

While coding a tool for EVE I noticed a bug in the table invtraits mysql56-rubicon-1.2-94438.sql found in mysql-latest.tar.bz2: The bonus attribute is an INT but it should be a DOUBLE since some trait boni have float values like the scan strength bonus of the Astero.



Ahh, I'll update it for next time. Smile


Ah, you lied Shocked ... I am sure you will fix it next time Cool

Something else:
Further above in the thread someone asked about the missing attributes for the new deployables like the Mobile Depot. Is this a bug or intended, also where to get the data if not from dgmattributetypes?



oop Sad

https://www.fuzzwork.co.uk/dump/rubicon-1.3-95173/invTraits.sql.bz2

I've updated the loader.



I suspect the missing attributes are because they manually pick the ones which get exported.


Great, that was fast and the traits now show up correctly ... maybe I should vote for you Smile

Just my thoughts on the quality of the dump db:
The more I work on my tool with the dump db the more I must sigh about all the inconsistencies and complicated / unintuitive designs, tons of unused data can be found next to incomplete data and so on... but better a bad data dump than none
Desmont McCallock
#107 - 2014-03-13 19:28:07 UTC  |  Edited by: Desmont McCallock
tl;dr Pilot's License Extensions (PLEX) market group is missing from SDE.


Reporting inconsistency in data for SDE Rubicon 1.3.
Plex item (ID: 29668) is set with marketGroupID: 1923 but there is no such ID in invMarketGroups.

Summoning CCP Creber Cattus or CCP Prism X...
Meat Ongrard
Sebiestor Tribe
Minmatar Republic
#108 - 2014-03-14 22:35:50 UTC
Steve Ronuken wrote:
https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/
https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2 (look ma! It's a symlink I'll try to keep pointing at the latest version!)
https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.0-93082.tar.bz2
https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/postgres-rubicon-1.0-93082.sql.bz2 (floats converted to numerics)


Next time, lets just start the thread with this post
Desmont McCallock
#109 - 2014-03-15 10:09:03 UTC
For your own sanity just run this query and your SDE will be whole again.

insert invMarketGroups values (1923,Null,'Pilot''s License Extensions (PLEX)', 'Special ISK-priced capsuleering licenses offered as an alternative to regular piloting contracts.', Null, 1)
Desmont McCallock
#110 - 2014-05-17 14:18:01 UTC
Beware Rubicon 1.4 SDE is still missing the marketGroup entry for the PLEX.
Ydnari
Estrale Frontiers
#111 - 2014-05-30 13:35:35 UTC