8,290
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 20:48, 23 June 2022
, 20:48, 23 June 2022no edit summary
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#ifeq:{{{3|}}}|yes | <includeonly>{{#ifeq:{{{3|}}}|yes | ||
|{{#cargo_query: | |{{#cargo_query: | ||
| tables = GeneralData=GD,CreatureFactions=CF,ExtraInfo=EI,WaterRitualSkills=WRS | | tables = GeneralData=GD,CreatureFactions=CF,ExtraInfo=EI,WaterRitualSkills=WRS,Factions=F | ||
| join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID,GD.ObjectID=WRS.ObjectID | | 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 | | where = EI.Info LIKE '%Ritualable,,,%' AND CF.Faction='{{{1}}}' AND (WRS.ObjectID IS NULL OR WRS.Skill=F.WaterRitualSkill) | ||
| format = ul | | format = ul | ||
| default = {{{2|None}}} | | default = {{{2|None}}} | ||
| Line 37: | Line 37: | ||
== Example == | == Example == | ||
<code><nowiki>{{faction members who perform the water ritual| | <code><nowiki>{{faction members who perform the water ritual|fellowship of wardens|3=yes}}</nowiki></code> | ||
{{faction members who perform the water ritual| | {{faction members who perform the water ritual|fellowship of wardens|3=yes}} | ||
[[Category:Query Templates]]</noinclude> | [[Category:Query Templates]]</noinclude> | ||