8,290
edits
(Add accuracy to query tables) |
m (number first (to allow sorting)) |
||
Line 93: | Line 93: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | 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{{)}} | CONCAT(MWD.Accuracy,' ({{(}}#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{{)}})')=Accuracy, | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | 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 | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
Line 106: | Line 106: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | 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{{)}} | CONCAT(MWD.Accuracy,' ({{(}}#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{{)}})')=Accuracy, | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | 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 | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
Line 122: | Line 122: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | 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{{)}} | CONCAT(MWD.Accuracy,' ({{(}}#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{{)}})')=Accuracy, | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | 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 | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
Line 138: | Line 138: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon, | 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{{)}} | CONCAT(MWD.Accuracy,' ({{(}}#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{{)}})')=Accuracy, | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | 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 | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage |