open All Channels
seplocked EVE Information Portal
blankseplocked EVE Data Export, REVELATIONS Edition and Dev Blog
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 3 4 5 6 [7] 8 9 10 11 ... : last (14)

Author Topic

Lord Alderaan
Posted - 2007.01.15 14:05:00 - [181]
 

I also found that some BP require negative materials for manufacturing. I looked a couple of those products up in the website Item Database and found it didn't require those materials.

Anyone know whats up with those?

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

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


Vessper
Indicium Technologies
Hephaestus Forge Alliance
Posted - 2007.01.15 14:31:00 - [182]
 

I posted earlier in this thread regarding the negative quantities issue. Basically, I have ignored any negative quantities in my calculations and these seem to tie in to the BP information ingame and in the item database.

Dunedon
Trans Nebula Inc.
Posted - 2007.01.16 14:14:00 - [183]
 

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

Colonel Jinx
TARDZ
Gods of Night and Day
Posted - 2007.01.16 16:07:00 - [184]
 

I just want to know, especially since it's over a month due for images, if i'm missing something about the icons.

For a killboard, this dump is useless. the evegraphics data is missing information for new ships, and there are no updated icons for the new ships!

Does anybody know anything about this? I'm sure i've seen a few killboards with working new images...
Can we get this sorted out? An official response would be appreciated.

zibelthurdos
Concrete Developments
LOADED CONCRETE
Posted - 2007.01.17 08:56:00 - [185]
 

I have begun a database project compiling all available knowledge about the REV sql dump

this is an access xp database, it's large.

most of the relationships are already done as are a bunch of (what i consider) useful make table queries one set is for build information

and the other is for recycling..
if you find this useful please build upon it, there is one report with some general info i started making, there are some things missing, like how to accurately compute the effect of a blueprints PE on the time waste factor. (any help here would be appreciated)

anywho, without further ado i bring you the Revelations Dump Database Project V.2


oh and if you find this reallllly useful i appreciate ingame donations

Dektor
Gallente
Nebula Rasa Holdings
Nebula Rasa
Posted - 2007.01.17 09:50:00 - [186]
 

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



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

Vessper
Indicium Technologies
Hephaestus Forge Alliance
Posted - 2007.01.17 10:36:00 - [187]
 

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


I believe it is erroneous data in the file. I did at one point think it was to do with Recycle values but disregarded this pretty quickly when there weren't enough negative quantities in the file.

Incidentally, if you check out the materials required for "activityDuplicating = 6", I have found that for a lot of T2 items, these correspond to the recycle values in the Eve item database. Doesn't work for T1 items but I have found for T1 items, the recycle amounts = manufacturing amounts anyway. Can anyone else confirm this?

Nuska
Amarr
Agony Unleashed
Agony Empire
Posted - 2007.01.19 08:36:00 - [188]
 

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

Chruker
Posted - 2007.01.19 12:35:00 - [189]
 

I'm looking for the information about which R&D agent do research in which fields.

Also I'm looking for the information about which research field can yield which blueprints. When using the search engine at http://eve-agents.com/ it looks like it is just the required skills for the bpo. But can anybody confirm this?

Ezlo Murkin
Posted - 2007.01.19 22:08:00 - [190]
 

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


I believe you can use table mapSolarSystemJumps for this. First look up the solarSystemID in the mapSolarSystems table, then select all the records in the mapSolarSystemJumps table that have your solarSystemID in the fromSolarSystemID field:

select solarSystemID from mapSolarSystems where solarSystemName = 'Jita' (returns solarSystemID of 30000142)

