Template:5e Subrace List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
(switched to named args)
Line 3: Line 3:
table=5e_Subrace, Pages_Info
table=5e_Subrace, Pages_Info
|join on=5e_Subrace._pageName=Pages_Info._pageName
|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)
|fields=COUNT(5e_Subrace._pageName)
}} official and unofficial races.<br />
}} official and unofficial races.<br />
Line 22: Line 22:
tables=5e_Subrace,Pages_Info
tables=5e_Subrace,Pages_Info
|join on=5e_Subrace._pageName=Pages_Info._pageName
|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
|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
|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
|format=template
|template={{#if: {{{showrace|}}}|5e Subrace Line Show Race|5e Subrace Line Hide Race|}}
|template={{#if: {{{showrace|}}}|5e Subrace Line Show Race|5e Subrace Line Hide Race|}}

Revision as of 06:51, 26 May 2022

Syntax

{{5e Subrace List|race}}}

Optional Fields

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

Example

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