Skip to content

Instantly share code, notes, and snippets.

@fuzzysteve

fuzzysteve/gist:8708591

Last active August 29, 2015 13:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fuzzysteve/8708591 to your computer and use it in GitHub Desktop.
Save fuzzysteve/8708591 to your computer and use it in GitHub Desktop.
Download ZIP
SQL for trait display
Raw
gistfile1.sql
select coalesce(typename,'Role Bonus') name,bonusText,
coalesce(if(invTraits.unitid=139,bonus,concat(bonus,displayName)),'') bonus
from invTraits
left join invTypes on (invTraits.skillid=invTypes.typeid)
left join eveUnits on (eveUnits.unitID=invTraits.unitID)
where invTraits.typeid=:id
requires:
https://www.fuzzwork.co.uk/dump/rubicon-1.1-94321/invTraits.sql.bz2
+----------------+---------------------------------------------------------------------+-------+
| name | bonusText | bonus |
+----------------+---------------------------------------------------------------------+-------+
| Role Bonus | Can fit <a href=showinfo:24554>Aurora Ominae</a> doomsday device | |
| Role Bonus | Can fit <a href=showinfo:23953>Jump Portal Generator</a> | |
| Role Bonus | Can fit <a href=showinfo:23735>Clone Vat Bay</a> | |
| Role Bonus | Immune to all forms of Electronic Warfare | |
| Role Bonus | Turrets fitted to this ship will do reduced damage to small targets | |
| Gallente Titan | bonus to <a href=showinfo:21666>Capital Hybrid Turret</a> damage | 100% |
| Gallente Titan | bonus to fleet members' maximum armor hitpoints | 8% |
| Gallente Titan | Can fit 1 additional <a href=showinfo:3348>Warfare Link</a> module | |
+----------------+---------------------------------------------------------------------+-------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment