. // 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('config.php'); include(mnminclude.'link.php'); include(mnminclude.'geo.php'); require_once(mnminclude.'thumbnails.php'); if(!empty($_REQUEST['rows'])) { $rows = intval($_REQUEST['rows']); if ($rows > 200) $rows = 50; //avoid abuses } else $rows = 50; // Bug in FeedBurner, it needs all items if (preg_match('/feedburner/i', $_SERVER['HTTP_USER_AGENT'])) { $if_modified = 0; } else { $if_modified = get_if_modified(); } if(!empty($_REQUEST['time'])) { ///// // Prepare for times ///// if(!($time = check_integer('time'))) die; $sql = "SELECT link_id, link_votes as votes FROM links WHERE "; if ($time > 0) { $from = time()-$time; $sql .= "link_date > FROM_UNIXTIME($from) AND "; } $sql .= "link_status != 'discard' ORDER BY link_votes DESC LIMIT $rows"; $last_modified = time(); $title = _('Menéame: más votadas en') . ' ' . txt_time_diff($from); } elseif (!empty($_REQUEST['favorites'])) { ///// // RSS for users' favorites ///// $user_id = guess_user_id($_REQUEST['favorites']); $sql = "SELECT link_id FROM links, favorites WHERE favorite_user_id=$user_id AND favorite_link_id=link_id ORDER BY favorite_date DESC limit $rows"; $last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(max(favorite_date)) from favorites where favorite_user_id=$user_id"); $user_login = $db->get_var("select user_login from users where user_id=$user_id"); $title = _('Menéame: favoritas de') . ' ' . $user_login; $globals['show_original_link'] = true; $globals['redirect_feedburner'] = false; } elseif (!empty($_REQUEST['friends_of'])) { ///// // RSS for users' friends ///// $user_id = guess_user_id($_REQUEST['friends_of']); $sql = "SELECT link_id FROM links, friends WHERE friend_type='manual' and friend_from = $user_id and friend_to=link_author and friend_value > 0 and link_status != 'discard' ORDER BY link_date DESC limit $rows"; $last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(link_date) FROM links, friends WHERE friend_type='manual' and friend_from = $user_id and friend_to=link_author and friend_value > 0 and link_status != 'discard' ORDER BY link_date DESC limit 1"); $user_login = $db->get_var("select user_login from users where user_id=$user_id"); $title = _('Menéame: amigos de') . ' ' . $user_login; $globals['show_original_link'] = false; $globals['redirect_feedburner'] = false; } elseif (!empty($_REQUEST['sent_by'])) { ///// // RSS for users' sent links ///// $user_id = guess_user_id($_REQUEST['sent_by']); $sql = "SELECT link_id FROM links WHERE link_author=$user_id ORDER BY link_id DESC limit $rows"; $last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(max(link_date)) from links where link_author=$user_id"); $user_login = $db->get_var("select user_login from users where user_id=$user_id"); $title = _('Menéame: noticias de') . ' ' . $user_login; $globals['show_original_link'] = false; $globals['redirect_feedburner'] = false; } else { ///// // All the others ///// $search = get_search_clause('boolean'); // The link_status to search if(!empty($_REQUEST['status'])) { $status = $db->escape(clean_input_string(trim($_REQUEST['status']))); } else { // By default it searches on all if($search) $status = 'all'; else $status = 'published'; } switch ($status) { case 'published': $order_field = 'link_published_date'; $link_date = 'published_date'; $title = _('Menéame: publicadas'); break; case 'queued': $title = _('Menéame: en cola'); $order_field = 'link_date'; $link_date = "date"; $home = "/shakeit.php"; // disable feedburner for queued $globals['redirect_feedburner'] = false; break; case 'all': case 'all_local': $title = _('Menéame: todas'); $order_field = 'link_date'; $link_date = "date"; break; } /***** WARNING this function is to redirect to feed burner comment it out You have been warned ******/ if (!$search && empty($_REQUEST['category']) && empty($_REQUEST['meta'])) { check_redirect_to_feedburner($status); } /***** END WARNING ******/ if($status == 'all' || $status == 'all_local') { $from_where = "FROM links WHERE link_status in ('published', 'queued') "; } else { $from_where = "FROM links WHERE link_status='$status' "; } if(($meta=check_integer('meta'))) { $cat_list = meta_get_categories_list($meta); $from_where .= " AND link_category in ($cat_list)"; $meta_name = $db->get_var("SELECT category_name FROM categories WHERE category_id = $meta AND category_parent=0"); $title .= " -$meta_name-"; } elseif(($cat=check_integer('category'))) { $from_where .= " AND link_category=$cat "; $category_name = $db->get_var("SELECT category_name FROM categories WHERE category_id = $cat AND category_lang='$dblang'"); $title .= " -$category_name-"; } if($search) { $from_where .= "AND $search"; $title = _('Menéame') . ": " . htmlspecialchars(strip_tags($_REQUEST['search'])); } $order_by = " ORDER BY $order_field DESC "; $last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(max($order_field)) links $from_where"); if ($if_modified > 0) { $from_where .= " AND $order_field > FROM_UNIXTIME($if_modified)"; } $sql = "SELECT link_id $from_where $order_by LIMIT $rows"; } do_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 categories WHERE category_id = $link->category AND category_lang='$dblang'"); $content = text_to_html($link->content); echo " \n"; // Title must not carry htmlentities echo " ".htmlentities2unicodeentities($link->title)."\n"; echo " ".$link->get_permalink()."\n"; echo " ".$link->get_permalink()."\n"; if (!empty($link_date)) echo " ".date("r", $link->$link_date)."\n"; else echo " ".date("r", $link->date)."\n"; echo " $link->username\n"; echo " \n"; // Add tags as categories if (!empty($link->tags)) { $tags_array = explode(",", $link->tags); foreach ($tags_array as $tag_item) { $tag_item=trim($tag_item); echo " \n"; } } echo " ".$link->get_permalink()."\n"; // Insert GEO if (($latlng = geo_latlng('link', $link->id))) { echo " $latlng->lat $latlng->lng\n"; } echo ' image)) { $thumb_url = get_thumbnails_url() . $link->image . '.' . '120.jpeg'; // real thumb if ( thumbnail_file_exists ($thumb_url) ) { $showImage = ''; } } // In case of meta, only sends votes and karma // developed for alianzo.com echo '

