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.
12Next page
 

SDE for Odyssey 1.0 + conversions by yours truly

First post
Author
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2013-06-03 13:37:27 UTC  |  Edited by: Steve Ronuken
If you've not seen it, the new SDE is out.
http://community.eveonline.com/community/fansites/toolkit/


Mysql single file conversion (includes the yaml):
http://www.fuzzwork.co.uk/dump/mysql55-odyssey-1.0-89097.tbz2


the SQL and XLS/CSV exports (+ the yaml):
http://www.fuzzwork.co.uk/dump/odyssey-1.0-89097/



The sqlite version (just the DB. unzip and use):
http://www.fuzzwork.co.uk/dump/odyssey-1.0-89097/odyssey10.sqlite.bz2

Postgres version (no guarantees with this. I don't use it. And all the column names will be quoted)
http://www.fuzzwork.co.uk/dump/odyssey-1.0-89097/postgres-odyssey-1.0-89097.sql.bz2

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

CCP Seagull
C C P
C C P Alliance
#2 - 2013-06-03 17:51:07 UTC
Great stuff! We will try to be even earlier with releasing the SDE in the future.

/CCP Seagull

Senior Producer, EVE Online Development CCP Games Reykjavik

Cyerus
University of Caille
Gallente Federation
#3 - 2013-06-03 18:15:22 UTC
Thanks Fuzzy, Seagull! Big smile
Yuki Kasumi
Some names are just stupid
#4 - 2013-06-03 18:48:42 UTC
Thank you!

Now if only evemon had the new skill trees I could get to work on my plans... :P
Desmont McCallock
#5 - 2013-06-03 20:23:37 UTC
EVEMon will be updated tomorrow, so to not confuse new players with the new skills.
Zifrian
The Frog Pond
Ribbit.
#6 - 2013-06-03 20:29:40 UTC
CCP Seagull wrote:
Great stuff! We will try to be even earlier with releasing the SDE in the future.

/CCP Seagull

Thanks much for this.

Quick question, when will the icons get updated? I use the BP icons and a few others and they seem shinier and new in the patch so would like to get them at some point. No biggy but eventually.

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

Import CCP's SDE - EVE SDE Database Builder

Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#7 - 2013-06-03 20:37:12 UTC
I may be bad, but I don't see the new navy BCs in this SDE
Rob Crowley
State War Academy
#8 - 2013-06-03 20:57:56 UTC
Sable Blitzmann wrote:
I may be bad, but I don't see the new navy BCs in this SDE

They're in there, typeIDs 33151, 33153, 33155, 33157.
Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#9 - 2013-06-03 21:10:23 UTC
Rob Crowley wrote:
Sable Blitzmann wrote:
I may be bad, but I don't see the new navy BCs in this SDE

They're in there, typeIDs 33151, 33153, 33155, 33157.


Confirmed, I am bad...

I don't know what the **** I was doing, but I was searching invTypes for %Hurricane% and it wasn't showing up at all. =(
Hoarr
Caldari Provisions
Caldari State
#10 - 2013-06-03 21:41:37 UTC  |  Edited by: Hoarr
Thanks for doing this so quickly, Steve.



Is anyone else reading anything into the fact that all of the DUST equipment is now in the typeid database?

EDIT:

is it just me or were the new metamaterials (racial mats) left out of the invTypeMaterials table?
Ydnari
Estrale Frontiers
#11 - 2013-06-03 23:35:04 UTC
Hoarr wrote:
Thanks for doing this so quickly, Steve.



Is anyone else reading anything into the fact that all of the DUST equipment is now in the typeid database?

EDIT:

is it just me or were the new metamaterials (racial mats) left out of the invTypeMaterials table?


I'd assume they're all "extra" materials so that you can't magic a ton of racial materials out of reprocessing existing T2 components, so won't they only be in ramTypeRequirements? (not finished loading on my database yet)

--

KL1
The Dirty Alpaca Fur Traders
The Last Alpaca
#12 - 2013-06-03 23:38:13 UTC
they are "extra" and are in the ramTypeRequirements table
Hoarr
Caldari Provisions
Caldari State
#13 - 2013-06-03 23:44:36 UTC
hurrdurr hurrdurr. Thanks for that. This is the first time I've been trying to use the database dump, so I dun goofed.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#14 - 2013-06-04 00:00:06 UTC
Hoarr wrote:
hurrdurr hurrdurr. Thanks for that. This is the first time I've been trying to use the database dump, so I dun goofed.



http://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/ might be of interest then Smile


(yes, I'm writing those things, purely so I can refer people to them in this kind of situation. If I get asked questions, I tend to write new ones after answering)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Hoarr
Caldari Provisions
Caldari State
#15 - 2013-06-04 00:13:30 UTC
Thanks you
Kaladr
Viziam
Amarr Empire
#16 - 2013-06-04 16:20:35 UTC  |  Edited by: Kaladr
To ease the load on the origin, these are being mirrored to:

https://eve-central.com/dumps/static_data_export/odyssey-1.0/

Creator of EVE-Central.com, the longest running EVE Market Aggregator

Talos Katuma
Helion Production Labs
Independent Operators Consortium
#17 - 2013-06-04 16:47:41 UTC
Thanks a lot
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#18 - 2013-06-04 19:39:01 UTC
Kaladr wrote:
To ease the load on the origin, these are being mirrored to:

https://eve-central.com/dumps/static_data_export/odyssey-1.0/



I'm not suffering any bandwidth issues, but this would be handy for people closer to the eve-central server Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Preck
Brutor Tribe
Minmatar Republic
#19 - 2013-06-04 19:56:25 UTC
Thank you, Steve

http://eve-universe.eu

Desmont McCallock
#20 - 2013-06-04 21:27:30 UTC
I'll post here also about it.

'Published' flag for "Battlecruisers" and "Destroyers" skills have not been switched. Yet another disappointment.
12Next page