5e:Warlock/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
(Created page with "<div class="grid-container-std"> <div class="bctop">{{backto|{{SRD5|Warlock}}}}</div> <div class="notice"></div> <div class="badge">{{5evaried}}</div> <div class="gi-main"> ==...")
 
No edit summary
 
(6 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|{{SRD5|Warlock}}}}</div>
<div class="bctop">{{backto|{{SRD5|Warlock}}}}</div>
Line 4: Line 5:
<div class="badge">{{5evaried}}</div>
<div class="badge">{{5evaried}}</div>
<div class="gi-main">
<div class="gi-main">
==Eldritch Knight Spells==
==Warlock Spells==
''Spells for the {{5ep|Warlock}} {{srd5lc|Class}}.''
</noinclude>
''{{#cargo_query:
tables=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
}} spells for the {{SRD5|Warlock}} subclass.''
{|class="zebra small"
{|class="zebra small"
!Cantrip<br />0 Level
!Cantrip<br />0 Level
Line 19: Line 26:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 31: Line 38:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 41: 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=0 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=2 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 53: Line 60:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 64: Line 71:
|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 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 72: Line 79:
|-
|-
!5th Level
!5th Level
!6th Level <ref name="arcanum">Note: This level may only be cast using the {{SRD5|Mystic Arcanum}}</ref>
!6th Level  
!7th Level <ref name="arcanum" />
!7th Level  
!8th Level <ref name="arcanum" />
!8th Level  
!9th Level <ref name="arcanum" />
!9th Level  
|-
|-


Line 83: Line 90:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=5 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 94: Line 101:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=6 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 105: Line 112:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=7 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 116: Line 123:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=8 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}
Line 127: Line 134:
|join on=5e_Spell._pageName=Pages_Info._pageName
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=9 AND 5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.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
|order by=5e_Spell.Sort_Text
}}
}}


|}
|}
 
<noinclude>


==Sortable Table==
==Sortable Table==
Line 142: Line 149:
|where=((5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=COUNT(5e_Spell._pageName)
|fields=COUNT(5e_Spell._pageName)
}} {{5ep|Warlock}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
}} {{SRD5|Warlock}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial).
<div style="overflow:auto; width:98%; font-size:0.8em;">
<div style="overflow:auto; width:100%; max-height:80vh; font-size:0.75rem;">
{|class="zebra small sortable"
!Name
!Level
!School
!Casting<br />Time
!Range
!Components
!Casters
!Source<br />Notes
!Sources
|-
{{#cargo_query:
{{#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
|where=((5e_Spell.Casters HOLDS 'Warlock') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=5e_Spell.Casters HOLDS 'Warlock' AND ((Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (Pages_Info.Deprecated=0 OR Pages_Info.Deprecated 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=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
|order by=5e_Spell.Sort_Text
|limit=100
|limit=1000
|format=table
|format=template
|template=5e Spell Table Row
|more results text=More Spells
|more results text=More Spells
}}</div>
}}
|}</div>
</div><!--gi-main-->
</div><!--gi-main-->
<div class="source">
<div class="source">
==Sources and Notes==
==Sources and Notes==
* ''See individual spells for sources.''
* ''See individual spells for sources.''
Line 164: Line 185:
[[Category:5e Warlocks|Spells Warlocks 5e]]
[[Category:5e Warlocks|Spells Warlocks 5e]]
[[Category:5e Spells|Warlock Spells 5e]]
[[Category:5e Spells|Warlock Spells 5e]]
</noinclude>

Latest revision as of 13:09, 1 January 2021

< Warlock

D&D 5e (2014) Varied ʰ 
See sections for licenses


Warlock Spells

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

spells for the Warlock 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`= 'Warlock') ) 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`= 'Warlock') ) 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`= 'Warlock') ) 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`= 'Warlock') ) 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`= 'Warlock') ) 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

5th Level 6th Level 7th Level 8th Level 9th 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`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) 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`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) 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`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) 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`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) 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`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Warlock') ) 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 `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,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`= 'Warlock') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Spell`.`_pageID`,COUNT(`rly2_cargo__5e_Spell`.`_pageName`) LIMIT 100

Warlock 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

  • See individual spells for sources.
Back to Main Page → DnD → 5x → 5e (2014) → Class → Warlock
  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:Warlock/Spell_List&oldid=10061"