Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Difference between revisions of "PCGamingWiki:Assignments/Table"

From PCGamingWiki, the wiki about fixing PC games
(Simple change to force cargo to relink)
(Undo revision 899995 by Rose (talk))
Tag: Undo
Line 63: Line 63:
 
{{Assignment/row| Blacksad: Under the Skin | unknown | unknown | November 5, 2019 | | | | Review code requested October 25, 2019 (Microids). }}
 
{{Assignment/row| Blacksad: Under the Skin | unknown | unknown | November 5, 2019 | | | | Review code requested October 25, 2019 (Microids). }}
 
{{Assignment/row| Red Dead Redemption 2 | unknown | unknown | November 5, 2019 | Rose, Unavailable, BesuBaru | | | Review code requested October 11, 2019 (Rockstar Games). }}
 
{{Assignment/row| Red Dead Redemption 2 | unknown | unknown | November 5, 2019 | Rose, Unavailable, BesuBaru | | | Review code requested October 11, 2019 (Rockstar Games). }}
 +
{{Assignment/row| Test game | unknown | unknown | November 5, 2019 |  | | |  }}
 
{{Assignment/row| Song of Horror | available | Steam | October 31, 2019 | | | | Review code received October 18, 2019 (Renaissance), embargo until October 29. }}
 
{{Assignment/row| Song of Horror | available | Steam | October 31, 2019 | | | | Review code received October 18, 2019 (Renaissance), embargo until October 29. }}
 
{{Assignment/row| Afterparty | unknown | Epic Games Store | October 29, 2019 | | | | Review code requested October 19, 2019 (Night School Studio). }}
 
{{Assignment/row| Afterparty | unknown | Epic Games Store | October 29, 2019 | | | | Review code requested October 19, 2019 (Night School Studio). }}

Revision as of 04:23, 26 October 2019

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.

2019

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

Template:Assignment/table

2020

Game Release Date Applied Completion Date Assigned Notes
The Settlers (2020)
Icon overlay.png
December 31, 2020 Expack3 (t|c|a) Date is most likely a temporary placeholder.[1]
Last Oasis
Icon overlay.png
March 31, 2020 Review code requested September 27, 2019 (Donkey Crew). Placeholder date for Q1 of 2020.
Doom Eternal
DRM details are not known
March 20, 2020 Unavailable (t|c|a)

Legacy

Template:Assignment/table

Template:References