Differences

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

--- welcome [2017/01/09 00:10]
marto osm url fix
+++ welcome [2018/10/19 09:20]
kenny open again
@@ Line 1: / Line 1: @@
 ====== Welcome ======
+Following the closure due to fire at Glasgow School of Art, earlier in the summer, the CCA and Electron Club reopened on the 20th October
 **The Electron Club is a voluntary run space where people interested in things like Free Open Source Software, DIY culture, circuit bending, hardware hacking, streaming, audio and video editing, green technologies, and amateur radio can meet, use equipment, and share and disseminate their skills and ideas.**
@@ Line 22: / Line 23: @@
 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()

Electron Club