Template:Main page event tab: Difference between revisions
From Tears of Themis Wiki
No edit summary Tag: Reverted |
mNo edit summary |
||
(19 intermediate revisions by one other user not shown) | |||
Line 16: | Line 16: | ||
}}<!-- | }}<!-- | ||
-->{{#if:{{#var:banner}} | <nowiki/> | -->{{#if:{{#var:banner}} | <nowiki/> | ||
{{#vardefine:cards|{{#cargo_query:table=ShadowOfThemis__featuredCards,ShadowOfThemis | {{#vardefine:cards|{{#replace:{{EscQ|{{#cargo_query:table=ShadowOfThemis__featuredCards,ShadowOfThemis | ||
|join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | |join on=ShadowOfThemis__featuredCards._rowId=ShadowOfThemis._ID | ||
|fields=CONCAT(" | |fields=CONCAT("@", _value, "@") | ||
|where=ShadowOfThemis.name='{{EscQ|{{#var:banner}}}}' | |where=ShadowOfThemis.name='{{EscQ|{{#var:banner}}}}' | ||
|default='' | |default='' | ||
|no html | |no html | ||
}} | }} | ||
}}|@|'}} | |||
}} | }} | ||
{{#invoke:CargoQuery|main | {{#invoke:CargoQuery|main | ||
|q?tables=Card | |q?tables=Card | ||
|q?fields=name=name,featuredCharacterShortName | |q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text,CONCAT('64px')=size | ||
|q?where=name IN ({{#var:cards}}) | |q?where=name IN ({{#var:cards}}) | ||
|q?orderBy=rarity DESC | |q?orderBy=rarity DESC |