User Tools

Site Tools


welcome

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
welcome [2017/01/09 01:10]
marto osm url fix
welcome [2017/02/13 11:20] (current)
marto include booking status
Line 22: Line 22:
 name as "Event Name", name as "Event Name",
 description as "​Description",​ 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 from mrbs_entry
 where from_unixtime( floor(start_time)) >= curdate() where from_unixtime( floor(start_time)) >= curdate()
welcome.txt · Last modified: 2017/02/13 11:20 by marto