Difference between revisions of "User:Andytizer/Home"
From PCGamingWiki, the wiki about fixing PC games
| Line 5: | Line 5: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
| − | <p>'''Next | + | <p>'''Next 5 upcoming:'''</p> |
</div> | </div> | ||
<table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | ||
| Line 15: | Line 15: | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
|order by=Release_Date ASC | |order by=Release_Date ASC | ||
| − | |limit= | + | |limit=5 |
| + | |more results text= | ||
| + | }} | ||
| + | </table> | ||
| + | </div> | ||
| + | |||
| + | |||
| + | <div class="month-container"> | ||
| + | <div class="month"> | ||
| + | <p>'''Last 5 released:'''</p> | ||
| + | </div> | ||
| + | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | ||
| + | {{#cargo_query: | ||
| + | tables=Assignments | ||
| + | |fields=Game,Status,Release_Date | ||
| + | |where=DATEDIFF(Release_Date, '{{#time: Y-m-d | now }}') < 0 | ||
| + | |format=template | ||
| + | |template=:Home/ask/assignments/row | ||
| + | |order by=Release_Date DESC | ||
| + | |limit=5 | ||
|more results text= | |more results text= | ||
}} | }} | ||