5e:Bard/Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
mNo 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, ']]' ) , 5e_Spell.School, 5e_Spell.Ritual, 5e_Spell.Ritual, Pages_Info.Sources, Pages_Info.User, Pages_Info.Canon, Pages_Info.Pointer, Pages_Info.UA
|fields=5e_Spell._pageName, 5e_Spell.Spell_Name, 5e_Spell.School, Pages_Info.Sources, Pages_Info.User, Pages_Info.Canon, Pages_Info.Pointer, Pages_Info.UA, 5e_Spell.Ritual, 5e_Spell.Ritual
|format=template
|format=template
|template=5e Spell List Row
|template=5e Spell List Row

Revision as of 08:29, 30 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`,`rly2_cargo__5e_Spell`.`_pageName` AS `_pageName`,`rly2_cargo__5e_Spell`.`Spell_Name` AS `Spell Name`,`rly2_cargo__5e_Spell`.`School` AS `School`,`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`,`rly2_cargo__5e_Spell`.`Ritual` AS `Ritual` 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]

Identifier must not contain quote, dot or null characters

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

Identifier must not contain quote, dot or null characters

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

Identifier must not contain quote, dot or null characters

catnap [1]
enemies abound [1]

Identifier must not contain quote, dot or null characters

charm monster [1]

5th Level 6th Level 7th Level 8th Level 9th Level
Identifier must not contain quote, dot or null characters

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

Identifier must not contain quote, dot or null characters
Identifier must not contain quote, dot or null characters
Identifier must not contain quote, dot or null characters
Identifier must not contain quote, dot or null characters

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