EventList: Difference between revisions

VisualWikitext

Latest revision as of 16:59, 17 April 2026

2026: RSS · iCal

1.May 30-Jun 06: Norwegian Dragonkin Gathering, NO (Buskerud)

2.Jun 18-Jun 21: Dragonkin Meetup, NL (Overijssel)

3.Aug 08-Aug 16: Draconic Summit Iceland Eclipse Meetup, IS (Höfuðborgarsvæðið)

4.Aug 14-Aug 16: OtherCon, (Online)

5.Oct 23-Oct 25: HowlCon, (Online)

6.Dec 31-Jan 03: Happy 2027!, UK (England)

2027:

1.Dec 31-Jan 03: Happy 2027!, UK (England)

2.Mar 05-Mar 07: The Centaurus Festival, (Online)

TBD:

1.Shining Hearth Gathering, (Online)

@@ Line 1: / Line 1: @@
-{{CURRENTYEAR}}:
+{{b|{{CURRENTYEAR}}:}} {{#cargo_query:
+tables=CommunityEvents
-{{#ask:
+|fields=CommunityEvents._pageName, CommunityEvents.NextDateStart
-  [[Category:Gathers||Minigathers||Meetups]]
+|where=COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
-  [[Status::Active]]
+|order by=CommunityEvents.NextDateStart ASC
-  [[Eventdate::>{{#time: Y-m-d | -2 days }}]]
+|format=feed
-  [[Eventdate::<{{#time: Y-m-d | {{CURRENTYEAR}}-12-31 }}]]
+|feed type=rss
-  [[Eventstartdate::!TBD]]
+|link text=RSS
-  |color=red
+|feed title=Upcoming Events
-  |? Eventstartdate
+|feed description=A feed of upcoming community events.
-  |format=table
+}} {{b|·}} {{#cargo_query:
-  |limit=300
+tables=CommunityEvents
+|fields=CommunityEvents._pageName, CommunityEvents.NextDateStart
+|where=COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
+|order by=CommunityEvents.NextDateStart ASC
+|format=icalendar
+|link text=iCal
+|filename=calendar.ics
+|icalendar name=Upcoming Events
+|icalendar description=A calendar of upcoming community events
 }}
+{{#cargo_query:
+tables=CommunityEvents
-{{#time: Y | +1 year}}:
+|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N
-{{#ask:
-  [[Category:Gathers||Minigathers||Meetups]]
+|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
+and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
-  [[Status::Active]]
-  [[Eventdate::>{{#time: Y-m-d | {{CURRENTYEAR}}-12-31 }}]]
+and NextDateStart <= '{{CURRENTYEAR}}-12-31'
+|limit=300
-  [[Eventdate::<{{#time: Y-m-d | +1 year }}]]
+|format=template
-  [[Eventstartdate::!TBD]]
+|sort=CommunityEvents.NextDateStart ASC
-  |color=red
+|template=EventsList2
-  |? Eventstartdate
-  |format=table
-  |limit=300
 }}
+{{#cargo_query:
+tables=CommunityEvents
-TBD:
+|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N
-{{#ask:
-  [[Category:Gathers||Minigathers||Meetups]]
+|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
+and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31'
-  [[Status::Active]]
+and NextDateStart <= '{{#time: Y-m-d | {{CURRENTYEAR}}-12-31+1 year}}'
-  [[Eventstartdate::TBD]]
+|limit=300
-  |color=red
+|format=template
-  |? Eventstartdate
+|template=EventsList2
-  |format=table
+|sort=CommunityEvents.NextDateStart ASC
-  |limit=300
+|intro={{b|{{#time: Y | +1 year}}:}}
+}}
+{{#cargo_query:
+tables=CommunityEvents
+|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')
+and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1))
+|limit=300
+|format=template
+|template=EventsList3
+|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC
+|intro={{b|TBD:}}
 }}