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

Revision as of 08:10, 28 September 2023