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:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Assignments._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

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:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Assignments._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

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.