<?
$email = DB::sl($_REQUEST['email']);
$id = DB::qry_single("SELECT id FROM users WHERE email='$email'");
if(empty($id)) {
	print json_encode(array());
	return;
}
$query = 'SELECT festivals.id as id, long_title, date_start, date_end
		  FROM festivals		  
		  WHERE admins REGEXP "[\[,]' . $id . '[\],]"
		    AND date_end > DATE_ADD(NOW(), INTERVAL 1 DAY)
		  ORDER BY date_start';
$res = DB::qry_res($query);
$ret = array();
while($f = mysql_fetch_assoc($res)) {
	$ret[$f['id']] = $f;
}
print json_encode($ret);
?>