Template:Change list by name: Difference between revisions

(13 intermediate revisions by the same user not shown)

Line 1:

<includeonly>{{#cargo_query:~~table~~={{{table|???}}}

<includeonly>{{#cargo_query:tables={{{table|???}}}=changes, {{{updates table|btdbm_updates}}}=update

|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n",

|fields=CONCAT("{{#ifeq:{{{header level|3}}}|2|==|<h{{{header level|3}}}>}}[[", changes._pageName, "|Version ", changes.version, "]] ", IF(changes.version_note != "", CONCAT("(", changes.version_note, ")"), ""), "{{#ifeq:{{{header level|3}}}|2|==|</h{{{header level|3}}}>}}\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'>“</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

GROUP_CONCAT(changes.changes ORDER BY changes.priority DESC, changes.changes SEPARATOR "\n")) = a

|where=(names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}){{#if:{{{before|}}}| AND version < {{{before}}}}}{{#if:{{{since|}}}| AND ~~version~~ >= {{{since}}}}}

|where=(changes.names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR changes.names HOLDS "{{{2|}}}"}}{{#if:{{{3|}}}| OR changes.names HOLDS "{{{3|}}}"}})<!--

|order by=(version~~+0)~~

-->{{#if:{{{before|}}}|AND update.version_code < (0+{{#invoke:pad version|main|{{{before}}}}})}}<!--

|group by=_pageName, version, version_note

-->{{#if:{{{since|}}}|AND update.version_code >= (0+{{#invoke:pad version|main|{{{since}}}}})}}

|order by=update.version_code, changes.version

|group by=changes._pageName, changes.version, changes.version_note, update.version_code

|join on=changes._pageName = update._pageName

|format=list

@@ Line 1: / Line 1: @@
-<includeonly>{{#cargo_query:table={{{table|???}}}
+<includeonly>{{#cargo_query:tables={{{table|???}}}=changes, {{{updates table|btdbm_updates}}}=update
-|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n",
+|fields=CONCAT("{{#ifeq:{{{header level|3}}}|2|==|<h{{{header level|3}}}>}}[[", changes._pageName, "|Version ", changes.version, "]] ", IF(changes.version_note != "", CONCAT("(", changes.version_note, ")"), ""), "{{#ifeq:{{{header level|3}}}|2|==|</h{{{header level|3}}}>}}\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 "")) = a
+GROUP_CONCAT(changes.changes ORDER BY changes.priority DESC, changes.changes SEPARATOR "\n")) = a
-|where=(names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}){{#if:{{{before|}}}| AND version < {{{before}}}}}{{#if:{{{since|}}}| AND version >= {{{since}}}}}
+|where=(changes.names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR changes.names HOLDS "{{{2|}}}"}}{{#if:{{{3|}}}| OR changes.names HOLDS "{{{3|}}}"}})<!--
-|order by=(version+0)
+-->{{#if:{{{before|}}}|AND update.version_code < (0+{{#invoke:pad version|main|{{{before}}}}})}}<!--
-|group by=_pageName, version, version_note
+-->{{#if:{{{since|}}}|AND update.version_code >= (0+{{#invoke:pad version|main|{{{since}}}}})}}
+|order by=update.version_code, changes.version
+|group by=changes._pageName, changes.version, changes.version_note, update.version_code
+|join on=changes._pageName = update._pageName
 |format=list