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: 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: Azrael Bierce

---

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

---

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: 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.

---

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: 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: 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: 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.

---

Originally by: ieniemienie

---

Would it be possible to calculte the AU distance between jumpgates in a solar system using the data files?

Somehow eve is able to calculate them
but im not been able to figure it out yet.

---

SELECT * FROM mapDenormalize WHERE itemName LIKE '%Stargate%' LIMIT 10

Originally by: Raoden Tanstaafl

---

If I wanted to build a query to build a skill tree, which tables should I be looking at?

---

Originally by: ieniemienie

---

Edited by: ieniemienie on 21/02/2007 07:50:06

Originally by: Chruker

---

Edited by: Chruker on 20/02/2007 09:43:29

Originally by: ieniemienie

---

Would it be possible to calculte the AU distance between jumpgates in a solar system using the data files?

Somehow eve is able to calculate them
but im not been able to figure it out yet.

---

You want to query the table mapDenormalize with solarSystemID = the system of your choice and groupID = 10 (10 is the stargates group from invGroups). Ex:

SELECT * FROM mapDenormalize WHERE itemName LIKE '%Stargate%' LIMIT 10

The x, y, z columns in the table are the stargates position relative to the star. Now with the locations you can calculate the distancies.

---

done that, thanks
Now i have the xyz locations of the stargates
The sun allways is at 0.0.0

But but how do I translate the x y z to distances in KM or AU?

And if i can find the distance between the sun and the gates from that... how could i calculate the distance between the gates? Only if the angle between the lines is 90degrees i could use Phytagoras. In all other cases i need to know the ange between the lines from the sun to the gates.

aka..
Im still a little lost, but LOVE to learn from you gurus if theres a way.

---

Originally by: Chi Prime

---

I am looking for a way to automatically display a character's image on a forum, and would thus like to map names (e.g. "kieron") to their ID (e.g. "146409153") to form the URL to the image server (e.g. "http://img.eve.is/serv.asp?s=64&c=146409153").

As far as I can tell, no such info is found in the export, and I have been unable to find info regarding any webservice etc providing this translation (from char name to ID). Help would be much appreciated

---

Originally by: Sazumaan Johnza

---

Originally by: Dal Rath

---

Ok thanks but how do I convert something like this:

INSERT INTO dbo.TL2MaterialsForTypeWithActivity
(typeID,activity,requiredTypeID,quantity,damagePerJob)
VALUES(12821,3,11459,1,0.65);

into:

X Noxcium required for Y Module...

dbo__TABLES.sql doesn't seem to contain TL2MaterialsForTypeWithActivity so I can't figure out which other tables the typeID is pulled from (then I could get a Description referencing typeID and see what module it is) and neither for requiredTypeID, then I could figure out what material this is (eg. Nocx)

You know what I mean?

---

For an overview of how the table fields relate together you can look at this page: http://games.chruker.dk/eve_online/datadump.php

But anyway typeID and requiredTypeID are both related to the table invTypes.

Also the entry you are listing in the above post, is for 'Time Efficiency Research' (activity = 3). You'll want to query for entries regarding 'Manufacturing', which has activity = 1.

And finally to get the amount of nocxium you would actually need, you need to run the quantity number from the table through this formula:
[excel]=ROUND(quantity*((1+(bpo_ml0_waste_factor/(1+bpo_ml)))+(0,25-(0,05*your_production_efficiency_skill))); 0)[/excel]
-----
CCP: Please make ship loot to drop in a can next to the wrecks. Edit: On the test server you can now salvage wrecks with loot. After a succesfull salvage the loot is left in a jetcan.

Originally by: Dacen Chilar

---

I worked myself through the data and some questiona rise.

first: how are the related ships(Ferox->Nighthawk,Vulture; Raven->RavenNavyIssue,Corvus) connected in the database?

---

Originally by: Dacen Chilar

---

second: can i seperate the attributes as shown on eve-online.com (seperate in Shield, Armor, Sensor and so on)

---

Originally by: CptDelta

---

hehe thx, its was very late yesterday, i forgot the a array index starts at 0 not at 1.. blame me ...

---

Originally by: Dacen Chilar

---

I want to seperate the attributes like shown on eve-online.com. There you have the shield relevant stuff as a group together and the armor stuff together and the propulsion stuff. is there any ID which specifies these groups?

---

Originally by: Asura Siddartha

---

Originally by: Chruker

---

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

---

If anyone grabs the ZIP there, you might want to edit the .sql file as there are multiple case mis-matches between the CREATE and INSERT statements that caused problems (for me at least) as well as making tables that don't match "the standard"

---

Originally by: Shpion

---

Originally by: Chruker

---

So a week or two ago I finally got so tired of the out-of-date data dump, that I pulled myself together and updated it. And here it finally is:
http://games.chruker.dk/eve_online/datadump.php

The complete dump is from a MySQL 3.23.xx database. That file contains the old MySQL import I had made and the changes.

The changes file, is all the changes that I could spot and fix between the last CCP export and todays game.

---

