Template:Creature navbox query: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
(Created page with "{{#cargo_query:table=CreatureFactions,GeneralData|join on=CreatureFactions._pageName=GeneralData._pageName|fields=CONCAT('16px ',CreatureFacti...")
 
(exclude pets)
 
(19 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{#cargo_query:table=CreatureFactions,GeneralData|join on=CreatureFactions._pageName=GeneralData._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']]')|format=list|delimiter=<nowiki> - </nowiki>|where=Faction="{{{1|}}}" AND CreatureFactions._pageNamespace ='0'|order by=CreatureFactions._pageName|group by=CreatureFactions._pageName}}<noinclude>[[Category:Query Templates]]</noinclude>
<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=&nbsp;-&#160;</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>

Latest revision as of 19:02, 26 December 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.

Retrieved from "https://wiki.cavesofqud.com/index.php?title=Template:Creature_navbox_query&oldid=65850"