Originally by: Salvis Tallan

---

Gah! Can we have it in CSV?

---

Originally by: elFarto

---

*edit* OMG, no CSV files, bad t20, no man love for you.

---

Originally by: t20

---

I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.

---

Originally by: t20

---

I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.

---

Originally by: t20

---

I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.

---

Originally by: Dalekplunger Slick

---

Originally by: t20

---

I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.

---

I don't see anything about how to create the tables in http://myeve.eve-online.com/devblog.asp?a=blog&bid=246 or http://myeve.eve-online.com/devblog.asp?a=blog&bid=406

Is there some other blog that you're talking about?

---

Originally by: Futurama

---

Which of the following would you most most prefer?

(a) A puppy;
(b) A pretty flower from your sweetie;
(c) A large, properly-formatted data file.

Choose!

---

Originally by: Quutar

---

(I am not complaining in the LEAST)

the following table definitions are missing
chrFactions
chrSchoolAgents
eveUnits
invFlags
invMetaGroups
invTypeReactions
TL2MaterialsForTypeWithActivity

and we have the definition for these, but no data
mapSecurityRatings
ramActivities
ramassemlylinecostlog
raminstallationtypedefaultcontents

---

Originally by: t20

---

Archive file updateded with missing tables + added table structure.

---

Originally by: Internet Knight

---

Forgive me for being an SQL newbie, I generally only use INSERT/UPDATE/DELETE... what is this IDENTITY(x, 1) definition in several of the table declarations?

---

Originally by: Dalekplunger Slick

---

Originally by: t20

---

I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.

---

I don't see anything about how to create the tables in http://myeve.eve-online.com/devblog.asp?a=blog&bid=246 or http://myeve.eve-online.com/devblog.asp?a=blog&bid=406

Is there some other blog that you're talking about?

---

CREATE TABLE dbo.chrFactions(
 factionID int,
 factionName varchar(100),
 description varchar(1000),
 raceIDs INTEGER,
 solarSystemID int,
 corporationID int,
 sizeFactor float,
 stationCount smallint,
 stationSystemCount smallint);


CREATE TABLE dbo.eveUnits(
 unitID tinyint,
 unitName varchar(100),
 displayName varchar(20),
 description varchar(100));

CREATE TABLE dbo.invMetaGroups(
 metaGroupID INTEGER,
 metaGroupName varchar(100),
 description varchar(100),
 graphicID smallint);
 
CREATE TABLE dbo.invMetaTypes(
 typeID int,
 parentTypeID int,
 metaGroupID INTEGER);


CREATE TABLE dbo.TL2MaterialsForTypeWithActivity(
 typeID int,
 activity tinyint,
 requiredTypeID smallint,
 quantity int,
 damagePerJob DOUBLE PRECISION);

CREATE TABLE dbo.chrSchoolAgents(
 schoolID tinyint,
 agentIndex INTEGER,
 agentID int);

CREATE TABLE dbo.invFlags(
 flagID INTEGER,
 flagName varchar(100),
 flagText varchar(1000),
 flagType varchar(1000),
 orderID INTEGER);

CREATE TABLE dbo.invTypeReactions(
 reactionTypeID INTEGER,
 input bit,
 typeID int,
 quantity int);

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these behemoths is Titans, the largest spacefaring vessels ever constructed. The sheer cost in resources, manpower and time, as well as the necessary technological knowledge, makes construction of a Titan-class vessel a venture only empires can usually fathom. Some of these mammoth vessels have taken decades to assemble. Many are over a century old themselves, and the three mammoth Jovian motherships, the first Titans, have origins pre-dating modern space travel. They are

---

Originally by: Eewec Ourbyni

---

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these <snip>

---

Are we ever going to find out what "They are".....? Was hoping this was in this datadrop as it got cut off in the last one....

---

Originally by: Keikko Aranata

---

Originally by: Eewec Ourbyni

---

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these <snip>

---

Are we ever going to find out what "They are".....? Was hoping this was in this datadrop as it got cut off in the last one....

---

I don't understand why that is truncated at 500 characters. The table def says nvarchar 3000? Maybe when t20 can update the missing table defs and missing tables, and rename the dbo_* to dbo.* he can re-export so data isn't truncated? Sounds like a lot of work as I am a newbie, but please take pity on us t20 :)

---

Originally by: ItsIdMe

---

Originally by: Rede

---

