Template:5e Monster List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 7: Line 7:
</div>
</div>
<div style="overflow:auto; font-size:0.8em; max-width:80vw; max-height:80vh;">
<div style="overflow:auto; font-size:0.8em; max-width:80vw; max-height:80vh;">
{|
{|class="zebra sortable"
!Monster
!Monster
!Size
!Size

Revision as of 19:04, 18 November 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'

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 1054: Unknown column 'rly2_cargo__Pages_Info.Hidden' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `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