EVE Search - EVE Data Export

All Channels

EVE General Discussion

EVE Data Export - Kali edition

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

Monitor this thread via RSS [?]

Pages: [1] :: one page
Author	Thread Statistics \| Show CCP posts - 1 post(s)
Xaroth Brook Minmatar Doomcraft	Posted - 2006.12.07 01:14:00 - [1] Edited by: Xaroth Brook on 07/12/2006 01:18:17 As t20 kindly released this long expected info, Kieron also locked the previous thread to start 'fresh' with the new export. Seeing how there hasn't been one as of yet, here it is. First of all, Thanks again, t20 (and the rest of CCP, ofc), for providing the community with this info, and hopefully the creators of various usefull tools will update their tools accordingly. Devblog: here Last page of previous topic: Here File List: (Grouped per 'field' of use) - Agents (dbo_agt) dbo_agtAgents.sql dbo_agtAgentTypes.sql dbo_agtConfig.sql - Character (dbo_chr) dbo_chrAttributes.sql dbo_chrBloodlines.sql dbo_chrCareers.sql dbo_chrCareerSkills.sql dbo_chrCareerSpecialities.sql dbo_chrCareerSpecialitySkills.sql dbo_chrRaces.sql dbo_chrRaceSkills.sql dbo_chrSchoolAgents.sql dbo_chrSchools.sql - Corperations (dbo_crp) dbo_crpNPCCorporationDivisions.sql dbo_crpNPCCorporationResearchFields.sql dbo_crpNPCCorporations.sql dbo_crpNPCDivisions.sql - (dbo_dgm) dbo_dgmAttributeTypes.sql dbo_dgmEffects.sql dbo_dgmTypeAttributes.sql dbo_dgmTypeEffects.sql - Eve general info (dbo_eve) dbo_eveUnits.sql - Items/Market (Inventory, probably) (dbo_inv) dbo_invBlueprintTypes.sql dbo_invCategories.sql dbo_invContrabandTypes.sql dbo_invFlags.sql dbo_invGroups.sql dbo_invMarketGroups.sql dbo_invMetaGroups.sql dbo_invMetaTypes.sql dbo_invTypeReactions.sql dbo_invTypes.sql - Map (dbo_map) dbo_mapCelestialStatistics.sql dbo_mapConstellationJumps.sql dbo_mapConstellations.sql dbo_mapDenormalize.sql dbo_mapJumps.sql dbo_mapLandmarks.sql dbo_mapRegionJumps.sql dbo_mapRegions.sql dbo_mapSolarSystemJumps.sql dbo_mapSolarSystems.sql dbo_mapUniverse.sql - Research and Manufactoring (dbo_ram) dbo_ramAssemblyLines.sql dbo_ramAssemblyLineStations.sql dbo_ramAssemblyLineTypeDetailPerCategory.sql dbo_ramAssemblyLineTypeDetailPerGroup.sql dbo_ramAssemblyLineTypes.sql dbo_ramCompletedStatuses.sql - Stations (dbo_sta) dbo_staOperations.sql dbo_staOperationServices.sql dbo_staServices.sql dbo_staStations.sql dbo_staStationTypes.sql - Research? (rest) dbo_TL2MaterialsForTypeWithActivity.sql Any more usefull info will be posted here as well -=-=-=-=-=-=-=-=-=-=-=-=- Xaroth Brook Brainiac of Doomcraft
Xaroth Brook Minmatar Doomcraft	Posted - 2006.12.07 01:15:00 - [2] - post reserved seeing how i spent 60% of the max post size on the initial info alone... - -=-=-=-=-=-=-=-=-=-=-=-=- Xaroth Brook Brainiac of Doomcraft
Mortimus Gallente Ordos Humanitas	Posted - 2006.12.07 02:48:00 - [3] Anyone going to figure out the table fields or are we waiting for t20?
Mik Nostrebor Minmatar ORKS	Posted - 2006.12.07 03:05:00 - [4] Edited by: Mik Nostrebor on 07/12/2006 03:17:30 dbo_invTypes contains module, ship, astral bodies, stations etc information as well. dbo_invMarketGroups groups items from the dbo_invTypes table based on the marketGroupID field. Market groups are tiered to create the Group tree seen in the Market Browser. The ParentGroupID field is used to create the links up the chain. There is a second method of grouping not related to the market. It uses the dbo_invGroup and dbo_invCategories to group items. In the dbo_invTypes table there is a GroupID field that links into dbo_invGroups. In the dbo_invGroup table there is the CategoryID field that link into dbo_invCategories table. This seems to be a flat 1 to many relationship upon initial inspection. Example Categories would be Commodity, Implant, Planet, Entity, Ship, Skill, Module, Asteroid etc.
Beatle Bones	Posted - 2006.12.07 03:08:00 - [5] Edited by: Beatle Bones on 07/12/2006 03:13:05 I'll start by saying I know f'all about SQL, so feel free to flame but... Originally by: dbo.mapSolarSystems INSERT INTO dbo.mapSolarSystems (regionID,constellationID,solarSystemID,solarSystemName,x,y,z,xMin,etc... VALUES(10000067,20000773,30005285,'Dead end',-2.70942052536296E17,-3.6011... is the green bit not the fields? The secret to creativity is knowing how to hide your sources.
Mik Nostrebor Minmatar ORKS	Posted - 2006.12.07 03:22:00 - [6] Originally by: Beatle Bones Edited by: Beatle Bones on 07/12/2006 03:13:05 I'll start by saying I know f'all about SQL, so feel free to flame but... Originally by: dbo.mapSolarSystems INSERT INTO dbo.mapSolarSystems (regionID,constellationID,solarSystemID,solarSystemName,x,y,z,xMin,etc... VALUES(10000067,20000773,30005285,'Dead end',-2.70942052536296E17,-3.6011... is the green bit not the fields? Yes mate they are the fields but there is no indication of datatype. Even Excel wants to know is a column (field) is a number, text or date at the very least. Also, ID fields should be integers (no decimal points), and the ID field that identifies each record (eg CategoryID in the dbo_invCategories table) should be a unique field. So in order to import the data into Access or SQL and even Excel you will need to do a bit of setting up.
Raquel Smith Caldari Freedom-Technologies Knights Of the Southerncross	Posted - 2006.12.07 03:39:00 - [7] This should be moved to tech forum.
Matalino Gallente	Posted - 2006.12.07 03:53:00 - [8] Originally by: Mik Nostrebor Originally by: Beatle Bones Edited by: Beatle Bones on 07/12/2006 03:13:05 I'll start by saying I know f'all about SQL, so feel free to flame but... Originally by: dbo.mapSolarSystems INSERT INTO dbo.mapSolarSystems (regionID,constellationID,solarSystemID,solarSystemName,x,y,z,xMin,etc... VALUES(10000067,20000773,30005285,'Dead end',-2.70942052536296E17,-3.6011... is the green bit not the fields? Yes mate they are the fields but there is no indication of datatype. Even Excel wants to know is a column (field) is a number, text or date at the very least. Also, ID fields should be integers (no decimal points), and the ID field that identifies each record (eg CategoryID in the dbo_invCategories table) should be a unique field. So in order to import the data into Access or SQL and even Excel you will need to do a bit of setting up. It looks like the fields are mostly (haven't gone through all of them) the same as the previous version. So we should be able to use the create table code from the last dump, and the insert code from this dump to get what we need. Thank you T20
SonOTassadar The Dead Parrot Shoppe Inc. Brutally Clever Empire	Posted - 2006.12.07 05:43:00 - [9] Sorry to poke my head in and not really help get to whatever you guys are doing, but, what are all these databases going to help you guys do? (Looking for a fairly detailed response, if someone would be so kind) ----- Griffin -- 100,000 ISK ECM - Multispectral Jammer Is -- 20,000 ISK Standar Missile Launcher Is -- 10,000 ISK War target sobbing over losing a fight in his T2 fitted Battleship -- priceless
Dark Kas Gallente Da Dark Star	Posted - 2006.12.07 05:58:00 - [10] People use the info to make 3rd party programs like evemon, quickfit and evemeep run with the latest info for the server.
Julian Tavernier Talion Federal Navy Babylon Federal Republic	Posted - 2006.12.07 07:53:00 - [11] Unless I'm wrong, there are new colums on chrBloodlines table: shortDescription,shortMaleDescription,shortFemaleDescription I think these columns can be set to VARCHAR(200). Will try this after work. :)
Nic Pyrotech	Posted - 2006.12.07 08:12:00 - [12] Yes, for the existing tables, the creates seem to be the same (so far). 2 questions if anyone could help: 1st. Is there a way to get mySQL to automatically take "x,,y" as "x,NULL,y", without having to do a global replace on each SQL file? 2nd. How do you find the slot requirements for modules, implants, & rigs? I would have expected it to be in invGroups, or dmgTypeAttributes, but I cant seem to find anywhere. Thanks for any help.
omghax0r	Posted - 2006.12.07 11:19:00 - [13] eve.coldfront.net's item database has been updated with the Revelations item database.
Mynk Minmatar Brutor tribe	Posted - 2006.12.07 18:50:00 - [14] Not sure about mysql but in most other sql flavors you can set the table to have a field default to null if you have nothing in that field for the record. So when you go to insert a blank space the server your using will automaticly place a NULL in there for you. So you just create your table and make each field allow nulls and set the default to null if nothing is in the space.
Raquel Smith Caldari Freedom-Technologies Knights Of the Southerncross	Posted - 2006.12.07 21:44:00 - [15] There's an updated dump with CREATEs.
Andargor theWise Disbelievers of Fate The SUdden Death Squad	Posted - 2006.12.08 04:53:00 - [16] Edited by: Andargor theWise on 08/12/2006 04:55:36 FWIW this is my MySQL conversion: Linkage (~32 MB) - Create the "dbo" database, if not already done - It will drop any existing tables, so backup your stuff first... CCP again forgot some CREATEs... So I guesstimated. I had to fiddle with data types, there were truncations on some of the IDs which were tinyint(4). I changed them to smallint(6). Also, I nixed the autoincrements, since I intend to use the data as read-only. - Got grief?

Wrangler	Posted - 2006.12.08 05:52:00 - [17] The thread on this can be found here, in the new EVE Information Portal forum. Wrangler Assistant Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


Pages: [1] :: 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.

The secret to creativity is knowing how to hide your sources.