Tears of Themis Wiki/New Content: Difference between revisions

From Tears of Themis Wiki
imported>Harmonea
(Trying out a general cosmetics display in place of only a badge display)
imported>Harmonea
(visit previews -> icons)
 
(4 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=rarity DESC
|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:', image, '|x80px|link=Visit Invitation Backgrounds]]<br/>[[Visit Invitation Backgrounds|', name, ']]</div>')
|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 Costume</b><br/>[[File:', image, '|x80px|link=Visit Invitation Clothing]]<br/>[[Visit Invitation Clothing|', name, ']]</div>')
|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=
Line 70: Line 71:
}}
}}


<div class="new-content-header">Newest Furnishings</div>
<div class="new-content-header">Newest [[NXX Lounge|Lounge Set]]</div>
{{#cargo_query:tables=FurnishingSet, Furnishing
{{#cargo_query:tables=FurnishingSet, Furnishing
|join on=FurnishingSet.name = Furnishing.furnishingSet
|join on=FurnishingSet.name = Furnishing.furnishingSet

Latest revision as of 08:07, 30 May 2022