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

Difference between revisions of "PCGamingWiki:GOG.com Enhancement Project"

From PCGamingWiki, the wiki about fixing PC games
(Added current time magic word to projectbox)
(22 intermediate revisions by 10 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.
* For games using [[DOSBox]], include the GOG.com DOSBox Configurator screenshot: [[:File:GOG.com DOSBox Configurator v2.png|GOG.com DOSBox Configurator v2.png]].{{note|note=A list of games on GOG that use DOSBox is [https://www.gog.com/forum/general/list_of_gog_games_using_dosbox/page1 on the GOG.com forums].|name="DOSBox"}}
 
  
 
'''Discussion'''
 
'''Discussion'''
Line 13: Line 12:
 
'''Other information'''
 
'''Other information'''
 
* [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 in 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 in the [[PCGamingWiki talk:GOG.com Enhancement Project|Discussion page]].
 +
* [[PCGamingWiki:GOG.com Enhancement Project/account|Track completion]] of the games on the shared GOG.com press account.
  
 
'''Main contact'''
 
'''Main contact'''
 
* [[User:Andytizer|Andytizer]]
 
* [[User:Andytizer|Andytizer]]
 +
 +
 +
<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|{{#ask: [[Category:Games]] [[Available from::GOG.com]] |format=count }}}}<!--
+
{{#vardefine:total|{{#cargo_query:tables=Infobox_game|fields=TRIM(COUNT(*))|where=Infobox_game.GOGcom_ID HOLDS LIKE '%'|no html|format=text}}}}<!--
-->{{#vardefine:stubs|{{#ask: [[Category:Games]] [[Category:Stubs]] [[Available from::GOG.com]] |format=count }}}}<!--
+
-->{{#vardefine:stubs|{{#cargo_query:tables=Infobox_game,Tags|join on=Infobox_game._pageName=Tags._pageName|fields=TRIM(COUNT(*))|where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Stub='true'|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 43: Line 46:
 
{{ii}} '''Stubs:''' {{#var:stubs}}
 
{{ii}} '''Stubs:''' {{#var:stubs}}
  
{{#ask: [[Category:Games]] [[Category:Stubs]] [[Available from::GOG.com]]
+
{{#cargo_query:
|?Part of series=Series
+
tables=Infobox_game,Availability,Tags
|?Developed by
+
|join on=Infobox_game._pageName=Availability._pageName,Infobox_game._pageName=Tags._pageName
|?Published by
+
|where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='true'
|?Release date|+limit=1
+
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on
|?Available on
+
|format=template
|format=table
+
|named args=yes
|limit=10
+
|limit=10
|template=Feature/row
+
|intro={{Game list/intro}}
|introtemplate=Feature/intro
+
|template=Game list/row
|outrotemplate=Feature/outro
+
|outro=</table></div>
|sep=,&ensp;
 
|mainlabel=Game
 
 
}}
 
}}
  
 
===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}}
  
{{#ask: [[Category:Games]] [[Available from::GOG.com]] [[Article state is stub::false]]
+
{{#cargo_query:
|?Part of series=Series
+
tables=Infobox_game,Availability,Tags
|?Developed by
+
|join on=Infobox_game._pageName=Availability._pageName,Infobox_game._pageName=Tags._pageName
|?Published by
+
|where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='false'
|?Release date|+limit=1
+
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on
|?Available on
+
|format=template
|format=table
+
|named args=yes
|limit=10
+
|limit=10
|template=Feature/row
+
|intro={{Game list/intro}}
|introtemplate=Feature/intro
+
|template=Game list/row
|outrotemplate=Feature/outro
+
|outro=</table></div>
|sep=,&ensp;
 
|mainlabel=Game
 
 
}}
 
}}
  
 
==Games removed from sale==
 
==Games removed from sale==
 
{{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, [http://www.gogwiki.com/wiki/List_of_games_removed_from_GOG see the GOG.com Community Wiki's article dedicated to the topic] (read-only).
+
{{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).
  
# [[Achtung Panzer: Kharkov 1943]]
+
{{#cargo_query:
# <s>[[Arma 2]]</s> - part of "Arma 2: Combined Operations"
+
tables=Infobox_game,Availability,Tags
# [[Arma 2|Arma 2: Operation Arrowhead]] - part of "Arma 2: Combined Operations"
+
|join on=Infobox_game._pageName=Availability._pageName,Infobox_game._pageName=Tags._pageName
# <s>[[Arma: Cold War Assault]]</s>
+
|where=Availability.Available_from_historically HOLDS LIKE 'GOG.com' AND Availability.Available_from HOLDS NOT LIKE 'GOG.com' AND Infobox_game.Released HOLDS LIKE '%'
# <s>[[Arma: Armed Assault]]</s>
+
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on
# <s>[[Armello]]</s> - sold as "Armello DRM-Free Edition"
+
|format=template
# [[Ashes of the Singularity]]
+
|named args=yes
# <s>[[The Ballads of Reemus: When the Bed Bites]]</s>
+
|limit=10
# <s>[[Balls of Steel]]</s>
+
|intro={{Game list/intro}}
# <s>[[Back to the Future: The Game]]</s>
+
|template=Game list/row
# [[Batman: The Enemy Within - The Telltale Series]]
+
|outro=</table></div>
# <s>[[Batman: The Telltale Series]]</s>
+
}}
# [[Blade of Darkness]]
 
# [[Caribbean!]]
 
# [[Chantelise - A Tale of Two Sisters]]
 
# [[Chessmaster 9000]]
 
# [[The Chronicles of Riddick: Assault on Dark Athena]]
 
# [[Chronology]]
 
# [[Colin McRae Rally 2005]]
 
# <s>[[Cryostasis]]</s>
 
# [[Dark Matter]]
 
# <s>[[Darksiders]]</s>
 
# [[Darksiders II]]
 
# [[Death Gate]]
 
# [[Devil's Dare]]
 
# <s>[[Divinity: Original Sin]]</s>
 
# <s>[[Duke Nukem]]</s> - part of "Duke Nukem 1+2"
 
# <s>[[Duke Nukem 2]]</s> - part of "Duke Nukem 1+2"
 
# <s>[[Duke Nukem 3D|Duke Nukem 3D - Atomic Edition]]</s>
 
# <s>[[Duke Nukem: Manhattan Project]]</s>
 
# <s>[[Dyad]]</s>
 
# [[Earthlock: Festival of Magic]]
 
# [[Everything]]
 
# [[F/A-18E Super Hornet]]
 
# [[Fez]]
 
# [[FRACT OSC]]
 
# [[Game of Thrones: A Telltale Games Series]]
 
# [[Gray Matter]]
 
# [[Gremlins, Inc.]]
 
# [[Gremlins vs Automatons]] - part of "Gremlins, Inc."
 
# [[Guilty Gear Isuka]]
 
# [[Guilty Gear X2 Reload]]
 
# [[Human: Fall Flat]]
 
# [[Hector: Badge of Carnage]]
 
# [[The Long Dark]]
 
# [[Lula: The Sexy Empire]]
 
# <s>[[Mutant Mudds]]</s>
 
# [[Marvel's Guardians of the Galaxy: The Telltale Series]]
 
# [[Minecraft: Story Mode - A Telltale Games Series]]
 
# [[Minecraft: Story Mode - Season Two]]
 
# [[Necropolis: A Diabolical Dungeon Delve]]
 
# <s>[[ObsCure]]</s>
 
# <s>[[Original War]]</s>
 
# [[Perception]]<ref>[https://www.gog.com/news/release_perception GOG Perception release]</ref>
 
# [[Puzzle Agent]]
 
# [[Puzzle Agent 2]]
 
# [[Pony Island]]
 
# <s>[[Race Driver: Grid]]</s>
 
# <s>[[realMyst]]</s><ref>https://www.gog.com/forum/general/real_myst_is_leaving_gogcom_on_the_18th_70_off_discount_now_active/page1</ref>
 
# <s>[[Recettear: An Item Shop's Tale]]</s>
 
# [[Republic: The Revolution]]
 
# [[Republique Remastered]]
 
# [[Reservoir Dogs: Bloody Days]]
 
# [[Re-Volt]]
 
# <s>[[Sam & Max: Beyond Time and Space]]</s>
 
# <s>[[Sam & Max: Save the World]]</s>
 
# <s>[[Sam & Max: The Devil's Playhouse]]</s>
 
# [[Schein]]
 
# [[Scratches Director's Cut]]
 
# [[Second Sight]]
 
# [[Simon the Sorcerer 4: Chaos Happens]]
 
# [[Slender: The Arrival]]
 
# [[Softporn Adventure]] - no longer part of "Leisure Suit Larry" bundle<ref>{{Refurl|url=https://www.gog.com/forum/leisure_suit_larry_series/softporn_adventure/post8|title=GOG.com Community -
 
Leisure Suit Larry series- Softporn Adventure|date=2019-06-02}}</ref>
 
# [[Sokobond]]
 
# [[Sorcerer King]]
 
# [[Space Rangers]]
 
# [[Space Rangers 2: Dominators]]
 
# [[Startup Company]]
 
# [[Strong Bad's Cool Game for Attractive People]]
 
# [[Superfrog]]
 
# <s>[[Superfrog HD]]</s>
 
# [[Tales from the Borderlands]]
 
# <s>[[Tales of Monkey Island]]</s>
 
# [[TOCA Race Driver 3]]
 
# [[TrickStyle]]
 
# [[UFO: Afterlight]]
 
# [[Wallace and Gromit's Grand Adventures]]
 
# <s>[[The Walking Dead: Season One]]</s>
 
# <s>[[The Walking Dead: Season Two]]</s>
 
# <s>[[The Walking Dead: Michonne]]</s>
 
# [[The Walking Dead: A New Frontier]]
 
# [[The Walking Dead: The Final Season]]
 
# <s>[[The Wolf Among Us]]</s>
 
# [[Wargame: European Escalation]]
 
# <s>[[Warsow]]</s>
 
# <s>[[Windforge]]</s>
 
# [[Wolcen: Lords of Mayhem]]
 
# <s>[[XIII]]</s>
 
  
 
[[Category:Projects]]
 
[[Category:Projects]]

Revision as of 16:15, 24 March 2022

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

  • Request access to our shared GOG.com press account on the Forums.
  • Alternatively, discuss the project on the Talk page.

Other information

Main contact


This page was last refreshed on 06:04 March 29, 2024. Purge the page to refresh it.



GOG.com Enhancement Project
ProjectForumTalk

<span class="meter" style="width: Expression error: Unexpected < operator.%;">

Completed Expression error: Unexpected < operator. of
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._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__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,TRIM(COUNT(*)) FROM `cargo__Infobox_game` WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__GOGcom_ID` WHERE `_value`LIKE '%') ORDER BY `cargo__Infobox_game`.`_pageID`,TRIM(COUNT(*)) LIMIT 100

games
Expression error: Unexpected < operator.%


Auto-populated list

An archived version of the old list can be found here.

Total number of games:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._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__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,TRIM(COUNT(*)) FROM `cargo__Infobox_game` WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__GOGcom_ID` WHERE `_value`LIKE '%') ORDER BY `cargo__Infobox_game`.`_pageID`,TRIM(COUNT(*)) LIMIT 100

Stubs

Stubs:
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Tags._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__Tags`.`_pageID` AS `cargo_backlink_page_id_Tags`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,TRIM(COUNT(*)) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__GOGcom_ID` WHERE `_value`LIKE '%') AND `cargo__Tags`.`Stub`='true' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`,TRIM(COUNT(*)) LIMIT 100


More...

Completed

Completion state can be tracked over on this page. Use this page for games on the shared GOG.com press account.
Completed: Expression error: Unexpected < operator.


More...

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).


More...


References