Difference between revisions of "PCGamingWiki:Assignments/Table"

Revision as of 20:15, 19 January 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 }}

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.

Game	Release Date	Applied	Notes
Riders Republic	December 31, 2021		Placeholder date for "later this year".
Evil Dead: The Game	December 31, 2021		Placeholder date for 2021. Review code requested December 11, 2020 (Sandbox Strategies).
NieR Replicant	April 23, 2021	Fayaine (t\|c\|a)
Outriders	April 1, 2021
Prince of Persia: The Sands of Time Remake	March 18, 2021
Stronghold: Warlords	March 9, 2021		Review code requested January 10 (Evolve).
Persona 5 Strikers	February 23, 2021	Shadowstealer7 (t\|c\|a) Fayaine (t\|c\|a)
Rogue Heroes: Ruins of Tasos	February 23, 2021
Lust from Beyond	February 11, 2021
Little Nightmares II	February 10, 2021
Becastled	February 8, 2021		Release to early access.
Aircraft Carrier Survival	February 5, 2021
Nioh 2: The Complete Edition	February 5, 2021	Shadowstealer7 (t\|c\|a)
Werewolf: The Apocalypse - Earthblood	February 4, 2021
Valheim	February 2, 2021		Release to early access.
The Medium	January 28, 2021
Yakuza 3 Remastered	January 28, 2021	Fayaine (t\|c\|a)
Yakuza 4 Remastered	January 28, 2021	Fayaine (t\|c\|a)
Yakuza 5 Remastered	January 28, 2021	Fayaine (t\|c\|a)
Atelier Ryza 2: Lost Legends & the Secret Fairy	January 26, 2021
Cyber Shadow	January 26, 2021
Redout: Space Assault	January 22, 2021
Dyson Sphere Program	January 21, 2021		Release to early access.
Skul: The Hero Slayer	January 21, 2021		Release from early access.
Hitman 3	January 20, 2021
Everspace 2	January 18, 2021		Release to early access. GOG.com Enhancement Project.
Scott Pilgrim vs. The World: The Game - Complete Edition	January 14, 2021	MasterBlaster (t\|c\|a)	Review code requested January 6 (Ubisoft), received January 12.

2020

See the 2020 subpage.

2019

See the 2019 subpage.

Legacy

See the Legacy subpage.

@@ Line 52: / Line 52: @@
 {{Assignment/row| Riders Republic | unknown | unknown | December 31, 2021 | | | | Placeholder date for "later this year". }}
 {{Assignment/row| Evil Dead: The Game | unknown | unknown | December 31, 2021 | | | | Placeholder date for 2021. Review code requested December 11, 2020 (Sandbox Strategies). }}
-{{Assignment/row| NieR Replicant | unknown | Steam | April 23, 2021 | | | | }}
+{{Assignment/row| NieR Replicant | unknown | Steam | April 23, 2021 | Fayaine | | | }}
 {{Assignment/row| Outriders | unknown | unknown | April 1, 2021 | | | | }}
 {{Assignment/row| Prince of Persia: The Sands of Time Remake | unknown | unknown | March 18, 2021 | | | | }}
 {{Assignment/row| Stronghold: Warlords | unknown | Steam | March 9, 2021 | | | | Review code requested January 10 (Evolve). }}
-{{Assignment/row| Persona 5 Strikers | unknown | Steam | February 23, 2021 | | | | }}
+{{Assignment/row| Persona 5 Strikers | unknown | Steam | February 23, 2021 | Shadowstealer7, Fayaine | | | }}
 {{Assignment/row| Rogue Heroes: Ruins of Tasos | unknown | Steam | February 23, 2021 | | | | }}
 {{Assignment/row| Lust from Beyond | unknown | Steam | February 11, 2021 | | | | }}
@@ Line 62: / Line 62: @@
 {{Assignment/row| Becastled | unknown | unknown | February 8, 2021 | | | | Release to early access. }}
 {{Assignment/row| Aircraft Carrier Survival | unknown | Steam | February 5, 2021 | | | | }}
-{{Assignment/row| Nioh 2: The Complete Edition | unknown | Steam | February 5, 2021 | | | | }}
+{{Assignment/row| Nioh 2: The Complete Edition | unknown | Steam | February 5, 2021 | Shadowstealer7 | | | }}
 {{Assignment/row| Werewolf: The Apocalypse - Earthblood | unknown | Epic Games Store | February 4, 2021 | | | | }}
 {{Assignment/row| Valheim | unknown | Steam | February 2, 2021 | | | | Release to early access. }}
 {{Assignment/row| The Medium | unknown | unknown | January 28, 2021 | | | | }}
-{{Assignment/row| Yakuza 3 Remastered | unknown | unknown | January 28, 2021 | | | | }}
+{{Assignment/row| Yakuza 3 Remastered | unknown | unknown | January 28, 2021 | Fayaine | | | }}
-{{Assignment/row| Yakuza 4 Remastered | unknown | unknown | January 28, 2021 | | | | }}
+{{Assignment/row| Yakuza 4 Remastered | unknown | unknown | January 28, 2021 | Fayaine | | | }}
-{{Assignment/row| Yakuza 5 Remastered | unknown | unknown | January 28, 2021 | | | | }}
+{{Assignment/row| Yakuza 5 Remastered | unknown | unknown | January 28, 2021 | Fayaine | | | }}
 {{Assignment/row| Atelier Ryza 2: Lost Legends & the Secret Fairy | unknown | Steam | January 26, 2021 | | | | }}
 {{Assignment/row| Cyber Shadow | unknown | unknown | January 26, 2021 | | | | }}