5e:Artificer/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 20: Line 20:
|valign="top"|<!--Cantrips (0 Level)-->
|valign="top"|<!--Cantrips (0 Level)-->
{{#cargo_query:
{{#cargo_query:
tables=5e_Spell,Pages_Info
table=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.Level='Cantrip' AND 5e_Spell.Casters HOLDS 'Artificer'
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|order by=5e_Spell.Spell_Name
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
|fields=CONCAT( '[[', 5e_Spell.Page_Name, '|', 5e_Spell.Spell_Name, ']]' )<!--, CONCAT( '<ref>', Pages_Info.Sources, '</ref>' )-->
|format=template
|format=list
|template=5e Spell List Row
|delimiter=<br />
|order by=5e_Spell.Sort_Text
}}
}}
<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::Cantrip]]
|sep=<br />
|format=list
}}''-->
----
----
''{{srd5lc|Acid Splash}}'' <ref name="srd5" /><br />
''{{5edlc|Create Bonfire}}'' <ref name="xan">{{pub|Xanathar's Guide to Everything}}</ref><br />
''{{5edlc|Create Bonfire}}'' <ref name="xan" /><br />
''{{srd5lc|Dancing Lights}}'' <ref name="srd5" /><br />
''{{srd5lc|Fire Bolt}}'' <ref name="srd5" /><br />
''{{5edlc|Frostbite}}'' <ref name="xan" /><br />
''{{5edlc|Frostbite}}'' <ref name="xan" /><br />
''{{srd5lc|Guidance}}'' <ref name="srd5" /><br /><!--
{{5espell|Kiss of Vanti}} <ref group="uc" name="rly" /><br />-->
''{{srd5lc|Light Spell|Light}}'' <ref name="srd5" /><br />
''{{srd5lc|Mage Hand}}'' <ref name="srd5" /><br />
''{{5edlc|Magic Stone}}'' <ref name="xan" /><br />
''{{5edlc|Magic Stone}}'' <ref name="xan" /><br />
''{{srd5lc|Mending}}'' <ref name="srd5" /><br />
''{{srd5lc|Message}}'' <ref name="srd5" /><br />
''{{srd5lc|Poison Spray}}'' <ref name="srd5" /><br />
''{{srd5lc|Prestidigitation}}'' <ref name="srd5" /><br />
''{{srd5lc|Ray of Frost}}'' <ref name="srd5" /><br />
''{{srd5lc|Resistance Spell|Resistance}}'' <ref name="srd5" /><br /><!--
{{5espell|Shadow}} <ref group="uc" name="rly" /><br />-->
''{{srd5lc|Shocking Grasp}}'' <ref name="srd5" /><br />
''{{srd5lc|Spare the Dying}}'' <ref name="srd5" /><br />
''{{5edlc|Thorn Whip}}'' <ref name="phb">{{pub|Player's Handbook (5e)}}</ref><br />
''{{5edlc|Thunderclap}}'' <ref name="xan" /><br />
''{{5edlc|Thunderclap}}'' <ref name="xan" /><br />


Line 58: Line 37:
|valign="top"|<!--1st Level-->
|valign="top"|<!--1st Level-->
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
table=5e_Spell, Pages_Info
|where=Level='1' AND Casters HOLDS 'Artificer'
|join on=5e_Spell._pageName=Pages_Info._pageName
|order by=Spell_Name
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', _pageName, '|', 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
}}
}}
----
----
''{{5edlc|Absorb Elements}}'' <ref name="xan" /><br />
''{{5edlc|Absorb Elements}}'' <ref name="xan" /><br />
''{{srd5lc|Alarm}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{5edlc|Catapult}}'' <ref name="xan" /><br />
''{{5edlc|Catapult}}'' <ref name="xan" /><br />
''{{srd5lc|Cure Wounds}}'' <ref name="srd5" /><br />
''{{srd5lc|Detect Magic}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Disguise Self}}'' <ref name="srd5" /><br />
''{{srd5lc|Expeditious Retreat}}'' <ref name="srd5" /><br />
''{{srd5lc|Faerie Fire}}'' <ref name="srd5" /><br />
''{{srd5lc|False Life}}'' <ref name="srd5" /><br />
''{{srd5lc|Feather Fall}}'' <ref name="srd5" /><br />
''{{srd5lc|Grease}}'' <ref name="srd5" /><br />
''{{srd5lc|Identify}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Jump Spell|Jump}}'' <ref name="srd5" /><br />
''{{srd5lc|Longstrider}}'' <ref name="srd5" /><br />
''{{srd5lc|Purify Food and Drink}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Sanctuary}}'' <ref name="srd5" /><br />
''{{5edlc|Snare}}'' <ref name="xan" /><br />
''{{5edlc|Snare}}'' <ref name="xan" /><br />


