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.
 

Escalation 1.0 SDE conversion

Author
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2012-04-25 08:33:20 UTC  |  Edited by: Steve Ronuken
http://www.fuzzwork.co.uk/dump/

A few changes in how I'm presenting it.

http://www.fuzzwork.co.uk/dump/mysql55-esc10.tar.bz2
This is a tar bz2 file (7zip will open it without trouble), which contains 2 files.

mysql55-esc10-structure.sql
Which is all the table creation syntax. You can edit the structure, before you use it, which was hard to do before, due to the file size.

mysql55-esc10-data.sql
Which is all the insert statements. These are single complete inserts, rather than the multi-insert option that was used in earlier exports. It'll take a little longer to import, but it's a little more stable, if you're using the web for importing.


All the other files are as before.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Null Byte
Perkone
Caldari State
#2 - 2012-04-25 22:09:52 UTC
Thanks for the conversion.

This is the first time I have worked with the eve database and the schema is quite straight forward. While it is very useful for creating many tools and getting rid of spreadsheets :) I was a bit sad to find that there seems to be no NPC data - ship attributes, resistances, HP etc.

In my research I believe that this was removed from Apocrypha onwards. Is this right? If so, is there any resource for archived data?

I would love to even get my hands on some older dgm attributes and effects tables for the NPCs. Would be more useful than nothing.

Thanks again for your time converting,

Null
6ie
The Kiwis
#3 - 2012-04-26 11:52:56 UTC
Thanks, data loaded perfectly.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-04-26 11:54:18 UTC
Null Byte wrote:
In my research I believe that this was removed from Apocrypha onwards. Is this right? If so, is there any resource for archived data?


No idea, I'm afraid.

/Might/ be in the cache data, which you can read with something like Reverance

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Vessper
Dark Mason Society
#5 - 2012-04-26 12:20:11 UTC  |  Edited by: Vessper
Null Byte wrote:
...I was a bit sad to find that there seems to be no NPC data - ship attributes, resistances, HP etc.

In my research I believe that this was removed from Apocrypha onwards. Is this right? If so, is there any resource for archived data?

I would love to even get my hands on some older dgm attributes and effects tables for the NPCs. Would be more useful than nothing.
NPC data was removed when Sleepers were introduced so you'd be going back to Quantum Rise in November 2008. If you check the thread at http://community.eveonline.com/ingameboard.asp?a=topic&threadID=920918, it may have a copy of the export in one of the links there.

Edit: Just in case it's useful, the original export can be found at http://content.eveonline.com/data/QuantumRise_1.0.0.69477_db.zip
Null Byte
Perkone
Caldari State
#6 - 2012-04-26 13:25:27 UTC
Vessper wrote:
Null Byte wrote:
...I was a bit sad to find that there seems to be no NPC data - ship attributes, resistances, HP etc.

In my research I believe that this was removed from Apocrypha onwards. Is this right? If so, is there any resource for archived data?

I would love to even get my hands on some older dgm attributes and effects tables for the NPCs. Would be more useful than nothing.
NPC data was removed when Sleepers were introduced so you'd be going back to Quantum Rise in November 2008. If you check the thread at http://community.eveonline.com/ingameboard.asp?a=topic&threadID=920918, it may have a copy of the export in one of the links there.

Edit: Just in case it's useful, the original export can be found at http://content.eveonline.com/data/QuantumRise_1.0.0.69477_db.zip


Thanks! Have downloaded the MySQL version and will import the attributes and effects shortly to test it out.
Dragonaire
Here there be Dragons
#7 - 2012-04-26 14:27:48 UTC
One of the reason CCP dropped the data from the dump was they were in the process of making some changes to the data and didn't want anyone to see it while they continued to tweak stuff so you may find that the old data isn't very useful as most of the stats and names have changed and as also pointed out a lot of newer NPCs have been added that wasn't in the older data sets.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.