Psionic: Difference between revisions

Jump to navigation Jump to search

Psionic (view source)

Revision as of 08:43, 20 March 2022

20 bytes added ,  08:43, 20 March 2022
Tentative fix for duplicate entries in "Possible Items"
(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 IS NOT NULL
   | 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 IS NOT NULL
   | 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 IS NOT NULL
   | 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 IS NOT NULL
   | 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
Cadex
312

edits

Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/72730"

Navigation menu