|valign="top"|<!--2nd Level-->
|valign="top"|<!--2nd Level-->
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
table=5e_Spell, Pages_Info
|where=Level='2' AND Casters HOLDS 'Artificer'
|join on=5e_Spell._pageName=Pages_Info._pageName
|order by=Spell_Name
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', _pageName, '|', 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
}}
}}
----
----
''{{srd5lc|Aid}}'' <ref name="srd5" /><br />
''{{srd5lc|Alter Self}}'' <ref name="srd5" /><br />
''{{srd5lc|Arcane Lock}}'' <ref name="srd5" /><br />
''{{srd5lc|Blur}}'' <ref name="srd5" /><br />
''{{srd5lc|Continual Flame}}'' <ref name="srd5" /><br />
''{{srd5lc|Darkvision Spell|darkvision}}'' <ref name="srd5" /><br />
''{{srd5lc|Enhance Ability}}'' <ref name="srd5" /><br />
''{{srd5lc|Enlarge/Reduce}}'' <ref name="srd5" /><br />
''{{srd5lc|Heat Metal}}'' <ref name="srd5" /><br />
''{{srd5lc|Invisibility}}'' <ref name="srd5" /><br />
''{{srd5lc|Levitate}}'' <ref name="srd5" /><br />
''{{srd5lc|Magic Mouth}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Magic Weapon}}'' <ref name="srd5" /><br />
''{{srd5lc|Protection from Poison}}'' <ref name="srd5" /><br />
''{{5edlc|Pyrotechnics}}'' <ref name="xan" /><br />
''{{5edlc|Pyrotechnics}}'' <ref name="xan" /><br />
''{{srd5lc|Lesser Restoration}}'' <ref name="srd5" /><br />
''{{srd5lc|Rope Trick}}'' <ref name="srd5" /><br />
''{{srd5lc|See Invisibility}}'' <ref name="srd5" /><br />
''{{5edlc|Skywrite}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{5edlc|Skywrite}}'' <ref name="xan" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Spider Climb}}'' <ref name="srd5" /><br />
''{{srd5lc|Web}}'' <ref name="srd5" /><br />


