EVE Search - Wormhole data

All Channels

EVE Technology Lab

Wormhole data

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

Monitor this thread via RSS [?]

Author	Thread Statistics \| Show CCP posts - 0 post(s)
jmutton Gallente	Posted - 2010.06.17 17:15:00 - [1] Edited by: jmutton on 17/06/2010 17:15:13 Has anyone got any mysql to pull the attributes for each wormhole? i.e... http://evemaps.dotlan.net/system/J100046 Quote: Attribute Value Description armorDamageAmountMultiplier -34% shieldBonusMultiplier -34% shieldBonusMultiplierRemote +68% armorDamageAmountMultiplierRemote +68% capacitorCapacityMultiplierSystem +68% rechargeRateMultiplier +68% Thanks, Jase
jmutton Gallente	Posted - 2010.06.17 23:07:00 - [2] dogma tables?
jmutton Gallente	Posted - 2010.06.21 14:01:00 - [3] I'm still struggling to see where this data is located in the dgm tables. I can't see how its being linked etc... If anyone whos done this before can show an SQL query? Thanks, Jase
jmutton Gallente	Posted - 2010.06.21 23:52:00 - [4] Thanks very much for that link. I'm managing to pull the attributes using the SQL provided from that link. However I'm struggling trying to link the solarsystem to it. I know that the wormhole effects are located in 'invtypes'. But when I try and link the typeid into the SQL for getting the attributes its always returning no results. Attributes SQL: Quote: SELECT dgmTypeAttributes., dgmAttributeTypes.attributeName, dgmAttributeTypes.displayName FROM eagle6_edb.dgmTypeAttributes INNER JOIN eagle6_edb.dgmAttributeTypes ON dgmAttributeTypes.attributeID = dgmTypeAttributes.attributeID WHERE typeID = '* typeid here ' Solarsystem typeid SQL: Quote: SELECT mapDenormalize.typeid, invTypes.typeName FROM eagle6_edb.mapDenormalize LEFT JOIN eagle6_edb.invTypes ON mapDenormalize.typeid = invTypes.typeID WHERE mapDenormalize.solarSystemID = ' solar system id **' AND mapDenormalize.groupID = '995' Any more clues? lol Thanks, Jase
jmutton Gallente	Posted - 2010.06.22 00:20:00 - [5] Hehe, Quote: SELECT * FROM `invTypes` WHERE `groupID` = 920 LIMIT 0 , 30 I can see all of the different effects listed. For example the invTypes.typeID for 'Pulsar Effect Beacon Class 1' is '30844'. I was then expecting invTypes.typeID = mapDenormalize.typeID ? Jase
jmutton Gallente	Posted - 2010.06.22 10:15:00 - [6] I think I can understand where you are heading with this... Quote: SELECT invTypes.typeName, mapLocationWormholeClasses.wormholeClassID FROM eagle6_edb.mapDenormalize LEFT JOIN eagle6_edb.invTypes ON mapDenormalize.typeid = invTypes.typeID LEFT JOIN eagle6_edb.mapLocationWormholeClasses ON mapDenormalize.regionID = mapLocationWormholeClasses.locationID WHERE mapDenormalize.solarSystemID = '31000250' AND mapDenormalize.groupID = '995' Returns: typeName: Pulsar Class: 1 I'm them using those in: Quote: SELECT dgmTypeAttributes.*, dgmAttributeTypes.attributeName, dgmAttributeTypes.displayName FROM eagle6_edb.dgmTypeAttributes INNER JOIN eagle6_edb.dgmAttributeTypes ON dgmAttributeTypes.attributeID = dgmTypeAttributes.attributeID WHERE typeID = (SELECT invTypes.typeID FROM invTypes WHERE typeName LIKE '%Pulsar% Class 1%') Returns: Is that what you ment? Cheers, Jase
jmutton Gallente	Posted - 2010.06.22 10:28:00 - [7] That is indeed what I was looking for! Is that pretty much the sameway you are returning the data? Jase

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.