From 2eda9d9be40c783ae16c169c133e72c7196a6639 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Sun, 3 Dec 2017 10:50:40 +0300
Subject: [PATCH] plugins/vf_shared: use PDO

---
 plugins/vf_shared/init.php | 21 +++++++++++++++++----
 1 file changed, 17 insertions(+), 4 deletions(-)

diff --git a/plugins/vf_shared/init.php b/plugins/vf_shared/init.php
index ce18f92d..a3b0daeb 100644
--- a/plugins/vf_shared/init.php
+++ b/plugins/vf_shared/init.php
@@ -1,6 +1,7 @@
 <?php
 class VF_Shared extends Plugin {
 
+	/* @var PluginHost $host */
 	private $host;
 
 	function about() {
@@ -24,18 +25,30 @@ class VF_Shared extends Plugin {
 	 * @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']]);
+
+		if ($row = $sth->fetch()) {
+			return $row['count'];
+		}
 
-		return db_fetch_result($result, 0, "count");
+		return 0;
 	}
 
 	/**
-- 
2.39.2