Template:Creature navbox query: Difference between revisions
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI | |q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI | ||
|q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName | |q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName | ||
|q?fields=GD. | |q?fields=GD.ObjectID=Page | ||
|q?where=Faction='{{#replace:{{{1|}}}|'|\'}}' AND GD._pageNamespace ='0' {{#switch:{{{2|_NULL_}}}|common= AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)|unique= AND EI.Info LIKE "%Unique,%"|}}{{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}} | |q?where=Faction='{{#replace:{{{1|}}}|'|\'}}' AND GD._pageNamespace ='0' {{#switch:{{{2|_NULL_}}}|common= AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)|unique= AND EI.Info LIKE "%Unique,%"|}}{{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}} | ||
|q?groupBy= | |q?groupBy=GD.ObjectID | ||
|template=favilink | |template=favilink id | ||
|delimiter= - </span><span style="display:inline-block">}}</span></includeonly><noinclude>[[Category:Query Templates]] | |delimiter= - </span><span style="display:inline-block">}}</span></includeonly><noinclude>[[Category:Query Templates]] | ||
A query that returns all creatures favilinked within a faction, delimited by hyphens. First argument must be the faction name. | A query that returns all creatures favilinked within a faction, delimited by hyphens. First argument must be the faction name. |
Revision as of 17:33, 5 February 2021
A query that returns all creatures favilinked within a faction, delimited by hyphens. First argument must be the faction name.
argument | value | returns |
---|---|---|
2 | common | returns all common creatures (not unique) |
unique | returns all unique creatures | |
category | <Category Name> | returns all creatures in the specified category |
notcategory | <Category Name> | returns all creatures NOT in the specified category |
By default, all creatures will be returned together regardless of unique status or category.