Пример #1
0
     case 'all_local':
     default:
         $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 (!$_REQUEST['q'] && empty($_REQUEST['category']) && empty($_REQUEST['meta']) && empty($_REQUEST['personal'])) {
     if ($status == 'published') {
         $globals['main_published_rss'] = true;
     }
     check_redirect_to_feedburner($status);
 }
 /*****  END WARNING ******/
 if ($status == 'all' || $status == 'all_local') {
     $from_where = "FROM links WHERE link_status in  ('published', 'queued') AND link_date > date_sub(now(), interval 7 day) ";
 } else {
     $from_where = "FROM links WHERE link_status='{$status}' AND link_date > date_sub(now(), interval 7 day) ";
 }
 // Check if it's search
 if ($_REQUEST['q']) {
     if ($search) {
         $from_where = "FROM links WHERE {$search} ";
     } else {
         $from_where .= "AND false";
         // Force to return empty set
     }
Пример #2
0
        $from_time = "AND comment_date > FROM_UNIXTIME({$if_modified})";
    } else {
        $from_time = "AND comment_date > date_sub(now(), interval 2 day)";
    }
    $sql = "SELECT comment_id FROM comments, sub_statuses WHERE id = {$site_id} AND link = comment_link_id {$from_time} ORDER BY comment_date DESC LIMIT {$rows}";
    $last_modified = $db->get_var("SELECT UNIX_TIMESTAMP(comment_date) FROM comments ORDER BY comment_date DESC LIMIT 1");
    $title = $globals['site_name'] . ': ' . _('comentarios');
    $globals['redirect_feedburner'] = false;
}
/*****  WARNING
		this function is to redirect to feed burner
		comment it out
		You have been warned
	***/
if (!$search) {
    check_redirect_to_feedburner();
}
/****
	END WARNING ******/
if (!empty($sql)) {
    $comments = $db->get_col($sql);
}
if (!$comments && $if_modified) {
    header('HTTP/1.1 304 Not Modified');
    exit;
}
do_header($title);
if ($comments) {
    foreach ($comments as $comment_id) {
        $comment = Comment::from_db($comment_id);
        if (!$comment) {