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.

Difference between revisions of "User:Garrett/Sandbox3"

From PCGamingWiki, the wiki about fixing PC games
(→‎Cargo: GOG only)
(Cargo? Cargo!)
Line 26: Line 26:
  
 
==Cargo==
 
==Cargo==
 +
{{Completion/intro}}
 
  {{#cargo_query:
 
  {{#cargo_query:
 
tables=Infobox_game,Tags
 
tables=Infobox_game,Tags
Line 31: Line 32:
 
|where=Infobox_game.GOGcom_page HOLDS LIKE '%'
 
|where=Infobox_game.GOGcom_page HOLDS LIKE '%'
 
|fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub=Incomplete,Tags.Tickcross_unknown="unknown",Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots=Screenshots,Tags.Video_screenshots=Video screens,Tags.Input_screenshots=Input screens,Tags.Audio_screenshots=Audio screens,Tags.Network_screenshots=Network screens,Tags.VR_screenshots=VR screens
 
|fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub=Incomplete,Tags.Tickcross_unknown="unknown",Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots=Screenshots,Tags.Video_screenshots=Video screens,Tags.Input_screenshots=Input screens,Tags.Audio_screenshots=Audio screens,Tags.Network_screenshots=Network screens,Tags.VR_screenshots=VR screens
 +
|format=template
 +
|template=Completion/row
 
|limit=5}}
 
|limit=5}}
 +
|}

Revision as of 10:20, 2 September 2021


SMW

Total number of games: {{#ask: GOGcom page::+ Tickcross unknown::≥0 | format=count}} {{#ask: GOGcom page::+ Tickcross unknown::≥0 | ?Cover filename | ?Article state is stub | ?Tickcross unknown | ?Config data | ?Save data | ?Settings screenshots | ?Video screenshots | ?Input screenshots | ?Audio screenshots | ?Network screenshots | ?VR screenshots | format=template | introtemplate=Completion/intro | template=Completion/row | offset=0 | limit=5 | sort=Tickcross unknown,Article state is stub | order=desc,desc }} |}

Cargo

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS LIKE '%' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`' at line 1 (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`,`cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Cover` AS `Cover`,`cargo__Tags`.`Stub` AS `Incomplete`,`cargo__Tags`.`Tickcross_unknown` AS `"unknown"`,`cargo__Tags`.`Config_data` AS `Config data`,`cargo__Tags`.`Save_data` AS `Save data`,`cargo__Tags`.`Settings_screenshots` AS `Screenshots`,`cargo__Tags`.`Video_screenshots` AS `Video screens`,`cargo__Tags`.`Input_screenshots` AS `Input screens`,`cargo__Tags`.`Audio_screenshots` AS `Audio screens`,`cargo__Tags`.`Network_screenshots` AS `Network screens`,`cargo__Tags`.`VR_screenshots` AS `VR screens` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Infobox_game`.`GOGcom_page` HOLDS LIKE '%' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`,`cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Cover`,`cargo__Tags`.`Stub` LIMIT 100

|}

Game Cover Incomplete "unknown" Config data Save data Screenshots Video screens Input screens Audio screens Network screens VR screens