Dervish of the Sightless Way: Difference between revisions
Jump to navigation
Jump to search
(add likely weapons) |
mNo edit summary |
||
Line 97: | Line 97: | ||
==== 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, | ||
CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | ||
CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND GD.Tier = 5 | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseAxe' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 5 | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
| format = table | | format = table | ||
Line 110: | Line 110: | ||
==== 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, | ||
CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | ||
CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND GD.Tier = 5 | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseCudgel' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 5 | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
| format = table | | format = table | ||
Line 123: | Line 123: | ||
====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, | ||
CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | ||
CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND GD.Tier = 5 | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseLongBlade' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 5 | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
| format = table | | format = table | ||
Line 136: | Line 136: | ||
==== 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, | ||
CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | CONCAT('{{(}}PV{{)}}',IT.MaxPV)=PV, | ||
CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | CONCAT('{{(}}Heart{{)}}',IT.Damage)=Damage | ||
| where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND GD.Tier = 5 | | where = M.SupportedMods HOLDS 'WeaponMods' AND GD.ParentObject WITHIN 'BaseDagger' AND DO.DynamicTbl IS NOT NULL AND GD.Tier = 5 | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
| format = table | | format = table |