Signets - Revision history

Teltura: Using standard sort

2022-02-28T17:01:47Z

Using standard sort

← Older revision		Revision as of 17:01, 28 February 2022
Line 40:		Line 40:
	\|where= C.SetNum <> 0		\|where= C.SetNum <> 0
	AND CR.GameText LIKE '%signet%'		AND CR.GameText LIKE '%signet%'
	\|order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), ~~C.SetNum, C.CardNum~~		\|order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), {{StandardSort}}
	\|limit=100		\|limit=100
	\|rows per page=26		\|rows per page=26
Line 62:		Line 62:
	AND C.CardType = 'Companion'		AND C.CardType = 'Companion'
	AND CR.Signet <> 'None'		AND CR.Signet <> 'None'
	\|order by=CR.Signet, ~~C.SetNum, C.CardNum~~		\|order by=CR.Signet, {{StandardSort}}
	\|limit=110		\|limit=110
	\|rows per page=107		\|rows per page=107

2021-11-17T03:08:36Z

Teltura moved page Signet to Signets: plural

← Older revision	Revision as of 03:08, 17 November 2021
(No difference)

2021-10-28T06:32:46Z

clarified statement

← Older revision		Revision as of 06:32, 28 October 2021
Line 23:		Line 23:
	[[File:LOTR-EN04S275.0_card.jpg\|250px\|link=lotr04275\|Forth, My Meatshields!]]		[[File:LOTR-EN04S275.0_card.jpg\|250px\|link=lotr04275\|Forth, My Meatshields!]]

	It should be noted that there is no rule stopping a character from boosting themselves with a signet-targeting ability, ~~such as if~~ {{Card\|Theoden, Lord of the Mark}} ~~were to grant~~ himself '''defender +1''' ~~using~~ {{Card\|Forth Eorlingas!}} above. ~~Indeed, most signet abilities have at least the option of boosting the~~ signet's ~~avatar~~, ~~so if one of the four~~ signet ~~characters is a major part of your deck's strategy, these abilities can be used~~ to ~~great effect~~.		It should be noted that there is no rule stopping a character from boosting themselves with a signet-targeting ability; for example, {{Card\|Theoden, Lord of the Mark}} himself could gain '''defender +1''' from {{Card\|Forth Eorlingas!}} above. Just remember that unless a card explicitly calls out a signet character by name (as seen with {{Card\|Gandalf's Wisdom}}), that character must have his own signet to do so.

	==Post-Shadows==		==Post-Shadows==

2021-10-28T04:05:00Z

← Older revision		Revision as of 04:05, 28 October 2021
Line 42:		Line 42:
	\|order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), C.SetNum, C.CardNum		\|order by=TRIM(CASE WHEN CR.GameText LIKE '%Aragorn signet%' THEN 'Aragorn' WHEN CR.GameText LIKE '%Frodo signet%' THEN 'Frodo' WHEN CR.GameText LIKE '%Gandalf signet%' THEN 'Gandalf' WHEN CR.GameText LIKE '%Theoden signet%' THEN 'Theoden' ELSE 'None' END), C.SetNum, C.CardNum
	\|limit=100		\|limit=100
	\|rows per page=~~107~~		\|rows per page=26
	\|format=dynamic table		\|format=dynamic table
	\|default=		\|default=

2021-10-28T04:03:47Z

Overhauled article to use cargo query tables

2020-09-07T09:23:26Z

Moving tables-to-fix category to Pending Cargo Tables, since the remainder are all about referencing queryable data.

← Older revision		Revision as of 09:23, 7 September 2020
Line 277:		Line 277:
	{{:card_layout_table}}		{{:card_layout_table}}

	[[Category:~~Pages With~~ Tables ~~To Fix~~]]		[[Category:Pending Cargo Tables]]

2020-09-07T09:03:27Z

← Older revision		Revision as of 09:03, 7 September 2020
Line 278:		Line 278:

	[[Category:Pages With Tables To Fix]]		[[Category:Pages With Tables To Fix]]
	~~ ~~

2020-09-07T08:51:00Z

← Older revision		Revision as of 08:51, 7 September 2020
Line 278:		Line 278:

	[[Category:Pages With Tables To Fix]]		[[Category:Pages With Tables To Fix]]

2020-09-07T07:09:36Z

mass update table references

← Older revision		Revision as of 07:09, 7 September 2020
Line 278:		Line 278:

	[[Category:Pages With Tables To Fix]]		[[Category:Pages With Tables To Fix]]
	~~ ~~

2020-08-26T09:48:04Z

← Older revision		Revision as of 09:48, 26 August 2020
Line 278:		Line 278:

	[[Category:Pages With Tables To Fix]]		[[Category:Pages With Tables To Fix]]