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">New Cards</div>
<div class="new-content-header">Newest Cards</div>
{{Card icon|Luke "Shape of You"|text=Luke<br/>"Shape of You"}}
{{#invoke:CargoQuery|main
{{Card icon|Artem "Entwined Fate"|text=Artem<br/>"Entwined Fate"}}
|q?tables=Card,OrderByCase=CardCase,OrderByCase=MLCase
{{Card icon|Vyn "Cool Summer"|text=Vyn<br/>"Cool Summer"}}
|q?join=Card.featuredCharacter=MLCase.maleLead,Card.rarity=CardCase.cardRarity
{{Card icon|Marius "Twilight Beauty"|text=Marius<br/>"Twilight Beauty"}}
|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">New [[Invitation]](s)</div>
<div class="new-content-header">Newest [[Invitation]](s)</div>
<div style="text-align:center; display:inline-block; margin:8px;">
{{#cargo_query:tables=Invitation
[[File:Sugar Painting Invitation preview.png|150px|link=Invitation]]<br/>Sugar Painting
|fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', previewImage, '|150px|link=', _pageName, ']]<br/>[[', _pageName, '|', name, ']]</div>')
</div>
|where=releaseDate>="{{#var:latestInvitationReleaseDate}}"
<div style="text-align:center; display:inline-block; margin:8px;">
|delimiter=
[[File:Bucket Surprise Invitation preview.png|150px|link=Invitation]]<br/>Bucket Surprise
}}
</div>
<div style="text-align:center; display:inline-block; margin:8px;">
[[File:Whac-A-Mole Invitation preview.png|150px|link=Invitation]]<br/>Whac-A-Mole
</div>
<div style="text-align:center; display:inline-block; margin:8px;">
[[File:Ring Toss Expert Invitation preview.png|150px|link=Invitation]]<br/>Ring Toss Expert
</div>


<div class="new-content-header">New [[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, ']]')
|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">New [[Illustration]](s)</div>
<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>

Latest revision as of 08:07, 30 May 2022