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