EVE Search - EVE Data Export, REVELATIONS Edition and Dev Blog

All Channels

EVE Information Portal

EVE Data Export, REVELATIONS Edition and Dev Blog

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

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)
Gentzen Amarr	Posted - 2007.03.20 05:23:00 - [271] I wrote a simple python script which convert export sqls to MS SQL Express 2005 import file. http://dl.eve-files.com/media/0703/eveexport2mssql.py.txt what this script do is: - insert 'use eve;' for every tables. - insert 'SET IDENTITY_INERT hogehoge' things for every tables. - convert 'true' to '1', 'false' to '0' - delete 'COMMIT;' - convert 'dbo_' to 'dbo.' - insert 'GO' for every 40000 lines
BarmaLINI Caldari PsiCorp	Posted - 2007.03.21 09:01:00 - [272] sorry, after Revelation 1.4 patch you planned to publish new DB export + images? --------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more
Chruker	Posted - 2007.03.21 12:09:00 - [273] Yeah, make t20 or his replacement work overtime to get this out :-) ----- 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.
Asura Siddartha	Posted - 2007.03.26 22:16:00 - [274] 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 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"
Chruker	Posted - 2007.03.27 11:35:00 - [275] 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" Are you sure that you grabbed the MySQL file on the page and not the original file? If it was the right file, can you tell me which mis-matches, so that I can fix them. Also what do you mean by that they are not matching 'the standard' Finally, what version of the database server are you using. ----- http://games.chruker.dk/eve_online ----- Top 3 wishes: 1: No daily downtime. 2: Updated dump of the database. 3: An update of the ingame browser, to fix ex: slow tables.
BarmaLINI Caldari PsiCorp	Posted - 2007.03.28 12:02:00 - [276] kieron, t20 - can you answer in this thread? any chanse for new Data Export? images? icons? --------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more
Asura Siddartha	Posted - 2007.03.28 15:18:00 - [277] Originally by: Chruker Are you sure that you grabbed the MySQL file on the page and not the original file? If it was the right file, can you tell me which mis-matches, so that I can fix them. Also what do you mean by that they are not matching 'the standard' Finally, what version of the database server are you using. I grabbed the zip from here: http://games.chruker.dk/eve_online/files/dbo_20070116.zip The dbo.sql file in there had all the table names in CREATE statements all lower case, but mixed case in INSERTS ex: 'CREATE TABLE invtypes... ' then 'INSERT INTO invTypes...' Which cause errors for me when I ran the sql file, using MySQL 5.0.24 which may be the issue. Also, thanks for your cool site and the mysql conversion. It is much appreciated.
Somatic Neuron	Posted - 2007.03.29 16:20:00 - [278] PLEASE give us the updated data/images and update the item database. ----------
Laendra	Posted - 2007.04.02 11:13:00 - [279] Give us the update or give us death. -------------------
OverKill Caldari Hadean Drive Yards Archaean Cooperative	Posted - 2007.04.03 18:22:00 - [280] Originally by: Laendra Give us the update or give us death. Agreed, give us the new data export or kill Laendra! - Building With Tomorrow's Technology, Today! Hadean Drive Yards
BarmaLINI Caldari PsiCorp	Posted - 2007.04.04 11:16:00 - [281] t20. kieron - any answer? --------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more
Vessper Black Thorne Corporation	Posted - 2007.04.05 09:25:00 - [282] Come on CCP!! It's been almost 4 months since the release of the last data export and there have been numerous patches since then. There are a lot of people in the Eve community that work hard to provide tools for others and, while we appreciate the data export in the first place, it's a shame that this isn't made a regular feature along with patch deployment. How long does it take to export the data anyway? An hour perhaps? And what happened to the so-called "Web Cell Revival"? The official item database is still (embarrassingly) out of date and we still have no updated icon data. Please, can we have at least some response as to what is happening with regards to the exports, and preferably a new export to tie us over until Kali 2. Don't make me fly to Iceland with a cattle prod
cptgone	Posted - 2007.04.05 12:10:00 - [283] Originally by: Vessper Please, can we have at least some response as to what is happening with regards to the exports, and preferably a new export to tie us over until Kali 2. +1
Chruker	Posted - 2007.04.05 18:42:00 - [284] We have been barking up the wrong tree. Read the last part of this blog: http://myeve.eve-online.com/devblog.asp?a=blog&bid=451 So we wait. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.04.05 21:36:00 - [285] Originally by: Chruker We have been barking up the wrong tree. Read the last part of this blog: http://myeve.eve-online.com/devblog.asp?a=blog&bid=451 So we wait. XML!?!?! Whose idea is it to bloat data with crappy tags?
Eewec Ourbyni Caldari	Posted - 2007.04.06 08:50:00 - [286] Originally by: Raquel Smith Originally by: Chruker We have been barking up the wrong tree. Read the last part of this blog: http://myeve.eve-online.com/devblog.asp?a=blog&bid=451 So we wait. XML!?!?! Whose idea is it to bloat data with crappy tags? Depends on how much data is in the feeds, and how much isn't (and what isn't). I'm going to sit here and wait and see what happens. This is a sig... -- You think this guys post is nuts.... you should see his bio -- ... good, ain't it!
Vessper Black Thorne Corporation	Posted - 2007.04.06 11:38:00 - [287] Originally by: Chruker We have been barking up the wrong tree. Read the last part of this blog: http://myeve.eve-online.com/devblog.asp?a=blog&bid=451 So we wait. The blog only suggests that some information will be in XML format, and that seems to be geared towards information that changes frequently such as (speculating here) alliance sovereignty, rankings etc. More akin to an RSS feed than an actual data dump I would have thought. There's no mention there of a revised data export although you might be able to imply that once the item database is updated, we could have the icon data finally. Originally by: devblog See you again in a few weeks... Well, here's hoping there's some movement on this before that time.
BarmaLINI Caldari PsiCorp	Posted - 2007.04.06 13:53:00 - [288] cool :) --------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more
Tengumai	Posted - 2007.04.15 07:12:00 - [289] 1) What do the XYZ coordinates in mapSolarSystems represent? I assumed that they were the distance from some central point in the universe, but apparently not, as very distant solar systems can have similar coordinates. 2) Whats the best way to calculate the distance between two solar systems? 3) Are there descriptions of the data export available? Thanks, tengumai
Vessper Black Thorne Corporation	Posted - 2007.04.16 01:15:00 - [290] Originally by: Tengumai 1) What do the XYZ coordinates in mapSolarSystems represent? I assumed that they were the distance from some central point in the universe, but apparently not, as very distant solar systems can have similar coordinates. 2) Whats the best way to calculate the distance between two solar systems? 3) Are there descriptions of the data export available? Thanks, tengumai 1. They are indeed coordinates, and measured from the "centre" of the galaxy. IIRC, these are measured in metres so you'll need to do some calculations to get these in km, light years or whatever. 2. Distance between two solar systems is calculated as SQRT( (x2-x1)^2 + (y2-y1)^2 + (z2-z1)^2 ) 3. No official descriptions - we just have to guess by what the field names are but TBH, most of them are self-explanatory.
snakehole	Posted - 2007.04.18 01:32:00 - [291] Either I'm blind, stupid (probably the latter) or the MySQL dump I have doesn't have the info... how do you tell how many belts / moons a solar system has?
Chruker	Posted - 2007.04.20 10:38:00 - [292] 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. ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering
Elisa Day Survey Division Interstellar Starbase Syndicate	Posted - 2007.04.20 11:21:00 - [293] Chruker for god-emperor!
Vessper Black Thorne Corporation	Posted - 2007.04.20 17:43:00 - [294] Superb work Chruker, ta very much
Shpion	Posted - 2007.04.21 17:24:00 - [295] 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
Chruker	Posted - 2007.04.22 10:13:00 - [296] 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 Hi I just re-downloaded it (using IE 6) and extracted it (using WinRAR) and it reported no errors. Which program are you downloading with and which are you extracting with? ----- http://games.chruker.dk/eve_online ----- Top wishes: - No daily downtime - Faster training on sisi - Updated data export - Speedup IGB table rendering
Tengumai	Posted - 2007.04.22 16:34:00 - [297] Hmmm... found a discrepancy between my mapSolarSystemJumps table and the current universe. Is this an error in the export, or has the galaxy changed since the export? My export does not include a jump from Ikao (30002786) to Uedama (30002768), although it is clearly there in-game. Thanks, T
Vessper Black Thorne Corporation	Posted - 2007.04.22 20:09:00 - [298] Originally by: Tengumai Hmmm... found a discrepancy between my mapSolarSystemJumps table and the current universe. Is this an error in the export, or has the galaxy changed since the export? My export does not include a jump from Ikao (30002786) to Uedama (30002768), although it is clearly there in-game. Thanks, T Ok, note the date of the export, then note the date of the dev blog that states all the jump changes. In addition, try reading 5 posts up and you'll see Chruker has taken the time to make all the changes in his excellent update. That should a) answer your question and b) fix it for you. --------------------
Asura Siddartha GoonFleet GoonSwarm	Posted - 2007.04.24 02:24:00 - [299] 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. 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. And again, thanks for your awesome MySQL versions.
Shpion	Posted - 2007.04.24 05:19:00 - [300] Originally by: Chruker Hi I just re-downloaded it (using IE 6) and extracted it (using WinRAR) and it reported no errors. Which program are you downloading with and which are you extracting with? 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. It may help the others if you either specify on your site what program to unzip it with or use the lowest common denominator implementation for zip archiving. Ta

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

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.