Differences

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

--- welcome [2017/01/09 00:10]
marto osm url fix
+++ welcome [2018/07/27 10:28]
marto CCA closure
@@ Line 1: / Line 1: @@
 ====== Welcome ======
+===== Temporary closure due to GSA fire =====
+Due to the recent fire at Glasgow School of Art the [[http://cca-glasgow.com/programme/cca-closure|CCA is closed until the end of August]].
 **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 25: @@
 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