Edited by: Rede on 09/12/2006 15:58:13
I was trying to import this stuff to MS-SQL Express, but stuck with true/false flags.

I get only:

Msg 128, Level 15, State 1, Line 3
The name "true" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Any help would be appreciated. Basically I need this to make SQLite3 database, but that's another story.

EDIT: I'm using management studio. If I need to use something else..?

---

You have to replace the true and false values with 1 and 0.
That worked for me anyway.

---

Originally by: Rede

---

Originally by: ItsIdMe

---

Originally by: Rede

---

Edited by: Rede on 09/12/2006 15:58:13
I was trying to import this stuff to MS-SQL Express, but stuck with true/false flags.

I get only:

Msg 128, Level 15, State 1, Line 3
The name "true" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Any help would be appreciated. Basically I need this to make SQLite3 database, but that's another story.

EDIT: I'm using management studio. If I need to use something else..?

---

You have to replace the true and false values with 1 and 0.
That worked for me anyway.

---

Worked for me too... But now I'm hitting new problems:

Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'dgmAttributeTypes' when IDENTITY_INSERT is set to OFF

This ms-sql stuff is killing me.. :)

---

Originally by: Rede

---

I can't import eveNames, I hit "out of memory" error - 1.5GB physical memory is not enough?

---

Originally by: ToxicFire

---

Originally by: Keikko Aranata

---

I don't understand why that is truncated at 500 characters. The table def says nvarchar 3000? <snip>

---

<snip> you will hit a few issues with nvarchar and char lengths that are over a certain number <snip>

---

Quote:

---

This is only the data, the icons will be rendered out tomorrow, alongside with the alliance logos for the alliance pages and most probably the item database on the website as well.

---

Originally by: Andargor theWise

---

FWIW this is my MySQL conversion:

<...>

CCP again forgot some CREATEs... So I guesstimated.

---

 Dim FileName As String = "SolarSystems"

 Dim sr As New StreamReader(Server.MapPath(FileName) & ".sql")
 Dim data As String = sr.ReadToEnd

 Dim re As New Regex("VALUES\((.*?)\)", RegexOptions.Singleline)

 Dim sw As New StreamWriter(Server.MapPath(FileName) & ".csv")
 For Each m As Match In re.Matches(data)
 Dim SqlRecord As String = m.Groups(1).Value
 Dim CsvRecord As String = ""
 Dim Columns As Array = SqlRecord.Split(",")

 For Each s As String In Columns
 If s.StartsWith("'") And s.EndsWith("'") Then
 s = s.Substring(1, s.Length - 2)
 End If
 If s.Contains("""") Then
 Throw New Exception("Oops!")
 End If
 CsvRecord += """" + s + """:"
 Next
 CsvRecord = CsvRecord.Substring(0, CsvRecord.Length - 1)
 sw.WriteLine(CsvRecord)
 Next
 sw.Close()

Originally by: Emily Spankratchet

---

Does anyone understand why there are negative values for some things in TL2MaterialsForTypeWithActivity?

Looking at the Vagabond blueprint (item ID 12000), there are negative values in activity 1 (manufacturing) for Trit (-271996), Pyer (-77203), Mex (-25832), Nocx (-506) and Zyd (-103).

In game, the blueprint doesn't appear to need those minerals. What's going on? Does it have some deep meaning, or is it a Db error or overflow problem?

---

Originally by: Emily Spankratchet

---

Originally by: Andargor theWise

---

FWIW this is my MySQL conversion:

<...>

CCP again forgot some CREATEs... So I guesstimated.

---

Great work, it's made my life a lot easier.

One small bit of feedback: In the table TL2MaterialsForTypeWithActivity you guesstimated the type for field damagePerJob as smallint. It should be float, as it has values in the range 0.0 to 1.0.

---

Originally by: Mortimus

---

i'm pretty sure if you look at the base T1 item print you'll discover that those are what's required to make it. Feel free to call me a dumbass because i never actually CHECKED that i just assumed that's what it was :)

---

Originally by: Carm

---

2. Could it be possible to add ";" at the end of each CREATE TABLE in the structure script ?
4. There are still some missing table definitions (I ve already seen that in the topic, but anyway)

---

Originally by: Carm

---

3. Why are there some column name between '[' and ']' in the structure script ?

---

Originally by: Chruker

---

SQL = Standard Query Language?

Not much standard about it

---

Originally by: Ather Ialeas

