5e:Bard/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 24: Line 24:
|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 'Bard') AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL))
|where=((5e_Spell.Level=0 AND 5e_Spell.Casters HOLDS 'Bard') 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, ']]' ) , 5e_Spell.School, 5e_Spell.Ritual, 5e_Spell.Ritual, Pages_Info.Sources, Pages_Info.User, Pages_Info.Canon, Pages_Info.Pointer, Pages_Info.UA
|format=list
|format=template
|delimiter=<br />
|template=5e Spell List Row
<!--|format=list
|delimiter=<br />-->
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
}}
}}
Line 168: Line 170:
<references>
<references>
<ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref>
<ref name="xan">{{Cite Pub|Xanathar's Guide to Everything}}</ref>
</references>
===Unearthed Arcana===
''Unearthed Arcana spells are at the GM's discression''
<references group="ua">
<ref group="ua" name="starter">{{Cite Pub|UA Starter Spells}}</ref>
</references>
===User Creations===
<references group="uc">
<ref group="uc" name="rly">[[User:Rlyehable]]</ref>
</references>
</references>
===Notes===
===Notes===
:<sup>[r]</sup> These spells may be cast as {{srd5lc|Ritual}}s.
===Spell Notes===
{{anchor|a}} = {{SRD5|Abjuration}}<br />
{{anchor|c}} = {{SRD5|Conjuration}}<br />
{{anchor|d}} = {{SRD5|Divination}}<br />
{{anchor|en}} = {{SRD5|Enchantment}}<br />
{{anchor|ev}} = {{SRD5|Evocation}}<br />
{{anchor|i}} = {{SRD5|Illusion}}<br />
{{anchor|n}} = {{SRD5|Necromancy}}<br />
{{anchor|t}} = {{SRD5|Transmutation}}<br />
{{anchor|o}} = Other school<br />
<br />
{{anchor|cn}} = {{SRD5|Concentration}}<br />
{{anchor|r}} = {{SRD5|Ritual}}<br />
<br />
{{anchor|can}} = Canon<br />
{{anchor|p}} = Pointer<br />
{{anchor|ua}} = Unearthed Arcana<br />
{{anchor|uc}} = User Creation
</div><!--source-->
</div><!--source-->
</div><!--grid-container-std-->
</div><!--grid-container-std-->
</noinclude>
</noinclude>

Revision as of 14:38, 29 April 2020

D&D 5e Varied ʰ 
See sections for licenses


Bard 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`= 'Bard') ) 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 Bard class.
Cantrips
(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, ']]' )`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Ritual` AS `Ritual`,`Sources__full` AS `Sources`,`rly2_cargo__Pages_Info`.`User` AS `User`,`rly2_cargo__Pages_Info`.`Canon` AS `Canon`,`rly2_cargo__Pages_Info`.`Pointer` AS `Pointer`,`rly2_cargo__Pages_Info`.`UA` AS `UA` 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`= 'Bard') ) 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


thunderclap [1]

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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`= 'Bard') ) 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


guiding hand [ua 1] [r]
puppet [ua 1]
sense emotion [ua 1]
sudden awakening [ua 1]
unearthly chorus [ua 1]

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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`= 'Bard') ) 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


pyrotechnics [1]
skywrite [1] [r]
warding wind [1]

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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`= 'Bard') ) 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


catnap [1]
enemies abound [1]

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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`= 'Bard') ) 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


charm monster [1]

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 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`=5 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) 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


earth tremor [1]
skill empowerment [1]
synaptic static [1]

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT 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`=6 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) 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 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`=7 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) 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 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`=8 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) 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 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`=9 AND `rly2_cargo__5e_Spell`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Spell__Casters` WHERE `_value`= 'Bard') ) 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


mass polymorph [1]
psychic scream [1]

Sources

Notes

Spell Notes

a = Abjuration
c = Conjuration
d = Divination
en = Enchantment
ev = Evocation
i = Illusion
n = Necromancy
t = Transmutation
o = Other school

cn = Concentration
r = Ritual

can = Canon
p = Pointer
ua = Unearthed Arcana
uc = User Creation


Cite error: <ref> tags exist for a group named "ua", but no corresponding <references group="ua"/> tag was found