Template:5e Subrace List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><div style="overflow:auto; max-width:85vw; ">
<includeonly><div style="overflow:auto; max-width:85vw; ">
{{#cargo_query:
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)|}}
|fields=COUNT(5e_Subrace._pageName)
}} official and unofficial races.<br />
{|class="zebra sortable small"
{|class="zebra sortable small"
{{#if: {{{showrace|}}}|!Race|}}
{{#if: {{{showrace|}}}|!Race|}}
Line 12: Line 18:
!Source
!Source
|-
|-
{{#cargo_query:
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)|}}
|fields=COUNT(5e_Subrace._pageName)
}} official and unofficial races.<br />
{{#cargo_query:
{{#cargo_query:
tables=5e_Subrace,Pages_Info
tables=5e_Subrace,Pages_Info

Revision as of 14:34, 12 June 2020

Syntax

{{5e Subrace List|race}}}

Optional Fields

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

Example

{{5e Subrace List|Halfling}}

produces...

Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Subrace`.`_pageID` AS `cargo_backlink_page_id_5e_Subrace`,COUNT(`rly2_cargo__5e_Subrace`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Subrace` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Subrace`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE `rly2_cargo__5e_Subrace`.`Race`="Halfling" AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5e_Subrace`.`_pageID`,COUNT(`rly2_cargo__5e_Subrace`.`_pageName`) LIMIT 100

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