open All Channels
seplocked EVE Technology Lab
blankseplocked Apocrypha 1.5 Static Data Dump - Oh wow, already?
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

CCP Zirnitra

Posted - 2009.08.18 12:46:00 - [1]
 

Edited by: CCP Zirnitra on 18/08/2009 16:22:58
Edited by: CCP Zirnitra on 18/08/2009 12:57:30
So, lets try something new guys. How about giving you the StaticDataDump BEFORE we patch Tranquility, what say you about that?

Thought so, so here goes. You can now download the Apocrypha 1.5 SDD even before we have updated Tranquility. So this time around you will have more time getting your applications updated, so you are ready when the new stuff hits the live server.

But thats not all, this time we have also included more shiney things for you to play with. We have now added translation data to the SDD as well. This means that we have added a couple of new tables, trnTranslationColumns and trnTranslations. Below, our wonderful PrismX has written a quick guide on how to use these new tables.

Originally by: PrismX
TcID’s (translationColumnID) reference a single column in a single table. The relationship can be found in the table trnTranslationColumns f.e:

SELECT *
FROM trnTranslationColumns
WHERE tableName = 'dbo.invTypes'


Will return tcIDs 8 and 33 referencing the columns typeName and description respectively. The masterID of those records is of course “typeID” referring to the fact that this typeName and description is unique to a given typeID.

Now, to get to the translations for the description of a Harbinger we first need the masterID of the translation ( which is typeID 24696 for the Harbinger ) along with the languageID we’re interested in ( I’m interested in german so we use languageID = ‘DE’ for this one ) and the translationColumnID (tcID) which is 33.

SELECT text
FROM trnTranslations
WHERE tcID = 33 AND keyID = 24696 AND languageID = 'DE'


This will return to us the following textblurb:
Seit ihrem ersten Erscheinen auf dem Schlachtfeld behauptet die Harbinger ihren Status als schlagkräftige Waffe und Laser, der sich durch das Herz der Gottlosen brennt. Alles an ihr zeigt diesen beabsichtigten Schwerpunkt - von den Lichtern an ihrem Bug und den Tragflächen, die zu den Ungläubigen leuchten, bis hin zu der großen Anzahl an Waffentürmen in den High-Slots, die dazu dienen, diese zu vernichten. Sollten irgendwelche Heiden nach dem ersten Angriff der Harbinger noch leben, werden ihre Drohnen sich ihrer annehmen. Battlecruiser Skill: 10% Reduktion des Energiespeicherverbrauchs von Lasern je Skillstufe. 5% Bonus auf die Schadenswirkung von Lasern je Skillstufe. 99% Reduktion des CPU-Verbrauchs von Warfare Link-Modulen.

TL;DR
trnTranslations.tcID , trnTanslationColumn.tcID = Reference to a certain column.
trnTranslations.languageID = Reference to a specific langauge
trnTranslations.keyID = the master key VALUE of the record being translated.
trnTranslationColumns.masterID = the NAME of the master key for the record.
trnTranslationColumns.tableName AND trnTranslationColumns.columnName = Values to facilitate locating the proper tcIDs to reference into trnTranslations.

Sakari Orisi
BIG
Gentlemen's Agreement
Posted - 2009.08.18 13:21:00 - [2]
 

How lovely :) Keep that up for future patches too please :D

Entity
X-Factor Industries
Synthetic Existence
Posted - 2009.08.18 13:22:00 - [3]
 

Heh, given the unlikeliness of this, I wouldn't be surprised if the universe imploded tonight.

Laughing

Catari Taga
Centre Of Attention
Middle of Nowhere
Posted - 2009.08.18 14:38:00 - [4]
 

Originally by: Entity
Heh, given the unlikeliness of this, I wouldn't be surprised if the universe imploded tonight.

This.

Also many thanks, much appreciated!

Neroo Tal
Minmatar
Order of the Golden Dawn
Shades of Gray
Posted - 2009.08.18 17:00:00 - [5]
 

Are the NPC pirate data info in this one, or was it removed on a permanent basis?

Arous Drephius
Posted - 2009.08.18 18:20:00 - [6]
 

Win detected.

Bolavaz
Posted - 2009.08.18 21:04:00 - [7]
 

Thank you very much. Now that is service. Great work!

Jercy Fravowitz
School of Applied Knowledge
Posted - 2009.08.18 23:13:00 - [8]
 

BLEH. conversions.

done and uploaded are:

the ever popular mysql "one file for the whole pile" (YOU ARE PROBABLY LOOKING FOR THIS ONE): http://eve.no-ip.de/apo15/apo15-mysql5-v1.sql.bz2
the less popular mysql "one table per file": http://eve.no-ip.de/apo15/apo15-mysql5-sql-v1/

sqlite3 "whole": http://eve.no-ip.de/apo15/apo15-sqlite3-v1.db.bz2
sqlite3 "eve asset manager": http://eve.no-ip.de/apo15/apo15-sqlite3-eam-v1.db.bz2


postgres and xml and whatnot are not done yet, i will upload them tomorrow, anyone interested can check for the files here: http://eve.no-ip.de/apo15/


Jameroz
Echoes of Space
Posted - 2009.08.19 03:44:00 - [9]
 

Awesome stuff, thanks to zofu for the conversions Very Happy

autoland2
Posted - 2009.08.20 15:38:00 - [10]
 

Awesome work m8,
Could you do me a favour.
The individual tables could you do a archive file or them ?
Cheeky to ask I know, I need to upload them individually to the server due to script execution times just dont want to miss any.

Celebrain
1st Steps Academy
Fidelas Constans
Posted - 2009.08.20 16:15:00 - [11]
 

Thank you CCP! If you are able to keep this up it will make some people happy on an ongoing basis.

For the first time in history this allows third party developers to release their updates simultaneously with CCP's patch (or even slightly ahead, give people something else to play around with while the universe is offline during the patch). I know this kind of took some people off guard this time so not everyone was able to take advantage of it that way, but at least it's possible now, so now some can start to plan this way.

Cele

Vessper
Indicium Technologies
Hephaestus Forge Alliance
Posted - 2009.08.20 16:55:00 - [12]
 

Very nice job CCP. Hope this continues for future updates.

Regarding the data, is there any reason why the chrRaceSkills table has no rows? Isn't this data still applicable to the current Eve version?


Kane Tabor
Posted - 2009.08.21 03:03:00 - [13]
 

Edited by: Kane Tabor on 21/08/2009 03:03:20
I'm getting this error when I try to import:

The media family on device 'FULLPATHTO.BAK' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

Here's the output of "select @@version":
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6001: Service Pack 1)

