#include <infodrom.style>
-<page title="Infodrom Oldenburg - Ticker">
-
-<headline "Ticker">
+<page func="Infodrom Oldenburg" title="Ticker">
<?
if ($oid > 0) {
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {
$row = pg_fetch_array ($sth, 0);
+
+ $foo = explode (" ", $row['releasedate']);
+ $row['releasedate'] = $foo[0];
+ $foo = explode (":", $foo[1]);
+ $row['releasedate'] .= " ". $foo[0] . ":". $foo[1];
}
} else {
$row['releasedate'] = date ("Y-m-j H:i");
sel ($row['ticker'], "ticker-firstlinux", "FirstLinux");
sel ($row['ticker'], "ticker-gnn", "Golem Network News");
sel ($row['ticker'], "ticker-internetnews", "Internet News");
- sel ($row['ticker'], "heise-ticker", "Heise Newsticker");
+ sel ($row['ticker'], "ticker-heise", "Heise Newsticker");
sel ($row['ticker'], "ticker-linuxcommunity", "Linux-Community");
sel ($row['ticker'], "ticker-linuxde", "Linux.de");
sel ($row['ticker'], "ticker-linuxmag", "Linux-Magazin");
#include <infodrom.style>
#include "ticker.inc"
-<page title="Infodrom Oldenburg - Ticker">
-
-<headline "Ticker">
+<page func="Infodrom Oldenburg" title="Ticker">
<listform>
#include <infodrom.style>
#include "ticker.inc"
-<page title="Infodrom Oldenburg - Ticker">
+<page func="Infodrom Oldenburg" title="Ticker">
-<headline "Ticker">
-
-<table width=100% border=1 cellspacing=0 cellpadding=0>
-<tr>
+<table width=100% border=0 cellspacing=0 cellpadding=0>
+<tr bgcolor=#<colh>>
<th width=10%><font face="Helvetica,Arial">Datum</font></th>
<th width=15%><font face="Helvetica,Arial">Quelle</font></th>
<th width=75%><font face="Helvetica,Arial">Titel</font></th>
</tr>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
$tick['ticker-firstlinux'] = "FirstLinux";
$tick['ticker-gnn'] = "Golem Network";
$tick['ticker-internetnews'] = "Internet News";
- $tick['heise-ticker'] = "Heise";
+ $tick['ticker-heise'] = "Heise";
$tick['ticker-linuxcommunity'] = "Linux-Community";
$tick['ticker-linuxde'] = "Linux.de";
$tick['ticker-linuxmag'] = "Linux-Magazin";
$tick['ticker-slashdot'] = "Slashdot";
$tick['ticker-zdnet'] = "ZDNet";
+ $color = "<cold>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$date = explode (" ", $row['releasedate']);
$date = explode ("-", $date[0]);
$date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+ $color = $color=="<cold>"?"<coln>":"<cold>";
- printf ("<tr><td><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $date);
- printf ("<td align=\"center\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $tick[$row['ticker']]);
+ printf ("<tr bgcolor=\"#%s\"><td align=\"right\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>", $color, $date);
+ printf ("<td align=\"center\"><font size=\"-1\" face=\"Helvetica,Arial\">%s</font></td>",
+ strlen ($tick[$row['ticker']])?$tick[$row['ticker']]:" ");
printf ("<td><font size=\"-1\" face=\"Helvetica,Arial\"><a href=\"show.php3?oid=%d\">%s</a></font></td></tr>",
$row['oid'], $row['subject']);
}
#include <infodrom.style>
-<page title="Infodrom Oldenburg - Ticker">
-
-<headline "Ticker">
+<page func="Infodrom Oldenburg" title="Ticker">
<?
if ($oid > 0) {
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
$ticker['ticker-chip'] = "CHIP Online";
$ticker['ticker-firstlinux'] = "FirstLinux";
$ticker['ticker-gnn'] = "Golem Network News";
- $ticker['heise-ticker'] = "Heise Newsticker";
+ $ticker['ticker-heise'] = "Heise Newsticker";
$ticker['ticker-linuxcommunity'] = "Linux-Community";
$ticker['ticker-linuxde'] = "Linux.de";
$ticker['ticker-linuxmag'] = "Linux-Magazin";
<font face="Helvetica,Arial">
<b><? echo $date; ?></b><p>
-<b><? printf ("<a href=\"http://www.infodrom.ffis.de/ticker/?ups=%d\">%s</a>", $oid, $row['url']); ?></b><p>
+<b><? printf ("Jump to <a href=\"http://www.infodrom.ffis.de/ticker/?ups=%d\">%s</a>", $oid, $row['url']); ?></b><p>
<? echo $row['body']; ?>
-<a href="<root_prefix>Infodrom/">Infodrom</a><br>
+<strong>Menu</strong><br>
-<a href="<root_prefix>Infodrom/news/">News</a><br>
+ <menu-item base=index text=Index href=index.html><br>
-<a href="<root_prefix>Infodrom/patches/">Patches</a><br>
+<line height=2>
-<a href="<root_prefix>Infodrom/todo/">Todo</a><br>
-
-<ifneq <get-var WML_SRC_BASENAME> "index"
- <a href="index.html">Ticker</a>
- Ticker
-><br>
-
-<a href="<root_prefix>Infodrom/zeitungen/">Zeitungen</a><br>
-
-<a href="<root_prefix>Infodrom/linx/">Linx</a><br>
-
-#<a href="<root_prefix>Infodrom/telefon/">Telefon</a><br>
-
-<a href="http://www.infodrom.ffis.de/">Homepage</a><br>
-
-# Local variables:
-# mode: indented-text
-# mode: auto-fill
-# mode: iso-accents
-# end:
+#include "../functions.inc" prefix="../"
#include <infodrom.style>
#include <phptools.inc>
-<page title="Infodrom Oldenburg - Ticker">
-
-<headline "Ticker">
+<page func="Infodrom Oldenburg" title="Ticker">
<sql_prepare>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
<: