#include <infodrom.style>
#include <db.style>

<page title="Infodrom Oldenburg - Patches">

<h1 align=center>Infodrom Oldenburg</h1>
<h3 align=center>&mdash; All Patches &mdash;</h3>

<?
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
		or die("Unable to connect to SQL server");

  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  $query = "SELECT * FROM patches ORDER by package,submitted";
  $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");

  $package = '';
  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    $date = explode (" ", $row['submitted']);
    $date = explode ("-", $date[0]);
    $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
    $download = implode (explode ("
", $row['download']), ", ");

    if ($package != $row['package']) {
      printf ("<h3><font face=\"<infodrom-font />\">%s</font></h3>", $row['package']);
      $package = $row['package'];
    }
?>

<table width=100% class=blueborder cellpadding=0 cellspacing=0>

<tr bgcolor=<colh>>
<th width=70% align=left><b><? echo $date . ": " . $row['subject']; ?></b></th>
<th width=20% align=left><b><? echo $row['package']; ?></b></th>
<th width=10% align=right><? echo $row['version']; ?></th>
</tr>

<tr>
<td colspan=3 width=100%><? echo $row['description']; ?></td>
</tr>

<tr bgcolor=<cold>>
<td colspan=3 width=100%>Download: <? echo $download; ?></td>
</tr>

</table>

<?
  }
?>

</page>

# Local variables:
# mode: html
# mode: auto-fill
# mode: iso-accents
# end: