User:Alephander/attributes: Difference between revisions

Line 61: Line 61:
             Description
             Description
   | where = _pageNamespace = 0 AND Description LIKE '%Strength%'
   | where = _pageNamespace = 0 AND Description LIKE '%Strength%'
  | order by = _pageName ASC
  | format = table
}}
reputation items
{{#cargo_query:
  | tables = ItemsTable
  | fields = CONCAT('{{(}}favilink id{{!}}',ObjectID,'{{)}}')=Equipment,
            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,
            Description
  | where = _pageNamespace = 0 AND Description LIKE '%reputation%'
   | order by = _pageName ASC
   | order by = _pageName ASC
   | format = table
   | format = table
}}
}}
69

edits