Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 2 post(s) |
|
CCP Stillman
|
Posted - 2011.04.12 10:43:00 -
[1]
HereÆs the Static Data Dump and Image Dump for Incursion 1.1.0
Static data export: http://cdn1.eveonline.com/data/Incursion_1.4_39687.zip
Image export types: http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Types.zip
Image export renders: http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Renders.zip
Image export icons: http://cdn1.eveonline.com/data/Incursion_1.4_imgs_Icons.zip
|
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2011.04.12 16:10:00 -
[2]
mssql singlefile script
mysql singlefile script mysql one-file-per-table script
sqlite singlefile binary (also for EAM) postgres-unquoted singlefile compatible script
innodb users please try loading the regular myisam version, then apply this script to change engine and add FKs, then report load/convert times here.
<Zirnitra> Someone should read you the EULA :) |
B0FROST
|
Posted - 2011.04.12 20:00:00 -
[3]
Originally by: Jercy Fravowitz conversions
With Catari gone, can I have your babies now?
What? Too soon?
|
Desmont McCallock
|
Posted - 2011.04.15 12:00:00 -
[4]
I have a complain to make.
By removing the attributes info for non-published skills from the SDD (dgmTypeAttributes table), you managed to break EVEMon and disable any accuracy on the displayed info or training time for those skills.
A heads-up notice, in the future, on such changes would be much appreciated.
|
Khoernal Khorotid
|
Posted - 2011.05.01 04:25:00 -
[5]
I'm trying to restore the .bak file into a new database and getting an error. This is the first time I've tried to do this.
I'm following these instructions from the other thread:
Quote: summary: open sql managment thing, rightclick database (the database tree header, not any specific database), restore database, from device, add the .bak file, select the db to restore, select the db to restore to, might have to adjust pathes in the other tab, go go go.
I have freshly installed ms sql server 2008 R2. I get as far as adding the .bak file to the 'specify backup' dialog. If I then click either Ok or Contents I get:
The media family on device 'I:\downloads\eve\Incursion_1.4_396867\DATADUMP201104061056.bak' is incorrectly formed. SQL Server cannot process this media family.
From some searching on the error it sounds like this means the download is corrupt. But I re-downloaded and got the same thing, and others are obviously getting it to work, so I must be doing something wrong.
I've also downloaded the singlel file script, so I could try that if someone would post some noob-level instructions for loading it.
Any help appreciated very much.
|
BoomChong Wong
|
Posted - 2011.05.01 04:51:00 -
[6]
Edited by: BoomChong Wong on 01/05/2011 04:51:41 Additional info, if it makes a difference:
I am running Win 7 x64, and (because I'm a visual studio developer) already had copies of VS 2008 and VS 2010 installed, as well as MS Sql Server 2005 and MS Sql Server 2008. I'd never used those earlier sql versions. I freshly downloaded 2008 R2 for this eve data. I have not found any updates to apply to it via windows update. During the install I took all default options.
I also tried copying the backup files to my C drive, since I saw something on the net about someone having trouble restoring from an external hard drive (but I was using my 'I' drive which is internal), anyhow, no difference.
(BoomChong Wong == Khoernal Khoritid)
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2011.05.01 09:40:00 -
[7]
Originally by: Khoernal Khorotid The media family on device 'I:\downloads\eve\Incursion_1.4_396867\DATADUMP201104061056.bak' is incorrectly formed. SQL Server cannot process this media family.
a) make sure you are actualy using the right version of sql server. try deinstalling the older versions, or at least check what version is reported in help->about. b) make sure the pathes in the other-tab of the restore dialog point at something that actualy exists and is writeable by you. c) contact microsoft support. :P |
BoomChong Wong
|
Posted - 2011.05.03 03:39:00 -
[8]
Thanks for your help. The Management studio shows 2008 R2 in its 'about'. I couldn't find an 'other' tab on the 'restore database' dialog. There's an 'options page', but it won't let me into it unless I have restored a db (says 'you must specify a source') and that's what I'm trying to do when I get the error. Where am I supposed to see the 'other' tab?
|
Enu Zembasi
|
Posted - 2011.05.09 15:52:00 -
[9]
I just glimpsed over that data and I'm not sure... is there a table with all items in the game? Maybe its just buried inside all those relations that I'm not noticing it? A few days ago certain site went down, with hosted information on NPC ships (damage dealt, resists, special abilities, HP and such - very detailed and nicely put) - is there some official database for that? Or someone used ship scanner on every NPC ship and put up his own database?
Regards,
|
Wendi Watson
Organization Too Secret To Know
|
Posted - 2011.05.16 20:33:00 -
[10]
With the changes to (most of) agent's divisions, along with quality, how soon can we expect an updated SDD?
|
|
Karlos Zhang
|
Posted - 2011.05.17 16:40:00 -
[11]
Agreed. We're going to need a new data dump after the changes to agents.
|
Etil DeLaFuente
|
Posted - 2011.05.17 20:34:00 -
[12]
We need an accurate (up-to-date) one.
How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.17 20:59:00 -
[13]
Originally by: Etil DeLaFuente We need an accurate (up-to-date) one.
How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?
You do. Player-built outposts were never in SDD. -- Thanks CCP for cu |
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.05.18 06:30:00 -
[14]
Originally by: Etil DeLaFuente We need an accurate (up-to-date) one.
How comes staStations or mapDenormalize lack some stations ? e.g "6Z-CKS VII" is nowhere, yet the station has been built in 2009! Or do we have to query the sov API and figure it out ?
Because Conquerable Stations aren't static data, therefore aren't in the Static Data Dump. They can (at least theoretically) change ownership day to day, so it it more appropriate to get that data from the dynamic API.
|
Etil DeLaFuente
|
Posted - 2011.05.18 08:31:00 -
[15]
Edited by: Etil DeLaFuente on 18/05/2011 08:34:49 Player built stations can't be destroyed therefore should be included in the static dump, owner has nothing to do with it. 57 conquerable stations are already present in staStations, maybe because they were not player built ?
I just want to use the CharacterInfo API, which gives the last known location (a station in that case), and dig some infos about that location. Unfortunately, i can't because some stations don't exist and the sov api does not gives enough info, only the solarSystemName is present. Do i have to build my own station list based on db dump and sov api ?
edit : Actually the ConquerableStationList API gives the list i need, seems i'll have to build my own list after all.
|
|
CCP Stillman
|
Posted - 2011.05.19 16:57:00 -
[16]
Added new SDE
|
|
Iurnan Mileghere
Singularity Foundation
|
Posted - 2011.05.19 19:58:00 -
[17]
Will Incursion 1.5 have a new image export, or stay as-is from 1.4?
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.19 20:49:00 -
[18]
Originally by: Iurnan Mileghere Will Incursion 1.5 have a new image export, or stay as-is from 1.4?
Anything changed pertaining images? -- Thanks CCP for cu |
Matthew
Caldari BloodStar Technologies
|
Posted - 2011.05.19 21:52:00 -
[19]
Originally by: Tonto Auri Anything changed pertaining images?
Blueprint Copy icons... ------- There is no magic Wand of Fixing, and it is not powered by forum whines. |
Epitrope
The Citadel Manufacturing and Trade Corporation
|
Posted - 2011.05.19 22:30:00 -
[20]
Originally by: CCP Stillman Added new SDE
Sometimes it's useful to have both the old and the new versions. The toolkit page doesn't have a log, and the link got edited out of the first post, so for posterity's sake, here's a link to the Incursion 1.4 SDE:
http://cdn1.eveonline.com/data/Incursion_1.4_39687.zip
|
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.20 00:40:00 -
[21]
Originally by: Matthew
Originally by: Tonto Auri Anything changed pertaining images?
Blueprint Copy icons...
I don't see any change. They're still indistinguishable from originals. -- Thanks CCP for cu |
Iurnan Mileghere
Singularity Foundation
|
Posted - 2011.05.20 13:15:00 -
[22]
Originally by: Tonto Auri
Originally by: Matthew
Blueprint Copy icons...
I don't see any change. They're still indistinguishable from originals.
Then you're missing something, because the icons have a clear and obvious difference. BPCs are now much lighter and have scan lines.
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.20 18:53:00 -
[23]
Originally by: Iurnan Mileghere Then you're missing something, because the icons have a clear and obvious difference. BPCs are now much lighter and have scan lines.
kk, show me?
http://img32.imageshack.us/i/bpcs20110519.png/ -- Thanks CCP for cu |
Adrielle Firewalker
Minmatar Amarr Will Eat Itself
|
Posted - 2011.05.20 19:13:00 -
[24]
Does anyone have any conversion tools for this? The MSSQL output is pretty useless for me. ================
~Adrielle
Original MinmatarT |
EveDataRules
|
Posted - 2011.05.21 01:02:00 -
[25]
Edited by: EveDataRules on 21/05/2011 01:01:56 http://www.evedata.org/eve-incursion-1.5-myisam.sql.gz
MySQL MyISAM version of the database export to tide people over; there were a few conversion errors.
|
Adrielle Firewalker
Minmatar Amarr Will Eat Itself
|
Posted - 2011.05.21 01:25:00 -
[26]
Thanks very much! ================
~Adrielle
Original MinmatarT |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.27 14:31:00 -
[27]
Originally by: Adrielle Firewalker Does anyone have any conversion tools for this? The MSSQL output is pretty useless for me.
Maestro AnySQL is a nice product for the occassional "data-from-this-to-that-format" tasks. -- EVEWalletAware - an offline wallet manager |
J'J'J'Jita
Ch'Ch'Ch'Chia Corp
|
Posted - 2011.05.28 01:23:00 -
[28]
Does anyone have links to older dumps, such as the first Incursion SDE, first and last Tyrannis SDE, and last Dominion SDE? Thanks!
|
Luminocity
|
Posted - 2011.05.28 14:26:00 -
[29]
Edited by: Luminocity on 28/05/2011 14:27:38 I'm not sure why the fresh conversion links haven't been posted but they seem to be available here: http://eve.no-ip.de/inc15/
Props to Jercy Fravowitz..
Also, CCP, stop being cheap and modifying the initial post - it's confusing. Just make a new thread or at least a fresh post in the old thread when a new dump is out... (don't worry we'll pay for it :D)
Edit: How ironic that I should need to edit this post after saying that..
|
dragonyte
|
Posted - 2011.05.29 05:16:00 -
[30]
What is the database name suppose to be? I am getting System.dta.sqlclient.sqlerror: the backup set holds a database other then the existing.... I ran the script that was with the static dump in the database i created...is there an "offical" name we are suppose to use? |
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |