Template:BTDB2 change list by name: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes | <includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes | ||
|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n", | |fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n", | ||
GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT(" | 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'>“</td><td class='quote-center'><i>", quote, "</i><br><span style='font-size:0.9em;padding-left:10px'>— Update notes</span></td><td class='quote-side' style='text-align:left'>”</tr></table>\n"), ""), IF(changes != "", CONCAT("\n", changes), "")) ORDER BY priority DESC, changes SEPARATOR "")) = a | ||
|where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}} | |where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}} | ||