Template:Factions: Difference between revisions

VisualWikitext

Latest revision as of 01: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 27: / Line 46: @@
 == Enemies ==
 {{#cargo_query:
-|tables=Factions AS F1, Factions AS F2
+|tables=Factions
-|fields=F1._pageName=Faction, F2._pageName=EnemyFaction
+|fields=_pageName=Faction
-|join on=1=1
+|where=Factions.Codename!='{{{Codename}}}' AND
-|where=F2.Codename='{{{Codename}}}' AND (F1.Enemies LIKE CONCAT('%,', F2.Codename, ',%') OR F1.Enemies LIKE CONCAT(F2.Codename, ',%') OR F1.Enemies LIKE CONCAT('%,', F2.Codename) OR F1.Enemies = F2.Codename)
+      (Factions.Enemies LIKE CONCAT('%,', '{{{Codename}}}', ',%') OR
+       Factions.Enemies LIKE CONCAT('{{{Codename}}}', ',%') OR
+       Factions.Enemies LIKE CONCAT('%,', '{{{Codename}}}') OR
+       Factions.Enemies = '{{{Codename}}}')
 |format=table
 |headers=yes
 }}
 </includeonly>