Passed
Push — master ( 678db7...164b32 )
by Cody
06:12 queued 03:06
created
plugins/af_zz_noautoplay/init.php 1 patch
Indentation   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -1,23 +1,23 @@
 block discarded – undo
1 1
 <?php
2 2
 class Af_Zz_NoAutoPlay extends Plugin {
3
-	private $host;
3
+    private $host;
4 4
 
5
-	public function about() {
6
-		return array(1.0,
7
-			"Don't autoplay HTML5 videos",
8
-			"fox");
9
-	}
5
+    public function about() {
6
+        return array(1.0,
7
+            "Don't autoplay HTML5 videos",
8
+            "fox");
9
+    }
10 10
 
11
-	public function init($host) {
12
-		$this->host = $host;
13
-	}
11
+    public function init($host) {
12
+        $this->host = $host;
13
+    }
14 14
 
15
-	public function get_js() {
16
-		return file_get_contents(__DIR__."/init.js");
17
-	}
15
+    public function get_js() {
16
+        return file_get_contents(__DIR__."/init.js");
17
+    }
18 18
 
19
-	public function api_version() {
20
-		return 2;
21
-	}
19
+    public function api_version() {
20
+        return 2;
21
+    }
22 22
 
23 23
 }
Please login to merge, or discard this patch.
plugins/no_url_hashes/init.php 1 patch
Indentation   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -1,24 +1,24 @@
 block discarded – undo
1 1
 <?php
2 2
 class No_URL_Hashes extends Plugin {
3
-	private $host;
3
+    private $host;
4 4
 
5
-	public function about() {
6
-		return array(1.0,
7
-			"Disable URL hash usage (e.g. #f=10, etc)",
8
-			"fox");
9
-	}
5
+    public function about() {
6
+        return array(1.0,
7
+            "Disable URL hash usage (e.g. #f=10, etc)",
8
+            "fox");
9
+    }
10 10
 
11
-	public function init($host) {
12
-		$this->host = $host;
11
+    public function init($host) {
12
+        $this->host = $host;
13 13
 
14
-	}
14
+    }
15 15
 
16
-	public function get_js() {
17
-		return file_get_contents(__DIR__."/init.js");
18
-	}
16
+    public function get_js() {
17
+        return file_get_contents(__DIR__."/init.js");
18
+    }
19 19
 
20
-	public function api_version() {
21
-		return 2;
22
-	}
20
+    public function api_version() {
21
+        return 2;
22
+    }
23 23
 
24 24
 }
Please login to merge, or discard this patch.
plugins/shorten_expanded/init.php 1 patch
Indentation   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -1,28 +1,28 @@
 block discarded – undo
1 1
 <?php
2 2
 class Shorten_Expanded extends Plugin {
3
-	private $host;
3
+    private $host;
4 4
 
5
-	public function about() {
6
-		return array(1.0,
7
-			"Shorten overly long articles in CDM/expanded",
8
-			"fox");
9
-	}
5
+    public function about() {
6
+        return array(1.0,
7
+            "Shorten overly long articles in CDM/expanded",
8
+            "fox");
9
+    }
10 10
 
11
-	public function init($host) {
12
-		$this->host = $host;
11
+    public function init($host) {
12
+        $this->host = $host;
13 13
 
14
-	}
14
+    }
15 15
 
16
-	public function get_css() {
17
-		return file_get_contents(__DIR__."/init.css");
18
-	}
16
+    public function get_css() {
17
+        return file_get_contents(__DIR__."/init.css");
18
+    }
19 19
 
20
-	public function get_js() {
21
-		return file_get_contents(__DIR__."/init.js");
22
-	}
20
+    public function get_js() {
21
+        return file_get_contents(__DIR__."/init.js");
22
+    }
23 23
 
24
-	public function api_version() {
25
-		return 2;
26
-	}
24
+    public function api_version() {
25
+        return 2;
26
+    }
27 27
 
28 28
 }
Please login to merge, or discard this patch.
index.php 1 patch
Indentation   +62 added lines, -62 removed lines patch added patch discarded remove patch
@@ -1,38 +1,38 @@  discard block
 block discarded – undo
1 1
 <?php
2
-	if (file_exists("install") && !file_exists("config.php")) {
3
-		header("Location: install/");
4
-	}
2
+    if (file_exists("install") && !file_exists("config.php")) {
3
+        header("Location: install/");
4
+    }
5 5
 
6
-	if (!file_exists("config.php")) {
7
-		print "<b>Fatal Error</b>: You forgot to copy
6
+    if (!file_exists("config.php")) {
7
+        print "<b>Fatal Error</b>: You forgot to copy
8 8
 		<b>config.php-dist</b> to <b>config.php</b> and edit it.\n";
9
-		exit;
10
-	}
9
+        exit;
10
+    }
11 11
 
12
-	// we need a separate check here because functions.php might get parsed
13
-	// incorrectly before 5.3 because of :: syntax.
14
-	if (version_compare(PHP_VERSION, '5.6.0', '<')) {
15
-		print "<b>Fatal Error</b>: PHP version 5.6.0 or newer required. You're using ".PHP_VERSION.".\n";
16
-		exit;
17
-	}
12
+    // we need a separate check here because functions.php might get parsed
13
+    // incorrectly before 5.3 because of :: syntax.
14
+    if (version_compare(PHP_VERSION, '5.6.0', '<')) {
15
+        print "<b>Fatal Error</b>: PHP version 5.6.0 or newer required. You're using ".PHP_VERSION.".\n";
16
+        exit;
17
+    }
18 18
 
19
-	set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
20
-		get_include_path());
19
+    set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
20
+        get_include_path());
21 21
 
22
-	require_once "autoload.php";
23
-	require_once "sessions.php";
24
-	require_once "functions.php";
25
-	require_once "sanity_check.php";
26
-	require_once "config.php";
27
-	require_once "db-prefs.php";
22
+    require_once "autoload.php";
23
+    require_once "sessions.php";
24
+    require_once "functions.php";
25
+    require_once "sanity_check.php";
26
+    require_once "config.php";
27
+    require_once "db-prefs.php";
28 28
 
29
-	if (!init_plugins()) {
30
-	    return;
31
-	}
29
+    if (!init_plugins()) {
30
+        return;
31
+    }
32 32
 
33
-	login_sequence();
33
+    login_sequence();
34 34
 
35
-	header('Content-Type: text/html; charset=utf-8');
35
+    header('Content-Type: text/html; charset=utf-8');
36 36
 
37 37
 ?>
38 38
 <!DOCTYPE html>
@@ -42,23 +42,23 @@  discard block
 block discarded – undo
42 42
     <meta name="viewport" content="initial-scale=1,width=device-width" />
43 43
 
44 44
 	<?php if ($_SESSION["uid"]) {
45
-		$theme = get_pref("USER_CSS_THEME", false, false);
46
-		if ($theme && theme_exists("$theme")) {
47
-			echo stylesheet_tag(get_theme_path($theme), 'theme_css');
48
-		}
49
-	}
45
+        $theme = get_pref("USER_CSS_THEME", false, false);
46
+        if ($theme && theme_exists("$theme")) {
47
+            echo stylesheet_tag(get_theme_path($theme), 'theme_css');
48
+        }
49
+    }
50 50
 
51
-	print_user_stylesheet()
51
+    print_user_stylesheet()
52 52
 
53
-	?>
53
+    ?>
54 54
 	<style type="text/css">
55 55
 	<?php
56
-		foreach (PluginHost::getInstance()->get_plugins() as $n => $p) {
57
-			if (method_exists($p, "get_css")) {
58
-				echo $p->get_css();
59
-			}
60
-		}
61
-	?>
56
+        foreach (PluginHost::getInstance()->get_plugins() as $n => $p) {
57
+            if (method_exists($p, "get_css")) {
58
+                echo $p->get_css();
59
+            }
60
+        }
61
+    ?>
62 62
 	</style>
63 63
 
64 64
 	<link rel="shortcut icon" type="image/png" href="images/favicon.png"/>
@@ -75,17 +75,17 @@  discard block
 block discarded – undo
75 75
 	</script>
76 76
 
77 77
 	<?php
78
-	foreach (array("lib/prototype.js",
79
-				"lib/scriptaculous/scriptaculous.js?load=effects,controls",
80
-				"lib/dojo/dojo.js",
81
-				"lib/dojo/tt-rss-layer.js",
82
-				"js/tt-rss.js",
83
-				"js/common.js",
84
-				"errors.php?mode=js") as $jsfile) {
78
+    foreach (array("lib/prototype.js",
79
+                "lib/scriptaculous/scriptaculous.js?load=effects,controls",
80
+                "lib/dojo/dojo.js",
81
+                "lib/dojo/tt-rss-layer.js",
82
+                "js/tt-rss.js",
83
+                "js/common.js",
84
+                "errors.php?mode=js") as $jsfile) {
85 85
 
86
-		echo javascript_tag($jsfile);
86
+        echo javascript_tag($jsfile);
87 87
 
88
-	} ?>
88
+    } ?>
89 89
 
90 90
 	<script type="text/javascript">
91 91
 		require({cache:{}});
@@ -93,22 +93,22 @@  discard block
 block discarded – undo
93 93
 
94 94
 	<script type="text/javascript">
95 95
 	<?php
96
-		foreach (PluginHost::getInstance()->get_plugins() as $n => $p) {
97
-			if (method_exists($p, "get_js")) {
98
-			    $script = $p->get_js();
96
+        foreach (PluginHost::getInstance()->get_plugins() as $n => $p) {
97
+            if (method_exists($p, "get_js")) {
98
+                $script = $p->get_js();
99 99
 
100
-			    if ($script) {
101
-					echo "try {
100
+                if ($script) {
101
+                    echo "try {
102 102
 					    $script
103 103
 					} catch (e) {
104 104
                         console.warn('failed to initialize plugin JS: $n', e);
105 105
                     }";
106
-				}
107
-			}
108
-		}
106
+                }
107
+            }
108
+        }
109 109
 
110
-		init_js_translations();
111
-	?>
110
+        init_js_translations();
111
+    ?>
112 112
 	</script>
113 113
 
114 114
 	<style type="text/css">
@@ -148,9 +148,9 @@  discard block
 block discarded – undo
148 148
             <img src='images/indicator_tiny.gif'/>
149 149
             <?php echo  __("Loading, please wait..."); ?></div>
150 150
         <?php
151
-          foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_FEED_TREE) as $p) {
151
+            foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_FEED_TREE) as $p) {
152 152
             echo $p->hook_feed_tree();
153
-          }
153
+            }
154 154
         ?>
155 155
         <div id="feedTree"></div>
156 156
     </div>
@@ -223,7 +223,7 @@  discard block
 block discarded – undo
223 223
 
224 224
                 <?php
225 225
                     foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_TOOLBAR_BUTTON) as $p) {
226
-                         echo $p->hook_toolbar_button();
226
+                            echo $p->hook_toolbar_button();
227 227
                     }
228 228
                 ?>
229 229
 
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
245 245
 
246 246
                         <?php
247 247
                             foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ACTION_ITEM) as $p) {
248
-                             echo $p->hook_action_item();
248
+                                echo $p->hook_action_item();
249 249
                             }
250 250
                         ?>
251 251
 
Please login to merge, or discard this patch.
public.php 1 patch
Indentation   +45 added lines, -45 removed lines patch added patch discarded remove patch
@@ -1,46 +1,46 @@
 block discarded – undo
1 1
 <?php
2
-	set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
3
-		get_include_path());
4
-
5
-	require_once "autoload.php";
6
-	require_once "sessions.php";
7
-	require_once "functions.php";
8
-	require_once "sanity_check.php";
9
-	require_once "config.php";
10
-	require_once "db.php";
11
-	require_once "db-prefs.php";
12
-
13
-	startup_gettext();
14
-
15
-	$script_started = microtime(true);
16
-
17
-	if (!init_plugins()) {
18
-	    return;
19
-	}
20
-
21
-	if (ENABLE_GZIP_OUTPUT && function_exists("ob_gzhandler")) {
22
-		ob_start("ob_gzhandler");
23
-	}
24
-
25
-	$method = $_REQUEST["op"];
26
-
27
-	$override = PluginHost::getInstance()->lookup_handler("public", $method);
28
-
29
-	if ($override) {
30
-		$handler = $override;
31
-	} else {
32
-		$handler = new Handler_Public($_REQUEST);
33
-	}
34
-
35
-	if (implements_interface($handler, "IHandler") && $handler->before($method)) {
36
-		if ($method && method_exists($handler, $method)) {
37
-			$handler->$method();
38
-		} else if (method_exists($handler, 'index')) {
39
-			$handler->index();
40
-		}
41
-		$handler->after();
42
-		return;
43
-	}
44
-
45
-	header("Content-Type: text/plain");
46
-	print error_json(13);
2
+    set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
3
+        get_include_path());
4
+
5
+    require_once "autoload.php";
6
+    require_once "sessions.php";
7
+    require_once "functions.php";
8
+    require_once "sanity_check.php";
9
+    require_once "config.php";
10
+    require_once "db.php";
11
+    require_once "db-prefs.php";
12
+
13
+    startup_gettext();
14
+
15
+    $script_started = microtime(true);
16
+
17
+    if (!init_plugins()) {
18
+        return;
19
+    }
20
+
21
+    if (ENABLE_GZIP_OUTPUT && function_exists("ob_gzhandler")) {
22
+        ob_start("ob_gzhandler");
23
+    }
24
+
25
+    $method = $_REQUEST["op"];
26
+
27
+    $override = PluginHost::getInstance()->lookup_handler("public", $method);
28
+
29
+    if ($override) {
30
+        $handler = $override;
31
+    } else {
32
+        $handler = new Handler_Public($_REQUEST);
33
+    }
34
+
35
+    if (implements_interface($handler, "IHandler") && $handler->before($method)) {
36
+        if ($method && method_exists($handler, $method)) {
37
+            $handler->$method();
38
+        } else if (method_exists($handler, 'index')) {
39
+            $handler->index();
40
+        }
41
+        $handler->after();
42
+        return;
43
+    }
44
+
45
+    header("Content-Type: text/plain");
46
+    print error_json(13);
Please login to merge, or discard this patch.
update.php 2 patches
Indentation   +375 added lines, -375 removed lines patch added patch discarded remove patch
@@ -1,108 +1,108 @@  discard block
 block discarded – undo
1 1
 #!/usr/bin/env php
2 2
 <?php
3
-	set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
4
-		get_include_path());
3
+    set_include_path(dirname(__FILE__)."/include".PATH_SEPARATOR.
4
+        get_include_path());
5 5
 
6
-	define('DISABLE_SESSIONS', true);
6
+    define('DISABLE_SESSIONS', true);
7 7
 
8
-	chdir(dirname(__FILE__));
8
+    chdir(dirname(__FILE__));
9 9
 
10
-	require_once "autoload.php";
11
-	require_once "functions.php";
12
-	require_once "config.php";
13
-	require_once "sanity_check.php";
14
-	require_once "db.php";
15
-	require_once "db-prefs.php";
10
+    require_once "autoload.php";
11
+    require_once "functions.php";
12
+    require_once "config.php";
13
+    require_once "sanity_check.php";
14
+    require_once "db.php";
15
+    require_once "db-prefs.php";
16 16
 
17
-	function cleanup_tags($days = 14, $limit = 1000) {
17
+    function cleanup_tags($days = 14, $limit = 1000) {
18 18
 
19
-		$days = (int) $days;
19
+        $days = (int) $days;
20 20
 
21
-		if (DB_TYPE == "pgsql") {
22
-			$interval_query = "date_updated < NOW() - INTERVAL '$days days'";
23
-		} else if (DB_TYPE == "mysql") {
24
-			$interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
25
-		}
21
+        if (DB_TYPE == "pgsql") {
22
+            $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
23
+        } else if (DB_TYPE == "mysql") {
24
+            $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
25
+        }
26 26
 
27
-		$tags_deleted = 0;
27
+        $tags_deleted = 0;
28 28
 
29
-		$pdo = Db::pdo();
29
+        $pdo = Db::pdo();
30 30
 
31
-		while ($limit > 0) {
32
-			$limit_part = 500;
31
+        while ($limit > 0) {
32
+            $limit_part = 500;
33 33
 
34
-			$sth = $pdo->prepare("SELECT ttrss_tags.id AS id
34
+            $sth = $pdo->prepare("SELECT ttrss_tags.id AS id
35 35
 						FROM ttrss_tags, ttrss_user_entries, ttrss_entries
36 36
 						WHERE post_int_id = int_id AND $interval_query AND
37 37
 						ref_id = ttrss_entries.id AND tag_cache != '' LIMIT ?");
38
-			$sth->bindValue(1, $limit_part, PDO::PARAM_INT);
39
-			$sth->execute();
40
-
41
-			$ids = array();
42
-
43
-			while ($line = $sth->fetch()) {
44
-				array_push($ids, $line['id']);
45
-			}
46
-
47
-			if (count($ids) > 0) {
48
-				$ids = join(",", $ids);
49
-
50
-				$usth = $pdo->query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
51
-				$tags_deleted = $usth->rowCount();
52
-			} else {
53
-				break;
54
-			}
55
-
56
-			$limit -= $limit_part;
57
-		}
58
-
59
-		return $tags_deleted;
60
-	}
61
-
62
-	if (!defined('PHP_EXECUTABLE')) {
63
-			define('PHP_EXECUTABLE', '/usr/bin/php');
64
-	}
65
-
66
-	$pdo = Db::pdo();
67
-
68
-	init_plugins();
69
-
70
-	$longopts = array("feeds",
71
-			"daemon",
72
-			"daemon-loop",
73
-			"send-digests",
74
-			"task:",
75
-			"cleanup-tags",
76
-			"quiet",
77
-			"log:",
78
-			"log-level:",
79
-			"indexes",
80
-			"pidlock:",
81
-			"update-schema",
82
-			"convert-filters",
83
-			"force-update",
84
-			"gen-search-idx",
85
-			"list-plugins",
86
-			"debug-feed:",
87
-			"force-refetch",
88
-			"force-rehash",
89
-			"help");
90
-
91
-	foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
92
-		array_push($longopts, $command.$data["suffix"]);
93
-	}
94
-
95
-	$options = getopt("", $longopts);
96
-
97
-	if (!is_array($options)) {
98
-		die("error: getopt() failed. ".
99
-			"Most probably you are using PHP CGI to run this script ".
100
-			"instead of required PHP CLI. Check tt-rss wiki page on updating feeds for ".
101
-			"additional information.\n");
102
-	}
103
-
104
-	if (count($options) == 0 && !defined('STDIN')) {
105
-		?>
38
+            $sth->bindValue(1, $limit_part, PDO::PARAM_INT);
39
+            $sth->execute();
40
+
41
+            $ids = array();
42
+
43
+            while ($line = $sth->fetch()) {
44
+                array_push($ids, $line['id']);
45
+            }
46
+
47
+            if (count($ids) > 0) {
48
+                $ids = join(",", $ids);
49
+
50
+                $usth = $pdo->query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
51
+                $tags_deleted = $usth->rowCount();
52
+            } else {
53
+                break;
54
+            }
55
+
56
+            $limit -= $limit_part;
57
+        }
58
+
59
+        return $tags_deleted;
60
+    }
61
+
62
+    if (!defined('PHP_EXECUTABLE')) {
63
+            define('PHP_EXECUTABLE', '/usr/bin/php');
64
+    }
65
+
66
+    $pdo = Db::pdo();
67
+
68
+    init_plugins();
69
+
70
+    $longopts = array("feeds",
71
+            "daemon",
72
+            "daemon-loop",
73
+            "send-digests",
74
+            "task:",
75
+            "cleanup-tags",
76
+            "quiet",
77
+            "log:",
78
+            "log-level:",
79
+            "indexes",
80
+            "pidlock:",
81
+            "update-schema",
82
+            "convert-filters",
83
+            "force-update",
84
+            "gen-search-idx",
85
+            "list-plugins",
86
+            "debug-feed:",
87
+            "force-refetch",
88
+            "force-rehash",
89
+            "help");
90
+
91
+    foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
92
+        array_push($longopts, $command.$data["suffix"]);
93
+    }
94
+
95
+    $options = getopt("", $longopts);
96
+
97
+    if (!is_array($options)) {
98
+        die("error: getopt() failed. ".
99
+            "Most probably you are using PHP CGI to run this script ".
100
+            "instead of required PHP CLI. Check tt-rss wiki page on updating feeds for ".
101
+            "additional information.\n");
102
+    }
103
+
104
+    if (count($options) == 0 && !defined('STDIN')) {
105
+        ?>
106 106
 		<!DOCTYPE html>
107 107
 		<html>
108 108
 		<head>
@@ -117,387 +117,387 @@  discard block
 block discarded – undo
117 117
 
118 118
 		</body></html>
119 119
 	<?php
120
-		exit;
121
-	}
122
-
123
-	if (count($options) == 0 || isset($options["help"])) {
124
-		print "Tiny Tiny RSS data update script.\n\n";
125
-		print "Options:\n";
126
-		print "  --feeds              - update feeds\n";
127
-		print "  --daemon             - start single-process update daemon\n";
128
-		print "  --task N             - create lockfile using this task id\n";
129
-		print "  --cleanup-tags       - perform tags table maintenance\n";
130
-		print "  --quiet              - don't output messages to stdout\n";
131
-		print "  --log FILE           - log messages to FILE\n";
132
-		print "  --log-level N        - log verbosity level\n";
133
-		print "  --indexes            - recreate missing schema indexes\n";
134
-		print "  --update-schema      - update database schema\n";
135
-		print "  --gen-search-idx     - generate basic PostgreSQL fulltext search index\n";
136
-		print "  --convert-filters    - convert type1 filters to type2\n";
137
-		print "  --send-digests       - send pending email digests\n";
138
-		print "  --force-update       - force update of all feeds\n";
139
-		print "  --list-plugins       - list all available plugins\n";
140
-		print "  --debug-feed N       - perform debug update of feed N\n";
141
-		print "  --force-refetch      - debug update: force refetch feed data\n";
142
-		print "  --force-rehash       - debug update: force rehash articles\n";
143
-		print "  --help               - show this help\n";
144
-		print "Plugin options:\n";
145
-
146
-		foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
147
-			$args = $data['arghelp'];
148
-			printf(" --%-19s - %s\n", "$command $args", $data["description"]);
149
-		}
150
-
151
-		return;
152
-	}
153
-
154
-	if (!isset($options['daemon'])) {
155
-		require_once "errorhandler.php";
156
-	}
157
-
158
-	if (!isset($options['update-schema'])) {
159
-		$schema_version = get_schema_version();
160
-
161
-		if ($schema_version != SCHEMA_VERSION) {
162
-			die("Schema version is wrong, please upgrade the database (--update-schema).\n");
163
-		}
164
-	}
165
-
166
-	Debug::set_enabled(true);
167
-
168
-	if (isset($options["log-level"])) {
169
-	    Debug::set_loglevel((int) $options["log-level"]);
120
+        exit;
121
+    }
122
+
123
+    if (count($options) == 0 || isset($options["help"])) {
124
+        print "Tiny Tiny RSS data update script.\n\n";
125
+        print "Options:\n";
126
+        print "  --feeds              - update feeds\n";
127
+        print "  --daemon             - start single-process update daemon\n";
128
+        print "  --task N             - create lockfile using this task id\n";
129
+        print "  --cleanup-tags       - perform tags table maintenance\n";
130
+        print "  --quiet              - don't output messages to stdout\n";
131
+        print "  --log FILE           - log messages to FILE\n";
132
+        print "  --log-level N        - log verbosity level\n";
133
+        print "  --indexes            - recreate missing schema indexes\n";
134
+        print "  --update-schema      - update database schema\n";
135
+        print "  --gen-search-idx     - generate basic PostgreSQL fulltext search index\n";
136
+        print "  --convert-filters    - convert type1 filters to type2\n";
137
+        print "  --send-digests       - send pending email digests\n";
138
+        print "  --force-update       - force update of all feeds\n";
139
+        print "  --list-plugins       - list all available plugins\n";
140
+        print "  --debug-feed N       - perform debug update of feed N\n";
141
+        print "  --force-refetch      - debug update: force refetch feed data\n";
142
+        print "  --force-rehash       - debug update: force rehash articles\n";
143
+        print "  --help               - show this help\n";
144
+        print "Plugin options:\n";
145
+
146
+        foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
147
+            $args = $data['arghelp'];
148
+            printf(" --%-19s - %s\n", "$command $args", $data["description"]);
149
+        }
150
+
151
+        return;
152
+    }
153
+
154
+    if (!isset($options['daemon'])) {
155
+        require_once "errorhandler.php";
156
+    }
157
+
158
+    if (!isset($options['update-schema'])) {
159
+        $schema_version = get_schema_version();
160
+
161
+        if ($schema_version != SCHEMA_VERSION) {
162
+            die("Schema version is wrong, please upgrade the database (--update-schema).\n");
163
+        }
164
+    }
165
+
166
+    Debug::set_enabled(true);
167
+
168
+    if (isset($options["log-level"])) {
169
+        Debug::set_loglevel((int) $options["log-level"]);
170 170
     }
171 171
 
