<?php

include('files.php');
echo('<h2 class="PageTitle">Soubory ke stažení:</h2>');
echo('<table class="DownloadTable">');
$DbResult = $System->Database->query('SELECT * FROM FileCategory ORDER BY Name');
while($Category = $DbResult->fetch_assoc())
{
  echo('<h3>'.$Category['Name'].'</h3>');
  $DbResult2 = $System->Database->query('SELECT * FROM File WHERE Category = '.$Category['Id'].' ORDER BY Name');
  while($File = $DbResult2->fetch_assoc())
  {
    echo('<a href="'.$File['Location'].'">'.$File['Name'].'</a>');
    if($File['Description'] != '') echo(' - '.$File['Description']);
    echo('<br/>');
  }
  echo('<br/>');
}

?>
