Template:5e Spell Data - Revision history

Rlyehable at 14:58, 2 November 2022

2022-11-02T14:58:39Z

← Older revision		Revision as of 07:58, 2 November 2022
Line 6:		Line 6:
	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.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}' ~~AND ({{#if: {{{hid\|}}}\|Pages_Info.Pointer=0 or Pages_Info.Pointer IS NULL\|Pages_Info.Hidden=0 or Pages_Info.Hidden IS NULL\|}})~~		\|where=5e_Spell.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}'
	\|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=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		\|order by=5e_Spell.Sort_Text

Rlyehable at 21:04, 7 December 2020

2020-12-07T21:04:56Z

← Older revision		Revision as of 14:04, 7 December 2020
Line 1:		Line 1:
	<includeonly>		<includeonly>
	----		----
	~~'''Spell data:'''<br />~~		<div style="display:block; overflow:auto; max-width:90vw; padding:0 0.5em; font-size:0.75rem;">
	<div style="display:block; overflow:auto; max-width:90vw; font-size:0.75rem;">		'''''Spell data ''''' <span class="mw-customtoggle-myDivision-SpellData"><sup>+</sup></span>
	{{#cargo_query:		<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-myDivision-SpellData>{{#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
Line 12:		Line 12:
	\|format=table		\|format=table
	\|more results text=More Spells		\|more results text=More Spells
	}}</div></includeonly><noinclude>		}}</div><!--collapsable--></div></div></includeonly><noinclude>
	===Syntax===		===Syntax===
	<pre>{{5e Spell Data\|optSpellName}}</pre>		<pre>{{5e Spell Data\|optSpellName}}</pre>

Rlyehable at 20:33, 7 December 2020

2020-12-07T20:33:55Z

← Older revision		Revision as of 13:33, 7 December 2020
Line 2:		Line 2:
	----		----
	'''Spell data:'''<br />		'''Spell data:'''<br />
	<div style="overflow:auto; width:~~100%~~; font-size:0.~~75em~~;">		<div style="display:block; overflow:auto; max-width:90vw; font-size:0.75rem;">
	{{#cargo_query:		{{#cargo_query:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info

Rlyehable at 00:33, 4 October 2020

2020-10-04T00:33:50Z

← Older revision		Revision as of 17:33, 3 October 2020
Line 6:		Line 6:
	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.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}'		\|where=5e_Spell.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}' AND ({{#if: {{{hid\|}}}\|Pages_Info.Pointer=0 or Pages_Info.Pointer IS NULL\|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=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		\|order by=5e_Spell.Sort_Text
Line 17:		Line 17:

	'''Note:''' For spell names with an apostrophe ('), you must double the apostrophe (<nowiki>''</nowiki>).		'''Note:''' For spell names with an apostrophe ('), you must double the apostrophe (<nowiki>''</nowiki>).

			===Add'l Entries===
			<pre>\|hid= <!--blank or true--></pre>

	{{5e Spell Data}}		{{5e Spell Data}}

Rlyehable at 19:34, 6 April 2020

2020-04-06T19:34:34Z

← Older revision		Revision as of 12:34, 6 April 2020
Line 5:		Line 5:
	{{#cargo_query:		{{#cargo_query:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info
	\|join on=5e_Spell.~~Page_Name~~=Pages_Info.~~Page_Name~~		\|join on=5e_Spell._pageName=Pages_Info._pageName
	\|where=5e_Spell.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}'		\|where=5e_Spell.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}'
	\|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=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

Rlyehable at 19:14, 27 February 2020

2020-02-27T19:14:26Z

← Older revision		Revision as of 12:14, 27 February 2020
Line 15:		Line 15:
	===Syntax===		===Syntax===
	<pre>{{5e Spell Data\|optSpellName}}</pre>		<pre>{{5e Spell Data\|optSpellName}}</pre>

			'''Note:''' For spell names with an apostrophe ('), you must double the apostrophe (<nowiki>''</nowiki>).

	{{5e Spell Data}}		{{5e Spell Data}}

Rlyehable at 14:15, 25 February 2020

2020-02-25T14:15:04Z

← Older revision		Revision as of 07:15, 25 February 2020
Line 2:		Line 2:
	----		----
	'''Spell data:'''<br />		'''Spell data:'''<br />
	<div style="overflow:auto; width:100%; font-size:0.~~8em~~;">		<div style="overflow:auto; width:100%; font-size:0.75em;">
	{{#cargo_query:		{{#cargo_query:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info
Line 20:		Line 20:
	{{5e Spell Data\|Acid Arrow}}		{{5e Spell Data\|Acid Arrow}}

	[[Category:5e ~~Template s~~]]		[[Category:5e Templates]]
	</noinclude>		</noinclude>

Rlyehable at 20:30, 24 February 2020

2020-02-24T20:30:33Z

@@ Line 1: / Line 1: @@
 ----
 '''Spell data:'''<br />
@@ Line 11: / Line 12: @@
 |format=table
 |more results text=More Spells
-}}</div>
+}}</div></includeonly><noinclude>

Rlyehable at 20:21, 24 February 2020

2020-02-24T20:21:11Z

← Older revision		Revision as of 13:21, 24 February 2020
Line 5:		Line 5:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info
	\|join on=5e_Spell.Page_Name=Pages_Info.Page_Name		\|join on=5e_Spell.Page_Name=Pages_Info.Page_Name
	\|where=5e_Spell.Spell_Name={{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}}\|}}		\|where=5e_Spell.Spell_Name='{{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}} }}'
	\|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=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		\|order by=5e_Spell.Sort_Text

Rlyehable at 20:13, 24 February 2020

2020-02-24T20:13:12Z

← Older revision		Revision as of 13:13, 24 February 2020
Line 5:		Line 5:
	tables=5e_Spell,Pages_Info		tables=5e_Spell,Pages_Info
	\|join on=5e_Spell.Page_Name=Pages_Info.Page_Name		\|join on=5e_Spell.Page_Name=Pages_Info.Page_Name
	\|where=5e_Spell.Spell_Name={{#if: {{{1\|}}}\|{{{1}}}\|~~5e_Spell.Page_Name~~\|}}		\|where=5e_Spell.Spell_Name={{#if: {{{1\|}}}\|{{{1}}}\|{{PAGENAME}}\|}}
	\|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=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		\|order by=5e_Spell.Sort_Text