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...

Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)
subclasses.
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)
Subclass Summary Features Flags License Source