Electron Club

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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. More information about regular [[groups:|groups]] can be found within the [[groups:|groups]] section of the site.


<sql>select 
from_unixtime( floor(start_time), '%d/%m/%Y @ %H:%i') as Event_Date,
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",
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()
and from_unixtime( floor(start_time)) < curdate() + interval 30 day
and upper( description ) not like "%CCA BUILDING CLOSED%"
order by start_time ;</sql>

Electron Club

User Tools

Site Tools

Page Tools