Psionic: Difference between revisions
Jump to navigation
Jump to search
(Add possible psionic items) |
m (remove items that are excluded from dynamic encounters) |
||
Line 43: | Line 43: | ||
=== Axes === | === Axes === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables = Modability=M,GeneralData=GD,ItemsTable=IT | | tables = Modability=M,GeneralData=GD,ItemsTable=IT,DynamicObjects=DO | ||
| join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey | | join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey,M.ObjectID=DO.ObjectID | ||
| 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' | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl IS NOT NULL | ||
| 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 55: | Line 55: | ||
=== Cudgels === | === Cudgels === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables = Modability=M,GeneralData=GD,ItemsTable=IT | | tables = Modability=M,GeneralData=GD,ItemsTable=IT,DynamicObjects=DO | ||
| join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey | | join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey,M.ObjectID=DO.ObjectID | ||
| 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' | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl IS NOT NULL | ||
| 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 67: | Line 67: | ||
=== Long Blades === | === Long Blades === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables = Modability=M,GeneralData=GD,ItemsTable=IT | | tables = Modability=M,GeneralData=GD,ItemsTable=IT,DynamicObjects=DO | ||
| join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey | | join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey,M.ObjectID=DO.ObjectID | ||
| 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' | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl IS NOT NULL | ||
| 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 79: | Line 79: | ||
=== Short Blades === | === Short Blades === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables = Modability=M,GeneralData=GD,ItemsTable=IT | | tables = Modability=M,GeneralData=GD,ItemsTable=IT,DynamicObjects=DO | ||
| join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey | | join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey,M.ObjectID=DO.ObjectID | ||
| 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' | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl IS NOT NULL | ||
| 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 |