.
// It's licensed under the AFFERO GENERAL PUBLIC LICENSE unless stated otherwise.
// You can get copies of the licenses here:
// http://www.affero.org/oagpl.html
// AFFERO GENERAL PUBLIC LICENSE is also included in the file called "COPYING".
include_once('Smarty.class.php');
$main_smarty = new Smarty;
include('config.php');
include(mnminclude.'link.php');
include(mnminclude.'html1.php');
include(mnminclude.'search.php');
include_once(mnminclude.'smartyvariables.php');
if(!empty($_REQUEST['rows']))
$rows = $_REQUEST['rows'];
else $rows = 40;
if(!empty($_REQUEST['time'])) {
// Prepare for times
if(!($time = check_integer('time')))
die;
$sql = "SELECT link_id, count(*) as votes FROM " . table_votes . ", " . table_links . " WHERE ";
if ($time > 0) {
$from = time()-$time;
$sql .= "vote_date > FROM_UNIXTIME($from) AND ";
}
$sql .= "vote_link_id=link_id AND link_status != 'discard' GROUP BY vote_link_id ORDER BY votes DESC LIMIT $rows";
$last_modified = time();
$title = $main_smarty->get_config_vars('PLIGG_Visual_RSS_Recent') . ' ' . txt_time_diff($from);
$link_date = "";
} else {
// All the others
$tmpsearch = new Search;
$tmpsearch->searchTerm = sanitize($_REQUEST['search'], 3);
$search = $tmpsearch->get_search_clause();
// The link_status to search
if(!empty($_REQUEST['status'])) {
$status = $_REQUEST['status'];
} else {
// By default it searches on all
if($search) $status = 'published';
else $status = 'published';
}
switch ($status) {
case 'published':
$order_field = 'link_published_date';
$link_date = 'published_date';
$title = " / " . $main_smarty->get_config_vars("PLIGG_Visual_Published_News");
break;
case 'queued':
$title = " / " . $main_smarty->get_config_vars("PLIGG_Visual_Pligg_Queued");
$order_field = 'link_date';
$link_date = "date";
break;
case 'all':
$title = "";
$order_field = 'link_date';
$link_date = "date";
break;
}
if($status == 'all') {
$from_where = "FROM " . table_links . " WHERE link_status!='discard' ";
} else {
$from_where = "FROM " . table_links . " WHERE link_status='$status' ";
}
if(($cat=check_integer('category'))) {
$from_where .= " AND link_category=$cat ";
$category_name = $db->get_var("SELECT category_name FROM " . table_categories . " WHERE category_id = $cat AND category_lang='$dblang'");
$title .= " / " . htmlspecialchars($category_name);
}
// This doesn't seem to work -kb
if($search) {
$from_where .= $search;
$title = htmlspecialchars($_REQUEST['search']);
}
$order_by = " ORDER BY $order_field DESC ";
$last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(max($order_field)) links $from_where");
$sql = "SELECT link_id $from_where $order_by LIMIT $rows";
}
do_rss_header($title);
$link = new Link;
$links = $db->get_col($sql);
if ($links) {
foreach($links as $link_id) {
$link->id=$link_id;
$link->read();
$category_name = $db->get_var("SELECT category_name FROM " . table_categories . " WHERE category_id = $link->category AND category_lang='$dblang'");
$link->link_summary = str_replace("\n", "
", $link->content);
$link->link_summary = str_replace("’", "'", $link->link_summary);
$link->link_summary = str_replace("–", "-", $link->link_summary);
$link->link_summary = str_replace("—", "-", $link->link_summary);
$link->link_summary = str_replace("“", "\"", $link->link_summary);
$link->link_summary = str_replace("”", "\"", $link->link_summary);
$description = $link->link_summary;
$description = strip_tags($description);
$description = htmlspecialchars($description);
$title = $link->title;
$title = strip_tags($title);
$title = htmlspecialchars($title);
$link->title = str_replace("á", "a", $link->title);
$link->title = str_replace("é", "e", $link->title);
$link->title = str_replace("í", "i", $link->title);
$link->title = str_replace("ó", "o", $link->title);
$link->title = str_replace("ú", "u", $link->title);
$link->title = str_replace("ñ", "n", $link->title);
$link->title = str_replace("Á", "A", $link->title);
$link->title = str_replace("É", "E", $link->title);
$link->title = str_replace("Í", "I", $link->title);
$link->title = str_replace("Ó", "O", $link->title);
$link->title = str_replace("Ú", "U", $link->title);
$link->title = str_replace("¿", "", $link->title);
$link->title = str_replace("Ñ", "N", $link->title);
echo "- \n";
echo "<![CDATA[". $title . "]]>\n";
echo "".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."\n";
echo "".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."\n";
if (!empty($link_date))
echo "".date('D, d M Y H:i:s T', $link->$link_date)."\n";
else
echo "".date('D, d M Y H:i:s T', time())."\n";
echo "$link->username\n";
echo "" . htmlspecialchars($category_name) . "\n";
echo "".getmyFullurl("storyURL", $link->category_safe_name($link->category), urlencode($link->title_url), $link->id)."\n";
echo "
".$link->votes." ".$main_smarty->get_config_vars('PLIGG_Visual_RSS_Votes')." ]]>\n";
echo " \n\n";
}
}
do_rss_footer();
function do_rss_header($title) {
global $last_modified, $dblang, $main_smarty;
header('Content-type: text/xml; charset=utf-8', true);
echo '' . "\n";
echo ''. "\n";
echo ''."\n";
echo ''.$main_smarty->get_config_vars("PLIGG_Visual_Name").$title.''."\n";
echo ''.my_base_url.my_pligg_base.''."\n";
echo ''.$main_smarty->get_config_vars("PLIGG_Visual_RSS_Description").' '.$link->votes.' votes'."\n";
echo ''.date('D, d M Y H:i:s T', $last_modified).''."\n";
echo ''.$dblang.''."\n";
}
function do_rss_footer() {
echo "\n\n";
}
function onlyreadables($string) {
for ($i=0;$i126) {
$chr = "~";
$string{$i} = $chr;
}
}
return str_replace("~", "", $string);
}
?>