Template:Naval Gun By ID Query: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<noinclude>This is the 'Naval Gun By ID Query' template. It should be called via the Form:Naval Gun By ID Query form. </noinclude><includeonly> Return a Naval Gun by its ID. Used because some Naval Guns have non-unique names so the only way to ensure a page links to the correct Naval Gun is to use its ID instead. {{#cargo_query: tables=ITEMNavalGun |fields=ITEMNavalGun.TXT_NavalGunName, ITEMNavalGun.TXT_NationName, ITEMNavalGun.TXT_Year, ITEMNavalGun.INT_Performanc...") |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude>This is the 'Naval Gun By ID Query' template. It should be called via the [[Form:Naval Gun By ID Query]] form. | <noinclude>This is the 'Naval Gun By ID Query' template. It should be called via the [[Form:Naval Gun By ID Query]] form. | ||
</noinclude><includeonly> | </noinclude><includeonly> | ||
Return a Naval Gun by its ID. | Return a Naval Gun by its ID. Some Naval Guns have non-unique names so the only way to ensure a page links to the correct Naval Gun is to use its ID instead. | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ITEMNavalGun | tables=ITEMNavalGun | ||
|fields=ITEMNavalGun.TXT_NavalGunName, ITEMNavalGun.TXT_NationName, ITEMNavalGun.TXT_Year, ITEMNavalGun.INT_Performance, ITEMNavalGun.TXT_MountType, ITEMNavalGun.INT_GunCount, ITEMNavalGun.FLT_BoreDiameter, ITEMNavalGun.FLT_RateOfFire, ITEMNavalGun.FLT_BestRateOfFire, ITEMNavalGun.FLT_Fatigue, ITEMNavalGun.FLT_AAAngle, ITEMNavalGun.INT_AARange, ITEMNavalGun.FLT_AAFireControl, ITEMNavalGun.INT_MaxRange, ITEMNavalGun.FLT_FuzeDistance, ITEMNavalGun.FLT_ProjectileWeight, ITEMNavalGun.FLT_DamageNonPen, ITEMNavalGun.FLT_DamagePen, ITEMNavalGun.FLT_DamageAircraft, ITEMNavalGun.FLT_DamageFlak, ITEMNavalGun.FLT_LethalRadius, ITEMNavalGun.FLT_BurstRadius, ITEMNavalGun.FLT_Power, ITEMNavalGun.FLT_MountWeight, ITEMNavalGun.FLT_BestMountWeight, ITEMNavalGun.FLT_RangeDispersion, ITEMNavalGun.FLT_DeflectionDispersion, ITEMNavalGun.FLT_MagWeight, ITEMNavalGun.FLT_BestMagWeight, ITEMNavalGun.FLT_FaceArmor, ITEMNavalGun.FLT_QualityV, ITEMNavalGun.FLT_RoofArmor, ITEMNavalGun.FLT_QualityH | |fields=ITEMNavalGun.TXT_NavalGunName=Name, ITEMNavalGun.TXT_NationName=NationName, ITEMNavalGun.TXT_Year=Year, ITEMNavalGun.INT_Performance=Performance, ITEMNavalGun.TXT_MountType=MountType, ITEMNavalGun.INT_GunCount, ITEMNavalGun.FLT_BoreDiameter=Bore, ITEMNavalGun.FLT_RateOfFire=RoF, ITEMNavalGun.FLT_BestRateOfFire=BestRoF, ITEMNavalGun.FLT_Fatigue=FTG, ITEMNavalGun.FLT_AAAngle=AAA, ITEMNavalGun.INT_AARange=AAR, ITEMNavalGun.FLT_AAFireControl=AAFC, ITEMNavalGun.INT_MaxRange=MaxRange, ITEMNavalGun.FLT_FuzeDistance=Fuze, ITEMNavalGun.FLT_ProjectileWeight=PWeight, ITEMNavalGun.FLT_DamageNonPen=DMGNP, ITEMNavalGun.FLT_DamagePen=DMGP, ITEMNavalGun.FLT_DamageAircraft=DMGA, ITEMNavalGun.FLT_DamageFlak=DMGFLK, ITEMNavalGun.FLT_LethalRadius=Lethal, ITEMNavalGun.FLT_BurstRadius=Burst, ITEMNavalGun.FLT_Power=PWR, ITEMNavalGun.FLT_MountWeight=Weight, ITEMNavalGun.FLT_BestMountWeight=BestWeight, ITEMNavalGun.FLT_RangeDispersion=RD, ITEMNavalGun.FLT_DeflectionDispersion=DD, ITEMNavalGun.FLT_MagWeight=MWGHT, ITEMNavalGun.FLT_BestMagWeight=BMWGHT, ITEMNavalGun.FLT_FaceArmor=FArm, ITEMNavalGun.FLT_QualityV=VQ, ITEMNavalGun.FLT_RoofArmor=RArm, ITEMNavalGun.FLT_QualityH=HQ | ||
|where=TXT_NavalGunID='{{{NavalGunID|}}}' | |where=TXT_NavalGunID='{{{NavalGunID|}}}' AND (BOOL_Hide='0' OR BOOL_Hide IS NULL) | ||
|format=template | |||
|template=NavalGunDataDisplay | |||
|named args=yes | |||
}} | |||
{{TraitTable|{{#cargo_query: | |||
tables=ITEMNavalGun, ITEMTrait | |||
|fields=ITEMTrait.TXT_Type=TraitType, ITEMTrait.TXT_TraitName=TraitName, ITEMTrait.INT_TraitDifficulty=TraitDifficulty, ITEMTrait.TXT_TraitEffectsList=TraitList | |||
|where=TXT_NavalGunID='{{{NavalGunID|}}}' AND (BOOL_Hide='0' OR BOOL_Hide IS NULL) | |||
|join on=ITEMNavalGun.TXT_TraitsList HOLDS ITEMTrait.TXT_TraitID | |||
|format=template | |||
|template=Template:TraitLine | |||
|named args=yes | |||
}} | |||
}} | }} | ||
</includeonly> | </includeonly> | ||
Latest revision as of 09:04, 20 May 2023
This is the 'Naval Gun By ID Query' template. It should be called via the Form:Naval Gun By ID Query form.