Pages: 1 2 [3] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 9 post(s) |
Azia Burgi
Caldari Science and Trade Institute
|
Posted - 2008.08.05 15:41:00 -
[61]
What units have been used for the following: mapCelestialStatistics.orbitPeriod mapCelestialStatistics.rotationRate mapCelestialStatistics.pressure
Any sensible suggestions?
Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery |
|
CCP Prism X
Gallente C C P
|
Posted - 2008.08.05 16:30:00 -
[62]
I believe the units are accessible through ing-game celestial info as well as in eveUnits. I'm not at work though so I can't confirm it (and this is a fairly fresh machine so I can't VPN) and honestly I don't think I've ever given it any real thought
~ Prism X EvE Database Developer Relocating your character to a cozy, secure container since 2006. Relocating your cozy, secure container to the EVE cemetery since 2008. |
|
Azia Burgi
Caldari Science and Trade Institute
|
Posted - 2008.08.05 17:20:00 -
[63]
Originally by: CCP Prism X I believe the units are accessible through ing-game celestial info as well as in eveUnits. I'm not at work though so I can't confirm it (and this is a fairly fresh machine so I can't VPN) and honestly I don't think I've ever given it any real thought
I appreciate that you are at home i don't expect a reply until you are in the office, but I expect a reply at 09:05!
Ingame pressure is listed as "very low" or "low". in the export it is listed as a figure. I'll assumed that this figure is MegaPascals, because that is the only unit type that refers to pressure.
if orbitPeriod is seconds then there is a problem because i get a vastly different figure (when converting it to days) to what the game claims. i used orbitPeriod/60/60/24.
rotationRate... is this rad/sec? does it refer to the planet rotating on its axis or to the planet orbiting the parent star?
You also have some very lowgrav gas giants.
other than that great export! hope you had a great holiday too btw (do we get to see the snaps?).
Azia
PS: the cemetery is running out of space... anything you can do? Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery |
Rexthor Hammerfists
The Movement
|
Posted - 2008.08.07 09:57:00 -
[64]
excuse me my ignorance as i have no idea about all this, id appreciate a simple answer for my simple mind ;) - will this make local checking programms possible again? -
Any good reason for gateguns shooting drones and thus removing dronebased ships from pirating?
|
Vessper
Indicium Technologies
|
Posted - 2008.08.07 12:38:00 -
[65]
Originally by: Rexthor Hammerfists excuse me my ignorance as i have no idea about all this, id appreciate a simple answer for my simple mind ;) - will this make local checking programms possible again?
Nope - the export is static data on items, ships, materials, map information and so on, there's no real-time data that can be retrieved from this.
- - -
EveHQ Character App | Item Database |
Nelix Trist
Caldari Nostromo Industries
|
Posted - 2008.08.07 15:12:00 -
[66]
So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information? Emm?"Cant touch this" den der der dum, der dum der dum KILLING THE BUG'S, BEFORE THEY KILL YOU |
Azia Burgi
Caldari Science and Trade Institute
|
Posted - 2008.08.08 00:35:00 -
[67]
Edited by: Azia Burgi on 08/08/2008 00:37:13
Originally by: Nelix Trist So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information?
the advantages? the most up-to-date data straight from CCP towers.
the applications you need are listed on in the devblog. However seeing you asked nicely you need: MS SQL Server Express 2005 http://go.microsoft.com/fwlink/?linkid=65212 This is the "framework" which allows you to host MSSQL databases off your local machine.
SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110 This lets you manipulate the database in a graphical way, similar to MS Access.
I can create an Access version if you are more comfortable using that.
edit: darn links Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery |
Chruker
|
Posted - 2008.08.08 01:18:00 -
[68]
Originally by: Althea Nar'agh Am using 64x64 icons and have unpacked: EmpyreanAge_1.0_img_icons.zip EmpyreanAge_1.0_img_types_dx9.zip
Shiptypes / 32x32 : 232 files Shiptypes / 64x64 : 346 files
The archives I've downloaded just have the 232 files in all the Shiptypes/sizes. Did you delete the your existing files first? And 29266.png is also present in all 4 sizes.
Quote: Icons / 16x16 : 1604 files Icons / 32x32 : 1092 files Icons / 64x64 : 964 files
There are several icons that are only in 16x16 sizes, so it doesn't make much sense enlarging those. You can see the icon sheets if you extract the iconXX.dds files using TriExporter. I haven't checked if the sheets have the same icons in different sizes or if they are just scaled by the client when generating the icons.
And an additional comment to the files: EmpyreanAge_1.0_img_types_dx9.zip contains the directory with 2095 blueprint icons from EmpyreanAge_1.0_img_blueprints.zip effectively bloating the _dx9.zip file by 16 mb
Finally to reiterate. All the rendered icons in EmpyreanAge_1.0_img_types_dx9.zip and EmpyreanAge_1.0_img_types_dx8.zip are blurry. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Speedup IGB table rendering |
Althea Nar'agh
StarHunt Fallout Project
|
Posted - 2008.08.08 07:19:00 -
[69]
Edited by: Althea Nar''agh on 08/08/2008 07:20:59 hm Chruker thanks... and the extraction was in a separate path so...
anyhow i'll try again see what comes out...
EDIT: i actually downloaded the zips from eve-id so maybe my issue comes from there...
War. War never changes.
Training Monitor / iMonitor / iCEO iPOS iHelp |
Nelix Trist
Caldari Nostromo Industries
|
Posted - 2008.08.08 09:06:00 -
[70]
Originally by: Azia Burgi Edited by: Azia Burgi on 08/08/2008 00:37:13
Originally by: Nelix Trist So to be rather blatent... Now that we have this, what are the advantages and what applications can I get to make use of this information?
the advantages? the most up-to-date data straight from CCP towers.
the applications you need are listed on in the devblog. However seeing you asked nicely you need: MS SQL Server Express 2005 http://go.microsoft.com/fwlink/?linkid=65212 This is the "framework" which allows you to host MSSQL databases off your local machine.
SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110 This lets you manipulate the database in a graphical way, similar to MS Access.
I can create an Access version if you are more comfortable using that.
edit: darn links
Thanks for that reply. I'm not realy too up on all this SQL stuff nor Access. I've never had an eye for Databases.
Sounds good though, the applications that some people could make out of this. Would be very helpfull. Emm?"Cant touch this" den der der dum, der dum der dum KILLING THE BUG'S, BEFORE THEY KILL YOU |
|
iulixxi
Dracula Order Hydra Alliance
|
Posted - 2008.08.09 11:57:00 -
[71]
Edited by: iulixxi on 09/08/2008 11:58:35 I also noticed some things are missing from this dump, for example: tables stastations and mapdenormalize are missing the stations from stationID 61000001 to 61000201 - thats 200 stations. In http://api.eve-online.com/eve/ConquerableStationList.xml.aspx they are listed but not in the data dump. What happend ? Some conquerable station are listed (60014861 to 60014928) and some are not ...
Also my first post must have been missed some how (or ignored) so I will ask again: Will we have a data_map icons any time soon ? (Black rise region/constellation and systems, also some systems from the last data_map are missing).
Thanks, Iulian
|
Gut Punch
The Dead Parrot Shoppe Inc.
|
Posted - 2008.08.10 14:47:00 -
[72]
Prism X:
Is is just me or did you guys change the list of items dump to include less of the base prices? Some of them are there but base prices available in the last dump aren't there now.
|
Sky Grunthor
Minmatar The Dead Parrot Shoppe Inc.
|
Posted - 2008.08.10 14:48:00 -
[73]
Where are the png's for the militia ranks?
The ones provided in the Dev Blog aren't any good because you didn't leave the background as transparent.
And they aren't in any of the image data dumps. Search: Sky Grunthor |
Fortuna Cournot
Caldari Special Unit Omega Kraftwerk.
|
Posted - 2008.08.12 14:24:00 -
[74]
Thank you for the data export!
I am missing some information, perhaps someone can help or explain what to do to obtain it.
There are 80 products where i miss activities in the dump files. There are blueprints to build these activities, and there are bluprints where the products are used in other activities to build.
Example Question: How to build a Capital Armor Plates ???
Thank you!
Appendix:
To get a list of Products some SQL:
SELECT t.typeName RequiredMaterial FROM invtypes t JOIN typeactivitymaterials tam1 ON tam1.requiredTypeID = t.typeID JOIN invblueprinttypes bpt ON tam1.typeID = bpt.productTypeID JOIN invblueprinttypes bpt2 ON t.typeID = bpt2.productTypeID JOIN invtypes t2 ON bpt.blueprintTypeID = t2.typeID WHERE NOT EXISTS (SELECT tam2.typeID FROM typeactivitymaterials tam2 WHERE t.typeID = tam2.typeID) GROUP BY t.typeID ORDER BY t.typeName;
There are 1823 Activites defined where these 80 products are used. Some SQL to fetch them:
SELECT t.typeName RequiredMaterial, tam1.quantity, t2.typeName Blueprint FROM invtypes t JOIN typeactivitymaterials tam1 ON tam1.requiredTypeID = t.typeID JOIN invblueprinttypes bpt ON tam1.typeID = bpt.productTypeID JOIN invblueprinttypes bpt2 ON t.typeID = bpt2.productTypeID JOIN invtypes t2 ON bpt.blueprintTypeID = t2.typeID WHERE NOT EXISTS (SELECT tam2.typeID FROM typeactivitymaterials tam2 WHERE t.typeID = tam2.typeID) ORDER BY t2.typeName;
Some of the Products with missing build activities:
Antimatter Reactor Unit; Capital Antimatter Reactor Unit; Capital Armor Plates; Capital Capacitor Battery; Crystalline Carbonide Armor Plate; Deflection Shield Emitter; Electrolytic Capacitor Unit; Emp Pulse Generator; Fernite Carbide Composite Armor Plate; Fusion Reactor Unit; Fusion Thruster; Gravimetric Sensor Cluster; Graviton Reactor Unit; Ion Thruster; Ladar Sensor Cluster; Linear Shield Emitter; Magnetometric Sensor Cluster;
------ ineve.net Character Skill Showroom My EVE Link Collection |
WolfSinger SilverShadow
Gallente
|
Posted - 2008.08.12 16:41:00 -
[75]
I have to agree with a lot of the other people here. This should not have been released in only in a Microsoft proprietary format. Doing so prevents people using the MAC and Linux game clients from accessing this data without getting a Windows machine involved in the process somehow.
Yes, itÆs true that several fan sites released text-based SQL versions of the database within a few hours, but we shouldnÆt need to depend on that. On top of that, this also makes their releases unofficial û data could have been changed either accidentally or maliciously, etcà At least if you guys release an SQL version, it can be trusted 100%
DonÆt get me wrong here. We definitely appreciate the release of this data, but releasing it that way just adds extra steps for those of us who need it for a non-MS server û we either need to figure out a way to convert it ourselves, or wait for an unofficial conversion. As it is, I probably wasted about 3 hours getting SQL Server Express loaded, figuring out just how to load a .BAK file since I never used SQL server before, then wasted some more time trying to figure out a way to get the data exported and over to my Linux Web/MySQL server. Once someone released the .SQL version, it took me about 5 minutes to get it loaded successfully.
Please consider this when you get ready to release the next one.
But like I said, we do appreciate the data. As it is now, IÆve written a personal PHP/MySQL program to help me calculate blueprint efficiencies and research, and it figures out how much it costs to make items based on prices from eve-central. I wouldnÆt mind releasing to the general public if my poor little server and internet bandwidth could handle it.
My next project: a refining/reprocessing calculator. Looks like you can get the results for modules and such from the typeActivityMaterials table. Batch size corresponds to invTypes.portionSize, but where is the refining reults info for ore, ice, and refinables? IÆve found some charts on fan sites that list this info, but IÆve also found errors (did the refining results for Glossy Compound change at some point?) Either IÆm not seeing it, or that data table just isnÆt included.
Any help here would be appreciated.
|
Glengrant
TOHA Heavy Industries
|
Posted - 2008.08.22 10:51:00 -
[76]
Edited by: Glengrant on 22/08/2008 10:52:09 Thanks for releasing the data and for thinking about how to make this more readily available from now on.
But using MSSQL backup (as the sole format) is a terrible idea.
SQL Server doesn't run on Linux: http://appdb.winehq.org/objectManager.php?sClass=application&iId=7218
So that's fairly annoying to those amongst us who said good bye to windows.
Besides that even the majority of windows players won't use MSSQL for anything beyond getting the data from the backup as they have to upload to MySQL DBs on their webspace or use it sqlite or similar for offline tools. I don't see anybody here paying for SQL Server 2k5 licenses.
Sure - somebody is likely nice enough to convert and publish in short order. And it's not that hard - which begs the question why CCP is not doing so themselves.
I'm using MSSQL at work every day and also do plenty of exports - many of them get automated. It's fairly easy to dump data from MSSQL into a variety of formats (actually any conceivable format). Obviously I have insufficient info about the particular Eve DB - but what is so damn complicated about creating an automated export of some tables (possibly filtering some columns players aren't supposed to see) into a universally usable format (eg CSV with ASCII 1 as delimiter or some such)?
But even better - why not create a read-only cache database with the data from the dumps that's publicly available? Similar to what you are already doing with the eve api. That would not only solve all problems regarding formats but also save most community eve web apps from having to import all that data and keeping it up-to-date. I assume that the bandwith and server demands would be a negligible tiny fraction of what CCP uses for Eve anyway.
Thanks for listening
--- ISK BUYER = LOOSER EVE TV- Bring it back!
|
Buildius Maximus
|
Posted - 2008.09.03 13:12:00 -
[77]
And where is the new updated export now that we have had a major patch?
|
|
CCP Explorer
|
Posted - 2008.09.04 22:52:00 -
[78]
Originally by: Buildius Maximus And where is the new updated export now that we have had a major patch?
See here.
Erlendur S. Thorsteinsson Software Director EVE Online, CCP Games |
|
|
CCP Prism X
Gallente C C P
|
Posted - 2008.09.05 15:47:00 -
[79]
I seem to managed to give you an empty invControlTowerResourcePurposes again. Apologies for that. I believe a new dump will go up soon with that included but if you are impatient here are the inserts in T-SQL:
INSERT INTO invControlTowerResourcePurposes VALUES (1,'Online') INSERT INTO invControlTowerResourcePurposes VALUES (2,'Power') INSERT INTO invControlTowerResourcePurposes VALUES (3,'CPU')
As to the format: We can go over this ad infinitum. Some people prefer this, others prefer that. I'm not saying we'll never include any other format, I'm just saying that's not a priority and I'm not promising anything. I understand that some people have issues with using MS formats just like I have issues with MySQL pre-5.0 and everyone has their preference for anything.
At least we're releasing them when we know the static data of every expansion is stable. That must account for something, no? |
|
burning raven
omen. Triumvirate.
|
Posted - 2008.09.05 21:05:00 -
[80]
Originally by: CCP Prism X I seem to managed to give you an empty invControlTowerResourcePurposes again. Apologies for that. I believe a new dump will go up soon with that included but if you are impatient here are the inserts in T-SQL:
INSERT INTO invControlTowerResourcePurposes VALUES (1,'Online') INSERT INTO invControlTowerResourcePurposes VALUES (2,'Power') INSERT INTO invControlTowerResourcePurposes VALUES (3,'CPU')
As to the format: We can go over this ad infinitum. Some people prefer this, others prefer that. I'm not saying we'll never include any other format, I'm just saying that's not a priority and I'm not promising anything. I understand that some people have issues with using MS formats just like I have issues with MySQL pre-5.0 and everyone has their preference for anything.
At least we're releasing them when we know the static data of every expansion is stable. That must account for something, no?
You rock my world, you are my saviour! Do you belive in destiny?
|
|
Z010
|
Posted - 2008.09.07 11:45:00 -
[81]
Originally by: CCP Prism X
At least we're releasing them when we know the static data of every expansion is stable. That must account for something, no?
Yes, at least we are not discussing when the next release will be! So, I'll learn some new tricks, or wait the two hours, or 24 hours for it to be a format I can use.
Thanks Prism - for giving us something unimportant to complain about! |
WolfSinger SilverShadow
Gallente Caldari Deep Space Ventures
|
Posted - 2008.09.16 16:37:00 -
[82]
Still haven't seen anyone post about a MySQL realease of the 1.1 database, so I gave it a shot myself. Not even on EveDEV Network, and those guys are usually on the ball.
Only took me about a week to figure out how to get MS Server SQL express installed, configured to accept connections, and then loaded wite DB dump
Took another week to figure out that the converter I was using was messing up the table schema, making some fields too small. Got aroud this by setting all SMALLINT and TINYINT fields to just straight INT.
All time I would have much rather spent PLAYING Eve.
I uploaded the file to eve-files: http://dl.eve-files.com/media/corp/wolfsinger/eveEmpy11mySQL.zip
Does not include foreign keys.
Please give me some feedback on how I did. If I mucked something up, I'll try to fix it.
|
Cpt Bunny
Gallente War inc
|
Posted - 2008.12.01 16:59:00 -
[83]
hi guys,
im working on a little market app, its a ms access DB, but im having problems getting the raw sql data imported, i dont know that much about sql tbh,
would anyone be able to help me aout with csv or even an access version of the raw data ? would be happy to provide them with versions of my system once its running.
thanks in advace
|
|
CCP Fallout
|
Posted - 2008.12.01 19:16:00 -
[84]
Originally by: Cpt Bunny hi guys,
im working on a little market app, its a ms access DB, but im having problems getting the raw sql data imported, i dont know that much about sql tbh,
would anyone be able to help me aout with csv or even an access version of the raw data ? would be happy to provide them with versions of my system once its running.
thanks in advace
Your best bet is to make an inquiry in our Tech Lab channel, if you've not yet done so.
Fallout Associate Community Manager CCP Hf, EVE Online
|
|
Mariokoli Mianana
Gallente Cloak and Daggers Ocularis Inferno
|
Posted - 2009.02.11 17:59:00 -
[85]
Originally by: CCP Prism X
Why is crpNPCCorporationTrades missing? Well, it should really never have been included. This is basicaly meta-data and could allow people to get an advantage they couldn't otherwise get in game. Something like finding out what is being sold in regions they've never been in would be a good example. Finding the best possible trade routes through some datamining would be another. I'm sorry if the mismatch has wasted anyones time.
Blargh! I miss some of this information, but more for the silly trivia reasons, a la my "NPC Supply and Demand Revealed" post. In fact, while that post was little seen, I have an inkling that my post may have reveled some of the interesting information one could get from that table and led to its removal from the data dump...
Still, I think that it should be more or less public knowledge what each NPC corporation is willing to buy and sell.
|
Mariokoli Mianana
Gallente Cloak and Daggers Ocularis Inferno
|
Posted - 2009.02.11 18:13:00 -
[86]
Originally by: Azia Burgi What units have been used for the following: mapCelestialStatistics.orbitPeriod mapCelestialStatistics.rotationRate mapCelestialStatistics.pressure
Any sensible suggestions?
I've found that orbitPeriod and rotationRate are very likely in tenths (1/10) of a second. Pressure is in cPa or hundredths (1/100) of a Pascal. Values less than 10 Pa (1000 in the DB) are listed as "Very Low".
These values are converted to days/hours and kPa respectively before being displayed.
|
Kendoori Jinwah
|
Posted - 2009.03.28 10:39:00 -
[87]
I've just imported the .bak database and noticed something that was not exported and don't know if it was left out intentionally, but the relationships between tables are not there. I'm going through and creating them each so when I pull up a data diagram, it's a little more concise as to what goes where. The ID labels are labeled nicely enough for me to figure it out but others might not.
I don't think the EVE databases would not have relationship constraints so these relationships should be included as it helps first time users quickly identify what relates to what.
Also, is there any way to determine where the current character is (Region/Constellation/Solar System) either using the API or some other method? I am starting to write a tool for keeping track of corp/alliance intel for solar systems and when a user reports intel, I'd like the utility to auto populate the solar system with the one the person repoting the intel (user) is currently in.
Is this possible?
Thanks for the data.
|
|
|
|
Pages: 1 2 [3] :: one page |
First page | Previous page | Next page | Last page |