Template:Infobox tour: Difference between revisions

From SPCodex, The Smashing Pumpkins wiki
No edit summary
No edit summary
Line 2: Line 2:
tables=shows
tables=shows
|fields=MIN(date)
|fields=MIN(date)
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{name|}}}|shows.tour = "{{{name}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
}}}}{{#vardefine:end_date|{{#cargo_query:
}}}}{{#vardefine:end_date|{{#cargo_query:
tables=shows
tables=shows
|fields=MAX(date)
|fields=MAX(date)
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{name|}}}|shows.tour = "{{{name}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
}}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox
}}}}</includeonly><templatestyles src="Template:Infobox tour/styles.css" />{{Infobox
| bodyclass      = vevent
| bodyclass      = vevent
| title          = {{#if:{{{festival|}}}|{{{festival}}}|{{#if:{{{year|}}}|{{#if:{{{artist|}}}|{{{artist}}}}} {{{year}}} tour history|''{{{name}}} {{#if:{{#pos:{{{name}}}|residency}}||{{#if:{{#pos:{{{name}}}|Sessions}}||tour}}}}''}}}}
| title          = {{#if:{{{festival|}}}|{{{festival}}}|{{#if:{{{year|}}}|{{#if:{{{artist|}}}|{{{artist}}}}} {{{year}}} tour history|''{{{tour}}} {{#if:{{#pos:{{{tour}}}|residency}}||{{#if:{{#pos:{{{tour}}}|Sessions}}||tour}}}}''}}}}
| titleclass    = summary
| titleclass    = summary
| subheader      = {{#if:{{{name|}}}|[[Tour history|Tour]] by [[{{{artist|}}}]]}}
| subheader      = {{#if:{{{tour|}}}|[[{{{artist}}} tour history|Tour]] by [[{{{artist|}}}]]}}
| subheaderstyle = font-weight: bold;
| subheaderstyle = font-weight: bold;
| image          = {{#invoke:InfoboxImage|InfoboxImage|image={{{image|{{{poster|}}}}}}|size={{{image_size|}}}|title={{#ifeq:{{{landscape|}}}|yes||upright}}|border={{#if:{{{border|}}}|yes}}|alt={{{alt|}}}}}
| image          = {{#invoke:InfoboxImage|InfoboxImage|image={{{image|{{{poster|}}}}}}|size={{{image_size|}}}|title={{#ifeq:{{{landscape|}}}|yes||upright}}|border={{#if:{{{border|}}}|yes}}|alt={{{alt|}}}}}
Line 17: Line 17:
| label1        = Co-headliners
| label1        = Co-headliners
| data1          = {{{co-headliner|}}}
| data1          = {{{co-headliner|}}}
| label11        = {{#if:{{{name|}}}|Start|First}} date
| label11        = {{#if:{{{tour|}}}|Start|First}} date
| data11        = {{#var:start_date}}<!--<includeonly>[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>-->
| data11        = {{#var:start_date}}<!--<includeonly>[[{{{artist}}} {{#var:start_date}}|{{#var:start_date}}]]</includeonly>-->
| label12        = {{#if:{{{name|}}}|End|Last}} date
| label12        = {{#if:{{{tour|}}}|End|Last}} date
| data12        = {{#var:end_date}}<!--<includeonly>[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>-->
| data12        = {{#var:end_date}}<!--<includeonly>[[{{{artist}}} {{#var:end_date}}|{{#var:end_date}}]]</includeonly>-->
| label13        = Duration
| label13        = Duration
Line 29: Line 29:
tables=shows
tables=shows
|fields=COUNT(DISTINCT shows._ID)
|fields=COUNT(DISTINCT shows._ID)
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{name|}}}|shows.tour = "{{{name}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
}}</includeonly>
}}</includeonly>
| label16        = No. of cities
| label16        = No. of cities
Line 35: Line 35:
tables=shows
tables=shows
|fields=COUNT(DISTINCT location)
|fields=COUNT(DISTINCT location)
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{name|}}}|shows.tour = "{{{name}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
}}</includeonly>
}}</includeonly>
| label17        = No. of countries
| label17        = No. of countries
Line 41: Line 41:
tables=shows
tables=shows
|fields=COUNT(DISTINCT country)
|fields=COUNT(DISTINCT country)
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{name|}}}|shows.tour = "{{{name}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
|where={{#invoke:String|join| AND |{{#if:{{{artist|}}}|(shows.artist = "{{{artist}}}" OR shows.featuring_artist = "{{{artist}}}")}}|{{#if:{{{tour|}}}|shows.tour = "{{{tour}}}"}}|{{#if:{{{festival|}}}|shows.festival = "{{{festival}}}"}}|{{#if:{{{year|}}}|YEAR(shows.date) = {{{year}}} AND shows.date__precision=1}}}}
}}</includeonly>
}}</includeonly>
| label19        = Supporting artists
| label19        = Supporting artists
Line 52: Line 52:
| data25        = {{#if:{{{prev_tour|}}}{{{next_tour|}}}{{{year|}}}|
| data25        = {{#if:{{{prev_tour|}}}{{{next_tour|}}}{{{year|}}}|
*<li style="display: table-cell; width: 33%;">{{#if:{{{prev_year|}}}|{{#if:{{{prev_tour|}}}|[[{{{prev_tour}}} tour|{{{prev_tour}}}]]<br/>({{{prev_year}}})|([[{{#if:{{{artist|}}}|{{{artist}}}}} {{{prev_year}}} tour history|{{{prev_year}}}]])}}}}
*<li style="display: table-cell; width: 33%;">{{#if:{{{prev_year|}}}|{{#if:{{{prev_tour|}}}|[[{{{prev_tour}}} tour|{{{prev_tour}}}]]<br/>({{{prev_year}}})|([[{{#if:{{{artist|}}}|{{{artist}}}}} {{{prev_year}}} tour history|{{{prev_year}}}]])}}}}
*<li style="display: table-cell; width: 33%;">{{#if:{{{name|}}}|{{{name}}}<br/>}}({{{this_year|{{{year|}}}}}})
*<li style="display: table-cell; width: 33%;">{{#if:{{{tour|}}}|{{{tour}}}<br/>}}({{{this_year|{{{year|}}}}}})
*<li style="display: table-cell; width: 33%;">{{#if:{{{next_year|}}}|{{#if:{{{next_tour|}}}|[[{{{next_tour}}} tour|{{{next_tour}}}]]<br/>({{{next_year}}})|([[{{#if:{{{artist|}}}|{{{artist}}}}} {{{next_year}}} tour history|{{{next_year}}}]])}}}}
*<li style="display: table-cell; width: 33%;">{{#if:{{{next_year|}}}|{{#if:{{{next_tour|}}}|[[{{{next_tour}}} tour|{{{next_tour}}}]]<br/>({{{next_year}}})|([[{{#if:{{{artist|}}}|{{{artist}}}}} {{{next_year}}} tour history|{{{next_year}}}]])}}}}
}}}}__FORCETOC__<noinclude><templatedata>
}}}}__FORCETOC__<noinclude><templatedata>
Line 70: Line 70:
"suggested": true
"suggested": true
},
},
"name": {
"tour": {
"label": "Name of tour",
"label": "Name of tour",
"type": "string",
"type": "string",
Line 134: Line 134:
"paramOrder": [
"paramOrder": [
"artist",
"artist",
"name",
"tour",
"image",
"image",
"caption",
"caption",

Revision as of 01:37, 19 October 2020

{{{tour}}} tour
First date{{#var:start_date}}
Last date{{#var:end_date}}

No description.

[Edit template data]

Template parameters

ParameterDescriptionTypeStatus
Artistartist

The name of the artist

Page namerequired
Name of tourtour

no description

Stringsuggested
Imageimage

no description

Filesuggested
Image captioncaption

no description

Unknownoptional
Yearyear

Use this instead of the 'tour' parameter on pages that list shows for a whole year and not a specific tour

Example
1996
Numberoptional
Image sizeimage_size

no description

Unknownoptional
landscapelandscape

no description

Unknownoptional
borderborder

no description

Unknownoptional
altalt

no description

Unknownoptional
image_captionimage_caption

no description

Unknownoptional
Co-headlersco-headliner

Other artists that co-headlined the tour, such as Marilyn Manson for The End Times tour

Stringoptional
durationduration

no description

Unknownoptional
number_of_legsnumber_of_legs

no description

Unknownoptional
supporting_artistssupporting_artists

no description

Unknownoptional
Name of previous tourprev_tour

Previous tour for the this band

Stringsuggested
Year of previous tourprev_year

Year or year range of the previous tour

Example
1996–1997
Unknownsuggested
Name of next tournext_tour

Next tour by this band

Unknownsuggested
Year of this tourthis_year

no description

Unknownsuggested
Year of next tournext_year

Year or year range of the next tour

Unknownoptional
Festivalfestival

Supply field instead of "name" or "year" to show data on appearances at the given festival

Stringoptional