| Author |
Topic |
CCP kieron
 |
Posted - 2006.12.07 00:24:00 - [ 1]
t20's long awaited and much requested Revelations edition data export is discussed and available in his new Dev Blog. Read the blog, download the export and discuss it to your heart's content here. As t20 stated in the blog, use of the data in the export may not be used for any commercial applications without the express written consent of CCP Games. I was 24 minutes late, sorry t20!  |
Salvis Tallan
Gallente
Sparse Enterprises
|
Posted - 2006.12.07 00:47:00 - [ 2]
Edited by: Salvis Tallan on 07/12/2006 01:11:44
Gah! Can we have it in CSV? Please? Those of use without databases cant really used the sql as well.
*edit* yea I know its a complaint. I swear I am really happy though, Thankyou!
*edit* Thankgod for replace-all... and thanks again for the data! |
Ching Ling
Gallente |
Posted - 2006.12.07 01:02:00 - [ 3]
Am I first? Yay, and thanks! |
Andrew Gunn
Battlestars
Wildly Inappropriate. |
Posted - 2006.12.07 01:18:00 - [ 4]
Edited by: Andrew Gunn on 07/12/2006 01:18:28AWESOME! Thank's man!  t20 you are my hero. |
Mirida
Meltd0wn |
Posted - 2006.12.07 01:18:00 - [ 5]
Whew, thanks... going to crunsh some queries now... |
Nic Pyrotech |
Posted - 2006.12.07 01:25:00 - [ 6]
YAY
I meant to ask this of the previous export....
Where would one find out the high/med/low/(and now rig) position of a given item?
TIA
|
Mik Nostrebor
Minmatar
Ex Coelis |
Posted - 2006.12.07 01:28:00 - [ 7]
Edited by: Mik Nostrebor on 07/12/2006 01:30:56
Edited by: Mik Nostrebor on 07/12/2006 01:29:23
Does anyone have the SQL to create the tables? Otherwise I have to create the tables manually and guees at the data types.
Contact me at *snip* -wystler
Thnx
Mik
PS: Once I have imported the data in MS-SQL I can export to CSV and maybe even XML if you ask nicely. Contact me if you are interested.
Please do not post OOG contacts on the forums, thank you. -wystler |
Xaroth Brook
Minmatar
BIG
Majesta Empire |
Posted - 2006.12.07 01:55:00 - [ 8]
I've started a new discussion for this export Here, as kie locked the old one to have this one have a fresh start. Mailed the mods to get it moved up here as well, which might happen.. or maybe not.. who knows. Thanks, t20! |
Beatle Bones |
Posted - 2006.12.07 02:34:00 - [ 9]
Edited by: Beatle Bones on 10/12/2006 21:15:43Huzzah!  Originally by: Salvis Tallan
Gah! Can we have it in CSV?
Well I would like it in CSV too... As it happens I've knocked up a little executable to do just that. Saves all that find/replace nonsense. Find out more here. |
Laendra
Universalis Imperium |
Posted - 2006.12.07 02:52:00 - [ 10]
t20, can we have your babies???
thanks man.... |
Weirda
Minmatar
Queens of the Stone Age
Rote Kapelle |
Posted - 2006.12.07 02:56:00 - [ 11]
thank you <3  |
Deikan Frost
Amarr |
Posted - 2006.12.07 03:11:00 - [ 12]
Nice thanks! Now... just need to learn how to import all that data in mysql and how to link everything together  |
Danalog
STK Industrial
N.A.S.A |
Posted - 2006.12.07 03:25:00 - [ 13]
Need the table definitions in order to get much good out of it, unfortunately  |
Mik Nostrebor
Minmatar
Ex Coelis |
Posted - 2006.12.07 03:45:00 - [ 14]
Edited by: Mik Nostrebor on 07/12/2006 03:53:42
Edited by: Mik Nostrebor on 07/12/2006 03:51:07
I am working on getting the item tables done. I can post the SQL CREATE statements for them. The typing will be a bit broad (ie int instead of boolean and float for non-ID fields etc).
I am to impatient to wait for someone else to do it.
Here are the Categories, Groups and Types tables for MSSQL. NOTE: replace ",true," with ",1," in the types table for this to work.:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invCategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invCategories]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invGroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invGroups]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[invTypes]
GO
CREATE TABLE [dbo].[invCategories] (
[CategoryID] [int] NOT NULL ,
[CategoryName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[invGroups] (
[groupID] [int] NULL ,
[categoryID] [int] NULL ,
[groupName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL ,
[useBasePrice] [float] NULL ,
[allowManufacture] [int] NULL ,
[allowRecyler] [int] NULL ,
[anchored] [int] NULL ,
[anchorable] [int] NULL ,
[fittableNonSingleton] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[invTypes] (
[typeID] [int] NOT NULL ,
[groupID] [int] NULL ,
[typeName] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[graphicID] [int] NULL ,
[radius] [float] NULL ,
[mass] [float] NULL ,
[volume] [float] NULL ,
[capacity] [float] NULL ,
[portionSize] [float] NULL ,
[raceID] [int] NULL ,
[basePrice] [float] NULL ,
[published] [int] NULL ,
[marketGroupID] [int] NULL ,
[chanceOfDuplicating] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO |
Nightblade
Minmatar
Rage of Inferno
Burning Ambition |
Posted - 2006.12.07 04:26:00 - [ 15]
Thanks for the updated export.
I noticed a few missing tables compared to the last version:
dbo_chrFactions.sql
dbo_eveGraphics.sql
dbo_eveNames.sql
dbo_invControlTowerResourcePurposes.sql
dbo_invControlTowerResources.sql
|
Nesa
Antares Fleet Yards
Molotov Coalition |
Posted - 2006.12.07 05:22:00 - [ 16]
CSV would be nice *nudge* Also an update to http://www.eve-online.com/itemdatabase/ would be useful...  |
Julian Tavernier
Axe'n'ture
|
Posted - 2006.12.07 07:22:00 - [ 17]
Edited by: Julian Tavernier on 07/12/2006 07:27:38
Thanks a lot for this much waited data export ! :)
Just for info, here is a list of differences between rmr and revelations data export.
Tables present in rmr export and not in revelations export :
chrFactions
eveGraphics
eveNames
invControlTowerResourcePurposes
invControlTowerResources
Tables present in revelations export and not in rmr export :
chrAttributes
chrCareers
chrCareerSkills
chrCareerSpecialities
chrCareerSpecialitySkills
chrRaceSkills
chrSchoolAgents
crpNPCCorporationResearchFields
invFlags
invTypeReactions
mapCelestialStatistics
ramAssemblyLines
ramAssemblyLineStations
ramAssemblyLineTypeDetailPerCategory
ramAssemblyLineTypeDetailPerGroup
ramAssemblyLineTypes
ramCompletedStatuses |
Eewec Ourbyni
Caldari |
Posted - 2006.12.07 07:53:00 - [ 18]
Arrrrgggggggg
Why....
why.....
why at midnight....?
/me pods clock.
ok, so I'm not that far behind, can still get this sorted out today..... hopefully.
P.S. Anyone got an .sql file with all the table create statements in? |
Kylania
Gallente
Phoenix Industries
Sylph Alliance |
Posted - 2006.12.07 07:57:00 - [ 19]
Whee THANK YOU! |
Mirida
Meltd0wn |
Posted - 2006.12.07 08:03:00 - [ 20]
Okay, i successfully grepped some data out of it, however the table dbo.eveGraphics would be nice as the information about which icon to use for which inventory item would be good to have.
btw, during export i noticed an data mismatch: Miner II has 2 blueprints, blueprintTypeIDs: 784, 26607.
All useable systems linked again ;)
image: http://exi.ath.cx/eve/?a=mapview&sys_id=3277&mode=map&size=800
|
Marcus Nihalan |
Posted - 2006.12.07 09:22:00 - [ 21]
I haven't had any chance to study it in detail...
but might it not be because it is an invention blueprint? And much worse then the real blueprint?
Mmm. That doesn't sound right. They'd not be T2 BPO's but BPC's. Never mind. |
BarmaLINI
Caldari
PsiCorp
|
Posted - 2006.12.07 11:30:00 - [ 22]
Edited by: BarmaLINI on 07/12/2006 11:30:56where is dbo.eveGraphics, dbo.eveNames ?  |
medecau
Gallente
Super Bock Preta
|
Posted - 2006.12.07 12:01:00 - [ 23]
would be nice to have this in CSV like before
kkthx |
CCP t20
|
Posted - 2006.12.07 12:02:00 - [ 24]
I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today. |
Akita T
Caldari
Caldari Navy Volunteer Task Force
|
Posted - 2006.12.07 12:10:00 - [ 25]
t20, if you need a slave for a few days, let me know ;)
Gratz' on a much-needed update. |
elFarto
New Order Industries
|
Posted - 2006.12.07 12:22:00 - [ 26]
Edited by: elFarto on 07/12/2006 12:25:08
Man love for t20
*edit* OMG, no CSV files, bad t20, no man love for you.
Regards
elFarto |
Luigi Thirty
Caldari
The Minmatarded
|
Posted - 2006.12.07 12:33:00 - [ 27]
MS SQL IS INVINCIBLE:((((
|
Jimmy Riddle
Possibly
Overclockers Podpilot Services |
Posted - 2006.12.07 12:39:00 - [ 28]
|
Dalekplunger Slick
Caldari
Deep Core Mining Inc.
|
Posted - 2006.12.07 13:27:00 - [ 29]
Originally by: t20
I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.
I don't see anything about how to create the tables in http://myeve.eve-online.com/devblog.asp?a=blog&bid=246 or http://myeve.eve-online.com/devblog.asp?a=blog&bid=406 Is there some other blog that you're talking about? |
Anders Chydenius
Dreddit
Test Alliance Please Ignore |
Posted - 2006.12.07 14:10:00 - [ 30]
\o/ Wubbins! |
Screenshots & Art
All Channels
EVE Information Portal