1 #include <infodrom.style>
2 #include <patches.style>
4 <page title="Infodrom Oldenburg - Todo">
6 <h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
7 <h3 align=center><font face="Helvetica,Arial">- Todo -</font></h3>
9 <font face="Helvetica,Arial">
10 I've begun collecting jobs with regard to Free Software that would
11 help improve the particular package or an entire system or make it
14 Since our time is short and Joey keeps being too busy, you're invited
15 to pick up a particular job and send in patches. For most of the
16 packages you can use the <a href="http://bugs.debian.org/">Debian Bug
17 Tracking System</a> since Debian contains all software. The
18 maintainer will forward it upstream.<p>
22 $dbh = pg_pconnect ("kuolema", "5432", "<db>")
23 or die("Unable to connect to SQL server");
25 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
27 $query = "SELECT * FROM todo WHERE done is NULL ORDER by package,submitted";
28 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
31 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
32 $row = pg_fetch_array ($sth, $nr);
33 $date = explode (" ", $row['submitted']);
34 $date = explode ("-", $date[0]);
35 $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
37 if ($package != $row['package']) {
38 printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['package']);
39 $package = $row['package'];
43 <table width=100% border=1 cellpadding=2 cellspacing=0>
45 <th width=90% align=left><font face="Helvetica,Arial"><? echo $row['subject']; ?></font></t>
46 <th width=10% align=right><font face="Helvetica,Arial"><? echo $date; ?></font></th>
50 <td colspan=3 width=100%><font face="Helvetica,Arial"><? echo $row['description']; ?></font></td>
58 <a href="done.php3">done</a><p>