plugins/af_redditimgur: use PDO

[tt-rss.git] / plugins / af_redditimgur / init.php

diff --git a/plugins/af_redditimgur/init.php b/plugins/af_redditimgur/init.php
index ac23a4fa34685f0338e94dceb754a45af5f99e7f..59e3a760c666f68ba54939dee92ec38ef3fea384 100755 (executable)
--- a/plugins/af_redditimgur/init.php
+++ b/plugins/af_redditimgur/init.php
@@ -1,5 +1,7 @@
 <?php
 class Af_RedditImgur extends Plugin {
+
+       /* @var PluginHost $host */
        private $host;
 
        function about() {
@@ -64,8 +66,8 @@ class Af_RedditImgur extends Plugin {
        }
 
        function save() {
-               $enable_readability = checkbox_to_sql_bool($_POST["enable_readability"]) == "true";
-               $enable_content_dupcheck = checkbox_to_sql_bool($_POST["enable_content_dupcheck"]) == "true";
+               $enable_readability = checkbox_to_sql_bool($_POST["enable_readability"]);
+               $enable_content_dupcheck = checkbox_to_sql_bool($_POST["enable_content_dupcheck"]);
 
                $this->host->set($this, "enable_readability", $enable_readability, false);
                $this->host->set($this, "enable_content_dupcheck", $enable_content_dupcheck);
@@ -79,6 +81,7 @@ class Af_RedditImgur extends Plugin {
        private function inline_stuff($article, &$doc, $xpath, $debug = false) {
 
                $entries = $xpath->query('(//a[@href]|//img[@src])');
+               $img_entries = $xpath->query("(//img[@src])");
 
                $found = false;
 
@@ -146,6 +149,51 @@ class Af_RedditImgur extends Plugin {
                                        }
                                }
 
+                               if (!$found && preg_match("/https?:\/\/v\.redd\.it\/(.*)$/i", $entry->getAttribute("href"), $matches)) {
+
+                                       _debug("Handling as reddit inline video", $debug);
+
+                                       $img = $img_entries->item(0);
+
+                                       if ($img) {
+                                               $poster_url = $img->getAttribute("src");
+                                       } else {
+                                               $poster_url = false;
+                                       }
+
+                                       // Get original article URL from v.redd.it redirects
+                                       $source_article_url = $this->get_location($matches[0]);
+                                       _debug("Resolved ".$matches[0]." to ".$source_article_url, $debug);
+
+                                       $source_stream = false;
+
+                                       if ($source_article_url) {
+                                               $j = json_decode(fetch_file_contents($source_article_url.".json"), true);
+
+                                               if ($j) {
+                                                       foreach ($j as $listing) {
+                                                               foreach ($listing["data"]["children"] as $child) {
+                                                                       if ($child["data"]["url"] == $matches[0]) {
+                                                                               try {
+                                                                                       $source_stream = $child["data"]["media"]["reddit_video"]["fallback_url"];
+                                                                               }
+                                                                               catch (Exception $e) {
+                                                                               }
+                                                                               break 2;
+                                                                       }
+                                                               }
+                                                       }
+                                               }
+                                       }
+
+                                       if (!$source_stream) {
+                                               $source_stream = "https://v.redd.it/" . $matches[1] . "/DASH_600_K";
+                                       }
+
+                                       $this->handle_as_video($doc, $entry, $source_stream, $poster_url);
+                                       $found = 1;
+                               }
+
                                if (!$found && preg_match("/https?:\/\/(www\.)?streamable.com\//i", $entry->getAttribute("href"))) {
 
                                        _debug("Handling as Streamable", $debug);
@@ -333,8 +381,8 @@ class Af_RedditImgur extends Plugin {
                        if ($this->host->get($this, "enable_content_dupcheck")) {
 
                                if ($content_link) {
-                                       $content_href = db_escape_string($content_link->getAttribute("href"));
-                                       $entry_guid = db_escape_string($article["guid_hashed"]);
+                                       $content_href = $content_link->getAttribute("href");
+                                       $entry_guid = $article["guid_hashed"];
                                        $owner_uid = $article["owner_uid"];
 
                                        if (DB_TYPE == "pgsql") {
@@ -343,16 +391,18 @@ class Af_RedditImgur extends Plugin {
                                                $interval_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 1 DAY)";
                                        }
 
-                                       $result = db_query("SELECT COUNT(id) AS cid
+                                       $sth = $this->pdo->prepare("SELECT COUNT(id) AS cid
                                                FROM ttrss_entries, ttrss_user_entries WHERE
                                                        ref_id = id AND
                                                        $interval_qpart AND
-                                                       guid != '$entry_guid' AND
-                                                       owner_uid = '$owner_uid' AND
-                                                       content LIKE '%href=\"$content_href\">[link]%'");
+                                                       guid != ? AND
+                                                       owner_uid = ? AND
+                                                       content LIKE ?");
+
+                                       $sth->execute([$entry_guid, $owner_uid, "%href=\"$content_href\">[link]%"]);
 
-                                       if ($result) {
-                                               $num_found = db_fetch_result($result, 0, "cid");
+                                       if ($row = $sth->fetch()) {
+                                               $num_found = $row['cid'];
 
                                                if ($num_found > 0) $article["force_catchup"] = true;
                                        }
@@ -433,8 +483,8 @@ class Af_RedditImgur extends Plugin {
                }
        }
 
-       private function get_content_type($url, $useragent = SELF_USER_AGENT) {
-               $content_type = false;
+       private function get_header($url, $useragent = SELF_USER_AGENT, $header) {
+               $ret = false;
 
                if (function_exists("curl_init") && !defined("NO_CURL")) {
                        $ch = curl_init($url);
@@ -446,10 +496,18 @@ class Af_RedditImgur extends Plugin {
                        curl_setopt($ch, CURLOPT_USERAGENT, $useragent);
 
                        @curl_exec($ch);
-                       $content_type = curl_getinfo($ch, CURLINFO_CONTENT_TYPE);
+                       $ret = curl_getinfo($ch, $header);
                }
 
-               return $content_type;
+               return $ret;
+       }
+
+       private function get_content_type($url, $useragent = SELF_USER_AGENT) {
+               return $this->get_header($url, $useragent, CURLINFO_CONTENT_TYPE);
+       }
+
+       private function get_location($url, $useragent = SELF_USER_AGENT) {
+               return $this->get_header($url, $useragent, CURLINFO_EFFECTIVE_URL);
        }
 
        /**