User:Alephander/attributes: Difference between revisions

Line 53: Line 53:
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN StrengthBonus IS NOT NULL AND StrengthBonus >= 0 THEN 'G+ ' ELSE 'R ' END, StrengthBonus, '{{)}}')=Strength,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN StrengthBonus IS NOT NULL AND StrengthBonus >= 0 THEN 'G+ ' ELSE 'R ' END, StrengthBonus, '{{)}}')=Strength,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN AgilityBonus IS NOT NULL AND AgilityBonus >= 0 THEN 'G+ ' ELSE 'R ' END, AgilityBonus, '{{)}}')=Agility,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN AgilityBonus IS NOT NULL AND AgilityBonus >= 0 THEN 'G+ ' ELSE 'R ' END, AgilityBonus, '{{)}}')=Agility,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN ToughnessBonus IS NOT NULL AND ToughnessBonus >= 0 THEN 'G+ ' ELSE 'R ' END, ToughnessBonus, '{{)}}')=Toughness,
             (VERSION)=Toughness,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN WillpowerBonus IS NOT NULL AND WillpowerBonus >= 0 THEN 'G+ ' ELSE 'R ' END,
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN WillpowerBonus IS NOT NULL AND WillpowerBonus >= 0 THEN 'G+ ' ELSE 'R ' END,
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '- ?' ELSE WillpowerBonus END, '{{)}}')=Willpower,
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '- ?' ELSE WillpowerBonus END, '{{)}}')=Willpower,
Line 60: Line 60:
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego,
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego,
             Description
             Description
   | where = _pageNamespace = 0 AND Description REGEXP '.*Ego.*'
   | where = _pageNamespace = 0 AND Description LIKE '%Ego%'
   | order by = _pageName ASC
   | order by = _pageName ASC
   | format = table
   | format = table
}}
}}
69

edits