Tears of Themis Wiki/New Content: Difference between revisions
From Tears of Themis Wiki
imported>Elaeagnifolia mNo edit summary |
imported>Harmonea (visit previews -> icons) |
||
(15 intermediate revisions by 2 users not shown) | |||
Line 11: | Line 11: | ||
### Variable Defines | ### Variable Defines | ||
-->{{#vardefine:latestCardReleaseDate|}}<!-- | -->{{#vardefine:latestCardReleaseDate|{{#cargo_query:tables=Card|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | ||
-->{{#vardefine:latestInvitationReleaseDate|}}<!-- | -->{{#vardefine:latestInvitationReleaseDate|{{#cargo_query:tables=Invitation|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | ||
-->{{#vardefine:latestBadgeReleaseDate|{{#cargo_query:tables=Badge|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | -->{{#vardefine:latestBadgeReleaseDate|{{#cargo_query:tables=Badge|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: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 19: | Line 24: | ||
--> | --> | ||
<div style="text-align: center;"> | <div style="text-align: center;"> | ||
<div class="new-content-header"> | <div class="new-content-header">Newest Cards</div> | ||
{{ | {{#invoke:CargoQuery|main | ||
|q?tables=Card,OrderByCase=CardCase,OrderByCase=MLCase | |||
|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?orderBy=CardCase.orderCase ASC, MLCase.orderCase ASC | |||
|template=Card icon | |||
}} | |||
<div class="new-content-header"> | <div class="new-content-header">Newest [[Invitation]](s)</div> | ||
{{#cargo_query:tables=Invitation | |||
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', previewImage, '|150px|link=', _pageName, ']]<br/>[[', _pageName, '|', name, ']]</div>') | |||
|where=releaseDate>="{{#var:latestInvitationReleaseDate}}" | |||
<div style="text-align:center; display:inline-block; margin:8px;"> | |delimiter= | ||
[[File: | }} | ||
[[ | |||
<div class="new-content-header"> | <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, '| | |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= | ||
}} | }} | ||
<div class="new-content-header"> | <div class="new-content-header">Newest [[Illustration]](s)</div> | ||
{{#invoke:CargoQuery|main | |||
|q?tables=Illustration | |||
|q?fields=image=image,CONCAT('150px')=size | |||
|q?where=releaseDate>="{{#var:latestIllustrationReleaseDate}}" | |||
|template=Spoiler | |||
}} | |||
<div class="new-content-header">Newest [[NXX Lounge|Lounge Set]]</div> | |||
{{#cargo_query:tables=FurnishingSet, Furnishing | |||
|join on=FurnishingSet.name = Furnishing.furnishingSet | |||
|fields=CONCAT('[[File:', Furnishing.icon, '|60px|link=', FurnishingSet.name, ' Lounge]]') | |||
|where=releaseDate>="{{#var:latestFurnishingReleaseDate}}" | |||
|delimiter= | |||
}} | |||
{{#cargo_query:tables=FurnishingSet | |||
|fields=CONCAT('<br />[[', name, ' Lounge]]') | |||
|where=releaseDate>="{{#var:latestFurnishingReleaseDate}}" | |||
|delimiter= | |||
}} | |||
</div> | </div> |