Template:5e Monster Data: Difference between revisions
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
|default=Not Found | |default=Not Found | ||
}} | }} | ||
{{#cargo_query: | |||
tables=5e_Features | tables=5e_Features,5eMonster | ||
|where= | |join on=5eMonster.Page_Name=5e_Features.Page_Name | ||
|where=5eMonster.Monster_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' | |||
|fields=5e_Features.Features | |fields=5e_Features.Features | ||
|limit=100 | |limit=100 | ||
| Line 22: | Line 23: | ||
|more results text=More Features | |more results text=More Features | ||
|default=Not Found | |default=Not Found | ||
}} | }}</div></includeonly><noinclude> | ||
===Syntax=== | ===Syntax=== | ||
<pre>{{5e Monster Data|optMonsterName}}</pre> | <pre>{{5e Monster Data|optMonsterName}}</pre> | ||
| Line 30: | Line 31: | ||
{{5e Monster Data}} | {{5e Monster Data}} | ||
{{5e Monster Data| | {{5e Monster Data|Hydra}} | ||
[[Category:5e Templates]] | [[Category:5e Templates]] | ||
</noinclude> | </noinclude> | ||
Revision as of 19:03, 1 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