Template:5e Monster Data: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 7: | Line 7: | ||
tables=5eMonster,Pages_Info | tables=5eMonster,Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where=5eMonster. | |where=5eMonster._pageName='{{FULLPAGENAME}}'<!--{{#if: {{{5eh|}}}|<!--nothing-->| AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|}}--> | ||
|fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources | |fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
Revision as of 11:33, 14 May 2020
Syntax
{{5e Monster Data|optMonsterName}}
Note: For monster names with an apostrophe ('), you must double the apostrophe ('').
Monster data +
Function: CargoSQLQuery::run Query: SELECT `_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`.`_pageName`='Template:5e Monster Data' ORDER BY `_pageName` LIMIT 100
|fields=CONCAT( '', 5eMonster.Monster_Name, '' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources |order by=5eMonster.Sort_Text |limit=10 |format=list |more results text=More Monsters |default=Not Found }}
Monster data +
Function: CargoSQLQuery::run Query: SELECT `_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`.`_pageName`='Template:5e Monster Data' ORDER BY `_pageName` LIMIT 100
|fields=CONCAT( '', 5eMonster.Monster_Name, '' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources |order by=5eMonster.Sort_Text |limit=10 |format=list |more results text=More Monsters |default=Not Found }}