Difference between revisions of "PCGamingWiki:Assignments/Table"
From PCGamingWiki, the wiki about fixing PC games
(Added Amnesia The Bunker with it's delayed release date) |
(Road 96 Mile 0, Age of Wonders 4, Redfall) |
||
| Line 61: | Line 61: | ||
{{Assignment/row| Endless Dungeon | unknown | unknown | May 18, 2023 | | | | }} | {{Assignment/row| Endless Dungeon | unknown | unknown | May 18, 2023 | | | | }} | ||
{{Assignment/row| Amnesia: The Bunker | unknown | unknown | May 16, 2023 | | | | }} | {{Assignment/row| Amnesia: The Bunker | unknown | unknown | May 16, 2023 | | | | }} | ||
| + | {{Assignment/row| Redfall | unknown | unknown | May 2, 2023 | | | | }} | ||
| + | {{Assignment/row| Age of Wonders 4 | unknown | unknown | May 2, 2023 | | | | }} | ||
| + | {{Assignment/row| Star Wars Jedi: Survivor | unknown | unknown | April 28, 2023 | Fayaine, Shadowstealer7 | | | }} | ||
{{Assignment/row| Dead Island 2 | unknown | unknown | April 28, 2023 | | | | }} | {{Assignment/row| Dead Island 2 | unknown | unknown | April 28, 2023 | | | | }} | ||
| − | |||
{{Assignment/row| Minecraft Legends | unknown | unknown | April 18, 2023 | | | | }} | {{Assignment/row| Minecraft Legends | unknown | unknown | April 18, 2023 | | | | }} | ||
| + | {{Assignment/row| Road 96: Mile 0 | unknown | unknown | April 4, 2023 | | | | }} | ||
{{Assignment/row| Resident Evil 4 (2023) | unknown | unknown | March 24, 2023 | Fayaine | | | }} | {{Assignment/row| Resident Evil 4 (2023) | unknown | unknown | March 24, 2023 | Fayaine | | | }} | ||
{{Assignment/row| Atelier Ryza 3: Alchemist of the End & the Secret Key | unknown | unknown | March 24, 2023 | Fayaine | | | }} | {{Assignment/row| Atelier Ryza 3: Alchemist of the End & the Secret Key | unknown | unknown | March 24, 2023 | Fayaine | | | }} | ||
Revision as of 07:39, 2 February 2023
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. | |||||||
2023
- 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 | Applied | Completion Date | Assigned | Notes | ||
|---|---|---|---|---|---|---|---|
| AEW Fight Forever |  |
December 31, 2023 | Jigen123 (t|c|a) | Placeholder date for 2023. | |||
| Skull and Bones | |
December 31, 2023 | Placeholder date for 2023. | ||||
| Forza Motorsport | |
December 31, 2023 | Placeholder date for 2023. | ||||
| The Day Before | |
November 10, 2023 | |||||
| Baldur's Gate III | |
August 31, 2023 | Placeholder date for August 2023. Release from early access. | ||||
| The Legend of Heroes: Trails into Reverie | |
July 7, 2023 | Fayaine (t|c|a) | ||||
| Forever Skies | |
June 30, 2023 | Placeholder date for Q2 2023. | ||||
| Diablo IV | |
June 6, 2023 | |||||
| Street Fighter 6 | |
June 2, 2023 | MasterBlaster (t|c|a) | ||||
| Suicide Squad: Kill the Justice League | |
May 26, 2023 | mrtnptrs (t|c|a) | ||||
| Endless Dungeon | |
May 18, 2023 | |||||
| Amnesia: The Bunker | |
May 16, 2023 | |||||
| Redfall | |
May 2, 2023 | |||||
| Age of Wonders 4 | |
May 2, 2023 | |||||
| Star Wars Jedi: Survivor | |
April 28, 2023 | Fayaine (t|c|a) Shadowstealer7 (t|c|a) |
||||
| Dead Island 2 | |
April 28, 2023 | |||||
| Minecraft Legends | |
April 18, 2023 | |||||
| Road 96: Mile 0 | |
April 4, 2023 | |||||
| Resident Evil 4 (2023) | |
March 24, 2023 | Fayaine (t|c|a) | ||||
| Atelier Ryza 3: Alchemist of the End & the Secret Key | |
March 24, 2023 | Fayaine (t|c|a) | ||||
| Have a Nice Death | |
March 22, 2023 | MasterBlaster (t|c|a) | ||||
| WWE 2K23 | |
March 17, 2023 | Jigen123 (t|c|a) | ||||
| The Legend of Heroes: Trails to Azure | |
March 14, 2023 | MasterBlaster (t|c|a) | ||||
| Fatal Frame: Mask of the Lunar Eclipse | |
March 9, 2023 | Fayaine (t|c|a) Expack3 (t|c|a) |
||||
| Wo Long: Fallen Dynasty | |
March 3, 2023 | Fayaine (t|c|a) | ||||
| The Last of Us Part I | |
March 3, 2023 | Fayaine (t|c|a) mrtnptrs (t|c|a) |
||||
| Darkest Dungeon II | |
February 28, 2023 | Placeholder date for February 2023. Release from early access. | ||||
| Octopath Traveler II | |
February 24, 2023 | Fayaine (t|c|a) | ||||
| Kerbal Space Program 2 | |
February 24, 2023 | Release to early access. | ||||
| Sons of the Forest | |
February 23, 2023 | |||||
| Company of Heroes 3 | |
February 23, 2023 | mrtnptrs (t|c|a) | ||||
| Blood Bowl 3 | |
February 23, 2023 | |||||
| Digimon World: Next Order | |
February 22, 2023 | Jigen123 (t|c|a) MasterBlaster (t|c|a) |
||||
| Like a Dragon: Ishin! | |
February 21, 2023 | Fayaine (t|c|a) | ||||
| Atomic Heart | |
February 21, 2023 | Expack3 (t|c|a) mrtnptrs (t|c|a) |
||||
| Wild Hearts | |
February 17, 2023 | Fayaine (t|c|a) | ||||
| The Settlers: New Allies | |
February 17, 2023 | Expack3 (t|c|a) | ||||
| Returnal | |
February 15, 2023 | Fayaine (t|c|a) mrtnptrs (t|c|a) |
||||
| Wanted: Dead | |
February 14, 2023 | Fayaine (t|c|a) | ||||
| Hogwarts Legacy | |
February 10, 2023 | Shadowstealer7 (t|c|a) | ||||
| SpellForce: Conquest of Eo | |
February 2, 2023 | |||||
| Deliver Us Mars | |
February 2, 2023 | SojerManLan (t|c|a) | Requested January 27, 2023. | |||
| SpongeBob SquarePants: The Cosmic Shake | |
January 31, 2023 | MasterBlaster (t|c|a) | MasterBlaster (t|c|a) | Requested January 18, 2023. Received January 27, 2023. | ||
| Dead Space (2023) | |
January 27, 2023 | Fayaine (t|c|a) mrtnptrs (t|c|a) |
Requested January 18, 2023. | |||
| Hi-Fi RUSH | |
January 25, 2023 | Somewhatviable (t|c|a) | Somewhatviable (t|c|a) | Assigned January 27, 2023. | ||
| Forspoken | |
January 24, 2023 | Fayaine (t|c|a) | January 25, 2023 | Fayaine (t|c|a) | Requested January 18, 2023. Received January 24, 2023. | |
| Persona 3 Portable | |
January 19, 2023 | Jigen123 (t|c|a) | January 20, 2023 | Jigen123 (t|c|a) | Requested January 14, 2023. Assigned January 20, 2023. | |
| One Piece Odyssey | |
January 13, 2023 | Fayaine (t|c|a) | January 14, 2023 | Fayaine (t|c|a) | Requested January 6, 2023. Received and assigned January 11, 2023. |
2022
- See the the 2022 subpage.
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 first part and second part legacy subpages.