Latest revision |
Your text |
Line 11: |
Line 11: |
| ### Variable Defines | | ### Variable Defines |
|
| |
|
| -->{{#vardefine:latestCardReleaseDate|{{#cargo_query:tables=Card|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | | -->{{#vardefine:latestCardReleaseDate|}}<!-- |
| -->{{#vardefine:latestInvitationReleaseDate|{{#cargo_query:tables=Invitation|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | | -->{{#vardefine:latestInvitationReleaseDate|}}<!-- |
| -->{{#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 24: |
Line 19: |
| --> | | --> |
| <div style="text-align: center;"> | | <div style="text-align: center;"> |
| <div class="new-content-header">Newest Cards</div> | | <div class="new-content-header">New Cards</div> |
| {{#invoke:CargoQuery|main | | {{Card icon|Luke "Shape of You"|text=Luke<br/>"Shape of You"}} |
| |q?tables=Card,OrderByCase=CardCase,OrderByCase=MLCase | | {{Card icon|Artem "Entwined Fate"|text=Artem<br/>"Entwined Fate"}} |
| |q?join=Card.featuredCharacter=MLCase.maleLead,Card.rarity=CardCase.cardRarity | | {{Card icon|Vyn "Cool Summer"|text=Vyn<br/>"Cool Summer"}} |
| |q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', Card.rarity, '<br/>"', cardName, '"')=text | | {{Card icon|Marius "Twilight Beauty"|text=Marius<br/>"Twilight Beauty"}} |
| |q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | |
| |q?orderBy=CardCase.orderCase ASC, MLCase.orderCase ASC | |
| |template=Card icon | |
| }} | |
|
| |
|
| <div class="new-content-header">Newest [[Invitation]](s)</div> | | <div class="new-content-header">New [[Invitation]](s)</div> |
| {{#cargo_query:tables=Invitation
| | <div style="text-align:center; display:inline-block; margin:8px;"> |
| |fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', previewImage, '|150px|link=', _pageName, ']]<br/>[[', _pageName, '|', name, ']]</div>')
| | [[File:Sugar Painting Invitation preview.png|150px|link=Invitation]]<br/>Sugar Painting |
| |where=releaseDate>="{{#var:latestInvitationReleaseDate}}"
| | </div> |
| |delimiter= | | <div style="text-align:center; display:inline-block; margin:8px;"> |
| }}
| | [[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">Newest Cosmetics</div> | | <div class="new-content-header">New [[Badge]](s)</div> |
| {{#cargo_query:tables=Badge | | {{#cargo_query:tables=Badge |
| |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>') | | |fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', iconImage, '|80px|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">Newest [[Illustration]](s)</div> | | <div class="new-content-header">New [[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> |