Template:Generic cargo query: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary Tag: Reverted |
||
| Line 3: | Line 3: | ||
|fields= | |fields= | ||
CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", name, "]]") = Icon, | CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", name, "]]") = Icon, | ||
{{#if:{{{no description|}}}|CONCAT("[[", _pageName, "|", name, "]]") = Name|CONCAT("'''[[", _pageName, "|", name, "]]'''<br>", {{{description field|description}}}) = Name / description}}{{#if:{{{extra col 1|}}}|, {{{extra col 1}}}}}{{#if:{{{extra col 2|}}}|, {{{extra col 2}}}}}{{#if:{{{extra col 3|}}}|, {{{extra col 3}}}}}{{#if:{{{extra col 4|}}}|, {{{extra col 4}}}}} | {{#if:{{{no description|}}}|CONCAT("[[", _pageName, "|", name, "]]") = Name|CONCAT("'''[[", _pageName, "|", name, "]]'''<br>", {{{description field|description}}}) = Name / description}}{{#if:{{{extra col 1|}}}|, COALESCE({{{extra col 1}}}, "—")}}{{#if:{{{extra col 2|}}}|, COALESCE({{{extra col 2}}}, "—")}}{{#if:{{{extra col 3|}}}|, COALESCE({{{extra col 3}}}, "—")}}{{#if:{{{extra col 4|}}}|, COALESCE({{{extra col 4}}}, "—")}} | ||
|format=table | |format=table | ||
Revision as of 03:01, 18 January 2025
No description.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Table | table tables | The name of the Cargo table to use.
| String | required |
| Disable descriptions | no description | If set to anything, the "Name / description" column is replaced with a "Name" column and descriptions are not included in the query. | Boolean | optional |
| image size | image size | no description | Unknown | optional |
| extra col 1 | extra col 1 | no description | Unknown | optional |
| extra col 2 | extra col 2 | no description | Unknown | optional |
| extra col 3 | extra col 3 | no description | Unknown | optional |
| extra col 4 | extra col 4 | no description | Unknown | optional |
| extra col 5 | extra col 5 | no description | Unknown | optional |
| extra col 6 | extra col 6 | no description | Unknown | optional |
| extra col 7 | extra col 7 | no description | Unknown | optional |
| extra col 8 | extra col 8 | no description | Unknown | optional |
| col align left | col align left | no description | Unknown | optional |
| image field | image field | no description | Unknown | optional |
| name field | name field | no description | Unknown | optional |
| description field | description field | no description | Unknown | optional |
| where | where | no description | Unknown | optional |
| order by | order by | no description | Unknown | optional |
| group by | group by | no description | Unknown | optional |
| limit | limit | no description | Unknown | optional |
| join on | join on | no description | Unknown | optional |
Example usage
{{generic cargo query
|table=battd_powers
|extra col 1=rarity=Rarity
|extra col 2=quality=Quality
|order by=rarity, name
}}
| Icon | Name / description | COALESCE(rarity=Rarity, — ) | COALESCE(quality=Quality, — ) |
|---|---|---|---|
 |
Bag of Butter Drops a huge bag of butter that stuns all bloons. |
1 | 1 |
 |
Golden Crown Become true royalty and gain extra cash from each pop. |
1 | 1 |
 |
Hot Dog Knights These brave knights will help pop bloons if placed on the track. |
1 | 1 |
 |
Twinkling Eye Potion All characters gain captivating, twinkling eyes that slow bloons near them. |
1 | 1 |
 |
Witch's Donuts Tasty treats that restore lives at the end of each round. |
1 | 1 |
 |
Crystal Copy Use Crystal Magic to temporarily duplicate one of your characters |
1 | 1 |
 |
Dimension Disruptor Destroys all bloons and heals all lives when you lose. |
1 | 1 |
 |
Fire Eyes Flying eyes that deal fire damage. The bloons are no match for their gaze! |
1 | 1 |
 |
Fire Wolves A pack of fire wolves to charge down the bloons. |
1 | 1 |
 |
Nightosphere Amulet Spawns a Nightosphere Cloud to rain down death and damnation on the bloons |
1 | 1 |
 |
Decorpsinator Serum PB's mysterious serum raises a candy zombie to fight alongside you. |
1 | 1 |
 |
Gold Coin A little extra cash goes a long way! |
1 | 1 |
 |
Hugsplosion The power of hugs instantly transforms all bloons up to MOAB into red bloons. |
1 | 1 |
 |
Ice Frog Alarm Attacks and buffs characters when bloons start escaping. |
1 | 1 |
 |
King Worm Hypnotizes and holds bloons near him for your other characters to pop. |
1 | 1 |
 |
Party Time Everyone attacks faster during Party Time! |
1 | 1 |
 |
Rainicorn Magic Control a damaging beam of Rainicorn glitter! |
1 | 1 |
 |
Scented Candles FP's candles give speed boosts to all in range and melt bloons that get close |
1 | 1 |
 |
Wolf Pack A pack of wolves charges up and down the track, popping bloons as they go. |
1 | 1 |
 |
Ancient Sleeping Magi of Lifegiving The ultimate giver of life! Revives you on game over with a cash boost. |
1 | 1 |
 |
Billy's Giant Gem Straight from Billy's treasure pile! Gain extra cash every round. |
1 | 1 |
 |
Billy's Shield Billy's shield protects you from leaking bloons. |
1 | 1 |
 |
Cold Spell The Cold Spell freezes all bloons and damages MOABs |
1 | 1 |
 |
Flame Thrower Melt bloons with ease! More powerful if near Flame Princess. |
1 | 1 |
 |
Mushroom Blast Unleash the mighty Mushroom Bomb. Deadly to bloons but harmful to heroes too! |
1 | 1 |
 |
Prismo's Homemade Artisanal Pickles So tasty they alter reality. Gain extra lives and a chance at a free wish orb! |
1 | 1 |
 |
The Most Perfect Sandwich That Has Ever Existed Gives camo detect, lead popping and extra damage to MOABs. The perfect sandwich! |
1 | 1 |
 |
Apple Pie Treetrunks' famous apple pie is so delicious it adds extra lives. |
1 | 1 |
 |
Heavy Weapons Extra weight means extra damage to bigger bloons. |
1 | 1 |
 |
Marauder The Marauder grabs the strongest bloon he can reach and crushes the life out of it! |
1 | 1 |
 |
Trail Mix Tasty trail mix revitalizes your heroes giving them an attack speed boost |
1 | 1 |