Geeklog Forums

$results = db_query("select * from ".$_DB_table_prefix."syndication WHERE is_enabled = 1 ORDER BY format, title",1);
$rows = DB_numRows($results);
$display ="<table>";
$display .= '<tr><td colspan="2">';
$display .= "<p><br>This page contains a list of active RDF/RSS news feeds as well as mobile channels that can be used by Avantgo and similar services. Our Avantgo channels are also suitable for online browsing on small screens.<p><br><br>";
$display .= "</td></tr>";

for ($i=0; $i< $rows; $i++) {
    $row = DB_fetchArray($results) ;

    $pfx = "Channel " ;
    $color = '<font color="red">';
    $fmt = $row['format'];
    if ( strcmp( $fmt, "avantgo") ) {
        $pfx = "Feed ";
        $color = '<font color="blue">';
    }

    $maxa = $row['limits'] ;
    if ( $maxa == 0 ) {
        $maxm = "";
    } else {
        $maxm = " (max. " . $maxa . ' articles)';
    }

    $display .= '<tr><td colspan="2" bgcolor="#DDDDDD"><b>'.$row['title']."</b></td></tr>";
    $fspec = $_CONF['site_url'] . '/backend/' . $row['filename'];
    $flink = '<a href="'.$fspec.'">' . $fspec . '</a>';
    $display .= '<tr><td width="20%" valign="top">' . $color  . strtoupper($row['format']) . '</font></td><td>' .$row['description']  . $maxm . '</td></tr>';
    $display .= '<tr><td>' . $pfx . 'URL: </td><td>' . $flink.'</td></tr>';
    $display .= '<tr><td colspan="2"> </td></tr>';
}
$display .= "</table>";

return $display;