open All Channels
seplocked EVE Technology Lab
blankseplocked Incursion 1.5 Static Data Export & Image Export
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 [2]

Author Topic

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

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

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.

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.

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]

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