172
-	if (isset($options["log"])) {
173
-		Debug::set_quiet(isset($options['quiet']));
174
-		Debug::set_logfile($options["log"]);
172
+    if (isset($options["log"])) {
173
+        Debug::set_quiet(isset($options['quiet']));
174
+        Debug::set_logfile($options["log"]);
175 175
         Debug::log("Logging to ".$options["log"]);
176 176
     } else {
177
-	    if (isset($options['quiet'])) {
178
-			Debug::set_loglevel(Debug::$LOG_DISABLED);
177
+        if (isset($options['quiet'])) {
178
+            Debug::set_loglevel(Debug::$LOG_DISABLED);
179 179
         }
180 180
     }
181 181
 
182
-	if (!isset($options["daemon"])) {
183
-		$lock_filename = "update.lock";
184
-	} else {
185
-		$lock_filename = "update_daemon.lock";
186
-	}
182
+    if (!isset($options["daemon"])) {
183
+        $lock_filename = "update.lock";
184
+    } else {
185
+        $lock_filename = "update_daemon.lock";
186
+    }
187 187
 
188
-	if (isset($options["task"])) {
189
-		Debug::log("Using task id ".$options["task"]);
190
-		$lock_filename = $lock_filename."-task_".$options["task"];
191
-	}
188
+    if (isset($options["task"])) {
189
+        Debug::log("Using task id ".$options["task"]);
190
+        $lock_filename = $lock_filename."-task_".$options["task"];
191
+    }
192 192
 
193
-	if (isset($options["pidlock"])) {
194
-		$my_pid = $options["pidlock"];
195
-		$lock_filename = "update_daemon-$my_pid.lock";
193
+    if (isset($options["pidlock"])) {
194
+        $my_pid = $options["pidlock"];
195
+        $lock_filename = "update_daemon-$my_pid.lock";
196 196
 
197
-	}
197
+    }
198 198
 
199
-	Debug::log("Lock: $lock_filename");
199
+    Debug::log("Lock: $lock_filename");
200 200
 
201
-	$lock_handle = make_lockfile($lock_filename);
202
-	$must_exit = false;
201
+    $lock_handle = make_lockfile($lock_filename);
202
+    $must_exit = false;
203 203
 
204
-	if (isset($options["task"]) && isset($options["pidlock"])) {
205
-		$waits = $options["task"] * 5;
206
-		Debug::log("Waiting before update ($waits)");
207
-		sleep($waits);
208
-	}
204
+    if (isset($options["task"]) && isset($options["pidlock"])) {
205
+        $waits = $options["task"] * 5;
206
+        Debug::log("Waiting before update ($waits)");
207
+        sleep($waits);
208
+    }
209 209
 
210
-	// Try to lock a file in order to avoid concurrent update.
211
-	if (!$lock_handle) {
212
-		die("error: Can't create lockfile ($lock_filename). ".
213
-			"Maybe another update process is already running.\n");
214
-	}
210
+    // Try to lock a file in order to avoid concurrent update.
211
+    if (!$lock_handle) {
212
+        die("error: Can't create lockfile ($lock_filename). ".
213
+            "Maybe another update process is already running.\n");
214
+    }
215 215
 
216
-	if (isset($options["force-update"])) {
217
-		Debug::log("marking all feeds as needing update...");
216
+    if (isset($options["force-update"])) {
217
+        Debug::log("marking all feeds as needing update...");
218 218
 
219
-		$pdo->query("UPDATE ttrss_feeds SET
219
+        $pdo->query("UPDATE ttrss_feeds SET
220 220
           last_update_started = '1970-01-01', last_updated = '1970-01-01'");
221
-	}
221
+    }
222 222
 
223
-	if (isset($options["feeds"])) {
224
-		RSSUtils::update_daemon_common();
225
-		RSSUtils::housekeeping_common(true);
223
+    if (isset($options["feeds"])) {
224
+        RSSUtils::update_daemon_common();
225
+        RSSUtils::housekeeping_common(true);
226 226
 
227
-		PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
228
-	}
227
+        PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
228
+    }
229 229
 
230
-	if (isset($options["daemon"])) {
231
-		while (true) {
232
-			$quiet = (isset($options["quiet"])) ? "--quiet" : "";
230
+    if (isset($options["daemon"])) {
231
+        while (true) {
232
+            $quiet = (isset($options["quiet"])) ? "--quiet" : "";
233 233
             $log = isset($options['log']) ? '--log '.$options['log'] : '';
234 234
             $log_level = isset($options['log-level']) ? '--log-level '.$options['log-level'] : '';
235 235
 
236
-			passthru(PHP_EXECUTABLE." ".$argv[0]." --daemon-loop $quiet $log $log_level");
236
+            passthru(PHP_EXECUTABLE." ".$argv[0]." --daemon-loop $quiet $log $log_level");
237 237
 
238
-			// let's enforce a minimum spawn interval as to not forkbomb the host
239
-			$spawn_interval = max(60, DAEMON_SLEEP_INTERVAL);
238
+            // let's enforce a minimum spawn interval as to not forkbomb the host
239
+            $spawn_interval = max(60, DAEMON_SLEEP_INTERVAL);
240 240
 
241
-			Debug::log("Sleeping for $spawn_interval seconds...");
242
-			sleep($spawn_interval);
243
-		}
244
-	}
241
+            Debug::log("Sleeping for $spawn_interval seconds...");
242
+            sleep($spawn_interval);
243
+        }
244
+    }
245 245
 
246
-	if (isset($options["daemon-loop"])) {
247
-		if (!make_stampfile('update_daemon.stamp')) {
248
-			Debug::log("warning: unable to create stampfile\n");
249
-		}
246
+    if (isset($options["daemon-loop"])) {
247
+        if (!make_stampfile('update_daemon.stamp')) {
248
+            Debug::log("warning: unable to create stampfile\n");
249
+        }
250 250
 
251
-		RSSUtils::update_daemon_common(isset($options["pidlock"]) ? 50 : DAEMON_FEED_LIMIT);
251
+        RSSUtils::update_daemon_common(isset($options["pidlock"]) ? 50 : DAEMON_FEED_LIMIT);
252 252
 
253
-		if (!isset($options["pidlock"]) || $options["task"] == 0) {
254
-					RSSUtils::housekeeping_common(true);
255
-		}
253
+        if (!isset($options["pidlock"]) || $options["task"] == 0) {
254
+                    RSSUtils::housekeeping_common(true);
255
+        }
256 256
 
257
-		PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
258
-	}
257
+        PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
258
+    }
259 259
 
260
-	if (isset($options["cleanup-tags"])) {
261
-		$rc = cleanup_tags(14, 50000);
262
-		Debug::log("$rc tags deleted.\n");
263
-	}
260
+    if (isset($options["cleanup-tags"])) {
261
+        $rc = cleanup_tags(14, 50000);
262
+        Debug::log("$rc tags deleted.\n");
263
+    }
264 264
 
265
-	if (isset($options["indexes"])) {
266
-		Debug::log("PLEASE BACKUP YOUR DATABASE BEFORE PROCEEDING!");
267
-		Debug::log("Type 'yes' to continue.");
265
+    if (isset($options["indexes"])) {
266
+        Debug::log("PLEASE BACKUP YOUR DATABASE BEFORE PROCEEDING!");
267
+        Debug::log("Type 'yes' to continue.");
268 268
 
269
-		if (read_stdin() != 'yes') {
270
-					exit;
271
-		}
269
+        if (read_stdin() != 'yes') {
270
+                    exit;
271
+        }
272 272
 
273
-		Debug::log("clearing existing indexes...");
273
+        Debug::log("clearing existing indexes...");
274 274
 
275
-		if (DB_TYPE == "pgsql") {
276
-			$sth = $pdo->query("SELECT relname FROM
275
+        if (DB_TYPE == "pgsql") {
276
+            $sth = $pdo->query("SELECT relname FROM
277 277
 				pg_catalog.pg_class WHERE relname LIKE 'ttrss_%'
278 278
 					AND relname NOT LIKE '%_pkey'
279 279
 				AND relkind = 'i'");
280
-		} else {
281
-			$sth = $pdo->query("SELECT index_name,table_name FROM
280
+        } else {
281
+            $sth = $pdo->query("SELECT index_name,table_name FROM
282 282
 				information_schema.statistics WHERE index_name LIKE 'ttrss_%'");
283
-		}
284
-
285
-		while ($line = $sth->fetch()) {
286
-			if (DB_TYPE == "pgsql") {
287
-				$statement = "DROP INDEX ".$line["relname"];
288
-				Debug::log($statement);
289
-			} else {
290
-				$statement = "ALTER TABLE ".
291
-					$line['table_name']." DROP INDEX ".$line['index_name'];
292
-				Debug::log($statement);
293
-			}
294
-			$pdo->query($statement);
295
-		}
283
+        }
296 284
 
297
-		Debug::log("reading indexes from schema for: ".DB_TYPE);
285
+        while ($line = $sth->fetch()) {
286
+            if (DB_TYPE == "pgsql") {
287
+                $statement = "DROP INDEX ".$line["relname"];
288
+                Debug::log($statement);
289
+            } else {
290
+                $statement = "ALTER TABLE ".
291
+                    $line['table_name']." DROP INDEX ".$line['index_name'];
292
+                Debug::log($statement);
293
+            }
294
+            $pdo->query($statement);
295
+        }
298 296
 
299
-		$fp = fopen("schema/ttrss_schema_".DB_TYPE.".sql", "r");
300
-		if ($fp) {
301
-			while ($line = fgets($fp)) {
302
-				$matches = array();
297
+        Debug::log("reading indexes from schema for: ".DB_TYPE);
303 298
 
304
-				if (preg_match("/^create index ([^ ]+) on ([^ ]+)$/i", $line, $matches)) {
305
-					$index = $matches[1];
306
-					$table = $matches[2];
299
+        $fp = fopen("schema/ttrss_schema_".DB_TYPE.".sql", "r");
300
+        if ($fp) {
301
+            while ($line = fgets($fp)) {
302
+                $matches = array();
307 303
 
308
-					$statement = "CREATE INDEX $index ON $table";
304
+                if (preg_match("/^create index ([^ ]+) on ([^ ]+)$/i", $line, $matches)) {
305
+                    $index = $matches[1];
306
+                    $table = $matches[2];
309 307
 
310
-					Debug::log($statement);
311
-					$pdo->query($statement);
312
-				}
313
-			}
314
-			fclose($fp);
315
-		} else {
316
-			Debug::log("unable to open schema file.");
317
-		}
318
-		Debug::log("all done.");
319
-	}
308
+                    $statement = "CREATE INDEX $index ON $table";
320 309
 
321
-	if (isset($options["convert-filters"])) {
322
-		Debug::log("WARNING: this will remove all existing type2 filters.");
323
-		Debug::log("Type 'yes' to continue.");
310
+                    Debug::log($statement);
311
+                    $pdo->query($statement);
312
+                }
313
+            }
314
+            fclose($fp);
315
+        } else {
316
+            Debug::log("unable to open schema file.");
317
+        }
318
+        Debug::log("all done.");
319
+    }
320
+
321
+    if (isset($options["convert-filters"])) {
322
+        Debug::log("WARNING: this will remove all existing type2 filters.");
323
+        Debug::log("Type 'yes' to continue.");
324 324
 
325
-		if (read_stdin() != 'yes') {
326
-					exit;
327
-		}
325
+        if (read_stdin() != 'yes') {
326
+                    exit;
327
+        }
328 328
 
329
-		Debug::log("converting filters...");
329
+        Debug::log("converting filters...");
330 330
 
331
-		$pdo->query("DELETE FROM ttrss_filters2");
331
+        $pdo->query("DELETE FROM ttrss_filters2");
332 332
 
333
-		$res = $pdo->query("SELECT * FROM ttrss_filters ORDER BY id");
333
+        $res = $pdo->query("SELECT * FROM ttrss_filters ORDER BY id");
334 334
 
335
-		while ($line = $res->fetch()) {
336
-			$owner_uid = $line["owner_uid"];
335
+        while ($line = $res->fetch()) {
336
+            $owner_uid = $line["owner_uid"];
337 337
 
338
-			// date filters are removed
339
-			if ($line["filter_type"] != 5) {
340
-				$filter = array();
338
+            // date filters are removed
339
+            if ($line["filter_type"] != 5) {
340
+                $filter = array();
341 341
 
342
-				if (sql_bool_to_bool($line["cat_filter"])) {
343
-					$feed_id = "CAT:".(int) $line["cat_id"];
344
-				} else {
345
-					$feed_id = (int) $line["feed_id"];
346
-				}
342
+                if (sql_bool_to_bool($line["cat_filter"])) {
343
+                    $feed_id = "CAT:".(int) $line["cat_id"];
344
+                } else {
345
+                    $feed_id = (int) $line["feed_id"];
346
+                }
347 347
 
348
-				$filter["enabled"] = $line["enabled"] ? "on" : "off";
349
-				$filter["rule"] = array(
350
-					json_encode(array(
351
-						"reg_exp" => $line["reg_exp"],
352
-						"feed_id" => $feed_id,
353
-						"filter_type" => $line["filter_type"])));
348
+                $filter["enabled"] = $line["enabled"] ? "on" : "off";
349
+                $filter["rule"] = array(
350
+                    json_encode(array(
351
+                        "reg_exp" => $line["reg_exp"],
352
+                        "feed_id" => $feed_id,
353
+                        "filter_type" => $line["filter_type"])));
354 354
 
355
-				$filter["action"] = array(
356
-					json_encode(array(
357
-						"action_id" => $line["action_id"],
358
-						"action_param_label" => $line["action_param"],
359
-						"action_param" => $line["action_param"])));
355
+                $filter["action"] = array(
356
+                    json_encode(array(
357
+                        "action_id" => $line["action_id"],
358
+                        "action_param_label" => $line["action_param"],
359
+                        "action_param" => $line["action_param"])));
360 360
 
361
-				// Oh god it's full of hacks
361
+                // Oh god it's full of hacks
362 362
 
363
-				$_REQUEST = $filter;
364
-				$_SESSION["uid"] = $owner_uid;
363
+                $_REQUEST = $filter;
364
+                $_SESSION["uid"] = $owner_uid;
365 365
 
366
-				$filters = new Pref_Filters($_REQUEST);
367
-				$filters->add();
368
-			}
369
-		}
366
+                $filters = new Pref_Filters($_REQUEST);
367
+                $filters->add();
368
+            }
369
+        }
370 370
 
371
-	}
371
+    }
372 372
 
373
-	if (isset($options["update-schema"])) {
374
-		Debug::log("Checking for updates (".DB_TYPE.")...");
373
+    if (isset($options["update-schema"])) {
374
+        Debug::log("Checking for updates (".DB_TYPE.")...");
375 375
 
376
-		$updater = new DbUpdater(DB_TYPE, SCHEMA_VERSION);
376
+        $updater = new DbUpdater(DB_TYPE, SCHEMA_VERSION);
377 377
 
378
-		if ($updater->isUpdateRequired()) {
379
-			Debug::log("Schema update required, version ".$updater->getSchemaVersion()." to ".SCHEMA_VERSION);
378
+        if ($updater->isUpdateRequired()) {
379
+            Debug::log("Schema update required, version ".$updater->getSchemaVersion()." to ".SCHEMA_VERSION);
380 380
 
381
-			if (DB_TYPE == "mysql") {
382
-							Debug::Log("READ THIS: Due to MySQL limitations, your database is not completely protected while updating.\n".
383
-					"Errors may put it in an inconsistent state requiring manual rollback.\nBACKUP YOUR DATABASE BEFORE CONTINUING.");
384
-			} else {
385
-							Debug::log("WARNING: please backup your database before continuing.");
386
-			}
381
+            if (DB_TYPE == "mysql") {
382
+                            Debug::Log("READ THIS: Due to MySQL limitations, your database is not completely protected while updating.\n".
383
+                    "Errors may put it in an inconsistent state requiring manual rollback.\nBACKUP YOUR DATABASE BEFORE CONTINUING.");
384
+            } else {
385
+                            Debug::log("WARNING: please backup your database before continuing.");
386
+            }
387 387
 
388
-			Debug::log("Type 'yes' to continue.");
388
+            Debug::log("Type 'yes' to continue.");
389 389
 
390
-			if (read_stdin() != 'yes') {
391
-							exit;
392
-			}
390
+            if (read_stdin() != 'yes') {
391
+                            exit;
392
+            }
393 393
 
394
-			Debug::log("Performing updates to version ".SCHEMA_VERSION);
394
+            Debug::log("Performing updates to version ".SCHEMA_VERSION);
395 395
 
396
-			for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) {
397
-				Debug::log("* Updating to version $i...");
396
+            for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) {
397
+                Debug::log("* Updating to version $i...");
398 398
 
399
-				$result = $updater->performUpdateTo($i, false);
399
+                $result = $updater->performUpdateTo($i, false);
400 400
 
401
-				if ($result) {
402
-					Debug::log("* Completed.");
403
-				} else {
404
-					Debug::log("One of the updates failed. Either retry the process or perform updates manually.");
405
-					return;
406
-				}
401
+                if ($result) {
402
+                    Debug::log("* Completed.");
403
+                } else {
404
+                    Debug::log("One of the updates failed. Either retry the process or perform updates manually.");
405
+                    return;
406
+                }
407 407
 
408
-			}
409
-		} else {
410
-			Debug::log("Update not required.");
411
-		}
408
+            }
409
+        } else {
410
+            Debug::log("Update not required.");
411
+        }
412 412
 
413
-	}
413
+    }
414 414
 
415
-	if (isset($options["gen-search-idx"])) {
416
-		echo "Generating search index (stemming set to English)...\n";
415
+    if (isset($options["gen-search-idx"])) {
416
+        echo "Generating search index (stemming set to English)...\n";
417 417
 
418
-		$res = $pdo->query("SELECT COUNT(id) AS count FROM ttrss_entries WHERE tsvector_combined IS NULL");
419
-		$row = $res->fetch();
420
-		$count = $row['count'];
418
+        $res = $pdo->query("SELECT COUNT(id) AS count FROM ttrss_entries WHERE tsvector_combined IS NULL");
419
+        $row = $res->fetch();
420
+        $count = $row['count'];
421 421
 
422
-		print "Articles to process: $count.\n";
422
+        print "Articles to process: $count.\n";
423 423
 
424
-		$limit = 500;
425
-		$processed = 0;
424
+        $limit = 500;
425
+        $processed = 0;
426 426
 
427
-		$sth = $pdo->prepare("SELECT id, title, content FROM ttrss_entries WHERE
427
+        $sth = $pdo->prepare("SELECT id, title, content FROM ttrss_entries WHERE
428 428
           tsvector_combined IS NULL ORDER BY id LIMIT ?");
429
-		$sth->execute([$limit]);
429
+        $sth->execute([$limit]);
430 430
 
431
-		$usth = $pdo->prepare("UPDATE ttrss_entries
431
+        $usth = $pdo->prepare("UPDATE ttrss_entries
432 432
           SET tsvector_combined = to_tsvector('english', ?) WHERE id = ?");
433 433
 
434
-		while (true) {
434
+        while (true) {
435 435
 
436
-			while ($line = $sth->fetch()) {
437
-				$tsvector_combined = mb_substr(strip_tags($line["title"]." ".$line["content"]), 0, 1000000);
436
+            while ($line = $sth->fetch()) {
437
+                $tsvector_combined = mb_substr(strip_tags($line["title"]." ".$line["content"]), 0, 1000000);
438 438
 
439
-				$usth->execute([$tsvector_combined, $line['id']]);
439
+                $usth->execute([$tsvector_combined, $line['id']]);
440 440
 
441
-				$processed++;
442
-			}
441
+                $processed++;
442
+            }
443 443
 
444
-			print "processed $processed articles...\n";
444
+            print "processed $processed articles...\n";
445 445
 
446
-			if ($processed < $limit) {
447
-				echo "All done.\n";
448
-				break;
449
-			}
450
-		}
451
-	}
446
+            if ($processed < $limit) {
447
+                echo "All done.\n";
448
+                break;
449
+            }
450
+        }
451
+    }
452 452
 
453
-	if (isset($options["list-plugins"])) {
454
-		$tmppluginhost = new PluginHost();
455
-		$tmppluginhost->load_all($tmppluginhost::KIND_ALL, false);
456
-		$enabled = array_map("trim", explode(",", PLUGINS));
453
+    if (isset($options["list-plugins"])) {
454
+        $tmppluginhost = new PluginHost();
455
+        $tmppluginhost->load_all($tmppluginhost::KIND_ALL, false);
456
+        $enabled = array_map("trim", explode(",", PLUGINS));
457 457
 
458
-		echo "List of all available plugins:\n";
458
+        echo "List of all available plugins:\n";
459 459
 
460
-		foreach ($tmppluginhost->get_plugins() as $name => $plugin) {
461
-			$about = $plugin->about();
460
+        foreach ($tmppluginhost->get_plugins() as $name => $plugin) {
461
+            $about = $plugin->about();
462 462
 
463
-			$status = $about[3] ? "system" : "user";
463
+            $status = $about[3] ? "system" : "user";
464 464
 
465
-			if (in_array($name, $enabled)) {
466
-			    $name .= "*";
467
-			}
465
+            if (in_array($name, $enabled)) {
466
+                $name .= "*";
467
+            }
468 468
 
469
-			printf("%-50s %-10s v%.2f (by %s)\n%s\n\n",
470
-				$name, $status, $about[0], $about[2], $about[1]);
471
-		}
469
+            printf("%-50s %-10s v%.2f (by %s)\n%s\n\n",
470
+                $name, $status, $about[0], $about[2], $about[1]);
471
+        }
472 472
 
473
-		echo "Plugins marked by * are currently enabled for all users.\n";
473
+        echo "Plugins marked by * are currently enabled for all users.\n";
474 474
 
475
-	}
475
+    }
476 476
 
477
-	if (isset($options["debug-feed"])) {
478
-		$feed = $options["debug-feed"];
477
+    if (isset($options["debug-feed"])) {
478
+        $feed = $options["debug-feed"];
479 479
 
480
-		if (isset($options["force-refetch"])) {
481
-		    $_REQUEST["force_refetch"] = true;
482
-		}
483
-		if (isset($options["force-rehash"])) {
484
-		    $_REQUEST["force_rehash"] = true;
485
-		}
480
+        if (isset($options["force-refetch"])) {
481
+            $_REQUEST["force_refetch"] = true;
482
+        }
483
+        if (isset($options["force-rehash"])) {
484
+            $_REQUEST["force_rehash"] = true;
485
+        }
486 486
 
487
-		Debug::set_loglevel(Debug::$LOG_EXTENDED);
487
+        Debug::set_loglevel(Debug::$LOG_EXTENDED);
488 488
 
489
-		$rc = RSSUtils::update_rss_feed($feed) != false ? 0 : 1;
489
+        $rc = RSSUtils::update_rss_feed($feed) != false ? 0 : 1;
490 490
 
491
-		exit($rc);
492
-	}
491
+        exit($rc);
492
+    }
493 493
 
494
-	if (isset($options["send-digests"])) {
495
-		Digest::send_headlines_digests();
496
-	}
494
+    if (isset($options["send-digests"])) {
495
+        Digest::send_headlines_digests();
496
+    }
497 497
 
498
-	PluginHost::getInstance()->run_commands($options);
498
+    PluginHost::getInstance()->run_commands($options);
499 499
 
500
-	if (file_exists(LOCK_DIRECTORY."/$lock_filename"))
501
-		if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
502
-			fclose($lock_handle);
503
-		unlink(LOCK_DIRECTORY."/$lock_filename");
500
+    if (file_exists(LOCK_DIRECTORY."/$lock_filename"))
501
+        if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
502
+            fclose($lock_handle);
503
+        unlink(LOCK_DIRECTORY."/$lock_filename");
Please login to merge, or discard this patch.
Braces   +3 added lines, -2 removed lines patch added patch discarded remove patch
@@ -497,7 +497,8 @@
 block discarded – undo
497 497
 
498 498
 	PluginHost::getInstance()->run_commands($options);
499 499
 
500
-	if (file_exists(LOCK_DIRECTORY."/$lock_filename"))
501
-		if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
500
+	if (file_exists(LOCK_DIRECTORY."/$lock_filename")) {
501
+			if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
502 502
 			fclose($lock_handle);
503
+	}
503 504
 		unlink(LOCK_DIRECTORY."/$lock_filename");
Please login to merge, or discard this patch.
classes/counters.php 1 patch
Indentation   +128 added lines, -128 removed lines patch added patch discarded remove patch
@@ -1,174 +1,174 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 class Counters {
3 3
 
4
-	public static function getAllCounters() {
5
-		$data = Counters::getGlobalCounters();
4
+    public static function getAllCounters() {
5
+        $data = Counters::getGlobalCounters();
6 6
 
7
-		$data = array_merge($data, Counters::getVirtCounters());
8
-		$data = array_merge($data, Counters::getLabelCounters());
9
-		$data = array_merge($data, Counters::getFeedCounters());
10
-		$data = array_merge($data, Counters::getCategoryCounters());
7
+        $data = array_merge($data, Counters::getVirtCounters());
8
+        $data = array_merge($data, Counters::getLabelCounters());
9
+        $data = array_merge($data, Counters::getFeedCounters());
10
+        $data = array_merge($data, Counters::getCategoryCounters());
11 11
 
12
-		return $data;
13
-	}
12
+        return $data;
13
+    }
14 14
 
15
-	public static function getCategoryCounters() {
16
-		$ret_arr = array();
15
+    public static function getCategoryCounters() {
16
+        $ret_arr = array();
17 17
 
18
-		/* Labels category */
18
+        /* Labels category */
19 19
 
20
-		$cv = array("id" => -2, "kind" => "cat",
21
-			"counter" => Feeds::getCategoryUnread(-2));
20
+        $cv = array("id" => -2, "kind" => "cat",
21
+            "counter" => Feeds::getCategoryUnread(-2));
22 22
 
23
-		array_push($ret_arr, $cv);
23
+        array_push($ret_arr, $cv);
24 24
 
25
-		$pdo = DB::pdo();
25
+        $pdo = DB::pdo();
26 26
 
27
-		$sth = $pdo->prepare("SELECT ttrss_feed_categories.id AS cat_id, value AS unread,
27
+        $sth = $pdo->prepare("SELECT ttrss_feed_categories.id AS cat_id, value AS unread,
28 28
 			(SELECT COUNT(id) FROM ttrss_feed_categories AS c2
29 29
 				WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children
30 30
 			FROM ttrss_feed_categories, ttrss_cat_counters_cache
31 31
 			WHERE ttrss_cat_counters_cache.feed_id = ttrss_feed_categories.id AND
32 32
 			ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND
33 33
 			ttrss_feed_categories.owner_uid = ?");
34
-		$sth->execute([$_SESSION['uid']]);
34
+        $sth->execute([$_SESSION['uid']]);
35 35
 
36
-		while ($line = $sth->fetch()) {
37
-			$line["cat_id"] = (int) $line["cat_id"];
36
+        while ($line = $sth->fetch()) {
37
+            $line["cat_id"] = (int) $line["cat_id"];
38 38
 
39
-			if ($line["num_children"] > 0) {
40
-				$child_counter = Feeds::getCategoryChildrenUnread($line["cat_id"], $_SESSION["uid"]);
41
-			} else {
42
-				$child_counter = 0;
43
-			}
39
+            if ($line["num_children"] > 0) {
40
+                $child_counter = Feeds::getCategoryChildrenUnread($line["cat_id"], $_SESSION["uid"]);
41
+            } else {
42
+                $child_counter = 0;
43
+            }
44 44
 
45
-			$cv = array("id" => $line["cat_id"], "kind" => "cat",
46
-				"counter" => $line["unread"] + $child_counter);
45
+            $cv = array("id" => $line["cat_id"], "kind" => "cat",
46
+                "counter" => $line["unread"] + $child_counter);
47 47
 
48
-			array_push($ret_arr, $cv);
49
-		}
48
+            array_push($ret_arr, $cv);
49
+        }
50 50
 
51
-		/* Special case: NULL category doesn't actually exist in the DB */
51
+        /* Special case: NULL category doesn't actually exist in the DB */
52 52
 
53
-		$cv = array("id" => 0, "kind" => "cat",
54
-			"counter" => (int) CCache::find(0, $_SESSION["uid"], true));
53
+        $cv = array("id" => 0, "kind" => "cat",
54
+            "counter" => (int) CCache::find(0, $_SESSION["uid"], true));
55 55
 
56
-		array_push($ret_arr, $cv);
56
+        array_push($ret_arr, $cv);
57 57
 
58
-		return $ret_arr;
59
-	}
58
+        return $ret_arr;
59
+    }
60 60
 
61
-	public static function getGlobalCounters($global_unread = -1) {
62
-		$ret_arr = array();
61
+    public static function getGlobalCounters($global_unread = -1) {
62
+        $ret_arr = array();
63 63
 
64
-		if ($global_unread == -1) {
65
-			$global_unread = Feeds::getGlobalUnread();
66
-		}
64
+        if ($global_unread == -1) {
65
+            $global_unread = Feeds::getGlobalUnread();
66
+        }
67 67
 
68
-		$cv = array("id" => "global-unread",
69
-			"counter" => (int) $global_unread);
68
+        $cv = array("id" => "global-unread",
69
+            "counter" => (int) $global_unread);
70 70
 
71
-		array_push($ret_arr, $cv);
71
+        array_push($ret_arr, $cv);
72 72
 
73
-		$pdo = Db::pdo();
73
+        $pdo = Db::pdo();
74 74
 
75
-		$sth = $pdo->prepare("SELECT COUNT(id) AS fn FROM
75
+        $sth = $pdo->prepare("SELECT COUNT(id) AS fn FROM
76 76
 			ttrss_feeds WHERE owner_uid = ?");
77
-		$sth->execute([$_SESSION['uid']]);
78
-		$row = $sth->fetch();
77
+        $sth->execute([$_SESSION['uid']]);
78
+        $row = $sth->fetch();
79 79
 
80
-		$subscribed_feeds = $row["fn"];
80
+        $subscribed_feeds = $row["fn"];
81 81
 
82
-		$cv = array("id" => "subscribed-feeds",
83
-			"counter" => (int) $subscribed_feeds);
82
+        $cv = array("id" => "subscribed-feeds",
83
+            "counter" => (int) $subscribed_feeds);
84 84
 
85
-		array_push($ret_arr, $cv);
85
+        array_push($ret_arr, $cv);
86 86
 
87
-		return $ret_arr;
88
-	}
87
+        return $ret_arr;
88
+    }
89 89
 
90
-	public static function getVirtCounters() {
90
+    public static function getVirtCounters() {
91 91
 
92
-		$ret_arr = array();
92
+        $ret_arr = array();
93 93
 
94
-		for ($i = 0; $i >= -4; $i--) {
94
+        for ($i = 0; $i >= -4; $i--) {
95 95
 
96
-			$count = getFeedUnread($i);
96
+            $count = getFeedUnread($i);
97 97
 
98
-			if ($i == 0 || $i == -1 || $i == -2) {
99
-							$auxctr = Feeds::getFeedArticles($i, false);
100
-			} else {
101
-							$auxctr = 0;
102
-			}
98
+            if ($i == 0 || $i == -1 || $i == -2) {
99
+                            $auxctr = Feeds::getFeedArticles($i, false);
100
+            } else {
101
+                            $auxctr = 0;
102
+            }
103 103
 
104
-			$cv = array("id" => $i,
105
-				"counter" => (int) $count,
106
-				"auxcounter" => (int) $auxctr);
104
+            $cv = array("id" => $i,
105
+                "counter" => (int) $count,
106
+                "auxcounter" => (int) $auxctr);
107 107
 
108 108
 //			if (get_pref('EXTENDED_FEEDLIST'))
109 109
 //				$cv["xmsg"] = getFeedArticles($i)." ".__("total");
110 110
 
111
-			array_push($ret_arr, $cv);
112
-		}
111
+            array_push($ret_arr, $cv);
112
+        }
113 113
 
114
-		$feeds = PluginHost::getInstance()->get_feeds(-1);
114
+        $feeds = PluginHost::getInstance()->get_feeds(-1);
115 115
 
116
-		if (is_array($feeds)) {
117
-			foreach ($feeds as $feed) {
118
-				$cv = array("id" => PluginHost::pfeed_to_feed_id($feed['id']),
119
-					"counter" => $feed['sender']->get_unread($feed['id']));
116
+        if (is_array($feeds)) {
117
+            foreach ($feeds as $feed) {
118
+                $cv = array("id" => PluginHost::pfeed_to_feed_id($feed['id']),
119
+                    "counter" => $feed['sender']->get_unread($feed['id']));
120 120
 
121
-				if (method_exists($feed['sender'], 'get_total')) {
122
-									$cv["auxcounter"] = $feed['sender']->get_total($feed['id']);
123
-				}
121
+                if (method_exists($feed['sender'], 'get_total')) {
122
+                                    $cv["auxcounter"] = $feed['sender']->get_total($feed['id']);
123
+                }
124 124
 
125
-				array_push($ret_arr, $cv);
126
-			}
127
-		}
125
+                array_push($ret_arr, $cv);
126
+            }
127
+        }
128 128
 
129
-		return $ret_arr;
130
-	}
129
+        return $ret_arr;
130
+    }
131 131
 
132
-	public static function getLabelCounters($descriptions = false) {
132
+    public static function getLabelCounters($descriptions = false) {
133 133
 
134
-		$ret_arr = array();
134
+        $ret_arr = array();
135 135
 
136
-		$pdo = Db::pdo();
136
+        $pdo = Db::pdo();
137 137
 
138
-		$sth = $pdo->prepare("SELECT id,caption,SUM(CASE WHEN u1.unread = true THEN 1 ELSE 0 END) AS unread, COUNT(u1.unread) AS total
138
+        $sth = $pdo->prepare("SELECT id,caption,SUM(CASE WHEN u1.unread = true THEN 1 ELSE 0 END) AS unread, COUNT(u1.unread) AS total
139 139
 			FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON
140 140
 				(ttrss_labels2.id = label_id)
141 141
 				LEFT JOIN ttrss_user_entries AS u1 ON u1.ref_id = article_id
142 142
 				WHERE ttrss_labels2.owner_uid = :uid AND u1.owner_uid = :uid
143 143
 				GROUP BY ttrss_labels2.id,
144 144
 					ttrss_labels2.caption");
145
-		$sth->execute([":uid" => $_SESSION['uid']]);
145
+        $sth->execute([":uid" => $_SESSION['uid']]);
146 146
 
147
-		while ($line = $sth->fetch()) {
147
+        while ($line = $sth->fetch()) {
148 148
 
149
-			$id = Labels::label_to_feed_id($line["id"]);
149
+            $id = Labels::label_to_feed_id($line["id"]);
150 150
 
151
-			$cv = array("id" => $id,
152
-				"counter" => (int) $line["unread"],
153
-				"auxcounter" => (int) $line["total"]);
151
+            $cv = array("id" => $id,
152
+                "counter" => (int) $line["unread"],
153
+                "auxcounter" => (int) $line["total"]);
154 154
 
155
-			if ($descriptions) {
156
-							$cv["description"] = $line["caption"];
157
-			}
155
+            if ($descriptions) {
156
+                            $cv["description"] = $line["caption"];
157
+            }
158 158
 
159
-			array_push($ret_arr, $cv);
160
-		}
159
+            array_push($ret_arr, $cv);
160
+        }
161 161
 
162
-		return $ret_arr;
163
-	}
162
+        return $ret_arr;
163
+    }
164 164
 
165
-	public static function getFeedCounters($active_feed = false) {
165
+    public static function getFeedCounters($active_feed = false) {
166 166
 
167
-		$ret_arr = array();
167
+        $ret_arr = array();
168 168
 
169
-		$pdo = Db::pdo();
169
+        $pdo = Db::pdo();
170 170
 
171
-		$sth = $pdo->prepare("SELECT ttrss_feeds.id,
171
+        $sth = $pdo->prepare("SELECT ttrss_feeds.id,
172 172
 				ttrss_feeds.title,
173 173
 				".SUBSTRING_FOR_DATE."(ttrss_feeds.last_updated,1,19) AS last_updated,
174 174
 				last_error, value AS count
@@ -176,47 +176,47 @@  discard block
 block discarded – undo
176 176
 			WHERE ttrss_feeds.owner_uid = ?
177 177
 				AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
178 178
 				AND ttrss_counters_cache.feed_id = ttrss_feeds.id");
179
-		$sth->execute([$_SESSION['uid']]);
179
+        $sth->execute([$_SESSION['uid']]);
180 180
 
181
-		while ($line = $sth->fetch()) {
181
+        while ($line = $sth->fetch()) {
182 182
 
183
-			$id = $line["id"];
184
-			$count = $line["count"];
185
-			$last_error = htmlspecialchars($line["last_error"]);
183
+            $id = $line["id"];
184
+            $count = $line["count"];
185
+            $last_error = htmlspecialchars($line["last_error"]);
186 186
 
187
-			$last_updated = make_local_datetime($line['last_updated'], false);
187
+            $last_updated = make_local_datetime($line['last_updated'], false);
188 188
 
189
-			if (Feeds::feedHasIcon($id)) {
190
-				$has_img = filemtime(Feeds::getIconFile($id));
191
-			} else {
192
-				$has_img = false;
193
-			}
189
+            if (Feeds::feedHasIcon($id)) {
190
+                $has_img = filemtime(Feeds::getIconFile($id));
191
+            } else {
192
+                $has_img = false;
193
+            }
194 194
 
195
-			if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2) {
196
-							$last_updated = '';
197
-			}
195
+            if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2) {
196
+                            $last_updated = '';
197
+            }
198 198
 
199
-			$cv = array("id" => $id,
200
-				"updated" => $last_updated,
201
-				"counter" => (int) $count,
202
-				"has_img" => (int) $has_img);
199
+            $cv = array("id" => $id,
200
+                "updated" => $last_updated,
201
+                "counter" => (int) $count,
202
+                "has_img" => (int) $has_img);
203 203
 
204
-			if ($last_error) {
205
-							$cv["error"] = $last_error;
206
-			}
204
+            if ($last_error) {
205
+                            $cv["error"] = $last_error;
206
+            }
207 207
 
208 208
 //			if (get_pref('EXTENDED_FEEDLIST'))
209 209
 //				$cv["xmsg"] = getFeedArticles($id)." ".__("total");
210 210
 
211
-			if ($active_feed && $id == $active_feed) {
212
-							$cv["title"] = truncate_string($line["title"], 30);
213
-			}
211
+            if ($active_feed && $id == $active_feed) {
212
+                            $cv["title"] = truncate_string($line["title"], 30);
213
+            }
214 214
 
215
-			array_push($ret_arr, $cv);
215
+            array_push($ret_arr, $cv);
216 216
 
217
-		}
217
+        }
218 218
 
219
-		return $ret_arr;
220
-	}
219
+        return $ret_arr;
220
+    }
221 221
 
222 222
 }
Please login to merge, or discard this patch.
classes/rssutils.php 3 patches
Indentation   +1292 added lines, -1292 removed lines patch added patch discarded remove patch
@@ -1,50 +1,50 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 class RSSUtils {
3
-	public static function calculate_article_hash($article, $pluginhost) {
4
-		$tmp = "";
5
-
6
-		foreach ($article as $k => $v) {
7
-			if ($k != "feed" && isset($v)) {
8
-				$x = strip_tags(is_array($v) ? implode(",", $v) : $v);
9
-
10
-				$tmp .= sha1("$k:".sha1($x));
11
-			}
12
-		}
13
-
14
-		return sha1(implode(",", $pluginhost->get_plugin_names()).$tmp);
15
-	}
16
-
17
-	// Strips utf8mb4 characters (i.e. emoji) for mysql
18
-	public static function strip_utf8mb4($str) {
19
-		return preg_replace('/[\x{10000}-\x{10FFFF}]/u', "\xEF\xBF\xBD", $str);
20
-	}
21
-
22
-	public static function cleanup_feed_browser() {
23
-		$pdo = Db::pdo();
24
-		$pdo->query("DELETE FROM ttrss_feedbrowser_cache");
25
-	}
26
-
27
-	public static function update_daemon_common($limit = DAEMON_FEED_LIMIT) {
28
-		$schema_version = get_schema_version();
29
-
30
-		if ($schema_version != SCHEMA_VERSION) {
31
-			die("Schema version is wrong, please upgrade the database.\n");
32
-		}
33
-
34
-		$pdo = Db::pdo();
35
-
36
-		if (!SINGLE_USER_MODE && DAEMON_UPDATE_LOGIN_LIMIT > 0) {
37
-			if (DB_TYPE == "pgsql") {
38
-				$login_thresh_qpart = "AND ttrss_users.last_login >= NOW() - INTERVAL '".DAEMON_UPDATE_LOGIN_LIMIT." days'";
39
-			} else {
40
-				$login_thresh_qpart = "AND ttrss_users.last_login >= DATE_SUB(NOW(), INTERVAL ".DAEMON_UPDATE_LOGIN_LIMIT." DAY)";
41
-			}
42
-		} else {
43
-			$login_thresh_qpart = "";
44
-		}
45
-
46
-		if (DB_TYPE == "pgsql") {
47
-			$update_limit_qpart = "AND ((
3
+    public static function calculate_article_hash($article, $pluginhost) {
4
+        $tmp = "";
5
+
6
+        foreach ($article as $k => $v) {
7
+            if ($k != "feed" && isset($v)) {
8
+                $x = strip_tags(is_array($v) ? implode(",", $v) : $v);
9
+
10
+                $tmp .= sha1("$k:".sha1($x));
11
+            }
12
+        }
13
+
14
+        return sha1(implode(",", $pluginhost->get_plugin_names()).$tmp);
15
+    }
16
+
17
+    // Strips utf8mb4 characters (i.e. emoji) for mysql
18
+    public static function strip_utf8mb4($str) {
19
+        return preg_replace('/[\x{10000}-\x{10FFFF}]/u', "\xEF\xBF\xBD", $str);
20
+    }
21
+
22
+    public static function cleanup_feed_browser() {
23
+        $pdo = Db::pdo();
24
+        $pdo->query("DELETE FROM ttrss_feedbrowser_cache");
25
+    }
26
+
27
+    public static function update_daemon_common($limit = DAEMON_FEED_LIMIT) {
28
+        $schema_version = get_schema_version();
29
+
30
+        if ($schema_version != SCHEMA_VERSION) {
31
+            die("Schema version is wrong, please upgrade the database.\n");
32
+        }
33
+
34
+        $pdo = Db::pdo();
35
+
36
+        if (!SINGLE_USER_MODE && DAEMON_UPDATE_LOGIN_LIMIT > 0) {
37
+            if (DB_TYPE == "pgsql") {
38
+                $login_thresh_qpart = "AND ttrss_users.last_login >= NOW() - INTERVAL '".DAEMON_UPDATE_LOGIN_LIMIT." days'";
39
+            } else {
40
+                $login_thresh_qpart = "AND ttrss_users.last_login >= DATE_SUB(NOW(), INTERVAL ".DAEMON_UPDATE_LOGIN_LIMIT." DAY)";
41
+            }
42
+        } else {
43
+            $login_thresh_qpart = "";
44
+        }
45
+
46
+        if (DB_TYPE == "pgsql") {
47
+            $update_limit_qpart = "AND ((
48 48
 					ttrss_feeds.update_interval = 0
49 49
 					AND ttrss_user_prefs.value != '-1'
50 50
 					AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL)
@@ -55,8 +55,8 @@  discard block
 block discarded – undo
55 55
 					AND ttrss_user_prefs.value != '-1')
56 56
 				OR (last_updated = '1970-01-01 00:00:00'
57 57
 					AND ttrss_user_prefs.value != '-1'))";
58
-		} else {
59
-			$update_limit_qpart = "AND ((
58
+        } else {
59
+            $update_limit_qpart = "AND ((
60 60
 					ttrss_feeds.update_interval = 0
61 61
 					AND ttrss_user_prefs.value != '-1'
62 62
 					AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER) MINUTE)
@@ -67,24 +67,24 @@  discard block
 block discarded – undo
67 67
 					AND ttrss_user_prefs.value != '-1')
68 68
 				OR (last_updated = '1970-01-01 00:00:00'
69 69
 					AND ttrss_user_prefs.value != '-1'))";
70
-		}
70
+        }
71 71
 
72
-		// Test if feed is currently being updated by another process.
73
-		if (DB_TYPE == "pgsql") {
74
-			$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '10 minutes')";
75
-		} else {
76
-			$updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 10 MINUTE))";
77
-		}
72
+        // Test if feed is currently being updated by another process.
73
+        if (DB_TYPE == "pgsql") {
74
+            $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '10 minutes')";
75
+        } else {
76
+            $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 10 MINUTE))";
77
+        }
78 78
 
79
-		$query_limit = $limit ? sprintf("LIMIT %d", $limit) : "";
79
+        $query_limit = $limit ? sprintf("LIMIT %d", $limit) : "";
80 80
 
81
-		// Update the least recently updated feeds first
82
-		$query_order = "ORDER BY last_updated";
83
-		if (DB_TYPE == "pgsql") {
84
-		    $query_order .= " NULLS FIRST";
85
-		}
81
+        // Update the least recently updated feeds first
82
+        $query_order = "ORDER BY last_updated";
83
+        if (DB_TYPE == "pgsql") {
84
+            $query_order .= " NULLS FIRST";
85
+        }
86 86
 
87
-		$query = "SELECT DISTINCT ttrss_feeds.feed_url, ttrss_feeds.last_updated
87
+        $query = "SELECT DISTINCT ttrss_feeds.feed_url, ttrss_feeds.last_updated
88 88
 			FROM
89 89
 				ttrss_feeds, ttrss_users, ttrss_user_prefs
90 90
 			WHERE
@@ -96,32 +96,32 @@  discard block
 block discarded – undo
96 96
 				$updstart_thresh_qpart
97 97
 				$query_order $query_limit";
98 98
 
99
-		$res = $pdo->query($query);
99
+        $res = $pdo->query($query);
100 100
 
101
-		$feeds_to_update = array();
102
-		while ($line = $res->fetch()) {
103
-			array_push($feeds_to_update, $line['feed_url']);
104
-		}
101
+        $feeds_to_update = array();
102
+        while ($line = $res->fetch()) {
103
+            array_push($feeds_to_update, $line['feed_url']);
104
+        }
105 105
 
106
-		Debug::log(sprintf("Scheduled %d feeds to update...", count($feeds_to_update)));
106
+        Debug::log(sprintf("Scheduled %d feeds to update...", count($feeds_to_update)));
107 107
 
108
-		// Update last_update_started before actually starting the batch
109
-		// in order to minimize collision risk for parallel daemon tasks
110
-		if (count($feeds_to_update) > 0) {
111
-			$feeds_qmarks = arr_qmarks($feeds_to_update);
108
+        // Update last_update_started before actually starting the batch
109
+        // in order to minimize collision risk for parallel daemon tasks
110
+        if (count($feeds_to_update) > 0) {
111
+            $feeds_qmarks = arr_qmarks($feeds_to_update);
112 112
 
113
-			$tmph = $pdo->prepare("UPDATE ttrss_feeds SET last_update_started = NOW()
113
+            $tmph = $pdo->prepare("UPDATE ttrss_feeds SET last_update_started = NOW()
114 114
 				WHERE feed_url IN ($feeds_qmarks)");
115
-			$tmph->execute($feeds_to_update);
116
-		}
115
+            $tmph->execute($feeds_to_update);
116
+        }
117 117
 
118
-		$nf = 0;
119
-		$bstarted = microtime(true);
118
+        $nf = 0;
119
+        $bstarted = microtime(true);
120 120
 
121
-		$batch_owners = array();
121
+        $batch_owners = array();
122 122
 
123
-		// since we have the data cached, we can deal with other feeds with the same url
124
-		$usth = $pdo->prepare("SELECT DISTINCT ttrss_feeds.id,last_updated,ttrss_feeds.owner_uid
123
+        // since we have the data cached, we can deal with other feeds with the same url
124
+        $usth = $pdo->prepare("SELECT DISTINCT ttrss_feeds.id,last_updated,ttrss_feeds.owner_uid
125 125
 			FROM ttrss_feeds, ttrss_users, ttrss_user_prefs WHERE
126 126
 				ttrss_user_prefs.owner_uid = ttrss_feeds.owner_uid AND
127 127
 				ttrss_users.id = ttrss_user_prefs.owner_uid AND
@@ -132,724 +132,724 @@  discard block
 block discarded – undo
132 132
 				$login_thresh_qpart
133 133
 			ORDER BY ttrss_feeds.id $query_limit");
134 134
 
135
-		foreach ($feeds_to_update as $feed) {
136
-			Debug::log("Base feed: $feed");
135
+        foreach ($feeds_to_update as $feed) {
136
+            Debug::log("Base feed: $feed");
137 137
 
138
-			$usth->execute([$feed]);
139
-			//update_rss_feed($line["id"], true);
138
+            $usth->execute([$feed]);
139
+            //update_rss_feed($line["id"], true);
140 140
 
141
-			if ($tline = $usth->fetch()) {
142
-				Debug::log(" => ".$tline["last_updated"].", ".$tline["id"]." ".$tline["owner_uid"]);
141
+            if ($tline = $usth->fetch()) {
142
+                Debug::log(" => ".$tline["last_updated"].", ".$tline["id"]." ".$tline["owner_uid"]);
143 143
 
144
-				if (array_search($tline["owner_uid"], $batch_owners) === false) {
145
-									array_push($batch_owners, $tline["owner_uid"]);
146
-				}
144
+                if (array_search($tline["owner_uid"], $batch_owners) === false) {
145
+                                    array_push($batch_owners, $tline["owner_uid"]);
146
+                }
147 147
 
148
-				$fstarted = microtime(true);
148
+                $fstarted = microtime(true);
149 149
 
150
-				try {
151
-					RSSUtils::update_rss_feed($tline["id"], true, false);
152
-				} catch (PDOException $e) {
153
-					Logger::get()->log_error(E_USER_NOTICE, $e->getMessage(), $e->getFile(), $e->getLine(), $e->getTraceAsString());
150
+                try {
151
+                    RSSUtils::update_rss_feed($tline["id"], true, false);
152
+                } catch (PDOException $e) {
153
+                    Logger::get()->log_error(E_USER_NOTICE, $e->getMessage(), $e->getFile(), $e->getLine(), $e->getTraceAsString());
154 154
 
155
-					try {
156
-						$pdo->rollback();
157
-					} catch (PDOException $e) {
158
-						// it doesn't matter if there wasn't actually anything to rollback, PDO Exception can be
159
-						// thrown outside of an active transaction during feed update
160
-					}
161
-				}
155
+                    try {
156
+                        $pdo->rollback();
157
+                    } catch (PDOException $e) {
158
+                        // it doesn't matter if there wasn't actually anything to rollback, PDO Exception can be
159
+                        // thrown outside of an active transaction during feed update
160
+                    }
161
+                }
162 162
 
163
-				Debug::log(sprintf("    %.4f (sec)", microtime(true) - $fstarted));
163
+                Debug::log(sprintf("    %.4f (sec)", microtime(true) - $fstarted));
164 164
 
165
-				++$nf;
166
-			}
167
-		}
165
+                ++$nf;
166
+            }
167
+        }
168 168
 
169
-		if ($nf > 0) {
170
-			Debug::log(sprintf("Processed %d feeds in %.4f (sec), %.4f (sec/feed avg)", $nf,
171
-				microtime(true) - $bstarted, (microtime(true) - $bstarted) / $nf));
172
-		}
169
+        if ($nf > 0) {
170
+            Debug::log(sprintf("Processed %d feeds in %.4f (sec), %.4f (sec/feed avg)", $nf,
171
+                microtime(true) - $bstarted, (microtime(true) - $bstarted) / $nf));
172
+        }
173 173
 
174
-		foreach ($batch_owners as $owner_uid) {
175
-			Debug::log("Running housekeeping tasks for user $owner_uid...");
174
+        foreach ($batch_owners as $owner_uid) {
175
+            Debug::log("Running housekeeping tasks for user $owner_uid...");
176 176
 
177
-			RSSUtils::housekeeping_user($owner_uid);
178
-		}
177
+            RSSUtils::housekeeping_user($owner_uid);
178
+        }
179 179
 
180
-		// Send feed digests by email if needed.
181
-		Digest::send_headlines_digests();
180
+        // Send feed digests by email if needed.
181
+        Digest::send_headlines_digests();
182 182
 
183
-		return $nf;
184
-	}
183
+        return $nf;
184
+    }
185 185
 
186
-	// this is used when subscribing
187
-	public static function set_basic_feed_info($feed) {
186
+    // this is used when subscribing
187
+    public static function set_basic_feed_info($feed) {
188 188
 
189
-		$pdo = Db::pdo();
189
+        $pdo = Db::pdo();
190 190
 
191
-		$sth = $pdo->prepare("SELECT owner_uid,feed_url,auth_pass,auth_login
191
+        $sth = $pdo->prepare("SELECT owner_uid,feed_url,auth_pass,auth_login
192 192
 				FROM ttrss_feeds WHERE id = ?");
193
-		$sth->execute([$feed]);
193
+        $sth->execute([$feed]);
194 194
 
195
-		if ($row = $sth->fetch()) {
195
+        if ($row = $sth->fetch()) {
196 196
 
197
-			$owner_uid = $row["owner_uid"];
198
-			$auth_login = $row["auth_login"];
199
-			$auth_pass = $row["auth_pass"];
200
-			$fetch_url = $row["feed_url"];
197
+            $owner_uid = $row["owner_uid"];
198
+            $auth_login = $row["auth_login"];
199
+            $auth_pass = $row["auth_pass"];
200
+            $fetch_url = $row["feed_url"];
201 201
 
202
-			$pluginhost = new PluginHost();
203
-			$user_plugins = get_pref("_ENABLED_PLUGINS", $owner_uid);
202
+            $pluginhost = new PluginHost();
203
+            $user_plugins = get_pref("_ENABLED_PLUGINS", $owner_uid);
204 204
 
205
-			$pluginhost->load(PLUGINS, PluginHost::KIND_ALL);
206
-			$pluginhost->load($user_plugins, PluginHost::KIND_USER, $owner_uid);
207
-			$pluginhost->load_data();
205
+            $pluginhost->load(PLUGINS, PluginHost::KIND_ALL);
206
+            $pluginhost->load($user_plugins, PluginHost::KIND_USER, $owner_uid);
207
+            $pluginhost->load_data();
208 208
 
209
-			$basic_info = array();
210
-			foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_BASIC_INFO) as $plugin) {
211
-				$basic_info = $plugin->hook_feed_basic_info($basic_info, $fetch_url, $owner_uid, $feed, $auth_login, $auth_pass);
212
-			}
209
+            $basic_info = array();
210
+            foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_BASIC_INFO) as $plugin) {
211
+                $basic_info = $plugin->hook_feed_basic_info($basic_info, $fetch_url, $owner_uid, $feed, $auth_login, $auth_pass);
212
+            }
213 213
 
214
-			if (!$basic_info) {
215
-				$feed_data = fetch_file_contents($fetch_url, false,
216
-					$auth_login, $auth_pass, false,
217
-					FEED_FETCH_TIMEOUT,
218
-					0);
214
+            if (!$basic_info) {
215
+                $feed_data = fetch_file_contents($fetch_url, false,
216
+                    $auth_login, $auth_pass, false,
217
+                    FEED_FETCH_TIMEOUT,
218
+                    0);
219 219
 
220
-				$feed_data = trim($feed_data);
220
+                $feed_data = trim($feed_data);
221 221
 
222
-				$rss = new FeedParser($feed_data);
223
-				$rss->init();
222
+                $rss = new FeedParser($feed_data);
223
+                $rss->init();
224 224
 
225
-				if (!$rss->error()) {
226
-					$basic_info = array(
227
-						'title' => mb_substr(clean($rss->get_title()), 0, 199),
228
-						'site_url' => mb_substr(rewrite_relative_url($fetch_url, clean($rss->get_link())), 0, 245)
229
-					);
230
-				}
231
-			}
225
+                if (!$rss->error()) {
226
+                    $basic_info = array(
227
+                        'title' => mb_substr(clean($rss->get_title()), 0, 199),
228
+                        'site_url' => mb_substr(rewrite_relative_url($fetch_url, clean($rss->get_link())), 0, 245)
229
+                    );
230
+                }
231
+            }
232 232
 
233
-			if ($basic_info && is_array($basic_info)) {
234
-				$sth = $pdo->prepare("SELECT title, site_url FROM ttrss_feeds WHERE id = ?");
235
-				$sth->execute([$feed]);
233
+            if ($basic_info && is_array($basic_info)) {
234
+                $sth = $pdo->prepare("SELECT title, site_url FROM ttrss_feeds WHERE id = ?");
235
+                $sth->execute([$feed]);
236 236
 
237
-				if ($row = $sth->fetch()) {
237
+                if ($row = $sth->fetch()) {
238 238
 
239
-					$registered_title = $row["title"];
240
-					$orig_site_url = $row["site_url"];
239
+                    $registered_title = $row["title"];
240
+                    $orig_site_url = $row["site_url"];
241 241
 
242
-					if ($basic_info['title'] && (!$registered_title || $registered_title == "[Unknown]")) {
242
+                    if ($basic_info['title'] && (!$registered_title || $registered_title == "[Unknown]")) {
243 243
 
244
-						$sth = $pdo->prepare("UPDATE ttrss_feeds SET
244
+                        $sth = $pdo->prepare("UPDATE ttrss_feeds SET
245 245
 							title = ? WHERE id = ?");
246
-						$sth->execute([$basic_info['title'], $feed]);
247
-					}
246
+                        $sth->execute([$basic_info['title'], $feed]);
247
+                    }
248 248
 
249
-					if ($basic_info['site_url'] && $orig_site_url != $basic_info['site_url']) {
250
-						$sth = $pdo->prepare("UPDATE ttrss_feeds SET
249
+                    if ($basic_info['site_url'] && $orig_site_url != $basic_info['site_url']) {
250
+                        $sth = $pdo->prepare("UPDATE ttrss_feeds SET
251 251
 							site_url = ? WHERE id = ?");
252
-						$sth->execute([$basic_info['site_url'], $feed]);
253
-					}
252
+                        $sth->execute([$basic_info['site_url'], $feed]);
253
+                    }
254 254
 
255
-				}
256
-			}
257
-		}
258
-	}
255
+                }
256
+            }
257
+        }
258
+    }
259 259
 
260
-	/**
261
-	 * @SuppressWarnings(PHPMD.UnusedFormalParameter)
262
-	 */
263
-	public static function update_rss_feed($feed, $no_cache = false) {
260
+    /**
261
+     * @SuppressWarnings(PHPMD.UnusedFormalParameter)
262
+     */
263
+    public static function update_rss_feed($feed, $no_cache = false) {
264 264
 
265
-		reset_fetch_domain_quota();
265
+        reset_fetch_domain_quota();
266 266
 
267
-		Debug::log("start", Debug::$LOG_VERBOSE);
267
+        Debug::log("start", Debug::$LOG_VERBOSE);
268 268
 
269
-		$pdo = Db::pdo();
269
+        $pdo = Db::pdo();
270 270
 
271
-		$sth = $pdo->prepare("SELECT title, site_url FROM ttrss_feeds WHERE id = ?");
272
-		$sth->execute([$feed]);
271
+        $sth = $pdo->prepare("SELECT title, site_url FROM ttrss_feeds WHERE id = ?");
272
+        $sth->execute([$feed]);
273 273
 
274
-		if (!$row = $sth->fetch()) {
275
-			Debug::log("feed $feed not found, skipping.");
276
-			user_error("Attempt to update unknown/invalid feed $feed", E_USER_WARNING);
277
-			return false;
278
-		}
274
+        if (!$row = $sth->fetch()) {
275
+            Debug::log("feed $feed not found, skipping.");
276
+            user_error("Attempt to update unknown/invalid feed $feed", E_USER_WARNING);
277
+            return false;
278
+        }
279 279
 
280
-		$title = $row["title"];
281
-		$site_url = $row["site_url"];
280
+        $title = $row["title"];
281
+        $site_url = $row["site_url"];
282 282
 
283
-		// feed was batch-subscribed or something, we need to get basic info
284
-		// this is not optimal currently as it fetches stuff separately TODO: optimize
285
-		if ($title == "[Unknown]" || !$title || !$site_url) {
286
-			Debug::log("setting basic feed info for $feed [$title, $site_url]...");
287
-			RSSUtils::set_basic_feed_info($feed);
288
-		}
283
+        // feed was batch-subscribed or something, we need to get basic info
284
+        // this is not optimal currently as it fetches stuff separately TODO: optimize
285
+        if ($title == "[Unknown]" || !$title || !$site_url) {
286
+            Debug::log("setting basic feed info for $feed [$title, $site_url]...");
287
+            RSSUtils::set_basic_feed_info($feed);
288
+        }
289 289
 
290
-		$sth = $pdo->prepare("SELECT id,update_interval,auth_login,
290
+        $sth = $pdo->prepare("SELECT id,update_interval,auth_login,
291 291
 			feed_url,auth_pass,cache_images,
292 292
 			mark_unread_on_update, owner_uid,
293 293
 			auth_pass_encrypted, feed_language,
294 294
 			last_modified,
295 295
 			".SUBSTRING_FOR_DATE."(last_unconditional, 1, 19) AS last_unconditional
296 296
 			FROM ttrss_feeds WHERE id = ?");
297
-		$sth->execute([$feed]);
297
+        $sth->execute([$feed]);
298 298
 
299
-		if ($row = $sth->fetch()) {
299
+        if ($row = $sth->fetch()) {
300 300
 
301
-			$owner_uid = $row["owner_uid"];
302
-			$mark_unread_on_update = $row["mark_unread_on_update"];
301
+            $owner_uid = $row["owner_uid"];
302
+            $mark_unread_on_update = $row["mark_unread_on_update"];
303 303
 
304
-			$sth = $pdo->prepare("UPDATE ttrss_feeds SET last_update_started = NOW()
304
+            $sth = $pdo->prepare("UPDATE ttrss_feeds SET last_update_started = NOW()
305 305
 				WHERE id = ?");
306
-			$sth->execute([$feed]);
306
+            $sth->execute([$feed]);
307 307
 
308
-			$auth_login = $row["auth_login"];
309
-			$auth_pass = $row["auth_pass"];
310
-			$stored_last_modified = $row["last_modified"];
311
-			$last_unconditional = $row["last_unconditional"];
312
-			$cache_images = $row["cache_images"];
313
-			$fetch_url = $row["feed_url"];
308
+            $auth_login = $row["auth_login"];
309
+            $auth_pass = $row["auth_pass"];
310
+            $stored_last_modified = $row["last_modified"];
311
+            $last_unconditional = $row["last_unconditional"];
312
+            $cache_images = $row["cache_images"];
313
+            $fetch_url = $row["feed_url"];
314 314
 
315
-			$feed_language = mb_strtolower($row["feed_language"]);
315
+            $feed_language = mb_strtolower($row["feed_language"]);
316 316
 
317
-			if (!$feed_language) {
318
-							$feed_language = mb_strtolower(get_pref('DEFAULT_SEARCH_LANGUAGE', $owner_uid));
319
-			}
317
+            if (!$feed_language) {
318
+                            $feed_language = mb_strtolower(get_pref('DEFAULT_SEARCH_LANGUAGE', $owner_uid));
319
+            }
320 320
 
321
-			if (!$feed_language) {
322
-							$feed_language = 'simple';
323
-			}
321
+            if (!$feed_language) {
322
+                            $feed_language = 'simple';
323
+            }
324 324
 
325
-		} else {
326
-			return false;
327
-		}
325
+        } else {
326
+            return false;
327
+        }
328 328
 
329
-		$date_feed_processed = date('Y-m-d H:i');
329
+        $date_feed_processed = date('Y-m-d H:i');
330 330
 
331
-		$cache_filename = CACHE_DIR."/feeds/".sha1($fetch_url).".xml";
331
+        $cache_filename = CACHE_DIR."/feeds/".sha1($fetch_url).".xml";
332 332
 
333
-		$pluginhost = new PluginHost();
334
-		$user_plugins = get_pref("_ENABLED_PLUGINS", $owner_uid);
333
+        $pluginhost = new PluginHost();
334
+        $user_plugins = get_pref("_ENABLED_PLUGINS", $owner_uid);
335 335
 
336
-		$pluginhost->load(PLUGINS, PluginHost::KIND_ALL);
337
-		$pluginhost->load($user_plugins, PluginHost::KIND_USER, $owner_uid);
338
-		$pluginhost->load_data();
336
+        $pluginhost->load(PLUGINS, PluginHost::KIND_ALL);
337
+        $pluginhost->load($user_plugins, PluginHost::KIND_USER, $owner_uid);
338
+        $pluginhost->load_data();
339 339
 
340
-		$rss_hash = false;
340
+        $rss_hash = false;
341 341
 
342
-		$force_refetch = isset($_REQUEST["force_refetch"]);
343
-		$feed_data = "";
342
+        $force_refetch = isset($_REQUEST["force_refetch"]);
343
+        $feed_data = "";
344 344
 
345
-		Debug::log("running HOOK_FETCH_FEED handlers...", Debug::$LOG_VERBOSE);
345
+        Debug::log("running HOOK_FETCH_FEED handlers...", Debug::$LOG_VERBOSE);
346 346
 
347
-		foreach ($pluginhost->get_hooks(PluginHost::HOOK_FETCH_FEED) as $plugin) {
348
-			Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
349
-			$start = microtime(true);
350
-			$feed_data = $plugin->hook_fetch_feed($feed_data, $fetch_url, $owner_uid, $feed, 0, $auth_login, $auth_pass);
351
-			Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
352
-		}
347
+        foreach ($pluginhost->get_hooks(PluginHost::HOOK_FETCH_FEED) as $plugin) {
348
+            Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
349
+            $start = microtime(true);
350
+            $feed_data = $plugin->hook_fetch_feed($feed_data, $fetch_url, $owner_uid, $feed, 0, $auth_login, $auth_pass);
351
+            Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
352
+        }
353 353
 
354
-		if ($feed_data) {
355
-			Debug::log("feed data has been modified by a plugin.", Debug::$LOG_VERBOSE);
356
-		} else {
357
-			Debug::log("feed data has not been modified by a plugin.", Debug::$LOG_VERBOSE);
358
-		}
354
+        if ($feed_data) {
355
+            Debug::log("feed data has been modified by a plugin.", Debug::$LOG_VERBOSE);
356
+        } else {
357
+            Debug::log("feed data has not been modified by a plugin.", Debug::$LOG_VERBOSE);
358
+        }
359 359
 
360
-		// try cache
361
-		if (!$feed_data &&
362
-			file_exists($cache_filename) &&
363
-			is_readable($cache_filename) &&
364
-			!$auth_login && !$auth_pass &&
365
-			filemtime($cache_filename) > time() - 30) {
360
+        // try cache
361
+        if (!$feed_data &&
362
+            file_exists($cache_filename) &&
363
+            is_readable($cache_filename) &&
364
+            !$auth_login && !$auth_pass &&
365
+            filemtime($cache_filename) > time() - 30) {
366 366
 
367
-			Debug::log("using local cache [$cache_filename].", Debug::$LOG_VERBOSE);
367
+            Debug::log("using local cache [$cache_filename].", Debug::$LOG_VERBOSE);
368 368
 
369
-			@$feed_data = file_get_contents($cache_filename);
369
+            @$feed_data = file_get_contents($cache_filename);
370 370
 
371
-			if ($feed_data) {
372
-				$rss_hash = sha1($feed_data);
373
-			}
371
+            if ($feed_data) {
372
+                $rss_hash = sha1($feed_data);
373
+            }
374 374
 
375
-		} else {
376
-			Debug::log("local cache will not be used for this feed", Debug::$LOG_VERBOSE);
377
-		}
375
+        } else {
376
+            Debug::log("local cache will not be used for this feed", Debug::$LOG_VERBOSE);
377
+        }
378 378
 
379
-		global $fetch_last_modified;
379
+        global $fetch_last_modified;
380 380
 
381
-		// fetch feed from source
382
-		if (!$feed_data) {
383
-			Debug::log("last unconditional update request: $last_unconditional", Debug::$LOG_VERBOSE);
381
+        // fetch feed from source
382
+        if (!$feed_data) {
383
+            Debug::log("last unconditional update request: $last_unconditional", Debug::$LOG_VERBOSE);
384 384
 
385
-			if (ini_get("open_basedir") && function_exists("curl_init")) {
386
-				Debug::log("not using CURL due to open_basedir restrictions", Debug::$LOG_VERBOSE);
387
-			}
385
+            if (ini_get("open_basedir") && function_exists("curl_init")) {
386
+                Debug::log("not using CURL due to open_basedir restrictions", Debug::$LOG_VERBOSE);
387
+            }
388 388
 
389
-			if (time() - strtotime($last_unconditional) > MAX_CONDITIONAL_INTERVAL) {
390
-				Debug::log("maximum allowed interval for conditional requests exceeded, forcing refetch", Debug::$LOG_VERBOSE);
389
+            if (time() - strtotime($last_unconditional) > MAX_CONDITIONAL_INTERVAL) {
390
+                Debug::log("maximum allowed interval for conditional requests exceeded, forcing refetch", Debug::$LOG_VERBOSE);
391 391
 
392
-				$force_refetch = true;
393
-			} else {
394
-				Debug::log("stored last modified for conditional request: $stored_last_modified", Debug::$LOG_VERBOSE);
395
-			}
392
+                $force_refetch = true;
393
+            } else {
394
+                Debug::log("stored last modified for conditional request: $stored_last_modified", Debug::$LOG_VERBOSE);
395
+            }
396 396
 
397
-			Debug::log("fetching [$fetch_url] (force_refetch: $force_refetch)...", Debug::$LOG_VERBOSE);
397
+            Debug::log("fetching [$fetch_url] (force_refetch: $force_refetch)...", Debug::$LOG_VERBOSE);
398 398
 
399
-			$feed_data = fetch_file_contents([
400
-				"url" => $fetch_url,
401
-				"login" => $auth_login,
402
-				"pass" => $auth_pass,
403
-				"timeout" => $no_cache ? FEED_FETCH_NO_CACHE_TIMEOUT : FEED_FETCH_TIMEOUT,
404
-				"last_modified" => $force_refetch ? "" : $stored_last_modified
405
-			]);
399
+            $feed_data = fetch_file_contents([
400
+                "url" => $fetch_url,
401
+                "login" => $auth_login,
402
+                "pass" => $auth_pass,
403
+                "timeout" => $no_cache ? FEED_FETCH_NO_CACHE_TIMEOUT : FEED_FETCH_TIMEOUT,
404
+                "last_modified" => $force_refetch ? "" : $stored_last_modified
405
+            ]);
406 406
 
407
-			$feed_data = trim($feed_data);
407
+            $feed_data = trim($feed_data);
408 408
 
409
-			Debug::log("fetch done.", Debug::$LOG_VERBOSE);
410
-			Debug::log("source last modified: ".$fetch_last_modified, Debug::$LOG_VERBOSE);
409
+            Debug::log("fetch done.", Debug::$LOG_VERBOSE);
410
+            Debug::log("source last modified: ".$fetch_last_modified, Debug::$LOG_VERBOSE);
411 411
 
412
-			if ($feed_data && $fetch_last_modified != $stored_last_modified) {
413
-				$sth = $pdo->prepare("UPDATE ttrss_feeds SET last_modified = ? WHERE id = ?");
414
-				$sth->execute([substr($fetch_last_modified, 0, 245), $feed]);
415
-			}
412
+            if ($feed_data && $fetch_last_modified != $stored_last_modified) {
413
+                $sth = $pdo->prepare("UPDATE ttrss_feeds SET last_modified = ? WHERE id = ?");
414
+                $sth->execute([substr($fetch_last_modified, 0, 245), $feed]);
415
+            }
416 416
 
417
-			// cache vanilla feed data for re-use
418
-			if ($feed_data && !$auth_pass && !$auth_login && is_writable(CACHE_DIR."/feeds")) {
419
-				$new_rss_hash = sha1($feed_data);
417
+            // cache vanilla feed data for re-use
418
+            if ($feed_data && !$auth_pass && !$auth_login && is_writable(CACHE_DIR."/feeds")) {
419
+                $new_rss_hash = sha1($feed_data);
420 420
 
421
-				if ($new_rss_hash != $rss_hash) {
422
-					Debug::log("saving $cache_filename", Debug::$LOG_VERBOSE);
423
-					@file_put_contents($cache_filename, $feed_data);
424
-				}
425
-			}
426
-		}
421
+                if ($new_rss_hash != $rss_hash) {
422
+                    Debug::log("saving $cache_filename", Debug::$LOG_VERBOSE);
423
+                    @file_put_contents($cache_filename, $feed_data);
424
+                }
425
+            }
426
+        }
427 427
 
428
-		if (!$feed_data) {
429
-			global $fetch_last_error;
430
-			global $fetch_last_error_code;
428
+        if (!$feed_data) {
429
+            global $fetch_last_error;
430
+            global $fetch_last_error_code;
431 431
 
432
-			Debug::log("unable to fetch: $fetch_last_error [$fetch_last_error_code]", Debug::$LOG_VERBOSE);
432
+            Debug::log("unable to fetch: $fetch_last_error [$fetch_last_error_code]", Debug::$LOG_VERBOSE);
433 433
 
434
-			// If-Modified-Since
435
-			if ($fetch_last_error_code != 304) {
436
-				$error_message = $fetch_last_error;
437
-			} else {
438
-				Debug::log("source claims data not modified, nothing to do.", Debug::$LOG_VERBOSE);
439
-				$error_message = "";
440
-			}
434
+            // If-Modified-Since
435
+            if ($fetch_last_error_code != 304) {
436
+                $error_message = $fetch_last_error;
437
+            } else {
438
+                Debug::log("source claims data not modified, nothing to do.", Debug::$LOG_VERBOSE);
439
+                $error_message = "";
440
+            }
441 441
 
442
-			$sth = $pdo->prepare("UPDATE ttrss_feeds SET last_error = ?,
442
+            $sth = $pdo->prepare("UPDATE ttrss_feeds SET last_error = ?,
443 443
 					last_updated = NOW() WHERE id = ?");
444
-			$sth->execute([$error_message, $feed]);
444
+            $sth->execute([$error_message, $feed]);
445 445
 
446
-			return;
447
-		}
446
+            return;
447
+        }
448 448
 
449
-		Debug::log("running HOOK_FEED_FETCHED handlers...", Debug::$LOG_VERBOSE);
450
-		$feed_data_checksum = md5($feed_data);
449
+        Debug::log("running HOOK_FEED_FETCHED handlers...", Debug::$LOG_VERBOSE);
450
+        $feed_data_checksum = md5($feed_data);
451 451
 
452
-		foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_FETCHED) as $plugin) {
453
-			Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
454
-			$start = microtime(true);
455
-			$feed_data = $plugin->hook_feed_fetched($feed_data, $fetch_url, $owner_uid, $feed);
456
-			Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
457
-		}
452
+        foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_FETCHED) as $plugin) {
453
+            Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
454
+            $start = microtime(true);
455
+            $feed_data = $plugin->hook_feed_fetched($feed_data, $fetch_url, $owner_uid, $feed);
456
+            Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
457
+        }
458 458
 
459
-		if (md5($feed_data) != $feed_data_checksum) {
460
-			Debug::log("feed data has been modified by a plugin.", Debug::$LOG_VERBOSE);
461
-		} else {
462
-			Debug::log("feed data has not been modified by a plugin.", Debug::$LOG_VERBOSE);
463
-		}
459
+        if (md5($feed_data) != $feed_data_checksum) {
460
+            Debug::log("feed data has been modified by a plugin.", Debug::$LOG_VERBOSE);
461
+        } else {
462
+            Debug::log("feed data has not been modified by a plugin.", Debug::$LOG_VERBOSE);
463
+        }
464 464
 
465
-		$rss = new FeedParser($feed_data);
466
-		$rss->init();
465
+        $rss = new FeedParser($feed_data);
466
+        $rss->init();
467 467
 
468
-		if (!$rss->error()) {
468
+        if (!$rss->error()) {
469 469
 
470
-			Debug::log("running HOOK_FEED_PARSED handlers...", Debug::$LOG_VERBOSE);
470
+            Debug::log("running HOOK_FEED_PARSED handlers...", Debug::$LOG_VERBOSE);
471 471
 
472
-			// We use local pluginhost here because we need to load different per-user feed plugins
472
+            // We use local pluginhost here because we need to load different per-user feed plugins
473 473
 
474
-			foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_PARSED) as $plugin) {
475
-				Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
476
-				$start = microtime(true);
477
-				$plugin->hook_feed_parsed($rss);
478
-				Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
479
-			}
474
+            foreach ($pluginhost->get_hooks(PluginHost::HOOK_FEED_PARSED) as $plugin) {
475
+                Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
476
+                $start = microtime(true);
477
+                $plugin->hook_feed_parsed($rss);
478
+                Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
479
+            }
480 480
 
481
-			Debug::log("language: $feed_language", Debug::$LOG_VERBOSE);
482
-			Debug::log("processing feed data...", Debug::$LOG_VERBOSE);
481
+            Debug::log("language: $feed_language", Debug::$LOG_VERBOSE);
482
+            Debug::log("processing feed data...", Debug::$LOG_VERBOSE);
483 483
 
484
-			if (DB_TYPE == "pgsql") {
485
-				$favicon_interval_qpart = "favicon_last_checked < NOW() - INTERVAL '12 hour'";
486
-			} else {
487
-				$favicon_interval_qpart = "favicon_last_checked < DATE_SUB(NOW(), INTERVAL 12 HOUR)";
488
-			}
484
+            if (DB_TYPE == "pgsql") {
485
+                $favicon_interval_qpart = "favicon_last_checked < NOW() - INTERVAL '12 hour'";
486
+            } else {
487
+                $favicon_interval_qpart = "favicon_last_checked < DATE_SUB(NOW(), INTERVAL 12 HOUR)";
488
+            }
489 489
 
490
-			$sth = $pdo->prepare("SELECT owner_uid,favicon_avg_color,
490
+            $sth = $pdo->prepare("SELECT owner_uid,favicon_avg_color,
491 491
 				(favicon_last_checked IS NULL OR $favicon_interval_qpart) AS
492 492
 						favicon_needs_check
493 493
 				FROM ttrss_feeds WHERE id = ?");
494
-			$sth->execute([$feed]);
494
+            $sth->execute([$feed]);
495 495
 
496
-			if ($row = $sth->fetch()) {
497
-				$favicon_needs_check = $row["favicon_needs_check"];
498
-				$favicon_avg_color = $row["favicon_avg_color"];
499
-				$owner_uid = $row["owner_uid"];
500
-			} else {
501
-				return false;
502
-			}
496
+            if ($row = $sth->fetch()) {
497
+                $favicon_needs_check = $row["favicon_needs_check"];
498
+                $favicon_avg_color = $row["favicon_avg_color"];
499
+                $owner_uid = $row["owner_uid"];
500
+            } else {
501
+                return false;
502
+            }
503 503
 
504
-			$site_url = mb_substr(rewrite_relative_url($fetch_url, clean($rss->get_link())), 0, 245);
504
+            $site_url = mb_substr(rewrite_relative_url($fetch_url, clean($rss->get_link())), 0, 245);
505 505
 
506
-			Debug::log("site_url: $site_url", Debug::$LOG_VERBOSE);
507
-			Debug::log("feed_title: ".clean($rss->get_title()), Debug::$LOG_VERBOSE);
506
+            Debug::log("site_url: $site_url", Debug::$LOG_VERBOSE);
507
+            Debug::log("feed_title: ".clean($rss->get_title()), Debug::$LOG_VERBOSE);
508 508
 
509
-			if ($favicon_needs_check || $force_refetch) {
509
+            if ($favicon_needs_check || $force_refetch) {
510 510
 
511
-				/* terrible hack: if we crash on floicon shit here, we won't check
511
+                /* terrible hack: if we crash on floicon shit here, we won't check
512 512
 				 * the icon avgcolor again (unless the icon got updated) */
513 513
 
514
-				$favicon_file = ICONS_DIR."/$feed.ico";
515
-				$favicon_modified = @filemtime($favicon_file);
514
+                $favicon_file = ICONS_DIR."/$feed.ico";
515
+                $favicon_modified = @filemtime($favicon_file);
516 516
 
517
-				Debug::log("checking favicon...", Debug::$LOG_VERBOSE);
517
+                Debug::log("checking favicon...", Debug::$LOG_VERBOSE);
518 518
 
519
-				RSSUtils::check_feed_favicon($site_url, $feed);
520
-				$favicon_modified_new = @filemtime($favicon_file);
519
+                RSSUtils::check_feed_favicon($site_url, $feed);
520
+                $favicon_modified_new = @filemtime($favicon_file);
521 521
 
522
-				if ($favicon_modified_new > $favicon_modified) {
523
-									$favicon_avg_color = '';
524
-				}
522
+                if ($favicon_modified_new > $favicon_modified) {
523
+                                    $favicon_avg_color = '';
524
+                }
525 525
 
526
-				$favicon_colorstring = "";
527
-				if (file_exists($favicon_file) && function_exists("imagecreatefromstring") && $favicon_avg_color == '') {
528
-					require_once "colors.php";
526
+                $favicon_colorstring = "";
527
+                if (file_exists($favicon_file) && function_exists("imagecreatefromstring") && $favicon_avg_color == '') {
528
+                    require_once "colors.php";
529 529
 
530
-					$sth = $pdo->prepare("UPDATE ttrss_feeds SET favicon_avg_color = 'fail' WHERE
530
+                    $sth = $pdo->prepare("UPDATE ttrss_feeds SET favicon_avg_color = 'fail' WHERE
531 531
 							id = ?");
532
-					$sth->execute([$feed]);
532
+                    $sth->execute([$feed]);
533 533
 
534
-					$favicon_color = calculate_avg_color($favicon_file);
534
+                    $favicon_color = calculate_avg_color($favicon_file);
535 535
 
536
-					$favicon_colorstring = ",favicon_avg_color = ".$pdo->quote($favicon_color);
536
+                    $favicon_colorstring = ",favicon_avg_color = ".$pdo->quote($favicon_color);
537 537
 
538
-				} else if ($favicon_avg_color == 'fail') {
539
-					Debug::log("floicon failed on this file, not trying to recalculate avg color", Debug::$LOG_VERBOSE);
540
-				}
538
+                } else if ($favicon_avg_color == 'fail') {
539
+                    Debug::log("floicon failed on this file, not trying to recalculate avg color", Debug::$LOG_VERBOSE);
540
+                }
541 541
 
542
-				$sth = $pdo->prepare("UPDATE ttrss_feeds SET favicon_last_checked = NOW()
542
+                $sth = $pdo->prepare("UPDATE ttrss_feeds SET favicon_last_checked = NOW()
543 543
 					$favicon_colorstring WHERE id = ?");
544
-				$sth->execute([$feed]);
545
-			}
544
+                $sth->execute([$feed]);
545
+            }
546 546
 
547
-			Debug::log("loading filters & labels...", Debug::$LOG_VERBOSE);
547
+            Debug::log("loading filters & labels...", Debug::$LOG_VERBOSE);
548 548
 
549
-			$filters = RSSUtils::load_filters($feed, $owner_uid);
549
+            $filters = RSSUtils::load_filters($feed, $owner_uid);
550 550
 
551
-			if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
552
-				print_r($filters);
553
-			}
551
+            if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
552
+                print_r($filters);
553
+            }
554 554
 
555
-			Debug::log("".count($filters)." filters loaded.", Debug::$LOG_VERBOSE);
555
+            Debug::log("".count($filters)." filters loaded.", Debug::$LOG_VERBOSE);
556 556
 
557
-			$items = $rss->get_items();
557
+            $items = $rss->get_items();
558 558
 
559
-			if (!is_array($items)) {
560
-				Debug::log("no articles found.", Debug::$LOG_VERBOSE);
559
+            if (!is_array($items)) {
560
+                Debug::log("no articles found.", Debug::$LOG_VERBOSE);
561 561
 
562
-				$sth = $pdo->prepare("UPDATE ttrss_feeds
562
+                $sth = $pdo->prepare("UPDATE ttrss_feeds
563 563
 					SET last_updated = NOW(), last_unconditional = NOW(), last_error = '' WHERE id = ?");
564
-				$sth->execute([$feed]);
564
+                $sth->execute([$feed]);
565 565
 
566
-				return true; // no articles
567
-			}
566
+                return true; // no articles
567
+            }
568 568
 
569
-			Debug::log("processing articles...", Debug::$LOG_VERBOSE);
569
+            Debug::log("processing articles...", Debug::$LOG_VERBOSE);
570 570
 
571
-			$tstart = time();
571
+            $tstart = time();
572 572
 
573
-			foreach ($items as $item) {
574
-				$pdo->beginTransaction();
573
+            foreach ($items as $item) {
574
+                $pdo->beginTransaction();
575 575
 
576
-				if (Debug::get_loglevel() >= 3) {
577
-					print_r($item);
578
-				}
576
+                if (Debug::get_loglevel() >= 3) {
577
+                    print_r($item);
578
+                }
579 579
 
580
-				if (ini_get("max_execution_time") > 0 && time() - $tstart >= ini_get("max_execution_time") * 0.7) {
581
-					Debug::log("looks like there's too many articles to process at once, breaking out", Debug::$LOG_VERBOSE);
582
-					$pdo->commit();
583
-					break;
584
-				}
580
+                if (ini_get("max_execution_time") > 0 && time() - $tstart >= ini_get("max_execution_time") * 0.7) {
581
+                    Debug::log("looks like there's too many articles to process at once, breaking out", Debug::$LOG_VERBOSE);
582
+                    $pdo->commit();
583
+                    break;
584
+                }
585 585
 
586
-				$entry_guid = strip_tags($item->get_id());
587
-				if (!$entry_guid) {
588
-				    $entry_guid = strip_tags($item->get_link());
589
-				}
590
-				if (!$entry_guid) {
591
-				    $entry_guid = RSSUtils::make_guid_from_title($item->get_title());
592
-				}
586
+                $entry_guid = strip_tags($item->get_id());
587
+                if (!$entry_guid) {
588
+                    $entry_guid = strip_tags($item->get_link());
589
+                }
590
+                if (!$entry_guid) {
591
+                    $entry_guid = RSSUtils::make_guid_from_title($item->get_title());
592
+                }
593 593
 
594
-				if (!$entry_guid) {
595
-					$pdo->commit();
596
-					continue;
597
-				}
594
+                if (!$entry_guid) {
595
+                    $pdo->commit();
596
+                    continue;
597
+                }
598 598
 
599
-				$entry_guid = "$owner_uid,$entry_guid";
599
+                $entry_guid = "$owner_uid,$entry_guid";
600 600
 
601
-				$entry_guid_hashed = 'SHA1:'.sha1($entry_guid);
601
+                $entry_guid_hashed = 'SHA1:'.sha1($entry_guid);
602 602
 
603
-				Debug::log("guid $entry_guid / $entry_guid_hashed", Debug::$LOG_VERBOSE);
603
+                Debug::log("guid $entry_guid / $entry_guid_hashed", Debug::$LOG_VERBOSE);
604 604
 
605
-				$entry_timestamp = (int) $item->get_date();
605
+                $entry_timestamp = (int) $item->get_date();
606 606
 
607
-				Debug::log("orig date: ".$item->get_date(), Debug::$LOG_VERBOSE);
607
+                Debug::log("orig date: ".$item->get_date(), Debug::$LOG_VERBOSE);
608 608
 
609
-				$entry_title = strip_tags($item->get_title());
609
+                $entry_title = strip_tags($item->get_title());
610 610
 
611
-				$entry_link = rewrite_relative_url($site_url, clean($item->get_link()));
611
+                $entry_link = rewrite_relative_url($site_url, clean($item->get_link()));
612 612
 
613
-				$entry_language = mb_substr(trim($item->get_language()), 0, 2);
613
+                $entry_language = mb_substr(trim($item->get_language()), 0, 2);
614 614
 
615
-				Debug::log("title $entry_title", Debug::$LOG_VERBOSE);
616
-				Debug::log("link $entry_link", Debug::$LOG_VERBOSE);
617
-				Debug::log("language $entry_language", Debug::$LOG_VERBOSE);
615
+                Debug::log("title $entry_title", Debug::$LOG_VERBOSE);
616
+                Debug::log("link $entry_link", Debug::$LOG_VERBOSE);
617
+                Debug::log("language $entry_language", Debug::$LOG_VERBOSE);
618 618
 
619
-				if (!$entry_title) $entry_title = date("Y-m-d H:i:s", $entry_timestamp); ;
619
+                if (!$entry_title) $entry_title = date("Y-m-d H:i:s", $entry_timestamp); ;
620 620
 
621
-				$entry_content = $item->get_content();
622
-				if (!$entry_content) $entry_content = $item->get_description();
621
+                $entry_content = $item->get_content();
622
+                if (!$entry_content) $entry_content = $item->get_description();
623 623
 
624
-				if (Debug::get_loglevel() >= 3) {
625
-					print "content: ";
626
-					print htmlspecialchars($entry_content);
627
-					print "\n";
628
-				}
624
+                if (Debug::get_loglevel() >= 3) {
625
+                    print "content: ";
626
+                    print htmlspecialchars($entry_content);
627
+                    print "\n";
628
+                }
629 629
 
630
-				$entry_comments = mb_substr(strip_tags($item->get_comments_url()), 0, 245);
631
-				$num_comments = (int) $item->get_comments_count();
630
+                $entry_comments = mb_substr(strip_tags($item->get_comments_url()), 0, 245);
631
+                $num_comments = (int) $item->get_comments_count();
632 632
 
633
-				$entry_author = strip_tags($item->get_author());
634
-				$entry_guid = mb_substr($entry_guid, 0, 245);
633
+                $entry_author = strip_tags($item->get_author());
634
+                $entry_guid = mb_substr($entry_guid, 0, 245);
635 635
 
636
-				Debug::log("author $entry_author", Debug::$LOG_VERBOSE);
637
-				Debug::log("looking for tags...", Debug::$LOG_VERBOSE);
636
+                Debug::log("author $entry_author", Debug::$LOG_VERBOSE);
637
+                Debug::log("looking for tags...", Debug::$LOG_VERBOSE);
638 638
 
639
-				$entry_tags = $item->get_categories();
640
-				Debug::log("tags found: ".join(", ", $entry_tags), Debug::$LOG_VERBOSE);
639
+                $entry_tags = $item->get_categories();
640
+                Debug::log("tags found: ".join(", ", $entry_tags), Debug::$LOG_VERBOSE);
641 641
 
642
-				Debug::log("done collecting data.", Debug::$LOG_VERBOSE);
642
+                Debug::log("done collecting data.", Debug::$LOG_VERBOSE);
643 643
 
644
-				$sth = $pdo->prepare("SELECT id, content_hash, lang FROM ttrss_entries
644
+                $sth = $pdo->prepare("SELECT id, content_hash, lang FROM ttrss_entries
645 645
 					WHERE guid = ? OR guid = ?");
646
-				$sth->execute([$entry_guid, $entry_guid_hashed]);
647
-
648
-				if ($row = $sth->fetch()) {
649
-					$base_entry_id = $row["id"];
650
-					$entry_stored_hash = $row["content_hash"];
651
-					$article_labels = Article::get_article_labels($base_entry_id, $owner_uid);
652
-
653
-					$existing_tags = Article::get_article_tags($base_entry_id, $owner_uid);
654
-					$entry_tags = array_unique(array_merge($entry_tags, $existing_tags));
655
-				} else {
656
-					$base_entry_id = false;
657
-					$entry_stored_hash = "";
658
-					$article_labels = array();
659
-				}
660
-
661
-				$article = array("owner_uid" => $owner_uid, // read only
662
-					"guid" => $entry_guid, // read only
663
-					"guid_hashed" => $entry_guid_hashed, // read only
664
-					"title" => $entry_title,
665
-					"content" => $entry_content,
666
-					"link" => $entry_link,
667
-					"labels" => $article_labels, // current limitation: can add labels to article, can't remove them
668
-					"tags" => $entry_tags,
669
-					"author" => $entry_author,
670
-					"force_catchup" => false, // ugly hack for the time being
671
-					"score_modifier" => 0, // no previous value, plugin should recalculate score modifier based on content if needed
672
-					"language" => $entry_language,
673
-					"timestamp" => $entry_timestamp,
674
-					"num_comments" => $num_comments,
675
-					"feed" => array("id" => $feed,
676
-						"fetch_url" => $fetch_url,
677
-						"site_url" => $site_url,
678
-						"cache_images" => $cache_images)
679
-				);
680
-
681
-				$entry_plugin_data = "";
682
-				$entry_current_hash = RSSUtils::calculate_article_hash($article, $pluginhost);
683
-
684
-				Debug::log("article hash: $entry_current_hash [stored=$entry_stored_hash]", Debug::$LOG_VERBOSE);
685
-
686
-				if ($entry_current_hash == $entry_stored_hash && !isset($_REQUEST["force_rehash"])) {
687
-					Debug::log("stored article seems up to date [IID: $base_entry_id], updating timestamp only", Debug::$LOG_VERBOSE);
688
-
689
-					// we keep encountering the entry in feeds, so we need to
690
-					// update date_updated column so that we don't get horrible
691
-					// dupes when the entry gets purged and reinserted again e.g.
692
-					// in the case of SLOW SLOW OMG SLOW updating feeds
693
-
694
-					$sth = $pdo->prepare("UPDATE ttrss_entries SET date_updated = NOW()
646
+                $sth->execute([$entry_guid, $entry_guid_hashed]);
647
+
648
+                if ($row = $sth->fetch()) {
649
+                    $base_entry_id = $row["id"];
650
+                    $entry_stored_hash = $row["content_hash"];
651
+                    $article_labels = Article::get_article_labels($base_entry_id, $owner_uid);
652
+
653
+                    $existing_tags = Article::get_article_tags($base_entry_id, $owner_uid);
654
+                    $entry_tags = array_unique(array_merge($entry_tags, $existing_tags));
655
+                } else {
656
+                    $base_entry_id = false;
657
+                    $entry_stored_hash = "";
658
+                    $article_labels = array();
659
+                }
660
+
661
+                $article = array("owner_uid" => $owner_uid, // read only
662
+                    "guid" => $entry_guid, // read only
663
+                    "guid_hashed" => $entry_guid_hashed, // read only
664
+                    "title" => $entry_title,
665
+                    "content" => $entry_content,
666
+                    "link" => $entry_link,
667
+                    "labels" => $article_labels, // current limitation: can add labels to article, can't remove them
668
+                    "tags" => $entry_tags,
669
+                    "author" => $entry_author,
670
+                    "force_catchup" => false, // ugly hack for the time being
671
+                    "score_modifier" => 0, // no previous value, plugin should recalculate score modifier based on content if needed
672
+                    "language" => $entry_language,
673
+                    "timestamp" => $entry_timestamp,
674
+                    "num_comments" => $num_comments,
675
+                    "feed" => array("id" => $feed,
676
+                        "fetch_url" => $fetch_url,
677
+                        "site_url" => $site_url,
678
+                        "cache_images" => $cache_images)
679
+                );
680
+
681
+                $entry_plugin_data = "";
682
+                $entry_current_hash = RSSUtils::calculate_article_hash($article, $pluginhost);
683
+
684
+                Debug::log("article hash: $entry_current_hash [stored=$entry_stored_hash]", Debug::$LOG_VERBOSE);
685
+
686
+                if ($entry_current_hash == $entry_stored_hash && !isset($_REQUEST["force_rehash"])) {
687
+                    Debug::log("stored article seems up to date [IID: $base_entry_id], updating timestamp only", Debug::$LOG_VERBOSE);
688
+
689
+                    // we keep encountering the entry in feeds, so we need to
690
+                    // update date_updated column so that we don't get horrible
691
+                    // dupes when the entry gets purged and reinserted again e.g.
692
+                    // in the case of SLOW SLOW OMG SLOW updating feeds
693
+
694
+                    $sth = $pdo->prepare("UPDATE ttrss_entries SET date_updated = NOW()
695 695
 						WHERE id = ?");
696
-					$sth->execute([$base_entry_id]);
696
+                    $sth->execute([$base_entry_id]);
697 697
 
698
-					$pdo->commit();
699
-					continue;
700
-				}
698
+                    $pdo->commit();
699
+                    continue;
700
+                }
701 701
 
702
-				Debug::log("hash differs, applying plugin filters:", Debug::$LOG_VERBOSE);
702
+                Debug::log("hash differs, applying plugin filters:", Debug::$LOG_VERBOSE);
703 703
 
704
-				foreach ($pluginhost->get_hooks(PluginHost::HOOK_ARTICLE_FILTER) as $plugin) {
705
-					Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
704
+                foreach ($pluginhost->get_hooks(PluginHost::HOOK_ARTICLE_FILTER) as $plugin) {
705
+                    Debug::log("... ".get_class($plugin), Debug::$LOG_VERBOSE);
706 706
 
707
-					$start = microtime(true);
708
-					$article = $plugin->hook_article_filter($article);
707
+                    $start = microtime(true);
708
+                    $article = $plugin->hook_article_filter($article);
709 709
 
710
-					Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
710
+                    Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
711 711
 
712
-					$entry_plugin_data .= mb_strtolower(get_class($plugin)).",";
713
-				}
712
+                    $entry_plugin_data .= mb_strtolower(get_class($plugin)).",";
713
+                }
714 714
 
715 715
                 if (Debug::get_loglevel() >= 3) {
716
-					print "processed content: ";
717
-					print htmlspecialchars($article["content"]);
718
-					print "\n";
719
-				}
716
+                    print "processed content: ";
717
+                    print htmlspecialchars($article["content"]);
718
+                    print "\n";
719
+                }
720 720
 
721
-				Debug::log("plugin data: $entry_plugin_data", Debug::$LOG_VERBOSE);
721
+                Debug::log("plugin data: $entry_plugin_data", Debug::$LOG_VERBOSE);
722 722
 
723
-				// Workaround: 4-byte unicode requires utf8mb4 in MySQL. See https://tt-rss.org/forum/viewtopic.php?f=1&t=3377&p=20077#p20077
724
-				if (DB_TYPE == "mysql" && MYSQL_CHARSET != "UTF8MB4") {
725
-					foreach ($article as $k => $v) {
726
-						// i guess we'll have to take the risk of 4byte unicode labels & tags here
727
-						if (is_string($article[$k])) {
728
-							$article[$k] = RSSUtils::strip_utf8mb4($v);
729
-						}
730
-					}
731
-				}
723
+                // Workaround: 4-byte unicode requires utf8mb4 in MySQL. See https://tt-rss.org/forum/viewtopic.php?f=1&t=3377&p=20077#p20077
724
+                if (DB_TYPE == "mysql" && MYSQL_CHARSET != "UTF8MB4") {
725
+                    foreach ($article as $k => $v) {
726
+                        // i guess we'll have to take the risk of 4byte unicode labels & tags here
727
+                        if (is_string($article[$k])) {
728
+                            $article[$k] = RSSUtils::strip_utf8mb4($v);
729
+                        }
730
+                    }
731
+                }
732 732
 
733
-				/* Collect article tags here so we could filter by them: */
733
+                /* Collect article tags here so we could filter by them: */
734 734
 
735
-				$matched_rules = [];
736
-				$matched_filters = [];
735
+                $matched_rules = [];
736
+                $matched_filters = [];
737 737
 
738
-				$article_filters = RSSUtils::get_article_filters($filters, $article["title"],
739
-					$article["content"], $article["link"], $article["author"],
740
-					$article["tags"], $matched_rules, $matched_filters);
738
+                $article_filters = RSSUtils::get_article_filters($filters, $article["title"],
739
+                    $article["content"], $article["link"], $article["author"],
740
+                    $article["tags"], $matched_rules, $matched_filters);
741 741
 
742
-				// $article_filters should be renamed to something like $filter_actions; actual filter objects are in $matched_filters
743
-				foreach ($pluginhost->get_hooks(PluginHost::HOOK_FILTER_TRIGGERED) as $plugin) {
744
-					$plugin->hook_filter_triggered($feed, $owner_uid, $article, $matched_filters, $matched_rules, $article_filters);
745
-				}
742
+                // $article_filters should be renamed to something like $filter_actions; actual filter objects are in $matched_filters
743
+                foreach ($pluginhost->get_hooks(PluginHost::HOOK_FILTER_TRIGGERED) as $plugin) {
744
+                    $plugin->hook_filter_triggered($feed, $owner_uid, $article, $matched_filters, $matched_rules, $article_filters);
745
+                }
746 746
 
747
-				$matched_filter_ids = array_map(function($f) { return $f['id']; }, $matched_filters);
747
+                $matched_filter_ids = array_map(function($f) { return $f['id']; }, $matched_filters);
748 748
 
749
-				if (count($matched_filter_ids) > 0) {
750
-					$filter_ids_qmarks = arr_qmarks($matched_filter_ids);
749
+                if (count($matched_filter_ids) > 0) {
750
+                    $filter_ids_qmarks = arr_qmarks($matched_filter_ids);
751 751
 
752
-					$fsth = $pdo->prepare("UPDATE ttrss_filters2 SET last_triggered = NOW() WHERE
752
+                    $fsth = $pdo->prepare("UPDATE ttrss_filters2 SET last_triggered = NOW() WHERE
753 753
 							   id IN ($filter_ids_qmarks) AND owner_uid = ?");
754 754
 
755
-					$fsth->execute(array_merge($matched_filter_ids, [$owner_uid]));
756
-				}
755
+                    $fsth->execute(array_merge($matched_filter_ids, [$owner_uid]));
756
+                }
757 757
 
758
-				if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
759
-					Debug::log("matched filters: ", Debug::$LOG_VERBOSE);
758
+                if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
759
+                    Debug::log("matched filters: ", Debug::$LOG_VERBOSE);
760 760
 
761
-					if (count($matched_filters != 0)) {
762
-						print_r($matched_filters);
763
-					}
761
+                    if (count($matched_filters != 0)) {
762
+                        print_r($matched_filters);
763
+                    }
764 764
 
765
-					Debug::log("matched filter rules: ", Debug::$LOG_VERBOSE);
765
+                    Debug::log("matched filter rules: ", Debug::$LOG_VERBOSE);
766 766
 
767
-					if (count($matched_rules) != 0) {
768
-						print_r($matched_rules);
769
-					}
767
+                    if (count($matched_rules) != 0) {
768
+                        print_r($matched_rules);
769
+                    }
770 770
 
771
-					Debug::log("filter actions: ", Debug::$LOG_VERBOSE);
771
+                    Debug::log("filter actions: ", Debug::$LOG_VERBOSE);
772 772
 
773
-					if (count($article_filters) != 0) {
774
-						print_r($article_filters);
775
-					}
776
-				}
773
+                    if (count($article_filters) != 0) {
774
+                        print_r($article_filters);
775
+                    }
776
+                }
777 777
 
778
-				$plugin_filter_names = RSSUtils::find_article_filters($article_filters, "plugin");
779
-				$plugin_filter_actions = $pluginhost->get_filter_actions();
778
+                $plugin_filter_names = RSSUtils::find_article_filters($article_filters, "plugin");
779
+                $plugin_filter_actions = $pluginhost->get_filter_actions();
780 780
 
781
-				if (count($plugin_filter_names) > 0) {
782
-					Debug::log("applying plugin filter actions...", Debug::$LOG_VERBOSE);
781
+                if (count($plugin_filter_names) > 0) {
782
+                    Debug::log("applying plugin filter actions...", Debug::$LOG_VERBOSE);
783 783
 
784
-					foreach ($plugin_filter_names as $pfn) {
785
-						list($pfclass, $pfaction) = explode(":", $pfn["param"]);
784
+                    foreach ($plugin_filter_names as $pfn) {
785
+                        list($pfclass, $pfaction) = explode(":", $pfn["param"]);
786 786
 
787
-						if (isset($plugin_filter_actions[$pfclass])) {
788
-							$plugin = $pluginhost->get_plugin($pfclass);
787
+                        if (isset($plugin_filter_actions[$pfclass])) {
788
+                            $plugin = $pluginhost->get_plugin($pfclass);
789 789
 
790
-							Debug::log("... $pfclass: $pfaction", Debug::$LOG_VERBOSE);
790
+                            Debug::log("... $pfclass: $pfaction", Debug::$LOG_VERBOSE);
791 791
 
792
-							if ($plugin) {
793
-								$start = microtime(true);
794
-								$article = $plugin->hook_article_filter_action($article, $pfaction);
792
+                            if ($plugin) {
793
+                                $start = microtime(true);
794
+                                $article = $plugin->hook_article_filter_action($article, $pfaction);
795 795
 
796
-								Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
797
-							} else {
798
-								Debug::log("??? $pfclass: plugin object not found.", Debug::$LOG_VERBOSE);
799
-							}
800
-						} else {
801
-							Debug::log("??? $pfclass: filter plugin not registered.", Debug::$LOG_VERBOSE);
802
-						}
803
-					}
804
-				}
796
+                                Debug::log(sprintf("=== %.4f (sec)", microtime(true) - $start), Debug::$LOG_VERBOSE);
797
+                            } else {
798
+                                Debug::log("??? $pfclass: plugin object not found.", Debug::$LOG_VERBOSE);
799
+                            }
800
+                        } else {
801
+                            Debug::log("??? $pfclass: filter plugin not registered.", Debug::$LOG_VERBOSE);
802
+                        }
803
+                    }
804
+                }
805 805
 
806
-				$entry_tags = $article["tags"];
807
-				$entry_title = strip_tags($article["title"]);
808
-				$entry_author = mb_substr(strip_tags($article["author"]), 0, 245);
809
-				$entry_link = strip_tags($article["link"]);
810
-				$entry_content = $article["content"]; // escaped below
811
-				$entry_force_catchup = $article["force_catchup"];
812
-				$article_labels = $article["labels"];
813
-				$entry_score_modifier = (int) $article["score_modifier"];
814
-				$entry_language = $article["language"];
815
-				$entry_timestamp = $article["timestamp"];
816
-				$num_comments = $article["num_comments"];
806
+                $entry_tags = $article["tags"];
807
+                $entry_title = strip_tags($article["title"]);
808
+                $entry_author = mb_substr(strip_tags($article["author"]), 0, 245);
809
+                $entry_link = strip_tags($article["link"]);
810
+                $entry_content = $article["content"]; // escaped below
811
+                $entry_force_catchup = $article["force_catchup"];
812
+                $article_labels = $article["labels"];
813
+                $entry_score_modifier = (int) $article["score_modifier"];
814
+                $entry_language = $article["language"];
815
+                $entry_timestamp = $article["timestamp"];
816
+                $num_comments = $article["num_comments"];
817 817
 
818
-				if ($entry_timestamp == -1 || !$entry_timestamp || $entry_timestamp > time()) {
819
-					$entry_timestamp = time();
820
-				}
818
+                if ($entry_timestamp == -1 || !$entry_timestamp || $entry_timestamp > time()) {
819
+                    $entry_timestamp = time();
820
+                }
821 821
 
822
-				$entry_timestamp_fmt = strftime("%Y/%m/%d %H:%M:%S", $entry_timestamp);
822
+                $entry_timestamp_fmt = strftime("%Y/%m/%d %H:%M:%S", $entry_timestamp);
823 823
 
824
-				Debug::log("date $entry_timestamp [$entry_timestamp_fmt]", Debug::$LOG_VERBOSE);
825
-				Debug::log("num_comments: $num_comments", Debug::$LOG_VERBOSE);
824
+                Debug::log("date $entry_timestamp [$entry_timestamp_fmt]", Debug::$LOG_VERBOSE);
825
+                Debug::log("num_comments: $num_comments", Debug::$LOG_VERBOSE);
826 826
 
827
-				if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
828
-					Debug::log("article labels:", Debug::$LOG_VERBOSE);
827
+                if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
828
+                    Debug::log("article labels:", Debug::$LOG_VERBOSE);
829 829
 
830
-					if (count($article_labels) != 0) {
831
-						print_r($article_labels);
832
-					}
833
-				}
830
+                    if (count($article_labels) != 0) {
831
+                        print_r($article_labels);
832
+                    }
833
+                }
834 834
 
835
-				Debug::log("force catchup: $entry_force_catchup", Debug::$LOG_VERBOSE);
835
+                Debug::log("force catchup: $entry_force_catchup", Debug::$LOG_VERBOSE);
836 836
 
837
-				if ($cache_images) {
838
-									RSSUtils::cache_media($entry_content, $site_url);
839
-				}
837
+                if ($cache_images) {
838
+                                    RSSUtils::cache_media($entry_content, $site_url);
839
+                }
840 840
 
841
-				$csth = $pdo->prepare("SELECT id FROM ttrss_entries
841
+                $csth = $pdo->prepare("SELECT id FROM ttrss_entries
842 842
 					WHERE guid = ? OR guid = ?");
843
-				$csth->execute([$entry_guid, $entry_guid_hashed]);
843
+                $csth->execute([$entry_guid, $entry_guid_hashed]);
844 844
 
845
-				if (!$row = $csth->fetch()) {
845
+                if (!$row = $csth->fetch()) {
846 846
 
847
-					Debug::log("base guid [$entry_guid or $entry_guid_hashed] not found, creating...", Debug::$LOG_VERBOSE);
847
+                    Debug::log("base guid [$entry_guid or $entry_guid_hashed] not found, creating...", Debug::$LOG_VERBOSE);
848 848
 
849
-					// base post entry does not exist, create it
849
+                    // base post entry does not exist, create it
850 850
 
851
-					$usth = $pdo->prepare(
852
-						"INSERT INTO ttrss_entries
851
+                    $usth = $pdo->prepare(
852
+                        "INSERT INTO ttrss_entries
853 853
 							(title,
854 854
 							guid,
855 855
 							link,
@@ -870,112 +870,112 @@  discard block
 block discarded – undo
870 870
 							NOW(),
871 871
 							?, ?, ?, ?,	?, ?)");
872 872
 
873
-						$usth->execute([$entry_title,
874
-							$entry_guid_hashed,
875
-							$entry_link,
876
-							$entry_timestamp_fmt,
877
-							"$entry_content",
878
-							$entry_current_hash,
879
-							$date_feed_processed,
880
-							$entry_comments,
881
-							(int) $num_comments,
882
-							$entry_plugin_data,
883
-							"$entry_language",
884
-							"$entry_author"]);
873
+                        $usth->execute([$entry_title,
874
+                            $entry_guid_hashed,
875
+                            $entry_link,
876
+                            $entry_timestamp_fmt,
877
+                            "$entry_content",
878
+                            $entry_current_hash,
879
+                            $date_feed_processed,
880
+                            $entry_comments,
881
+                            (int) $num_comments,
882
+                            $entry_plugin_data,
883
+                            "$entry_language",
884
+                            "$entry_author"]);
885 885
 
886
-				}
886
+                }
887 887
 
888
-				$csth->execute([$entry_guid, $entry_guid_hashed]);
888
+                $csth->execute([$entry_guid, $entry_guid_hashed]);
889 889
 
890
-				$entry_ref_id = 0;
891
-				$entry_int_id = 0;
890
+                $entry_ref_id = 0;
891
+                $entry_int_id = 0;
892 892
 
893
-				if ($row = $csth->fetch()) {
893
+                if ($row = $csth->fetch()) {
894 894
 
895
-					Debug::log("base guid found, checking for user record", Debug::$LOG_VERBOSE);
895
+                    Debug::log("base guid found, checking for user record", Debug::$LOG_VERBOSE);
896 896
 
897
-					$ref_id = $row['id'];
898
-					$entry_ref_id = $ref_id;
897
+                    $ref_id = $row['id'];
898
+                    $entry_ref_id = $ref_id;
899 899
 
900
-					if (RSSUtils::find_article_filter($article_filters, "filter")) {
901
-						Debug::log("article is filtered out, nothing to do.", Debug::$LOG_VERBOSE);
902
-						$pdo->commit();
903
-						continue;
904
-					}
900
+                    if (RSSUtils::find_article_filter($article_filters, "filter")) {
901
+                        Debug::log("article is filtered out, nothing to do.", Debug::$LOG_VERBOSE);
902
+                        $pdo->commit();
903
+                        continue;
904
+                    }
905 905
 
906
-					$score = RSSUtils::calculate_article_score($article_filters) + $entry_score_modifier;
906
+                    $score = RSSUtils::calculate_article_score($article_filters) + $entry_score_modifier;
907 907
 
908
-					Debug::log("initial score: $score [including plugin modifier: $entry_score_modifier]", Debug::$LOG_VERBOSE);
908
+                    Debug::log("initial score: $score [including plugin modifier: $entry_score_modifier]", Debug::$LOG_VERBOSE);
909 909
 
910
-					// check for user post link to main table
910
+                    // check for user post link to main table
911 911
 
912
-					$sth = $pdo->prepare("SELECT ref_id, int_id FROM ttrss_user_entries WHERE
912
+                    $sth = $pdo->prepare("SELECT ref_id, int_id FROM ttrss_user_entries WHERE
913 913
 							ref_id = ? AND owner_uid = ?");
914
-					$sth->execute([$ref_id, $owner_uid]);
915
-
916
-					// okay it doesn't exist - create user entry
917
-					if ($row = $sth->fetch()) {
918
-						$entry_ref_id = $row["ref_id"];
919
-						$entry_int_id = $row["int_id"];
920
-
921
-						Debug::log("user record FOUND: RID: $entry_ref_id, IID: $entry_int_id", Debug::$LOG_VERBOSE);
922
-					} else {
923
-
924
-						Debug::log("user record not found, creating...", Debug::$LOG_VERBOSE);
925
-
926
-						if ($score >= -500 && !RSSUtils::find_article_filter($article_filters, 'catchup') && !$entry_force_catchup) {
927
-							$unread = 1;
928
-							$last_read_qpart = null;
929
-						} else {
930
-							$unread = 0;
931
-							$last_read_qpart = date("Y-m-d H:i"); // we can't use NOW() here because it gets quoted
932
-						}
933
-
934
-						if (RSSUtils::find_article_filter($article_filters, 'mark') || $score > 1000) {
935
-							$marked = 1;
936
-						} else {
937
-							$marked = 0;
938
-						}
939
-
940
-						if (RSSUtils::find_article_filter($article_filters, 'publish')) {
941
-							$published = 1;
942
-						} else {
943
-							$published = 0;
944
-						}
945
-
946
-						$last_marked = ($marked == 1) ? 'NOW()' : 'NULL';
947
-						$last_published = ($published == 1) ? 'NOW()' : 'NULL';
948
-
949
-						$sth = $pdo->prepare(
950
-							"INSERT INTO ttrss_user_entries
914
+                    $sth->execute([$ref_id, $owner_uid]);
915
+
916
+                    // okay it doesn't exist - create user entry
917
+                    if ($row = $sth->fetch()) {
918
+                        $entry_ref_id = $row["ref_id"];
919
+                        $entry_int_id = $row["int_id"];
920
+
921
+                        Debug::log("user record FOUND: RID: $entry_ref_id, IID: $entry_int_id", Debug::$LOG_VERBOSE);
922
+                    } else {
923
+
924
+                        Debug::log("user record not found, creating...", Debug::$LOG_VERBOSE);
925
+
926
+                        if ($score >= -500 && !RSSUtils::find_article_filter($article_filters, 'catchup') && !$entry_force_catchup) {
927
+                            $unread = 1;
928
+                            $last_read_qpart = null;
929
+                        } else {
930
+                            $unread = 0;
931
+                            $last_read_qpart = date("Y-m-d H:i"); // we can't use NOW() here because it gets quoted
932
+                        }
933
+
934
+                        if (RSSUtils::find_article_filter($article_filters, 'mark') || $score > 1000) {
935
+                            $marked = 1;
936
+                        } else {
937
+                            $marked = 0;
938
+                        }
939
+
940
+                        if (RSSUtils::find_article_filter($article_filters, 'publish')) {
941
+                            $published = 1;
942
+                        } else {
943
+                            $published = 0;
944
+                        }
945
+
946
+                        $last_marked = ($marked == 1) ? 'NOW()' : 'NULL';
947
+                        $last_published = ($published == 1) ? 'NOW()' : 'NULL';
948
+
949
+                        $sth = $pdo->prepare(
950
+                            "INSERT INTO ttrss_user_entries
951 951
 								(ref_id, owner_uid, feed_id, unread, last_read, marked,
952 952
 								published, score, tag_cache, label_cache, uuid,
953 953
 								last_marked, last_published)
954 954
 							VALUES (?, ?, ?, ?, ?, ?, ?, ?, '', '', '', ".$last_marked.", ".$last_published.")");
955 955
 
956
-						$sth->execute([$ref_id, $owner_uid, $feed, $unread, $last_read_qpart, $marked,
957
-							$published, $score]);
956
+                        $sth->execute([$ref_id, $owner_uid, $feed, $unread, $last_read_qpart, $marked,
957
+                            $published, $score]);
958 958
 
959
-						$sth = $pdo->prepare("SELECT int_id FROM ttrss_user_entries WHERE
959
+                        $sth = $pdo->prepare("SELECT int_id FROM ttrss_user_entries WHERE
960 960
 								ref_id = ? AND owner_uid = ? AND
961 961
 								feed_id = ? LIMIT 1");
962 962
 
963
-						$sth->execute([$ref_id, $owner_uid, $feed]);
963
+                        $sth->execute([$ref_id, $owner_uid, $feed]);
964 964
 
965
-						if ($row = $sth->fetch()) {
966
-													$entry_int_id = $row['int_id'];
967
-						}
968
-					}
965
+                        if ($row = $sth->fetch()) {
966
+                                                    $entry_int_id = $row['int_id'];
967
+                        }
968
+                    }
969 969
 
970
-					Debug::log("resulting RID: $entry_ref_id, IID: $entry_int_id", Debug::$LOG_VERBOSE);
970
+                    Debug::log("resulting RID: $entry_ref_id, IID: $entry_int_id", Debug::$LOG_VERBOSE);
971 971
 
972
-					if (DB_TYPE == "pgsql") {
973
-											$tsvector_qpart = "tsvector_combined = to_tsvector(:ts_lang, :ts_content),";
974
-					} else {
975
-											$tsvector_qpart = "";
976
-					}
972
+                    if (DB_TYPE == "pgsql") {
973
+                                            $tsvector_qpart = "tsvector_combined = to_tsvector(:ts_lang, :ts_content),";
974
+                    } else {
975
+                                            $tsvector_qpart = "";
976
+                    }
977 977
 
978
-					$sth = $pdo->prepare("UPDATE ttrss_entries
978
+                    $sth = $pdo->prepare("UPDATE ttrss_entries
979 979
 						SET title = :title,
980 980
 							$tsvector_qpart
981 981
 							content = :content,
@@ -988,642 +988,642 @@  discard block
 block discarded – undo
988 988
 							lang = :lang
989 989
 						WHERE id = :id");
990 990
 
991
-					$params = [":title" => $entry_title,
992
-						":content" => "$entry_content",
993
-						":content_hash" => $entry_current_hash,
994
-						":updated" => $entry_timestamp_fmt,
995
-						":num_comments" => (int) $num_comments,
996
-						":plugin_data" => $entry_plugin_data,
997
-						":author" => "$entry_author",
998
-						":lang" => $entry_language,
999
-						":id" => $ref_id];
1000
-
1001
-					if (DB_TYPE == "pgsql") {
1002
-						$params[":ts_lang"] = $feed_language;
1003
-						$params[":ts_content"] = mb_substr(strip_tags($entry_title." ".$entry_content), 0, 900000);
1004
-					}
1005
-
1006
-					$sth->execute($params);
1007
-
1008
-					// update aux data
1009
-					$sth = $pdo->prepare("UPDATE ttrss_user_entries
991
+                    $params = [":title" => $entry_title,
992
+                        ":content" => "$entry_content",
993
+                        ":content_hash" => $entry_current_hash,
994
+                        ":updated" => $entry_timestamp_fmt,
995
+                        ":num_comments" => (int) $num_comments,
996
+                        ":plugin_data" => $entry_plugin_data,
997
+                        ":author" => "$entry_author",
998
+                        ":lang" => $entry_language,
999
+                        ":id" => $ref_id];
1000
+
1001
+                    if (DB_TYPE == "pgsql") {
1002
+                        $params[":ts_lang"] = $feed_language;
1003
+                        $params[":ts_content"] = mb_substr(strip_tags($entry_title." ".$entry_content), 0, 900000);
1004
+                    }
1005
+
1006
+                    $sth->execute($params);
1007
+
1008
+                    // update aux data
1009
+                    $sth = $pdo->prepare("UPDATE ttrss_user_entries
1010 1010
 							SET score = ? WHERE ref_id = ?");
1011
-					$sth->execute([$score, $ref_id]);
1011
+                    $sth->execute([$score, $ref_id]);
1012 1012
 
1013
-					if ($mark_unread_on_update &&
1014
-						!$entry_force_catchup &&
1015
-						!RSSUtils::find_article_filter($article_filters, 'catchup')) {
1013
+                    if ($mark_unread_on_update &&
1014
+                        !$entry_force_catchup &&
1015
+                        !RSSUtils::find_article_filter($article_filters, 'catchup')) {
1016 1016
 
1017
-						Debug::log("article updated, marking unread as requested.", Debug::$LOG_VERBOSE);
1017
+                        Debug::log("article updated, marking unread as requested.", Debug::$LOG_VERBOSE);
1018 1018
 
1019
-						$sth = $pdo->prepare("UPDATE ttrss_user_entries
1019
+                        $sth = $pdo->prepare("UPDATE ttrss_user_entries
1020 1020
 							SET last_read = null, unread = true WHERE ref_id = ?");
1021
-						$sth->execute([$ref_id]);
1022
-					} else {
1023
-						Debug::log("article updated, but we're forbidden to mark it unread.", Debug::$LOG_VERBOSE);
1024
-					}
1025
-				}
1021
+                        $sth->execute([$ref_id]);
1022
+                    } else {
1023
+                        Debug::log("article updated, but we're forbidden to mark it unread.", Debug::$LOG_VERBOSE);
1024
+                    }
1025
+                }
1026 1026
 
1027
-				Debug::log("assigning labels [other]...", Debug::$LOG_VERBOSE);
1027
+                Debug::log("assigning labels [other]...", Debug::$LOG_VERBOSE);
1028 1028
 
1029
-				foreach ($article_labels as $label) {
1030
-					Labels::add_article($entry_ref_id, $label[1], $owner_uid);
1031
-				}
1029
+                foreach ($article_labels as $label) {
1030
+                    Labels::add_article($entry_ref_id, $label[1], $owner_uid);
1031
+                }
1032 1032
 
1033
-				Debug::log("assigning labels [filters]...", Debug::$LOG_VERBOSE);
1033
+                Debug::log("assigning labels [filters]...", Debug::$LOG_VERBOSE);
1034 1034
 
1035
-				RSSUtils::assign_article_to_label_filters($entry_ref_id, $article_filters,
1036
-					$owner_uid, $article_labels);
1035
+                RSSUtils::assign_article_to_label_filters($entry_ref_id, $article_filters,
1036
+                    $owner_uid, $article_labels);
1037 1037
 
1038
-				Debug::log("looking for enclosures...", Debug::$LOG_VERBOSE);
1038
+                Debug::log("looking for enclosures...", Debug::$LOG_VERBOSE);
1039 1039
 
1040
-				// enclosures
1040
+                // enclosures
1041 1041
 
1042
-				$enclosures = array();
1042
+                $enclosures = array();
1043 1043
 
1044
-				$encs = $item->get_enclosures();
1044
+                $encs = $item->get_enclosures();
1045 1045
 
1046
-				if (is_array($encs)) {
1047
-					foreach ($encs as $e) {
1048
-						$e_item = array(
1049
-							rewrite_relative_url($site_url, $e->link),
1050
-							$e->type, $e->length, $e->title, $e->width, $e->height);
1046
+                if (is_array($encs)) {
1047
+                    foreach ($encs as $e) {
1048
+                        $e_item = array(
1049
+                            rewrite_relative_url($site_url, $e->link),
1050
+                            $e->type, $e->length, $e->title, $e->width, $e->height);
1051 1051
 
1052
-						// Yet another episode of "mysql utf8_general_ci is gimped"
1053
-						if (DB_TYPE == "mysql" && MYSQL_CHARSET != "UTF8MB4") {
1054
-							for ($i = 0; $i < count($e_item); $i++) {
1055
-								if (is_string($e_item[$i])) {
1056
-									$e_item[$i] = RSSUtils::strip_utf8mb4($e_item[$i]);
1057
-								}
1058
-							}
1059
-						}
1052
+                        // Yet another episode of "mysql utf8_general_ci is gimped"
1053
+                        if (DB_TYPE == "mysql" && MYSQL_CHARSET != "UTF8MB4") {
1054
+                            for ($i = 0; $i < count($e_item); $i++) {
1055
+                                if (is_string($e_item[$i])) {
1056
+                                    $e_item[$i] = RSSUtils::strip_utf8mb4($e_item[$i]);
1057
+                                }
1058
+                            }
1059
+                        }
1060 1060
 
1061
-						array_push($enclosures, $e_item);
1062
-					}
1063
-				}
1061
+                        array_push($enclosures, $e_item);
1062
+                    }
1063
+                }
1064 1064
 
1065
-				if ($cache_images) {
1066
-									RSSUtils::cache_enclosures($enclosures, $site_url);
1067
-				}
1065
+                if ($cache_images) {
1066
+                                    RSSUtils::cache_enclosures($enclosures, $site_url);
1067
+                }
1068 1068
 
1069
-				if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
1070
-					Debug::log("article enclosures:", Debug::$LOG_VERBOSE);
1071
-					print_r($enclosures);
1072
-				}
1069
+                if (Debug::get_loglevel() >= Debug::$LOG_EXTENDED) {
1070
+                    Debug::log("article enclosures:", Debug::$LOG_VERBOSE);
1071
+                    print_r($enclosures);
1072
+                }
1073 1073
 
1074
-				$esth = $pdo->prepare("SELECT id FROM ttrss_enclosures
1074
+                $esth = $pdo->prepare("SELECT id FROM ttrss_enclosures
1075 1075
 						WHERE content_url = ? AND content_type = ? AND post_id = ?");
1076 1076
 
1077
-				$usth = $pdo->prepare("INSERT INTO ttrss_enclosures
1077
+                $usth = $pdo->prepare("INSERT INTO ttrss_enclosures
1078 1078
 							(content_url, content_type, title, duration, post_id, width, height) VALUES
1079 1079
 							(?, ?, ?, ?, ?, ?, ?)");
1080 1080
 
1081
-				foreach ($enclosures as $enc) {
1082
-					$enc_url = $enc[0];
1083
-					$enc_type = $enc[1];
1084
-					$enc_dur = (int) $enc[2];
1085
-					$enc_title = $enc[3];
1086
-					$enc_width = intval($enc[4]);
1087
-					$enc_height = intval($enc[5]);
1081
+                foreach ($enclosures as $enc) {
1082
+                    $enc_url = $enc[0];
1083
+                    $enc_type = $enc[1];
1084
+                    $enc_dur = (int) $enc[2];
1085
+                    $enc_title = $enc[3];
1086
+                    $enc_width = intval($enc[4]);
1087
+                    $enc_height = intval($enc[5]);
1088 1088
 
1089
-					$esth->execute([$enc_url, $enc_type, $entry_ref_id]);
1089
+                    $esth->execute([$enc_url, $enc_type, $entry_ref_id]);
1090 1090
 
1091
-					if (!$esth->fetch()) {
1092
-						$usth->execute([$enc_url, $enc_type, (string) $enc_title, $enc_dur, $entry_ref_id, $enc_width, $enc_height]);
1093
-					}
1094
-				}
1091
+                    if (!$esth->fetch()) {
1092
+                        $usth->execute([$enc_url, $enc_type, (string) $enc_title, $enc_dur, $entry_ref_id, $enc_width, $enc_height]);
1093
+                    }
1094
+                }
1095 1095
 
1096
-				// check for manual tags (we have to do it here since they're loaded from filters)
1096
+                // check for manual tags (we have to do it here since they're loaded from filters)
1097 1097
 
1098
-				foreach ($article_filters as $f) {
1099
-					if ($f["type"] == "tag") {
1098
+                foreach ($article_filters as $f) {
1099
+                    if ($f["type"] == "tag") {
1100 1100
 
1101
-						$manual_tags = trim_array(explode(",", $f["param"]));
1101
+                        $manual_tags = trim_array(explode(",", $f["param"]));
1102 1102
 
1103
-						foreach ($manual_tags as $tag) {
1104
-							array_push($entry_tags, $tag);
1105
-						}
1106
-					}
1107
-				}
1103
+                        foreach ($manual_tags as $tag) {
1104
+                            array_push($entry_tags, $tag);
1105
+                        }
1106
+                    }
1107
+                }
1108 1108
 
1109
-				// Skip boring tags
1109
+                // Skip boring tags
1110 1110
 
1111
-				$boring_tags = trim_array(explode(",", mb_strtolower(get_pref(
1112
-					'BLACKLISTED_TAGS', $owner_uid, ''), 'utf-8')));
1111
+                $boring_tags = trim_array(explode(",", mb_strtolower(get_pref(
1112
+                    'BLACKLISTED_TAGS', $owner_uid, ''), 'utf-8')));
1113 1113
 
1114
-				$filtered_tags = array();
1115
-				$tags_to_cache = array();
1114
+                $filtered_tags = array();
1115
+                $tags_to_cache = array();
1116 1116
 
1117
-				foreach ($entry_tags as $tag) {
1118
-					if (array_search($tag, $boring_tags) === false) {
1119
-						array_push($filtered_tags, $tag);
1120
-					}
1121
-				}
1117
+                foreach ($entry_tags as $tag) {
1118
+                    if (array_search($tag, $boring_tags) === false) {
1119
+                        array_push($filtered_tags, $tag);
1120
+                    }
1121
+                }
1122 1122
 
1123
-				$filtered_tags = array_unique($filtered_tags);
1123
+                $filtered_tags = array_unique($filtered_tags);
1124 1124
 
1125
-				if (Debug::get_loglevel() >= Debug::$LOG_VERBOSE) {
1126
-					Debug::log("filtered tags: ".implode(", ", $filtered_tags), Debug::$LOG_VERBOSE);
1125
+                if (Debug::get_loglevel() >= Debug::$LOG_VERBOSE) {
1126
+                    Debug::log("filtered tags: ".implode(", ", $filtered_tags), Debug::$LOG_VERBOSE);
1127 1127
 
1128
-				}
1128
+                }
1129 1129
 
1130
-				// Save article tags in the database
1130
+                // Save article tags in the database
1131 1131
 
1132
-				if (count($filtered_tags) > 0) {
1132
+                if (count($filtered_tags) > 0) {
1133 1133
 
1134
-					$tsth = $pdo->prepare("SELECT id FROM ttrss_tags
1134
+                    $tsth = $pdo->prepare("SELECT id FROM ttrss_tags
1135 1135
 							WHERE tag_name = ? AND post_int_id = ? AND
1136 1136
 							owner_uid = ? LIMIT 1");
1137 1137
 
1138
-					$usth = $pdo->prepare("INSERT INTO ttrss_tags
1138
+                    $usth = $pdo->prepare("INSERT INTO ttrss_tags
1139 1139
 									(owner_uid,tag_name,post_int_id)
1140 1140
 									VALUES (?, ?, ?)");
1141 1141
 
1142
-					$filtered_tags = FeedItem_Common::normalize_categories($filtered_tags);
1142
+                    $filtered_tags = FeedItem_Common::normalize_categories($filtered_tags);
1143 1143
 
1144
-					foreach ($filtered_tags as $tag) {
1145
-						$tsth->execute([$tag, $entry_int_id, $owner_uid]);
1144
+                    foreach ($filtered_tags as $tag) {
1145
+                        $tsth->execute([$tag, $entry_int_id, $owner_uid]);
1146 1146
 
1147
-						if (!$tsth->fetch()) {
1148
-							$usth->execute([$owner_uid, $tag, $entry_int_id]);
1149
-						}
1147
+                        if (!$tsth->fetch()) {
1148
+                            $usth->execute([$owner_uid, $tag, $entry_int_id]);
1149
+                        }
1150 1150
 
1151
-						array_push($tags_to_cache, $tag);
1152
-					}
1151
+                        array_push($tags_to_cache, $tag);
1152
+                    }
1153 1153
 
1154
-					/* update the cache */
1155
-					$tags_str = join(",", $tags_to_cache);
1154
+                    /* update the cache */
1155
+                    $tags_str = join(",", $tags_to_cache);
1156 1156
 
1157
-					$tsth = $pdo->prepare("UPDATE ttrss_user_entries
1157
+                    $tsth = $pdo->prepare("UPDATE ttrss_user_entries
1158 1158
 						SET tag_cache = ? WHERE ref_id = ?
1159 1159
 						AND owner_uid = ?");
1160
-					$tsth->execute([$tags_str, $entry_ref_id, $owner_uid]);
1161
-				}
1160
+                    $tsth->execute([$tags_str, $entry_ref_id, $owner_uid]);
1161
+                }
1162 1162
 
1163
-				Debug::log("article processed", Debug::$LOG_VERBOSE);
1163
+                Debug::log("article processed", Debug::$LOG_VERBOSE);
1164 1164
 
1165
-				$pdo->commit();
1166
-			}
1165
+                $pdo->commit();
1166
+            }
1167 1167
 
1168
-			Debug::log("purging feed...", Debug::$LOG_VERBOSE);
1168
+            Debug::log("purging feed...", Debug::$LOG_VERBOSE);
1169 1169
 
1170
-			Feeds::purge_feed($feed, 0);
1170
+            Feeds::purge_feed($feed, 0);
1171 1171
 
1172
-			$sth = $pdo->prepare("UPDATE ttrss_feeds
1172
+            $sth = $pdo->prepare("UPDATE ttrss_feeds
1173 1173
 				SET last_updated = NOW(), last_unconditional = NOW(), last_error = '' WHERE id = ?");
1174
-			$sth->execute([$feed]);
1174
+            $sth->execute([$feed]);
1175 1175
 
1176
-		} else {
1176
+        } else {
1177 1177
 
1178
-			$error_msg = mb_substr($rss->error(), 0, 245);
1178
+            $error_msg = mb_substr($rss->error(), 0, 245);
1179 1179
 
1180
-			Debug::log("fetch error: $error_msg", Debug::$LOG_VERBOSE);
1180
+            Debug::log("fetch error: $error_msg", Debug::$LOG_VERBOSE);
1181 1181
 
1182
-			if (count($rss->errors()) > 1) {
1183
-				foreach ($rss->errors() as $error) {
1184
-					Debug::log("+ $error", Debug::$LOG_VERBOSE);
1185
-				}
1186
-			}
1182
+            if (count($rss->errors()) > 1) {
1183
+                foreach ($rss->errors() as $error) {
1184
+                    Debug::log("+ $error", Debug::$LOG_VERBOSE);
1185
+                }
1186
+            }
1187 1187
 
1188
-			$sth = $pdo->prepare("UPDATE ttrss_feeds SET last_error = ?,
1188
+            $sth = $pdo->prepare("UPDATE ttrss_feeds SET last_error = ?,
1189 1189
 				last_updated = NOW(), last_unconditional = NOW() WHERE id = ?");
1190
-			$sth->execute([$error_msg, $feed]);
1190
+            $sth->execute([$error_msg, $feed]);
1191 1191
 
1192
-			unset($rss);
1192
+            unset($rss);
1193 1193
 
1194
-			Debug::log("update failed.", Debug::$LOG_VERBOSE);
1195
-			return false;
1196
-		}
1194
+            Debug::log("update failed.", Debug::$LOG_VERBOSE);
1195
+            return false;
1196
+        }
1197 1197
 
1198
-		Debug::log("update done.", Debug::$LOG_VERBOSE);
1198
+        Debug::log("update done.", Debug::$LOG_VERBOSE);
1199 1199
 
1200
-		return true;
1201
-	}
1200
+        return true;
1201
+    }
1202 1202
 
1203
-	public static function cache_enclosures($enclosures, $site_url) {
1204
-		$cache = new DiskCache("images");
1203
+    public static function cache_enclosures($enclosures, $site_url) {
1204
+        $cache = new DiskCache("images");
1205 1205
 
1206
-		if ($cache->isWritable()) {
1207
-			foreach ($enclosures as $enc) {
1206
+        if ($cache->isWritable()) {
1207
+            foreach ($enclosures as $enc) {
1208 1208
 
1209
-				if (preg_match("/(image|audio|video)/", $enc[1])) {
1210
-					$src = rewrite_relative_url($site_url, $enc[0]);
1209
+                if (preg_match("/(image|audio|video)/", $enc[1])) {
1210
+                    $src = rewrite_relative_url($site_url, $enc[0]);
1211 1211
 
1212
-					$local_filename = sha1($src);
1212
+                    $local_filename = sha1($src);
1213 1213
 
1214
-					Debug::log("cache_enclosures: downloading: $src to $local_filename", Debug::$LOG_VERBOSE);
1214
+                    Debug::log("cache_enclosures: downloading: $src to $local_filename", Debug::$LOG_VERBOSE);
1215 1215
 
1216
-					if (!$cache->exists($local_filename)) {
1216
+                    if (!$cache->exists($local_filename)) {
1217 1217
 
1218
-						global $fetch_last_error_code;
1219
-						global $fetch_last_error;
1218
+                        global $fetch_last_error_code;
1219
+                        global $fetch_last_error;
1220 1220
 
1221
-						$file_content = fetch_file_contents(array("url" => $src,
1222
-							"http_referrer" => $src,
1223
-							"max_size" => MAX_CACHE_FILE_SIZE));
1221
+                        $file_content = fetch_file_contents(array("url" => $src,
1222
+                            "http_referrer" => $src,
1223
+                            "max_size" => MAX_CACHE_FILE_SIZE));
1224 1224
 
1225
-						if ($file_content) {
1226
-							$cache->put($local_filename, $file_content);
1227
-						} else {
1228
-							Debug::log("cache_enclosures: failed with $fetch_last_error_code: $fetch_last_error");
1229
-						}
1230
-					} else if (is_writable($local_filename)) {
1231
-						$cache->touch($local_filename);
1232
-					}
1233
-				}
1234
-			}
1235
-		}
1236
-	}
1225
+                        if ($file_content) {
1226
+                            $cache->put($local_filename, $file_content);
1227
+                        } else {
1228
+                            Debug::log("cache_enclosures: failed with $fetch_last_error_code: $fetch_last_error");
1229
+                        }
1230
+                    } else if (is_writable($local_filename)) {
1231
+                        $cache->touch($local_filename);
1232
+                    }
1233
+                }
1234
+            }
1235
+        }
1236
+    }
1237 1237
 
1238
-	public static function cache_media($html, $site_url) {
1239
-		$cache = new DiskCache("images");
1238
+    public static function cache_media($html, $site_url) {
1239
+        $cache = new DiskCache("images");
1240 1240
 
1241
-		if ($cache->isWritable()) {
1242
-			$doc = new DOMDocument();
1243
-			if ($doc->loadHTML($html)) {
1244
-				$xpath = new DOMXPath($doc);
1241
+        if ($cache->isWritable()) {
1242
+            $doc = new DOMDocument();
1243
+            if ($doc->loadHTML($html)) {
1244
+                $xpath = new DOMXPath($doc);
1245 1245
 
1246
-				$entries = $xpath->query('(//img[@src])|(//video/source[@src])|(//audio/source[@src])');
1246
+                $entries = $xpath->query('(//img[@src])|(//video/source[@src])|(//audio/source[@src])');
1247 1247
 
1248
-				foreach ($entries as $entry) {
1249
-					if ($entry->hasAttribute('src') && strpos($entry->getAttribute('src'), "data:") !== 0) {
1250
-						$src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
1248
+                foreach ($entries as $entry) {
1249
+                    if ($entry->hasAttribute('src') && strpos($entry->getAttribute('src'), "data:") !== 0) {
1250
+                        $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
1251 1251
 
1252
-						$local_filename = sha1($src);
1252
+                        $local_filename = sha1($src);
1253 1253
 
1254
-						Debug::log("cache_media: checking $src", Debug::$LOG_VERBOSE);
1254
+                        Debug::log("cache_media: checking $src", Debug::$LOG_VERBOSE);
1255 1255
 
1256
-						if (!$cache->exists($local_filename)) {
1257
-							Debug::log("cache_media: downloading: $src to $local_filename", Debug::$LOG_VERBOSE);
1256
+                        if (!$cache->exists($local_filename)) {
1257
+                            Debug::log("cache_media: downloading: $src to $local_filename", Debug::$LOG_VERBOSE);
1258 1258
 
1259
-							global $fetch_last_error_code;
1260
-							global $fetch_last_error;
1259
+                            global $fetch_last_error_code;
1260
+                            global $fetch_last_error;
1261 1261
 
1262
-							$file_content = fetch_file_contents(array("url" => $src,
1263
-								"http_referrer" => $src,
1264
-								"max_size" => MAX_CACHE_FILE_SIZE));
1262
+                            $file_content = fetch_file_contents(array("url" => $src,
1263
+                                "http_referrer" => $src,
1264
+                                "max_size" => MAX_CACHE_FILE_SIZE));
1265 1265
 
1266
-							if ($file_content) {
1267
-								$cache->put($local_filename, $file_content);
1268
-							} else {
1269
-								Debug::log("cache_media: failed with $fetch_last_error_code: $fetch_last_error");
1270
-							}
1271
-						} else if ($cache->isWritable($local_filename)) {
1272
-							$cache->touch($local_filename);
1273
-						}
1274
-					}
1275
-				}
1276
-			}
1277
-		}
1278
-	}
1266
+                            if ($file_content) {
1267
+                                $cache->put($local_filename, $file_content);
1268
+                            } else {
1269
+                                Debug::log("cache_media: failed with $fetch_last_error_code: $fetch_last_error");
1270
+                            }
1271
+                        } else if ($cache->isWritable($local_filename)) {
1272
+                            $cache->touch($local_filename);
1273
+                        }
1274
+                    }
1275
+                }
1276
+            }
1277
+        }
1278
+    }
1279 1279
 
1280
-	public static function expire_error_log() {
1281
-		Debug::log("Removing old error log entries...");
1280
+    public static function expire_error_log() {
1281
+        Debug::log("Removing old error log entries...");
1282 1282
 
1283
-		$pdo = Db::pdo();
1283
+        $pdo = Db::pdo();
1284 1284
 
1285
-		if (DB_TYPE == "pgsql") {
1286
-			$pdo->query("DELETE FROM ttrss_error_log
1285
+        if (DB_TYPE == "pgsql") {
1286
+            $pdo->query("DELETE FROM ttrss_error_log
1287 1287
 				WHERE created_at < NOW() - INTERVAL '7 days'");
1288
-		} else {
1289
-			$pdo->query("DELETE FROM ttrss_error_log
1288
+        } else {
1289
+            $pdo->query("DELETE FROM ttrss_error_log
1290 1290
 				WHERE created_at < DATE_SUB(NOW(), INTERVAL 7 DAY)");
1291
-		}
1292
-	}
1291
+        }
1292
+    }
1293 1293
 
1294
-	public static function expire_feed_archive() {
1295
-		Debug::log("Removing old archived feeds...");
1294
+    public static function expire_feed_archive() {
1295
+        Debug::log("Removing old archived feeds...");
1296 1296
 
1297
-		$pdo = Db::pdo();
1297
+        $pdo = Db::pdo();
1298 1298
 
1299
-		if (DB_TYPE == "pgsql") {
1300
-			$pdo->query("DELETE FROM ttrss_archived_feeds
1299
+        if (DB_TYPE == "pgsql") {
1300
+            $pdo->query("DELETE FROM ttrss_archived_feeds
1301 1301
 				WHERE created < NOW() - INTERVAL '1 month'");
1302
-		} else {
1303
-			$pdo->query("DELETE FROM ttrss_archived_feeds
1302
+        } else {
1303
+            $pdo->query("DELETE FROM ttrss_archived_feeds
1304 1304
 				WHERE created < DATE_SUB(NOW(), INTERVAL 1 MONTH)");
1305
-		}
1306
-	}
1307
-
1308
-	public static function expire_lock_files() {
1309
-		Debug::log("Removing old lock files...", Debug::$LOG_VERBOSE);
1310
-
1311
-		$num_deleted = 0;
1312
-
1313
-		if (is_writable(LOCK_DIRECTORY)) {
1314
-			$files = glob(LOCK_DIRECTORY."/*.lock");
1315
-
1316
-			if ($files) {
1317
-				foreach ($files as $file) {
1318
-					if (!file_is_locked(basename($file)) && time() - filemtime($file) > 86400 * 2) {
1319
-						unlink($file);
1320
-						++$num_deleted;
1321
-					}
1322
-				}
1323
-			}
1324
-		}
1325
-
1326
-		Debug::log("removed $num_deleted old lock files.");
1327
-	}
1328
-
1329
-	/**
1330
-	 * Source: http://www.php.net/manual/en/function.parse-url.php#104527
1331
-	 * Returns the url query as associative array
1332
-	 *
1333
-	 * @param    string    query
1334
-	 * @return    array    params
1335
-	 */
1336
-	public static function convertUrlQuery($query) {
1337
-		$queryParts = explode('&', $query);
1338
-
1339
-		$params = array();
1340
-
1341
-		foreach ($queryParts as $param) {
1342
-			$item = explode('=', $param);
1343
-			$params[$item[0]] = $item[1];
1344
-		}
1345
-
1346
-		return $params;
1347
-	}
1348
-
1349
-	public static function get_article_filters($filters, $title, $content, $link, $author, $tags, &$matched_rules = false, &$matched_filters = false) {
1350
-		$matches = array();
1351
-
1352
-		foreach ($filters as $filter) {
1353
-			$match_any_rule = $filter["match_any_rule"];
1354
-			$inverse = $filter["inverse"];
1355
-			$filter_match = false;
1356
-
1357
-			foreach ($filter["rules"] as $rule) {
1358
-				$match = false;
1359
-				$reg_exp = str_replace('/', '\/', $rule["reg_exp"]);
1360
-				$rule_inverse = $rule["inverse"];
1361
-
1362
-				if (!$reg_exp) {
1363
-									continue;
1364
-				}
1365
-
1366
-				switch ($rule["type"]) {
1367
-					case "title":
1368
-						$match = @preg_match("/$reg_exp/iu", $title);
1369
-						break;
1370
-					case "content":
1371
-						// we don't need to deal with multiline regexps
1372
-						$content = preg_replace("/[\r\n\t]/", "", $content);
1373
-
1374
-						$match = @preg_match("/$reg_exp/iu", $content);
1375
-						break;
1376
-					case "both":
1377
-						// we don't need to deal with multiline regexps
1378
-						$content = preg_replace("/[\r\n\t]/", "", $content);
1379
-
1380
-						$match = (@preg_match("/$reg_exp/iu", $title) || @preg_match("/$reg_exp/iu", $content));
1381
-						break;
1382
-					case "link":
1383
-						$match = @preg_match("/$reg_exp/iu", $link);
1384
-						break;
1385
-					case "author":
1386
-						$match = @preg_match("/$reg_exp/iu", $author);
1387
-						break;
1388
-					case "tag":
1389
-						foreach ($tags as $tag) {
1390
-							if (@preg_match("/$reg_exp/iu", $tag)) {
1391
-								$match = true;
1392
-								break;
1393
-							}
1394
-						}
1395
-						break;
1396
-				}
1397
-
1398
-				if ($rule_inverse) {
1399
-				    $match = !$match;
1400
-				}
1401
-
1402
-				if ($match_any_rule) {
1403
-					if ($match) {
1404
-						$filter_match = true;
1405
-						break;
1406
-					}
1407
-				} else {
1408
-					$filter_match = $match;
1409
-					if (!$match) {
1410
-						break;
1411
-					}
1412
-				}
1413
-			}
1414
-
1415
-			if ($inverse) {
1416
-			    $filter_match = !$filter_match;
1417
-			}
1418
-
1419
-			if ($filter_match) {
1420
-				if (is_array($matched_rules)) {
1421
-				    array_push($matched_rules, $rule);
1422
-				}
1423
-				if (is_array($matched_filters)) {
1424
-				    array_push($matched_filters, $filter);
1425
-				}
1426
-
1427
-				foreach ($filter["actions"] as $action) {
1428
-					array_push($matches, $action);
1429
-
1430
-					// if Stop action encountered, perform no further processing
1431
-					if (isset($action["type"]) && $action["type"] == "stop") {
1432
-					    return $matches;
1433
-					}
1434
-				}
1435
-			}
1436
-		}
1437
-
1438
-		return $matches;
1439
-	}
1440
-
1441
-	public static function find_article_filter($filters, $filter_name) {
1442
-		foreach ($filters as $f) {
1443
-			if ($f["type"] == $filter_name) {
1444
-				return $f;
1445
-			};
1446
-		}
1447
-		return false;
1448
-	}
1449
-
1450
-	public static function find_article_filters($filters, $filter_name) {
1451
-		$results = array();
1452
-
1453
-		foreach ($filters as $f) {
1454
-			if ($f["type"] == $filter_name) {
1455
-				array_push($results, $f);
1456
-			};
1457
-		}
1458
-		return $results;
1459
-	}
1460
-
1461
-	public static function calculate_article_score($filters) {
1462
-		$score = 0;
1463
-
1464
-		foreach ($filters as $f) {
1465
-			if ($f["type"] == "score") {
1466
-				$score += $f["param"];
1467
-			};
1468
-		}
1469
-		return $score;
1470
-	}
1471
-
1472
-	public static function labels_contains_caption($labels, $caption) {
1473
-		foreach ($labels as $label) {
1474
-			if ($label[1] == $caption) {
1475
-				return true;
1476
-			}
1477
-		}
1478
-
1479
-		return false;
1480
-	}
1481
-
1482
-	public static function assign_article_to_label_filters($id, $filters, $owner_uid, $article_labels) {
1483
-		foreach ($filters as $f) {
1484
-			if ($f["type"] == "label") {
1485
-				if (!RSSUtils::labels_contains_caption($article_labels, $f["param"])) {
1486
-					Labels::add_article($id, $f["param"], $owner_uid);
1487
-				}
1488
-			}
1489
-		}
1490
-	}
1491
-
1492
-	public static function make_guid_from_title($title) {
1493
-		return preg_replace("/[ \"\',.:;]/", "-",
1494
-			mb_strtolower(strip_tags($title), 'utf-8'));
1495
-	}
1496
-
1497
-	public static function cleanup_counters_cache() {
1498
-		$pdo = Db::pdo();
1499
-
1500
-		$res = $pdo->query("DELETE FROM ttrss_counters_cache
1305
+        }
1306
+    }
1307
+
1308
+    public static function expire_lock_files() {
1309
+        Debug::log("Removing old lock files...", Debug::$LOG_VERBOSE);
1310
+
1311
+        $num_deleted = 0;
1312
+
1313
+        if (is_writable(LOCK_DIRECTORY)) {
1314
+            $files = glob(LOCK_DIRECTORY."/*.lock");
1315
+
1316
+            if ($files) {
1317
+                foreach ($files as $file) {
1318
+                    if (!file_is_locked(basename($file)) && time() - filemtime($file) > 86400 * 2) {
1319
+                        unlink($file);
1320
+                        ++$num_deleted;
1321
+                    }
1322
+                }
1323
+            }
1324
+        }
1325
+
1326
+        Debug::log("removed $num_deleted old lock files.");
1327
+    }
1328
+
1329
+    /**
1330
+     * Source: http://www.php.net/manual/en/function.parse-url.php#104527
1331
+     * Returns the url query as associative array
1332
+     *
1333
+     * @param    string    query
1334
+     * @return    array    params
1335
+     */
1336
+    public static function convertUrlQuery($query) {
1337
+        $queryParts = explode('&', $query);
1338
+
1339
+        $params = array();
1340
+
1341
+        foreach ($queryParts as $param) {
1342
+            $item = explode('=', $param);
1343
+            $params[$item[0]] = $item[1];
1344
+        }
1345
+
1346
+        return $params;
1347
+    }
1348
+
1349
+    public static function get_article_filters($filters, $title, $content, $link, $author, $tags, &$matched_rules = false, &$matched_filters = false) {
1350
+        $matches = array();
1351
+
1352
+        foreach ($filters as $filter) {
1353
+            $match_any_rule = $filter["match_any_rule"];
1354
+            $inverse = $filter["inverse"];
1355
+            $filter_match = false;
1356
+
1357
+            foreach ($filter["rules"] as $rule) {
1358
+                $match = false;
1359
+                $reg_exp = str_replace('/', '\/', $rule["reg_exp"]);
1360
+                $rule_inverse = $rule["inverse"];
1361
+
1362
+                if (!$reg_exp) {
1363
+                                    continue;
1364
+                }
1365
+
1366
+                switch ($rule["type"]) {
1367
+                    case "title":
1368
+                        $match = @preg_match("/$reg_exp/iu", $title);
1369
+                        break;
1370
+                    case "content":
1371
+                        // we don't need to deal with multiline regexps
1372
+                        $content = preg_replace("/[\r\n\t]/", "", $content);
1373
+
1374
+                        $match = @preg_match("/$reg_exp/iu", $content);
1375
+                        break;
1376
+                    case "both":
1377
+                        // we don't need to deal with multiline regexps
1378
+                        $content = preg_replace("/[\r\n\t]/", "", $content);
1379
+
1380
+                        $match = (@preg_match("/$reg_exp/iu", $title) || @preg_match("/$reg_exp/iu", $content));
1381
+                        break;
1382
+                    case "link":
1383
+                        $match = @preg_match("/$reg_exp/iu", $link);
1384
+                        break;
1385
+                    case "author":
1386
+                        $match = @preg_match("/$reg_exp/iu", $author);
1387
+                        break;
1388
+                    case "tag":
1389
+                        foreach ($tags as $tag) {
1390
+                            if (@preg_match("/$reg_exp/iu", $tag)) {
1391
+                                $match = true;
1392
+                                break;
1393
+                            }
1394
+                        }
1395
+                        break;
1396
+                }
1397
+
1398
+                if ($rule_inverse) {
1399
+                    $match = !$match;
1400
+                }
1401
+
1402
+                if ($match_any_rule) {
1403
+                    if ($match) {
1404
+                        $filter_match = true;
1405
+                        break;
1406
+                    }
1407
+                } else {
1408
+                    $filter_match = $match;
1409
+                    if (!$match) {
1410
+                        break;
1411
+                    }
1412
+                }
1413
+            }
1414
+
1415
+            if ($inverse) {
1416
+                $filter_match = !$filter_match;
1417
+            }
1418
+
1419
+            if ($filter_match) {
1420
+                if (is_array($matched_rules)) {
1421
+                    array_push($matched_rules, $rule);
1422
+                }
1423
+                if (is_array($matched_filters)) {
1424
+                    array_push($matched_filters, $filter);
1425
+                }
1426
+
1427
+                foreach ($filter["actions"] as $action) {
1428
+                    array_push($matches, $action);
1429
+
1430
+                    // if Stop action encountered, perform no further processing
1431
+                    if (isset($action["type"]) && $action["type"] == "stop") {
1432
+                        return $matches;
1433
+                    }
1434
+                }
1435
+            }
1436
+        }
1437
+
1438
+        return $matches;
1439
+    }
1440
+
1441
+    public static function find_article_filter($filters, $filter_name) {
1442
+        foreach ($filters as $f) {
1443
+            if ($f["type"] == $filter_name) {
1444
+                return $f;
1445
+            };
1446
+        }
1447
+        return false;
1448
+    }
1449
+
1450
+    public static function find_article_filters($filters, $filter_name) {
1451
+        $results = array();
1452
+
1453
+        foreach ($filters as $f) {
1454
+            if ($f["type"] == $filter_name) {
1455
+                array_push($results, $f);
1456
+            };
1457
+        }
1458
+        return $results;
1459
+    }
1460
+
1461
+    public static function calculate_article_score($filters) {
1462
+        $score = 0;
1463
+
1464
+        foreach ($filters as $f) {
1465
+            if ($f["type"] == "score") {
1466
+                $score += $f["param"];
1467
+            };
1468
+        }
1469
+        return $score;
1470
+    }
1471
+
1472
+    public static function labels_contains_caption($labels, $caption) {
1473
+        foreach ($labels as $label) {
1474
+            if ($label[1] == $caption) {
1475
+                return true;
1476
+            }
1477
+        }
1478
+
1479
+        return false;
1480
+    }
1481
+
1482
+    public static function assign_article_to_label_filters($id, $filters, $owner_uid, $article_labels) {
1483
+        foreach ($filters as $f) {
1484
+            if ($f["type"] == "label") {
1485
+                if (!RSSUtils::labels_contains_caption($article_labels, $f["param"])) {
1486
+                    Labels::add_article($id, $f["param"], $owner_uid);
1487
+                }
1488
+            }
1489
+        }
1490
+    }
1491
+
1492
+    public static function make_guid_from_title($title) {
1493
+        return preg_replace("/[ \"\',.:;]/", "-",
1494
+            mb_strtolower(strip_tags($title), 'utf-8'));
1495
+    }
1496
+
1497
+    public static function cleanup_counters_cache() {
1498
+        $pdo = Db::pdo();
1499
+
1500
+        $res = $pdo->query("DELETE FROM ttrss_counters_cache
1501 1501
 			WHERE feed_id > 0 AND
1502 1502
 			(SELECT COUNT(id) FROM ttrss_feeds WHERE
1503 1503
 				id = feed_id AND
1504 1504
 				ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid) = 0");
1505 1505
 
1506
-		$frows = $res->rowCount();
1506
+        $frows = $res->rowCount();
1507 1507
 
1508
-		$res = $pdo->query("DELETE FROM ttrss_cat_counters_cache
1508
+        $res = $pdo->query("DELETE FROM ttrss_cat_counters_cache
1509 1509
 			WHERE feed_id > 0 AND
1510 1510
 			(SELECT COUNT(id) FROM ttrss_feed_categories WHERE
1511 1511
 				id = feed_id AND
1512 1512
 				ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid) = 0");
1513 1513
 
1514
-		$crows = $res->rowCount();
1515
-
1516
-		Debug::log("removed $frows (feeds) $crows (cats) orphaned counter cache entries.");
1517
-	}
1518
-
1519
-	public static function housekeeping_user($owner_uid) {
1520
-		$tmph = new PluginHost();
1521
-
1522
-		load_user_plugins($owner_uid, $tmph);
1523
-
1524
-		$tmph->run_hooks(PluginHost::HOOK_HOUSE_KEEPING, "hook_house_keeping", "");
1525
-	}
1526
-
1527
-	public static function housekeeping_common() {
1528
-		DiskCache::expire();
1529
-
1530
-		RSSUtils::expire_lock_files();
1531
-		RSSUtils::expire_error_log();
1532
-		RSSUtils::expire_feed_archive();
1533
-		RSSUtils::cleanup_feed_browser();
1534
-
1535
-		Article::purge_orphans();
1536
-		RSSUtils::cleanup_counters_cache();
1537
-
1538
-		PluginHost::getInstance()->run_hooks(PluginHost::HOOK_HOUSE_KEEPING, "hook_house_keeping", "");
1539
-	}
1540
-
1541
-	public static function check_feed_favicon($site_url, $feed) {
1542
-		#		print "FAVICON [$site_url]: $favicon_url\n";
1543
-
1544
-		$icon_file = ICONS_DIR."/$feed.ico";
1545
-
1546
-		if (!file_exists($icon_file)) {
1547
-			$favicon_url = RSSUtils::get_favicon_url($site_url);
1548
-
1549
-			if ($favicon_url) {
1550
-				// Limiting to "image" type misses those served with text/plain
1551
-				$contents = fetch_file_contents($favicon_url); // , "image");
1552
-
1553
-				if ($contents) {
1554
-					// Crude image type matching.
1555
-					// Patterns gleaned from the file(1) source code.
1556
-					if (preg_match('/^\x00\x00\x01\x00/', $contents)) {
1557
-						// 0       string  \000\000\001\000        MS Windows icon resource
1558
-						//error_log("check_feed_favicon: favicon_url=$favicon_url isa MS Windows icon resource");
1559
-					} elseif (preg_match('/^GIF8/', $contents)) {
1560
-						// 0       string          GIF8            GIF image data
1561
-						//error_log("check_feed_favicon: favicon_url=$favicon_url isa GIF image");
1562
-					} elseif (preg_match('/^\x89PNG\x0d\x0a\x1a\x0a/', $contents)) {
1563
-						// 0       string          \x89PNG\x0d\x0a\x1a\x0a         PNG image data
1564
-						//error_log("check_feed_favicon: favicon_url=$favicon_url isa PNG image");
1565
-					} elseif (preg_match('/^\xff\xd8/', $contents)) {
1566
-						// 0       beshort         0xffd8          JPEG image data
1567
-						//error_log("check_feed_favicon: favicon_url=$favicon_url isa JPG image");
1568
-					} elseif (preg_match('/^BM/', $contents)) {
1569
-						// 0	string		BM	PC bitmap (OS2, Windows BMP files)
1570
-						//error_log("check_feed_favicon, favicon_url=$favicon_url isa BMP image");
1571
-					} else {
1572
-						//error_log("check_feed_favicon: favicon_url=$favicon_url isa UNKNOWN type");
1573
-						$contents = "";
1574
-					}
1575
-				}
1576
-
1577
-				if ($contents) {
1578
-					$fp = @fopen($icon_file, "w");
1579
-
1580
-					if ($fp) {
1581
-						fwrite($fp, $contents);
1582
-						fclose($fp);
1583
-						chmod($icon_file, 0644);
1584
-					}
1585
-				}
1586
-			}
1587
-			return $icon_file;
1588
-		}
1589
-	}
1590
-
1591
-	public static function is_gzipped($feed_data) {
1592
-		return strpos(substr($feed_data, 0, 3),
1593
-				"\x1f"."\x8b"."\x08", 0) === 0;
1594
-	}
1595
-
1596
-	public static function load_filters($feed_id, $owner_uid) {
1597
-		$filters = array();
1598
-
1599
-		$feed_id = (int) $feed_id;
1600
-		$cat_id = (int) Feeds::getFeedCategory($feed_id);
1601
-
1602
-		if ($cat_id == 0) {
1603
-					$null_cat_qpart = "cat_id IS NULL OR";
1604
-		} else {
1605
-					$null_cat_qpart = "";
1606
-		}
1607
-
1608
-		$pdo = Db::pdo();
1609
-
1610
-		$sth = $pdo->prepare("SELECT * FROM ttrss_filters2 WHERE
1514
+        $crows = $res->rowCount();
1515
+
1516
+        Debug::log("removed $frows (feeds) $crows (cats) orphaned counter cache entries.");
1517
+    }
1518
+
1519
+    public static function housekeeping_user($owner_uid) {
1520
+        $tmph = new PluginHost();
1521
+
1522
+        load_user_plugins($owner_uid, $tmph);
1523
+
1524
+        $tmph->run_hooks(PluginHost::HOOK_HOUSE_KEEPING, "hook_house_keeping", "");
1525
+    }
1526
+
1527
+    public static function housekeeping_common() {
1528
+        DiskCache::expire();
1529
+
1530
+        RSSUtils::expire_lock_files();
1531
+        RSSUtils::expire_error_log();
1532
+        RSSUtils::expire_feed_archive();
1533
+        RSSUtils::cleanup_feed_browser();
1534
+
1535
+        Article::purge_orphans();
1536
+        RSSUtils::cleanup_counters_cache();
1537
+
1538
+        PluginHost::getInstance()->run_hooks(PluginHost::HOOK_HOUSE_KEEPING, "hook_house_keeping", "");
1539
+    }
1540
+
1541
+    public static function check_feed_favicon($site_url, $feed) {
1542
+        #		print "FAVICON [$site_url]: $favicon_url\n";
1543
+
1544
+        $icon_file = ICONS_DIR."/$feed.ico";
1545
+
1546
+        if (!file_exists($icon_file)) {
1547
+            $favicon_url = RSSUtils::get_favicon_url($site_url);
1548
+
1549
+            if ($favicon_url) {
1550
+                // Limiting to "image" type misses those served with text/plain
1551
+                $contents = fetch_file_contents($favicon_url); // , "image");
1552
+
1553
+                if ($contents) {
1554
+                    // Crude image type matching.
1555
+                    // Patterns gleaned from the file(1) source code.
1556
+                    if (preg_match('/^\x00\x00\x01\x00/', $contents)) {
1557
+                        // 0       string  \000\000\001\000        MS Windows icon resource
1558
+                        //error_log("check_feed_favicon: favicon_url=$favicon_url isa MS Windows icon resource");
1559
+                    } elseif (preg_match('/^GIF8/', $contents)) {
1560
+                        // 0       string          GIF8            GIF image data
1561
+                        //error_log("check_feed_favicon: favicon_url=$favicon_url isa GIF image");
1562
+                    } elseif (preg_match('/^\x89PNG\x0d\x0a\x1a\x0a/', $contents)) {
1563
+                        // 0       string          \x89PNG\x0d\x0a\x1a\x0a         PNG image data
1564
+                        //error_log("check_feed_favicon: favicon_url=$favicon_url isa PNG image");
1565
+                    } elseif (preg_match('/^\xff\xd8/', $contents)) {
1566
+                        // 0       beshort         0xffd8          JPEG image data
1567
+                        //error_log("check_feed_favicon: favicon_url=$favicon_url isa JPG image");
1568
+                    } elseif (preg_match('/^BM/', $contents)) {
1569
+                        // 0	string		BM	PC bitmap (OS2, Windows BMP files)
1570
+                        //error_log("check_feed_favicon, favicon_url=$favicon_url isa BMP image");
1571
+                    } else {
1572
+                        //error_log("check_feed_favicon: favicon_url=$favicon_url isa UNKNOWN type");
1573
+                        $contents = "";
1574
+                    }
1575
+                }
1576
+
1577
+                if ($contents) {
1578
+                    $fp = @fopen($icon_file, "w");
1579
+
1580
+                    if ($fp) {
1581
+                        fwrite($fp, $contents);
1582
+                        fclose($fp);
1583
+                        chmod($icon_file, 0644);
1584
+                    }
1585
+                }
1586
+            }
1587
+            return $icon_file;
1588
+        }
1589
+    }
1590
+
1591
+    public static function is_gzipped($feed_data) {
1592
+        return strpos(substr($feed_data, 0, 3),
1593
+                "\x1f"."\x8b"."\x08", 0) === 0;
1594
+    }
1595
+
1596
+    public static function load_filters($feed_id, $owner_uid) {
1597
+        $filters = array();
1598
+
1599
+        $feed_id = (int) $feed_id;
1600
+        $cat_id = (int) Feeds::getFeedCategory($feed_id);
1601
+
1602
+        if ($cat_id == 0) {
1603
+                    $null_cat_qpart = "cat_id IS NULL OR";
1604
+        } else {
1605
+                    $null_cat_qpart = "";
1606
+        }
1607
+
1608
+        $pdo = Db::pdo();
1609
+
1610
+        $sth = $pdo->prepare("SELECT * FROM ttrss_filters2 WHERE
1611 1611
 				owner_uid = ? AND enabled = true ORDER BY order_id, title");
1612
-		$sth->execute([$owner_uid]);
1612
+        $sth->execute([$owner_uid]);
1613 1613
 
1614
-		$check_cats = array_merge(
1615
-			Feeds::getParentCategories($cat_id, $owner_uid),
1616
-			[$cat_id]);
1614
+        $check_cats = array_merge(
1615
+            Feeds::getParentCategories($cat_id, $owner_uid),
1616
+            [$cat_id]);
1617 1617
 
1618
-		$check_cats_str = join(",", $check_cats);
1619
-		$check_cats_fullids = array_map(function($a) { return "CAT:$a"; }, $check_cats);
1618
+        $check_cats_str = join(",", $check_cats);
1619
+        $check_cats_fullids = array_map(function($a) { return "CAT:$a"; }, $check_cats);
1620 1620
 
1621
-		while ($line = $sth->fetch()) {
1622
-			$filter_id = $line["id"];
1621
+        while ($line = $sth->fetch()) {
1622
+            $filter_id = $line["id"];
1623 1623
 
1624
-			$match_any_rule = sql_bool_to_bool($line["match_any_rule"]);
1624
+            $match_any_rule = sql_bool_to_bool($line["match_any_rule"]);
1625 1625
 
1626
-			$sth2 = $pdo->prepare("SELECT
1626
+            $sth2 = $pdo->prepare("SELECT
1627 1627
 					r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, r.match_on, t.name AS type_name
1628 1628
 					FROM ttrss_filters2_rules AS r,
1629 1629
 					ttrss_filter_types AS t
@@ -1632,118 +1632,118 @@  discard block
 block discarded – undo
1632 1632
 						  (($null_cat_qpart (cat_id IS NULL AND cat_filter = false) OR cat_id IN ($check_cats_str)) AND
1633 1633
 						  (feed_id IS NULL OR feed_id = ?))) AND
1634 1634
 						filter_type = t.id AND filter_id = ?");
1635
-			$sth2->execute([$feed_id, $filter_id]);
1635
+            $sth2->execute([$feed_id, $filter_id]);
1636 1636
 
1637
-			$rules = array();
1638
-			$actions = array();
1637
+            $rules = array();
1638
+            $actions = array();
1639 1639
 
1640
-			while ($rule_line = $sth2->fetch()) {
1641
-				#				print_r($rule_line);
1640
+            while ($rule_line = $sth2->fetch()) {
1641
+                #				print_r($rule_line);
1642 1642
 
1643
-				if ($rule_line["match_on"]) {
1644
-					$match_on = json_decode($rule_line["match_on"], true);
1643
+                if ($rule_line["match_on"]) {
1644
+                    $match_on = json_decode($rule_line["match_on"], true);
1645 1645
 
1646
-					if (in_array("0", $match_on) || in_array($feed_id, $match_on) || count(array_intersect($check_cats_fullids, $match_on)) > 0) {
1646
+                    if (in_array("0", $match_on) || in_array($feed_id, $match_on) || count(array_intersect($check_cats_fullids, $match_on)) > 0) {
1647 1647
 
1648
-						$rule = array();
1649
-						$rule["reg_exp"] = $rule_line["reg_exp"];
1650
-						$rule["type"] = $rule_line["type_name"];
1651
-						$rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1648
+                        $rule = array();
1649
+                        $rule["reg_exp"] = $rule_line["reg_exp"];
1650
+                        $rule["type"] = $rule_line["type_name"];
1651
+                        $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1652 1652
 
1653
-						array_push($rules, $rule);
1654
-					} else if (!$match_any_rule) {
1655
-						// this filter contains a rule that doesn't match to this feed/category combination
1656
-						// thus filter has to be rejected
1653
+                        array_push($rules, $rule);
1654
+                    } else if (!$match_any_rule) {
1655
+                        // this filter contains a rule that doesn't match to this feed/category combination
1656
+                        // thus filter has to be rejected
1657 1657
 
1658
-						$rules = [];
1659
-						break;
1660
-					}
1658
+                        $rules = [];
1659
+                        break;
1660
+                    }
1661 1661
 
1662
-				} else {
1662
+                } else {
1663 1663
 
1664
-					$rule = array();
1665
-					$rule["reg_exp"] = $rule_line["reg_exp"];
1666
-					$rule["type"] = $rule_line["type_name"];
1667
-					$rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1664
+                    $rule = array();
1665
+                    $rule["reg_exp"] = $rule_line["reg_exp"];
1666
+                    $rule["type"] = $rule_line["type_name"];
1667
+                    $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1668 1668
 
1669
-					array_push($rules, $rule);
1670
-				}
1671
-			}
1669
+                    array_push($rules, $rule);
1670
+                }
1671
+            }
1672 1672
 
1673
-			if (count($rules) > 0) {
1674
-				$sth2 = $pdo->prepare("SELECT a.action_param,t.name AS type_name
1673
+            if (count($rules) > 0) {
1674
+                $sth2 = $pdo->prepare("SELECT a.action_param,t.name AS type_name
1675 1675
 						FROM ttrss_filters2_actions AS a,
1676 1676
 						ttrss_filter_actions AS t
1677 1677
 						WHERE
1678 1678
 							action_id = t.id AND filter_id = ?");
1679
-				$sth2->execute([$filter_id]);
1680
-
1681
-				while ($action_line = $sth2->fetch()) {
1682
-					#				print_r($action_line);
1683
-
1684
-					$action = array();
1685
-					$action["type"] = $action_line["type_name"];
1686
-					$action["param"] = $action_line["action_param"];
1687
-
1688
-					array_push($actions, $action);
1689
-				}
1690
-			}
1691
-
1692
-			$filter = [];
1693
-			$filter["id"] = $filter_id;
1694
-			$filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
1695
-			$filter["inverse"] = sql_bool_to_bool($line["inverse"]);
1696
-			$filter["rules"] = $rules;
1697
-			$filter["actions"] = $actions;
1698
-
1699
-			if (count($rules) > 0 && count($actions) > 0) {
1700
-				array_push($filters, $filter);
1701
-			}
1702
-		}
1703
-
1704
-		return $filters;
1705
-	}
1706
-
1707
-	/**
1708
-	 * Try to determine the favicon URL for a feed.
1709
-	 * adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
1710
-	 * http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
1711
-	 *
1712
-	 * @param string $url A feed or page URL
1713
-	 * @access public
1714
-	 * @return mixed The favicon URL, or false if none was found.
1715
-	 */
1716
-	public static function get_favicon_url($url) {
1717
-
1718
-		$favicon_url = false;
1719
-
1720
-		if ($html = @fetch_file_contents($url)) {
1721
-
1722
-			$doc = new DOMDocument();
1723
-			if ($doc->loadHTML($html)) {
1724
-				$xpath = new DOMXPath($doc);
1725
-
1726
-				$base = $xpath->query('/html/head/base[@href]');
1727
-				foreach ($base as $b) {
1728
-					$url = rewrite_relative_url($url, $b->getAttribute("href"));
1729
-					break;
1730
-				}
1731
-
1732
-				$entries = $xpath->query('/html/head/link[@rel="shortcut icon" or @rel="icon"]');
1733
-				if (count($entries) > 0) {
1734
-					foreach ($entries as $entry) {
1735
-						$favicon_url = rewrite_relative_url($url, $entry->getAttribute("href"));
1736
-						break;
1737
-					}
1738
-				}
1739
-			}
1740
-		}
1741
-
1742
-		if (!$favicon_url) {
1743
-					$favicon_url = rewrite_relative_url($url, "/favicon.ico");
1744
-		}
1745
-
1746
-		return $favicon_url;
1747
-	}
1679
+                $sth2->execute([$filter_id]);
1680
+
1681
+                while ($action_line = $sth2->fetch()) {
1682
+                    #				print_r($action_line);
1683
+
1684
+                    $action = array();
1685
+                    $action["type"] = $action_line["type_name"];
1686
+                    $action["param"] = $action_line["action_param"];
1687
+
1688
+                    array_push($actions, $action);
1689
+                }
1690
+            }
1691
+
1692
+            $filter = [];
1693
+            $filter["id"] = $filter_id;
1694
+            $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
1695
+            $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
1696
+            $filter["rules"] = $rules;
1697
+            $filter["actions"] = $actions;
1698
+
1699
+            if (count($rules) > 0 && count($actions) > 0) {
1700
+                array_push($filters, $filter);
1701
+            }
1702
+        }
1703
+
1704
+        return $filters;
1705
+    }
1706
+
1707
+    /**
1708
+     * Try to determine the favicon URL for a feed.
1709
+     * adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
1710
+     * http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
1711
+     *
1712
+     * @param string $url A feed or page URL
1713
+     * @access public
1714
+     * @return mixed The favicon URL, or false if none was found.
1715
+     */
1716
+    public static function get_favicon_url($url) {
1717
+
1718
+        $favicon_url = false;
1719
+
1720
+        if ($html = @fetch_file_contents($url)) {
1721
+
1722
+            $doc = new DOMDocument();
1723
+            if ($doc->loadHTML($html)) {
1724
+                $xpath = new DOMXPath($doc);
1725
+
1726
+                $base = $xpath->query('/html/head/base[@href]');
1727
+                foreach ($base as $b) {
1728
+                    $url = rewrite_relative_url($url, $b->getAttribute("href"));
1729
+                    break;
1730
+                }
1731
+
1732
+                $entries = $xpath->query('/html/head/link[@rel="shortcut icon" or @rel="icon"]');
1733
+                if (count($entries) > 0) {
1734
+                    foreach ($entries as $entry) {
1735
+                        $favicon_url = rewrite_relative_url($url, $entry->getAttribute("href"));
1736
+                        break;
1737
+                    }
1738
+                }
1739
+            }
1740
+        }
1741
+
1742
+        if (!$favicon_url) {
1743
+                    $favicon_url = rewrite_relative_url($url, "/favicon.ico");
1744
+        }
1745
+
1746
+        return $favicon_url;
1747
+    }
1748 1748
 
1749 1749
 }
Please login to merge, or discard this patch.
Switch Indentation   +26 added lines, -26 removed lines patch added patch discarded remove patch
@@ -1364,35 +1364,35 @@
 block discarded – undo
1364 1364
 				}
1365 1365
 
1366 1366
 				switch ($rule["type"]) {
1367
-					case "title":
1368
-						$match = @preg_match("/$reg_exp/iu", $title);
1369
-						break;
1370
-					case "content":
1371
-						// we don't need to deal with multiline regexps
1372
-						$content = preg_replace("/[\r\n\t]/", "", $content);
1367
+				case "title":
1368
+					$match = @preg_match("/$reg_exp/iu", $title);
1369
+					break;
1370
+				case "content":
1371
+					// we don't need to deal with multiline regexps
1372
+					$content = preg_replace("/[\r\n\t]/", "", $content);
1373 1373
 
1374
-						$match = @preg_match("/$reg_exp/iu", $content);
1375
-						break;
1376
-					case "both":
1377
-						// we don't need to deal with multiline regexps
1378
-						$content = preg_replace("/[\r\n\t]/", "", $content);
1374
+					$match = @preg_match("/$reg_exp/iu", $content);
1375
+					break;
1376
+				case "both":
1377
+					// we don't need to deal with multiline regexps
1378
+					$content = preg_replace("/[\r\n\t]/", "", $content);
1379 1379
 
1380
-						$match = (@preg_match("/$reg_exp/iu", $title) || @preg_match("/$reg_exp/iu", $content));
1381
-						break;
1382
-					case "link":
1383
-						$match = @preg_match("/$reg_exp/iu", $link);
1384
-						break;
1385
-					case "author":
1386
-						$match = @preg_match("/$reg_exp/iu", $author);
1387
-						break;
1388
-					case "tag":
1389
-						foreach ($tags as $tag) {
1390
-							if (@preg_match("/$reg_exp/iu", $tag)) {
1391
-								$match = true;
1392
-								break;
1393
-							}
1380
+					$match = (@preg_match("/$reg_exp/iu", $title) || @preg_match("/$reg_exp/iu", $content));
1381
+					break;
1382
+				case "link":
1383
+					$match = @preg_match("/$reg_exp/iu", $link);
1384
+					break;
1385
+				case "author":
1386
+					$match = @preg_match("/$reg_exp/iu", $author);
1387
+					break;
1388
+				case "tag":
1389
+					foreach ($tags as $tag) {
1390
+						if (@preg_match("/$reg_exp/iu", $tag)) {
1391
+							$match = true;
1392
+							break;
1394 1393
 						}
1395
-						break;
1394
+					}
1395
+					break;
1396 1396
 				}
1397 1397
 
1398 1398
 				if ($rule_inverse) {
Please login to merge, or discard this patch.
Braces   +7 added lines, -2 removed lines patch added patch discarded remove patch
@@ -616,10 +616,15 @@
 block discarded – undo
616 616
 				Debug::log("link $entry_link", Debug::$LOG_VERBOSE);
617 617
 				Debug::log("language $entry_language", Debug::$LOG_VERBOSE);
618 618
 
619
-				if (!$entry_title) $entry_title = date("Y-m-d H:i:s", $entry_timestamp); ;
619
+				if (!$entry_title) {
620
+				    $entry_title = date("Y-m-d H:i:s", $entry_timestamp);
621
+				}
622
+				;
620 623
 
621 624
 				$entry_content = $item->get_content();
622
-				if (!$entry_content) $entry_content = $item->get_description();
625
+				if (!$entry_content) {
626
+				    $entry_content = $item->get_description();
627
+				}
623 628
 
624 629
 				if (Debug::get_loglevel() >= 3) {
625 630
 					print "content: ";
Please login to merge, or discard this patch.
classes/backend.php 3 patches
Indentation   +96 added lines, -96 removed lines patch added patch discarded remove patch
@@ -1,101 +1,101 @@
 block discarded – undo
1 1
 <?php
2 2
 class Backend extends Handler {
3
-	public function loading() {
4
-		header("Content-type: text/html");
5
-		print __("Loading, please wait...")." ".
6
-			"<img src='images/indicator_tiny.gif'>";
7
-	}
8
-
9
-	public function digestTest() {
10
-		if (isset($_SESSION['uid'])) {
11
-			header("Content-type: text/html");
12
-
13
-			$rv = Digest::prepare_headlines_digest($_SESSION['uid'], 1, 1000);
14
-
15
-			print "<h1>HTML</h1>";
16
-			print $rv[0];
17
-			print "<h1>Plain text</h1>";
18
-			print "<pre>".$rv[3]."</pre>";
19
-		} else {
20
-			print error_json(6);
21
-		}
22
-	}
23
-
24
-	public function help() {
25
-		$topic = clean_filename($_REQUEST["topic"]); // only one for now
26
-
27
-		if ($topic == "main") {
28
-			$info = get_hotkeys_info();
29
-			$imap = get_hotkeys_map();
30
-			$omap = array();
31
-
32
-			foreach ($imap[1] as $sequence => $action) {
33
-				if (!isset($omap[$action])) {
34
-				    $omap[$action] = array();
35
-				}
36
-
37
-				array_push($omap[$action], $sequence);
38
-			}
39
-
40
-			print "<ul class='panel panel-scrollable hotkeys-help' style='height : 300px'>";
41
-
42
-			$cur_section = "";
43
-			foreach ($info as $section => $hotkeys) {
44
-
45
-				if ($cur_section) {
46
-				    print "<li>&nbsp;</li>";
47
-				}
48
-				print "<li><h3>" . $section . "</h3></li>";
49
-				$cur_section = $section;
50
-
51
-				foreach ($hotkeys as $action => $description) {
52
-
53
-					if (is_array($omap[$action])) {
54
-						foreach ($omap[$action] as $sequence) {
55
-							if (strpos($sequence, "|") !== false) {
56
-								$sequence = substr($sequence,
57
-									strpos($sequence, "|") + 1,
58
-									strlen($sequence));
59
-							} else {
60
-								$keys = explode(" ", $sequence);
61
-
62
-								for ($i = 0; $i < count($keys); $i++) {
63
-									if (strlen($keys[$i]) > 1) {
64
-										$tmp = '';
65
-										foreach (str_split($keys[$i]) as $c) {
66
-											switch ($c) {
67
-												case '*':
68
-													$tmp .= __('Shift').'+';
69
-													break;
70
-												case '^':
71
-													$tmp .= __('Ctrl').'+';
72
-													break;
73
-												default:
74
-													$tmp .= $c;
75
-											}
76
-										}
77
-										$keys[$i] = $tmp;
78
-									}
79
-								}
80
-								$sequence = join(" ", $keys);
81
-							}
82
-
83
-							print "<li>";
84
-							print "<div class='hk'><code>$sequence</code></div>";
85
-							print "<div class='desc'>$description</div>";
86
-							print "</li>";
87
-						}
88
-					}
89
-				}
90
-			}
91
-
92
-			print "</ul>";
93
-		}
94
-
95
-		print "<footer class='text-center'>";
96
-		print "<button dojoType='dijit.form.Button'
3
+    public function loading() {
4
+        header("Content-type: text/html");
5
+        print __("Loading, please wait...")." ".
6
+            "<img src='images/indicator_tiny.gif'>";
7
+    }
8
+
9
+    public function digestTest() {
10
+        if (isset($_SESSION['uid'])) {
11
+            header("Content-type: text/html");
12
+
13
+            $rv = Digest::prepare_headlines_digest($_SESSION['uid'], 1, 1000);
14
+
15
+            print "<h1>HTML</h1>";
16
+            print $rv[0];
17
+            print "<h1>Plain text</h1>";
18
+            print "<pre>".$rv[3]."</pre>";
19
+        } else {
20
+            print error_json(6);
21
+        }
22
+    }
23
+
24
+    public function help() {
25
+        $topic = clean_filename($_REQUEST["topic"]); // only one for now
26
+
27
+        if ($topic == "main") {
28
+            $info = get_hotkeys_info();
29
+            $imap = get_hotkeys_map();
30
+            $omap = array();
31
+
32
+            foreach ($imap[1] as $sequence => $action) {
33
+                if (!isset($omap[$action])) {
34
+                    $omap[$action] = array();
35
+                }
36
+
37
+                array_push($omap[$action], $sequence);
38
+            }
39
+
40
+            print "<ul class='panel panel-scrollable hotkeys-help' style='height : 300px'>";
41
+
42
+            $cur_section = "";
43
+            foreach ($info as $section => $hotkeys) {
44
+
45
+                if ($cur_section) {
46
+                    print "<li>&nbsp;</li>";
47
+                }
48
+                print "<li><h3>" . $section . "</h3></li>";
49
+                $cur_section = $section;
50
+
51
+                foreach ($hotkeys as $action => $description) {
52
+
53
+                    if (is_array($omap[$action])) {
54
+                        foreach ($omap[$action] as $sequence) {
55
+                            if (strpos($sequence, "|") !== false) {
56
+                                $sequence = substr($sequence,
57
+                                    strpos($sequence, "|") + 1,
58
+                                    strlen($sequence));
59
+                            } else {
60
+                                $keys = explode(" ", $sequence);
61
+
62
+                                for ($i = 0; $i < count($keys); $i++) {
63
+                                    if (strlen($keys[$i]) > 1) {
64
+                                        $tmp = '';
65
+                                        foreach (str_split($keys[$i]) as $c) {
66
+                                            switch ($c) {
67
+                                                case '*':
68
+                                                    $tmp .= __('Shift').'+';
69
+                                                    break;
70
+                                                case '^':
71
+                                                    $tmp .= __('Ctrl').'+';
72
+                                                    break;
73
+                                                default:
74
+                                                    $tmp .= $c;
75
+                                            }
76
+                                        }
77
+                                        $keys[$i] = $tmp;
78
+                                    }
79
+                                }
80
+                                $sequence = join(" ", $keys);
81
+                            }
82
+
83
+                            print "<li>";
84
+                            print "<div class='hk'><code>$sequence</code></div>";
85
+                            print "<div class='desc'>$description</div>";
86
+                            print "</li>";
87
+                        }
88
+                    }
89
+                }
90
+            }
91
+
92
+            print "</ul>";
93
+        }
94
+
95
+        print "<footer class='text-center'>";
96
+        print "<button dojoType='dijit.form.Button'
97 97
 			onclick=\"return dijit.byId('helpDlg').hide()\">".__('Close this window')."</button>";
98
-		print "</footer>";
98
+        print "</footer>";
99 99
 
100
-	}
100
+    }
101 101
 }
Please login to merge, or discard this patch.
Switch Indentation   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -64,14 +64,14 @@
 block discarded – undo
64 64
 										$tmp = '';
65 65
 										foreach (str_split($keys[$i]) as $c) {
66 66
 											switch ($c) {
67
-												case '*':
68
-													$tmp .= __('Shift').'+';
69
-													break;
70
-												case '^':
71
-													$tmp .= __('Ctrl').'+';
72
-													break;
73
-												default:
74
-													$tmp .= $c;
67
+											case '*':
68
+												$tmp .= __('Shift').'+';
69
+												break;
70
+											case '^':
71
+												$tmp .= __('Ctrl').'+';
72
+												break;
73
+											default:
74
+												$tmp .= $c;
75 75
 											}
76 76
 										}
77 77
 										$keys[$i] = $tmp;
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -45,7 +45,7 @@
 block discarded – undo
45 45
 				if ($cur_section) {
46 46
 				    print "<li>&nbsp;</li>";
47 47
 				}
48
-				print "<li><h3>" . $section . "</h3></li>";
48
+				print "<li><h3>".$section."</h3></li>";
49 49
 				$cur_section = $section;
50 50
 
51 51
 				foreach ($hotkeys as $action => $description) {
Please login to merge, or discard this patch.