Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "Home/ask/assignments"

From PCGamingWiki, the wiki about fixing PC games
< Home‎ | ask
(changed lookups to use the #time parser function to automatically perform the necessary date calculates from the time the page was refreshed)
m (moved over to named args)
 
(2 intermediate revisions by one other user not shown)
Line 3: Line 3:
 
     <div class="month-container">
 
     <div class="month-container">
 
         <div class="month">
 
         <div class="month">
−
             <p>'''Current month: {{#time: F | now }}'''</p>
+
             <p>'''Next 10 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 9: Line 9:
 
             tables=Assignments
 
             tables=Assignments
 
             |fields=Game,Status,Release_Date
 
             |fields=Game,Status,Release_Date
−
             |where=DATEDIFF(Release_Date, '{{#time: Y-m-01 | now }}') >= 0 AND DATEDIFF(Release_Date, '{{#time: Y-m-01 | now +1 months }}') < 0
+
             |where=DATEDIFF(Release_Date, '{{#time: Y-m-d | now }}') >= 0
 
             |format=template
 
             |format=template
 +
            |named args=yes
 
             |template=:Home/ask/assignments/row
 
             |template=:Home/ask/assignments/row
 
             |order by=Release_Date ASC
 
             |order by=Release_Date ASC
 +
            |limit=10
 
             |more results text=
 
             |more results text=
 
             }}
 
             }}
 
         </table>
 
         </table>
 
     </div>
 
     </div>
−
 
−
----
 
−
 
−
    <div class="month-container">
 
−
        <div class="month">
 
−
            <p>'''Next month: {{#time: F | now +1 months }}'''</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-01 | now +1 months }}') >= 0 AND DATEDIFF(Release_Date, '{{#time: Y-m-01 | now +2 months }}') < 0
 
−
            |format=template
 
−
            |template=:Home/ask/assignments/row
 
−
            |order by=Release_Date ASC
 
−
            |more results text=
 
−
            }}
 
−
        </table>
 
−
    </div>
 
−
 
−
----
 
  
 
     <div class="month-container">
 
     <div class="month-container">
 
         <div class="month">
 
         <div class="month">
−
             <p>'''Previous month: {{#time: F | now -1 months }}'''</p>
+
             <p>'''Last 10 released:'''</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 47: Line 28:
 
             tables=Assignments
 
             tables=Assignments
 
             |fields=Game,Status,Release_Date
 
             |fields=Game,Status,Release_Date
−
             |where=DATEDIFF(Release_Date, '{{#time: Y-m-01 | now -1 months }}') >= 0 AND DATEDIFF(Release_Date, '{{#time: Y-m-01 | now }}') < 0
+
             |where=DATEDIFF(Release_Date, '{{#time: Y-m-d | now }}') < 0
 
             |format=template
 
             |format=template
 +
            |named args=yes
 
             |template=:Home/ask/assignments/row
 
             |template=:Home/ask/assignments/row
 
             |order by=Release_Date DESC
 
             |order by=Release_Date DESC
 +
            |limit=10
 
             |more results text=
 
             |more results text=
 
             }}
 
             }}

Latest revision as of 17:51, 7 April 2021

Next 10 upcoming:

30 Braid Anniversary Edition
07 Prison Architect 2
13 Homeworld 3
16 Ghost of Tsushima Director's Cut
21 Senua's Saga: Hellblade II
23 Songs of Silence
31 Selaco
31 F1 24
04 Life by You
14 Monster Hunter Stories

Last 10 released:

26 Manor Lords
26 Sand Land
25 SaGa Emerald Beyond
23 Eiyuden Chronicle: Hundred Heroes
23 Phantom Fury
18 No Rest for the Wicked
16 Harold Halibut
10 Broken Roads
09 Yellow Taxi Goes Vroom
05 Sons of Valhalla
Documentation for the above template (sometimes hidden from view).

Description

Purge the home page to refresh the lists.

This page makes use of the #cargo_query function along with relevant #time parser function to query data from the Assignments Cargo table (populated by the the Assignments/Table page) which is then transcluded unto Home. As part of the database query, the query makes use of the DATEDIFF() function to validate if the specified Release Date (also set on the the Assignments/Table page) is between two dates, the first day of the month or the first day of the next month.

The two future months listed first are ordered by the release date in ascending order. The bottom past month is ordered in descending order.