#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Patches">

<?
  $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 oid,package,version,subject,submitted FROM patches ORDER BY package,submitted";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ("<table width=\"100%\" class=\"smallfont border\" cellspacing=\"1\" summary=\"\">");
    echo ("<tr class=\"head\"><th width=\"15%\"><font face=\"Helvetica,Arial\">Paket</font></th>");
    echo ("<th width=\"15%\"><font face=\"Helvetica,Arial\">Version</font></th>");
    echo ("<th width=\"10%\"><font face=\"Helvetica,Arial\">Datum</font></th>");
    echo ("<th width=\"60%\"><font face=\"Helvetica,Arial\">Subject</font></th></tr>");
  }

  $color = 0;
  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]);

    printf ("<tr class=\"t%d\"><td align=\"left\" width=\"15%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $color, $row['package']);
    printf ("<td align=\"left\" width=\"15%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $row['version']);
    printf ("<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $date);
    printf ("<td align=\"left\" width=\"60%%\"><font face=\"Helvetica,Arial\"><a href=\"edit.php?id=%d\">%s</a></font></th></tr>",
      $row['oid'], $row['subject']);
    $color = !$color;
  }
  if (pg_NumRows ($sth) > 0) {
    echo ("</table>");
  }
?>

</table>

</page>

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