Expanded Middle-earth/Index: Difference between revisions

From LOTR-TCG Wiki
(Created page with "__NOTOC__ {{NavBar|Expanded Middle-earth/Index|Main Page|Bloodlines|The Hunters}} {{SetTabs}} {{#cargo_query:tables=Cards=C,C...")
 
No edit summary
 
Line 5: Line 5:




{{#cargo_query:tables=Cards=C,CardReleases=CR
<big>{{C|Dwarven}}</big>
|join on=C.ID = CR.ID
{{ListTable
|fields=
|filter= C.SetNum = 14 AND C.Culture = 'Dwarven'
|sort= {{StandardSort}}
|columns=1
}}


,CONCAT('<span class="tooltip">[[',  REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),  '|',  CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
----


,C.CardType
,CONCAT('[[Image:Culture_', C.Culture, '.svg|x20px|text-bottom|link=', C.Culture, '_Culture]] [[', C.Culture, '_Culture|', C.Culture, ']]')=Culture


,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
<big>{{C|Elven}}</big>
|where= C.SetNum = 14
{{ListTable
|order by={{StandardSort}}
|filter= C.SetNum = 14 AND C.Culture = 'Elven'
|limit=400
|sort= {{StandardSort}}
|format=dynamic table
|columns=1
|rows per page=400
}}
|named args= yes
 
|default=
----
|delimiter=
 
 
<big>{{C|Gandalf}}</big>
{{ListTable
|filter= C.SetNum = 14 AND C.Culture = 'Gandalf'
|sort= {{StandardSort}}
|columns=1
}}
 
 
----
 
 
<big>{{C|Gondor}}</big>
{{ListTable
|filter= C.SetNum = 14 AND C.Culture = 'Gondor'
|sort= {{StandardSort}}
|columns=1
}}
 
 
----
 
 
<big>{{C|Men}}</big>
{{ListTable
|filter= C.SetNum = 14 AND C.Culture = 'Men'
|sort= {{StandardSort}}
|columns=1
}}
 
----
 
 
<big>{{C|Orc}}</big>
{{ListTable
|filter= C.SetNum = 14 AND C.Culture = 'Orc'
|sort= {{StandardSort}}
|columns=1
}}
 
----
 
 
<big>{{C|Uruk-hai}}</big>
{{ListTable
|filter= C.SetNum = 14 AND C.Culture = 'Uruk-hai'
|sort= {{StandardSort}}
|columns=1
}}
}}

Latest revision as of 09:30, 12 February 2022