Differences

This shows you the differences between two versions of the page.

--- events:30dayfeed [2017/01/02 15:31] – created marto
+++ events:30dayfeed [2017/02/13 10:21] (current) – include booking status marto
@@ Line 1: / Line 1: @@
 ====== Events within the next 30 days. ======
-Below is a list of events scheduled within the next 30 days. Certain events have their own listing in the [[events|events section]]. The information is taken from our [[howto:calendar|calendar]], and is also available as an [[http://electronclub.org/rss.php|rss]] feed.
+Below is a list of events scheduled within the next 30 days. Certain events have their own listing in the [[events:|events section]]. The information is taken from our [[howto:calendar|calendar]], and is also available as an [[http://electronclub.org/rss.php|rss]] feed. More information about regular [[groups:|groups]] can be found within the [[groups:|groups]] section of the site.
 <sql>select
@@ Line 7: / Line 8: @@
 name as "Event Name",
 description as "Description",
-concat('<a href="http://www.electronclub.org/calendar/view_entry.php?id=', id, '" target="_blank">Click here</a>') as "Link"
+concat('<a href="http://www.electronclub.org/calendar/view_entry.php?id=', id, '" target="_blank">Click here</a>') as "Link",
+CASE
+  WHEN status = '0' THEN 'Confirmed'
+  WHEN status = '4' THEN 'Tentative'
+END as "Booking Status"
 from mrbs_entry
 where from_unixtime( floor(start_time)) >= curdate()
 and from_unixtime( floor(start_time)) < curdate() + interval 30 day
 and upper( description ) not like "%CCA BUILDING CLOSED%"
-order by Event_Date;</sql>
+order by start_time ;</sql>