8,756
edits
Template:Faction members who perform the water ritual: Difference between revisions
Template:Faction members who perform the water ritual (view source)
Revision as of 23:49, 26 July 2022
, 23:49, 26 July 2022ignore skill givers who are not 100 rep with specified faction
No edit summary |
(ignore skill givers who are not 100 rep with specified faction) |
||
| Line 4: | Line 4: | ||
| join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID,GD.ObjectID=WRS.ObjectID,CF.Faction=F.PlainName | | join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID,GD.ObjectID=WRS.ObjectID,CF.Faction=F.PlainName | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Character | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Character | ||
| where = EI.Info LIKE '%Ritualable,,,%' AND CF.Faction='{{{1}}}' AND (WRS.ObjectID IS NULL OR WRS.Skill=F.WaterRitualSkill) | | where = EI.Info LIKE '%Ritualable,,,%' AND CF.Faction='{{{1}}}' AND (WRS.ObjectID IS NULL OR WRS.Skill=F.WaterRitualSkill) AND CF.Value = '100' | ||
| format = ul | | format = ul | ||
| default = {{{2|None}}} | | default = {{{2|None}}} | ||
| Line 12: | Line 12: | ||
| join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID | | join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Character | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Character | ||
| where = EI.Info LIKE '%Ritualable,,,%' AND CF.Faction='{{{1}}}' | | where = EI.Info LIKE '%Ritualable,,,%' AND CF.Faction='{{{1}}}' AND CF.Value = '100' | ||
| format = ul | | format = ul | ||
| default = {{{2|None}}} | | default = {{{2|None}}} | ||