Difference between revisions of "PCGamingWiki:GOG.com Enhancement Project"
From PCGamingWiki, the wiki about fixing PC games
m (→Games removed from sale: restored archived link) |
m (hopefully fixed stupid cargo query) |
||
| (24 intermediate revisions by 11 users not shown) | |||
| Line 5: | Line 5: | ||
'''Instructions''' | '''Instructions''' | ||
* Refer to the [[PCGamingWiki:Editing_guide|Editing guide]] (along with the [[PCGamingWiki:Sample_article|Sample article]]) and fill in all issues and fixes, test windowed/borderless fullscreen modes, controllers, etc. | * Refer to the [[PCGamingWiki:Editing_guide|Editing guide]] (along with the [[PCGamingWiki:Sample_article|Sample article]]) and fill in all issues and fixes, test windowed/borderless fullscreen modes, controllers, etc. | ||
| − | |||
'''Discussion''' | '''Discussion''' | ||
| − | * | + | * Discuss the project on [[PCGamingWiki:Discord|Discord]] or the [[PCGamingWiki talk:GOG.com Enhancement Project|Discussion page]]. |
| − | + | * [https://www.gog.com/catalogue GOG.com catalogue] - if you find a game on GOG.com that isn't listed on this project page, please notify us on the [[PCGamingWiki talk:GOG.com Enhancement Project|Discussion page]]. | |
'''Other information''' | '''Other information''' | ||
| − | * [ | + | * [[PCGamingWiki:Staff|Staff members]] have access to a shared GOG.com press account with a library of games. |
| + | * [[PCGamingWiki:GOG.com Enhancement Project/account|Track completion]] of the games on the shared GOG.com press account. | ||
| + | * ''An archived version of the old list can be found [[PCGamingWiki:GOG.com Enhancement Project/legacy|here]]. | ||
'''Main contact''' | '''Main contact''' | ||
| Line 18: | Line 19: | ||
| − | <center>This page was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it.</center> | + | <center>This page was last refreshed on '''{{CURRENTTIME}} {{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it.</center> |
}} | }} | ||
<!--- STATUS BAR ---> | <!--- STATUS BAR ---> | ||
<onlyinclude> | <onlyinclude> | ||
| − | {{#vardefine:total|{{# | + | {{#vardefine:total|{{#cargo_query:tables=Availability|fields=TRIM(COUNT(*))|where=Availability.Available_from HOLDS LIKE 'GOG.com'|group by=Availability._pageNamespace|no html|format=text}}}}<!-- |
| − | -->{{#vardefine:stubs|{{# | + | -->{{#vardefine:stubs|{{#cargo_query:tables=Availability,Tags|join on=Availability._pageName=Tags._pageName|fields=TRIM(COUNT(*))|where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='true'|group by=Availability._pageNamespace|no html|format=text}}}}<!-- |
-->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:stubs}})}}}}<!-- | -->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:stubs}})}}}}<!-- | ||
-->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | -->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | ||
| Line 39: | Line 40: | ||
</onlyinclude> | </onlyinclude> | ||
| − | == | + | ==Games== |
| − | |||
'''Total number of games: '''{{#var:total}} | '''Total number of games: '''{{#var:total}} | ||
===Stubs=== | ===Stubs=== | ||
{{ii}} '''Stubs:''' {{#var:stubs}} | {{ii}} '''Stubs:''' {{#var:stubs}} | ||
| − | + | {{#cargo_query: | |
| − | {{# | + | tables=Infobox_game,Availability,Tags |
| − | + | |join on=Infobox_game._pageName=Availability._pageName,Infobox_game._pageName=Tags._pageName | |
| − | + | |where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='true' | |
| − | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |
| − | + | |format=template | |
| − | + | |named args=yes | |
| − | + | |limit=10 | |
| − | + | |intro={{Game list/intro}} | |
| − | + | |template=Game list/row | |
| − | + | |outro=</table></div> | |
| − | |||
| − | |||
| − | |||
}} | }} | ||
===Completed=== | ===Completed=== | ||
| − | {{ii}} Completion state can be tracked over on [[PCGamingWiki:GOG.com Enhancement Project/Completion|this page]]. | + | {{ii}} Completion state can be tracked over on [[PCGamingWiki:GOG.com Enhancement Project/Completion|this page]]. Use [[PCGamingWiki:GOG.com Enhancement Project/account|this page]] for games on the shared GOG.com press account. |
{{ii}} '''Completed:''' {{#var:completed}} | {{ii}} '''Completed:''' {{#var:completed}} | ||
| − | + | {{#cargo_query: | |
| − | {{# | + | tables=Infobox_game,Availability,Tags |
| − | + | |join on=Infobox_game._pageName=Availability._pageName,Infobox_game._pageName=Tags._pageName | |
| − | + | |where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='false' | |
| − | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |
| − | + | |format=template | |
| − | + | |named args=yes | |
| − | + | |limit=10 | |
| − | + | |intro={{Game list/intro}} | |
| − | + | |template=Game list/row | |
| − | + | |outro=</table></div> | |
| − | |||
| − | |||
| − | |||
}} | }} | ||
| Line 83: | Line 77: | ||
{{ii}} These are games which have been removed for sale from GOG.com and remain for the sake of completeness. Users who purchased them previously are able to download and play these games as usual. These do not need to be completed for the project. | {{ii}} These are games which have been removed for sale from GOG.com and remain for the sake of completeness. Users who purchased them previously are able to download and play these games as usual. These do not need to be completed for the project. | ||
{{ii}} For more information on games that have been removed from sale, [https://web.archive.org/web/20190321090105/http://www.gogwiki.com/wiki/List_of_games_removed_from_GOG see the GOG.com Community Wiki's article dedicated to the topic] (archived). | {{ii}} For more information on games that have been removed from sale, [https://web.archive.org/web/20190321090105/http://www.gogwiki.com/wiki/List_of_games_removed_from_GOG see the GOG.com Community Wiki's article dedicated to the topic] (archived). | ||
| − | + | {{ii}} '''Removed:''' {{#cargo_query:tables=Infobox_game,Availability|join on=Infobox_game._pageName=Availability._pageName|fields=TRIM(COUNT(*))|where=Availability.Available_from_historically HOLDS LIKE 'GOG.com' AND Availability.Available_from HOLDS NOT LIKE 'GOG.com' AND Infobox_game.Released HOLDS LIKE '%'|group by=Availability._pageNamespace|no html|format=text}} | |
| − | + | {{#cargo_query: | |
| − | # | + | tables=Infobox_game,Availability |
| − | + | |join on=Infobox_game._pageName=Availability._pageName | |
| − | + | |where=Availability.Available_from_historically HOLDS LIKE 'GOG.com' AND Availability.Available_from HOLDS NOT LIKE 'GOG.com' AND Infobox_game.Released HOLDS LIKE '%' | |
| − | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |
| − | + | |format=template | |
| − | + | |named args=yes | |
| − | + | |limit=10 | |
| − | + | |intro={{Game list/intro}} | |
| − | + | |template=Game list/row | |
| − | + | |outro=</table></div> | |
| − | + | }} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | # | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category:Projects]] | [[Category:Projects]] | ||
Latest revision as of 18:54, 15 June 2023
Project aim
- Update and complete articles for every single GOG.com game to the highest standard.
Instructions
- Refer to the Editing guide (along with the Sample article) and fill in all issues and fixes, test windowed/borderless fullscreen modes, controllers, etc.
Discussion
- Discuss the project on Discord or the Discussion page.
- GOG.com catalogue - if you find a game on GOG.com that isn't listed on this project page, please notify us on the Discussion page.
Other information
- Staff members have access to a shared GOG.com press account with a library of games.
- Track completion of the games on the shared GOG.com press account.
- An archived version of the old list can be found here.
Main contact
Project • Forum • Talk
Games
Total number of games: 4447
Stubs
- Stubs: 1716
| Game | Series | Developer | Publisher | First release | Available on |
|---|---|---|---|---|---|
| 1942: The Pacific Air War | Air War | MPS Labs | MicroProse, Night Dive Studios, Retroism | January 1, 1994 |  |
| 1971 Project Helios | RecoTechnology | June 9, 2020 | |
||
| 4th & Inches | Accolade | Accolade, Ziggurat Interactive | October 1, 1988 | |
|
| 7.62 Hard Life | Brigade E5 | HLA team | 1C Company, 1C Entertainment, Fulqrum Publishing | October 1, 2015 | |
| 7.62 High Calibre | Brigade E5 | Apeiron | 1C Company, 1C Entertainment, Fulqrum Publishing | August 24, 2007 | |
| 8 Eyes | Thinking Rabbit | Piko Interactive | August 14, 2019 | |
|
| 8-Bit Adventures 2 | 8-Bit Adventures | Critical Games | January 31, 2023 | |
|
| 8-Bit Adventures: The Forgotten Journey Remastered Edition | 8-Bit Adventures | Critical Games | March 31, 2015 | |
|
| 88 Heroes | Bitmap Bureau | Rising Star Games | March 24, 2017 | |
|
| 9 Years of Shadows | Halberd Studios | Freedom Games | March 27, 2023 | |
Completed
- Completion state can be tracked over on this page. Use this page for games on the shared GOG.com press account.
- Completed: 2731
Games removed from sale
- These are games which have been removed for sale from GOG.com and remain for the sake of completeness. Users who purchased them previously are able to download and play these games as usual. These do not need to be completed for the project.
- For more information on games that have been removed from sale, see the GOG.com Community Wiki's article dedicated to the topic (archived).
- Removed: 174
| Game | Series | Developer | Publisher | First release | Available on |
|---|---|---|---|---|---|
| 60 Parsecs! | 60 | Robot Gentleman | September 18, 2018 | |
|
| 60 Seconds! | 60 | Robot Gentleman | May 25, 2015 | |
|
| A Vampyre Story | Autumn Moon, Jordan Freeman Group | Focus Home Interactive, Crimson Cow, Strategy First, Autumn Moon, Jordan Freeman Group | December 2, 2008 | |
|
| Achtung Panzer: Kharkov 1943 | Graviteam | 1C Company, United Independent Entertainment, Paradox Interactive | September 11, 2009 | |
|
| Adeptus Titanicus: Dominus | Warhammer 40,000 | Membraine Studios | March 26, 2021 | |
|
| Alchemist Adventure | Bad Minions | Super.com | June 10, 2021 | |
|
| Arma 2 | Arma | Bohemia Interactive | 505 Games, Got Game Entertainment, Akella | June 17, 2009 | |
| Armello | League of Geeks | September 1, 2015 | |
||
| Ashes of the Singularity | Ashes of the Singularity | Oxide Games, Stardock | Stardock | March 31, 2016 | |
| Back to the Future: The Game | Telltale Games | December 22, 2010 | |