Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Zepple

---

Managed to create a patch that adds all the unofficial data to the latest tyrannis database.

---

Originally by: Serious Masta

---

do you mean this?
http://wiki.eveonline.com/en/wiki/Wormholes

---

Originally by: Flaming Candle

---

Originally by: Serious Masta

---

do you mean this?
http://wiki.eveonline.com/en/wiki/Wormholes

---

That's not quite enough - I was looking for the w-space system <-> class/anomaly data.

---

Originally by: Zepple

---

Edited by: Zepple on 14/06/2010 19:00:57
Does anyone know where i can find data about wormhole phenomenon and the various wormhole types (mass, destenation, etc)

i found tons of sites displaying this information but i couldnt find any up to date databases containing this data.

This is the only database that i did find: http://zofu.no-ip.de/ (less than official addons section)

---

Quote:

---

Attribute Value Description
armorDamageAmountMultiplier -34%
shieldBonusMultiplier -34%
shieldBonusMultiplierRemote +68%
armorDamageAmountMultiplierRemote +68%
capacitorCapacityMultiplierSystem +68%
rechargeRateMultiplier +68%

---

Originally by: jmutton

---

Edited by: jmutton on 17/06/2010 17:15:13
Has anyone got any mysql to pull the attributes for each wormhole? i.e...

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: jmutton

---

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

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

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 ****'

---

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'

---

Originally by: jmutton

---

Any more clues? lol

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Quote:

---

SELECT * FROM `invTypes` WHERE `groupID` = 920 LIMIT 0 , 30

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

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'

---

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%')

---

Originally by: jmutton

---

Is that what you ment?

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

DROP TABLE IF EXISTS `sPhenomenonIndex`;

CREATE TABLE `sPhenomenonIndex` (
 `phenomenonID` SMALLINT(6) NOT NULL,
 `typeID` SMALLINT(6) NOT NULL,
 `classID` TINYINT(3) UNSIGNED NOT NULL,
 PRIMARY KEY (`phenomenonID`, `typeID`, `classID`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;


insert into sPhenomenonIndex (`typeID`, `phenomenonID`, `classID`)
select distinct(typeid), phenomenonID, classid from
(
select l.wormholeclassid as classid, t.typeid as phenomenonID, concat(replace(replace(t.typename, '-', ' '), 'Star', ''), '%Class%', l.wormholeclassid) anoTypeName from smapdenormalize d
inner join sinvtypes t using(typeid)
inner join smaplocationwormholeclasses l on d.regionid = l.locationid
where d.groupid = 995
) asd
inner join sinvtypes on sinvtypes.typename like anoTypeName
order by typename;