Difference between revisions of "Template:WeaponsTable Training"
Tag: Reverted |
|||
| Line 13: | Line 13: | ||
{{#cargo_query:tables=Feats_Weapon_Training=Feat,Equipment_Items=Items,Equipment_Weapons=TblWeapons | {{#cargo_query:tables=Feats_Weapon_Training=Feat,Equipment_Items=Items,Equipment_Weapons=TblWeapons | ||
|join on=Feat.Weapons HOLDS TblWeapons._pageName, Feat.Weapons HOLDS Items._pageName | |join on=Feat.Weapons HOLDS TblWeapons._pageName, Feat.Weapons HOLDS Items._pageName | ||
|where=Feat.Name | |where=Feat.Name "{{{1}}}" | ||
|order by=Items.Name | |order by=Items.Name | ||
|fields=CONCAT( '[[', TblWeapons._pageName, '|', Items.Name, ']]' ) = Name,Cost,Damage,Critical,RangeInc = Range,Weight,DamageType=Type,Special | |fields=CONCAT( '[[', TblWeapons._pageName, '|', Items.Name, ']]' ) = Name,Cost,Damage,Critical,RangeInc = Range,Weight,DamageType=Type,Special | ||
|format=table | |format=table | ||
}}</includeonly> | }}</includeonly> | ||
Revision as of 13:07, 26 August 2021
Parameter
1. weapon training feat that grants proficiency in the weapons
Example: {{WeaponsTable Training|Archery Training}}
Archery Training Weapons
Function: CargoSQLQuery::run Query: SELECT CONCAT( '', `Items`.`Name`, '' ) AS `Name`,`Cost` AS `Cost`,`Damage` AS `Damage`,`Critical` AS `Critical`,`RangeInc` AS `Range`,`Weight` AS `Weight`,`DamageType` AS `Type`,`Special` AS `Special` FROM `cargo__Feats_Weapon_Training` `Feat` LEFT OUTER JOIN `cargo__Feats_Weapon_Training__Weapons` `Feat__Weapons` ON ((`Feat`.`_ID`=`Feat__Weapons`.`_rowID`)) RIGHT OUTER JOIN `cargo__Equipment_Items` `Items` ON ((`Feat__Weapons`.`_value`=`Items`.`_pageName`)) RIGHT OUTER JOIN `cargo__Equipment_Weapons` `TblWeapons` ON ((`Feat__Weapons`.`_value`=`TblWeapons`.`_pageName`)) WHERE `Feat`.`Name` "Archery Training" ORDER BY `Items`.`Name` LIMIT 100