User Tools

Site Tools


events:30dayfeed

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
events:30dayfeed [2017/01/06 13:29]
marto
events:30dayfeed [2017/02/13 11:21] (current)
marto include booking status
Line 2: Line 2:
  
 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. 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 ​ <​sql>​select ​
Line 7: Line 8:
 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()
events/30dayfeed.txt · Last modified: 2017/02/13 11:21 by marto