Skip to content

Instantly share code, notes, and snippets.

@fuzzysteve

fuzzysteve/decryptorEffects

Created July 28, 2014 03:06
Show Gist options
  • Save fuzzysteve/27cd234b680d445a4629 to your computer and use it in GitHub Desktop.
Save fuzzysteve/27cd234b680d445a4629 to your computer and use it in GitHub Desktop.
Download ZIP
Decryptor effects by blueprint
Raw
decryptorEffects
SELECT it2.typename,
it2.typeid,
coalesce(dta2.valueInt,dta2.valueFloat) multiplier,
coalesce(dta3.valueInt,dta3.valueFloat) me,
coalesce(dta4.valueInt,dta4.valueFloat) te,
coalesce(dta5.valueInt,dta5.valueFloat) runs
FROM invTypes
JOIN industryActivityMaterials iam ON (iam.materialtypeid=invTypes.typeid and iam.activityid=8 and groupid=716)
JOIN industryActivityProducts iap ON (iam.typeid=iap.typeid)
JOIN dgmTypeAttributes dta on (dta.typeid=invTypes.typeid and dta.attributeID=1115)
JOIN invTypes it2 on (it2.groupid=dta.valueInt)
join dgmTypeAttributes dta2 on (dta2.typeid=it2.typeid and dta2.attributeID=1112)
join dgmTypeAttributes dta3 on (dta3.typeid=it2.typeid and dta3.attributeID=1113)
join dgmTypeAttributes dta4 on (dta4.typeid=it2.typeid and dta4.attributeID=1114)
join dgmTypeAttributes dta5 on (dta5.typeid=it2.typeid and dta5.attributeID=1124)
WHERE iap.producttypeid=1320;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment