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
Next revision
Previous revision
events:30dayfeed [2017/01/03 10:10]
marto
events:30dayfeed [2017/02/13 10:21] (current)
marto include booking status
Line 1: Line 1:
 ====== Events within the next 30 days. ====== ====== Events within the next 30 days. ======
  
-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.+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.1483438232.txt.gz · Last modified: 2017/01/03 10:10 by marto