Blooncyclopedia

Template:Change list by name: Difference between revisions

← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
60,678 edits
VisualWikitext
m Undo revision 79883 by Polavux (talk)
Tag: Undo
mNo edit summary
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("<h{{{header level|3}}}>[[", changes._pageName, "|Version ", changes.version, "]] ", IF(changes.version_note != "", CONCAT("(", changes.version_note, ")"), ""), "</h{{{header level|3}}}>\n",
"{{{prefix|}}}",
GROUP_CONCAT(changes.changes ORDER BY changes.priority DESC, changes.changes SEPARATOR "\n")) = a
GROUP_CONCAT(changes ORDER BY priority DESC, changes SEPARATOR "\n"),
"{{{suffix|}}}"
) = 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:{{{before|}}}| AND update.version_code < {{#invoke:pad version|main|{{{before}}}}}}}{{#if:{{{since|}}}| AND update.version_code >= {{#invoke:pad version|main|{{{since}}}}}}}
|order by=(version+0)
|order by=update.version_code
|group by=_pageName, version, version_note
|group by=changes._pageName, changes.version, changes.version_note, update.version_code
|join on=changes._pageName = update._pageName


|format=list
|format=list
Retrieved from "https://www.bloonswiki.com/Template:Change_list_by_name"