Template:GetCharUnites: Difference between revisions

Revision as of 16:53, 26 March 2025

Error 1054: Unknown column 'cargo__Unites._pageID' in 'SELECT'

Function: CargoSQLQuery::run Query: SELECT `cargo__Unites`.`_pageID` AS `cargo_backlink_page_id_Unites`,`name` AS `name`,`participants` AS `participants`,`target` AS `target`,`damage` AS `damage`,`effect` AS `effect`,`timer` AS `timer`,`game` AS `game` FROM `cargo__Unites` `Unites` WHERE participants like '%%' ORDER BY `cargo__Unites`.`_pageID`,`name`,`participants`,`target`,`damage` LIMIT 100

@@ Line 1: / Line 1: @@
-{| class="wikitable"
+{{#cargo_query:
-|+ Good Will
+table=
-|-
+  Unites
-! class="wikitable-title" | Action !! class="wikitable-title" | Members
+|fields =
-|-
+  name, participants, target, damage, effect, timer, game
-| style="width: 34%; background: #7fbbdf; color: #000" | Attack Name ||
+|where=participants like '%{{{name|}}}%'
-<includeonly>
+|format=template
-<!-- Member 1 -->
+|limit=240
-{{#if:{{#explode:{{{Members|}}}|,|0}}|
+|template=Unite_TableRow2
-  {{#tag:charactericon|{{#explode:{{{Members|}}}|,|0}}|S1|HDR}}
+|intro={{Unite TableHeader|name={{{name|}}}}}
+|outro={{CloseTable}}
+|more results text=
+|named args=yes
 }}
+<noinclude>[[Category:Cargo query templates]]</noinclude>
-<!-- Member 2 -->
-{{#if:{{#explode:{{{Members|}}}|,|1}}|
-  {{#tag:charactericon|{{#explode:{{{Members|}}}|,|1}}|S1|HDR}}
-}}
-<!-- Member 3 -->
-{{#if:{{#explode:{{{Members|}}}|,|2}}|
-  {{#tag:charactericon|{{#explode:{{{Members|}}}|,|2}}|S1|HDR}}
-}}
-<!-- Member 4 -->
-{{#if:{{#explode:{{{Members|}}}|,|3}}|
-  {{#tag:charactericon|{{#explode:{{{Members|}}}|,|3}}|S1|HDR}}
-}}
-<!-- Member 5 -->
-{{#if:{{#explode:{{{Members|}}}|,|4}}|
-  {{#tag:charactericon|{{#explode:{{{Members|}}}|,|4}}|S1|HDR}}
-}}
-</includeonly>
-|}