5e:Eldritch Knight/Spell List - Revision history

Rlyehable: /* Sortable Table */

2020-10-21T14:34:32Z

Sortable Table

← Older revision		Revision as of 07:34, 21 October 2020
Line 82:		Line 82:
	\|fields=COUNT(5e_Spell._pageName)		\|fields=COUNT(5e_Spell._pageName)
	}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).		}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).
	<div style="overflow:auto; ~~max-~~width:~~90vw~~; max-height:80vh; font-size:0.75rem;">		<div style="overflow:auto; width:100%; max-height:80vh; font-size:0.75rem;">
	{\|class="zebra small sortable"		{\|class="zebra small sortable"
	!Name		!Name
Line 97:		Line 97:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=5e_Spell.Casters HOLDS 'Eldritch Knight' AND ((Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL))
	\|fields=5e_Spell._pageName,5e_Spell.Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters,Pages_Info.Canon,Pages_Info.UA,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.User,Pages_Info.Sources		\|fields=5e_Spell._pageName,5e_Spell.Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters,Pages_Info.Canon,Pages_Info.UA,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.User,Pages_Info.Sources,Pages_Info.Deprecated
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	\|limit=1000		\|limit=1000
Line 106:		Line 106:
	}}		}}
	\|}</div>		\|}</div>

	==Sources and Notes==		==Sources and Notes==
	<references />		<references />

Rlyehable at 19:19, 19 October 2020

2020-10-19T19:19:03Z

← Older revision		Revision as of 12:19, 19 October 2020
Line 1:		Line 1:
	<noinclude>		<noinclude>
	==Eldritch Knight Spells==		==Eldritch Knight Spells==
	~~''Spells for the {{5ep\|Eldritch Knight}} subclass.''~~
	</noinclude>		</noinclude>
			''{{#cargo_query:
			tables=5e_Spell, Pages_Info
			\|join on=5e_Spell._pageName=Pages_Info._pageName
			\|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
			\|fields=COUNT(5e_Spell._pageName)
			}} spells for the {{5ep\|Eldritch Knight}} subclass.''
	{\|class="zebra small"		{\|class="zebra small"
	!Cantrip<br />0 Level		!Cantrip<br />0 Level

Rlyehable at 14:39, 18 October 2020

2020-10-18T14:39:35Z

← Older revision		Revision as of 07:39, 18 October 2020
Line 1:		Line 1:
	<noinclude>		<noinclude>
	~~''These lists exceed the text of the SRD''~~
	==Eldritch Knight Spells==		==Eldritch Knight Spells==
			''Spells for the {{5ep\|Eldritch Knight}} subclass.''
	</noinclude>		</noinclude>
	~~''Spells for the {{5ep\|Eldritch Knight}} subclass.''~~
	{\|class="zebra small"		{\|class="zebra small"
	!Cantrip<br />0 Level		!Cantrip<br />0 Level
Line 17:		Line 16:
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	~~\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )~~
	\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|format=template		\|format=template
Line 52:		Line 50:
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	~~\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )~~
	\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|format=template		\|format=template
Line 80:		Line 77:
	\|fields=COUNT(5e_Spell._pageName)		\|fields=COUNT(5e_Spell._pageName)
	}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).		}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).
	<div style="overflow:auto; width:~~95%~~; font-size:0.~~8em~~;">		<div style="overflow:auto; max-width:90vw; max-height:80vh; font-size:0.75rem;">
			{\|class="zebra small sortable"
			!Name
			!Level
			!School
			!Casting<br />Time
			!Range
			!Components
			!Casters
			!Source<br />Notes
			!Sources
			\|-
	{{#cargo_query:		{{#cargo_query:
	tables=5e_Spell, Pages_Info		tables=5e_Spell,Pages_Info
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=~~CONCAT( '[[',~~ 5e_Spell._pageName~~, '\|'~~, 5e_Spell.Spell_Name~~, ']]' )=Spell~~,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters, ~~5e_Spell~~.~~Canon_Spell=~~Canon,Pages_Info.Sources		\|fields=5e_Spell._pageName,5e_Spell.Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters,Pages_Info.Canon,Pages_Info.UA,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.User,Pages_Info.Sources
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	\|limit=~~100~~		\|limit=1000
	\|format=~~table~~		\|format=template
			\|template=5e Spell Table Row
	\|more results text=More Spells		\|more results text=More Spells
	}}</div>		}}
			\|}</div>
	==Sources and Notes==		==Sources and Notes==
	<references />		<references />

Rlyehable at 21:14, 8 October 2020

2020-10-08T21:14:11Z

