Promotional Index - Revision history

Teltura: Redirected page to Promotional/Index

2021-11-12T05:59:49Z

← Older revision		Revision as of 05:59, 12 November 2021
Line 1:		Line 1:
	~~__NOTOC__~~		#REDIRECT [[Promotional/Index]]
	~~{{NavBar\|Promotional Index\|[[Main_Page]]\| \|[[Fellowship of the Ring Index]]}}~~
	~~{{SetTabs}}~~

	~~Here you will find every (known) card in the~~ [[Promotional~~]] set. Please see that page for additional information.~~


	~~{{#cargo_query:tables=Cards=C,CardReleases=CR~~
	~~\|join on=C.ID = CR.ID~~
	~~\|fields=~~

	~~CONCAT('[[File:', IFNULL(CR.PortraitFilename,'Portrait_Not_Found.jpg'), '\|center\|link=', REPLACE(REPLACE(C._pageName, '~~/~~Data', ''), 'Data:', ''), ']]')=Portrait~~

	,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

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

	~~,C.CardType~~

	~~,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText~~
	~~\|where= C.SetNum = 0~~
	~~\|order by={{StandardSort}}~~
	~~\|limit=400~~
	~~\|format=dynamic table~~
	~~\|hidden fields=Subset~~
	~~\|named args= yes~~
	~~\|default=~~
	~~\|delimiter=~~
	}}

Teltura at 19:53, 9 November 2021

2021-11-09T19:53:47Z

← Older revision		Revision as of 19:53, 9 November 2021
Line 9:		Line 9:
	\|join on=C.ID = CR.ID		\|join on=C.ID = CR.ID
	\|fields=		\|fields=

	CONCAT('[[File:', IFNULL(CR.PortraitFilename,'Portrait_Not_Found.jpg'), '\|center\|link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ']]')=Portrait		CONCAT('[[File:', IFNULL(CR.PortraitFilename,'Portrait_Not_Found.jpg'), '\|center\|link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ']]')=Portrait

Teltura: Created page with "NOTOC {{NavBar|Promotional Index|Main_Page| |Fellowship of the Ring Index}} {{SetTabs}} Here you will find every (known) card in the Promotional set. Please..."

2021-11-09T19:00:02Z

Created page with "__NOTOC__ {{NavBar|Promotional Index|Main_Page| |Fellowship of the Ring Index}} {{SetTabs}} Here you will find every (known) card in the Promotional set. Please..."

New page

__NOTOC__
{{NavBar|Promotional Index|[[Main_Page]]| |[[Fellowship of the Ring Index]]}}
{{SetTabs}}

Here you will find every (known) card in the [[Promotional]] set. Please see that page for additional information.

{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=
CONCAT('[[File:', IFNULL(CR.PortraitFilename,'Portrait_Not_Found.jpg'), '|center|link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ']]')=Portrait

,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

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

,C.CardType

,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|where= C.SetNum = 0
|order by={{StandardSort}}
|limit=400
|format=dynamic table
|hidden fields=Subset
|named args= yes
|default=
|delimiter=
}}

Promotional Index - Revision history

Teltura: Redirected page to Promotional/Index

Teltura at 19:53, 9 November 2021

Teltura: Created page with "__NOTOC__ {{NavBar|Promotional Index|Main_Page| |Fellowship of the Ring Index}} {{SetTabs}} Here you will find every (known) card in the Promotional set. Please..."

Teltura: Created page with "NOTOC {{NavBar|Promotional Index|Main_Page| |Fellowship of the Ring Index}} {{SetTabs}} Here you will find every (known) card in the Promotional set. Please..."