EventList: Difference between revisions

VisualWikitext

Revision as of 16:29, 17 April 2026

2026: RSS · iCal

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

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

2027:

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

TBD:

9.OtherCon, (Online)

10.Shining Hearth Gathering, (Online)

@@ Line 1: / Line 1: @@
-{{b|{{CURRENTYEAR}}:}} {{#ask:
+{{b|{{CURRENTYEAR}}:}} {{#cargo_query:
+tables=CommunityEvents
-  [[:+]]
+|fields=CommunityEvents._pageName, CommunityEvents.NextDateStart
-  [[Eventstartdate::>{{#time: Y-m-d | -2 days }}]]
+|where=COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
-  [[Eventstartdate::<{{#time: Y-m-d | {{CURRENTYEAR}}-12-31}}]]
+|order by=CommunityEvents.NextDateStart ASC
-  [[Category:Gathers||Minigathers||Meetups]]
+|format=feed
-  [[Status::Active]]
+|feed type=rss
-  |? Eventstartdate#ISO = date
+|link text=RSS
-  |format=feed
+|feed title=Upcoming Events
-  |type=atom
+|feed description=A feed of upcoming community events.
-  |sort=Eventstartdate
+}} {{b|·}} {{#cargo_query:
-  |order=ASC
+tables=CommunityEvents
-  |searchlabel= RSS
+|fields=CommunityEvents._pageName, CommunityEvents.NextDateStart
-  |title=Upcoming Community Events
+|where=COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY)
-  |description=Upcoming Otherkin Community Events
+|order by=CommunityEvents.NextDateStart ASC
-}} {{b|·}} {{#ifexpr: {{#ask: [[Eventstartdate::>{{#time: Y-m-d | -2 days }}]] [[Eventstartdate::<{{#time: Y-m-d | {{CURRENTYEAR}}-12-31}}]] [[Category:Gathers||Minigathers||Meetups]] [[Status::Active]] |format=count}} > 0 | {{#ask:
+|format=icalendar
-       [[Eventstartdate::>{{#time: Y-m-d | -2 days }}]]
+|link text=iCal
-       [[Eventstartdate::<{{#time: Y-m-d | {{CURRENTYEAR}}-12-31}}]]
+|filename=calendar.ics
-       [[Category:Gathers||Minigathers||Meetups]]
+|icalendar name=Upcoming Events
-       [[Status::Active]]
+|icalendar description=A calendar of upcoming community events
-       |? Eventstartdate = start
-       |? Eventenddate = end
-       |format=iCalendar
-       |sort=eventstartdate
-       |order=ASC
-       |searchlabel= iCal
-       |title=OtherkinEvents
-       |description=Upcoming Otherkin Community Events
-       |limit=5000
-    }} | <span class="error">No iCal available.</span>
 }}
-{{#ask:
+{{#cargo_query:
+tables=CommunityEvents
-  [[:+]]
+|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
-  [[Eventstartdate::>{{#time: Y-m-d | -2 days }}]]
+|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)
-  [[Status::Active]]
+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
-  |default = none
 }}
-{{#ask:
+{{#cargo_query:
+tables=CommunityEvents
-  [[:+]]
+|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
-  [[Eventstartdate::>{{#time: Y-m-d | {{CURRENTYEAR}}-12-31}}]]
+|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
-  [[Eventstartdate::<{{#time: Y-m-d | {{CURRENTYEAR}}-12-31+1 year }}]]
+and COALESCE(NextDateEnd,NextDateStart) > '{{CURRENTYEAR}}-12-31'
-  [[Status::Active]]
+and NextDateStart <= '{{#time: Y-m-d | {{CURRENTYEAR}}-12-31+1 year}}'
-  [[Category:Gathers||Minigathers||Meetups]]
+|limit=300
-  |mainlabel=-
+|format=template
-  |? Eventstartdate#ISO = Event Date
+|template=EventsList2
-  |? Eventends
+|sort=CommunityEvents.NextDateStart ASC
-  |? = Event
+|intro={{b|{{#time: Y | +1 year}}:}}
-  |? State#
-  |? Country#
-  |format=ol
-  |template=EventsList2
-  |sort=Eventstartdate
-  |order=ASC
-  |limit=300
-  |intro = {{b|{{#time: Y | +1 year}}:}}
 }}
-{{#ask:
+{{#cargo_query:
+tables=CommunityEvents
- [[:+]]
+|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, CONCAT("{{((}}Iter{{))}}")=N
- [[Status::TBD]] OR [[Status::Active]] [[Eventnotscheduled::true]]
+|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups')
- |mainlabel=-
+and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1))
- |? = EventName
+|limit=300
- |? State#
+|format=template
- |? Country#
+|template=EventsList3
- |format=ol
+|sort=CommunityEvents.Status ASC
- |template=EventsList3
+|intro={{b|TBD:}}
- |limit=300
- |intro = {{b|TBD:}}
- |sort=Status
- |order=asc
 }}