Todo-Liste hinzugefuegt

diff --git a/src/Infodrom/patches/submenu.inc b/src/Infodrom/patches/submenu.inc
index 61b957f..8371509 100644 (file)
--- a/src/Infodrom/patches/submenu.inc
+++ b/src/Infodrom/patches/submenu.inc
@@ -14,13 +14,15 @@
 
 <a href="../beitraege.html">Beiträge</a><br>
 
 
 <a href="../beitraege.html">Beiträge</a><br>
 

-<a href="http://www.ffis.de/">ffis e.V.</a><br>
-
-<ifneq <get-var WML_SRC_BASENAME> "patches"
-  <a href="index.html">Patches</a>
+<ifneq <get-var WML_SRC_BASENAME> "index"
+  <a href="index.php3">Patches</a>

   Patches
 ><br>
 
   Patches
 ><br>
 

+<a href="../todo/">Todo</a><br>
+
+<a href="http://www.ffis.de/">ffis e.V.</a><br>
+

 # Local variables:
 # mode: indented-text
 # mode: auto-fill
 # Local variables:
 # mode: indented-text
 # mode: auto-fill

diff --git a/src/Infodrom/submenu.inc b/src/Infodrom/submenu.inc
index 8c00f51..d4c0c37 100644 (file)
--- a/src/Infodrom/submenu.inc
+++ b/src/Infodrom/submenu.inc
@@ -42,6 +42,8 @@
 
   <a href="patches/">Patches</a><br>
 
 
   <a href="patches/">Patches</a><br>
 

+  <a href="todo/">Todo</a><br>
+

 <a href="http://www.ffis.de/">ffis e.V.</a><br>
 
 # Local variables:
 <a href="http://www.ffis.de/">ffis e.V.</a><br>
 
 # Local variables:

diff --git a/src/Infodrom/todo/done.wml b/src/Infodrom/todo/done.wml
new file mode 100644 (file)
index 0000000..95626d2
--- /dev/null
+++ b/src/Infodrom/todo/done.wml
@@ -0,0 +1,64 @@
+#include <infodrom.style>
+#include <patches.style>
+
+<page title="Infodrom Oldenburg - Todo">
+
+<h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Todo -</font></h3>
+
+<font face="Helvetica,Arial">
+I've begun collecting jobs with regard to Free Software that would
+help improve the particular package or an entire system or make it
+policy complient.<p>
+
+For some reason, maybe somebody found time, these jobs are done.
+</font>
+
+<?
+  $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+              or die("Unable to connect to SQL server");
+
+  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+  $query = "SELECT * FROM todo WHERE done is not NULL 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]);
+
+    $done = explode (" ", $row['sdone']);
+    $done = explode ("-", $done[0]);
+    $done = sprintf ("%d.%d.%d", $done[2], $done[1], $done[0]);
+
+    if ($package != $row['package']) {
+      printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['package']);
+      $package = $row['package'];
+    }
+?>
+
+<table width=100% border=1 cellpadding=2 cellspacing=0>
+<tr>
+<th width=90% align=left><font face="Helvetica,Arial"><? echo $row['subject']; ?></font></t>
+<th width=10% align=right><font face="Helvetica,Arial"><? echo $date; ?></font></th>
+</tr>
+
+<tr>
+<td colspan=3 width=100%><font face="Helvetica,Arial"><? echo $row['description'] . "<br>Done: " . $done; ?></font></td>
+</tr>
+</table><p>
+
+<?
+  }
+?>
+
+</page>
+
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode: iso-accents-
+# end:

diff --git a/src/Infodrom/todo/index.wml b/src/Infodrom/todo/index.wml
new file mode 100644 (file)
index 0000000..c2b2f90
--- /dev/null
+++ b/src/Infodrom/todo/index.wml
@@ -0,0 +1,65 @@
+#include <infodrom.style>
+#include <patches.style>
+
+<page title="Infodrom Oldenburg - Todo">
+
+<h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Todo -</font></h3>
+
+<font face="Helvetica,Arial">
+I've begun collecting jobs with regard to Free Software that would
+help improve the particular package or an entire system or make it
+policy complient.<p>
+
+Since our time is short and Joey keeps being too busy, you're invited
+to pick up a particular job and send in patches.  For most of the
+packages you can use the <a href="http://bugs.debian.org/">Debian Bug
+Tracking System</a> since Debian contains all software.  The
+maintainer will forward it upstream.<p>
+</font>
+
+<?
+  $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+              or die("Unable to connect to SQL server");
+
+  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+  $query = "SELECT * FROM todo WHERE done is NULL 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]);
+
+    if ($package != $row['package']) {
+      printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['package']);
+      $package = $row['package'];
+    }
+?>
+
+<table width=100% border=1 cellpadding=2 cellspacing=0>
+<tr>
+<th width=90% align=left><font face="Helvetica,Arial"><? echo $row['subject']; ?></font></t>
+<th width=10% align=right><font face="Helvetica,Arial"><? echo $date; ?></font></th>
+</tr>
+
+<tr>
+<td colspan=3 width=100%><font face="Helvetica,Arial"><? echo $row['description']; ?></font></td>
+</tr>
+</table><p>
+
+<?
+  }
+?>
+
+<a href="done.php3">done</a><p>
+</page>
+
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode-: iso-accents
+# end: