Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
|
CCP Zirnitra
|
Posted - 2009.08.18 12:46:00 -
[1]
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 schlagkrSftige 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 TragflSchen, die zu den UnglSubigen leuchten, bis hin zu der gro¯en Anzahl an Waffentnrmen 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
Dreams of Desolation Systematic-Chaos
|
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.
_
Got Item? | EVE API? |
Catari Taga
Centre Of Attention Rough Necks
|
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
|
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? --Neroo Tal Order of the Golden Dawn CEO : Founder |
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
|
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 Tread Alliance
|
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
SI Radio
|
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. New Eden Retail Federation
|
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 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
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
|
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. -------------------------------------------------
Mitnal was here. |
Hel O'Ween
Academy of Truth
|
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. -- EVEWalletAware - an offline wallet manager |
|
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
SI Radio
|
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.
- - - - - - EveHQ Character App |
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. New Eden Retail Federation
|
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 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
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
"To Do Is To Be" - Nietzsche "To Do Is To Do" - Kant "Do Be Do Be Do" - Sinatra |
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 Life is Experience New Eden Hardware Emporium
|
Posted - 2009.11.15 17:26:00 -
[28]
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?
Eve-online Industrial Organiser thread full batch manufacturing
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |