8,756
edits
mNo edit summary |
(exclude pets) |
||
(17 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
<includeonly><span style="display:inline-block">{{# | <includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main | ||
|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI | |||
|q?join=CF.ObjectID=GD.ObjectID, CF.ObjectID=EI.ObjectID | |||
|q?fields={{favilink format args}} | |||
|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}}}')}} AND GD.Categories <> 'Pets' | |||
|q?groupBy=GD.ObjectID | |||
|template=favilink format | |||
|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. | |||
{|class="wikitable" | |||
!argument | |||
!value | |||
!returns | |||
|- | |||
|rowspan="2"|'''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. | |||
</noinclude> |