Template:Creature navbox query: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
(replaced with cargoquery module for testing)
(exclude pets)
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=CONCAT(CreatureFactions._pageName)=Page|q?where=Faction="{{{1|Crabs}}}" AND CreatureFactions._pageNamespace ='0'|q?orderBy=CreatureFactions._pageName|q?groupBy=CreatureFactions._pageName|format=template|template=favilink|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span></includeonly><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.