'.$showImage.$content.'

'; if (time() - $link->date < 172800) { // Only add the votes/comments image if the link has less than two days echo '

votes

'; } if ($link->status == 'published' || $globals['show_original_link']) { echo "

» "._('noticia original')."

"; } echo "]]>\n"; //echo ''.$link->comments().''; // echo " ".get_trackback($link->id)."\n"; // no standard //echo "\n"; echo 'http://'.get_server_name().$globals['base_url'].'comments_rss2.php?id='.$link->id.''; echo " \n\n"; } } do_footer(); function do_header($title) { global $if_modified, $last_modified, $dblang, $home, $globals; if (!$last_modified > 0) { if ($if_modified > 0) $last_modified = $if_modified; else $last_modified = time(); } if ($last_modified <= $if_modified) { header('HTTP/1.1 304 Not Modified'); exit(); } header('Last-Modified: ' . gmdate('D, d M Y H:i:s', $last_modified) . ' GMT'); header('Content-type: text/xml; charset=UTF-8', true); echo '' . "\n"; echo ''. "\n"; echo ''."\n"; echo' '.$title.''."\n"; echo' http://'.get_server_name().$home.''."\n"; echo" ".get_server_name()."http://".get_server_name().$home."http://".get_server_name().$globals['base_url']."img/es/logo02.png\n"; echo' '._('Sitio colaborativo de publicación y comunicación entre blogs').''."\n"; echo' '.date("r", $last_modified).''."\n"; echo' http://pixelame.net/'."\n"; echo' '.$dblang.''."\n"; } function do_footer() { echo "\n\n"; } function check_redirect_to_feedburner($status) { global $globals; if (isset($_REQUEST['local']) || !$globals['redirect_feedburner'] || preg_match('/feedburner/', htmlspecialchars($_SERVER['PHP_SELF'])) || preg_match('/feedburner/i', $_SERVER['HTTP_USER_AGENT']) ) return; /*|| preg_match('/technoratibot/i', $_SERVER['HTTP_USER_AGENT']) */ switch ($status) { case 'published': header("Location: http://feeds.feedburner.com/meneame/published"); exit(); break; case 'queued': header("Location: http://feeds.feedburner.com/meneame/queued"); exit(); break; case 'all': header("Location: http://feeds.feedburner.com/meneame/all"); exit(); break; } } ?>