User:Coffeesaga/Sandbox/Flavor text: Difference between revisions

From Archon Arcana - The KeyForge Wiki
no edit summary
No edit summary
No edit summary
 
Line 2: Line 2:
__TOC__
__TOC__
<templatestyles src="Template:Flavor_Text/styles.css" />
<templatestyles src="Template:Flavor_Text/styles.css" />
==Call of the Archons==
{{#cargo_query:
tables=CardData, SetData
|fields=CardData.Name, CardData.FlavorText
|join on=SetData._pageTitle=CardData.Name
|where=((CardData.FlavorText is not null) AND (SetData.SetName LIKE 'Call of the Archons')) AND (SetData.Meta LIKE 'Debut')
|group by=CardData.FlavorText, CardData.Name
|order by=CardData.Name ASC
|format=template
|template=Flavor_Text
|named args=yes
|default=
|intro=<div class="flavor-text">
|outro=</div>
|limit=500
|more results text=}}
==Age of Ascension==
{{#cargo_query:
tables=CardData, SetData
|fields=CardData.Name, CardData.FlavorText
|join on=SetData._pageTitle=CardData.Name
|where=((CardData.FlavorText is not null) AND (SetData.SetName LIKE 'Age of Ascension')) AND (SetData.Meta LIKE 'Debut')
|group by=CardData.FlavorText, CardData.Name
|order by=CardData.Name ASC
|format=template
|template=Flavor_Text
|named args=yes
|default=
|intro=<div class="flavor-text">
|outro=</div>
|limit=500
|more results text=}}
==Worlds Collide==
{{#cargo_query:
tables=CardData, SetData
|fields=CardData.Name, CardData.FlavorText
|join on=SetData._pageTitle=CardData.Name
|where=((CardData.FlavorText is not null) AND (SetData.SetName LIKE 'Worlds Collide')) AND (SetData.Meta LIKE 'Debut')
|group by=CardData.FlavorText, CardData.Name
|order by=CardData.Name ASC
|format=template
|template=Flavor_Text
|named args=yes
|default=
|intro=<div class="flavor-text">
|outro=</div>
|limit=500
|more results text=}}


==Mass Mutation==
{{#loop: varname
| 0
| 10
| <nowiki />
{{#cargo_query:
{{#cargo_query:
tables=CardData, SetData
tables=SetData,SetInfo
|fields=CardData.Name, CardData.FlavorText
|fields=SetData.SetName
|join on=SetData._pageTitle=CardData.Name
|join on=SetData.SetName=SetInfo.SetName
|where=((CardData.FlavorText is not null) AND (SetData.SetName LIKE 'Mass Mutation')) AND (SetData.Meta LIKE 'Debut')
|group by=SetData.SetName,SetInfo.ReleaseYear, SetInfo.ReleaseMonth
|group by=CardData.FlavorText, CardData.Name
|where=SetData.SetName is not null
|order by=CardData.Name ASC
|format=template
|format=template
|template=Flavor_Text
|template=Flavor_Text_List
|named args=yes
|named args=yes
|limit=1
|offset={{#var: varname}}
|no html
|more results text=
|default=
|default=
|intro=<div class="flavor-text">
|order by=SetInfo.ReleaseYear, SetInfo.ReleaseMonth
|outro=</div>
}}
|limit=500
}}
|more results text=}}