User:Phallen Cassidy/Test - Revision history

Phallen Cassidy at 03:05, 26 October 2022

2022-10-26T03:05:28Z

← Older revision		Revision as of 03:05, 26 October 2022
Line 217:		Line 217:
	<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
	</div>		</div>
	~~</div>~~

	~~<div class="flex">~~
	<div class="sidebar flex" style="max-width:250px">		<div class="sidebar flex" style="max-width:250px">
	<div class="title">Collection Info</div>		<div class="title">Collection Info</div>

Phallen Cassidy at 03:04, 26 October 2022

2022-10-26T03:04:28Z

← Older revision		Revision as of 03:04, 26 October 2022
Line 217:		Line 217:
	<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}		<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field\|usesKeyword\|input type=tokens\|default=\|size=40\|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise\|existing values only\|placeholder=Select 1 or more}}}
	</div>		</div>
			</div>

			<div class="flex">
	<div class="sidebar flex" style="max-width:250px">		<div class="sidebar flex" style="max-width:250px">
	<div class="title">Collection Info</div>		<div class="title">Collection Info</div>

Phallen Cassidy: proposed search overhaul

2022-10-26T02:37:10Z

proposed search overhaul

Show changes

Phallen Cassidy at 13:15, 22 October 2022

2022-10-22T13:15:47Z

Show changes

Phallen Cassidy: Phallen Cassidy moved page User:Phallen Cassidy/Move Limit to User:Phallen Cassidy/Test: Maybe if I name it better I won't forget about it

2022-10-22T04:25:07Z

Phallen Cassidy moved page User:Phallen Cassidy/Move Limit to User:Phallen Cassidy/Test: Maybe if I name it better I won't forget about it

← Older revision	Revision as of 04:25, 22 October 2022
(No difference)

Phallen Cassidy: Replaced content with "{{subst:PersonaTable|Aragorn}}"

2021-12-28T02:39:14Z

Replaced content with "{{subst:PersonaTable|Aragorn}}"

@@ Line 9: / Line 9: @@
 AND 'Aragorn' = C.Title
 |order by={{StandardSort}}
 }}

Phallen Cassidy at 21:49, 26 December 2021

2021-12-26T21:49:49Z

← Older revision		Revision as of 21:49, 26 December 2021
Line 1:		Line 1:
	~~===Cards That Add to the Move Limit===~~		{{#cargo_query:tables=Cards=C,CardReleases=CR
	{{#cargo_query:
	tables=Cards=C, CardReleases=CR
	\|join on=C.ID = CR.ID		\|join on=C.ID = CR.ID
	\|fields=		\|fields=CR.ID=CardID
	~~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~~		,CR.CollInfo
	~~,C.Side~~		,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
	~~,C.Culture~~		,CR.PortraitFilename
	~~,C.CardType~~		,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageName
	~~,CR.GameText~~		\|where= CR.Title IS NOT NULL
	\|where~~=C.ID LIKE 'LOTR-EN%'~~		AND 'Aragorn' = C.Title
	~~AND C.ID~~ = CR.ID		\|order by={{StandardSort}}
	~~AND {{FilterReprints}}~~
	AND ~~CR.GameText LIKE~~ '~~%move limit%~~'
	~~AND (CR~~.~~GameText LIKE '%limit +%'~~
	~~OR CR.GameText LIKE '%is +%'~~
	~~OR CR.GameText LIKE '%turn +%')~~
	\|order by= {{StandardSort}}
	}}		}}

Teltura at 22:13, 2 November 2021

2021-11-02T22:13:25Z

← Older revision		Revision as of 22:13, 2 November 2021
Line 11:		Line 11:
	\|where=C.ID LIKE 'LOTR-EN%'		\|where=C.ID LIKE 'LOTR-EN%'
	AND C.ID = CR.ID		AND C.ID = CR.ID
			AND {{FilterReprints}}
	AND CR.GameText LIKE '%move limit%'		AND CR.GameText LIKE '%move limit%'
	AND (CR.GameText LIKE '%limit +%'		AND (CR.GameText LIKE '%limit +%'
	OR CR.GameText LIKE '%is +%'		OR CR.GameText LIKE '%is +%'
	OR CR.GameText LIKE '%turn +%')		OR CR.GameText LIKE '%turn +%')
	\|order by=~~C.Side, C.Culture, CONVERT(C.SetNum, int)~~		\|order by= {{StandardSort}}
	}}		}}

Phallen Cassidy: Created page with "===Cards That Add to the Move Limit=== {{#cargo_query: tables=Cards=C, CardReleases=CR |join on=C.ID = CR.ID |fields= CONCAT('', REPLACE(REPLACE(C._pa..."

2021-11-02T20:42:25Z

Created page with "===Cards That Add to the Move Limit=== {{#cargo_query: tables=Cards=C, CardReleases=CR |join on=C.ID = CR.ID |fields= CONCAT('', REPLACE(REPLACE(C._pa..."

New page

===Cards That Add to the Move Limit===
{{#cargo_query:
tables=Cards=C, CardReleases=CR
|join on=C.ID = CR.ID
|fields=
CONCAT('[[', 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), ')]][[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]')=CardName
,C.Side
,C.Culture
,C.CardType
,CR.GameText
|where=C.ID LIKE 'LOTR-EN%'
AND C.ID = CR.ID
AND CR.GameText LIKE '%move limit%'
AND (CR.GameText LIKE '%limit +%'
OR CR.GameText LIKE '%is +%'
OR CR.GameText LIKE '%turn +%')
|order by=C.Side, C.Culture, CONVERT(C.SetNum, int)
}}