EventList - Revision history

Jarandhel: Fixed spacing.

2026-04-17T20:59:49Z

Fixed spacing.

← Older revision		Revision as of 16:59, 17 April 2026
Line 20:		Line 20:
	\|icalendar description=A calendar of upcoming community events		\|icalendar description=A calendar of upcoming community events
	}}		}}
	{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
Line 31:		Line 30:
	\|sort=CommunityEvents.NextDateStart ASC		\|sort=CommunityEvents.NextDateStart ASC
	\|template=EventsList2		\|template=EventsList2
	\|intro={{#vardefine:ITER_INDEX\|0}}
	}}		}}
	{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
Line 44:		Line 41:
	\|template=EventsList2		\|template=EventsList2
	\|sort=CommunityEvents.NextDateStart ASC		\|sort=CommunityEvents.NextDateStart ASC
	\|intro=~~{{#vardefine:ITER_INDEX\|0}}~~{{b\|{{#time: Y \| +1 year}}:}}		\|intro={{b\|{{#time: Y \| +1 year}}:}}
	}}		}}
	{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
Line 56:		Line 52:
	\|template=EventsList3		\|template=EventsList3
	\|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC		\|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC
	\|intro=~~{{#vardefine:ITER_INDEX\|0}}~~{{b\|TBD:}}		\|intro={{b\|TBD:}}
	}}		}}

Jarandhel: Final fix.

2026-04-17T20:57:48Z

Final fix.

← Older revision		Revision as of 16:57, 17 April 2026
Line 23:		Line 23:
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
	\|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ~~CONCAT~~(~~"{{~~(~~(}}Iter{{))}}"~~)=N		\|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N
	\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')		\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
	and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)		and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
Line 31:		Line 31:
	\|sort=CommunityEvents.NextDateStart ASC		\|sort=CommunityEvents.NextDateStart ASC
	\|template=EventsList2		\|template=EventsList2
			\|intro={{#vardefine:ITER_INDEX\|0}}
	}}		}}
	{{#vardefine:ITER_INDEX\|0}}		{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
	\|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ~~CONCAT~~(~~"{{~~(~~(}}Iter{{))}}"~~)=N		\|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N
	\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')		\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
	and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31'		and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31'
Line 43:		Line 44:
	\|template=EventsList2		\|template=EventsList2
	\|sort=CommunityEvents.NextDateStart ASC		\|sort=CommunityEvents.NextDateStart ASC
	\|intro={{b\|{{#time: Y \| +1 year}}:}}		\|intro={{#vardefine:ITER_INDEX\|0}}{{b\|{{#time: Y \| +1 year}}:}}
	}}		}}
	{{#vardefine:ITER_INDEX\|0}}		{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
	\|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ~~CONCAT~~(~~"{{~~(~~(}}Iter{{))}}"~~)=N		\|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.Status ASC,CommunityEvents._PageName ASC)=N
	\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')		\|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
	and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1))		and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1))
Line 54:		Line 55:
	\|format=template		\|format=template
	\|template=EventsList3		\|template=EventsList3
	\|sort=CommunityEvents.Status ASC		\|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC
	\|intro={{b\|TBD:}}		\|intro={{#vardefine:ITER_INDEX\|0}}{{b\|TBD:}}
	}}		}}

Jarandhel: Resetting index.

2026-04-17T20:35:59Z

Resetting index.

