5e:Artificer/Spell List: Difference between revisions

Latest revision as of 07:25, 21 October 2020

D&D 5e Varied ʰ
See sections for licenses

These lists exceed the text of the published article

Artificer Spells

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

spells for the Artificer subclass.

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	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	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	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	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	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

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: No field named "Hidden" found for the database table "Pages_Info".

Name	Level	School	Casting Time	Range	Components	Casters	Source Notes	Sources

Sources and Notes

Back to Main Page → DnD → 5e → Spell

Varied Licenses

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.

@@ Line 1: / Line 1: @@
+<noinclude>
 <div class="grid-container-std">
 <div class="bctop">{{backto|{{5ed|Artificer}}}}</div>
 <div class="notice"></div>
-<div class="badge">{{5epointer|Wayfinder's Guide to Eberron}}</div>
+<div class="badge">{{5evaried}}</div>
 <div class="gi-main">
 ''These lists exceed the text of the published article''
 ==Artificer Spells==
-''Spells for the [[Artificer (5e)|artificer]] class.''
+</noinclude>
+''{{#cargo_query:
+tables=5e_Spell, Pages_Info
+|join on=5e_Spell._pageName=Pages_Info._pageName
+|where=((5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
+|fields=COUNT(5e_Spell._pageName)
+}} spells for the {{5ep|Artificer}} subclass.''
 {|class="sortable zebra small leftall"
 !Cantrips<br />(0 Level)
@@ Line 17: / Line 24: @@
 |valign="top"|<!--Cantrips (0 Level)-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::Cantrip]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Acid Splash<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Create Bonfire<br />
+|format=template
-Dancing Lights<br />
+|template=5e Spell List Row
-Fire Bolt<br />
+|order by=5e_Spell.Sort_Text
-Frostbite<br />
+}}
-Guidance<br />
-Kiss of Vanti<br />
-Light<br />
-Mage Hand<br />
-Magic Stone<br />
-Mending<br />
-Message<br />
-Poison Spray<br />
-Prestidigitation<br />
-Ray of Frost<br />
-Resistance<br />
-Shadow<br />
-Shocking Grasp<br />
-Spare the Dying<br />
-Thorn Whip<br />
-Thunderclap<br />
 |valign="top"|<!--1st Level-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::1]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Absorb Elements<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Alarm<br />
+|format=template
-Arcane Weapon<br />
+|template=5e Spell List Row
-Catapult<br />
+|order by=5e_Spell.Sort_Text
-Cure Wounds<br />
+}}
-Detect Magic<br />
-Disguise Self<br />
-Expeditious Retreat<br />
-Faerie Fire<br />
-False Life<br />
-Feather Fall<br />
-Grease<br />
-Identify<br />
-Jump<br />
-Longstrider<br />
-Purify Food and Drink<br />
-Sanctuary<br />
-Snare<br />
 |valign="top"|<!--2nd Level-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::2]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Aid<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Alter Self<br />
+|format=template
-Arcane Lock<br />
+|template=5e Spell List Row
-Blur<br />
+|order by=5e_Spell.Sort_Text
-Continual Flame<br />
+}}
-Darkvision<br />
-Enhance Ability<br />
-Enlarge/Reduce<br />
-Heat Metal<br />
-Invisibility<br />
-Levitate<br />
-Magic Mouth<br />
-Magic Weapon<br />
-Protection from Poison<br />
-Pyrotechnics<br />
-Lesser Restoration<br />
-Rope Trick<br />
-See Invisibility<br />
-Skywrite<br />
-Spider Climb<br />
-Web
 |valign="top"|<!--3rd Level-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::3]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Blink<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Catnap<br />
+|format=template
-Create Food and Water<br />
+|template=5e Spell List Row
-Dispel Magic<br />
+|order by=5e_Spell.Sort_Text
-Elemental Weapon<br />
+}}
-Flame Arrows<br />
-Fly<br />
-Glyph of Warding<br />
-Haste<br />
-Protection from Energy<br />
-Revivify<br />
-Tiny Servant<br />
-Water Breathing<br />
-Water Walk <br />
 |valign="top"|<!--4th Level-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::4]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Arcane Eye<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Elemental Bane<br />
