Difference between revisions of "Template:FeatsTable Category"
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
<wbr>|}}{{#cargo_query:tables=Feats, Feats__SubCategories | <wbr>|}}{{#cargo_query:tables=Feats, Feats__SubCategories | ||
|join on=Feats._ID=Feats__SubCategories._rowID | |join on=Feats._ID=Feats__SubCategories._rowID | ||
|group by=Feats._pageName | |||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | ||
|where=MainCategory = "{{{1}}}" AND Advanced = 0 AND Feats__SubCategories._value != 'Drawback' | |where=MainCategory = "{{{1}}}" AND Advanced = 0 AND Feats__SubCategories._value != 'Drawback' | ||
| Line 27: | Line 28: | ||
{{#cargo_query:tables=Feats, Feats__SubCategories | {{#cargo_query:tables=Feats, Feats__SubCategories | ||
|join on=Feats._ID=Feats__SubCategories._rowID | |join on=Feats._ID=Feats__SubCategories._rowID | ||
|group by=Feats._pageName | |||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | ||
|where=MainCategory = "{{{1}}}" AND Advanced = 1 AND Feats__SubCategories._value != 'Drawback' | |where=MainCategory = "{{{1}}}" AND Advanced = 1 AND Feats__SubCategories._value != 'Drawback' | ||
| Line 36: | Line 38: | ||
{{#cargo_query:tables=Feats, Feats__SubCategories | {{#cargo_query:tables=Feats, Feats__SubCategories | ||
|join on=Feats._ID=Feats__SubCategories._rowID | |join on=Feats._ID=Feats__SubCategories._rowID | ||
|group by=Feats._pageName | |||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name,CONCAT(Feats.SubCategories__full)=Categories,Prereq=Prerequisites,Short=Benefit | ||
|where=MainCategory = "{{{1}}}" AND Feats__SubCategories._value = 'Drawback' | |where=MainCategory = "{{{1}}}" AND Feats__SubCategories._value = 'Drawback' | ||
Revision as of 14:05, 4 September 2021
Parameters
1(required): The MainCategory to filter for. (Guardian)
2(optional): Description to place under the heading. Default: none. (These are feats from the Guardian Sphere)
3(optional): Heading to use instead of the filter category name. Default: MainCategory name (Guardian Feats)
4(optional): Heading-level of the tables Heading. Default: 2 (3)
5(optional): Should advanced feats be shown. Default: no
Template: {{FeatsTable_Category|}}