Template:5e Subclass List: Difference between revisions

Revision as of 21:46, 11 April 2020

Generates a table showing the subclasses for a class.

{{5e Subclass List|className}}

|showhidden=<!-- blank, true will show hidden. Admin only -->

{{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)

Subclass	Summary	Features	Flags	License	Source
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	format=template	template=5e Subclass Row }}

@@ Line 10: / Line 10: @@
 tables=5e_Subclass, Pages_Info
 |join on=5e_Subclass._pageName=Pages_Info._pageName
-|where={{#if: {{{showhidden|}}}|5e_Subclass.Class_Name='{{{1|}}}'|5e_Subclass.Class_Name='{{{1|}}}' AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden 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
 |order by=5e_Subclass.Sort_Text