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) |
|
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!
kieron Community Manager, EVE Online |
|
Salvis Tallan
Gallente Team Condor
|
Posted - 2006.12.07 00:47:00 -
[2]
Edited by: Salvis Tallan on 07/12/2006 00:51:17 Gah! Can we have it in CSV? Please? Those of use without databases cant really used the sql as well. ------
|
Ching Ling
Gallente
|
Posted - 2006.12.07 01:02:00 -
[3]
Am I first? Yay, and thanks! ---------- EvE Ship Classes now in poster format |
Andrew Gunn
Frontline Defense Force Maelstrom Alliance
|
Posted - 2006.12.07 01:18:00 -
[4]
Edited by: Andrew Gunn on 07/12/2006 01:18:28 AWESOME! Thank's man!
t20 you are my hero. --
EVE-Development Network - Home of the EDK, which is a free, open-source killboard software. |
Mirida
Amarr Cataclysm Enterprises Dusk and Dawn
|
Posted - 2006.12.07 01:18:00 -
[5]
Whew, thanks... going to crunsh some queries now... EVE Development Network <Lead Developer> |
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 ORKS
|
Posted - 2006.12.07 01:28:00 -
[7]
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 [email protected]
Thnx Mik
AUSSIE AND KIWI EVE Fansite |
Xaroth Brook
Minmatar Doomcraft
|
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! -=-=-=-=-=-=-=-=-=-=-=-=- Xaroth Brook Brainiac of Doomcraft |
Beatle Bones
|
Posted - 2006.12.07 02:34:00 -
[9]
Huzzah!
Originally by: Salvis Tallan Gah! Can we have it in CSV?
Well as it happens I need *ahem* would like it in CSV too... I think I could be knocking up a little *.exe to do just that. Saves all that find/replace nonsense. Watch this space.
Again though, Huzzah!
Hip hip...
The secret to creativity is knowing how to hide your sources. |
Laendra
|
Posted - 2006.12.07 02:52:00 -
[10]
t20, can we have your babies???
thanks man.... ------------------- |
|
Weirda
Minmatar Queens of the Stone Age Anarchy Empire
|
Posted - 2006.12.07 02:56:00 -
[11]
thank you <3 __ Weirda Join QotSA
|
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
Sig Size: 374x115 pixels - 136Kb |
Danalog
STK Scientific Ascendant Frontier
|
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 ORKS
|
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 , [*****bleNonSingleton] [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 Black Avatar Firmus Ixion
|
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 SMASH Alliance
|
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
Talion Federal Navy Babylon Federal Republic
|
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?
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
Kylania
Gallente
|
Posted - 2006.12.07 07:57:00 -
[19]
Whee THANK YOU! -- Lil Miner Newbie Skills Roadmap | CCG Card Lookup |
Mirida
Amarr Cataclysm Enterprises Dusk and Dawn
|
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
EVE Development Network <Lead Developer> |
|
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:56 where is dbo.eveGraphics, dbo.eveNames ?
--------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more |
medecau
|
Posted - 2006.12.07 12:01:00 -
[23]
would be nice to have this in CSV like before
kkthx
|
|
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 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. _____ -sig-
This is my only char. These are my skills
Always question everything, including yourself |
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
NPC database Mal: This is your captain speaking. We're having some technical difficulties, so we may experience some turbulence, and then explode. |
Beatle Bones
|
Posted - 2006.12.07 12:29:00 -
[27]
Originally by: elFarto *edit* OMG, no CSV files, bad t20, no man love for you.
Nearly finished a Eve Data SQL to CSV converter... watch this space.
Erm, would anyone be willing to host it?
The secret to creativity is knowing how to hide your sources. |
Luigi Thirty
Caldari
|
Posted - 2006.12.07 12:33:00 -
[28]
MS SQL IS INVINCIBLE:((((
---- DOMINIX IS INVINCIBLE:(((( |
Jimmy Riddle
Possibly
|
Posted - 2006.12.07 12:39:00 -
[29]
Bonus>Phobia Handicap
Claustrophobia Bonus
If floating in capsule in space for 5 mins, he dies.
Monophobia Bonus
Dies if he doesn't dock at a station every 60 mins
|
Dalekplunger Slick
Caldari DPS Holding Corporation
|
Posted - 2006.12.07 13:27:00 -
[30]
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?
|
|
|
|
|
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 |