2 <head><title>Infodrom Ticker</title></head>
3 <body bgcolor="#ffffff" text="#000000" vlink="#000090" alink="#e709f7" link="#1717ef">
4 <table width="100%" cellspacing="0" cellpadding="0" summary=""><tr><td align="center" valign="top" bgcolor="#0000ff"><a href="../../Infodrom/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Infodrom</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#00bdff"><a href="../../Linux/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Linux</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#ff4040"><a href="../../Debian/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Debian</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#ff7f00"><a href="../../linx/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Linx</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#ffd700"><a href="../../text/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Texte</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#ff00ff"><a href="../../service/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Service</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#ab82ff"><a href="../../zeitungen/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Zeitungen</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#32cd05"><a href="../../News/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>News</b></font></a></td><td width="1"> </td><td align="center" valign="top" bgcolor="#3cb371"><a href="../../projects/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Projekte</b></font></a></td></tr></table><table border="0" cellspacing="1" cellpadding="3" summary=""><tr bgcolor="#32cd05"><td align="center" valign="top">
5 <a href="../../News/ticker/" target="_top"><font color="#ffffff" face="Helvetica,Arial"><b>Ticker</b></font></a></td></tr></table>
8 $dbh = pg_pconnect ("kuolema", "5432", "web")
9 or die("Unable to connect to SQL server");
11 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
13 $query = "SELECT releasedate,ticker FROM ticker WHERE oid = '$ups'";
14 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
16 $date = date ("j.m.Y");
17 $ticker = "von Infodrom Oldenburg";
18 if (pg_NumRows ($sth) > 0) {
19 $row = pg_fetch_array ($sth, 0);
20 $date = explode (" ", $row['releasedate']);
21 $time = explode (":", $date[1]);
22 $date = explode ("-", $date[0]);
23 $date = sprintf ("%d.%d.%d %d:%d", $date[2], $date[1], $date[0], $time[0], $time[1]);
25 $tick['ticker-chip'] = "von CHIP Online";
26 $tick['ticker-firstlinux'] = "von FirstLinux";
27 $tick['ticker-gnn'] = "von Golem News";
28 $tick['ticker-internetnews'] = "von Internet News";
29 $tick['heise-ticker'] = "vom Heise Newsticker";
30 $tick['ticker-linuxcommunity'] = "von Linux-Community";
31 $tick['ticker-linuxde'] = "von Linux.de";
32 $tick['ticker-linuxmag'] = "vom Linux-Magazin";
33 $tick['ticker-linuxpr'] = "von LinuxPR";
34 $tick['ticker-linuxtoday'] = "von Linux Today";
35 $tick['ticker-lwn'] = "von Linux Weekly News";
36 $tick['ticker-prolinux'] = "von Pro Linux";
37 $tick['ticker-slashdot'] = "von Slashdot";
38 $tick['ticker-zdnet'] = "von ZDNet";
40 $ticker = $tick[$row['ticker']];
46 <h3 align="center"><font face="Helvetica,Arial"><? echo "Nachrichten $ticker am $date"; ?></font></h3>