8,290
edits
mNo edit summary |
(Add accuracy to query tables) |
||
Line 91: | Line 91: | ||
{{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | {{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | ||
| join on=MWD.JoinKey=IT.JoinKey | | join on=MWD.JoinKey=IT.JoinKey | ||
| fields=CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon,CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV,CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | |||
CONCAT('{{(}}#switch: ',MWD.Accuracy,'{{!}}0=Very High{{!}}1{{!}}2{{!}}3{{!}}4=High{{!}}5{{!}}6{{!}}7{{!}}8{{!}}9=Medium{{!}}10{{!}}11{{!}}12{{!}}13{{!}}14{{!}}15{{!}}16{{!}}17{{!}}18{{!}}19{{!}}20{{!}}21{{!}}22{{!}}23{{!}}24=Low{{!}}Very Low{{)}} (',MWD.Accuracy,')')=Accuracy, | |||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | |||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | |||
| where=IT.Skill='Pistol' AND MWD._pageName NOT LIKE 'Data:%' | | where=IT.Skill='Pistol' AND MWD._pageName NOT LIKE 'Data:%' | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
Line 100: | Line 104: | ||
{{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | {{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | ||
| join on=MWD.JoinKey=IT.JoinKey | | join on=MWD.JoinKey=IT.JoinKey | ||
| fields=CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon,CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV,CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | |||
CONCAT('{{(}}#switch: ',MWD.Accuracy,'{{!}}0=Very High{{!}}1{{!}}2{{!}}3{{!}}4=High{{!}}5{{!}}6{{!}}7{{!}}8{{!}}9=Medium{{!}}10{{!}}11{{!}}12{{!}}13{{!}}14{{!}}15{{!}}16{{!}}17{{!}}18{{!}}19{{!}}20{{!}}21{{!}}22{{!}}23{{!}}24=Low{{!}}Very Low{{)}} (',MWD.Accuracy,')')=Accuracy, | |||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | |||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | |||
| where=IT.Skill='Bow and Rifle' AND MWD.AmmoName = 'arrow' AND MWD._pageName NOT LIKE 'Data:%' | | where=IT.Skill='Bow and Rifle' AND MWD.AmmoName = 'arrow' AND MWD._pageName NOT LIKE 'Data:%' | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
Line 112: | Line 120: | ||
{{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | {{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | ||
| join on=MWD.JoinKey=IT.JoinKey | | join on=MWD.JoinKey=IT.JoinKey | ||
| fields=CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon,CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV,CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | |||
CONCAT('{{(}}#switch: ',MWD.Accuracy,'{{!}}0=Very High{{!}}1{{!}}2{{!}}3{{!}}4=High{{!}}5{{!}}6{{!}}7{{!}}8{{!}}9=Medium{{!}}10{{!}}11{{!}}12{{!}}13{{!}}14{{!}}15{{!}}16{{!}}17{{!}}18{{!}}19{{!}}20{{!}}21{{!}}22{{!}}23{{!}}24=Low{{!}}Very Low{{)}} (',MWD.Accuracy,')')=Accuracy, | |||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | |||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | |||
| where=IT.Skill='Bow and Rifle' AND MWD.AmmoName <> 'arrow' AND MWD._pageName NOT LIKE 'Data:%' | | where=IT.Skill='Bow and Rifle' AND MWD.AmmoName <> 'arrow' AND MWD._pageName NOT LIKE 'Data:%' | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
Line 124: | Line 136: | ||
{{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | {{#cargo_query:tables=ItemsTable=IT,MissileWeaponData=MWD | ||
| join on=MWD.JoinKey=IT.JoinKey | | join on=MWD.JoinKey=IT.JoinKey | ||
| fields=CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon,CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV,CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | |||
CONCAT('{{(}}#switch: ',MWD.Accuracy,'{{!}}0=Very High{{!}}1{{!}}2{{!}}3{{!}}4=High{{!}}5{{!}}6{{!}}7{{!}}8{{!}}9=Medium{{!}}10{{!}}11{{!}}12{{!}}13{{!}}14{{!}}15{{!}}16{{!}}17{{!}}18{{!}}19{{!}}20{{!}}21{{!}}22{{!}}23{{!}}24=Low{{!}}Very Low{{)}} (',MWD.Accuracy,')')=Accuracy, | |||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | |||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | |||
| where=IT.Skill='Heavy Weapon' AND MWD._pageName NOT LIKE 'Data:%' | | where=IT.Skill='Heavy Weapon' AND MWD._pageName NOT LIKE 'Data:%' | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC |