From: Andrew Dolgov Date: Mon, 13 Jul 2015 09:46:05 +0000 (+0300) Subject: Merge branch 'master' of git.fakecake.org:tt-rss X-Git-Tag: 16.3~232 X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=commitdiff_plain;h=4f9a3c0e0f995b5ad8eed5357df3d12beb8bee00 Merge branch 'master' of git.fakecake.org:tt-rss Conflicts: classes/pref/filters.php --- 4f9a3c0e0f995b5ad8eed5357df3d12beb8bee00 diff --cc classes/pref/filters.php index 6e8f4630,5e3c35b7..0e887c42 --- a/classes/pref/filters.php +++ b/classes/pref/filters.php @@@ -106,82 -108,47 +106,83 @@@ class Pref_Filters extends Handler_Prot print "
"; print ""; - while ($line = $this->dbh->fetch_assoc($result)) { - $line["content_preview"] = truncate_string(strip_tags($line["content"]), 100, '...'); + $glue = $filter['match_any_rule'] ? " AND " : "OR "; + $scope_qpart = join($glue, $scope_qparts); - foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_QUERY_HEADLINES) as $p) { - $line = $p->hook_query_headlines($line, 100); - } + while ($found < $limit && $offset < $limit * 10 && time() - $started < ini_get("max_execution_time") * 0.7) { - $content_preview = $line["content_preview"]; + $result = db_query("SELECT ttrss_entries.id, + ttrss_entries.title, + ttrss_feeds.id AS feed_id, ++ ttrss_feeds.title AS feed_title, + ttrss_feed_categories.id AS cat_id, + content, + link, + author, + tag_cache + FROM + ttrss_entries, ttrss_user_entries + LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id) + LEFT JOIN ttrss_feed_categories ON (ttrss_feeds.cat_id = ttrss_feed_categories.id) + WHERE + ref_id = ttrss_entries.id AND + ($scope_qpart) AND + ttrss_user_entries.owner_uid = " . $_SESSION["uid"] . " + ORDER BY date_entered DESC LIMIT $limit OFFSET $offset"); - if ($line["feed_title"]) - $feed_title = $line["feed_title"]; + while ($line = db_fetch_assoc($result)) { - print ""; + $rc = get_article_filters(array($filter), $line['title'], $line['content'], $line['link'], + false, $line['author'], explode(",", $line['tag_cache'])); - print ""; - print ""; + foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_QUERY_HEADLINES) as $p) { + $line = $p->hook_query_headlines($line, 100); + } - $found++; - } + $content_preview = $line["content_preview"]; - if ($found == 0) { - print ""; + + print ""; + print ""; - print ""; + $found++; + } + } + + $offset += $limit; + } + if ($found == 0) { + print "
"; + if (count($rc) > 0) { - print $line["title"]; - print " ("; - print "" . $feed_title . ""; - print "): "; - print "" . $content_preview . ""; - print " " . mb_substr($line["date_entered"], 0, 16); + $line["content_preview"] = truncate_string(strip_tags($line["content"]), 100, '...'); - print "
" . - __("No recent articles matching this filter have been found."); + if ($line["feed_title"]) $feed_title = $line["feed_title"]; + + print "
"; + - foreach ($filter['rules'] as $rule) { ++ /*foreach ($filter['rules'] as $rule) { + $reg_exp = $rule['reg_exp']; + $reg_exp = str_replace('/', '\/', $rule["reg_exp"]); + + $line["title"] = preg_replace("/($reg_exp)/i", + "$1", $line["title"]); + + $content_preview = preg_replace("/($reg_exp)/i", + "$1", $content_preview); - } ++ }*/ - print "
"; + print $line["title"]; + print " ("; + print "" . $feed_title . ""; + print "): "; + print "" . $content_preview . ""; + print " " . mb_substr($line["date_entered"], 0, 16); - print __("Complex expressions might not give results while testing due to issues with database server regexp implementation."); + print "
" . + __("No recent articles matching this filter have been found."); } print "
";