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

Revision as of 10:36, 19 November 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

GOG.com catalogue - if you find a game on GOG.com that isn't listed on this project page, please notify us in the Discussion page.
Track completion of the games on the shared GOG.com press account.

Main contact

Andytizer

This page was last refreshed on 10:50 April 28, 2024. Purge the page to refresh it.

GOG.com Enhancement Project
Project • Forum • Talk

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__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Availability`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'GOG.com') AND `cargo__Tags`.`Stub`='true' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100

Game	Series	Developer	Publisher	First release
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

More...

Completed

Completion state can be tracked over on this page. Use this page for games on the shared GOG.com press account.

Completed:

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__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Availability`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'GOG.com') AND `cargo__Tags`.`Stub`='false' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100

Game	Series	Developer	Publisher	First release
140		Carlsen Games		October 16, 2013
15 Days		House of Tales	DTP Entertainment, THQ Nordic	June 25, 2010
18 Wheels of Steel: Across America	18 Wheels of Steel	SCS Software	ValuSoft, Retroism, TopWare Poland	September 23, 2003
18 Wheels of Steel: American Long Haul	18 Wheels of Steel	SCS Software	ValuSoft, Noviy Disk, Retroism, CD Projekt	December 3, 2007
18 Wheels of Steel: Convoy	18 Wheels of Steel	SCS Software	ValuSoft, Retroism, TopWare Poland	September 1, 2005
18 Wheels of Steel: Extreme Trucker	18 Wheels of Steel	SCS Software	ValuSoft, Retroism, City Interactive	September 23, 2009
18 Wheels of Steel: Extreme Trucker 2	18 Wheels of Steel	SCS Software	ValuSoft, Retroism, City Interactive	January 6, 2011
18 Wheels of Steel: Haulin'	18 Wheels of Steel	SCS Software	ValuSoft, Retroism, TopWare Poland	December 8, 2006
18 Wheels of Steel: Pedal to the Metal	18 Wheels of Steel	SCS Software	ValuSoft, City Interactive	August 30, 2004
1849		Somasim		May 8, 2014

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

Game	Series	Developer	Publisher	First release
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

More...

References

@@ Line 44: / Line 44: @@
 ===Stubs===
-{{ii}} '''Stubs:''' {{#var:stubs}}
+{{ii}} '''Stubs:''' {{#cargo_query:
+tables=Availability,Tags
+|join on=Availability._pageName=Tags._pageName
+|fields=COUNT(*)
+|where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='true'
+|format=text
+}}
 {{#cargo_query:
 tables=Infobox_game,Availability,Tags
@@ Line 61: / Line 66: @@
 ===Completed===
 {{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:''' {{#cargo_query:
+tables=Availability,Tags
+|join on=Availability._pageName=Tags._pageName
+|fields=COUNT(*)
+|where=Availability.Available_from HOLDS LIKE 'GOG.com' AND Tags.Stub='false'
+|format=text
+}}
 {{#cargo_query:
 tables=Infobox_game,Availability,Tags
@@ Line 79: / Line 89: @@
 {{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).
 {{#cargo_query:
 tables=Infobox_game,Availability,Tags