Template:Faction members who perform the water ritual: Difference between revisions
(Created page with "<includeonly>{{#cargo_query: | tables = GeneralData=GD,CreatureFactions=CF,ExtraInfo=EI | join on = GD.ObjectID=CF.ObjectID,GD.ObjectID=EI.ObjectID | fields = CONCA...") |
(ignore skill givers who are not 100 rep with specified faction) |
||
(3 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
<includeonly>{{#cargo_query: | <includeonly>{{#ifeq:{{{3|}}}|yes | ||
|{{#cargo_query: | |||
| 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,CF.Faction=F.PlainName | |||
| 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) AND CF.Value = '100' | |||
| format = ul | |||
| default = {{{2|None}}} | |||
}} | |||
|{{#cargo_query: | |||
| tables = GeneralData=GD,CreatureFactions=CF,ExtraInfo=EI | | tables = GeneralData=GD,CreatureFactions=CF,ExtraInfo=EI | ||
| 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 = None | | default = {{{2|None}}} | ||
}}</includeonly><noinclude> | }}}}</includeonly><noinclude> | ||
A list of faction representatives who can partake in the water ritual. | A list of faction representatives who can partake in the water ritual. | ||
{| class="wikitable" | |||
! Parameter | |||
! Type | |||
! Description | |||
|- | |||
| 1 | |||
| required | |||
| The faction name ''(matches to cargo columns CreatureFactions.Faction or Factions.PlainName)'' | |||
|- | |||
| 2 | |||
| optional | |||
| Text to show if no results are found. By default, this is "None" | |||
|- | |||
| 3 | |||
| optional | |||
| Set to "yes" to limit the results to only those NPCs who teach their faction's main skill. NPCs who do not teach a skill or who teach a different skill than their faction will not be included. | |||
|} | |||
== 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> |
Latest revision as of 23:49, 26 July 2022
A list of faction representatives who can partake in the water ritual.
Parameter | Type | Description |
---|---|---|
1 | required | The faction name (matches to cargo columns CreatureFactions.Faction or Factions.PlainName) |
2 | optional | Text to show if no results are found. By default, this is "None" |
3 | optional | Set to "yes" to limit the results to only those NPCs who teach their faction's main skill. NPCs who do not teach a skill or who teach a different skill than their faction will not be included. |
Example
{{faction members who perform the water ritual|fellowship of wardens|3=yes}}