Difference between revisions of "User:Aemony/Sandbox"
From PCGamingWiki, the wiki about fixing PC games
m (updated proper) |
m (added columns) |
||
| (29 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | '''Cargo data with some reference inserted?''' | ||
| + | |||
| + | {{#cargo_query: | ||
| + | tables=Middleware | ||
| + | |where= | ||
| + | Physics HOLDS LIKE '%UNIQ%' OR | ||
| + | Audio HOLDS LIKE '%UNIQ%' OR | ||
| + | Interface HOLDS LIKE '%UNIQ%' OR | ||
| + | Input HOLDS LIKE '%UNIQ%' OR | ||
| + | Cutscenes HOLDS LIKE '%UNIQ%' OR | ||
| + | Multiplayer HOLDS LIKE '%UNIQ%' OR | ||
| + | Anticheat HOLDS LIKE '%UNIQ%' | ||
| + | |fields=_pageName,Physics,Audio,Interface,Input,Cutscenes,Multiplayer,Anticheat | ||
| + | |format=table | ||
| + | |default= | ||
| + | }} | ||
| + | |||
| + | '''Cargo data with some newlines inserted?''' | ||
| + | |||
| + | {{#cargo_query: | ||
| + | tables=Middleware | ||
| + | |where= | ||
| + | Physics HOLDS LIKE '%<br%' OR | ||
| + | Audio HOLDS LIKE '%<br%' OR | ||
| + | Interface HOLDS LIKE '%<br%' OR | ||
| + | Input HOLDS LIKE '%<br%' OR | ||
| + | Cutscenes HOLDS LIKE '%<br%' OR | ||
| + | Multiplayer HOLDS LIKE '%<br%' OR | ||
| + | Anticheat HOLDS LIKE '%<br%' | ||
| + | |fields=_pageName,Physics,Audio,Interface,Input,Cutscenes,Multiplayer,Anticheat | ||
| + | |format=table | ||
| + | |default= | ||
| + | }} | ||
| + | |||
| + | |||
| + | |||
'''Example query''' | '''Example query''' | ||
| Line 8: | Line 44: | ||
|default= | |default= | ||
}} | }} | ||
| − | |||
<!-- | <!-- | ||
| Line 16: | Line 51: | ||
Infobox_game._pageName="9 Clues: The Secret of Serpent Creek" | Infobox_game._pageName="9 Clues: The Secret of Serpent Creek" | ||
--> | --> | ||
| − | |||
'''Broken backend data:''' (nothing beyond infobox game seems to be populated) | '''Broken backend data:''' (nothing beyond infobox game seems to be populated) | ||
| Line 22: | Line 56: | ||
tables=Infobox_game,API,L10n,Cloud,Availability | tables=Infobox_game,API,L10n,Cloud,Availability | ||
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName | ||
| − | |where=Infobox_game._pageName="Make It Rain: The Love of Money" | + | |where=Infobox_game._pageName="Make It Rain: The Love of Money" OR Infobox_game._pageName="NieR: Automata" OR Infobox_game._pageName="User:Aemony/Sandbox/Bot2" OR Cloud._pageName="NieR: Automata2" OR Infobox_game._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld" |
| − | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released_Windows | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released,Infobox_game.Released_Windows,API.Windows_ARM_app,L10n.Language,Cloud.Steam=Cloud.Steam,Availability.Available_from |
| + | |format=table | ||
| + | }} | ||
| + | |||
| + | '''Test using <code>User:Aemony/Sandbox/Bot2</code> and {{T|Save game cloud syncing}}:''' | ||
| + | {{#cargo_query: | ||
| + | tables=Infobox_game | ||
| + | |where=Infobox_game._pageName="User:Aemony/Sandbox/Bot2" OR Infobox_game._pageName="NieR: Automata" OR Infobox_game._pageName="NieR: Automata2" OR Infobox_game._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld" | ||
| + | |fields=Infobox_game._pageName,Infobox_game.Released,Infobox_game.Released_Windows,Infobox_game.Series | ||
| + | |format=table | ||
| + | }} | ||
| + | |||
| + | {{#cargo_query: | ||
| + | tables=Cloud | ||
| + | |where=Cloud._pageName="User:Aemony/Sandbox/Bot2" OR Cloud._pageName="NieR: Automata" OR Cloud._pageName="NieR: Automata2" OR Cloud._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld" | ||
| + | |fields=Cloud._pageName,Cloud.Steam=Cloud.Steam | ||
|format=table | |format=table | ||
}} | }} | ||
| Line 30: | Line 79: | ||
'''Proper backend data:''' | '''Proper backend data:''' | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=Infobox_game,API,L10n,Cloud | + | tables=Infobox_game,API,L10n,Cloud,Availability |
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName | ||
|where=Infobox_game._pageName="9 Clues: The Secret of Serpent Creek" | |where=Infobox_game._pageName="9 Clues: The Secret of Serpent Creek" | ||
| − | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released_Windows | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released,Infobox_game.Released_Windows,API.Windows_ARM_app,L10n.Language,Cloud.Steam=Cloud.Steam,Availability.Available_from |
|format=table | |format=table | ||
}} | }} | ||
Latest revision as of 18:56, 9 April 2024
Cargo data with some reference inserted?
Cargo data with some newlines inserted?
Example query
| _pageName | Developers | Publishers | Engines | Released |
|---|---|---|---|---|
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 |
Broken backend data: (nothing beyond infobox game seems to be populated)
| _pageName | Series | Developers | Publishers | Engines | Released | Released Windows | Windows ARM app | Language | Cloud.Steam | Available from |
|---|---|---|---|---|---|---|---|---|---|---|
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | English | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | Simplified Chinese | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | French | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | German | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | Italian | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | Japanese | true | Microsoft Store • Steam | |||
| Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 | 2015-02-19 | true | Spanish | true | Microsoft Store • Steam | |||
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | English | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Simplified Chinese | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | French | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | German | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Italian | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Japanese | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Polish | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Brazilian Portuguese | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Russian | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| NieR: Automata | NieR | Company:PlatinumGames • Company:Square Enix • Company:QLOC | Company:Square Enix | Engine:Platinum Engine | 2017-03-17 | 2017-03-17 | unknown | Spanish | true | Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | English | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Simplified Chinese | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Traditional Chinese | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | French | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | German | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Italian | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Japanese | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Polish | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Russian | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Spanish | true | Retail • Official website • Humble Store • GOG.com • Steam | |
| War for the Overworld | Company:Subterranean Games | Company:Subterranean Games • Company:Sold Out | Engine:Unity | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 | unknown | Latin American Spanish | true | Retail • Official website • Humble Store • GOG.com • Steam |
Test using User:Aemony/Sandbox/Bot2 and {{Save game cloud syncing}}:
| _pageName | Released | Released Windows | Series |
|---|---|---|---|
| NieR: Automata | 2017-03-17 | 2017-03-17 | NieR |
| War for the Overworld | 2015-04-02 • 2015-04-02 • 2015-04-02 | 2015-04-02 |
Error 1054: Unknown column 'Infobox_game._pageName' in 'where clause' (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)
Function: CargoSQLQuery::run Query: SELECT `cargo__Cloud`.`_pageID` AS `cargo_backlink_page_id_Cloud`,`cargo__Cloud`.`_pageName` AS `_pageName`,`cargo__Cloud`.`Steam` AS `Cloud.Steam` FROM `cargo__Cloud` WHERE `cargo__Cloud`.`_pageName`="User:Aemony/Sandbox/Bot2" OR `cargo__Cloud`.`_pageName`="NieR: Automata" OR `cargo__Cloud`.`_pageName`="NieR: Automata2" OR `cargo__Cloud`.`_pageName`="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld" ORDER BY `cargo__Cloud`.`_pageID`,`cargo__Cloud`.`_pageName`,`cargo__Cloud`.`Steam` LIMIT 100
Proper backend data:
| _pageName | Series | Developers | Publishers | Engines | Released | Released Windows | Windows ARM app | Language | Cloud.Steam | Available from |
|---|---|---|---|---|---|---|---|---|---|---|
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | English | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Simplified Chinese | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | French | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | German | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Japanese | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Korean | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Polish | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Brazilian Portuguese | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Russian | true | Microsoft Store • Steam |
| 9 Clues: The Secret of Serpent Creek | 9 Clues | Company:Tap It Games | Company:Artifex Mundi | Engine:Spark Casual Engine | 2013-07-18 • 2013-07-18 • 2013-07-18 | 2013-07-18 | true | Spanish | true | Microsoft Store • Steam |