Template:5e Monster List: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
|where=(5eMonster.Type="{{#if: {{{1|}}}|{{{1}}}}}" OR 5eMonster.Monster_Tags HOLDS "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}") AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |where=(5eMonster.Type="{{#if: {{{1|}}}|{{{1}}}}}" OR 5eMonster.Monster_Tags HOLDS "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}") AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{ | }} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | ||
<div style="overflow:scroll; font-size:0.9em; max-width:80vw; max-height:80vh;"> | <div style="overflow:scroll; font-size:0.9em; max-width:80vw; max-height:80vh;"> | ||
{| | {| | ||
| Line 26: | Line 26: | ||
|template=5e Monster List Row | |template=5e Monster List Row | ||
|limit=1000 | |limit=1000 | ||
|more results text=More {{#if: {{{2|}}}|{{{2}}}|{{{1}}}}} | |more results text=More {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | ||
}} | }} | ||
|}</div></includeonly><noinclude> | |}</div></includeonly><noinclude> | ||
Revision as of 20:05, 23 March 2020
Syntax
{{5e Monster List|type|subtype}}
Normally type is not used and only one subtype is specified.
Example
{{5e Monster List|Gnoll}}
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT COUNT(`rly2_cargo__5eMonster`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5eMonster` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5eMonster`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE (`rly2_cargo__5eMonster`.`Type`="Gnoll" OR `rly2_cargo__5eMonster`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5eMonster__Monster_Tags` WHERE `_value`= "Gnoll") ) AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
Gnolls
Error: No field named "Canon" found for the database table "5eMonster".
| Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source |
|---|