Template:5e Monster Data: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
|join on=5eMonster.Page_Name=Pages_Info.Page_Name | |join on=5eMonster.Page_Name=Pages_Info.Page_Name | ||
|where=5eMonster.Monster_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' | |where=5eMonster.Monster_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' | ||
|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.Challenge_Rating=CR,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, 5eMonster.Canon,5eMonster.Pointer,5eMonster.Hidden,5eMonster.UA,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.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, 5eMonster.Canon,5eMonster.Pointer,5eMonster.Hidden,5eMonster.UA,Pages_Info.Sources | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
|limit=100 | |limit=100 | ||
Revision as of 13:59, 3 March 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 `rly2_cargo__5e_Features`.`_pageID` AS `cargo_backlink_page_id_5e_Features`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,`Features__full` AS `Features` FROM `rly2_cargo__5eMonster` LEFT OUTER JOIN `rly2_cargo__5e_Features` ON ((`rly2_cargo__5eMonster`.`Page_Name`=`rly2_cargo__5e_Features`.`Page_Name`)) WHERE `rly2_cargo__5eMonster`.`Monster_Name`='5e Monster Data' ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,`rly2_cargo__5e_Features`.`Features__full` LIMIT 100
Monster data:
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__5e_Features`.`_pageID` AS `cargo_backlink_page_id_5e_Features`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,`Features__full` AS `Features` FROM `rly2_cargo__5eMonster` LEFT OUTER JOIN `rly2_cargo__5e_Features` ON ((`rly2_cargo__5eMonster`.`Page_Name`=`rly2_cargo__5e_Features`.`Page_Name`)) WHERE `rly2_cargo__5eMonster`.`Monster_Name`='Hydra' ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,`rly2_cargo__5e_Features`.`Features__full` LIMIT 100