Tears of Themis Wiki/New Content: Difference between revisions
From Tears of Themis Wiki
imported>Harmonea (+link to new lounge page) |
imported>Harmonea (visit previews -> icons) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 26: | Line 26: | ||
<div class="new-content-header">Newest Cards</div> | <div class="new-content-header">Newest Cards</div> | ||
{{#invoke:CargoQuery|main | {{#invoke:CargoQuery|main | ||
|q?tables=Card | |q?tables=Card,OrderByCase=CardCase,OrderByCase=MLCase | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text | |q?join=Card.featuredCharacter=MLCase.maleLead,Card.rarity=CardCase.cardRarity | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', Card.rarity, '<br/>"', cardName, '"')=text | |||
|q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | |q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | ||
|q?orderBy= | |q?orderBy=CardCase.orderCase ASC, MLCase.orderCase ASC | ||
|template=Card icon | |template=Card icon | ||
}} | }} | ||
Line 52: | Line 53: | ||
}} | }} | ||
{{#cargo_query:tables=VisitBackground | {{#cargo_query:tables=VisitBackground | ||
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Visit BG</b><br/>[[File:', | |fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Visit BG</b><br/>[[File:', icon, '|x80px|link=Visit Invitation Backgrounds]]<br/>[[Visit Invitation Backgrounds|', name, ']]</div>') | ||
|where=releaseDate>="{{#var:latestVisitBackgroundReleaseDate}}" | |where=releaseDate>="{{#var:latestVisitBackgroundReleaseDate}}" | ||
|delimiter= | |delimiter= | ||
}} | }} | ||
{{#cargo_query:tables=VisitClothing | {{#cargo_query:tables=VisitClothing | ||
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Visit | |fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Visit Outfit</b><br/>[[File:', icon, '|x80px|link=Visit Invitation Outfits]]<br/>[[Visit Invitation Outfits|', name, ']]</div>') | ||
|where=releaseDate>="{{#var:latestVisitClothingReleaseDate}}" | |where=releaseDate>="{{#var:latestVisitClothingReleaseDate}}" | ||
|delimiter= | |delimiter= |