Template:Factions: Difference between revisions

Revision as of 03:50, 7 November 2024

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

@@ Line 2: / Line 2: @@
 {{#cargo_declare:_table=Factions
 | Codename=String
+| Allies=String
 | Enemies=String
 | Leader_1=String
@@ Line 24: / Line 25: @@
 |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 ==