Tears of Themis Wiki/New Content: Difference between revisions

From Tears of Themis Wiki
imported>Harmonea
No edit summary
imported>Harmonea
(visit previews -> icons)
 
(5 intermediate revisions by the same user not shown)
Line 16: Line 16:
-->{{#vardefine:latestIllustrationReleaseDate|{{#cargo_query:tables=Illustration|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestIllustrationReleaseDate|{{#cargo_query:tables=Illustration|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestFurnishingReleaseDate|{{#cargo_query:tables=FurnishingSet|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestFurnishingReleaseDate|{{#cargo_query:tables=FurnishingSet|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestNamecardReleaseDate|{{#cargo_query:tables=Namecard|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestVisitBackgroundReleaseDate|{{#cargo_query:tables=VisitBackground|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--
-->{{#vardefine:latestVisitClothingReleaseDate|{{#cargo_query:tables=VisitClothing|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!--


### Template Display
### Template Display
Line 23: 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 37: Line 41:
}}
}}


<div class="new-content-header">Newest [[Badge]](s)</div>
<div class="new-content-header">Newest Cosmetics</div>
{{#cargo_query:tables=Badge
{{#cargo_query:tables=Badge
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', iconImage, '|80px|link=Badges]]<br/>[[Badges|', name, ']]</div>')
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Badge</b><br/>[[File:', iconImage, '|x80px|link=Badges]]<br/>[[Badges|', name, ']]</div>')
|where=releaseDate>="{{#var:latestBadgeReleaseDate}}"
|where=releaseDate>="{{#var:latestBadgeReleaseDate}}"
|delimiter=
}}
{{#cargo_query:tables=Namecard
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;"><b>Namecard</b><br/>[[File:', iconImage, '|x80px|link=Namecards]]<br/>[[Namecards|', name, ']]</div>')
|where=releaseDate>="{{#var:latestNamecardReleaseDate}}"
|delimiter=
}}
{{#cargo_query:tables=VisitBackground
|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}}"
|delimiter=
}}
{{#cargo_query:tables=VisitClothing
|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}}"
|delimiter=
|delimiter=
}}
}}
Line 52: 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

Retrieved from "http://tot.wiki/index.php?title=Tears_of_Themis_Wiki/New_Content&oldid=14524"