User:Teltura/Text - Revision history

Teltura at 16:57, 9 November 2021

2021-11-09T16:57:41Z

← Older revision		Revision as of 16:57, 9 November 2021
Line 11:		Line 11:
	\|fields=		\|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('<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

Teltura at 16:54, 9 November 2021

2021-11-09T16:54:01Z

← Older revision		Revision as of 16:54, 9 November 2021
Line 14:		Line 14:
	,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('<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.Culture		,CONCAT('[[Image:Culture_', C.Culture, '.svg\|x20px\|text-bottom\|link=', C.Culture, '_Culture]][[', C.Culture, '_Culture\|', C.Culture, ']]')=Culture

	,C.CardType		,C.CardType
Line 23:		Line 23:
	\|limit=400		\|limit=400
	\|format=dynamic table		\|format=dynamic table
	~~\|hidden fields=Subset~~
	\|named args= yes		\|named args= yes
	\|default=		\|default=
	\|delimiter=		\|delimiter=
	}}		}}

Teltura: Teltura moved page Data:Teltura/Text to User:Teltura/Text without leaving a redirect

2021-10-15T23:52:12Z

Teltura moved page Data:Teltura/Text to User:Teltura/Text without leaving a redirect

← Older revision	Revision as of 23:52, 15 October 2021
(No difference)

Teltura: Created page with "NOTOC {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

2021-10-15T23:51:28Z

Created page with "__NOTOC__ {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

New page

__NOTOC__
{{NavBar|Fellowship of the Ring Index| [[Main Page]]|[[Promotional Index]]|[[Mines of Moria Index]]}}
{{SetTabs}}

Here you will find every card in the [[Fellowship of the Ring]] set. Please see that page for additional information.

= Standard Cards =

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

,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.Culture

,C.CardType

,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
|where= C.SetNum = 1
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|format=dynamic table
|hidden fields=Subset
|named args= yes
|default=
|delimiter=
}}

User:Teltura/Text - Revision history

Teltura at 16:57, 9 November 2021

Teltura at 16:54, 9 November 2021

Teltura: Teltura moved page Data:Teltura/Text to User:Teltura/Text without leaving a redirect

Teltura: Created page with "__NOTOC__ {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

Teltura: Created page with "NOTOC {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."