EVE Search - Crucible database dump

All Channels

EVE Technology Lab

Crucible database dump

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

Monitor this thread via RSS [?]

Pages: [1] 2 3 :: one page
Author	Thread Statistics \| Show CCP posts - 7 post(s)
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 07:03:00 - [1] - Quote Anyone know when a dump of the database will be availeble?
TorTorden NorCorp Enterprise No Holes Barred 14	Posted - 2011.11.30 10:59:00 - [2] - Quote It's out but only from ccp direct so no mysql version yet :S http://www.eveonline.com/community/toolkit.asp
Desmont McCallock 50	Posted - 2011.11.30 11:47:00 - [3] - Quote Would be nice if it included the SQL script file.
Kekkekir Order of the Domain The Polaris Syndicate 1	Posted - 2011.11.30 12:56:00 - [4] - Quote The dump seems to be available now here: http://www.eveonline.com/community/toolkit.asp Just need someone to convert it to SQL now :
Arskaff Adhocracy Incorporated Adhocracy 4	Posted - 2011.11.30 18:46:00 - [5] - Quote Desmont McCallock wrote: Changes (possible breaking) found: - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed Edit 2: cruc10-sqlite3-v.1.db.7z Thanx for the SQLite version. About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ?
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 19:07:00 - [6] - Quote Sweet, 'im currently uploading a mysql version to eve-files! I'll post again when it's there
KillMinusNine League of Obsidian Blades 0	Posted - 2011.11.30 19:27:00 - [7] - Quote Found this thread: https://forums.eveonline.com/default.aspx?g=posts&t=39958&find=unread
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 19:34:00 - [8] - Quote Haha... i need has faster internet! well here is the db i converted anyways! http://eve-files.com/dl/249921 Have fun!
Desmont McCallock 51	Posted - 2011.11.30 19:37:00 - [9] - Quote Arskaff wrote: Desmont McCallock wrote: Changes (possible breaking) found: - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed Edit 2: cruc10-sqlite3-v.1.db.7z Thanx for the SQLite version. About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ? Yes and having them in SDD was doubling the file size. Praise they got rid of those tables.
Scrapyard Bob EVE University Ivy League 413	Posted - 2011.11.30 20:23:00 - [10] - Quote Crossing my fingers for a pgsql version.
TorTorden NorCorp Enterprise No Holes Barred 15	Posted - 2011.11.30 20:26:00 - [11] - Quote Just as a warning been quick looking at the two conversions now and they are both with extended inserts, not a problem for me, since I don't bother with bigdump etc.
Luminocity Filthy Thirteen 2	Posted - 2011.11.30 22:34:00 - [12] - Quote I have not checked any of the other conversions at this point so they might be completely valid. But here is another version I created using the same approach as the one I did for the last Incarna dump. (among other things no extended inserts): crucible1.0.57975-mysql5-v1.zip
Ruziel Twilight Military Industrial Complex 1	Posted - 2011.12.01 02:50:00 - [13] - Quote One more mysql conversion for the pile: cru100-mysql5-v1.zip Used the same scripts that Jercy used for all his previous conversions.

CCP Prism X C C P C C P Alliance 214	Posted - 2011.12.01 08:50:00 - [14] - Quote There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay. Terribly sorry, will get the ball rolling on this ASAP. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Cyerus Galactic Dominion Eternal Strife 13	Posted - 2011.12.02 01:34:00 - [15] - Quote CCP Prims X: Once these issues are fixed, would you mind making a sticky topic will all the conversions?
Zifrian Deep Space Innovations 48	Posted - 2011.12.02 02:27:00 - [16] - Quote CCP Prism X wrote: There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay. Terribly sorry, will get the ball rolling on this ASAP. So the current download has errors? Or am I misreading? Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/

