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


Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

PCGamingWiki:GOG.com Enhancement Project

From PCGamingWiki, the wiki about fixing PC games
Revision as of 07:58, 20 October 2021 by Garrett (talk | contribs) (→‎Games removed from sale: migrated manual list to Cargo query)

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 April 25, 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