Difference between revisions of "User:Aemony/Sandbox"
m (d) |
m (added columns) |
||
(149 intermediate revisions by 2 users 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''' | ||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game | ||
+ | |where=Infobox_game._pageName="Make It Rain: The Love of Money" | ||
+ | |fields=_pageName,Developers,Publishers,Engines,Released, | ||
+ | |format=table | ||
+ | |default= | ||
+ | }} | ||
− | {{ | + | <!-- |
− | {{ | + | API.Windows_ARM_app='true' |
+ | Infobox_game._pageName="NieR: Automata" | ||
+ | Infobox_game._pageName="Make It Rain: The Love of Money" | ||
+ | Infobox_game._pageName="9 Clues: The Secret of Serpent Creek" | ||
+ | --> | ||
+ | |||
+ | '''Broken backend data:''' (nothing beyond infobox game seems to be populated) | ||
+ | {{#cargo_query: | ||
+ | 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 | ||
+ | |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,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 | ||
+ | }} | ||
+ | |||
+ | |||
+ | '''Proper backend data:''' | ||
+ | {{#cargo_query: | ||
+ | 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 | ||
+ | |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,Infobox_game.Released_Windows,API.Windows_ARM_app,L10n.Language,Cloud.Steam=Cloud.Steam,Availability.Available_from | ||
+ | |format=table | ||
+ | }} | ||
+ | |||
+ | |||
+ | |||
+ | ------ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <!-- | ||
+ | |||
+ | |||
+ | |||
+ | '''Basic example -- does not work with multiple defined dates: ''' | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game | ||
+ | |fields=Infobox_game._pageName,Infobox_game.Released_Windows=DateUnformatted,DATE_FORMAT(Infobox_game.Released_Windows,"%M %e, %Y")=DateFormatted | ||
+ | |limit=20 | ||
+ | }} | ||
+ | |||
+ | --- | ||
+ | |||
+ | '''NumOfRows: '''{{#cargo_query: | ||
+ | tables=Infobox_game,Infobox_game__Released | ||
+ | |join on=Infobox_game._ID=Infobox_game__Released._rowID | ||
+ | |fields=COUNT(Infobox_game__Released._value) | ||
+ | |where=Infobox_game._pageName="Half-Life" | ||
+ | }} | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game,Infobox_game__Released | ||
+ | |join on=Infobox_game._ID=Infobox_game__Released._rowID | ||
+ | |fields=Infobox_game._pageName,DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")=DateFormatted | ||
+ | |where=Infobox_game._pageName="Half-Life" | ||
+ | }} | ||
+ | |||
+ | '''Delimited: '''{{#cargo_query: | ||
+ | tables=Infobox_game,Infobox_game__Released | ||
+ | |join on=Infobox_game._ID=Infobox_game__Released._rowID | ||
+ | |fields=DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y") | ||
+ | |where=Infobox_game._pageName="Half-Life" | ||
+ | |format=list | ||
+ | |delimiter= and | ||
+ | }} | ||
+ | |||
+ | --- | ||
+ | |||
+ | '''Full: ''' | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game | ||
+ | |fields=Infobox_game._pageName,Infobox_game.Released,Infobox_game.Released__full,CONCAT(Infobox_game.Released__full)=CONCAT__full,SUBSTRING(CONCAT(Infobox_game.Released__full),0,10)=SUBSTRING | ||
+ | |where=Infobox_game._pageName="Doom (1993)" | ||
+ | }} | ||
+ | |||
+ | --- | ||
+ | |||
+ | '''Group By: ''' | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game,Infobox_game__Released | ||
+ | |join on=Infobox_game._ID=Infobox_game__Released._rowID | ||
+ | |fields=Infobox_game._pageName,DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")=DateFormatted | ||
+ | |where=Infobox_game._pageName="Half-Life" | ||
+ | |group by=Infobox_game._pageName,Infobox_game__Released._value | ||
+ | }} | ||
+ | |||
+ | '''Delimited: '''{{#cargo_query: | ||
+ | tables=Infobox_game,Infobox_game__Released | ||
+ | |join on=Infobox_game._ID=Infobox_game__Released._rowID | ||
+ | |fields=DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y") | ||
+ | |where=Infobox_game._pageName="Half-Life" | ||
+ | |group by=Infobox_game._pageName,Infobox_game__Released._value | ||
+ | |format=list | ||
+ | |delimiter= and | ||
+ | }} | ||
+ | |||
+ | --- | ||
+ | |||
+ | '''Duplicate data in table ? Returns 2 rows -- should only be 1 !''' | ||
+ | |||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game | ||
+ | |fields=Infobox_game._pageName,Infobox_game.Released=DateUnformatted,DATE_FORMAT(Infobox_game.Released__full,"%M %e, %Y")=DateFormatted,COUNT(*)=NumOfRows | ||
+ | |where=Infobox_game._pageName="Quake" | ||
+ | }} | ||
− | + | --> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
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 |