Tears of Themis Wiki/New Content: Difference between revisions
From Tears of Themis Wiki
imported>Elaeagnifolia No edit summary |
imported>Elaeagnifolia No edit summary |
||
Line 24: | Line 24: | ||
|q?tables=Card | |q?tables=Card | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text | |q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text | ||
|q?where=releaseDate="{{#var:latestCardReleaseDate}}" | |q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | ||
|q?orderBy=rarity DESC | |q?orderBy=rarity DESC | ||
|template=Card icon | |template=Card icon | ||
Line 32: | Line 32: | ||
{{#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=', _pageName, ']]<br/>[[', _pageName, '|', name, ']]</div>') | ||
|where=releaseDate="{{#var:latestInvitationReleaseDate}}" | |where=releaseDate>="{{#var:latestInvitationReleaseDate}}" | ||
|delimiter= | |delimiter= | ||
}} | }} | ||
Line 39: | Line 39: | ||
{{#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;">[[File:', iconImage, '|80px|link=Badges]]<br/>[[Badges|', name, ']]</div>') | ||
|where=releaseDate="{{#var:latestBadgeReleaseDate}}" | |where=releaseDate>="{{#var:latestBadgeReleaseDate}}" | ||
|delimiter= | |delimiter= | ||
}} | }} | ||
Line 47: | Line 47: | ||
|q?tables=Illustration | |q?tables=Illustration | ||
|q?fields=image=image,CONCAT('150px')=size | |q?fields=image=image,CONCAT('150px')=size | ||
|q?where=releaseDate="{{#var:latestIllustrationReleaseDate}}" | |q?where=releaseDate>="{{#var:latestIllustrationReleaseDate}}" | ||
|template=Spoiler | |template=Spoiler | ||
}} | }} | ||
</div> | </div> |