Difference between revisions of "PCGamingWiki:GOG.com Enhancement Project/account"
From PCGamingWiki, the wiki about fixing PC games
(migrated queries to Cargo (still storing some Semantic MediaWiki data for now)) |
(migrated progress bar to Cargo, fixed table queries) |
||
Line 1: | Line 1: | ||
<!--- STATUS BAR ---> | <!--- STATUS BAR ---> | ||
<onlyinclude> | <onlyinclude> | ||
− | {{#vardefine:total|{{# | + | {{#vardefine:total|{{#cargo_query:tables=GOGcom_Enhancement_Project|fields=TRIM(COUNT(*))|where=Press_account='true'|no html|format=text}}}}<!-- |
− | -->{{#vardefine:incomplete|{{# | + | -->{{#vardefine:incomplete|{{#cargo_query:tables=GOGcom_Enhancement_Project,Tags|join on=GOGcom_Enhancement_Project._pageName=Tags._pageName|fields=TRIM(COUNT(*))|where=GOGcom_Enhancement_Project.Press_account='true' AND Tags.Stub='true' OR GOGcom_Enhancement_Project.Press_account='true' AND Tags.Cleanup='true'|no html|format=text}}}}<!-- |
-->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:incomplete}})}}}}<!-- | -->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:incomplete}})}}}}<!-- | ||
-->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | -->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | ||
Line 28: | Line 28: | ||
tables=Infobox_game,Tags,GOGcom_Enhancement_Project | tables=Infobox_game,Tags,GOGcom_Enhancement_Project | ||
|join on=Infobox_game._pageName=Tags._pageName,Tags._pageName=GOGcom_Enhancement_Project._pageName | |join on=Infobox_game._pageName=Tags._pageName,Tags._pageName=GOGcom_Enhancement_Project._pageName | ||
− | |where=Tags.Stub | + | |where=GOGcom_Enhancement_Project.Press_account='true' AND Tags.Stub='true' OR GOGcom_Enhancement_Project.Press_account='true' AND Tags.Cleanup='true' |
− | |fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots | + | |fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots,Tags.Cleanup |
|format=template | |format=template | ||
|intro={{Completion/intro}} | |intro={{Completion/intro}} | ||
Line 41: | Line 41: | ||
tables=Infobox_game,Tags,GOGcom_Enhancement_Project | tables=Infobox_game,Tags,GOGcom_Enhancement_Project | ||
|join on=Infobox_game._pageName=Tags._pageName,Tags._pageName=GOGcom_Enhancement_Project._pageName | |join on=Infobox_game._pageName=Tags._pageName,Tags._pageName=GOGcom_Enhancement_Project._pageName | ||
− | |where=GOGcom_Enhancement_Project.Press_account | + | |where=GOGcom_Enhancement_Project.Press_account='true' |
− | |fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots | + | |fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots,Tags.Cleanup |
|format=template | |format=template | ||
|intro={{Completion/intro}} | |intro={{Completion/intro}} |
Revision as of 09:21, 16 October 2021
Project • Forum • Talk
Information
- Add {{GOG.com Enhancement Project}} to the very bottom (usually below the {{References}} call) of pages that is available on the shared GOG press account.
Incomplete pages
All pages
- The following are all pages in Category:GOG.com Enhancement Project.