Template:Factions: Difference between revisions

VisualWikitext

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
 | Leader_2=String
@@ Line 7: / Line 8: @@
 | Leader_4=String
 | Leader_5=String
-}}
+}}</noinclude><includeonly>{{#cargo_store:_table=Factions}}== Information ==
-</noinclude>
+{{{Desc}}}
-<includeonly>
-{{#cargo_store:_table=Factions}}
+== Owned Locations ==
 {{#cargo_query:
 table=Zones, Factions
 |fields=Zones._pageName=Name, Factions._pageName=Faction, Zones.PopCount, Zones.Economy
-|where Zones.Faction = Factions.Codename
 |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
+}}
+== Enemies ==
+{{#cargo_query:
+|tables=Factions
+|fields=_pageName=Faction
+|where=Factions.Codename!='{{{Codename}}}' AND
+      (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>