Template:5e Spell Data: Difference between revisions
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
---- | ---- | ||
'''Spell data:'''<br /> | '''Spell data:'''<br /> | ||
<div style="overflow:auto; width:100%; font-size:0. | <div style="overflow:auto; width:100%; font-size:0.75em;"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=5e_Spell,Pages_Info | tables=5e_Spell,Pages_Info | ||
| Line 20: | Line 20: | ||
{{5e Spell Data|Acid Arrow}} | {{5e Spell Data|Acid Arrow}} | ||
[[Category:5e | [[Category:5e Templates]] | ||
</noinclude> | </noinclude> | ||
Revision as of 06:15, 25 February 2020
Syntax
{{5e Spell Data|optSpellName}}
Spell data:
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `Spell`,`rly2_cargo__5e_Spell`.`Level` AS `Level`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Action_Type` AS `Casting`,`rly2_cargo__5e_Spell`.`Spell_Range` AS `Range`,`Component__full` AS `VSM`,`rly2_cargo__5e_Spell`.`Valuable_Component` AS `VC`,`rly2_cargo__5e_Spell`.`Consumable_Component` AS `CC`,`Casters__full` AS `Casters`,`rly2_cargo__5e_Spell`.`Canon_Spell` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`Page_Name`=`rly2_cargo__Pages_Info`.`Page_Name`)) WHERE `rly2_cargo__5e_Spell`.`Spell_Name`='5e Spell Data' ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100
Spell data:
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Spell`.`_pageID` AS `cargo_backlink_page_id_5e_Spell`,CONCAT( '', `rly2_cargo__5e_Spell`.`Spell_Name`, '' ) AS `Spell`,`rly2_cargo__5e_Spell`.`Level` AS `Level`,`rly2_cargo__5e_Spell`.`School` AS `School`,`rly2_cargo__5e_Spell`.`Action_Type` AS `Casting`,`rly2_cargo__5e_Spell`.`Spell_Range` AS `Range`,`Component__full` AS `VSM`,`rly2_cargo__5e_Spell`.`Valuable_Component` AS `VC`,`rly2_cargo__5e_Spell`.`Consumable_Component` AS `CC`,`Casters__full` AS `Casters`,`rly2_cargo__5e_Spell`.`Canon_Spell` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Spell` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Spell`.`Page_Name`=`rly2_cargo__Pages_Info`.`Page_Name`)) WHERE `rly2_cargo__5e_Spell`.`Spell_Name`='Acid Arrow' ORDER BY `rly2_cargo__5e_Spell`.`Sort_Text` LIMIT 100