|valign="top"|<!--3rd Level-->
|valign="top"|<!--3rd Level-->
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
table=5e_Spell, Pages_Info
|where=Level='3' AND Casters HOLDS 'Artificer'
|join on=5e_Spell._pageName=Pages_Info._pageName
|order by=Spell_Name
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', _pageName, '|', 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
}}
}}
----
----
''{{srd5lc|Blink}}'' <ref name="srd5" /><br />
''{{5edlc|Catnap}}'' <ref name="xan" /><br />
''{{5edlc|Catnap}}'' <ref name="xan" /><br />
''{{srd5lc|Create Food and Water}}'' <ref name="srd5" /><br />
''{{srd5lc|Dispel Magic}}'' <ref name="srd5" /><br />
''{{srd5lc|Elemental Weapon}}'' <ref name="srd5" /><br />
''{{5edlc|Flame Arrows}}'' <ref name="xan" /><br />
''{{5edlc|Flame Arrows}}'' <ref name="xan" /><br />
''{{srd5lc|Fly Spell|fly}}'' <ref name="srd5" /><br />
''{{srd5lc|Glyph of Warding}}'' <ref name="srd5" /><br />
''{{srd5lc|Haste}}'' <ref name="srd5" /><br />
''{{srd5lc|Protection from Energy}}'' <ref name="srd5" /><br />
''{{srd5lc|Revivify}}'' <ref name="srd5" /><br />
''{{5edlc|Tiny Servant}}'' <ref name="xan" /><br />
''{{5edlc|Tiny Servant}}'' <ref name="xan" /><br />
''{{srd5lc|Water Breathing}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />
''{{srd5lc|Water Walk}}'' <ref name="srd5" /> <sup>{{iplink|Notes|[r]}}</sup><br />


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
table=5e_Spell, Pages_Info
|where=Level='4' AND Casters HOLDS 'Artificer'
|join on=5e_Spell._pageName=Pages_Info._pageName
|order by=Spell_Name
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', _pageName, '|', 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
}}
}}
----
----
''{{srd5lc|Arcane Eye}}'' <ref name="srd5" /><br />
''{{5edlc|Elemental Bane}}'' <ref name="xan" /><br />
''{{5edlc|Elemental Bane}}'' <ref name="xan" /><br />
''{{srd5lc|Fabricate}}'' <ref name="srd5" /><br />
''{{srd5lc|Faithful Hound}}'' <ref name="srd5" /><br />
''{{srd5lc|Freedom of Movement}}'' <ref name="srd5" /><br />
''{{srd5lc|Private Sanctum}}'' <ref name="srd5" /><br />
''{{srd5lc|Resilient Sphere}}'' <ref name="srd5" /><br />
''{{srd5lc|Secret Chest}}'' <ref name="srd5" /><br />
''{{srd5lc|Stone Shape}}'' <ref name="srd5" /><br />
''{{srd5lc|Stoneskin}}'' <ref name="srd5" /><br />


|valign="top"|<!--5th Level-->
|valign="top"|<!--5th Level-->
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
table=5e_Spell, Pages_Info
|where=Level='5' AND Casters HOLDS 'Artificer'
|join on=5e_Spell._pageName=Pages_Info._pageName
|order by=Spell_Name
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', _pageName, '|', 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
}}
}}
----
----
''{{srd5lc|Animate Objects}}'' <ref name="srd5" /><br />
''{{srd5lc|Arcane Hand}}'' <ref name="srd5" /><br />
''{{srd5lc|Creation}}'' <ref name="srd5" /><br />
''{{srd5lc|Greater Restoration}}'' <ref name="srd5" /><br />
''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br />
''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br />
''{{5edlc|Transmute Rock}}'' <ref name="xan" /><br />
''{{5edlc|Transmute Rock}}'' <ref name="xan" /><br />
''{{srd5lc|Wall of Stone}}'' <ref name="srd5" /><br />
|}
|}
* Below the lines is canon.
* Below the lines is canon.
Line 184: Line 110:


==Sortable Table==
==Sortable Table==
The following is a sortable list of  
The following is a sortable list of {{#cargo_query:
{{#cargo_query:
tables=5e_Spell, Pages_Info
table=5e_Spell
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=Casters HOLDS 'Artificer'
|where=((5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(_pageName)
|fields=COUNT(5e_Spell._pageName)
}} {{5ed|Artificer}} {{srd5lc|Spell}}s
}} {{5ep|Artificer}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
<div style="overflow:auto; width:100%; font-size:0.8em;">
<div style="overflow:auto; width:98%; font-size:0.8em;">
{{#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.Casters HOLDS 'Artificer'
|where=((5e_Spell.Casters HOLDS 'Artificer') 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=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 201: Line 127:
|more results text=More Spells
|more results text=More Spells
}}</div>
}}</div>
<!--
 
{{#ask: [[Category:5e Spells]] [[Caster::Artificer]]|format=count}}''''{{srd5lclc|Artificer}}'' ''{{srd5lclc|Spell}}''s for 5th ed. ([[SRD5|SRD]], [[Canon]] (5e), and [[Homebrew]] (5e Spell)).
{{#ask: [[Category:5e Spells]] [[Caster::Artificer]] [[Level::+]]
|?=Name
|?Level
|?School
|?Ritual#tick
|?Action Type
|?Range
|?Component=V,S,M
|?Valuable Components#tick=&curren;
|?Author=Source
|mainlabel=-
|headers=plain
|format=broadtable
|class=d20 leftall sortable zebra small
|sep=&#44;&ensp;
|limit=500
|default=None created yet! Why don't you add your own?
}}''
&curren; (currency symbol) = component has a gp value, and must be provided in addition to a ''{{srd5lclc|Spell Focus}}'' or other components.<br />
<sup>V,S,M</sup> Verbal, Somatic, Material components
-->
</div><!--gi-main-->
</div><!--gi-main-->
<div class="source">
<div class="source">


==Sources and Notes==
==Sources and Notes==
<references>
<references />
<ref name="srd5">{{pub|SRD-OGL v5.1}}</ref>
<ref name="xan">{{pub|Xanathar's Guide to Everything}}</ref>
</references>
<!--
===User Creations <sup>[uc]</sup>===
<references group="uc">
<ref group="uc" name="rly">[[user:Rlyehable]]</ref>
</references>
-->
===Notes===
:<sup>[r]</sup> These spells may be cast as {{srd5lc|Ritural}}s.


----
{{5e Footer|Spell|Varied}}<br />
{{SRD5 Spell Breadcrumb}}<br />
{{5e Spell Breadcrumb}}
</div><!--source-->
</div><!--source-->
</div><!--grid-container-std-->
</div><!--grid-container-std-->

Revision as of 14:17, 30 April 2020

< Artificer
Work in Progress

D&D 5e Varied ʰ 
See sections for licenses


These lists exceed the text of the published article

Artificer Spells

Spells for the Artificer class.

Cantrips
(0 Level) 		1st Level 2nd Level 3rd Level 4th Level 5th Level
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=0 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

create bonfire [1]
frostbite [1]
magic stone [1]
thunderclap [1]
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=1 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

absorb elements [1]
catapult [1]
snare [1]
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=2 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

pyrotechnics [1]
skywrite [1] [r]
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=3 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

catnap [1]
flame arrows [1]
tiny servant [1]
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=4 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

elemental bane [1]
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`Level`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

skill empowerment [1]
transmute rock [1]

  • Below the lines is canon.


Sortable Table

The following is a sortable list of
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT COUNT(`rly2_cargo__5e_Spell`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

Artificer spells for 5th ed. (official and unofficial).
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `Spell`,`rly2_cargo__5e_Spell`.`Level` AS `Level`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Action_Type` AS `Casting`,`rly2_cargo__5e_Spell`.`Spell_Range` AS `Range`,`Component__full` AS `VSM`,`rly2_cargo__5e_Spell`.`Valuable_Component` AS `VC`,`rly2_cargo__5e_Spell`.`Consumable_Component` AS `CC`,`Casters__full` AS `Casters`,`rly2_cargo__5e_Spell`.`Canon_Spell` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE ((`rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Artificer') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

Sources and Notes

  1. Xanathar's Guide to Everything ↑ 1.00 1.01 1.02 1.03 1.04 1.05 1.06 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.14
Back to Main Page → DnD → 5e → Spell
  Varied Licenses
Caution
Varied
Licenses

This is article is covered by varying licenses, rather than the Creative Commons Attribution Sharealike License. Please see the Sources section for individual sources and licenses.



Retrieved from "https://wiki.rlyehable.com/index.php?title=5e:Artificer/Spell_List&oldid=5710"