+|format=template
-Fabricate<br />
+|template=5e Spell List Row
-Faithful Hound<br />
+|order by=5e_Spell.Sort_Text
-Freedom of Movement<br />
+}}
-Private Sanctum<br />
-Resilient Sphere<br />
-Secret Chest<br />
-Stone Shape<br />
-Stoneskin<br />
 |valign="top"|<!--5th Level-->
-<!--{{#ask: [[Category:5e Spells]] [[Caster::Artificer]][[Level::5]]
+{{#cargo_query:
-|sep=<br />
+table=5e_Spell, Pages_Info
-|format=list
+|join on=5e_Spell._pageName=Pages_Info._pageName
-}}-->
+|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-Animate Objects<br />
+|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
-Arcane Hand<br />
+|format=template
-Creation<br />
+|template=5e Spell List Row
-Greater Restoration<br />
+|order by=5e_Spell.Sort_Text
-Skill Empowerment<br />
+}}
-Transmute Rock<br />
-Wall of Stone <br />
 |}
+<noinclude>
-<!--
 ==Sortable Table==
-The following is a sortable list of {{#ask: [[Category:5e Spells]] [[Caster::Artificer]]|format=count}}{{srd5lc|Artificer}} {{srd5lc|Spell}}s for 5th ed. ([[SRD5|SRD]], [[Canon]] (5e), and [[Homebrew]] (5e Spell)).
+The following is a sortable list of {{#cargo_query:
-{{#ask: [[Category:5e Spells]] [[Caster::Artificer]] [[Level::+]]
+tables=5e_Spell, Pages_Info
-|?=Name
+|join on=5e_Spell._pageName=Pages_Info._pageName
-|?Level
+|where=((5e_Spell.Casters HOLDS 'Artificer') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
-|?School
+|fields=COUNT(5e_Spell._pageName)
-|?Ritual#tick
+}} {{5ep|Artificer}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
-|?Action Type
+<div style="overflow:auto; width:100%; max-height:80vh; font-size:0.75rem;">
-|?Range
+{|class="zebra small sortable"
-|?Component=V,S,M
+!Name
-|?Valuable Components#tick=&curren;
+!Level
-|?Author=Source
+!School
-|mainlabel=-
+!Casting<br />Time
-|headers=plain
+!Range
-|format=broadtable
+!Components
-|class=d20 leftall sortable zebra small
+!Casters
-|sep=&#44;&ensp;
+!Source<br />Notes
-|limit=500
+!Sources
-|default=None created yet! Why don't you add your own?
+|-
+{{#cargo_query:
+tables=5e_Spell,Pages_Info
+|join on=5e_Spell._pageName=Pages_Info._pageName
+|where=5e_Spell.Casters HOLDS 'Artificer' 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,Pages_Info.Deprecated
+|order by=5e_Spell.Sort_Text
+|limit=1000
+|format=template
+|template=5e Spell Table Row
+|more results text=More Spells
 }}
-&curren; (currency symbol) = component has a gp value, and must be provided in addition to a {{srd5lc|Spell Focus}} or other components.<br />
+|}</div>
-<sup>V,S,M</sup> Verbal, Somatic, Material components
--->
 </div><!--gi-main-->
 <div class="source">
-{{SRD5 Spell Breadcrumb}}<br />
-{{5e Spell Breadcrumb}}
+==Sources and Notes==
+<references />
+{{5e Footer|Spell|Varied}}<br />
 </div><!--source-->
 </div><!--grid-container-std-->
@@ Line 177: / Line 135: @@
 [[Category:5e Spells]]
 [[Category:5e Artificers|Spells Artificer 5e]]
+</noinclude>

5e:Artificer/Spell List: Difference between revisions

Latest revision as of 07:25, 21 October 2020

Artificer Spells

Sortable Table

Sources and Notes

Navigation menu

Search