---

I'm new to this database poking stuff, would anyone want to tell me how I can check out from the db what are the bonuses for modules? For example how do I dig up what sort of bonuses and such EANMII has?

---

Originally by: Chruker

---

Edited by: Chruker on 14/12/2006 15:32:28
parentBlueprintTypeID = 682 (which is 'Clone Grade Gamma Blueprint' = strange)

---

Originally by: Dunedon

---

Originally by: Chruker

---

Edited by: Chruker on 14/12/2006 15:32:28
parentBlueprintTypeID = 682 (which is 'Clone Grade Gamma Blueprint' = strange)

---

parent almost always means to look within the SAME table for the value. The parentBlueprintTypID is not a link to the invType table, but back to itself (the blueprintTypeID table).

- Dunedon

---

Originally by: Ilor Prophet

---

the system ID numbers have been non-sequential since the Dragon update. :( I used to have some route and haul calculation stuff in which I used an array of system objects indexed to (systemid-30.000.001). It made object lookup blazingly fast because I didn't have to query.

---

(I don't actually know what a hashmap is :/)

Originally by: Dev Blog of the nber god

---

Attention: The same criteria apply still and I will say it again for posterity, you can not sell this data or use it in any form of a commercial product. If you want to use it in a commercial product, contact [email protected] for licensing.

---

Originally by: Beatle Bones

---

(I don't actually know what a hashmap is :/)

---

Originally by: beldonuin

---

Hi

silly question, but am looking for simple data on
ships - CPU (tf)
Powergrid (MW)
Low Slots
Med Slots
Hi Slots
Launcher Hardpoint
Turret Hardpoint

and ship fits
slot
CPU (tf)
Powergrid (MW)

cannot see them in the rmr feed
thanks

---

Originally by: Lunadi

---

Could anyone help me with regards to importing these data into mySQL?, I've tried to use the fixed export supplied by Mecci. But I quickly get some errors, unfortunately my knowledge of databases is very very basic (just enough to build some simple php tools). Maybe anyone could share a mySQL export or give some advices.

---

Originally by: Mecci

---

Are you trying to import the evedb-1953-FIXED.zip files or are you running them through the tool as well? Because the sql files in the zip file doesn't work with MySQL (that's what the tool are there for)

---

Originally by: ToxicFire

---

feels like theres a couple of missing tables in this export is there any possible way of getting an agents name list table added to the list. So alot of agent databases can be updated?

---

Originally by: RF Gonzo

---

pleeeeease help

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

SELECT g.groupName, t.typeName, t.description, t.basePrice
FROM
invTypes t,
invGroups g,
invCategories c
WHERE g.groupID = t.groupID
AND c.categoryID = g.categoryID
AND c.categoryID = 16
ORDER BY g.groupName, t.typeName

SELECT e.*
FROM
dgmTypeEffects te,
dgmEffects e,
invTypes t
WHERE te.effectID = e.effectID
AND t.typeID = te.typeID
AND t.typeName = 'Omnipotent';

SELECT a.attributeName, a.description, IFNULL(ta.valueInt,ta.valueFloat) as value 
/* 
IFNULL is a mysql function, 
IFNULL(expr1,expr2) returns expr2 if expr1 is null, returns expr1 otherwise
*/
FROM
dgmTypeAttributes ta,
dgmAttributeTypes a,
invTypes t
WHERE ta.attributeID = a.attributeID
AND t.typeID = ta.typeID
AND t.typeName = 'Omnipotent';

Originally by: RF Gonzo

---

I am looking for the refining/reproccessing values of ore and drone minerals (glossy compund etc.) but cant find it.
Examples: Glossy Compound has itemID 11724 and no entry in activity tab. Plaglioclase has itemID 18 and no entry...pleeeeease help

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

Originally by: Grismar

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

I think you need to take a long hard look at the invtypes table. You'll find some of it there. The skill tree (or skill pre-reqs for items) doesn't seem to be part of the export at all at the moment.

---

Originally by: "Original blog for first data dump

---

activityNone = 0
activityManufacturing = 1
activityResearchingTechnology = 2
activityResearchingTimeProductivity = 3
activityResearchingMaterialProductivity = 4
activityCopying = 5
activityDuplicating = 6
activityReverseEngineering = 7

---

Originally by: Eewec Ourbyni

---

Originally by: "Original blog for first data dump

---

activityNone = 0
activityManufacturing = 1
activityResearchingTechnology = 2
activityResearchingTimeProductivity = 3
activityResearchingMaterialProductivity = 4
activityCopying = 5
activityDuplicating = 6
activityReverseEngineering = 7

---

so activity = 8 would be... invention?

---

Quote:

---

--
-- Table structure for table `TL2MaterialsActivity`
--

DROP TABLE IF EXISTS `TL2MaterialsActivity`;
CREATE TABLE `TL2MaterialsActivity` (
`activityID` smallint(6) NOT NULL default '0',
`activity` varchar(40) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TL2MaterialsActivity`
--

/*!40000 ALTER TABLE `TL2MaterialsActivity` DISABLE KEYS */;
LOCK TABLES `TL2MaterialsActivity` WRITE;
INSERT INTO `TL2MaterialsActivity` VALUES (0,'None'),(1,'Manufacturing'),(2,'Research Technology'),(3,'Research Time Production'),(4,'Research Material Production'),(5,'Copying'),(6,'Duplicating - NOT In-game!!'),(7,'Reverse Engineering - NOT In-Game!!'),(8,'Invention?');
UNLOCK TABLES;
/*!40000 ALTER TABLE `TL2MaterialsActivity` ENABLE KEYS */;

---

Originally by: Azrael Bierce

---

anyone happen to have a pretty picture describing all the relationships somewhere?

---

Originally by: Chruker

---

Edited by: Chruker on 27/12/2006 15:57:50

Originally by: Azrael Bierce

---

anyone happen to have a pretty picture describing all the relationships somewhere?

---

I've made a pdf of the relationsships. This is not the final version, so feel free to come with corrections, and more relations. There are also a few grey lines which are IDs I don't know where to find.

EDIT:
And the link is: http://games.chruker.dk/eve_online/datadump.php

---

Originally by: Chruker

---

uhmmmm spaghetti...

Yeah it is a bit messy. Luckily you can switch off some of the layers if you view the PDF in Adobe Illustrator :-) Anyway, I'll take a look at yours and see which relations I'm missing.

BTW, was your diagram autogenerated? If so, which program did that?

---

Originally by: Vessper

---

I think you need to take a long hard look at the dgmTypeAttributes table. Check for attributeID = 182, 183 and 184 for the skill required (the value is the skillID) together with attributeID = 277, 278 and 279 for the skill level (the value is the skill level).

---

Originally by: Grismar

---

Indeed, thanks. I don't know how I managed to miss that, since looking at the old data, that's how I got it the first time ^^. Thanks anyway.

I'm still curious about the T2-table though. It seems woefully incomplete.

---

Originally by: Max Kentarii

---

Any news on the item icons?
Dev blog said that it would be out a long time ago, but as far as i can tell. It's not yet available

---

Originally by: Grismar

---

Edited by: Grismar on 19/12/2006 17:18:14
All you PHP and MySQL users, you can download the structure definitions from my website at:

http://eve.grismar.net/dbo__tables_my.zip

Changes made are noted in the query itself. Also, there are three notable bugs in the definition as released by CCP:
- missing "," after "hasType BIT NOT NULL DEFAULT 0" in invMarketGroups
- missing "," after "reprocessingHangarFlag tinyint NOT NULL DEFAULT 4" in staStations
- missing definition for TL2MaterialsForTypeWithActivity altogether

If you're new to webdevelopment, but want to get this database up and running, try XAMPP. It's free and includes an easy to setup Apache server with MySQL server. You can get a legal and free copy here:

http://www.apachefriends.org/en/xampp.html

That's a lot better than running that illegal copy of IIS with MS-SQL Server CCP forced you to use :p

Greetings,
Grismar.

---

Originally by: khazid

---

hi,

i'm searching for detailed ship informations in the dump and can't find. i need the info on how many high, med, low slots a ship has. in which table can i find that? think i looked into each sql file but really can't find anything on it, hope somebody can help me...


greetz

---

Originally by: Dunedon

---

Is it just me or is the data dump missing "pieces" of data?

I'm trying to build a table of all the recycling values ... sounds simple you'd think.

The Eve-Online database even contains the information I need for the 'Large Standard Container' (typeID: 3296)

However I cannot find in the data dump the component values, even though they are listed on the site (so apparently it can find them).

Does anyone know where I would find this information? I've looked in the blueprints, TL2 and attributes tables ... don't know where else I should really be looking :)

Thanks in advance for any assistance - even if it's just to tell me that yes that information is missing :)

- Dunedon

---

Originally by: Phyra

---

Edited by: Phyra on 10/01/2007 12:10:01
Sorry to be on the same rant again, but this is costing my time:

I worked a little more with that export.

T20: Get things fixed ASAP. It is really unacceptable with all the bugs. You got very good responses in this thread and in bug reports before. Now heed them. Especially annoying are these five bugs:

1. In the 40 MB "dbo_eveNames.sql" all table references are to dbo_eveNames instead of dbo.eveNames.(There's another smaller file with the same problem, find it too while you are at it). Fix it!

2. All tables containing true/false values have mismatching values/variables. Either change the values from true/false to numerical (recommended) or change the variable def.

3. In the table defs all those IDENTITY statements are completely out of place for our purposes here. Fix it!

4. All those COMMIT statements are out of place. Get them out.

5. Big files, i.e. above 2 or 3 MB need a few "GO" statements in between all those INSERTs. Every 10k - 20k rows is nice for example.

@Dunedon: I'll try and find out as soon as I have all tables set up...

Ty

Phyra

Edited to include two more annoying bugs.

---

Originally by: Salvador King

---

Hi,

Was wondering in which table was located informations about skills required per item.
I.e. skills required to be able to use Nosferatu.

---

Originally by: Chruker

---

Originally by: Phyra

---

Edited by: Phyra on 10/01/2007 12:10:01
Sorry to be on the same rant again, but this is costing my time:

I worked a little more with that export.

T20: Get things fixed ASAP. It is really unacceptable with all the bugs. You got very good responses in this thread and in bug reports before. Now heed them. Especially annoying are these five bugs:

1. In the 40 MB "dbo_eveNames.sql" all table references are to dbo_eveNames instead of dbo.eveNames.(There's another smaller file with the same problem, find it too while you are at it). Fix it!

2. All tables containing true/false values have mismatching values/variables. Either change the values from true/false to numerical (recommended) or change the variable def.

3. In the table defs all those IDENTITY statements are completely out of place for our purposes here. Fix it!

4. All those COMMIT statements are out of place. Get them out.

5. Big files, i.e. above 2 or 3 MB need a few "GO" statements in between all those INSERTs. Every 10k - 20k rows is nice for example.

@Dunedon: I'll try and find out as soon as I have all tables set up...

Ty

Phyra

Edited to include two more annoying bugs.

---

I ran into all of those except number 5. And they were very easy to solve with a simple search and replace. Took maybe 10 mins.

---

Originally by: Zatch

---

Edited by: Zatch on 12/01/2007 16:21:30
There seem to be some missing items in the item/bptypes, specifically the Multispectral Frequency Probe and its associated blueprint. Also, is an icon release still planned?

I'm afraid I can't trust the data export now that it seems to be incomplete.

---

SELECT * FROM `tl2materialsfortypewithactivity` WHERE `quantity` <0 AND activity =1;

Originally by: Dunedon

---

The negative numbers correspond to the mineral requirements for items used up in the manufacture of the item you are looking at.

IE: An Eros requires a Catalyst as a manufacturing component ... if you check the mineral requirements for the Eros you'll find negative numbers ... which are identical to those required (but the wrong sign) for manufacturing a Catalyst.

- Dunedon

PS: Would someone from CCP please respond to this ever lengthening thread to let us know if a revised and complete data dump will be available ... or if they are no longer going to be supplying this information. Working with incomplete data, and not knowing if it's going to be fixed is (as I am sure they are also aware) VERY frustrating :)

---

Originally by: Dektor

---

The Eris has no negative Material requirements. It requires 1 Catalyst. Not -1 Catalyst. Check out the list I linked:

Here is a list of BPs and which material they require negatively.

All BP's in that list I checked (which is only a few) didn't require the material at all. However I was wondering if the negative quantities were a error or are meant for something else (maybe for Recycle calculations or something).

---

Originally by: Nuska

---

Perhaps someone could assist me with something simpler than a full blown hot-to for sql express.
The only thing I really need is to be able to calculate travel routes. So say if I want to know how to get from system A to system B, how many jumps are involved through which systems, finding routes to avoid lowsec, or 0.0, etc.

There ought to be some fairly simple way to pull out the few tables that would be needed, and import them to sql express 2005 to make such queries possible, no? Any help is greatly appreciated. TIA

---

Originally by: t20

---

Archive file updateded with missing tables + added table structure.

---

Originally by: Dunedon

---

mapsolarsystemjumps is what you need to plot travel roots ... you then need to impliment either an A* or dyikstra (sp?) algorithm to search for the route you need.

My current implimentation of dyikstra can map any route in under 40s .. still pretty slow, need to optimize! ;-)

Dunedon

---

Originally by: t20

---

Archive file updateded with missing tables + added table structure.

---

SELECT
 dgmattributetypes.attributeid, dgmattributetypes.attributename,
 dgmtypeattributes.valueint 
FROM 
 dgmattributetypes 
INNER JOIN 
 dgmtypeattributes 
ON
 dgmtypeattributes.attributeid = dgmattributetypes.attributeid 
WHERE
 (dgmtypeattributes.typeid = 17978 );

 attributeid | attributename | valueint
-------------+-----------------------+----------
 182 | requiredSkill1 | 16281
 790 | reprocessingSkillType | 18025

SELECT
 dgmattributetypes.attributeid, dgmattributetypes.attributename,
 dgmtypeattributes.valueint 
FROM 
 dgmattributetypes 
INNER JOIN 
 dgmtypeattributes 
ON
 dgmtypeattributes.attributeid = dgmattributetypes.attributeid 
WHERE
 (dgmtypeattributes.typeid = 21039 );

 attributeid | attributename | valueint
-------------+------------------+----------
 726 | moonMiningAmount | 100

Originally by: Zatch

---

Edited by: Zatch on 23/01/2007 08:49:50
This is also the number displayed ingame, with Production Efficiency at 5. If these blueprints were handled like every other blueprint I've ever encountered, though, the displayed requirement at Material Level 0 would be 138. This number is reached via this calculation:

(Base Amount) * ( (Base Wastage Factor) / (1 + Material Level) + 0.25 - 0.05 * (Production Efficiency Skill Level) )
125 * ( (1.1) / (1 + 0) + 0.25 - 0.05 * 5 ) = 12.5, which rounds up to 13 (125 + 13 = 138.)

---

Originally by: Zatch

---

I'm just a little confused about why the calculations would be any different, given that the method for all of the other blueprints is quite sound and straightforward, whereas reversing the calculation is inaccurate and thus inefficient. Given the circumstances though, I won't throw out that possibility.

---

Originally by: Chruker

---

Edited by: Chruker on 02/02/2007 12:52:53
For anyone still needing a MySQL one, here is my dump from the MySQL database (3.x) I use on my site: http://games.chruker.dk/eve_online/files/dbo_20070116.zip

---

Originally by: Chruker

---

Edited by: Chruker on 02/02/2007 12:52:53
For anyone still needing a MySQL one, here is my dump from the MySQL database (3.x) I use on my site: http://games.chruker.dk/eve_online/files/dbo_20070116.zip

---

Originally by: mvil

---

Here's[/url] a few lines of sql to update the mapSolarsystemJumps table with the changed jumps (as listed in the patch notes).

---

Originally by: Raquel Smith

---

With the most recent t20 stuff I hope we can still have someone in CCP to provide for us database dumps!

---

Originally by: EmmettBrown

---

for example I know a thorax has a waste factor of .1 unresearched as most things do. there are some items such as ammo and drones that have a waste of .05. This is not reflected in the WASTEFACTOR column

---

Originally by: Raquel Smith

---

Quote:

---

Here's a few lines of sql to update the mapSolarsystemJumps table with the changed jumps

---

There's no data for stargates. This sql fragment is very handy for what it is but any decent A* algorithm needs the coordinates of the new stargates.

---

Originally by: Chruker

---

well, the coordinates that the A* algorithm would use would be the location of the systems. And AFAIK the systems hasn't moved anywhere.

---

Originally by: Raquel Smith

---

Edited by: Raquel Smith on 16/02/2007 21:49:36

Originally by: Chruker

---

well, the coordinates that the A* algorithm would use would be the location of the systems. And AFAIK the systems hasn't moved anywhere.

---

One needs to know the distance between each gate in each system.

edit: I should elaborate...

In the graph of the universe each system is a vertex and each journey between stargates inside each system is actually the edge. That is where there is cost. Jumping between systems incurs no real cost (unless it's into Jita) aside from, perhaps, weighting based on the security system of the next vertex.

---