Template:Event Host - Revision history

Edd at 16:20, 11 February 2024

2024-02-11T16:20:22Z

← Older revision		Revision as of 16:20, 11 February 2024
Line 46:		Line 46:
	{{#cargo_query:		{{#cargo_query:
	tables=SatelliteEvents		tables=SatelliteEvents
	\|fields=MainEvent,StartDate,EventName,URL,EventCategory1,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15		\|fields=_pageName,MainEvent,StartDate,EventName,URL,EventCategory1,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15
	\|where= SatelliteEvents.Host1= '{{PAGENAME}}' OR SatelliteEvents.Host2= '{{PAGENAME}}' OR SatelliteEvents.Host3= '{{PAGENAME}}' OR SatelliteEvents.Host4= '{{PAGENAME}}' OR SatelliteEvents.Host5= '{{PAGENAME}}' OR SatelliteEvents.Host6= '{{PAGENAME}}' OR SatelliteEvents.Host7= '{{PAGENAME}}' OR SatelliteEvents.Host8= '{{PAGENAME}}' OR SatelliteEvents.Host9= '{{PAGENAME}}' OR SatelliteEvents.Host10= '{{PAGENAME}}' OR SatelliteEvents.Host11= '{{PAGENAME}}' OR SatelliteEvents.Host12= '{{PAGENAME}}' OR SatelliteEvents.Host13= '{{PAGENAME}}' OR SatelliteEvents.Host14= '{{PAGENAME}}' OR SatelliteEvents.Host15= '{{PAGENAME}}'		\|where= SatelliteEvents.Host1= '{{PAGENAME}}' OR SatelliteEvents.Host2= '{{PAGENAME}}' OR SatelliteEvents.Host3= '{{PAGENAME}}' OR SatelliteEvents.Host4= '{{PAGENAME}}' OR SatelliteEvents.Host5= '{{PAGENAME}}' OR SatelliteEvents.Host6= '{{PAGENAME}}' OR SatelliteEvents.Host7= '{{PAGENAME}}' OR SatelliteEvents.Host8= '{{PAGENAME}}' OR SatelliteEvents.Host9= '{{PAGENAME}}' OR SatelliteEvents.Host10= '{{PAGENAME}}' OR SatelliteEvents.Host11= '{{PAGENAME}}' OR SatelliteEvents.Host12= '{{PAGENAME}}' OR SatelliteEvents.Host13= '{{PAGENAME}}' OR SatelliteEvents.Host14= '{{PAGENAME}}' OR SatelliteEvents.Host15= '{{PAGENAME}}'
	\|format=template		\|format=template

Edd at 15:58, 11 February 2024

2024-02-11T15:58:31Z

← Older revision		Revision as of 15:58, 11 February 2024
Line 46:		Line 46:
	{{#cargo_query:		{{#cargo_query:
	tables=SatelliteEvents		tables=SatelliteEvents
	\|fields=MainEvent,StartDate,EventName,URL,~~EventType~~,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15		\|fields=MainEvent,StartDate,EventName,URL,EventCategory1,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15
	\|where= SatelliteEvents.Host1= '{{PAGENAME}}' OR SatelliteEvents.Host2= '{{PAGENAME}}' OR SatelliteEvents.Host3= '{{PAGENAME}}' OR SatelliteEvents.Host4= '{{PAGENAME}}' OR SatelliteEvents.Host5= '{{PAGENAME}}' OR SatelliteEvents.Host6= '{{PAGENAME}}' OR SatelliteEvents.Host7= '{{PAGENAME}}' OR SatelliteEvents.Host8= '{{PAGENAME}}' OR SatelliteEvents.Host9= '{{PAGENAME}}' OR SatelliteEvents.Host10= '{{PAGENAME}}' OR SatelliteEvents.Host11= '{{PAGENAME}}' OR SatelliteEvents.Host12= '{{PAGENAME}}' OR SatelliteEvents.Host13= '{{PAGENAME}}' OR SatelliteEvents.Host14= '{{PAGENAME}}' OR SatelliteEvents.Host15= '{{PAGENAME}}'		\|where= SatelliteEvents.Host1= '{{PAGENAME}}' OR SatelliteEvents.Host2= '{{PAGENAME}}' OR SatelliteEvents.Host3= '{{PAGENAME}}' OR SatelliteEvents.Host4= '{{PAGENAME}}' OR SatelliteEvents.Host5= '{{PAGENAME}}' OR SatelliteEvents.Host6= '{{PAGENAME}}' OR SatelliteEvents.Host7= '{{PAGENAME}}' OR SatelliteEvents.Host8= '{{PAGENAME}}' OR SatelliteEvents.Host9= '{{PAGENAME}}' OR SatelliteEvents.Host10= '{{PAGENAME}}' OR SatelliteEvents.Host11= '{{PAGENAME}}' OR SatelliteEvents.Host12= '{{PAGENAME}}' OR SatelliteEvents.Host13= '{{PAGENAME}}' OR SatelliteEvents.Host14= '{{PAGENAME}}' OR SatelliteEvents.Host15= '{{PAGENAME}}'
	\|format=template		\|format=template

Edd: Created page with " {{#template_params:URL (label=URL)|XTwitter (label=X (Twitter))|Discord (label=Discord)|GitHub (label=GitHub)|Instagram (label=Instagram)|YouTube (label=YouTube)|Blog (label=Blog/News)|Telegram (label=Telegram)|Facebook (label=Facebook)|Linkedin (label=Linkedin)|Reddit (label=Reddit)|OtherCategories1 (label=Additional Categories)|OtherCategories2 (label=Additional Categories)|OtherCategories3 (label=Additional Categories)}} {{#cargo_declare:_table=EventHosts|..."

2024-01-29T20:25:31Z

Created page with "<noinclude> {{#template_params:URL (label=URL)|XTwitter (label=X (Twitter))|Discord (label=Discord)|GitHub (label=GitHub)|Instagram (label=Instagram)|YouTube (label=YouTube)|Blog (label=Blog/News)|Telegram (label=Telegram)|Facebook (label=Facebook)|Linkedin (label=Linkedin)|Reddit (label=Reddit)|OtherCategories1 (label=Additional Categories)|OtherCategories2 (label=Additional Categories)|OtherCategories3 (label=Additional Categories)}} {{#cargo_declare:_table=EventHosts|..."

New page

<noinclude>
{{#template_params:URL (label=URL)|XTwitter (label=X (Twitter))|Discord (label=Discord)|GitHub (label=GitHub)|Instagram (label=Instagram)|YouTube (label=YouTube)|Blog (label=Blog/News)|Telegram (label=Telegram)|Facebook (label=Facebook)|Linkedin (label=Linkedin)|Reddit (label=Reddit)|OtherCategories1 (label=Additional Categories)|OtherCategories2 (label=Additional Categories)|OtherCategories3 (label=Additional Categories)}}
{{#cargo_declare:_table=EventHosts|URL=URL|XTwitter=URL|Discord=URL|GitHub=URL|Instagram=URL|YouTube=URL|Blog=URL|Telegram=URL|Facebook=URL|Linkedin=URL|Reddit=URL|OtherCategories1=String|OtherCategories2=String|OtherCategories3=String}}
</noinclude><includeonly>{{#cargo_store:_table=EventHosts}}
{| class="wikitable" style="width: 30em; font-size: 90%; border: 1px solid #aaaaaa; background-color: #f0f4f7; color: black; margin-bottom: 0.5em; margin-left: 1em; padding: 0.2em; float: right; clear: right; text-align:left;"
! style="text-align: center; background-color:#86c8fc;" colspan="2" |<span style="font-size: larger;">{{PAGENAME}}</span>
|-
!Website:
| {{{URL|}}}
|-
!X (Twitter):
| {{{XTwitter|}}}
|-
!Discord:
| {{{Discord|}}}
|-
!GitHub:
| {{{GitHub|}}}
|-
!Instagram:
| {{{Instagram|}}}
|-
!YouTube:
| {{{YouTube|}}}
|-
!Blog/News:
| {{{Blog|}}}
|-
!Telegram:
| {{{Telegram|}}}
|-
!Facebook:
| {{{Facebook|}}}
|-
!Linkedin:
| {{{Linkedin|}}}
|-
!Reddit:
| {{{Reddit|}}}
|}

== Recent And Upcoming Events Hosted By {{PAGENAME}} ==
{| class="wikitable sortable" style="text-align: center;"
|-
! During !! Date !! Event !! Venue !! Host(s)
{{#cargo_query:
tables=SatelliteEvents
|fields=MainEvent,StartDate,EventName,URL,EventType,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,City,ZipCode,MapLink,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15
|where= SatelliteEvents.Host1= '{{PAGENAME}}' OR SatelliteEvents.Host2= '{{PAGENAME}}' OR SatelliteEvents.Host3= '{{PAGENAME}}' OR SatelliteEvents.Host4= '{{PAGENAME}}' OR SatelliteEvents.Host5= '{{PAGENAME}}' OR SatelliteEvents.Host6= '{{PAGENAME}}' OR SatelliteEvents.Host7= '{{PAGENAME}}' OR SatelliteEvents.Host8= '{{PAGENAME}}' OR SatelliteEvents.Host9= '{{PAGENAME}}' OR SatelliteEvents.Host10= '{{PAGENAME}}' OR SatelliteEvents.Host11= '{{PAGENAME}}' OR SatelliteEvents.Host12= '{{PAGENAME}}' OR SatelliteEvents.Host13= '{{PAGENAME}}' OR SatelliteEvents.Host14= '{{PAGENAME}}' OR SatelliteEvents.Host15= '{{PAGENAME}}'
|format=template
|template=CityTemplateRowDisplay
|named args=yes
|order by=StartDate DESC
}}

{{#cargo_query:
tables=EventHosts
|fields=CONCAT('[[Category:',OtherCategories1,']]')=OtherCategories1,CONCAT(' [[Category:',OtherCategories2,']]')=OtherCategories2,CONCAT('[[Category:',OtherCategories3,']]')=OtherCategories3
|where=EventHosts._pageName= '{{PAGENAME}}'
|format=template
|template=Web3OrgMultipleCategories
|named args=yes
}}

[[Category:Event Hosts]]

</includeonly>