PCGamingWiki:Assignments/Table
What games should be included?
Only 'notable' games should be on the list:
- No games that are 'shovelware'.
- Popular games (anticipated to have 100+ concurrent players).
- Important or critically acclaimed games.
Data source
The data from the Assignments page and the Home page are sourced from the table below.
Statistics
Total games assigned and completed to date:
Function: CargoSQLQuery::run Query: SELECT `cargo__Assignments`.`_pageID` AS `cargo_backlink_page_id_Assignments`,COUNT(*) FROM `cargo__Assignments` WHERE Status = "complete" OR Status = "limited" ORDER BY `cargo__Assignments`.`_pageID`,COUNT(*) LIMIT 100
Total since 'new' wiki Assignments system implemented March 25, 2019:
Function: CargoSQLQuery::run Query: SELECT `cargo__Assignments`.`_pageID` AS `cargo_backlink_page_id_Assignments`,COUNT(*) FROM `cargo__Assignments` WHERE Status = "complete" ORDER BY `cargo__Assignments`.`_pageID`,COUNT(*) LIMIT 100
Syntax
{{Assignment/row| title | state | platform | release_date | applied | completion_date | assigned | notes }}
title
should match the name of the PCGW article of the game.state
can be various states, but the common ones are available, assigned, complete, and not available. Visit Template:Assignment/tickcross to see all possible states.platform
works the same as the DRM column of the Availability table.release_date
expects the typical MMMM DD, YYYY format (e.g. January 1, 1970). Might or might not work with other date formats.applied
is a list of users (comma-delimited) whom have applied for the assignment so far.completion_date
is the date when the assignment was completed by the assigned user(s).assigned
is a list of users (comma-delimited) whom have been assigned to perform the assignment.notes
is for notes that might apply.
Assignment available! | Already assigned. | Assignment completed! | Assignment not available. | ||||
Visit Template:Assignment/tickcross to see all possible states. |
2021
- The rows in this table feed the data for the Assignments page and also the Notable releases widget on the Home page.
2020
- See the 2020 subpage.
2019
- See the 2019 subpage.
Legacy
- See the Legacy subpage.