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/>
{{#vardefineecho: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=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 LIKE '%{{EscQ|{{#var:cards}}}}%'
|q?where=name IN ({{#var:cards}})
|q?orderBy=rarity DESC
|q?orderBy=rarity DESC
|template=Card icon
|template=Card icon

Revision as of 08:14, 28 September 2023