EventList: Difference between revisions
No edit summary |
m (Fixed spacing.) |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{b|{{CURRENTYEAR}}:}} {{#cargo_query: |
|||
tables=CommunityEvents |
|||
[[Eventstartdate::+]] |
|||
|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 |
|||
|? Eventstartdate#ISO = date |
|||
|format=feed |
|||
|feed type=rss |
|||
|sort=Eventstartdate |
|||
|link text=RSS |
|||
|order=ASC |
|||
|feed title=Upcoming Events |
|||
|searchlabel= RSS |
|||
|feed description=A feed of upcoming community events. |
|||
|rsstitle=Upcoming Community Events |
|||
}} {{b|·}} {{#cargo_query: |
|||
|rssdescription=Upcoming Otherkin Community Events |
|||
tables=CommunityEvents |
|||
}} '''·''' {{#get_web_data: |
|||
|fields=CommunityEvents._pageName, CommunityEvents.NextDateStart |
|||
url=http://dreamhart.org/tiny.php?url={{#ask: |
|||
|where=COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY) |
|||
[[Category:Gathers||Minigathers||Meetups]] |
|||
|order by=CommunityEvents.NextDateStart ASC |
|||
[[Status::Active]] |
|||
|format=icalendar |
|||
|? Eventstartdate = start |
|||
|link text=iCal |
|||
|? Eventends = end |
|||
|filename=calendar.ics |
|||
|format=icalendar |
|||
|icalendar name=Upcoming Events |
|||
|sort=Eventstartdate |
|||
|icalendar description=A calendar of upcoming community events |
|||
|order=ASC |
|||
|searchlabel= |
|||
|title=Upcoming Community Events |
|||
|description=Upcoming Community Events |
|||
}} |
}} |
||
{{#cargo_query: |
|||
|format=csv|data=theurl=1}} |
|||
tables=CommunityEvents |
|||
<span class="plainlinks">[{{#external_value:theurl}} iCal]</span> |
|||
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=N |
|||
{{#ask: |
|||
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
|||
[[:+]] |
|||
and COALESCE(NextDateEnd,NextDateStart) > DATE_ADD(NOW(), INTERVAL -2 DAY) |
|||
[[Eventstartdate::>{{#time: Y-m-d | -2 days }}]] |
|||
and NextDateStart <= '{{CURRENTYEAR}}-12-31' |
|||
|limit=300 |
|||
[[Status::Active]] |
|||
|format=template |
|||
[[Category:Gathers||Minigathers||Meetups]] |
|||
|sort=CommunityEvents.NextDateStart ASC |
|||
|mainlabel=- |
|||
|template=EventsList2 |
|||
|? Eventstartdate#ISO = Event Date |
|||
|? Eventends |
|||
|? = Event |
|||
|? State# |
|||
|? Country# |
|||
|format=ol |
|||
|template=EventsList2 |
|||
|sort=Eventstartdate |
|||
|order=ASC |
|||
|limit=300 |
|||
|default = none |
|||
}} |
}} |
||
{{# |
{{#cargo_query: |
||
tables=CommunityEvents |
|||
[[:+]] |
|||
|fields=CommunityEvents.NextDateStart, CommunityEvents.NextDateEnd, CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.NextDateStart ASC)=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 = '''{{#time: Y | +1 year}}:''' |
|||
}} |
}} |
||
{{# |
{{#cargo_query: |
||
tables=CommunityEvents |
|||
[[Status::TBD]] OR [[Eventnotscheduled::TRUE]] OR [[Eventstartdate::<{{#time: Y-m-d | -2 days }}]] |
|||
|fields=CommunityEvents._pageName, CommunityEvents.State, CommunityEvents.Country, ROW_NUMBER() OVER (ORDER BY CommunityEvents.Status ASC,CommunityEvents._PageName ASC)=N |
|||
[[Eventstartdate::!{{#time: Y-m-d | -2 days }}]] |
|||
|where=CommunityEvents.EventType IN ('Gathers','Minigathers','Meetups') |
|||
[[Status::Active||TBD]] |
|||
and (CommunityEvents.Status = 'TBD' or (CommunityEvents.Status = 'Active' and CommunityEvents.EventNotScheduled = 1)) |
|||
[[:+]] |
|||
|limit=300 |
|||
|mainlabel = Event |
|||
|format=template |
|||
|? State# |
|||
|template=EventsList3 |
|||
|? Country# |
|||
|sort=CommunityEvents.Status ASC,CommunityEvents._PageName ASC |
|||
|format=ol |
|||
|intro={{b|TBD:}} |
|||
|template=EventsList3 |
|||
|limit=300 |
|||
|intro = '''TBD:''' |
|||
|sort=Status,Eventstartdate |
|||
|order=asc,desc |
|||
}} |
}} |
||
Latest revision as of 16:59, 17 April 2026
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)