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.
 

Inferno 1.2 SDE conversion. Mysql. Excel/CSV.
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2012-08-08 13:50:56 UTC  |  Edited by: Steve Ronuken
Full mysql dump, with extended inserts. Camel case.
http://www.fuzzwork.co.uk/dump/mysql55-inferno12-extended.sql.bz2

Full mysql dump, without extended inserts. creates and inserts split. Camel case.
http://www.fuzzwork.co.uk/dump/mysql55-inferno12.tar.bz2


XLS or CSV dumps of individual tables (depending on size). MySQL dumps of individual tables.
http://www.fuzzwork.co.uk/dump/inferno12/

Sqlite dump (not an sqlite database. you'll need to restore it)
http://www.fuzzwork.co.uk/dump/inferno12/inferno12.sqlite.bz2

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Khorkrak
KarmaFleet
Goonswarm Federation
#2 - 2012-08-08 15:03:35 UTC
Thanks once again Steve! Truly appreciate your doing this so reliably and quickly. Does anyone know what the diffs are yet?

Developer of http://www.decloaked.com and http://sourceforge.net/projects/pykb/
Zeta Zhul
Preemptive Paranoia
#3 - 2012-08-08 16:36:54 UTC
Outstanding! Thanks man!
Desmont McCallock
#4 - 2012-08-08 17:04:40 UTC
So far I have found a few.

Unannounced : 'radius' column has been removed from InvTypes table.
Announced: Changes in Skill Hardwiring Implants (market group), added items (Rig for Ice & Merxocit mining).
There may be more but I haven't gone through the patch notes yet to see if everything is announced.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-08-08 17:32:19 UTC
Desmont McCallock wrote:
So far I have found a few.

Unannounced : 'radius' column has been removed from InvTypes table.
Announced: Changes in Skill Hardwiring Implants (market group), added items (Rig for Ice & Merxocit mining).
There may be more but I haven't gone through the patch notes yet to see if everything is announced.



Oh, and there are now three Yamled tables.

I believe radius is showing up in the typeid one.

I'm looking for a diff generator, but so far the only reasonable one I've run across has problems with my system.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Fraa Bjorn
Cell 317
#6 - 2012-08-08 20:40:10 UTC
cool. Just curious, did you base this off the eve cachefiles? I can't find the official MSSQL release, but maybe my google-fu is just bad ;(

All games have QQ, but only Eve has Q.Q
Fraa Bjorn
Cell 317
#7 - 2012-08-08 20:52:59 UTC
Fraa Bjorn wrote:
cool. Just curious, did you base this off the eve cachefiles? I can't find the official MSSQL release, but maybe my google-fu is just bad ;(


my bad..

The sticky on top only links to Crucible.. but it seems here is the real deal: http://community.eveonline.com/community/toolkit.asp

Thanks for providing a mysql version!

All games have QQ, but only Eve has Q.Q
Muscaat
EVE Markets
#8 - 2012-08-08 21:14:24 UTC
Awesome work as always, thanks! Smile
Acid Kanshi
AIFAM
#9 - 2012-08-08 22:28:44 UTC
Thank you my friend.

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
Thebriwan
LUX Uls Xystus
#10 - 2012-08-10 14:30:49 UTC
Your work is much appreciated - as always.