From 9f1374e2f52a24ff8829a752e886e949452554a3 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Sun, 3 Sep 2000 17:42:00 +0000
Subject: [PATCH] Erfolgreich nach php konvertiert

---
 src/Infodrom/patches/index.wml   | 57 ++++++++++++++++++++++++++++++++
 src/Infodrom/patches/submenu.inc | 28 ++++++++++++++++
 2 files changed, 85 insertions(+)
 create mode 100644 src/Infodrom/patches/index.wml
 create mode 100644 src/Infodrom/patches/submenu.inc

diff --git a/src/Infodrom/patches/index.wml b/src/Infodrom/patches/index.wml
new file mode 100644
index 00000000..b557ef6b
--- /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
index 00000000..61b957f0
--- /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:
-- 
2.20.1