Template:5e Monster List: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
< | <includeonly><div style="display:block; overflow:auto; max-width:78vw;">{{#cargo_query: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName |
Revision as of 07:24, 11 May 2020
Syntax
{{5e Monster List|type|subtype}}
Normally type is not used and only one subtype is specified.
Add'l Fields
|5eh= <!--blank, true if 5eh. Used by Admin only-->
Example
{{5e Monster List|Gnoll}}
Error 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'
Gnolls
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
Error: No field named "Hidden" found for the database table "Pages_Info".
Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source |
---|