CCP Prism X C C P C C P Alliance 220	Posted - 2011.12.02 08:46:00 - [17] - Quote It currently has errors. SELECT * FROM dbo.agtAgents WHERE locationID < 60000000 Will show you that all agents in space have locationIDs of stations (Because we all know that the only valid locations for agents are stations and solar systems so that anything below 60Mils must be located in systems!). It's because of a change in our internal processes with how we treat NPC Characters VS Player Characters and how that static data is copied around our servers. It has been fixed internally and I'm tryingto push for its (SDEs) regeneration and deployment but people are just very busy these post-expansion-deployment-days. P.S. I am very disappointed in these forums forcing me to break our SQL coding standards! ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Pizzutz Capital Industries Research And Development Fidelas Constans 0	Posted - 2011.12.02 11:39:00 - [18] - Quote Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?
Celebrain 1st Steps Academy Fidelas Constans 0	Posted - 2011.12.02 20:37:00 - [19] - Quote I've been using the eveOwners table to detect and display the bloodline (and therefore race too) of each individual agent. You can see an example here: http://www.eveiverse.com/agents/akinoma_nimpalius Another side effect of losing bloodline info is that I can no longer generate IGB eve info popup urls for these agents any longer... since they are all encoded, both for player characters and npc characters with a typeID that represents each bloodline. So that will be very frustrating too, and potentially a really big functionality problem. :( Please, if you are able, either restore that table, or add a new column with this info to the agtAgents table, just like you did for the isLocator column when you removed the agtConfig table. Otherwise my site will have to lose data and functionality that some people may have found interesting and/or useful. Of course adding gender and ancestry would be cool too, but losing data is more painful than not adding new cool stuff. Cele
TorTorden NorCorp Enterprise No Holes Barred 15	Posted - 2011.12.03 16:46:00 - [20] - Quote Any ETA on the non bugged datadump or is it out already ?
Desmont McCallock 52	Posted - 2011.12.03 16:52:00 - [21] - Quote Try again on Monday.
Zifrian Deep Space Innovations 54	Posted - 2011.12.04 01:07:00 - [22] - Quote The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Returns: Fiery KerniteKernite PyroxeresPyroxeres Solid PyroxeresPyroxeres VeldsparVeldspar Condensed ScorditeScordite KerniteKernite Viscous PyroxeresPyroxeres Concentrated VeldsparVeldspar Dense VeldsparVeldspar ScorditeScordite Same query in Crucible returns no rows. Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/
Celebrain 1st Steps Academy Fidelas Constans 0	Posted - 2011.12.04 20:50:00 - [23] - Quote Celebrain wrote: I've been using the eveOwners table to detect and display the bloodline (and therefore race too) of each individual agent. You know what? never mind on this one, I finally found the "missing" agent bloodline type data, in the invItems table. :P
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.04 21:48:00 - [24] - Quote Desmont McCallock wrote: Edit 2: cruc10-sqlite3-v.1.db.7z Notice: Not compatible with EAM I can only use sqlite export... tried this one, and new t2 modules' material requirements are not the same as the ones shown in game for t2 bpo.
Desmont McCallock 52	Posted - 2011.12.05 07:03:00 - [25] - Quote Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject.

CCP Prism X C C P C C P Alliance 225	Posted - 2011.12.05 08:02:00 - [26] - Quote Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName No, we sanitized a lot of stuff out of invItems, asteroids included. Desmont McCallock wrote: Would be nice if it included the SQL script file. Not very hot on releasing anything about our own internal structure of things. Not that obscurity is security but transparency isn't either. Desmont McCallock wrote: Changes (possible breaking) found: - agtConfig -> empty table ??? (edit: related data have been inserted in agtAgents table, which was about time) - dgmAttributeTypes -> some attributeName values are NULL (intended?) - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed - invPositions -> added - invUniqueNames -> added - translationLaguages -> added (typo error on table name - contains no data, should be removed) - translationTables -> added - trnTranslationLanguages -> added - warCombatZoneSystems -> added - warCombatZones -> added I thought the changelog had mentioned that eveNames and eveOwners were now invNames and invUniqueNames as well as that eveLocations is now invPositions. The dogma attributes missing names is probably due to our new translation system, will look at that. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Lutz Major Austriae Est Imperare Orbi Universo 50	Posted - 2011.12.05 08:05:00 - [27] - Quote Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Remove the invItems table from your query and it should work again
Zifrian Deep Space Innovations 71	Posted - 2011.12.05 12:20:00 - [28] - Quote Lutz Major wrote: Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Remove the invItems table from your query and it should work again Nah, I was linking this to the map tables by the location id in invitems to find out where certain asteroids spawned. So this was just a partial query. Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/
Desmont McCallock 52	Posted - 2011.12.05 14:22:00 - [29] - Quote @CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions.
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.05 14:30:00 - [30] - Quote Desmont McCallock wrote: Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject. I am talking about basic requirements like tritanium etc. besides t1 base module. is it also modified to include t1's requirements? so I have to subtract i.e. tritanium needed for t1 module from t2's count?

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