Difference between revisions of "PCGamingWiki:Assignments/Table"

Revision as of 14:34, 13 May 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	Completion Date	Assigned	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).
Deathloop	September 14, 2021	Shadowstealer7 (t\|c\|a)
Life Is Strange: True Colors	September 10, 2021
Tales of Arise	September 10, 2021
Humankind	August 17, 2021
The Great Ace Attorney Chronicles	July 27, 2021
Scarlet Nexus	June 25, 2021
Guilty Gear Strive	June 11, 2021
Sniper: Ghost Warrior Contracts 2	June 4, 2021
Necromunda: Hired Gun	June 1, 2021
Warhammer Age of Sigmar: Storm Ground	May 27, 2021
Biomutant	May 25, 2021
Shin Megami Tensei III Nocturne HD Remaster	May 25, 2021	MasterBlaster (t\|c\|a)
Knockout City	May 21, 2021
Just Die Already	May 20, 2021
Mind Scanners	May 20, 2021				Review code received May 12, 2021 (Brave At Night).
Days Gone	May 18, 2021	KingKrouch (t\|c\|a)
Siege Survival: Gloria Victis	May 18, 2021
Mass Effect Legendary Edition	May 14, 2021	Shadowstealer7 (t\|c\|a)		Shadowstealer7 (t\|c\|a)	Review code requested May 7, 2021 (fortyseven), received and assigned May 13.
Subnautica: Below Zero	May 14, 2021				Release from early access.
Hundred Days - Winemaking Simulator	May 13, 2021
The Hand of Merlin	May 11, 2021				Release to early access.
Hood: Outlaws & Legends	May 10, 2021
Resident Evil Village	May 7, 2021	Fayaine (t\|c\|a)		Fayaine (t\|c\|a)	Review code requested May 1, 2021, declined (Capcom, Lick PR). Purchased with Gamesplanet funds and assigned on May 7.
Distant Kingdoms	May 5, 2021				Release to early access.
Scavengers	May 1, 2021				Free-to-play release to early access.
CryoFall	April 29, 2021				Release from early access.
Total War: Rome Remastered	April 29, 2021
NieR Replicant	April 23, 2021	Fayaine (t\|c\|a)	April 28, 2021	Fayaine (t\|c\|a)	Code requested April 21, 2021 (GMG), received and allocated April 23.
Voxel Tycoon	April 15, 2021				Release to early access.
Knight Squad 2	April 14, 2021				Review code received April 9, 2021 (IndieBoost).
TaleSpire	April 14, 2021				Release to early access.
The Legend of Heroes: Trails of Cold Steel IV	April 9, 2021	MasterBlaster (t\|c\|a)	April 24, 2021	MasterBlaster (t\|c\|a)	Review code requested April 5, 2021 (NIS America), received April 9 and assigned April 14. First covered by Fayaine at own initiative, expanded and verified by MasterBlaster.
Lost Words: Beyond the Page	April 6, 2021				Review code received April 9, 2021 (IndieBoost).
Oddworld: Soulstorm	April 6, 2021	MasterBlaster (t\|c\|a)	April 6, 2021	MasterBlaster (t\|c\|a)	Review code requested April 2, 2021 (Oddworld Inhabitants, Redner PR), received and assigned April 5.
The Slormancer	April 6, 2021				Release to early access. GOG.com Enhancement Project.
Outriders	April 1, 2021
Evil Genius 2: World Domination	March 30, 2021
Kingdom Hearts HD 1.5 + 2.5 ReMIX	March 30, 2021	Fayaine (t\|c\|a)	April 2, 2021	Fayaine (t\|c\|a)	Purchased using PCGamingWiki funds.
Kingdom Hearts HD 2.8 Final Chapter Prologue	March 30, 2021	Fayaine (t\|c\|a)
Kingdom Hearts III	March 30, 2021	Fayaine (t\|c\|a)
Kingdom Hearts Melody of Memory	March 30, 2021	Fayaine (t\|c\|a)
Narita Boy	March 30, 2021
Balan Wonderworld	March 26, 2021	Dandelion Sprout (t\|c\|a)	March 26, 2021	Dandelion Sprout (t\|c\|a)	Code requested March 24, 2021 (GMG), received March 26.
Crash Bandicoot 4: It's About Time	March 26, 2021	MasterBlaster (t\|c\|a)			Review code requested March 18, 2021 (H+K Strategies).
Genesis Noir	March 26, 2021				GOG.com Enhancement Project.
It Takes Two	March 26, 2021
Spacebase Startopia	March 26, 2021
Subverse	March 26, 2021				Release to early access.
Dorfromantik	March 25, 2021				Release to early access. GOG.com Enhancement Project.
Mech Mechanic Simulator	March 25, 2021
The Tenants	March 25, 2021				Release to early access. GOG.com Enhancement Project.
Yakuza 6: The Song of Life	March 25, 2021	Fayaine (t\|c\|a)	March 26, 2021	Fayaine (t\|c\|a)	Purchased with Gamesplanet funds on March 25, 2021.
Paradise Lost	March 24, 2021
Arkham Horror: Mother's Embrace	March 23, 2021
Cartel Tycoon	March 18, 2021
Endzone - A World Apart	March 18, 2021				Release from early access. GOG.com Enhancement Project.
Mr. Prepper	March 18, 2021
Cyanide & Happiness - Freakpocalypse	March 11, 2021
Lust from Beyond	March 11, 2021
Stronghold: Warlords	March 9, 2021				Review code requested January 10, 2021 (Evolve), received March 1.
Loop Hero	March 4, 2021				GOG.com Enhancement Project.
Rhythm Doctor	February 26, 2021				Release to early access.
Breathedge	February 25, 2021				Release from early access.
League of Maidens	February 25, 2021				Release to early access. Free to play.
Fights in Tight Spaces	February 24, 2021				Release to early access.
Curse of the Dead Gods	February 23, 2021				Release from early access.
Persona 5 Strikers	February 23, 2021	Shadowstealer7 (t\|c\|a) Fayaine (t\|c\|a)	February 22, 2021	Shadowstealer7 (t\|c\|a)	Review code requested February 10, 2021 (Sega). Deluxe Edition purchased with Gamesplanet funds for early coverage.
Rogue Heroes: Ruins of Tasos	February 23, 2021
The Shore	February 19, 2021
Rustler	February 18, 2021				Release to early access.
30XX	February 17, 2021
Nebuchadnezzar	February 17, 2021
Hellish Quart	February 16, 2021				Release to early access.
Gal*Gun Returns	February 12, 2021	KingKrouch (t\|c\|a)	February 10, 2021	KingKrouch (t\|c\|a)	Review code requested February 5, 2021 (PQube), received February 8.
Erzurum	February 10, 2021
Little Nightmares II	February 10, 2021
Becastled	February 8, 2021				Release to early access.
HuniePop 2: Double Date	February 8, 2021
Nioh 2: The Complete Edition	February 5, 2021	Shadowstealer7 (t\|c\|a)	February 5, 2021	Shadowstealer7 (t\|c\|a)	Review code requested January 19, 2021 (Renaissance), received January 29.
Werewolf: The Apocalypse - Earthblood	February 4, 2021	Rose (t\|c\|a)	February 4, 2021	Rose (t\|c\|a)	Review code requested January 31, 2021 (Dead Good Media), received February 1. Rose created FOV fix.
Valheim	February 2, 2021				Release to early access.
The Medium	January 28, 2021
Yakuza 3 Remastered	January 28, 2021	Fayaine (t\|c\|a)			Review code requested January 19, 2021 (Sega, Cosmocover, One PR, BOPE, Indigo Pearl).
Yakuza 4 Remastered	January 28, 2021	Fayaine (t\|c\|a)			Review code requested January 19, 2021 (Sega, Cosmocover, One PR, BOPE, Indigo Pearl).
Yakuza 5 Remastered	January 28, 2021	Fayaine (t\|c\|a)			Review code requested January 19, 2021 (Sega, Cosmocover, One PR, BOPE, Indigo Pearl).
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, 2021 (Ubisoft), received January 12.

2020

See the 2020 subpage.

2019

See the 2019 subpage.

Legacy

See the Legacy subpage.

@@ Line 69: / Line 69: @@
 {{Assignment/row| Days Gone | unknown | unknown | May 18, 2021 | KingKrouch | | | }}
 {{Assignment/row| Siege Survival: Gloria Victis | unknown | unknown | May 18, 2021 | | | | }}
-{{Assignment/row| Mass Effect Legendary Edition | unknown | unknown | May 14, 2021 | Shadowstealer7 | | | Review code requested May 7, 2021 (fortyseven). }}
+{{Assignment/row| Mass Effect Legendary Edition | assigned | unknown | May 14, 2021 | Shadowstealer7 | | Shadowstealer7 | Review code requested May 7, 2021 (fortyseven), received and assigned May 13. }}
 {{Assignment/row| Subnautica: Below Zero | unknown | unknown | May 14, 2021 | | | | Release from early access. }}
 {{Assignment/row| Hundred Days - Winemaking Simulator | unknown | unknown | May 13, 2021 | | | | }}