3 $dbh = pg_pconnect ("kuolema", "5432", "web")
4 or die("Unable to connect to SQL server");
6 pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
8 $query = "SELECT url,ticker,releasedate,subject FROM ticker WHERE oid = '$ups'";
9 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
11 if (pg_NumRows ($sth) > 0) {
12 $row = pg_fetch_array ($sth, 0);
20 $title="title.php3?ups=$ups";
22 // if (strstr ($HTTP_USER_AGENT, "Lynx")) {
24 if (!strstr ($HTTP_USER_AGENT, "Mozilla")) {
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']];
41 if ($row['releasedate']) {
42 $date = explode (" ", $row['releasedate']);
43 $time = explode (":", $date[1]);
44 $date = explode ("-", $date[0]);
45 $date = sprintf ("%d.%d.%d %d:%d", $date[2], $date[1], $date[0], $time[0], $time[1]);
47 $date = date ("j.m.Y");
49 $link = sprintf ("<a href=\"%s\">%s</a>", $url, $row['subject']);
52 <head><title>Infodrom Ticker</title></head>
53 <body bgcolor="#ffffff" text="#000000" vlink="#000090" alink="#e709f7" link="#1717ef">
54 <table width="100%" cellspacing="0" cellpadding="0" summary=""><tr><td align="center" valign="top" bgcolor="#0000ff"><a href="../../Infodrom/"><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/"><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/"><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/"><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/"><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/"><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/"><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/"><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/"><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">
55 <a href="../../News/ticker/"><font color="#ffffff" face="Helvetica,Arial"><b>Ticker</b></font></a></td></tr></table>
56 <table border="0" cellpadding="0" cellspacing="5" width="100%" summary="">
58 <td valign="top" align="left" valign="top" width="10%" bgcolor="#eff0f1"><font face="helvetica,arial" size="-1" color="#008dfd">
59 <a href="index.php3">Index</a><br>
60 <a href="search.php3">Suche</a><br>
61 <a href="search.php3?ups=today">Heute</a><br>
62 <a href="search.php3?ups=yesterday">Gestern</a><br>
64 <td valign="top" width="1"></td>
65 <td valign="top" align="left" width="90%"><font face="helvetica,arial">
66 <h3>Infodrom: Latest Ticker News</h3>
69 <h1 align="center"><font face="Helvetica,Arial"><? echo "Nachrichten $ticker am $date"; ?></font><hr width="90%" align="center"></h1>
71 <h3 align="center"><font face="Helvetica,Arial"><? echo $link; ?></font></h3>
78 <address>© <a href="http://www.infodrom.ffis.de/">Infodrom Oldenburg</a>, Last modified: 19. Dezember 2000</address>
87 <frameset cols="100,*" border="0" framespacing="0" frameborder="no" marginheight="0" marginwidth="0">
88 <frame name="Links" scrolling="no" noresize marginheight="0" marginwidth="0" frameborder=no src="links.html" framespacing="0">
91 <frameset rows="80,*" bordercolor="#ffffff" border="0" framespacing="0" frameborder="no">
92 <frame name="Titel" scrolling="no" noresize marginheight="0" marginwidth="0" frameborder="no" SRC="<? echo $title; ?>" framespacing="0">
93 <frame name="Inhalt" noresize marginheight="0" marginwidth="0" frameborder="1" scrolling="auto" src="<? echo $url; ?>" framespacing="0">