Difference between revisions of "PCGamingWiki:Assignments/Table"
Tag: Undo |
(Simple change to force cargo to relink) |
||
Line 4: | Line 4: | ||
* Popular games (anticipated to have 100+ concurrent players). | * Popular games (anticipated to have 100+ concurrent players). | ||
* Important or critically acclaimed games. | * Important or critically acclaimed games. | ||
+ | |||
==Data source== | ==Data source== |
Revision as of 03:31, 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:
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:
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.
2020
Game | Release Date | Applied | Completion Date | Assigned | Notes | ||
---|---|---|---|---|---|---|---|
The Settlers (2020) | December 31, 2020 | Expack3 (t|c|a) | Date is most likely a temporary placeholder.[1] | ||||
Last Oasis | March 31, 2020 | Review code requested September 27, 2019 (Donkey Crew). Placeholder date for Q1 of 2020. | |||||
Doom Eternal | March 20, 2020 | Unavailable (t|c|a) |