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("{", "{quote", "{{!}}", quote, "{{!}}Update notes}", "}\n"), ""), "\n", changes) ORDER BY priority DESC, changes SEPARATOR "\n")) = a
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 "")) = a


|where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}
|where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}