Blooncyclopedia

Template:BTDB2 change list by name: Difference between revisions

← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
63,191 edits
VisualWikitext
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes
<includeonly>{{#if:{{{hide header|}}}||{{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("\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(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|}}}"}}){{#if:{{{before|}}}| AND version < {{{before}}}}}{{#if:{{{since|}}}| AND version >= {{{since}}}}}
|order by=(version+0)
|order by=(version+0)
|group by=_pageName, version, version_note
|group by=_pageName, version, version_note
Line 9: Line 9:
|format=list
|format=list
|delimiter=\n
|delimiter=\n
|default=No changes found.
|default=
}}</includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTDB2_change_list_by_name"