Latest revision |
Your text |
Line 14: |
Line 14: |
| -->{{#vardefine:latestInvitationReleaseDate|{{#cargo_query:tables=Invitation|fields=releaseDate|order by=releaseDate DESC|limit=1|more results text=|no html}}}}<!-- | | -->{{#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 26: |
Line 21: |
| <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,OrderByCase=CardCase,OrderByCase=MLCase | | |q?tables=Card |
| |q?join=Card.featuredCharacter=MLCase.maleLead,Card.rarity=CardCase.cardRarity
| | |q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text |
| |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 36: |
Line 30: |
| <div class="new-content-header">Newest [[Invitation]](s)</div> | | <div class="new-content-header">Newest [[Invitation]](s)</div> |
| {{#cargo_query:tables=Invitation | | {{#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>') | | |fields=CONCAT('<div style="text-align:center; display:inline-block; margin:8px;">[[File:', previewImage, '|150px|link=Invitations]]<br/>[[Invitations|', name, ']]</div>') |
| |where=releaseDate>="{{#var:latestInvitationReleaseDate}}" | | |where=releaseDate="{{#var:latestInvitationReleaseDate}}" |
| |delimiter= | | |delimiter= |
| }} | | }} |
|
| |
|
| <div class="new-content-header">Newest Cosmetics</div> | | <div class="new-content-header">Newest [[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>
| |
| {{#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> |