5e:Arcane Trickster/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
 
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 'Arcane Trickster') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=(((5e_Spell.Casters HOLDS 'Arcane Trickster') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) AND (Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL))
|fields=COUNT(5e_Spell._pageName)
|fields=COUNT(5e_Spell._pageName)
}} spells for the {{5ep|Arcane Trickster}} subclass.''
}} spells for the {{5ep|Arcane Trickster}} 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=0 AND 5e_Spell.Casters HOLDS 'Wizard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=(((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Wizard') 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, Pages_Info.Sources, Pages_Info.User  
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User<!--, 5e_Spell.School, 5e_Spell.Ritual, 5e_Spell.Valuable_Component-->
|format=template
|format=template
|template=5e Spell List Row
|template=5e Spell List Row
Line 37: Line 37:
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 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) 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, 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=2 AND 5e_Spell.Casters HOLDS 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) 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, 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 59: Line 59:
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 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) 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, 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 70: Line 70:
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 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Wizard') AND (5e_Spell.School='Enchantment' OR 5e_Spell.School='Illusion')) 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, Pages_Info.Sources, Pages_Info.User  
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, Pages_Info.Sources, Pages_Info.User  
|format=template
|format=template

Latest revision as of 17:19, 19 December 2020

< Arcane Trickster

D&D 5e Varied ʰ 
See sections for licenses


Arcane Trickster 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`= 'Arcane Trickster') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` IS NULL)) ORDER BY COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

spells for the Arcane Trickster subclass.
Cantrip
0 Level 		1st Level 2nd Level 3rd Level 4th 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`= 'Wizard') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` 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`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` 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`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` 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`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` 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`= 'Wizard') ) AND (`rly2_cargo__5e_Spell`.`School`='Enchantment' OR `rly2_cargo__5e_Spell`.`School`='Illusion')) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND (`rly2_cargo__Pages_Info`.`Deprecated`=0 OR `rly2_cargo__Pages_Info`.`Deprecated` 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`= 'Arcane Trickster') ) 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

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

Back to Main Page → DnD → 5e → SRD5 → Spells → Arcane Trickster
Back to Main Page → DnD → 5e → Spell

Sources and Notes

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