Great effort there Chruker,
Althought I am having difficulty extracting the http://games.chruker.dk/eve_online/files/dbo_20070420.zip that your Updated MySQL Dump link refers to. I have tried downloading it quite a few time to be sure, but every time I try to extract I get an error saying that the archive is corrupt or incomplete. Could you please verify that it is valid on your end?
Thanks

---

Originally by: Asura Siddartha

---

Does this have the case discrepancy between table CREATE and INSERT statements? Still downloading it, jut wondering if I have to do a search / replace on it.

---

Originally by: Shpion

---

Thanks mate, latest trial version of WinRar did work for me. Previously I tried extracting with WinAce as well as the Windows Compressed folders function, both of which supposed to work with zip files, but I guess they use different implementation of it.

---

Originally by: Vessper

---

is missing an "e" in the x-coord (should be -2.65590e+012). Not a big issue but just thought I'd mention it if you wanted to correct it for anyone else.

---

Originally by: Dusky Shark

---

Any chance of getting up-to-date database dump ?

---

Originally by: Raquel Smith

---

Originally by: Chruker

---

Edited by: Chruker on 03/06/2007 11:33:44

Originally by: Dusky Shark

---

Any chance of getting up-to-date database dump ?

---

You mean like this one? http://oldforums.eveonline.com/?a=topic&threadID=512512

---

Is that official?

---

Originally by: HoRnY CoRnY

---

anyone know when the next datadump is due out, one with all the new shiney bits from revelations 2

---

Originally by: The Locksmith

---

Do the ID's, particualrly "typeID" change between versions / dumps? I ask since some of the items have fairly contiguous numbering and newer items such as the new Battlecruisers have a high number indicating their recent additions, then there are items which have been in game for a long time that have high numbers suggesting that when they are modified they get assigned a new typeID value. Are these are an IDENTITY in SQL, AKA Autonumber, AutoIncrement etc in other DB's? My main concern is that if they are subject to change it is a big consideration in any database or application design as one would need to update them with every EVE augmentation.

---

Originally by: The Locksmith

---

Also where can I find the "regionID" numerical values 10000xx etc?

---

Originally by: The Locksmith

---

I know many of you will simply think 'why not just use the SQL database for your application?' and you would be completely correct that would be the most logical and time efficient, but I am trying to expand my knowledge of databases using an app I am familiar with first, MSAccess, before taking a dive into SQL and it's language. By looking at the dump data structure I can make simpler tables etc that will work for my needs and moreso because I built them, I stand a much better chance of understanding them. As a lady once said 'if the world was a logical place, men would ride side saddle'

---

Originally by: BarmaLINI

---

Originally by: Chruker

---

Originally by: HoRnY CoRnY

---

anyone know when the next datadump is due out, one with all the new shiney bits from revelations 2

---

Read the reply two position above your own post

---

and?

we have end of week yesterday, plz never write if you dont know about

---

Originally by: BarmaLINI

---

no - i dont wish that you keep mouths shut, i wish that export db i can see after patch in 1 day, and i need official answers, and no rumors, i think you wish the same, but we have lazy t20, and in this moment we have Garthagk

---

Originally by: Maverick Ice

---

Yes, inquiring minds want to know...where is the official announcement and why did Chruker get first knowledge of this?

---

Originally by: 0 Stiff

---

How to retrieve the asteroid types(ore) available in a system or in a asteroid belt?

I can't find this information in the mapDenormalize table...

Thx a lot.

---

Originally by: DPSLogistics Mike

---

Originally by: 0 Stiff

---

Originally by: Chruker

---

It isn't there. You have to go with a combination of system security status and faction.

---

Where I can find algorithm for calculating what minerals/ore are available in a system? (I didn't find it on your site).

Thx a lot.

---

function GetOreList($security_class) {
...snip...

---

Originally by: 0 Stiff

---

Howto get list of required skills (with level) for R&D Agent?

---

Originally by: Jack Toad

---

Any chances to get dump of minerals info for BPO's?

---

Originally by: Jack Toad

---

Another questions:
- where I can get activities names? ('activity' column of TL2MaterialsForTypeWithActivity)
I determined that 1 - Manufacture, 8 - Invention, but what about others?

---

Originally by: Jack Toad

---

- Your EVE Math page: 'Blueprint Material Requirement' formula has Default_Blueprint_Waste_Factor. Is it raw value from DB or something like 0.1 or what?

---

Originally by: 0 Stiff

---

How to retrieve ice list available in a system?

---

Originally by: 0 Stiff

---

Originally by: Chruker

---

That info isn't in the database dump.

---

then, where he took it? http://www.fluidorbit.co.uk/

---

function getIceOre($securityClass) {
$matrix = array(
"C"=> "White Glaze",
"D1"=> "Blue Ice",
"D3"=> "Blue Ice, Glare crust",
"H7"=> "Krystallos, Pristine White Glaze",
"J"=> "Dark Glitter, Glare crust, Thick Blue Ice",
);

if (array_key_exists($securityClass, $matrix)) {
return $matrix[$securityClass];
} else {
return "Unknown";
} 
}