5e:Spell List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(10 intermediate revisions by the same user not shown)
Line 5: Line 5:
<div class="gi-main">
<div class="gi-main">
{{#cargo_query:
{{#cargo_query:
table=5e_Spell
tables=5e_Spell, Pages_Info
|fields=COUNT(_pageName)
|join on=5e_Spell._pageName=Pages_Info._pageName
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|fields=COUNT(5e_Spell._pageName)
}} {{srd5lc|Spell}}s
}} {{srd5lc|Spell}}s
<div style="overflow:auto; width:100%; font-size:0.8em;">
<div style="display:block; overflow:auto; max-width:75vw; max-height:90vh; font-size:0.8em;">
{{#cargo_query:
{{#cargo_query:
tables=5e_Spell,Pages_Info
tables=5e_Spell,Pages_Info
|join on=5e_Spell.Page_Name=Pages_Info.Page_Name
|join on=5e_Spell._pageName=Pages_Info._pageName
|fields=5e_Spell._pageName=Spell_Name,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Canon_Spell=Canon,Pages_Info.Sources
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
|order by=5e_Spell.Sort_Text
|order by=5e_Spell.Sort_Text
|limit=100
|limit=2000
|format=table
|format=table
|more results text=More Spells
|more results text=More Spells
}}</div>
}}</div>
===By School===
{{Special:PrefixIndex/5e:Spell List/|stripprefix=5e:Spell List/}}
</div><!--gi-main-->
</div><!--gi-main-->
<div class="source">
<div class="source">

Latest revision as of 06:44, 17 September 2021

< Spell

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


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__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
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 `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__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100

By School

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