Template:5e Monster List: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | }} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | ||
<div style="overflow: | </div> | ||
<div style="overflow:auto; font-size:0.8em; max-width:80vw; max-height:80vh;"> | |||
{| | {| | ||
!Monster | !Monster | ||
Revision as of 11:34, 15 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}}
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,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 `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,`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 `rly2_cargo__5eMonster`.`Sort_Text` LIMIT 100
| Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source |
|---|