Differences

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

--- welcome [2017/01/09 00:05]
marto cca url fix
+++ welcome [2017/02/13 10:20]
marto include booking status
@@ Line 22: / Line 22: @@
 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()
@@ Line 38: / Line 42: @@
 Glasgow
-[[http://www.openstreetmap.org/?lat=55.865764&lon=-4.264938&zoom=18&layers=C| CCA on OpenStreetMap]] - [[https://maps.google.co.uk/maps?q=cca,+glasgow&hl=en&ll=55.865735,-4.264986&spn=0.000777,0.002411&geocode=+&hq=cca,+glasgow&t=h&z=19| CCA on Google Maps]]\\
+[[http://www.openstreetmap.org/#map=18/55.86596/-4.26599| CCA on OpenStreetMap]] - [[https://maps.google.co.uk/maps?q=cca,+glasgow&hl=en&ll=55.865735,-4.264986&spn=0.000777,0.002411&geocode=+&hq=cca,+glasgow&t=h&z=19| CCA on Google Maps]]\\
 See the CCA website for [[http://www.cca-glasgow.com/programme | opening hours]] or check the [[http://www.electronclub.org/calendar/ | calendar]] for Electron club related meeting/event times.

Electron Club