Template:5e Subclass List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
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|}}}|5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)}}
|where={{#if: {{{showhidden|}}}|{{#if: {{{showdeprecated|}}}|5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|<!--no deprecated-->5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|}}|<!--no hidden-->{{#if: {{{showdeprecated|}}}|5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|<!--no deprecated-->5e_Subclass.Class_Name='{{{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='{{{1|}}}' AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|5e_Subclass.Class_Name='{{{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
Line 29: Line 30:
<pre>{{5e Subclass List|className}}</pre>
<pre>{{5e Subclass List|className}}</pre>
===Add'l Entries===
===Add'l Entries===
<pre>|showhidden=<!-- blank, true will show hidden. Admin only --></pre>
<pre>
|showhidden=<!-- blank, true will show hidden. Admin only-->
|showdeprecated=<!-- blank, true will show deprecated. Admin only-->
</pre>


==Example==
==Example==

Revision as of 17:28, 19 February 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: operator for the virtual field '5e_Subclass.Class_Name' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
subclasses.
Error: No field named "Hidden" found for the database table "Pages_Info".
Subclass Summary Features Flags License Source