Template:BTDB2 change list by name

Revision as of 19:41, 17 November 2024 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 the Cargo query. If specified, changes containing both the names will be displayed in the query.

Example
Round
Stringoptional
Header levelheader level

The level of section headers to use for the list.

Default
3
Example
4
Numberoptional

Example usage

{{BTDB2 change list by name|Bot Factory}}
Error 1054: Unknown column 'quote' in 'field list'

Function: CargoSQLQuery::run Query: SELECT `btdb2_changes`.`_pageID` AS `cargo_backlink_page_id_btdb2_changes`,CONCAT("<h3>Version ", version, " ", COALESCE(CONCAT("(", version_note, ")"), ""), "</h3>\n", COALESCE(CONCAT("{", "{quote", "|", quote, "|Update notes}", "}\n"), ""), changes) AS `CONCAT( <h3>Version , version, , COALESCE(CONCAT( ( , version note, ) ), ), </h3>\n , COALESCE(CONCAT( { , {quote , | , quote, |Update notes} , }\n ), ), changes)` FROM `cargo__btdb2_changes` `btdb2_changes` WHERE `btdb2_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__btdb2_changes__names` WHERE `_value`= "Bot Factory") ORDER BY `version` LIMIT 100