Template:5e Subclass List: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
tables=5e_Subclass, Pages_Info | tables=5e_Subclass, Pages_Info | ||
|join on=5e_Subclass._pageName=Pages_Info._pageName | |join on=5e_Subclass._pageName=Pages_Info._pageName | ||
|where={{#if: {{{showhidden|}}}|5e_Subclass.Class_Name | |where={{#if: {{{showhidden|}}}|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)}} | ||
|fields=COUNT(5e_Subclass._pageName) | |fields=COUNT(5e_Subclass._pageName) | ||
}} subclasses. | }} subclasses. | ||
| Line 16: | Line 16: | ||
tables=5e_Subclass, Pages_Info | tables=5e_Subclass, Pages_Info | ||
|join on=5e_Subclass._pageName=Pages_Info._pageName | |join on=5e_Subclass._pageName=Pages_Info._pageName | ||
|where={{#if: {{{showhidden|}}}|{{#if: {{{showdeprecated|}}}|5e_Subclass.Class_Name | |where={{#if: {{{showhidden|}}}|{{#if: {{{showdeprecated|}}}|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|<!--no deprecated-->5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|}}|<!--no hidden-->{{#if: {{{showdeprecated|}}}|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|<!--no deprecated-->5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND ((Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) AND (Pages_Info.Deprecated=0 OR Pages_Info.Deprecated IS NULL))|}}|}} | ||
<!--|where={{#if: {{{showhidden|}}}|5e_Subclass.Class_Name | <!--|where={{#if: {{{showhidden|}}}|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|5e_Subclass.Class_Name HOLDS '{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)}}--> | ||
|fields=5e_Subclass._pageName,5e_Subclass.Subclass_Name,5e_Subclass.Subclass_Summary,5e_Subclass.Subclass_Features,Pages_Info.Sources,Pages_Info.Licenses,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.User,Pages_Info.UA,Pages_Info.Hidden | |fields=5e_Subclass._pageName,5e_Subclass.Subclass_Name,5e_Subclass.Subclass_Summary,5e_Subclass.Subclass_Features,Pages_Info.Sources,Pages_Info.Licenses,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.User,Pages_Info.UA,Pages_Info.Hidden | ||
|order by=5e_Subclass.Sort_Text | |order by=5e_Subclass.Sort_Text | ||
Revision as of 16:44, 1 September 2021
Use
Generates a table showing the subclasses for a class.
Syntax
{{5e Subclass List|className}}
Add'l Entries
|showhidden=<!-- blank, true will show hidden. Admin only--> |showdeprecated=<!-- blank, true will show deprecated. Admin only-->
Example
{{5e Subclass List|Artificer}}
produces...
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'
subclasses.
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Subclass`.`_pageID` AS `cargo_backlink_page_id_5e_Subclass`,COUNT(`rly2_cargo__5e_Subclass`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Subclass` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Subclass`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE `rly2_cargo__5e_Subclass`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5e_Subclass__Class_Name` WHERE `_value`= 'Artificer') 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_Subclass`.`_pageID`,COUNT(`rly2_cargo__5e_Subclass`.`_pageName`) LIMIT 100
Error: No field named "Hidden" found for the database table "Pages_Info".
| Subclass | Summary | Features | Flags | License | Source |
|---|