1 #include <infodrom.style>
4 <page title="Infodrom Oldenburg - Patches">
6 <h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
7 <h3 align=center><font face="Helvetica,Arial">- All Patches -</font></h3>
10 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
11 or die("Unable to connect to SQL server");
13 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
15 $query = "SELECT * FROM patches ORDER by package,submitted";
16 $sth = pg_exec ($dbh, $query); // or die("Datenbank-Abfrage!");
19 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
20 $row = pg_fetch_array ($sth, $nr);
21 $date = explode (" ", $row['submitted']);
22 $date = explode ("-", $date[0]);
23 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
24 $download = implode (explode ("
25 ", $row['download']), ", ");
27 if ($package != $row['package']) {
28 printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['package']);
29 $package = $row['package'];
33 <border color=<box-bdcolor>>
35 <table width=100% border=0 cellpadding=1 cellspacing=0>
37 <th width=70% align=left><font face="Helvetica,Arial"><b><? echo $date . ": " . $row['subject']; ?></b></font></t>
38 <th width=20% align=left><font face="Helvetica,Arial"><b><? echo $row['package']; ?></b></font></th>
39 <th width=10% align=right><font face="Helvetica,Arial"><? echo $row['version']; ?></font></th>
43 <td colspan=3 width=100%><font face="Helvetica,Arial"><? echo $row['description']; ?></font></td>
47 <td colspan=3 width=100%><font face="Helvetica,Arial">Download: <? echo $download; ?></font></td>