Erfolgreich nach php konvertiert

diff --git a/src/Infodrom/patches/index.wml b/src/Infodrom/patches/index.wml
new file mode 100644 (file)
index 0000000..b557ef6
--- /dev/null
+++ b/src/Infodrom/patches/index.wml
@@ -0,0 +1,57 @@
+#include <infodrom.style>
+#include <patches.style>
+
+<page title="Infodrom Oldenburg - Patches">
+
+<h1 align=center><font face="Helvetica,Arial">Infodrom Oldenburg</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Patches -</font></h3>
+
+<font face="Helvetica,Arial">
+In this area you'll find the collection of patches developed at
+Infodrom Oldenburg.  Some of them were developed for customers, others
+ofr free projects or for our own use.  Since they are addition to Free
+Software, they are published.<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 patches ORDER by package,submitted,version";
+  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+  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]);
+
+?>
+
+<table width=100% border=1 cellpadding=2 cellspacing=0>
+<tr>
+<td width=70% align=left><font face="Helvetica,Arial"><b><? echo $date . ": " . $row['subject']; ?></b></font></td>
+<td width=20% align=left><font face="Helvetica,Arial"><b><? echo $row['package']; ?></b></font></td>
+<td width=10% align=left><font face="Helvetica,Arial"><? echo $row['version']; ?></font></td>
+</tr>
+
+<tr>
+<td colspan=3 width=100%><font face="Helvetica,Arial"><? echo $row['description']; ?><br>
+Download: <? echo $row['download']; ?>
+</font></td>
+</tr>
+</table><p>
+
+<?
+  }
+?>
+
+</page>
+
+# Local variables:
+# mode: html
+# mode: auto-fill
+# mode: iso-accents
+# end:

diff --git a/src/Infodrom/patches/submenu.inc b/src/Infodrom/patches/submenu.inc
new file mode 100644 (file)
index 0000000..61b957f
--- /dev/null
+++ b/src/Infodrom/patches/submenu.inc
@@ -0,0 +1,28 @@
+<a href="/">Home</a><br>
+
+<a href="../history.html">Historie</a><br>
+
+<a href="../goal.html">Ziel</a><br>
+
+<a href="../network.html">Netzwerk</a><br>
+
+<a href="../services.html">Services</a><br>
+
+<a href="../policy.html">Policy</a><br>
+
+<a href="../rechner.html">Rechner</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>
+  Patches
+><br>
+
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode: iso-accents
+# end: