Difference between revisions of "CargoTest"

From Rigged Wiki
Jump to navigation Jump to search
Line 1: Line 1:
This is to figure out how the cargo extension works
This is to figure out how the cargo extension works
 
<table class='wikitable sortable'>
<tr><th>Date</th><th>Opponent</th><th>Tournament</th><th>Score</th><th>Goals</th></tr>
{{#cargo_query:
{{#cargo_query:
tables=CupMatches
tables=CupMatches
|fields=_pageName=Tournament,Home,HomeG=Home Goals,CONCAT(HomeS,'-',AwayS) = Score,AwayG=Away Goals,Away=Away
|fields=_pageName,MatchTime,'mu'=Team,Home,Away,HomeS,AwayS,HomeG,AwayG
|format=dynamic table
|where=_pageName LIKE '201% 4Chan%Cup%' AND (home = 'mu' OR away = 'mu')
|where=_pageName = '2018 4chan Spring Babby Cup Group D'
|order by=MatchTime
|order by=_PAGEID ASC
|limit=1000
}}
|format=template
<table>
|template=MatchHistory
{{#cargo_compound_query:
tables=CupMatches;fields=_pageName=Tournament,MatchTime,Away,HomeS, AwayS, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000
|tables=CupMatches;fields=_pageName=Tournament,MatchTime,Home,AwayS,HomeS, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000
|format=template|template=MatchHistory
}}
}}
</table>
</table>

Revision as of 03:44, 23 May 2018

This is to figure out how the cargo extension works

{{#cargo_query: tables=CupMatches |fields=_pageName,MatchTime,'mu'=Team,Home,Away,HomeS,AwayS,HomeG,AwayG |where=_pageName LIKE '201% 4Chan%Cup%' AND (home = 'mu' OR away = 'mu') |order by=MatchTime |limit=1000 |format=template |template=MatchHistory }}

DateOpponentTournamentScoreGoals
Retrieved from "https://implyingrigged.info/w/index.php?title=CargoTest&oldid=110736"