Pages: 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14 .. 14 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 3 post(s) |
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.01.13 22:58:00 -
[181]
Edited by: Raquel Smith on 13/01/2007 22:59:33 It seems some corporations aren't in the dump: id=150072611, for starters. Reference in staStations:
INSERT INTO staStations (stationID,security,dockingCostPerVolume,maxShipVolumeDockable,officeRentalCost, operationID,stationTypeID,corporationID,solarSystemID,constellationID,regionID, stationName,x,y,z,reprocessingEfficiency,reprocessingStationsTake, reprocessingHangarFlag) VALUES(60014922,500,0,50000000,0,47,12295,150072611,30004059,20000593,10000051, '9-4RP2 IV - Moon 2 - Cloning Outpost',878666588160,175879741440, -1675383644160,0.5,0.025,4);
(This query has been formatted for your screen.)
Edit: With some bash-fu here's a list of corporation IDs that aren't in the corporation table:
1000173 doesn't exist in crpNPCCorporations 144684705 doesn't exist in crpNPCCorporations 144693213 doesn't exist in crpNPCCorporations 144719292 doesn't exist in crpNPCCorporations 150001295 doesn't exist in crpNPCCorporations 150020944 doesn't exist in crpNPCCorporations 150072611 doesn't exist in crpNPCCorporations 150087495 doesn't exist in crpNPCCorporations 150094093 doesn't exist in crpNPCCorporations 150134971 doesn't exist in crpNPCCorporations 150151670 doesn't exist in crpNPCCorporations 150158528 doesn't exist in crpNPCCorporations 150217957 doesn't exist in crpNPCCorporations
These are all referenced in staStations.
|
Colonel Jinx
TARDZ Gods of Night and Day
|
Posted - 2007.01.14 04:22:00 -
[182]
This is frustrating, icons promised a day after a release, I really want to update my killboard for the new ships! Can we get the icons please!
|
Nuska
Amarr Imperial Academy
|
Posted - 2007.01.15 08:05:00 -
[183]
Edited by: Nuska on 15/01/2007 08:02:40 If someone could post a step-by-step detailed "how to import this data into mssql 2005 express edition", I would be thankful (and send some isk your way too). Thanks in advance!
Edit: I have downloaded the files listed in the devblog post at http://myeve.eve-online.com/devblog.asp?a=blog&bid=406
|
Lord Alderaan
|
Posted - 2007.01.15 14:05:00 -
[184]
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
|
Posted - 2007.01.15 14:31:00 -
[185]
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
|
Posted - 2007.01.16 14:14:00 -
[186]
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 -
[187]
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
|
Posted - 2007.01.17 08:56:00 -
[188]
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 Aliastra
|
Posted - 2007.01.17 09:50:00 -
[189]
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). I do not suffer from insanity... I enjoy every minute of it. |
Vessper
Indicium Technologies
|
Posted - 2007.01.17 10:36:00 -
[190]
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 Imperial Academy
|
Posted - 2007.01.19 08:36:00 -
[191]
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 -
[192]
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 -
[193]
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 Aliastra
|
Posted - 2007.01.19 23:36:00 -
[194]
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 __ UI Overhaul Eve Links http://oldforums.eveonline.com/?a=topic&thread |
Dunedon
|
Posted - 2007.01.20 00:44:00 -
[195]
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 -
[196]
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 -
[197]
I've written a little linux mySQL installer/patcher for the Database files. Hope this helps some of you having problems.
http://www.jedzia.de/evedb/mysql-evedb.tar.gz
Feel free to change anything you want in it
over and out, Jedzia
|
DHU InMe
Gallente Aliastra
|
Posted - 2007.01.21 17:27:00 -
[198]
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 "" __ UI Overhaul Eve Links http://oldforums.eveonline.com/?a=topic&thread |
Jedzias Miezekatze
|
Posted - 2007.01.21 23:43:00 -
[199]
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
|
Posted - 2007.01.22 00:25:00 -
[200]
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 Inner Void
|
Posted - 2007.01.23 08:53:00 -
[201]
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. ----- MLCalc Creator HW2/EVE Mod Team Leader |
Chruker
|
Posted - 2007.01.23 11:39:00 -
[202]
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 Inner Void
|
Posted - 2007.01.23 20:10:00 -
[203]
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. ----- MLCalc Creator HW2/EVE Mod Team Leader |
Fubar
Amarr Eagle Eye Inc.
|
Posted - 2007.01.24 20:31:00 -
[204]
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
|
Posted - 2007.01.25 05:56:00 -
[205]
One other thing...
There are duplicate entries in invtypes: typeid (18034,17569) "Serpentis Light Missile Battery"
|
Zatch
Gallente Inner Void
|
Posted - 2007.01.25 08:03:00 -
[206]
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.) ----- MLCalc Creator HW2/EVE Mod Team Leader |
Mal Loc
|
Posted - 2007.01.29 08:44:00 -
[207]
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!
Please resize image to a maximum of 400 x 120, not exceeding 24000 bytes, ty. If you would like further details please mail [email protected] - Cortes |
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.01.30 17:54:00 -
[208]
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 -
[209]
Looking forward to an updated datadump.
And eventually some icon images. ----- CCP: Please make ship loot to drop in a can next to the wrecks. |
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.02.01 04:24:00 -
[210]
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.
|
|
|
|
|
Pages: 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14 .. 14 :: one page |
First page | Previous page | Next page | Last page |