Template:BTD6 change list by name

Revision as of 19:08, 2 May 2025 by Polavux (talk | contribs)

Uses Cargo to generate a list of changes that apply to a specific key.

Template parameters[Edit template data]

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
Name1

The key to use for the Cargo query. Will display a list of changes that contain this key in the "names" column with matching capitalization and spacing.

Example
Bloon send
Stringrequired
Name 22

A second key to use for querying. The results of both names will be shown in the list.

Stringoptional
Header levelheader level

The level of section headers to use for the list.

Default
3
Example
4
Numberoptional
Beforebefore

Only shows changes from versions up to, but *not* including, this version number.

Example
18.0
Numberoptional
sincesince

Only shows changes from versions after, *and* including, this version number.

Example
18.0
Numberoptional

Example usage

{{BTD6 change list by name|Quincy}}
Icon of "the greatest challenge" This article or section uses Cargo to generate its content. It will automatically fill up as other articles are completed.
To add to this section, create the articles it is looking up. Do not add content to this section manually and do not remove this notice until you are sure this section is complete.
Error 1054: Unknown column 'quote' in 'field list'

Function: CargoSQLQuery::run Query: SELECT CONCAT("<h3>Version ", version, " ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h3>\n", GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT("\n<table class='quote' border='0' cellspacing='0' cellpadding='0'><tr><td class='quote-side' style='text-align:right'>&ldquo;</td><td class='quote-center'><i>", quote, "</i><br><span style='font-size:0.9em;padding-left:10px'>&mdash; Update notes</span></td><td class='quote-side' style='text-align:left'>&rdquo;</tr></table>\n"), ""), IF(changes != "", CONCAT("\n", changes), "")) ORDER BY priority DESC, changes SEPARATOR "")) AS `a` FROM `cargo__btd6_changes` `btd6_changes` WHERE (`btd6_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__btd6_changes__names` WHERE `_value`= "Quincy") ) GROUP BY _pageName, version, version_note ORDER BY (version+0) LIMIT 100