Template:Main page event tab: Difference between revisions
From Tears of Themis Wiki
No edit summary Tag: Reverted |
m (Reverted edits by Elaeagnifolia (talk) to last revision by [[User:imported>Harmonea|imported>Harmonea]]) Tag: Rollback |
||
Line 16: | Line 16: | ||
}}<!-- | }}<!-- | ||
-->{{#if:{{#var:banner}} | <nowiki/> | -->{{#if:{{#var:banner}} | <nowiki/> | ||
{{# | {{#vardefine:cards|{{#cargo_query:table=ShadowOfThemis__featuredCards,ShadowOfThemis | ||
|join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | |join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | ||
|fields=CONCAT(_value) | |fields=CONCAT("'", _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 IN ({{#var:cards}}) | ||
|q?orderBy=rarity DESC | |q?orderBy=rarity DESC | ||
|template=Card icon | |template=Card icon |