User:Alephander/attributes: Difference between revisions

Line 59: Line 59:
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN EgoBonus IS NOT NULL AND EgoBonus >= 0 THEN 'G+ ' ELSE 'R ' END,  
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN EgoBonus IS NOT NULL AND EgoBonus >= 0 THEN 'G+ ' ELSE 'R ' END,  
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego
   | where = _pageNamespace = 0 AND (IntelligenceBonus IS NOT NULL OR EgoBonus IS NOT NULL) AND Description LIKE '%+1 Strength%'
   | where = _pageNamespace = 0 AND Description LIKE '%+1 Strength%'
   | order by = _pageName ASC
   | order by = _pageName ASC
   | format = table
   | format = table
}}
}}
69

edits