Template:5e Creature Adventure List/Format: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<includeonly>{{#if: {{{1}}}|{{#cargo_query: table=5e_Adventures <!--|join on= --> |where=5e_Adventures.Adventure HOLDS "{{Safeapos|{{{1}}}}}" |fields=CONCAT( "", "{{Safeapos|{{{1}}}}}", "" ) <!--|order by= --> |default={{{1}}} |format=ul |limit=1000 <!--|more results text=More creatures--> }}|}}<!--endif 1--></includeonly><noinclude> ==Use== Called by Template:5e Creature Adventure List to have link added. ==Syntax== <pre> {{5e Cre...") |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#if: {{{1}}}|{{#cargo_query: | <includeonly>{{#if: {{{1}}}|''{{#cargo_query: | ||
table=5e_Adventures | table=5e_Adventures | ||
<!--|join on= --> | <!--|join on= --> | ||
| Line 9: | Line 9: | ||
|limit=1000 | |limit=1000 | ||
<!--|more results text=More creatures--> | <!--|more results text=More creatures--> | ||
}}|}}<!--endif 1--></includeonly><noinclude> | }}''|}}<!--endif 1--></includeonly><noinclude> | ||
==Use== | ==Use== | ||
Called by [[Template:5e Creature Adventure List]] to have link added. | Called by [[Template:5e Creature Adventure List]] to have link added. | ||
Latest revision as of 16:08, 22 April 2024
Use
Called by Template:5e Creature Adventure List to have link added.
Syntax
{{5e Creature Adventure List/Format|adventure name}}
Example
{{5e Creature Adventure List/Format|Tammeraut's Fate}}
produces...
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS "Tammeraut's Fate" ORDER BY `rly2_cargo__5e_Adventures`.`_pageID`,CONCAT(' at line 1
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__5e_Adventures`.`_pageID` AS `cargo_backlink_page_id_5e_Adventures`,CONCAT( "", "Tammeraut's Fate", "" ) AS `_pageName, "|", "Tammeraut's Fate", "]]" )` FROM `rly2_cargo__5e_Adventures` WHERE `rly2_cargo__5e_Adventures`.`Adventure` HOLDS "Tammeraut's Fate" ORDER BY `rly2_cargo__5e_Adventures`.`_pageID`,CONCAT( "", "Tammeraut's Fate", "" ) LIMIT 100