← Older revision		Revision as of 16:35, 17 April 2026
Line 20:		Line 20:
	\|icalendar description=A calendar of upcoming community events		\|icalendar description=A calendar of upcoming community events
	}}		}}
			{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
Line 31:		Line 32:
	\|template=EventsList2		\|template=EventsList2
	}}		}}
			{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents
Line 43:		Line 45:
	\|intro={{b\|{{#time: Y \| +1 year}}:}}		\|intro={{b\|{{#time: Y \| +1 year}}:}}
	}}		}}
			{{#vardefine:ITER_INDEX\|0}}
	{{#cargo_query:		{{#cargo_query:
	tables=CommunityEvents		tables=CommunityEvents

Jarandhel: Switching to Cargo

2026-04-17T20:29:37Z

Switching to Cargo

@@ Line 1: / Line 1: @@
-{{b|{{CURRENTYEAR}}:}} {{#ask:
+{{b|{{CURRENTYEAR}}:}} {{#cargo_query:
 }}
-{{#ask:
+{{#cargo_query:
 }}
-{{#ask:
+{{#cargo_query:
 }}
-{{#ask:
+{{#cargo_query:
 }}

Jarandhel: Trying to fix the ical link still.

2026-04-12T16:42:48Z

Trying to fix the ical link still.

@@ Line 1: / Line 1: @@
 {{b|{{CURRENTYEAR}}:}} {{#ask:
   [[:+]]
-  [[Eventstartdate::+]]
+  [[Eventstartdate::>{{#time: Y-m-d | -2 days }}]]
   [[Category:Gathers||Minigathers||Meetups]]
   [[Status::Active]]
@@ Line 12: / Line 13: @@
   |title=Upcoming Community Events
   |description=Upcoming Otherkin Community Events
-  |? Eventstartdate = start
+       |? Eventenddate = end
 }}
 {{#ask:
   [[:+]]

Jarandhel: Trying to fix the ical link still.

2026-04-12T16:26:14Z

Trying to fix the ical link still.

← Older revision		Revision as of 12:26, 12 April 2026
Line 13:		Line 13:
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
	}} {{b\|·}}		}} {{b\|·}}
			{{#ask:
	{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#ask:
	[[:+]]		[[:+]]
	[[Eventstartdate::+]]		[[Eventstartdate::+]]
Line 26:		Line 26:
	\|title=OtherkinEvents		\|title=OtherkinEvents
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
	}}
	\|format=csv\|data=theurl=1\|suppress error}}{{#ifeq: {{#external_value:theurl}} \| there

	\| <span class="error">No iCal available</span>
	\| {{#if: {{#external_value:theurl}}
	\| <span class="plainlinks">[{{#external_value:theurl}} iCal]</span>
	\| <span class="error">No iCal available</span>
	}}
	}}		}}

Jarandhel: Trying to fix a template.

2026-04-12T16:15:32Z

Trying to fix a template.

← Older revision		Revision as of 12:15, 12 April 2026
Line 13:		Line 13:
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
	}} {{b\|·}}		}} {{b\|·}}
	{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url=~~{{#urlencode:~~{{#ask:		{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#ask:
	[[:+]]		[[:+]]
	[[Eventstartdate::+]]		[[Eventstartdate::+]]
Line 26:		Line 26:
	\|title=OtherkinEvents		\|title=OtherkinEvents
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
	}} }}		}}
	\|format=csv\|data=theurl=1\|suppress error}}{{#ifeq: {{#external_value:theurl}} \| there		\|format=csv\|data=theurl=1\|suppress error}}{{#ifeq: {{#external_value:theurl}} \| there

Jarandhel: Gracefully handles no ical available.

2026-04-12T16:02:06Z

Gracefully handles no ical available.

← Older revision		Revision as of 12:02, 12 April 2026
Line 13:		Line 13:
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
	}} {{b\|·}}		}} {{b\|·}}
	{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#ask:		{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#urlencode:{{#ask:
	[[:+]]		[[:+]]
	[[Eventstartdate::+]]		[[Eventstartdate::+]]
Line 26:		Line 26:
	\|title=OtherkinEvents		\|title=OtherkinEvents
	\|description=Upcoming Otherkin Community Events		\|description=Upcoming Otherkin Community Events
			}} }}
		⚫	\|format=csv\|data=theurl=1\|suppress error}}{{#ifeq: {{#external_value:theurl}} \| there

			\| <span class="error">No iCal available</span>
			\| {{#if: {{#external_value:theurl}}
			\| <span class="plainlinks">[{{#external_value:theurl}} iCal]</span>
			\| <span class="error">No iCal available</span>
			}}
	}}		}}
⚫	\|format=csv\|data=theurl=1\|suppress error}}~~<span~~ ~~class="plainlinks">[~~{{#external_value:theurl}} ~~iCal]</span>~~

	{{#ask:		{{#ask:

Jarandhel at 14:18, 12 April 2026

2026-04-12T14:18:13Z

← Older revision		Revision as of 10:18, 12 April 2026
Line 1:		Line 1:
	{{b\|{{CURRENTYEAR}}:}} {{#ask:		{{b\|{{CURRENTYEAR}}:}} {{#ask:
			[[:+]]
	[[Eventstartdate::+]]		[[Eventstartdate::+]]
	[[Category:Gathers\|\|Minigathers\|\|Meetups]]		[[Category:Gathers\|\|Minigathers\|\|Meetups]]
Line 13:		Line 14:
	}} {{b\|·}}		}} {{b\|·}}
	{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#ask:		{{#get_web_data:url=https://dreamhart.org/lilliputian.php?url={{#ask:
			[[:+]]
	[[Eventstartdate::+]]		[[Eventstartdate::+]]
	[[Category:Gathers\|\|Minigathers\|\|Meetups]]		[[Category:Gathers\|\|Minigathers\|\|Meetups]]
Line 66:		Line 68:
	}}		}}
	{{#ask:		{{#ask:
	[[~~Status~~:~~:Active\|\|TBD~~]]		[[:+]]
	[[Status::TBD\|\|Eventnotscheduled::true]]		[[Status::TBD]] OR [[Status::Active]] [[Eventnotscheduled::true]]
			\|mainlabel=-
	[[Category:Gathers\|\|Minigathers\|\|Meetups]]
	\|~~mainlabel~~=EventName		\|? = EventName
	\|?State~~=State~~		\|? State#
	\|?Country~~=Country~~		\|? Country#
	\|format=ol		\|format=ol
	\|template=EventsList3		\|template=EventsList3

Jarandhel at 13:51, 12 April 2026

2026-04-12T13:51:31Z

← Older revision		Revision as of 09:51, 12 April 2026
Line 66:		Line 66:
	}}		}}
	{{#ask:		{{#ask:
	[[Status::~~TBD]]~~ \|\| ~~[[Eventnotscheduled::true~~]]		[[Status::Active\|\|TBD]]
	[[Status::~~Active~~\|\|~~TBD~~]]		[[Status::TBD\|\|Eventnotscheduled::true]]
			[[Category:Gathers\|\|Minigathers\|\|Meetups]]
	\|mainlabel = ~~Event~~		\|mainlabel=EventName
	\|? EventName# = Event
	\|? State# = State		\|?State=State
	\|? Country# = Country		\|?Country=Country
	\|format=ol		\|format=ol
	\|template=EventsList3		\|template=EventsList3
	\|limit=300		\|limit=300
	\|intro = {{b\|TBD:}}		\|intro = {{b\|TBD:}}
	\|sort=Status		\|sort=Status
	\|order=asc		\|order=asc
	}}		}}