Template:5e Monster List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
<noinclude></noinclude><includeonly>{{#cargo_query:
<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'

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 "Hidden" found for the database table "Pages_Info".
Monster Size Type Tags Alignment HP CR Marked Source