<?php
require_once 'database.php';
$data = array();

if (sql_connect())
{
	$query = 'SELECT nome, streaming_url, (SELECT COUNT(*) FROM `palinsesto` WHERE canale=nome) as `hasEPG` FROM `canali`';

	if (array_key_exists('channel',$_REQUEST))
	{
		$canali = explode(',',$_REQUEST['channel']);
		if (count($canali)>0)
		{
			$where = array();
			foreach($canali as &$canale)
			{
				if (strtolower($canale)=='streaming_live')
				{
					$where[] = '(streaming_url<>\'\'))';
				} else {
					$where[] = 'nome='.sql_quote($canale);
				}
			}
			$query .= ' WHERE ('.implode(' OR ',$where).')';
		}
	}

	$query .= ' ORDER BY nome';
	$cursor = sql_cursor_open($query);
	while ($row = sql_fetch_row($cursor))
	{
		$row['logo'] = 'logo/'.$row['nome'].'.png';
		if ($row['hasEPG']>0)
		{
			$row['hasEPG'] = TRUE;
		} else {
			$row['hasEPG'] = FALSE;
		}
		$data[$row['nome']] = $row;
	}
	sql_cursor_close($cursor);
	sql_disconnect();
}

header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
echo json_encode($data);
exit;
?>