Difference between revisions of "User:Aemony/Sandbox"
m (test #3) |
m (added columns) |
||
(11 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 27: | 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) |
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 | Arabic | 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 | Czech | 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 |
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 |