Template:Main page event tab: Difference between revisions
From Tears of Themis Wiki
m (Reverted edits by Elaeagnifolia (talk) to last revision by [[User:imported>Harmonea|imported>Harmonea]]) Tags: Rollback Reverted |
No edit summary Tag: Reverted |
||
Line 18: | Line 18: | ||
{{#vardefine:cards|{{#cargo_query:table=ShadowOfThemis__featuredCards,ShadowOfThemis | {{#vardefine:cards|{{#cargo_query:table=ShadowOfThemis__featuredCards,ShadowOfThemis | ||
|join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | |join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | ||
|fields= | |fields=_value | ||
|where=ShadowOfThemis.name='{{EscQ|{{#var:banner}}}}' | |where=ShadowOfThemis.name='{{EscQ|{{#var:banner}}}}' | ||
|default='' | |default='' | ||
Line 27: | Line 27: | ||
|q?tables=Card | |q?tables=Card | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text,CONCAT('64px')=size | |q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text,CONCAT('64px')=size | ||
|q?where=name | |q?where=name LIKE '%{{EscQ|{{#var:cards}}}}%' | ||
|q?orderBy=rarity DESC | |q?orderBy=rarity DESC | ||
|template=Card icon | |template=Card icon |