Template:Mainpage/New Releases: Difference between revisions

From Love and Deepspace Wiki
Browse history interactively
Content added Content deleted
VisualWikitext
(Created page with "<div class="mainpage-new-releases mainpage-card"> <div class="mainpage-card-label">New Releases</div> </div>")
 
mNo edit summary
 
(21 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div class="mainpage-new-releases mainpage-card">
<div class="mainpage-new-releases mainpage-card">
<div class="mainpage-card-label">New Releases</div>
<div class="mainpage-card-label">New Releases</div>
<div class="mainpage-card-subsection">
<div class="mainpage-card-sublabel">Upcoming/Active Wishing Pools</div>
{{#vardefine:time|{{#time:Y-m-d H:m:s|-7 hours|now}}}}
<div class="mainpage-new-releases-pool">
{{#invoke:CargoQuery|main
|q?tables=WishingPool
|q?fields=name=name,bannerImage=bannerImage,poolType=poolType,startDate=startDate,endDate=endDate
|q?where=endDate >= "{{#var:time}}"
|q?orderBy=startDate DESC, _rowID DESC
|template=Mainpage/New Releases/Wishing Pool tab
}}
</div>
</div>

<div class="mainpage-card-subsection">
<div class="mainpage-card-sublabel">Latest/Upcoming Memories</div>
{{#invoke:CargoQuery|main
|q?tables=Memory
|q?fields=_pageName=name
|q?where=releaseDate="{{#cargo_query:tables=Memory
|fields=releaseDate
|limit=1
|order by=releaseDate DESC
|default=
|group by=_pageName
|no html
}}"
|template=IIT
|delimiter=<br/>
}}
</div>
<!--
<div class="mainpage-card-subsection">
<div class="mainpage-card-sublabel">New Unlockables</div>

</div>
-->
<div class="mainpage-card-subsection">
<div class="mainpage-card-sublabel">Latest/Upcoming Miscellaneous</div>
{{#cargo_query:tables=Item
|fields=_pageName
|where=(category NOT LIKE "%Event Item%" AND category NOT LIKE "%Event Token%") AND releaseDate="{{#cargo_query:tables=Item
|fields=releaseDate
|limit=1
|order by=releaseDate DESC
|default=
|no html
}}"
|group by=_pageName
|format=ul
|columns=3
}}
{{#cargo_query:tables=Title
|fields=CONCAT('Title: [[', _pageName, ']]')
|where=releaseDate="{{#cargo_query:tables=Title
|fields=releaseDate
|limit=1
|order by=releaseDate DESC
|default=
|no html
}}"
|group by=_pageName
|format=ul
|columns=3
}}
</div>
</div>
</div>

Latest revision as of 00:09, 4 April 2024

New Releases
Upcoming/Active Wishing Pools

File:Entwined Shadows banner.png
Entwined Shadows (Limited - Three Featured)
2024-06-25 05:00:00 - 2024-07-10 04:59:00

Latest/Upcoming Memories

Xavier: Lost Signal Xavier: Lost Signal

Latest/Upcoming Miscellaneous
Retrieved from "https://lads.wiki/wiki/Template:Mainpage/New_Releases?oldid=6331"