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
m (limited query to only poll from PCGamingWiki:Assignments/Table)
m (Undo revision 830871 by Aemony (talk) applied central filtering instead)
Tag: Undo
Line 9: Line 9:
 
             tables=Assignments
 
             tables=Assignments
 
             |fields=Game,Status,Release_Date
 
             |fields=Game,Status,Release_Date
−
             |where=_pageName = 'PCGamingWiki:Assignments/Table' AND DATEDIFF(Release_Date, '2019-09-01') >= 0 AND DATEDIFF(Release_Date, '2019-10-01') < 0
+
             |where=DATEDIFF(Release_Date, '2019-09-01') >= 0 AND DATEDIFF(Release_Date, '2019-10-01') < 0
 
             |format=template
 
             |format=template
 
             |template=:Home/ask/assignments/row
 
             |template=:Home/ask/assignments/row
Line 26: Line 26:
 
             tables=Assignments
 
             tables=Assignments
 
             |fields=Game,Status,Release_Date
 
             |fields=Game,Status,Release_Date
−
             |where=_pageName = 'PCGamingWiki:Assignments/Table' AND DATEDIFF(Release_Date, '2019-08-01') >= 0 AND DATEDIFF(Release_Date, '2019-09-01') < 0
+
             |where=DATEDIFF(Release_Date, '2019-08-01') >= 0 AND DATEDIFF(Release_Date, '2019-09-01') < 0
 
             |format=template
 
             |format=template
 
             |template=:Home/ask/assignments/row
 
             |template=:Home/ask/assignments/row
Line 43: Line 43:
 
             tables=Assignments
 
             tables=Assignments
 
             |fields=Game,Status,Release_Date
 
             |fields=Game,Status,Release_Date
−
             |where=_pageName = 'PCGamingWiki:Assignments/Table' AND DATEDIFF(Release_Date, '2019-07-01') >= 0 AND DATEDIFF(Release_Date, '2019-08-01') < 0
+
             |where=DATEDIFF(Release_Date, '2019-07-01') >= 0 AND DATEDIFF(Release_Date, '2019-08-01') < 0
 
             |format=template
 
             |format=template
 
             |template=:Home/ask/assignments/row
 
             |template=:Home/ask/assignments/row

Revision as of 13:01, 1 August 2019

September

29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]

August

29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]

July

29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]
29 [[]]


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.