Difference between revisions of "PCGamingWiki:Assignments/Table"

Revision as of 00:27, 9 January 2022

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.

	Assignment available!		Already assigned.		Assignment completed!		Assignment not available.
Visit Template:Assignment/tickcross to see all possible states.

2022

The rows in this table feed the data for the Assignments page and also the Notable releases widget on the Home page.

Game	Release Date	Notes
Uncharted: Legacy of Thieves Collection	December 31, 2022	Placeholder date for 2022.
Starfield	November 11, 2022
Saints Row	August 23, 2022
Forspoken	May 24, 2022
S.T.A.L.K.E.R. 2: Heart of Chernobyl	April 28, 2022
Tiny Tina's Wonderlands	March 25, 2022
Stranger of Paradise: Final Fantasy Origin	March 18, 2022
Persona 4 Arena Ultimax	March 17, 2022
Babylon's Fall	March 3, 2022
ELEX II	March 1, 2022
Evil Dead: The Game	February 28, 2022	Placeholder date for February 2022. Review code requested December 11, 2020 (Sandbox Strategies).
Elden Ring	February 25, 2022
Total War: Warhammer III	February 17, 2022
Dying Light 2 Stay Human	February 4, 2022
Life is Strange: Before the Storm Remastered	February 1, 2022
Life Is Strange Remastered	February 1, 2022
Tom Clancy's Rainbow Six Extraction	January 20, 2022
God of War	January 14, 2022
Monster Hunter Rise	January 12, 2022

2021

See the first half of 2021 and second half of 2021 subpages.

2020

See the 2020 subpage.

2019

See the 2019 subpage.

Legacy

See the Legacy subpage.