Template:5e Subrace List: Difference between revisions

Revision as of 07:51, 26 May 2022

{{5e Subrace List|race}}}

|5eh= <!--blank or true, admin only-->
|showrace= <!--blank or true-->

{{5e Subrace List|Halfling}}

produces...

5 official and unofficial races.

Error: No field named "Hidden" found for the database table "Pages_Info".

Subrace	Abilities	Size Change	Speed Change	Darkvision (if change)	Features	Source Notes	Source

@@ Line 3: / Line 3: @@
 table=5e_Subrace, Pages_Info
 |join on=5e_Subrace._pageName=Pages_Info._pageName
-|where=5e_Subrace.Race="{{{1|}}}" AND {{#if: {{{5eh|}}}|(Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|}}
+|where=5e_Subrace.Race="{{{1|}}}"
 |fields=COUNT(5e_Subrace._pageName)
 }} official and unofficial races.<br />
@@ Line 22: / Line 22: @@
 tables=5e_Subrace,Pages_Info
 |join on=5e_Subrace._pageName=Pages_Info._pageName
-|where=5e_Subrace.Race="{{{1|}}}" AND {{#if: {{{5eh|}}}|(Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)|(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|}}
+|where=5e_Subrace.Race="{{{1|}}}"
 |order by=5e_Subrace.Race,5e_Subrace.Sort_Text
 |fields=5e_Subrace._pageName,5e_Subrace.Race,5e_Subrace.Race_NS,5e_Subrace.Subrace,5e_Subrace.Sort_Text,5e_Subrace.Ability_Mods,5e_Subrace.Size,5e_Subrace.Speed,5e_Subrace.Darkvision,5e_Subrace.Features,5e_Subrace.Summary,Pages_Info.Canon,Pages_Info.Hidden,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources
+|named args=yes
 |format=template
 |template={{#if: {{{showrace|}}}|5e Subrace Line Show Race|5e Subrace Line Hide Race|}}