Template:5e Subrace List: Difference between revisions
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: | {{#cargo_query: | ||
tables=5e_Subrace,Pages_Info | tables=5e_Subrace,Pages_Info | ||
Revision as of 13: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'
official and unofficial races.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
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 |
|---|