5e:Artificer/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>
<div class="grid-container-std">
<div class="grid-container-std">
<div class="bctop">{{backto|{{5ed|Artificer}}}}</div>
<div class="bctop">{{backto|{{5ed|Artificer}}}}</div>
<div class="notice"></div>
<div class="notice"></div>
<div class="badge">{{5epointer|Wayfinder's Guide to Eberron}}</div>
<div class="badge">{{5evaried}}</div>
<div class="gi-main">
<div class="gi-main">
''These lists exceed the text of the published article''
''These lists exceed the text of the published article''
==Artificer Spells==
==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"
{|class="sortable zebra small leftall"
!Cantrips<br />(0 Level)
!Cantrips<br />(0 Level)
Line 17: Line 24:


|valign="top"|<!--Cantrips (0 Level)-->
|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))
''{{srd5lc|Acid Splash}}'' <ref name="srd5">{{pub|SRD-OGL v5.1}}</ref><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Create Bonfire}}'' <ref name="xan">{{pub|Xanathar's Guide to Everything}}</ref><br />
|format=template
''{{srd5lc|Dancing Lights}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Fire Bolt}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{5edlc|Frostbite}}'' <ref name="xan" /><br />
}}
''{{srd5lc|Guidance}}'' <ref name="srd5" /><br />
''{{5edlc|Kiss of Vanti}}'' <ref group="uc" name="rly">[[user:Rlyehable]]</ref><br />
''{{srd5lc|Light Spell|Light}}'' <ref name="srd5" /><br />
''{{srd5lc|Mage Hand}}'' <ref name="srd5" /><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}}'' <ref name="srd5" /><br />
''{{5edlc|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 />


|valign="top"|<!--1st Level-->
|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))
''{{5edlc|Absorb Elements}}'' <ref name="xan" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Alarm}}'' <ref name="srd5" /> <ref group="r" name="ritual">May be cast as a {{srd5lc|Ritual}}</ref><br />
|format=template
''{{5edlc|Catapult}}'' <ref name="xan" /><br />
|template=5e Spell List Row
''{{srd5lc|Cure Wounds}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Detect Magic}}'' <ref name="srd5" /> <ref group="r" name="ritual" /><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" /> <ref group="r" name="ritual" /><br />
''{{srd5lc|Jump Spell|Jump}}'' <ref name="srd5" /><br />
''{{srd5lc|Longstrider}}'' <ref name="srd5" /><br />
''{{srd5lc|Purify Food and Drink}}'' <ref name="srd5" /><br />
''{{srd5lc|Sanctuary}}'' <ref name="srd5" /><br />
''{{5edlc|Snare}}'' <ref name="xan" /><br />


|valign="top"|<!--2nd Level-->
|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))
''{{srd5lc|Aid}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Alter Self}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Arcane Lock}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Blur}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{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" /> <ref group="r" name="ritual" /><br />
''{{srd5lc|Magic Weapon}}'' <ref name="srd5" /><br />
''{{srd5lc|Protection from Poison}}'' <ref name="srd5" /><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" /><br />
''{{srd5lc|Spider Climb}}'' <ref name="srd5" /><br />
''{{srd5lc|Web}}'' <ref name="srd5" /><br />


|valign="top"|<!--3rd Level-->
|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))
''{{srd5lc|Blink}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Catnap}}'' <ref name="xan" /><br />
|format=template
''{{srd5lc|Create Food and Water}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Dispel Magic}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{srd5lc|Elemental Weapon}}'' <ref name="srd5" /><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 />
''{{srd5lc|Water Breathing}}'' <ref name="srd5" /> <ref group="r" name="ritual" /><br />
''{{srd5lc|Water Walk}}'' <ref name="srd5" /> <ref group="r" name="ritual" /><br />


|valign="top"|<!--4th Level-->
|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))
''{{srd5lc|Arcane Eye}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{5edlc|Elemental Bane}}'' <ref name="xan" /><br />
|format=template
''{{srd5lc|Fabricate}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Faithful Hound}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{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-->
<!--{{#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))
''{{srd5lc|Animate Objects}}'' <ref name="srd5" /><br />
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User
''{{srd5lc|Arcane Hand}}'' <ref name="srd5" /><br />
|format=template
''{{srd5lc|Creation}}'' <ref name="srd5" /><br />
|template=5e Spell List Row
''{{srd5lc|Greater Restoration}}'' <ref name="srd5" /><br />
|order by=5e_Spell.Sort_Text
''{{5edlc|Skill Empowerment}}'' <ref name="xan" /><br />
}}
''{{5edlc|Transmute Rock}}'' <ref name="xan" /><br />
''{{srd5lc|Wall of Stone}}'' <ref name="srd5" /><br />
|}
|}
<noinclude>


<!--
==Sortable Table==
==Sortable Table==
The following is a sortable list of {{#ask: [[Category:5e Spells]] [[Caster::Artificer]]|format=count}}''''{{srd5lclc|Artificer}}'' ''{{srd5lclc|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:
&curren; (currency symbol) = component has a gp value, and must be provided in addition to a ''{{srd5lclc|Spell Focus}}'' or other components.<br />
tables=5e_Spell,Pages_Info
<sup>V,S,M</sup> Verbal, Somatic, Material components
|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
}}
|}</div>
 
</div><!--gi-main-->
</div><!--gi-main-->
<div class="source">
<div class="source">
Line 172: Line 128:
==Sources and Notes==
==Sources and Notes==
<references />
<references />
===User Creations===
 
<references group="uc" />
{{5e Footer|Spell|Varied}}<br />
{{SRD5 Spell Breadcrumb}}<br />
{{5e Spell Breadcrumb}}
</div><!--source-->
</div><!--source-->
</div><!--grid-container-std-->
</div><!--grid-container-std-->
Line 181: Line 135:
[[Category:5e Spells]]
[[Category:5e Spells]]
[[Category:5e Artificers|Spells Artificer 5e]]
[[Category:5e Artificers|Spells Artificer 5e]]
</noinclude>

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