Template:Generic cargo count: Difference between revisions
Jump to navigation
Jump to search
Created page with "<includeonly>{{#cargo_query:table={{{table}}}|fields=COUNT(*)=text|where={{{where}}}}}</includeonly><noinclude>{{/doc}}</noinclude>" |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query:table={{{ | <includeonly>{{#cargo_query:table={{{1}}}|fields=COUNT(*)=text|where={{{where}}}}}</includeonly><noinclude>{{/doc}}</noinclude> | ||
Revision as of 22:16, 10 October 2025
This template displays the number of rows in a specified cargo table.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Cargo table | 1 | no description
| String | required |
| Where | where | Corresponds to the "where" field in a cargo query. | String | optional |
| Count | count | Overrides the count field.
| String | optional |
Example usage
Bloons Card Storm has {{generic cargo count|bcs_cards}} cards.Bloons Card Storm has
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{{where}}} ORDER BY COUNT(*) LIMIT 100' at line 1
Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `text` FROM `cargo__bcs_cards` `bcs_cards` WHERE {{{where}}} ORDER BY COUNT(*) LIMIT 100
cards.
Rogue Legends has {{generic cargo count|btd6_artifacts|where=type != "Boost"}} Artifacts, or {{generic cargo count|btd6_artifacts|where=type != "Boost"|count=COUNT(description_common)+COUNT(description_rare)+COUNT(description_legendary)}} if different rarities of an Artifact are counted separately.
Rogue Legends has 116 Artifacts, or 116 Artifacts if all rarities of each Artifact are counted separately.