The stuff I've found thus far online say to apply SQL 2000 SP1 (which obviously isn't the answer here), or that the backup is corrupted (which I'm doubting -- other people got it working no problem it seems). I have two other Apocrypha data dumps running on this instance of SQL Server, so I think I'm on the right version. I'll be trying installing SQL Express 2008 on this machine next and we'll see if that helps. Any other ideas?

Just to rule out corruption, I'm seeing the following MD5 sums:
BAK file itself: 218699a36f9181478ced33460aac6ced
ZIP file: 543c965e7f4abf264d6687dfe66dcf06

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.08.21 04:13:00 - [14]
 

Think they changed to 2008 for this one just like they have plans to move the servers to it also soon if they didn't with this patch

Kane Tabor
Posted - 2009.08.21 05:07:00 - [15]
 

Originally by: Dragonaire
Think they changed to 2008 for this one just like they have plans to move the servers to it also soon if they didn't with this patch

Yep that did it. If only it didn't take *so* long to get it up and going. I had to install Windows Installer 4.5 (which took 3 reboots to coax into installing), then Powershell (because apparently my 2005 install was 'Advanced', and the 2008 version of that needs Powershell), and then fight with the installer for a bit over upgrading my existing installation before just going with a new one (I think I had 2005 x32 installed and had an x64 installer for 2008).

Anyway, yes, I got it working with 2008 with the files with the MD5s I posted before in case anyone else is running into similar problems.

Migol
Caldari
Hanza Mineral and Trade
Posted - 2009.08.22 09:40:00 - [16]
 

Why didn't you include Foreing Key relationships or any other constraints in the database dump?

Kane Tabor
Posted - 2009.08.22 10:01:00 - [17]
 

Originally by: Migol
Why didn't you include Foreing Key relationships or any other constraints in the database dump?

Check the comments at the end of ebs_DATADUMP.sql -- the SQL to create the FKs are there.

Bolavaz
Posted - 2009.08.26 23:51:00 - [18]
 

Could we also get an update on the icons. We are currently missing icons for the small/medium rigs, and off course the graphic for plex.

Thanks in advance.

Rilwar
BlackStar Industrial
Posted - 2009.08.30 23:34:00 - [19]
 

Originally by: Bolavaz
Could we also get an update on the icons. We are currently missing icons for the small/medium rigs, and off course the graphic for plex.

Thanks in advance.



lmao.

They're not going to be out for another 4 months, that's the rationalization they used to give us the dump this quickly.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2009.09.02 09:42:00 - [20]
 

Late but hopefully not too late ...

Let me also thank you for making the DB dump available so early. Very Happy

xz01d
Posted - 2009.09.03 18:25:00 - [21]
 

Thnx for dump!
But i've got a question. How can I calculate (get) repackaged volume? Or where I can see the descritions of some tables, of this dump?

PS: http://wiki.eve-id.net/ don't got this information. :(

Vessper
Indicium Technologies
Hephaestus Forge Alliance
Posted - 2009.09.03 22:01:00 - [22]
 

Originally by: xz01d
Thnx for dump!
But i've got a question. How can I calculate (get) repackaged volume? Or where I can see the descritions of some tables, of this dump?

PS: http://wiki.eve-id.net/ don't got this information. :(

The information isn't in the data dump but this thread contains the details you need.


Karl Mort
Posted - 2009.09.22 00:17:00 - [23]
 

Please forgive the noob question, but are BP's info no longer on SQL dumps?

xz01d
Posted - 2009.09.23 01:01:00 - [24]
 

And one more quastion.. Last, I hope. :)
Is there is info, in dump, about reprocessing of items? Where i can find description of them? Or any link about this....

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.23 04:19:00 - [25]
 

Try a search there has only been 4 threads on that this month alone I'm sure you can find one of them if not try this link to a thread that gives you several more links to the information you'll need.
http://www.eve-search.com/thread/865233/page/1

Emma Royd
Caldari
Maddled Gommerils
Posted - 2009.10.11 17:34:00 - [26]
 

Forgive the noobiness but....

Just what can I do with the dump, I've tried getting them into Access 2007 to see what it contains but don't know how, installed Microsoft SQL Server 2008 but tbh the help on that might as well be written in Swahili for the understanding I get from it.

I fancy having a look at agent data etc, but I'm totally lost as to how to do it.

Thanks

xz01d
Posted - 2009.10.14 00:21:00 - [27]
 

Threads? =\ I've got MySQL base... I need JUST formuls as http://wiki.eve-id.net/Equations , i'll make query by myself. eve-id hasn't reprocess formuls.. Sad .. =\

And one more.. Is reprocess of alloys is static table? If not where i can find calc formul.

Sidrat Flush
Caldari
Eve Industrial Corp
Posted - 2009.11.15 17:26:00 - [28]
 

Edited by: Sidrat Flush on 15/11/2009 20:04:27
Now having 'upgraded' to SQL server express 2008 I can't find where the server management studio is located and thus can't restore the SDD?

Anyone help?

Found it, you have to start it up with no database created or selected, then right click on the database and select tools - repair.

Or something like that I'll write up something better later, I've taken about two hundred steps too far forward so I'm going back to the visual web developer 2008 tutorials.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only