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 23:02, 3 January 2023 by Aemony (talk | contribs) (shared acc is currently limited to PCGW staff members, so changed things around in the projectbox)

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

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


This page was last refreshed on 08:32 April 28, 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__Availability._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__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,TRIM(COUNT(*)) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'GOG.com') ORDER BY `cargo__Availability`.`_pageID`,TRIM(COUNT(*)) LIMIT 100

games
Expression error: Unexpected < operator.%


Games

Total number of games:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._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__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,TRIM(COUNT(*)) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'GOG.com') ORDER BY `cargo__Availability`.`_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`,TRIM(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`,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).
Removed:
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._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__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,TRIM(COUNT(*)) FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Availability` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Availability`.`_pageName`)) WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from_historically` WHERE `_value`LIKE 'GOG.com') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'GOG.com') AND `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__Released` WHERE `_value`LIKE '%') ORDER BY `cargo__Availability`.`_pageID`,`cargo__Infobox_game`.`_pageID`,TRIM(COUNT(*)) LIMIT 100

More...


References