Výpis kanálů:';
$DbResult = $this->Database->query('SELECT COUNT(*) FROM `TV` LEFT JOIN `TVGroup` ON `TVGroup`.`Id` = `TV`.`Category` '.
' LEFT JOIN `Language` ON `Language`.`Id` = `TV`.`Language` WHERE (`TV`.`Stream` <> "") OR (`TV`.`StreamWeb` <> "")');
$DbRow = $DbResult->fetch_row();
$PageList = GetPageList('TVChannels', $DbRow[0]);
$Output .= $PageList['Output'];
$Output .= '
';
$TableColumns = array(
array('Name' => 'Name', 'Title' => 'Jméno stanice'),
array('Name' => 'Language', 'Title' => 'Jazyk'),
array('Name' => 'Category', 'Title' => 'Zaměření'),
array('Name' => 'SourceType', 'Title' => 'Zdroj'),
array('Name' => '', 'Title' => 'Ladění'),
);
$Order = GetOrderTableHeader('TVChannels', $TableColumns, 'Name', 0);
$Output .= $Order['Output'];
$Query = 'SELECT `TV`.*, `TVGroup`.`Name` AS `Category`, `Language`.`Name` AS `Language` FROM `TV` LEFT JOIN `TVGroup` ON `TVGroup`.`Id` = `TV`.`Category` '.
' LEFT JOIN `Language` ON `Language`.`Id` = `TV`.`Language` WHERE (`TV`.`Stream` <> "") OR (`TV`.`StreamWeb` <> "") '.$Order['SQL'].$PageList['SQLLimit'];
$DbResult = $this->Database->query($Query);
while ($Line = $DbResult->fetch_assoc())
{
if ($Line['Stream'] <> '') $Line['Show'] = 'Naladit';
else
if ($Line['StreamWeb'] <> '') $Line['Show'] = 'Naladit';
else $Line['Show'] = ' ';
$Output .= '| '.$Line['Name'].' | '.
''.$Line['Language'].' | '.
''.$Line['Category'].' | '.
''.$Line['SourceType'].' | '.
''.$Line['Show'].' |
';
}
$Output .= '
';
$Output .= $PageList['Output'];
$Output .= '