5e:Eldritch Knight/Spell List: Difference between revisions
(Created page with "''These lists exceed the text of the SRD'' ==Eldritch Knight Spells== ''Spells for the {{5ep|Eldritch Knight}} subclass.'' {|class="zebra small" !Cantrip<br />0 Level !1st Lev...") |
No edit summary |
||
| Line 1: | Line 1: | ||
<noinclude> | |||
''These lists exceed the text of the SRD'' | ''These lists exceed the text of the SRD'' | ||
==Eldritch Knight Spells== | ==Eldritch Knight Spells== | ||
</noinclude> | |||
''Spells for the {{5ep|Eldritch Knight}} subclass.'' | ''Spells for the {{5ep|Eldritch Knight}} subclass.'' | ||
{|class="zebra small" | {|class="zebra small" | ||
| Line 37: | Line 39: | ||
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= | |where=((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Eldritch Knight') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) | ||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' ) | ||
|format=list | |format=list | ||
| Line 67: | Line 69: | ||
|} | |} | ||
<noinclude> | |||
==Sortable Table== | ==Sortable Table== | ||
| Line 76: | Line 78: | ||
|fields=COUNT(5e_Spell._pageName) | |fields=COUNT(5e_Spell._pageName) | ||
}} {{5ep|Eldritch Knight}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial). | }} {{5ep|Eldritch Knight}} {{srd5lc|Spell}}s for 5th ed. (official and unofficial). | ||
<div style="overflow:auto; width: | <div style="overflow:auto; width:95%; font-size:0.8em;"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=5e_Spell, Pages_Info | tables=5e_Spell, Pages_Info | ||
| Line 92: | Line 94: | ||
[[Category:5e Eldritch Knights|Spells Eldritch Knight 5e]] | [[Category:5e Eldritch Knights|Spells Eldritch Knight 5e]] | ||
[[Category:5e Spells|Eldritch Knight Spells 5e]] | [[Category:5e Spells|Eldritch Knight Spells 5e]] | ||
</noinclude> | |||
Revision as of 13:06, 8 October 2020
These lists exceed the text of the SRD
Eldritch Knight Spells
Spells for the Eldritch Knight 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`= 'Eldritch Knight') ) 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`= 'Eldritch Knight') ) 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`= 'Eldritch Knight') ) 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`= 'Eldritch Knight') ) 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`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `_pageName, '|', 5e_Spell.Spell_Name, ']]' )` 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`= 'Eldritch Knight') ) 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
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`= 'Eldritch Knight') ) 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
Eldritch Knight spells for 5th ed. (official and unofficial).
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`= 'Eldritch Knight') ) 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
Back to Main Page → DnD → 5x → 5e (2014) → SRD5 → Spells → Eldritch Knight
Back to Main Page → DnD → 5x → 5e (2014) → Spell