Template:Naval Gun By ID Query: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
tables=ITEMNavalGun | tables=ITEMNavalGun | ||
|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 | |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 | |format=template | ||
|template=NavalGunDataDisplay | |template=NavalGunDataDisplay | ||
| Line 13: | Line 13: | ||
tables=ITEMNavalGun, ITEMTrait | tables=ITEMNavalGun, ITEMTrait | ||
|fields=ITEMTrait.TXT_Type=TraitType, ITEMTrait.TXT_TraitName=TraitName, ITEMTrait.INT_TraitDifficulty=TraitDifficulty, ITEMTrait.TXT_TraitEffectsList=TraitList | |fields=ITEMTrait.TXT_Type=TraitType, ITEMTrait.TXT_TraitName=TraitName, ITEMTrait.INT_TraitDifficulty=TraitDifficulty, ITEMTrait.TXT_TraitEffectsList=TraitList | ||
|where=TXT_NavalGunID='{{{NavalGunID|}}}' | |where=TXT_NavalGunID='{{{NavalGunID|}}}' AND (BOOL_Hide='0' OR BOOL_Hide IS NULL) | ||
|join on=ITEMNavalGun.TXT_TraitsList HOLDS ITEMTrait.TXT_TraitID | |join on=ITEMNavalGun.TXT_TraitsList HOLDS ITEMTrait.TXT_TraitID | ||
|format=template | |format=template | ||
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.