5e:Ranger/Spell List - Revision history

Rlyehable at 17:23, 29 December 2022

2022-12-29T17:23:45Z

← Older revision		Revision as of 10:23, 29 December 2022
Line 10:		Line 10:
	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 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Casters HOLDS 'Ranger'
	\|fields=COUNT(5e_Spell._pageName)		\|fields=COUNT(5e_Spell._pageName)
	}} spells for the {{SRD5\|Ranger}} subclass.''		}} spells for the {{SRD5\|Ranger}} subclass.''
Line 25:		Line 25:
	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=1 AND 5e_Spell.Casters HOLDS 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Ranger'
	\|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 36:		Line 36:
	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=2 AND 5e_Spell.Casters HOLDS 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Ranger'
	\|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 48:		Line 48:
	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=3 AND 5e_Spell.Casters HOLDS 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Ranger'
	\|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 60:		Line 60:
	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=4 AND 5e_Spell.Casters HOLDS 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Ranger'
	\|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 72:		Line 72:
	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=5 AND 5e_Spell.Casters HOLDS 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Ranger'
	\|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 86:		Line 86:
	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 'Ranger'~~) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))~~		\|where=5e_Spell.Casters HOLDS 'Ranger'
	\|fields=COUNT(5e_Spell._pageName)		\|fields=COUNT(5e_Spell._pageName)
	}} {{SRD5\|Ranger}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).		}} {{SRD5\|Ranger}} {{srd5lc\|Spell}}s for 5th ed. (official and unofficial).
Line 104:		Line 104:
	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 'Ranger' ~~AND ((Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)~~ AND (Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL))		\|where=5e_Spell.Casters HOLDS 'Ranger' 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,Pages_Info.Deprecated		\|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.User,Pages_Info.Sources,Pages_Info.Deprecated
	\|order by=5e_Spell.Sort_Text		\|order by=5e_Spell.Sort_Text
	\|limit=1000		\|limit=1000

Rlyehable at 14:39, 21 October 2020

2020-10-21T14:39:21Z

← Older revision		Revision as of 07:39, 21 October 2020
Line 115:		Line 115:
	</div><!--gi-main-->		</div><!--gi-main-->
	<div class="source">		<div class="source">
			==Sources and Notes==
			<references />
	</div><!--source-->		</div><!--source-->
	</div><!--grid-container-std-->		</div><!--grid-container-std-->

Rlyehable at 14:38, 21 October 2020

2020-10-21T14:38:22Z

@@ Line 81: / Line 81: @@
 |}
 <noinclude>
 </div><!--gi-main-->
 <div class="source">

Rlyehable at 19:22, 19 October 2020

2020-10-19T19:22:28Z

← Older revision		Revision as of 12:22, 19 October 2020
Line 5:		Line 5:
	<div class="badge">{{5evaried}}</div>		<div class="badge">{{5evaried}}</div>
	<div class="gi-main">		<div class="gi-main">
	==~~Paladin~~ Spells==		==Ranger Spells==
	~~''Spells for the ''{{SRD5\|Ranger}}'' class.''~~
	</noinclude>		</noinclude>
			''{{#cargo_query:
			tables=5e_Spell, Pages_Info
			\|join on=5e_Spell._pageName=Pages_Info._pageName
			\|where=((5e_Spell.Casters HOLDS 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
			\|fields=COUNT(5e_Spell._pageName)
			}} spells for the {{SRD5\|Ranger}} subclass.''
	{\|class="zebra small"		{\|class="zebra small"
	!1st Level		!1st Level

Rlyehable at 01:26, 30 September 2020

2020-09-30T01:26:09Z

← Older revision		Revision as of 18:26, 29 September 2020
Line 1:		Line 1:
			<noinclude>
	<div class="grid-container-std">		<div class="grid-container-std">
	<div class="bctop">{{backto\|{{SRD5\|Ranger}}}}</div>		<div class="bctop">{{backto\|{{SRD5\|Ranger}}}}</div>
Line 6:		Line 7:
	==Paladin Spells==		==Paladin Spells==
	''Spells for the ''{{SRD5\|Ranger}}'' class.''		''Spells for the ''{{SRD5\|Ranger}}'' class.''
			</noinclude>
	{\|class="zebra small"		{\|class="zebra small"
	!1st Level		!1st Level
Line 73:		Line 75:

	\|}		\|}
			<noinclude>
	</div><!--gi-main-->		</div><!--gi-main-->
	<div class="source">		<div class="source">
Line 80:		Line 83:
	[[Category:5e Rangers\|Spells Ranger 5e]]		[[Category:5e Rangers\|Spells Ranger 5e]]
	[[Category:5e Spells\|Ranger Spells 5e]]		[[Category:5e Spells\|Ranger Spells 5e]]
			</noinclude>

Rlyehable: Created page with "

{{backto|{{SRD5|Ranger}}}}

{{5evaried}}

==P..."

2020-04-30T20:07:29Z

Created page with "<div class="grid-container-std"> <div class="bctop">{{backto|{{SRD5|Ranger}}}}</div> <div class="notice"></div> <div class="badge">{{5evaried}}</div> <div class="gi-main"> ==P..."

New page

<div class="grid-container-std">
<div class="bctop">{{backto|{{SRD5|Ranger}}}}</div>
<div class="notice"></div>
<div class="badge">{{5evaried}}</div>
<div class="gi-main">
==Paladin Spells==
''Spells for the ''{{SRD5|Ranger}}'' class.''
{|class="zebra small"
!1st Level
!2nd Level
!3rd Level
!4th Level
!5th Level
|-

|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 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|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=2 AND 5e_Spell.Casters HOLDS 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|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 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|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 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|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=5 AND 5e_Spell.Casters HOLDS 'Ranger') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|format=template
|template=5e Spell List Row
|order by=5e_Spell.Sort_Text
}}

|}
</div>
<div class="source">

</div>
</div>
[[Category:5e Rangers|Spells Ranger 5e]]
[[Category:5e Spells|Ranger Spells 5e]]