5e:Way of the Divine Path/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
 
Line 9: Line 9:
|-
|-


|valign="top"|<!--5th Level-->
|valign="top"|<!--Cantrips-->
<!--{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[Level::Cantrip]]
{{#cargo_query:
|sep=<br />
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|format=list
}}-->
|delimiter=<br />
''{{SRD5|Guidance}}<br />
|order by=5e_Spell.Sort_Text
{{5ed|Hand of Radiance}}<br />
}}
{{SRD5|Light (spell)|Light}}<br />
{{SRD5|Mending}}<br />
{{SRD5|Resistance (spell)|Resistance}}<br />
{{SRD5|Sacred Flame}}<br />
{{SRD5|Spare the Dying}}<br />
{{SRD5|Thaumaturgy}}<br />
{{5ed|Toll the Dead}}<br />
{{5ed|Virtue}}<br />
{{5ed|Word of Radiance}}<br />''


|valign="top"|<!--1st Level-->
|valign="top"|<!--1st Level-->
<!--{{#ask: [[Category:5e Spells]][[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::1]]
{{#cargo_query:
|sep=<br />
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(((5e_Spell.Level=1 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) AND ((5e_Spell.School='Abjuration') OR (5e_Spell.School='Evocation')))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|format=list
}}-->
|delimiter=<br />
''{{5ed|Ceremony}}<br />
|order by=5e_Spell.Sort_Text
{{SRD5|Cure Wounds}}<br />
}}
{{SRD5|Guiding Bolt}}<br />
 
{{SRD5|Healing Word}}<br />
{{SRD5|Protection from Evil and Good}}<br />
{{SRD5|Sanctuary}}<br />
{{SRD5|Shield of Faith}}<br />
''
|valign="top"|<!--2nd Level-->
|valign="top"|<!--2nd Level-->
<!--{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::2]]
{{#cargo_query:
|sep=<br />
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(((5e_Spell.Level=2 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) AND ((5e_Spell.School='Abjuration') OR (5e_Spell.School='Evocation')))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|format=list
}}-->
|delimiter=<br />
''{{SRD5|Aid}}<br />
|order by=5e_Spell.Sort_Text
{{SRD5|Continual Flame}}<br />
}}
{{5ed|Focus Breaker}}<br />
{{SRD5|Prayer of Healing}}<br />
{{SRD5|Protection from Poison}}<br />
{{SRD5|Lesser Restoration}}<br />
{{SRD5|Spiritual Weapon}}<br />
{{SRD5|Warding Bond}}<br />''


|valign="top"|<!--3rd Level-->
|valign="top"|<!--3rd Level-->
<!--{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::3]]
{{#cargo_query:
|sep=<br />
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(((5e_Spell.Level=3 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) AND ((5e_Spell.School='Abjuration') OR (5e_Spell.School='Evocation')))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|format=list
}}-->
|delimiter=<br />
''{{SRD5|Beacon of Hope}}<br />
|order by=5e_Spell.Sort_Text
{{SRD5|Daylight (spell)|Daylight}}<br />
}}  
{{SRD5|Dispel Magic}}<br />
{{5ed|Endure Elements}}<br />
{{SRD5|Glyph of Warding}}<br />  
{{SRD5|Mass Healing Word}}<br />
{{SRD5|Magic Circle}}<br />
{{SRD5|Protection from Energy}}<br />
{{SRD5|Remove Curse}}<br />
{{SRD5|Sending}}<br />'' 


|valign="top"|<!--4th Level-->
|valign="top"|<!--4th Level-->
<!--{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::4]]
{{#cargo_query:
|sep=<br />
table=5e_Spell, Pages_Info
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(((5e_Spell.Level=4 AND 5e_Spell.Casters HOLDS 'Cleric') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)) AND ((5e_Spell.School='Abjuration') OR (5e_Spell.School='Evocation')))
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )
|format=list
|format=list
}}-->
|delimiter=<br />
''{{SRD5|Banishment}}<br />  
|order by=5e_Spell.Sort_Text
{{SRD5|Death Ward}}<br />
}}
{{SRD5|Freedom of Movement}}<br />'' 
 
|}
<!--({{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::+]]|format=count}} official and unofficial spells)
<!--({{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::+]]|format=count}} official and unofficial spells)
{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::+]] OR [[Category:5e Spells]] [[Caster::Cleric]] [[Level::Cantrip]]
{{#ask: [[Category:5e Spells]] [[Caster::Cleric]][[School::Evocation||Abjuration]][[Level::+]] OR [[Category:5e Spells]] [[Caster::Cleric]] [[Level::Cantrip]]

Latest revision as of 08:09, 16 April 2020

< Way of the Divine Path

Way of the Divine Path Spells

Cantrips 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`= 'Cleric') ) 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`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND ((`rly2_cargo__5e_Spell`.`School`='Abjuration') OR (`rly2_cargo__5e_Spell`.`School`='Evocation'))) 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`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND ((`rly2_cargo__5e_Spell`.`School`='Abjuration') OR (`rly2_cargo__5e_Spell`.`School`='Evocation'))) 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`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND ((`rly2_cargo__5e_Spell`.`School`='Abjuration') OR (`rly2_cargo__5e_Spell`.`School`='Evocation'))) 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`= 'Cleric') ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL)) AND ((`rly2_cargo__5e_Spell`.`School`='Abjuration') OR (`rly2_cargo__5e_Spell`.`School`='Evocation'))) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

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