Posted on: 04/09/04 02:25pm
By: jmichael
$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;