Template:5e Subclass List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
No 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 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)}}
|where=5e_Subclass.Class_Name HOLDS '{{{1|}}}'
|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 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=5e_Subclass.Class_Name HOLDS '{{{1|}}}'|<!--no deprecated-->5e_Subclass.Class_Name HOLDS '{{{1|}}}'
<!--|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
|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
|format=template
|format=template

Latest revision as of 11:51, 23 May 2023

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
Retrieved from "https://wiki.rlyehable.com/index.php?title=Template:5e_Subclass_List&oldid=18676"