Template:Factions: Difference between revisions

Latest revision as of 00:22, 9 November 2024

This template defines the table "Factions". View table.

@@ Line 1: / Line 1: @@
-<noinclude>
+<noinclude>{{#cargo_declare:_table=Factions
-{{#cargo_declare:_table=Factions
 | Codename=String
+| Allies=String
 | Enemies=String
 | Leader_1=String
@@ Line 8: / Line 8: @@
 | Leader_4=String
 | Leader_5=String
-}}
+}}</noinclude><includeonly>{{#cargo_store:_table=Factions}}== Information ==
-</noinclude>
-<includeonly>
-{{#cargo_store:_table=Factions}}
-== Information ==
 {{{Desc}}}
@@ Line 21: / Line 17: @@
 |join on = Zones.Faction = Factions.Codename
 |where=Factions.Codename='{{{Codename}}}'
+|format=table
+|headers=yes
+}}
+== Bounties ==
+{{#cargo_query:
+|tables=CharacterBounty, Spawners, Factions
+|fields=Spawners._pageName=Name, Factions._pageName=Faction, CharacterBounty.Value
+|where=CharacterBounty.FactionCodename='{{{Codename}}}'
+|join on=Spawners.Codename=CharacterBounty.CharacterCodename, Factions.Codename=Spawners.Faction
+|format=table
+|headers=yes
+}}
+== Allies ==
+{{#cargo_query:
+|tables=Factions
+|fields=_pageName=Faction
+|where=Factions.Codename!='{{{Codename}}}' AND
+      (Factions.Allies LIKE CONCAT('%,', '{{{Codename}}}', ',%') OR
+       Factions.Allies LIKE CONCAT('{{{Codename}}}', ',%') OR
+       Factions.Allies LIKE CONCAT('%,', '{{{Codename}}}') OR
+       Factions.Allies = '{{{Codename}}}')
 |format=table
 |headers=yes
@@ Line 37: / Line 56: @@
 |headers=yes
 }}
 </includeonly>