Difference between revisions of "PCGamingWiki:Assignments/Table"
From PCGamingWiki, the wiki about fixing PC games
(→2021: two GOG.com account additions) |
(→2021: added Surviving the Aftermath, some dates corrected) |
||
| Line 61: | Line 61: | ||
{{Assignment/row| Icarus | unknown | unknown | November 20, 2021 | | | | }} | {{Assignment/row| Icarus | unknown | unknown | November 20, 2021 | | | | }} | ||
{{Assignment/row| Battlefield 2042 | unknown | unknown | November 19, 2021 | Shadowstealer7 | | | }} | {{Assignment/row| Battlefield 2042 | unknown | unknown | November 19, 2021 | Shadowstealer7 | | | }} | ||
| − | {{Assignment/row| Hammerting | unknown | unknown | November 16, | + | {{Assignment/row| Hammerting | unknown | unknown | November 16, 2021 | | | | Release from early access. }} |
| − | {{Assignment/row| Sherlock Holmes: Chapter One | unknown | unknown | November 16, | + | {{Assignment/row| Sherlock Holmes: Chapter One | unknown | unknown | November 16, 2021 | | | | }} |
| − | {{Assignment/row| The Last Stand: Aftermath | unknown | unknown | November 16, | + | {{Assignment/row| Surviving the Aftermath | available | Epic Games Store | November 16, 2021 | | | | Release from early access. Review code requested October 19, 2019 (Paradox Interactive), received October 28, 2019. }} |
| + | {{Assignment/row| The Last Stand: Aftermath | unknown | unknown | November 16, 2021 | | | | }} | ||
{{Assignment/row| Breakwaters | unknown | unknown | November 11, 2021 | | | | Release to early access. }} | {{Assignment/row| Breakwaters | unknown | unknown | November 11, 2021 | | | | Release to early access. }} | ||
{{Assignment/row| Grand Theft Auto: The Trilogy – The Definitive Edition | unknown | Rockstar Games Launcher | November 11, 2021 | | | | }} | {{Assignment/row| Grand Theft Auto: The Trilogy – The Definitive Edition | unknown | Rockstar Games Launcher | November 11, 2021 | | | | }} | ||
Revision as of 14:12, 27 October 2021
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 }}
titleshould match the name of the PCGW article of the game.statecan be various states, but the common ones are available, assigned, complete, and not available. Visit Template:Assignment/tickcross to see all possible states.platformworks the same as the DRM column of the Availability table.release_dateexpects the typical MMMM DD, YYYY format (e.g. January 1, 1970). Might or might not work with other date formats.appliedis a list of users (comma-delimited) whom have applied for the assignment so far.completion_dateis the date when the assignment was completed by the assigned user(s).assignedis a list of users (comma-delimited) whom have been assigned to perform the assignment.notesis 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.