EVE Search - Incursion 1.4 Static Data Export & Image Export

All Channels

EVE Technology Lab

Incursion 1.4 Static Data Export & Image Export

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

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?
Jacob Reuben	Posted - 2011.05.31 12:04:00 - [31] Originally by: Jercy Fravowitz 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. Thank you very much for the conversions!
Asteriade	Posted - 2011.06.01 13:40:00 - [32] Originally by: Jercy Fravowitz 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. Yeah, big thx for that ! My Microsoft Sql server 2008 crach everytime, i hate this softwar. Even my browser become instale with it. So, thx alot Jercy ------------------------------------------- Eve Indus
Ruziel Minmatar Twilight Military Industrial Complex	Posted - 2011.06.07 20:51:00 - [33] I've already bug reported it, but I thought I'd mention this here as well. A number of the blueprint icons are missing from the latest image dump, appears to be all the ones with PI materials added in Tyrannis, even though they are in the Tyrannis image dump. In addition, they appear to be missing from the image server as well. I didn't check them all, but random sample from the list all came back missing. typeID Name 2738 Nanite Repair Paste Blueprint 2774 Amarr Control Tower Blueprint 2775 Amarr Control Tower Medium Blueprint 2775 Amarr Control Tower Small Blueprint 2777 Caldari Control Tower Blueprint 2778 Caldari Control Tower Medium Blueprint 2779 Caldari Control Tower Small Blueprint 2780 Gallente Control Tower Blueprint 2781 Gallente Control Tower Medium Blueprint 2782 Gallente Control Tower Small Blueprint 2783 Minmatar Control Tower Blueprint 2784 Minmatar Control Tower Medium Blueprint 2785 Minmatar Control Tower Small Blueprint 2792 Ion Field Projection Battery Blueprint 2794 Phase Inversion Battery Blueprint 2796 Spatial Destabilization Battery Blueprint 2798 White Noise Generation Battery Blueprint 2799 Energy Neutralizing Battery Blueprint 2803 Large Blaster Battery Blueprint 2804 Large Railgun Battery Blueprint 2806 Medium Blaster Battery Blueprint 2808 Medium Railgun Battery Blueprint 2813 Small Blaster Battery Blueprint 2815 Small Railgun Battery Blueprint 2830 Large Beam Laser Battery Blueprint 2829 Large Pulse Laser Battery Blueprint 2828 Medium Beam Laser Battery Blueprint 2827 Medium Pulse Laser Battery Blueprint 2826 Small Beam Laser Battery Blueprint 2825 Small Pulse Laser Battery Blueprint 2822 Citadel Torpedo Battery Blueprint 2823 Cruise Missile Battery Blueprint 2824 Torpedo Battery Blueprint 2820 Experimental Laboratory Blueprint 2821 Mobile Laboratory Blueprint 2805 Large Artillery Battery Blueprint 2807 Large AutoCannon Battery Blueprint 2810 Medium Artillery Battery Blueprint 2814 Medium AutoCannon Battery Blueprint 2816 Small Artillery Battery Blueprint 2819 Small AutoCannon Battery Blueprint 2741 Stasis Webification Battery Blueprint 2736 Warp Disruption Battery Blueprint 2740 Warp Scrambling Battery Blueprint List continued next post, because the full list exceeds the post limit
Ruziel Minmatar Twilight Military Industrial Complex	Posted - 2011.06.07 20:53:00 - [34] Continued list: 2742 Biochemical Silo Blueprint 2743 Catalyst Silo Blueprint 2744 Coupling Array Blueprint 2745 General Storage Blueprint 2746 Hazardous Chemical Silo Blueprint 2747 Hybrid Polymer Silo Blueprint 2748 Silo Blueprint 2749 Advanced Large Ship Assembly Array Blueprint 2750 Capital Ship Maintenance Array Blueprint 2751 Advanced Medium Ship Assembly Array Blueprint 2752 Ship Maintenance Array Blueprint 2753 Advanced Small Ship Assembly Array Blueprint 2754 Ammunition Assembly Array Blueprint 2755 Ballistic Deflection Array Blueprint 2756 Capital Ship Assembly Array Blueprint 2757 Explosion Dampening Array Blueprint 2758 Component Assembly Array Blueprint 2759 Heat Dissipation Array Blueprint 2760 Drone Assembly Array Blueprint 2761 Photon Scattering Array Blueprint 2762 Drug Lab Blueprint 2763 Sensor Dampening Battery Blueprint 2764 Equipment Assembly Array Blueprint 2765 Intensive Refining Array Blueprint 2766 Large Ship Assembly Array Blueprint 2767 Medium Intensive Refining Array Blueprint 2768 Medium Ship Assembly Array Blueprint 2769 Refining Array Blueprint 2770 Rapid Equipment Assembly Array Blueprint 2771 Small Ship Assembly Array Blueprint 2772 Subsystem Assembly Array Blueprint 2773 X-Large Ship Assembly Array Blueprint 2786 Moon Harvesting Array Blueprint 2787 Corporate Hangar Array Blueprint 2788 Cynosural Generator Array Blueprint 2789 Cynosural System Jammer Blueprint 2790 Biochemical Reactor Array Blueprint 2791 Complex Reactor Array Blueprint 2793 Medium Biochemical Reactor Array Blueprint 2795 Polymer Reactor Array Blueprint 2797 Simple Reactor Array Blueprint 2800 Jump Bridge Blueprint In addition, why is the Sensor Dampening Battery Blueprint (typeID: 2736), part of groupID 1048 (Structure Blueprint) instead of groupID 859 (Structures - Sensor Dampening Array Blueprints) like the two faction Sensor Dampening Battery Blueprints?
Trenker	Posted - 2011.06.09 08:09:00 - [35] For you Jercy, some import / convert stats on my notebook (has 4GB RAM, Core i3 M330, SSD HD, running on Ubuntu natty) time bzcat inc14-mysql5-v1.sql.bz2 \| mysql -u eveinc14 -peveinc14 eve_datadump_inc14 6m6.261s time mysql -u eveinc14 -peveinc14 eve_datadump_inc14 < update_innodb.sql 2m7.289s time bzcat inc15-mysql5-v1.sql.bz2 \| mysql -u eveinc15 -peveinc15 eve_datadump_inc15 6m7.758s time mysql -u eveinc15 -peveinc15 eve_datadump_inc15 < update_innodb.sql 2m7.314s I love Eve, web apps and chinese food!
Jimmy Riot	Posted - 2011.06.10 19:05:00 - [36] have problems with mysql.dump invtypematerials some entrys like 'Guardian' (11987) are wrong. 11987 34 17403 // Tritanium ? [...]
Tonto Auri Vhero' Multipurpose Corp	Posted - 2011.06.10 21:53:00 - [37] Originally by: Jimmy Riot have problems with mysql.dump invtypematerials some entrys like 'Guardian' (11987) are wrong. 11987 34 17403 // Tritanium ? [...] Please elaborate. What was the query, and what was your intention about the results. -- Thanks CCP for cu
Zheh	Posted - 2011.06.11 10:52:00 - [38] Originally by: Tonto Auri Originally by: Jimmy Riot have problems with mysql.dump invtypematerials some entrys like 'Guardian' (11987) are wrong. 11987 34 17403 // Tritanium ? [...] Please elaborate. What was the query, and what was your intention about the results. here the query for a guardians mats: SELECT * FROM invtypematerials WHERE typeID = 11987 here the result: 11987 34 17403 // trit 11987 35 18784 // pyr 11987 36 19122 // mex 11987 37 1488 // iso 11987 38 1013 // nocx 11987 40 33 // mega 11987 3828 50 // c-blocks 11987 11399 60 // Morphite 11987 11532 50 // Fusion Thruster 11987 11537 175 // Radar Sensor Cluster 11987 11539 1200 // Nanoelectrical Microprocessor 11987 11543 1500 // Tungsten Carbide Armor Plate 11987 11549 15 // Antimatter Reactor Unit 11987 11554 500 // Tesseract Capacitor Unit 11987 11557 100 // Linear Shield Emitter but its need to be / what it is ingame: 11987 36 4219 // mex 11987 38 167 // nocx 11987 3828 50 // c-blocks 11987 11399 60 // Morphite 11987 11532 50 // Fusion Thruster 11987 11537 175 // Radar Sensor Cluster 11987 11539 1200 // Nanoelectrical Microprocessor 11987 11543 1500 // Tungsten Carbide Armor Plate 11987 11549 15 // Antimatter Reactor Unit 11987 11554 500 // Tesseract Capacitor Unit 11987 11557 100 // Linear Shield Emitter
Zheh	Posted - 2011.06.11 16:36:00 - [39] next one (mysql.dump inc1.4) here's the select for data interfaces SELECT * FROM ramtyperequirements WHERE requiredTypeID IN (SELECT typeID FROM `invtypes` WHERE `groupID` =716 ) all of them with damagePerJob = 1, but ingame they dont get dmg. also there is R.A.M.- Hybrid Technology(30386) in that group(716) - it need to be in group 332! solution: delimiter ; UPDATE invtypes SET groupID = 332 WHERE typeID = 30386 ; UPDATE ramtyperequirements SET damagePerJob = 0 WHERE requiredTypeID IN (SELECT typeID FROM `invtypes` WHERE `groupID` = 716 )
Tonto Auri Vhero' Multipurpose Corp	Posted - 2011.06.13 20:59:00 - [40] Originally by: Zheh next one (mysql.dump inc1.4) Do your tests on current dump, please. -- Thanks CCP for cu
Jercy Fravowitz School of Applied Knowledge	Posted - 2011.06.15 10:47:00 - [41] Originally by: Jimmy Riot have problems with mysql.dump invtypematerials hints on how to use the split materials data may be found in the dom100 thread.

Pages: 1 2 :: [one page]

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.