<?php
class VF_Shared extends Plugin {
+ /* @var PluginHost $host */
private $host;
function about() {
* @SuppressWarnings(PHPMD.UnusedFormalParameter)
*/
function get_unread($feed_id) {
- $result = db_query("select count(int_id) AS count from ttrss_user_entries where owner_uid = ".$_SESSION["uid"]." and unread = true and uuid != ''");
+ $sth = $this->pdo->prepare("select count(int_id) AS count
+ from ttrss_user_entries where owner_uid = ? and unread = true and uuid != ''");
+ $sth->execute([$_SESSION['uid']]);
- return db_fetch_result($result, 0, "count");
+ if ($row = $sth->fetch()) {
+ return $row['count'];
+ }
+
+ return 0;
}
/**
* @SuppressWarnings(PHPMD.UnusedFormalParameter)
*/
function get_total($feed_id) {
- $result = db_query("select count(int_id) AS count from ttrss_user_entries where owner_uid = ".$_SESSION["uid"]." and uuid != ''");
+ $sth = $this->pdo->prepare("select count(int_id) AS count
+ from ttrss_user_entries where owner_uid = ? and uuid != ''");
+ $sth->execute([$_SESSION['uid']]);
- return db_fetch_result($result, 0, "count");
- }
+ if ($row = $sth->fetch()) {
+ return $row['count'];
+ }
- //function queryFeedHeadlines($feed, $limit, $view_mode, $cat_view, $search, $search_mode, $override_order = false, $offset = 0, $owner_uid = 0, $filter = false, $since_id = 0, $include_children = false, $ignore_vfeed_group = false, $override_strategy = false, $override_vfeed = false) {
+ return 0;
+ }
/**
* @SuppressWarnings(PHPMD.UnusedFormalParameter)
*/
function get_headlines($feed_id, $options) {
- /*$qfh_ret = queryFeedHeadlines(-4,
- $options['limit'],
- $this->get_unread(-1) > 0 ? "adaptive" : "all_articles",
- false,
- $options['search'],
- $options['search_mode'],
- $options['override_order'],
- $options['offset'],
- $options['owner_uid'],
- $options['filter'],
- $options['since_id'],
- $options['include_children'],
- false,
- "uuid != ''",
- "ttrss_feeds.title AS feed_title,"); */
-
$params = array(
"feed" => -4,
"limit" => $options["limit"],
"override_vfeed" => "ttrss_feeds.title AS feed_title,"
);
- $qfh_ret = queryFeedHeadlines($params);
+ $qfh_ret = Feeds::queryFeedHeadlines($params);
$qfh_ret[1] = __("Shared articles");
return $qfh_ret;