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 [?]

Author	Thread Statistics \| Show CCP posts - 7 post(s)
Zifrian Deep Space Innovations 48	Posted - 2011.12.02 02:27:00 - [1] - 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/
Zifrian Deep Space Innovations 54	Posted - 2011.12.04 01:07:00 - [2] - 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/
Zifrian Deep Space Innovations 71	Posted - 2011.12.05 12:20:00 - [3] - 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/

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.