← Older revision		Revision as of 14:14, 8 October 2020
Line 18:		Line 18:
	\|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )		\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )
	\|format=~~list~~		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|~~delimiter~~=~~<br />~~		\|format=template
			\|template=5e Spell List Row
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	}}		}}
Line 29:		Line 30:
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=~~CONCAT( '[[',~~ 5e_Spell._pageName~~, '\|'~~, 5e_Spell.Spell_Name, ~~']]' )~~		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|format=~~list~~		\|format=template
	\|~~delimiter~~=~~<br />~~		\|template=5e Spell List Row
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	}}		}}
Line 40:		Line 41:
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=~~CONCAT( '[[',~~ 5e_Spell._pageName~~, '\|'~~, 5e_Spell.Spell_Name, ~~']]' )~~		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|format=~~list~~		\|format=template
	\|~~delimiter~~=~~<br />~~		\|template=5e Spell List Row
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	}}		}}
Line 52:		Line 53:
	\|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )		\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )
	\|format=~~list~~		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|~~delimiter~~=~~<br />~~		\|format=template
			\|template=5e Spell List Row
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	}}		}}
Line 62:		Line 64:
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=~~CONCAT( '[[',~~ 5e_Spell._pageName~~, '\|'~~, 5e_Spell.Spell_Name, ~~']]' )~~		\|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
	\|format=~~list~~		\|format=template
	\|~~delimiter~~=~~<br />~~		\|template=5e Spell List Row
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	}}		}}
Line 89:		Line 91:
	\|more results text=More Spells		\|more results text=More Spells
	}}</div>		}}</div>
			==Sources and Notes==
			<references />
	{{SRD5 Spell Breadcrumb}}<br />		{{SRD5 Spell Breadcrumb}}<br />
	{{5e Spell Breadcrumb}}		{{5e Spell Breadcrumb}}

Rlyehable at 21:06, 8 October 2020

2020-10-08T21:06:49Z

← Older revision		Revision as of 14:06, 8 October 2020
Line 1:		Line 1:
			<noinclude>
	''These lists exceed the text of the SRD''		''These lists exceed the text of the SRD''
	==Eldritch Knight Spells==		==Eldritch Knight Spells==
			</noinclude>
	''Spells for the {{5ep\|Eldritch Knight}} subclass.''		''Spells for the {{5ep\|Eldritch Knight}} subclass.''
	{\|class="zebra small"		{\|class="zebra small"
Line 37:		Line 39:
	table=5e_Spell, Pages_Info		table=5e_Spell, Pages_Info
	\|join on=5e_Spell._pageName=Pages_Info._pageName		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=2 OR Pages_Info.Hidden IS NULL))		\|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
	\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )		\|fields=CONCAT( '[[', 5e_Spell._pageName, '\|', 5e_Spell.Spell_Name, ']]' )
	\|format=list		\|format=list
Line 67:		Line 69:

	\|}		\|}
			<noinclude>

	==Sortable Table==		==Sortable Table==
Line 76:		Line 78:
	\|fields=COUNT(5e_Spell._pageName)		\|fields=COUNT(5e_Spell._pageName)
	}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).		}} {{5ep\|Eldritch Knight}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).
	<div style="overflow:auto; width:98%; font-size:0.8em;">		<div style="overflow:auto; width:95%; font-size:0.8em;">
	{{#cargo_query:		{{#cargo_query:
	tables=5e_Spell, Pages_Info		tables=5e_Spell, Pages_Info
Line 92:		Line 94:
	[[Category:5e Eldritch Knights\|Spells Eldritch Knight 5e]]		[[Category:5e Eldritch Knights\|Spells Eldritch Knight 5e]]
	[[Category:5e Spells\|Eldritch Knight Spells 5e]]		[[Category:5e Spells\|Eldritch Knight Spells 5e]]
			</noinclude>

Rlyehable: Created page with "''These lists exceed the text of the SRD'' ==Eldritch Knight Spells== ''Spells for the {{5ep|Eldritch Knight}} subclass.'' {|class="zebra small" !Cantrip
0 Level !1st Lev..."

2020-04-16T02:22:20Z

Created page with "''These lists exceed the text of the SRD'' ==Eldritch Knight Spells== ''Spells for the {{5ep|Eldritch Knight}} subclass.'' {|class="zebra small" !Cantrip<br />0 Level !1st Lev..."

New page

''These lists exceed the text of the SRD''
==Eldritch Knight Spells==
''Spells for the {{5ep|Eldritch Knight}} subclass.''
{|class="zebra small"
!Cantrip<br />0 Level
!1st Level
!2nd Level
!3rd Level
!4th Level
|-

|valign="top"|
{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}

|valign="top"|
{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}

|valign="top"|
{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=2 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}

|valign="top"|
{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}

|valign="top"|
{{#cargo_query:
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}

|}

==Sortable Table==
The following is a sortable list of {{#cargo_query:
tables=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} {{5ep|Eldritch Knight}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
<div style="overflow:auto; width:98%; font-size:0.8em;">
{{#cargo_query:
tables=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )=Spell,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters, 5e_Spell.Canon_Spell=Canon,Pages_Info.Sources
|order by=5e_Spell.Sort_Text
|limit=100
|format=table
|more results text=More Spells
}}</div>

{{SRD5 Spell Breadcrumb}}<br />
{{5e Spell Breadcrumb}}
[[Category:5e Eldritch Knights|Spells Eldritch Knight 5e]]
[[Category:5e Spells|Eldritch Knight Spells 5e]]