select toSolarSystemID from mapSolarSystemJumps where fromSolarSystemID = 30000142 (this should give the ID's of all the systems that connect to Jita)

Those should be the base tables to get started with anyways, there's also a mapJumps and mapRegionJumps table which I haven't looked at yet, they might be easier to use, not sure...

DHU InMe
Gallente
Corsairs Inc.
The Spire Collective
Posted - 2007.01.19 23:36:00 - [191]
 

Edited by: DHU InMe on 21/01/2007 17:23:22

Dunedon
Trans Nebula Inc.
Posted - 2007.01.20 00:44:00 - [192]
 

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

Chruker
Posted - 2007.01.21 11:11:00 - [193]
 

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


By plot do you then mean drawing them on a 3D map? Or is it just figuring out which systems to pass-through?

[OT]I'm no longer a ! portrait. Celebration tonight at 9pm[/OT]

Jedzias Miezekatze
Posted - 2007.01.21 12:42:00 - [194]
 

Edited by: Jedzias Miezekatze on 06/04/2007 17:42:23
I've written a little linux mySQL installer/patcher for the Database files. Hope this helps some of you having problems.

http://dl.eve-files.com/media/corp/Jedzia/mysql-evedb.zip

Feel free to change anything you want in it Very Happy

over and out, Jedzia

Edit: Url changed.

DHU InMe
Gallente
Corsairs Inc.
The Spire Collective
Posted - 2007.01.21 17:27:00 - [195]
 

Originally by: t20
Archive file updateded with missing tables + added table structure.


-SQL file lacking.
-Table creation lacking.

dbo_ramActivities.sql --no file
dbo_ramAssemblyLineStationCostLogs.sql --no file
dbo_ramInstallationTypeDefaultContents.sql --no file
dbo_mapSecurityRatings.sql --no file

dbo_invFlags.sql --table
dbo_invMetaGroups.sql --table
dbo_invMetaTypes.sql --table
dbo_invTypeReactions.sql --table
dbo_eveUnits.sql --table
dbo_chrFactions.sql --table
dbo_chrSchoolAgents.sql --table



dbo_invTypes.sql
replace all
"dbo_invTypes"
by
"dbo.invTypes"

without ""

Jedzias Miezekatze
Posted - 2007.01.21 23:43:00 - [196]
 

Edited by: Jedzias Miezekatze on 21/01/2007 23:42:32
Hi DHU InMe

the table creation is fixed in my installer, also a sed
script and a patcher is in the archive for typo correction,
the dbo_ / dbo. problem you wrote above.
It works with the original files, so it is relative small,
very small :)

Maybe someone wants to make this for windows ? ... perl ? python ? batch ? ... i dont (want to) know much about windoze :P


Raquel Smith
Caldari
Freedom-Technologies
Sev3rance
Posted - 2007.01.22 00:25:00 - [197]
 

The data dump has some very strange anomolies!

For example:

1. Some items (ALL Target Painters) have no requiredSkill1 but they have requiredSkill2
2. Cruise and Defender missiles (at least) have their "Max Velocity" (attrib_id=37) unit_id set to 11, which is acceleration ("meters per second squared"). This unit also has its "displayname" set to m/sec when it should be m/sec/sec.
3. It's curious that the ores have skill requirements, for example:

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


4. Capital Siege Array (typeid: 21039) (and all Capital parts of marketgroupid 781) have some strange typeattributes (as CCP calls them) as well:

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


What could that possibly mean? A lot of items have that moonMiningAmount attribute.

Zatch
Gallente
Death of Virtue
MeatSausage EXPRESS
Posted - 2007.01.23 08:53:00 - [198]
 

Edited by: Zatch on 23/01/2007 08:49:50
Could a dev please comment on the unusual material requirements for mining crystals? Case in point: Omber Mining Crystal I Blueprint, one of the material requirements:

INSERT INTO dbo.TL2MaterialsForTypeWithActivity
(typeID,activity,requiredTypeID,quantity,damagePerJob)
VALUES(18057,1,38,125,1);
(Nocxium: 125)

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

This issue was brought to my attention by another user (Jasmin Black) in my MLCalc thread. After Jasmin brought it up, I checked several other mining crystal blueprints and they all have the same problem. My calculations yield the correct results for every blueprint I own, though, and I do own several, which leads me to believe that either the mining crystal blueprint group was improperly exported, or the calculations work differently for the mining crystals than they do for other blueprints.

