Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
oxman
|
Posted - 2007.11.04 11:45:00 -
[1]
Hi,
In the database EvE, how the skill with id 3318 (Weapon Upgrades) is linked to other item ? This skill give a reduce of 5% need of CPU for missile launcher, turret, etc...
I don't know where the link to say "the skill give this bonus to all items missile launcher, turret, etc" is in the database.
The only things in the database to say that is the description of the skill. But I can't believe its the only way to know.
|
oxman
|
Posted - 2007.11.05 19:52:00 -
[2]
No answer ? :(
|
maronfloower
Gallente
|
Posted - 2007.11.06 09:19:00 -
[3]
Edited by: maronfloower on 06/11/2007 09:19:26 select e.effectName,e.effectCategory,e.description from dgmTypeEffects t inner join dgmEffects e on e.effectID=t.effectID where t.typeID=3318 -- select a.attributeID,a.attributeName,isnull(convert(double precision,v.valueInt),v.valueFloat) as Value, rtrim(u.displayName)+' ('+rtrim(u.unitName)+')' as unit, t.typeName from dgmTypeAttributes v inner join dgmAttributeTypes a on a.attributeID=v.attributeID inner join invTypes t on v.typeID=t.typeID left join eveUnits u on a.unitID=u.unitID where v.typeID=3318 order by 1,5 -- First one will give you: skillEffect sensorUpgradesSkillBoostCpuNeedBonus weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringGunnery weaponUpgradesSkillBoostCpu weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringEnergyPulseWeapons weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringMissileLauncherOperation
|
oxman
|
Posted - 2007.11.06 12:17:00 -
[4]
Thanks, but I already know that
With your example I don't know how I can know that skill (#3318) work on the item cruise missile launcher (#13320)
|
Tonto Auri
|
Posted - 2007.11.06 18:36:00 -
[5]
Look at skill attibutes and their effects. -- Thanks CCP for cu<end of sig> |
AliasXNeo
Gallente
|
Posted - 2007.11.06 19:21:00 -
[6]
I don't think there is any specific say on whether or not a skill will directly effect the item. It's pretty much based on logic, read the attributes and from there link them to the item. ------------------------------ ~ AKA Josh ~ - Battleclinic Staff Developer - ------------------------------
|
oxman
|
Posted - 2007.11.06 23:27:00 -
[7]
But which logic ? I don't know how I can code a kind of logic to do that.
|
AliasXNeo
Gallente
|
Posted - 2007.11.07 02:35:00 -
[8]
Originally by: oxman But which logic ? I don't know how I can code a kind of logic to do that.
If the skill gives a modifier for mining laser yield then it probably affects on mining lasers. That kind of logic. ------------------------------ ~ AKA Josh ~ - Battleclinic Staff Developer - ------------------------------
|
oxman
|
Posted - 2007.11.07 06:12:00 -
[9]
You mean I need to parse : sensorUpgradesSkillBoostCpuNeedBonus weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringGunnery weaponUpgradesSkillBoostCpu weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringEnergyPulseWeapons weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringMissileLauncherOperation
Split at each word, then try to do matching on the name of module ? It's pretty incredible, I think there are a more clear way, because this one is very dirty and not accurate.
|
maronfloower
Gallente
|
Posted - 2007.11.07 07:29:00 -
[10]
Actually there is only fixed set of effects available. So you can fetch it all, read carefully and build your own table which maps effect to item group. I'm afraid this logic is hardcoded in EVE's source code.
|
|
oxman
|
Posted - 2007.11.07 08:07:00 -
[11]
Hum ok. Thanks all.
I think nobody here have already make this kind of table and can share it ? I'll try to do something and share it.
Any advice are welcome.
|
oxman
|
Posted - 2007.11.07 14:05:00 -
[12]
:)
I want to know if my skill Weapon Upgrades (#3318) give his bonus to my item 'Arbalest' Rocket Launcher I (#16527), the method :
1. Get the required skill by my item 'Arbalest' Rocket Launcher I (#16527)
SELECT t2.typeName FROM dgmTypeAttributes dta INNER JOIN dgmAttributeTypes dat ON dat.attributeID = dta.attributeID INNER JOIN invTypes t ON dta.typeID = t.typeID INNER JOIN invTypes t2 ON dta.valueInt = t2.typeID WHERE t.typeID = 16527 and dat.attributeName like 'requiredSkill%'
Result : Missile Launcher Operation
2. Get the "special" effects give by my skill Weapon Upgrades (#3318)
SELECT e.effectName FROM dgmTypeEffects t INNER JOIN dgmEffects e ON e.effectID = t.effectID inner join invTypes it on it.typeid = t.typeid inner join invGroups ig on ig.groupid = it.groupid WHERE t.typeID = 3318 and e.effectName like '%Requiring%'
Result : weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringGunnery weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringEnergyPulseWeapons weaponUpgradesCpuNeedBonusPostPercentCpuLocationShipModulesRequiringMissileLauncherOperation
Cut all before the word "Requiring" : Gunnery EnergyPulseWeapons MissileLauncherOperation
Split at each caps : Gunnery Energy Pulse Weapons Missile Launcher Operation
3.
Finaly match the result from 1. and 2. :)
|
Dal Rath
|
Posted - 2007.11.07 14:11:00 -
[13]
If you think that's a pain in the posterior, then try doing the ship bonuses. Come on CCP, open source dogma please! |
oxman
|
Posted - 2007.11.07 15:02:00 -
[14]
SELECT e.* FROM dgmTypeEffects t INNER JOIN dgmEffects e ON e.effectID = t.effectID inner join invTypes it on it.typeid = t.typeid inner join invGroups ig on ig.groupid = it.groupid WHERE t.typeID = '638'
For Raven
|
oxman
|
Posted - 2007.11.15 12:07:00 -
[15]
Edited by: oxman on 15/11/2007 12:17:01 Above the method to get bonus for item. And now I try to find the method to get bonus from a skill to a Ship.
Any information are welcome. I'll give my method if I found one.
(After that, I'll try to find the method to get the bonus of a ship) --------- Give me 1 isk if you like my help. Yes, I don't ask 1M, 5M or 10M like other people offer services ^^ |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |