312
edits
(added mental shield link) |
(Tentative fix for duplicate entries in "Possible Items") |
||
Line 51: | Line 51: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl = 'MeleeWeapons' | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| format = table | | format = table | ||
Line 63: | Line 63: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl = 'MeleeWeapons' | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| format = table | | format = table | ||
Line 75: | Line 75: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl = 'MeleeWeapons' | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| format = table | | format = table | ||
Line 87: | Line 87: | ||
| fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | | fields = CONCAT('{{(}}favilink id{{!}}', M.ObjectID, '{{!}}prefix:&bp&Bs&Ci&co&bn&Bi&Cc{{)}}') = Item, | ||
CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END = Tier | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl = 'MeleeWeapons' | ||
| order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | | order by = CASE WHEN COALESCE(GD.Tier,1) < 1 THEN 1 ELSE COALESCE(GD.Tier,1) END DESC,GD.PlainName | ||
| format = table | | format = table |
edits