Chruker
Posted - 2007.01.23 11:39:00 - [199]
 

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



Have you tried getting a manufacturing quote for the blueprint?

Other than that, I can see that all of the Mining I crystals are marked as tech 2 level. However I don't know if that field (invBlueprintTypes.techLevel) in the database is used to decide how to print the material needs on the blueprint.

The only mining crystal that is labeled as tech 1 is this one: Arkonor Mining Crystal II Blueprint (typeID: 18591)

Zatch
Gallente
Death of Virtue
MeatSausage EXPRESS
Posted - 2007.01.23 20:10:00 - [200]
 

Edited by: Zatch on 23/01/2007 20:07:11
That's a good point about the tech level. I don't think it affects how the calculations are done, but if anybody has a tech 2 (non mining crystal) blueprint and would be willing to give me a manufacturing quote, as well as the material level of the blueprint, I would greatly appreciate it. Please EVE-mail me if you wish to keep your t2 ownership private (as opposed to posting in here.)

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.

Fubar
Posted - 2007.01.24 20:31:00 - [201]
 

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.

In manufacturing waste calculations are only performed on materials/minerals which are also received when reprocessing the build item.

Mining crystals can not be reprocessed so therefore there is no material waste when building them, neither material level nor skill level.

Another example is tech 2 ships and construction components (ie antimatter reactor units and the like). Construction components would be received if you reprocessed a tech 2 ship so waste is calculated on the construction components.

Some tech2 modules do not produce construction components when reprocessed. An example is the 1MN Afterburner II. They use the same amount of antimatter reactor units, ion thrusters, and plasma thrusters at every ME level and production efficiency skill level even when manufactured in a rapid assembly array.

Raquel Smith
Caldari
Freedom-Technologies
Sev3rance
Posted - 2007.01.25 05:56:00 - [202]
 

One other thing...

There are duplicate entries in invtypes: typeid (18034,17569) "Serpentis Light Missile Battery"

Zatch
Gallente
Death of Virtue
MeatSausage EXPRESS
Posted - 2007.01.25 08:03:00 - [203]
 

Thanks a bunch Fubar, now I can write a program to parse the relevant files and find non-researchable BPOs (researchable, but to no effect.)

Mal Loc
Posted - 2007.01.29 08:44:00 - [204]
 

Has anyone created an excel spreadsheet (or csv) detailing the mineral needs for all items that they would be willing to share?
I am looking for a basic spreadsheet with columns like:
itemName tritRequired pyeriteRequired

and one row per item in the item database. I'd love to not have to install mysql and bother with figuring out the queries to do this myself!

Thanks!

Raquel Smith
Caldari
Freedom-Technologies
Sev3rance
Posted - 2007.01.30 17:54:00 - [205]
 

Is there any SQL fragment that can provide records for these stargates/jumps:

Komo - Muvolailen
Komo - Ahynada
Laah - Aramachi
Laah - Motsu
Ikao - Uedama
Venilen - Hogimo
Hogimo - Huttaken
Ryddinjorn - Meirakulf

Don't let us down t20!

Chruker
Posted - 2007.01.31 09:17:00 - [206]
 

Looking forward to an updated datadump.

And eventually some icon images.

Raquel Smith
Caldari
Freedom-Technologies
Sev3rance
Posted - 2007.02.01 04:24:00 - [207]
 

I'm curious why Defender I (typied=265) missiles have only one launcherGroup (groupid=56) named 'Missile Launcher' associated with it. That group has two items in it:

Active Missile Defence System I (typeid=19449)
Dropship Launch Bay I (typeid=16284)

Both of these have no market categories.

However, the number of launchers that can use Defender I missiles (chargeGroup%) are numerous.

WredStorm
Posted - 2007.02.01 22:11:00 - [208]
 

I know some people are lost on how to import this data into MSSQL Express (the free version of MSSQL). I'm about 2/3 of the way through completing this process now, and here is what I ended doing (this won't be a full step-by-step, but should give you enough to figure it out, I think).

The key thing I found to importing the information was the sqlcmd program that is installed with SQL Express. The first thing I did was startup sqlcmd in interactive mode by opening a command prompt and typing:
sqlcmd -S .\SQLEXPRESS

This connected me to the copy of SQL EXPRESS running on my local computer. You'll get a prompt like this:
1>

I told it to create a new database for me by typing (I'll show the lines numbers too):
1> CREATE DATABASE EVE;
2> GO

You could change "EVE" to whatever you want to call your database. The "GO" command tells it to execute whatever SQL commands you've entered so far. Next I exited out of the interactive editor by typing "exit".

Now I started using sqlcmd in its "batch" mode, where you can feed it files. I had already downloaded and unrar'd the tables. I changed directories in the command prompt I had open so that I was in the same directory as all the files.

I opened up the file called dbo__tables using Textpad (a great text editor) and added the following line to the top of it:
USE EVE;

At the bottom of the file I added the SQL commands posted earlier in this thread (I think on page 1 or 2) for the 7 missing tables. I then saved the file. Next I entered the following command at the command prompt (again, in the same directory as all the database files I downloaded and unzipped):
sqlcmd -S .\SQLEXPRESS -i dbo__tables.sql

This tells the sqlcmd program to execute all of the SQL commands it finds in the specified file, which in this case creates all the tables you need.

Now it is just a matter of going through and making minor changes to each of the remaining files and running the sqlcmd on them with the appropriate file name.

The most important change to each of the files is to add "USE EVE;" at the beginning of each one (or change EVE to whatever you called your database). I also found that I had to change the command "COMMIT;" at the end of the files to "GO". If a file is very large (as in greater than about 2MB in size I found I had to add the word GO in between the INSERT statements every 40,000 lines or so).

Now, sometimes you'll run the sqlcmd on a file and get errors. The two error types I ran into were:
1) It would tell me that I was using the wrong column name or something like that and would indicate that "false" and "true" were not allowed. To fix this, just open the file and do a search/replace, changing "false" to "0" (that is a zero) and "true" to "1". Save the file with the changes and try again.
2) The second error would be related to not being able to INSERT when IDENTITY_INSERT is set to OFF. This has to do with trying to insert data into a field that is an auto-incrementing field. The fix for this is to open up the file and in the line after "USE EVE;" type in:
SET IDENTITY_INSERT dbo.chrBloodlines ON;
and then change the very last line of the file to:
SET IDENTITY_INSERT dbo.chrBloodlines OFF;

The key here is, change dbo.chrBloodlines to be the name of the table that is having the problem (chrBloodlines is one of the first you'll run into a problem with if you're doing the files in alphabetical order).

Don't be surprised if some of the bigger files take a long while to process. You'll see the words (1 rows affected) scrolling past your screen as sqlcmd executes each INSERT command. There may well be a better way to do all of this, but I haven't found it, and this is getting the job done. Expect it to take you about 1/2 day at least to do all of the tables (I'm guestimating, since I'm not done yet myself and have worked on other stuff too).

Hope this helps you out,
Wred

WredStorm
Posted - 2007.02.01 22:12:00 - [209]
 

Oh, as previously mentioned by someone. You may find some tables where the SQL commands reference dbo_tablename as opposed to dbo.tablename. You have to do a search/replace on those, otherwise you'll get an error kicking back saying it can't find the table specified.

Wred

Chruker
Posted - 2007.02.02 12:55:00 - [210]
 

Edited by: Chruker on 28/04/2007 01:53:21
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

EDIT:
Stuff has changed. Anyway here is a thread where I'll keep updated on my database dumps:
http://myeve.eve-online.com/ingameboard.asp?a=topic&threadID=512512


Pages: first : previous : ... 3 4 5 6 [7] 8 9 10 11 ... : last (14)

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