Current version - Mit php-fortunes

[infodrom.org/www.infodrom.org] / src / index.html.en.wml

diff --git a/src/index.html.en.wml b/src/index.html.en.wml
index 61e0c7a..3c4fe95 100644 (file)
--- a/src/index.html.en.wml
+++ b/src/index.html.en.wml
@@ -25,7 +25,7 @@
 
 <: main_menu (('Infodrom','Linux','Debian','Linx','Projects','News')); :>
 
-<p><center><quotebox-en-shtml index-fortune.html></center>
+<p><center><quotebox-en-php index-fortune.html></center>
 
 <:
   %specials = ('zeitungen/'                        => 'Newspapers',
@@ -57,10 +57,60 @@
 
 </font></blockquote>
 
+<?
+
+  function newstab ()
+  {
+    $dbh = pg_pconnect ("kuolema", "5432", "web")
+                or die("Unable to connect to SQL server");
+
+  #  pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+    $query = "SELECT oid,ticker,subject FROM ticker ORDER BY releasedate DESC";
+    $sth = pg_exec ($dbh, $query);
+
+    $tick['ticker-chip'] = "CHIP Online";
+    $tick['ticker-firstlinux'] = "FirstLinux";
+    $tick['ticker-gnn'] = "Golem Network News";
+    $tick['heise-ticker'] = "Heise";
+    $tick['ticker-linuxcommunity'] = "Linux-Community";
+    $tick['ticker-linuxde'] = "Linux.de";
+    $tick['ticker-linuxmag'] = "Linux-Magazin";
+    $tick['ticker-linuxpr'] = "LinuxPR";
+    $tick['ticker-linuxtoday'] = "Linux Today";
+    $tick['ticker-lwn'] = "Linux Weekly News";
+    $tick['ticker-prolinux'] = "Pro Linux";
+    $tick['ticker-slashdot'] = "Slashdot";
+    $tick['ticker-zdnet'] = "ZDNet";
+
+    if ($sth) {
+      $count=0;
+      for ($nr=0; $nr < pg_NumRows ($sth) && $count < 10; $nr++) {
+       $row = pg_fetch_array ($sth, $nr);
+
+       printf ("<tr><td width=\"20%%\" align=\"center\" valign=\"top\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>",
+               $tick[$row['ticker']]);
+       printf ("<td width=\"80%%\" align=\"left\" valign=\"top\"><font size=\"-1\" face=\"Helvetica,Arial\"><a href=\"ticker/?ups=%d\">%s</a></font></td></tr>",
+               $row['oid'], $row['subject']);
+       $count++;
+      }
+    }
+  }
+?>
+
+<center>
+<box header="<font size=-1 face="Helvetica,Arial" color="#<box-fgcolor>"><b>Latest News</b></font>"
+     bdcolor="#<box-bdcolor>" bdwidth=2 bdspace=5
+     bgcolor="#<box-bgcolor>">
+  <table width=100% border=0 cellpadding=1 cellspacing=0><? newstab (); ?></table>
+</box>
+</center>
+
 <table width=100% border=0>
 <tr>
   <td align=left valign=top>
-     <a href="http://www.linuxtag.org/"><img src="/gifs/button/lt2kblue.gif" alt="LinuxTag 2000" border=0></a>
+#     <a href="http://www.linuxtag.org/"><img src="/gifs/button/lt2kblue.gif" alt="LinuxTag 2000" border=0></a>
+     <font face="Helvetica,Arial"><a href="http://oldenburger.linuxtage.de/"><b>Oldenburger LinuxTag</b></a></font>
   </td>
   <td align=right valign=top>
      <a href="http://www.linux.org/"><img src="/gifs/button/powered_by_linux.gif" alt="Powered by Linux" border=0></a>