]> git.wh0rd.org - tt-rss.git/blob - include/functions.php
git.wh0rd.org / tt-rss.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
blame | history | raw | HEAD
Merge branch 'master' of github.com:gothfox/Tiny-Tiny-RSS
[tt-rss.git] / include / functions.php
1 <?php
2 define('EXPECTED_CONFIG_VERSION', 26);
3 define('SCHEMA_VERSION', 116);
4
5 define('LABEL_BASE_INDEX', -1024);
6 define('PLUGIN_FEED_BASE_INDEX', -128);
7
8 $fetch_last_error = false;
9 $fetch_last_error_code = false;
10 $fetch_last_content_type = false;
11 $pluginhost = false;
12
13 function __autoload($class) {
14 $class_file = str_replace("_", "/", strtolower(basename($class)));
15
16 $file = dirname(__FILE__)."/../classes/$class_file.php";
17
18 if (file_exists($file)) {
19 require $file;
20 }
21
22 }
23
24 mb_internal_encoding("UTF-8");
25 date_default_timezone_set('UTC');
26 if (defined('E_DEPRECATED')) {
27 error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
28 } else {
29 error_reporting(E_ALL & ~E_NOTICE);
30 }
31
32 require_once 'config.php';
33
34 /**
35 * Define a constant if not already defined
36 *
37 * @param string $name The constant name.
38 * @param mixed $value The constant value.
39 * @access public
40 * @return boolean True if defined successfully or not.
41 */
42 function define_default($name, $value) {
43 defined($name) or define($name, $value);
44 }
45
46 ///// Some defaults that you can override in config.php //////
47
48 define_default('FEED_FETCH_TIMEOUT', 45);
49 // How may seconds to wait for response when requesting feed from a site
50 define_default('FEED_FETCH_NO_CACHE_TIMEOUT', 15);
51 // How may seconds to wait for response when requesting feed from a
52 // site when that feed wasn't cached before
53 define_default('FILE_FETCH_TIMEOUT', 45);
54 // Default timeout when fetching files from remote sites
55 define_default('FILE_FETCH_CONNECT_TIMEOUT', 15);
56 // How many seconds to wait for initial response from website when
57 // fetching files from remote sites
58
59 if (DB_TYPE == "pgsql") {
60 define('SUBSTRING_FOR_DATE', 'SUBSTRING_FOR_DATE');
61 } else {
62 define('SUBSTRING_FOR_DATE', 'SUBSTRING');
63 }
64
65 /**
66 * Return available translations names.
67 *
68 * @access public
69 * @return array A array of available translations.
70 */
71 function get_translations() {
72 $tr = array(
73 "auto" => "Detect automatically",
74 "ca_CA" => "Català",
75 "cs_CZ" => "Česky",
76 "en_US" => "English",
77 "es_ES" => "Español",
78 "de_DE" => "Deutsch",
79 "fr_FR" => "Français",
80 "hu_HU" => "Magyar (Hungarian)",
81 "it_IT" => "Italiano",
82 "ja_JP" => "日本語 (Japanese)",
83 "lv_LV" => "Latviešu",
84 "nb_NO" => "Norwegian bokmål",
85 "nl_NL" => "Dutch",
86 "pl_PL" => "Polski",
87 "ru_RU" => "Русский",
88 "pt_BR" => "Portuguese/Brazil",
89 "zh_CN" => "Simplified Chinese",
90 "sv_SE" => "Svenska",
91 "fi_FI" => "Suomi");
92
93 return $tr;
94 }
95
96 require_once "lib/accept-to-gettext.php";
97 require_once "lib/gettext/gettext.inc";
98
99
100 function startup_gettext() {
101
102 # Get locale from Accept-Language header
103 $lang = al2gt(array_keys(get_translations()), "text/html");
104
105 if (defined('_TRANSLATION_OVERRIDE_DEFAULT')) {
106 $lang = _TRANSLATION_OVERRIDE_DEFAULT;
107 }
108
109 if ($_SESSION["language"] && $_SESSION["language"] != "auto") {
110 $lang = $_SESSION["language"];
111 }
112
113 if ($lang) {
114 if (defined('LC_MESSAGES')) {
115 _setlocale(LC_MESSAGES, $lang);
116 } else if (defined('LC_ALL')) {
117 _setlocale(LC_ALL, $lang);
118 }
119
120 _bindtextdomain("messages", "locale");
121
122 _textdomain("messages");
123 _bind_textdomain_codeset("messages", "UTF-8");
124 }
125 }
126
127 startup_gettext();
128
129 require_once 'db-prefs.php';
130 require_once 'version.php';
131 require_once 'ccache.php';
132 require_once 'labels.php';
133
134 define('SELF_USER_AGENT', 'Tiny Tiny RSS/' . VERSION . ' (http://tt-rss.org/)');
135 ini_set('user_agent', SELF_USER_AGENT);
136
137 require_once 'lib/pubsubhubbub/publisher.php';
138
139 $tz_offset = -1;
140 $utc_tz = new DateTimeZone('UTC');
141 $schema_version = false;
142
143 /**
144 * Print a timestamped debug message.
145 *
146 * @param string $msg The debug message.
147 * @return void
148 */
149 function _debug($msg) {
150 $ts = strftime("%H:%M:%S", time());
151 if (function_exists('posix_getpid')) {
152 $ts = "$ts/" . posix_getpid();
153 }
154
155 if (!(defined('QUIET') && QUIET)) {
156 print "[$ts] $msg\n";
157 }
158
159 if (defined('LOGFILE')) {
160 $fp = fopen(LOGFILE, 'a+');
161
162 if ($fp) {
163 fputs($fp, "[$ts] $msg\n");
164 fclose($fp);
165 }
166 }
167
168 } // function _debug
169
170 /**
171 * Purge a feed old posts.
172 *
173 * @param mixed $link A database connection.
174 * @param mixed $feed_id The id of the purged feed.
175 * @param mixed $purge_interval Olderness of purged posts.
176 * @param boolean $debug Set to True to enable the debug. False by default.
177 * @access public
178 * @return void
179 */
180 function purge_feed($link, $feed_id, $purge_interval, $debug = false) {
181
182 if (!$purge_interval) $purge_interval = feed_purge_interval($link, $feed_id);
183
184 $rows = -1;
185
186 $result = db_query($link,
187 "SELECT owner_uid FROM ttrss_feeds WHERE id = '$feed_id'");
188
189 $owner_uid = false;
190
191 if (db_num_rows($result) == 1) {
192 $owner_uid = db_fetch_result($result, 0, "owner_uid");
193 }
194
195 if ($purge_interval == -1 || !$purge_interval) {
196 if ($owner_uid) {
197 ccache_update($link, $feed_id, $owner_uid);
198 }
199 return;
200 }
201
202 if (!$owner_uid) return;
203
204 if (FORCE_ARTICLE_PURGE == 0) {
205 $purge_unread = get_pref($link, "PURGE_UNREAD_ARTICLES",
206 $owner_uid, false);
207 } else {
208 $purge_unread = true;
209 $purge_interval = FORCE_ARTICLE_PURGE;
210 }
211
212 if (!$purge_unread) $query_limit = " unread = false AND ";
213
214 if (DB_TYPE == "pgsql") {
215 $pg_version = get_pgsql_version($link);
216
217 if (preg_match("/^7\./", $pg_version) || preg_match("/^8\.0/", $pg_version)) {
218
219 $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
220 ttrss_entries.id = ref_id AND
221 marked = false AND
222 feed_id = '$feed_id' AND
223 $query_limit
224 ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
225
226 } else {
227
228 $result = db_query($link, "DELETE FROM ttrss_user_entries
229 USING ttrss_entries
230 WHERE ttrss_entries.id = ref_id AND
231 marked = false AND
232 feed_id = '$feed_id' AND
233 $query_limit
234 ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
235 }
236
237 $rows = pg_affected_rows($result);
238
239 } else {
240
241 /* $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
242 marked = false AND feed_id = '$feed_id' AND
243 (SELECT date_updated FROM ttrss_entries WHERE
244 id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */
245
246 $result = db_query($link, "DELETE FROM ttrss_user_entries
247 USING ttrss_user_entries, ttrss_entries
248 WHERE ttrss_entries.id = ref_id AND
249 marked = false AND
250 feed_id = '$feed_id' AND
251 $query_limit
252 ttrss_entries.date_updated < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)");
253
254 $rows = mysql_affected_rows($link);
255
256 }
257
258 ccache_update($link, $feed_id, $owner_uid);
259
260 if ($debug) {
261 _debug("Purged feed $feed_id ($purge_interval): deleted $rows articles");
262 }
263
264 return $rows;
265 } // function purge_feed
266
267 function feed_purge_interval($link, $feed_id) {
268
269 $result = db_query($link, "SELECT purge_interval, owner_uid FROM ttrss_feeds
270 WHERE id = '$feed_id'");
271
272 if (db_num_rows($result) == 1) {
273 $purge_interval = db_fetch_result($result, 0, "purge_interval");
274 $owner_uid = db_fetch_result($result, 0, "owner_uid");
275
276 if ($purge_interval == 0) $purge_interval = get_pref($link,
277 'PURGE_OLD_DAYS', $owner_uid);
278
279 return $purge_interval;
280
281 } else {
282 return -1;
283 }
284 }
285
286 function purge_orphans($link, $do_output = false) {
287
288 // purge orphaned posts in main content table
289 $result = db_query($link, "DELETE FROM ttrss_entries WHERE
290 (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
291
292 if ($do_output) {
293 $rows = db_affected_rows($link, $result);
294 _debug("Purged $rows orphaned posts.");
295 }
296 }
297
298 function get_feed_update_interval($link, $feed_id) {
299 $result = db_query($link, "SELECT owner_uid, update_interval FROM
300 ttrss_feeds WHERE id = '$feed_id'");
301
302 if (db_num_rows($result) == 1) {
303 $update_interval = db_fetch_result($result, 0, "update_interval");
304 $owner_uid = db_fetch_result($result, 0, "owner_uid");
305
306 if ($update_interval != 0) {
307 return $update_interval;
308 } else {
309 return get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $owner_uid, false);
310 }
311
312 } else {
313 return -1;
314 }
315 }
316
317 function fetch_file_contents($url, $type = false, $login = false, $pass = false, $post_query = false, $timeout = false, $timestamp = 0) {
318
319 global $fetch_last_error;
320 global $fetch_last_error_code;
321 global $fetch_last_content_type;
322
323 $url = str_replace(' ', '%20', $url);
324
325 if (!defined('NO_CURL') && function_exists('curl_init') && !ini_get("open_basedir")) {
326
327 if (ini_get("safe_mode")) {
328 $ch = curl_init(geturl($url));
329 } else {
330 $ch = curl_init($url);
331 }
332
333 if ($timestamp) {
334 curl_setopt($ch, CURLOPT_HTTPHEADER,
335 array("If-Modified-Since: ".gmdate('D, d M Y H:i:s \G\M\T', $timestamp)));
336 }
337
338 curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout ? $timeout : FILE_FETCH_CONNECT_TIMEOUT);
339 curl_setopt($ch, CURLOPT_TIMEOUT, $timeout ? $timeout : FILE_FETCH_TIMEOUT);
340 curl_setopt($ch, CURLOPT_FOLLOWLOCATION, !ini_get("safe_mode"));
341 curl_setopt($ch, CURLOPT_MAXREDIRS, 20);
342 curl_setopt($ch, CURLOPT_BINARYTRANSFER, true);
343 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
344 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
345 curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
346 curl_setopt($ch, CURLOPT_USERAGENT, SELF_USER_AGENT);
347 curl_setopt($ch, CURLOPT_ENCODING , "gzip");
348 curl_setopt($ch, CURLOPT_REFERER, $url);
349
350 if ($post_query) {
351 curl_setopt($ch, CURLOPT_POST, true);
352 curl_setopt($ch, CURLOPT_POSTFIELDS, $post_query);
353 }
354
355 if ($login && $pass)
356 curl_setopt($ch, CURLOPT_USERPWD, "$login:$pass");
357
358 $contents = @curl_exec($ch);
359
360 if (curl_errno($ch) === 23 || curl_errno($ch) === 61) {
361 curl_setopt($ch, CURLOPT_ENCODING, 'none');
362 $contents = @curl_exec($ch);
363 }
364
365 if ($contents === false) {
366 $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
367 curl_close($ch);
368 return false;
369 }
370
371 $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
372 $fetch_last_content_type = curl_getinfo($ch, CURLINFO_CONTENT_TYPE);
373
374 $fetch_last_error_code = $http_code;
375
376 if ($http_code != 200 || $type && strpos($fetch_last_content_type, "$type") === false) {
377 if (curl_errno($ch) != 0) {
378 $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
379 } else {
380 $fetch_last_error = "HTTP Code: $http_code";
381 }
382 curl_close($ch);
383 return false;
384 }
385
386 curl_close($ch);
387
388 return $contents;
389 } else {
390 if ($login && $pass){
391 $url_parts = array();
392
393 preg_match("/(^[^:]*):\/\/(.*)/", $url, $url_parts);
394
395 $pass = urlencode($pass);
396
397 if ($url_parts[1] && $url_parts[2]) {
398 $url = $url_parts[1] . "://$login:$pass@" . $url_parts[2];
399 }
400 }
401
402 $data = @file_get_contents($url);
403
404 $fetch_last_content_type = false; // reset if no type was sent from server
405 foreach ($http_response_header as $h) {
406 if (substr(strtolower($h), 0, 13) == 'content-type:') {
407 $fetch_last_content_type = substr($h, 14);
408 // don't abort here b/c there might be more than one
409 // e.g. if we were being redirected -- last one is the right one
410 }
411 }
412
413 if (!$data && function_exists('error_get_last')) {
414 $error = error_get_last();
415 $fetch_last_error = $error["message"];
416 }
417 return $data;
418 }
419
420 }
421
422 /**
423 * Try to determine the favicon URL for a feed.
424 * adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
425 * http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
426 *
427 * @param string $url A feed or page URL
428 * @access public
429 * @return mixed The favicon URL, or false if none was found.
430 */
431 function get_favicon_url($url) {
432
433 $favicon_url = false;
434
435 if ($html = @fetch_file_contents($url)) {
436
437 libxml_use_internal_errors(true);
438
439 $doc = new DOMDocument();
440 $doc->loadHTML($html);
441 $xpath = new DOMXPath($doc);
442
443 $base = $xpath->query('/html/head/base');
444 foreach ($base as $b) {
445 $url = $b->getAttribute("href");
446 break;
447 }
448
449 $entries = $xpath->query('/html/head/link[@rel="shortcut icon" or @rel="icon"]');
450 if (count($entries) > 0) {
451 foreach ($entries as $entry) {
452 $favicon_url = rewrite_relative_url($url, $entry->getAttribute("href"));
453 break;
454 }
455 }
456 }
457
458 if (!$favicon_url)
459 $favicon_url = rewrite_relative_url($url, "/favicon.ico");
460
461 return $favicon_url;
462 } // function get_favicon_url
463
464 function check_feed_favicon($site_url, $feed, $link) {
465 # print "FAVICON [$site_url]: $favicon_url\n";
466
467 $icon_file = ICONS_DIR . "/$feed.ico";
468
469 if (!file_exists($icon_file)) {
470 $favicon_url = get_favicon_url($site_url);
471
472 if ($favicon_url) {
473 // Limiting to "image" type misses those served with text/plain
474 $contents = fetch_file_contents($favicon_url); // , "image");
475
476 if ($contents) {
477 // Crude image type matching.
478 // Patterns gleaned from the file(1) source code.
479 if (preg_match('/^\x00\x00\x01\x00/', $contents)) {
480 // 0 string \000\000\001\000 MS Windows icon resource
481 //error_log("check_feed_favicon: favicon_url=$favicon_url isa MS Windows icon resource");
482 }
483 elseif (preg_match('/^GIF8/', $contents)) {
484 // 0 string GIF8 GIF image data
485 //error_log("check_feed_favicon: favicon_url=$favicon_url isa GIF image");
486 }
487 elseif (preg_match('/^\x89PNG\x0d\x0a\x1a\x0a/', $contents)) {
488 // 0 string \x89PNG\x0d\x0a\x1a\x0a PNG image data
489 //error_log("check_feed_favicon: favicon_url=$favicon_url isa PNG image");
490 }
491 elseif (preg_match('/^\xff\xd8/', $contents)) {
492 // 0 beshort 0xffd8 JPEG image data
493 //error_log("check_feed_favicon: favicon_url=$favicon_url isa JPG image");
494 }
495 else {
496 //error_log("check_feed_favicon: favicon_url=$favicon_url isa UNKNOWN type");
497 $contents = "";
498 }
499 }
500
501 if ($contents) {
502 $fp = @fopen($icon_file, "w");
503
504 if ($fp) {
505 fwrite($fp, $contents);
506 fclose($fp);
507 chmod($icon_file, 0644);
508 }
509 }
510 }
511 }
512 }
513
514 function print_select($id, $default, $values, $attributes = "") {
515 print "<select name=\"$id\" id=\"$id\" $attributes>";
516 foreach ($values as $v) {
517 if ($v == $default)
518 $sel = "selected=\"1\"";
519 else
520 $sel = "";
521
522 $v = trim($v);
523
524 print "<option value=\"$v\" $sel>$v</option>";
525 }
526 print "</select>";
527 }
528
529 function print_select_hash($id, $default, $values, $attributes = "") {
530 print "<select name=\"$id\" id='$id' $attributes>";
531 foreach (array_keys($values) as $v) {
532 if ($v == $default)
533 $sel = 'selected="selected"';
534 else
535 $sel = "";
536
537 $v = trim($v);
538
539 print "<option $sel value=\"$v\">".$values[$v]."</option>";
540 }
541
542 print "</select>";
543 }
544
545 function print_radio($id, $default, $true_is, $values, $attributes = "") {
546 foreach ($values as $v) {
547
548 if ($v == $default)
549 $sel = "checked";
550 else
551 $sel = "";
552
553 if ($v == $true_is) {
554 $sel .= " value=\"1\"";
555 } else {
556 $sel .= " value=\"0\"";
557 }
558
559 print "<input class=\"noborder\" dojoType=\"dijit.form.RadioButton\"
560 type=\"radio\" $sel $attributes name=\"$id\">&nbsp;$v&nbsp;";
561
562 }
563 }
564
565 function initialize_user_prefs($link, $uid, $profile = false) {
566
567 $uid = db_escape_string($link, $uid);
568
569 if (!$profile) {
570 $profile = "NULL";
571 $profile_qpart = "AND profile IS NULL";
572 } else {
573 $profile_qpart = "AND profile = '$profile'";
574 }
575
576 if (get_schema_version($link) < 63) $profile_qpart = "";
577
578 db_query($link, "BEGIN");
579
580 $result = db_query($link, "SELECT pref_name,def_value FROM ttrss_prefs");
581
582 $u_result = db_query($link, "SELECT pref_name
583 FROM ttrss_user_prefs WHERE owner_uid = '$uid' $profile_qpart");
584
585 $active_prefs = array();
586
587 while ($line = db_fetch_assoc($u_result)) {
588 array_push($active_prefs, $line["pref_name"]);
589 }
590
591 while ($line = db_fetch_assoc($result)) {
592 if (array_search($line["pref_name"], $active_prefs) === FALSE) {
593 // print "adding " . $line["pref_name"] . "<br>";
594
595 $line["def_value"] = db_escape_string($link, $line["def_value"]);
596 $line["pref_name"] = db_escape_string($link, $line["pref_name"]);
597
598 if (get_schema_version($link) < 63) {
599 db_query($link, "INSERT INTO ttrss_user_prefs
600 (owner_uid,pref_name,value) VALUES
601 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')");
602
603 } else {
604 db_query($link, "INSERT INTO ttrss_user_prefs
605 (owner_uid,pref_name,value, profile) VALUES
606 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."', $profile)");
607 }
608
609 }
610 }
611
612 db_query($link, "COMMIT");
613
614 }
615
616 function get_ssl_certificate_id() {
617 if ($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"]) {
618 return sha1($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"] .
619 $_SERVER["REDIRECT_SSL_CLIENT_V_START"] .
620 $_SERVER["REDIRECT_SSL_CLIENT_V_END"] .
621 $_SERVER["REDIRECT_SSL_CLIENT_S_DN"]);
622 }
623 return "";
624 }
625
626 function authenticate_user($link, $login, $password, $check_only = false) {
627
628 if (!SINGLE_USER_MODE) {
629 $user_id = false;
630
631 global $pluginhost;
632 foreach ($pluginhost->get_hooks($pluginhost::HOOK_AUTH_USER) as $plugin) {
633
634 $user_id = (int) $plugin->authenticate($login, $password);
635
636 if ($user_id) {
637 $_SESSION["auth_module"] = strtolower(get_class($plugin));
638 break;
639 }
640 }
641
642 if ($user_id && !$check_only) {
643 @session_start();
644
645 $_SESSION["uid"] = $user_id;
646 $_SESSION["version"] = VERSION;
647
648 $result = db_query($link, "SELECT login,access_level,pwd_hash FROM ttrss_users
649 WHERE id = '$user_id'");
650
651 $_SESSION["name"] = db_fetch_result($result, 0, "login");
652 $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level");
653 $_SESSION["csrf_token"] = sha1(uniqid(rand(), true));
654
655 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
656 $_SESSION["uid"]);
657
658 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
659 $_SESSION["user_agent"] = sha1($_SERVER['HTTP_USER_AGENT']);
660 $_SESSION["pwd_hash"] = db_fetch_result($result, 0, "pwd_hash");
661
662 $_SESSION["last_version_check"] = time();
663
664 initialize_user_prefs($link, $_SESSION["uid"]);
665
666 return true;
667 }
668
669 return false;
670
671 } else {
672
673 $_SESSION["uid"] = 1;
674 $_SESSION["name"] = "admin";
675 $_SESSION["access_level"] = 10;
676
677 $_SESSION["hide_hello"] = true;
678 $_SESSION["hide_logout"] = true;
679
680 $_SESSION["auth_module"] = false;
681
682 if (!$_SESSION["csrf_token"]) {
683 $_SESSION["csrf_token"] = sha1(uniqid(rand(), true));
684 }
685
686 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
687
688 initialize_user_prefs($link, $_SESSION["uid"]);
689
690 return true;
691 }
692 }
693
694 function make_password($length = 8) {
695
696 $password = "";
697 $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ";
698
699 $i = 0;
700
701 while ($i < $length) {
702 $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
703
704 if (!strstr($password, $char)) {
705 $password .= $char;
706 $i++;
707 }
708 }
709 return $password;
710 }
711
712 // this is called after user is created to initialize default feeds, labels
713 // or whatever else
714
715 // user preferences are checked on every login, not here
716
717 function initialize_user($link, $uid) {
718
719 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
720 values ('$uid', 'Tiny Tiny RSS: New Releases',
721 'http://tt-rss.org/releases.rss')");
722
723 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
724 values ('$uid', 'Tiny Tiny RSS: Forum',
725 'http://tt-rss.org/forum/rss.php')");
726 }
727
728 function logout_user() {
729 session_destroy();
730 if (isset($_COOKIE[session_name()])) {
731 setcookie(session_name(), '', time()-42000, '/');
732 }
733 }
734
735 function validate_csrf($csrf_token) {
736 return $csrf_token == $_SESSION['csrf_token'];
737 }
738
739 function load_user_plugins($link, $owner_uid) {
740 if ($owner_uid) {
741 $plugins = get_pref($link, "_ENABLED_PLUGINS", $owner_uid);
742
743 global $pluginhost;
744 $pluginhost->load($plugins, $pluginhost::KIND_USER, $owner_uid);
745
746 if (get_schema_version($link) > 100) {
747 $pluginhost->load_data();
748 }
749 }
750 }
751
752 function login_sequence($link) {
753 $_SESSION["prefs_cache"] = false;
754
755 if (SINGLE_USER_MODE) {
756 @session_start();
757 authenticate_user($link, "admin", null);
758 cache_prefs($link);
759 load_user_plugins($link, $_SESSION["uid"]);
760 } else {
761 if (!validate_session($link)) $_SESSION["uid"] = false;
762
763 if (!$_SESSION["uid"]) {
764
765 if (AUTH_AUTO_LOGIN && authenticate_user($link, null, null)) {
766 $_SESSION["ref_schema_version"] = get_schema_version($link, true);
767 } else {
768 authenticate_user($link, null, null, true);
769 }
770
771 if (!$_SESSION["uid"]) {
772 @session_destroy();
773 setcookie(session_name(), '', time()-42000, '/');
774
775 render_login_form($link);
776 exit;
777 }
778
779 } else {
780 /* bump login timestamp */
781 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
782 $_SESSION["uid"]);
783 $_SESSION["last_login_update"] = time();
784 }
785
786 if ($_SESSION["uid"] && $_SESSION["language"] && SESSION_COOKIE_LIFETIME > 0) {
787 setcookie("ttrss_lang", $_SESSION["language"],
788 time() + SESSION_COOKIE_LIFETIME);
789 }
790
791 if ($_SESSION["uid"]) {
792 cache_prefs($link);
793 load_user_plugins($link, $_SESSION["uid"]);
794
795 /* cleanup ccache */
796
797 db_query($link, "DELETE FROM ttrss_counters_cache WHERE owner_uid = ".
798 $_SESSION["uid"] . " AND
799 (SELECT COUNT(id) FROM ttrss_feeds WHERE
800 ttrss_feeds.id = feed_id) = 0");
801
802 db_query($link, "DELETE FROM ttrss_cat_counters_cache WHERE owner_uid = ".
803 $_SESSION["uid"] . " AND
804 (SELECT COUNT(id) FROM ttrss_feed_categories WHERE
805 ttrss_feed_categories.id = feed_id) = 0");
806
807 }
808
809 }
810 }
811
812 function truncate_string($str, $max_len, $suffix = '&hellip;') {
813 if (mb_strlen($str, "utf-8") > $max_len - 3) {
814 return mb_substr($str, 0, $max_len, "utf-8") . $suffix;
815 } else {
816 return $str;
817 }
818 }
819
820 function convert_timestamp($timestamp, $source_tz, $dest_tz) {
821
822 try {
823 $source_tz = new DateTimeZone($source_tz);
824 } catch (Exception $e) {
825 $source_tz = new DateTimeZone('UTC');
826 }
827
828 try {
829 $dest_tz = new DateTimeZone($dest_tz);
830 } catch (Exception $e) {
831 $dest_tz = new DateTimeZone('UTC');
832 }
833
834 $dt = new DateTime(date('Y-m-d H:i:s', $timestamp), $source_tz);
835 return $dt->format('U') + $dest_tz->getOffset($dt);
836 }
837
838 function make_local_datetime($link, $timestamp, $long, $owner_uid = false,
839 $no_smart_dt = false) {
840
841 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
842 if (!$timestamp) $timestamp = '1970-01-01 0:00';
843
844 global $utc_tz;
845 global $tz_offset;
846
847 # We store date in UTC internally
848 $dt = new DateTime($timestamp, $utc_tz);
849
850 if ($tz_offset == -1) {
851
852 $user_tz_string = get_pref($link, 'USER_TIMEZONE', $owner_uid);
853
854 try {
855 $user_tz = new DateTimeZone($user_tz_string);
856 } catch (Exception $e) {
857 $user_tz = $utc_tz;
858 }
859
860 $tz_offset = $user_tz->getOffset($dt);
861 }
862
863 $user_timestamp = $dt->format('U') + $tz_offset;
864
865 if (!$no_smart_dt) {
866 return smart_date_time($link, $user_timestamp,
867 $tz_offset, $owner_uid);
868 } else {
869 if ($long)
870 $format = get_pref($link, 'LONG_DATE_FORMAT', $owner_uid);
871 else
872 $format = get_pref($link, 'SHORT_DATE_FORMAT', $owner_uid);
873
874 return date($format, $user_timestamp);
875 }
876 }
877
878 function smart_date_time($link, $timestamp, $tz_offset = 0, $owner_uid = false) {
879 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
880
881 if (date("Y.m.d", $timestamp) == date("Y.m.d", time() + $tz_offset)) {
882 return date("G:i", $timestamp);
883 } else if (date("Y", $timestamp) == date("Y", time() + $tz_offset)) {
884 $format = get_pref($link, 'SHORT_DATE_FORMAT', $owner_uid);
885 return date($format, $timestamp);
886 } else {
887 $format = get_pref($link, 'LONG_DATE_FORMAT', $owner_uid);
888 return date($format, $timestamp);
889 }
890 }
891
892 function sql_bool_to_bool($s) {
893 if ($s == "t" || $s == "1" || strtolower($s) == "true") {
894 return true;
895 } else {
896 return false;
897 }
898 }
899
900 function bool_to_sql_bool($s) {
901 if ($s) {
902 return "true";
903 } else {
904 return "false";
905 }
906 }
907
908 // Session caching removed due to causing wrong redirects to upgrade
909 // script when get_schema_version() is called on an obsolete session
910 // created on a previous schema version.
911 function get_schema_version($link, $nocache = false) {
912 global $schema_version;
913
914 if (!$schema_version) {
915 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
916 $version = db_fetch_result($result, 0, "schema_version");
917 $schema_version = $version;
918 return $version;
919 } else {
920 return $schema_version;
921 }
922 }
923
924 function sanity_check($link) {
925 require_once 'errors.php';
926
927 $error_code = 0;
928 $schema_version = get_schema_version($link, true);
929
930 if ($schema_version != SCHEMA_VERSION) {
931 $error_code = 5;
932 }
933
934 if (DB_TYPE == "mysql") {
935 $result = db_query($link, "SELECT true", false);
936 if (db_num_rows($result) != 1) {
937 $error_code = 10;
938 }
939 }
940
941 if (db_escape_string($link, "testTEST") != "testTEST") {
942 $error_code = 12;
943 }
944
945 return array("code" => $error_code, "message" => $ERRORS[$error_code]);
946 }
947
948 function file_is_locked($filename) {
949 if (function_exists('flock')) {
950 $fp = @fopen(LOCK_DIRECTORY . "/$filename", "r");
951 if ($fp) {
952 if (flock($fp, LOCK_EX | LOCK_NB)) {
953 flock($fp, LOCK_UN);
954 fclose($fp);
955 return false;
956 }
957 fclose($fp);
958 return true;
959 } else {
960 return false;
961 }
962 }
963 return true; // consider the file always locked and skip the test
964 }
965
966 function make_lockfile($filename) {
967 $fp = fopen(LOCK_DIRECTORY . "/$filename", "w");
968
969 if ($fp && flock($fp, LOCK_EX | LOCK_NB)) {
970 if (function_exists('posix_getpid')) {
971 fwrite($fp, posix_getpid() . "\n");
972 }
973 return $fp;
974 } else {
975 return false;
976 }
977 }
978
979 function make_stampfile($filename) {
980 $fp = fopen(LOCK_DIRECTORY . "/$filename", "w");
981
982 if (flock($fp, LOCK_EX | LOCK_NB)) {
983 fwrite($fp, time() . "\n");
984 flock($fp, LOCK_UN);
985 fclose($fp);
986 return true;
987 } else {
988 return false;
989 }
990 }
991
992 function sql_random_function() {
993 if (DB_TYPE == "mysql") {
994 return "RAND()";
995 } else {
996 return "RANDOM()";
997 }
998 }
999
1000 function catchup_feed($link, $feed, $cat_view, $owner_uid = false, $max_id = false, $mode = 'all') {
1001
1002 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
1003
1004 //if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
1005
1006 // Todo: all this interval stuff needs some generic generator function
1007
1008 $date_qpart = "false";
1009
1010 switch ($mode) {
1011 case "1day":
1012 if (DB_TYPE == "pgsql") {
1013 $date_qpart = "date_entered < NOW() - INTERVAL '1 day' ";
1014 } else {
1015 $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 1 DAY) ";
1016 }
1017 break;
1018 case "1week":
1019 if (DB_TYPE == "pgsql") {
1020 $date_qpart = "date_entered < NOW() - INTERVAL '1 week' ";
1021 } else {
1022 $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 1 WEEK) ";
1023 }
1024 break;
1025 case "2weeks":
1026 if (DB_TYPE == "pgsql") {
1027 $date_qpart = "date_entered < NOW() - INTERVAL '2 week' ";
1028 } else {
1029 $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 2 WEEK) ";
1030 }
1031 break;
1032 default:
1033 $date_qpart = "true";
1034 }
1035
1036 if (is_numeric($feed)) {
1037 if ($cat_view) {
1038
1039 if ($feed >= 0) {
1040
1041 if ($feed > 0) {
1042 $children = getChildCategories($link, $feed, $owner_uid);
1043 array_push($children, $feed);
1044
1045 $children = join(",", $children);
1046
1047 $cat_qpart = "cat_id IN ($children)";
1048 } else {
1049 $cat_qpart = "cat_id IS NULL";
1050 }
1051
1052 db_query($link, "UPDATE ttrss_user_entries
1053 SET unread = false, last_read = NOW() WHERE ref_id IN
1054 (SELECT id FROM
1055 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1056 AND owner_uid = $owner_uid AND unread = true AND feed_id IN
1057 (SELECT id FROM ttrss_feeds WHERE $cat_qpart) AND $date_qpart) as tmp)");
1058
1059 } else if ($feed == -2) {
1060
1061 db_query($link, "UPDATE ttrss_user_entries
1062 SET unread = false,last_read = NOW() WHERE (SELECT COUNT(*)
1063 FROM ttrss_user_labels2 WHERE article_id = ref_id) > 0
1064 AND unread = true AND $date_qpart AND owner_uid = $owner_uid");
1065 }
1066
1067 } else if ($feed > 0) {
1068
1069 db_query($link, "UPDATE ttrss_user_entries
1070 SET unread = false, last_read = NOW() WHERE ref_id IN
1071 (SELECT id FROM
1072 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1073 AND owner_uid = $owner_uid AND unread = true AND feed_id = $feed AND $date_qpart) as tmp)");
1074
1075 } else if ($feed < 0 && $feed > LABEL_BASE_INDEX) { // special, like starred
1076
1077 if ($feed == -1) {
1078 db_query($link, "UPDATE ttrss_user_entries
1079 SET unread = false, last_read = NOW() WHERE ref_id IN
1080 (SELECT id FROM
1081 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1082 AND owner_uid = $owner_uid AND unread = true AND marked = true AND $date_qpart) as tmp)");
1083 }
1084
1085 if ($feed == -2) {
1086 db_query($link, "UPDATE ttrss_user_entries
1087 SET unread = false, last_read = NOW() WHERE ref_id IN
1088 (SELECT id FROM
1089 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1090 AND owner_uid = $owner_uid AND unread = true AND published = true AND $date_qpart) as tmp)");
1091 }
1092
1093 if ($feed == -3) {
1094
1095 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE");
1096
1097 if (DB_TYPE == "pgsql") {
1098 $match_part = "date_entered > NOW() - INTERVAL '$intl hour' ";
1099 } else {
1100 $match_part = "date_entered > DATE_SUB(NOW(),
1101 INTERVAL $intl HOUR) ";
1102 }
1103
1104 db_query($link, "UPDATE ttrss_user_entries
1105 SET unread = false, last_read = NOW() WHERE ref_id IN
1106 (SELECT id FROM
1107 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1108 AND owner_uid = $owner_uid AND unread = true AND $date_qpart AND $match_part) as tmp)");
1109 }
1110
1111 if ($feed == -4) {
1112 db_query($link, "UPDATE ttrss_user_entries
1113 SET unread = false, last_read = NOW() WHERE ref_id IN
1114 (SELECT id FROM
1115 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1116 AND owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1117 }
1118
1119 } else if ($feed < LABEL_BASE_INDEX) { // label
1120
1121 $label_id = feed_to_label_id($feed);
1122
1123 db_query($link, "UPDATE ttrss_user_entries
1124 SET unread = false, last_read = NOW() WHERE ref_id IN
1125 (SELECT id FROM
1126 (SELECT ttrss_entries.id FROM ttrss_entries, ttrss_user_entries, ttrss_user_labels2 WHERE ref_id = id
1127 AND label_id = '$label_id' AND ref_id = article_id
1128 AND owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1129
1130 }
1131
1132 ccache_update($link, $feed, $owner_uid, $cat_view);
1133
1134 } else { // tag
1135 db_query($link, "UPDATE ttrss_user_entries
1136 SET unread = false, last_read = NOW() WHERE ref_id IN
1137 (SELECT id FROM
1138 (SELECT ttrss_entries.id FROM ttrss_entries, ttrss_user_entries, ttrss_tags WHERE ref_id = ttrss_entries.id
1139 AND post_int_id = int_id AND tag_name = '$feed'
1140 AND ttrss_user_entries.owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1141
1142 }
1143 }
1144
1145 function getAllCounters($link) {
1146 $data = getGlobalCounters($link);
1147
1148 $data = array_merge($data, getVirtCounters($link));
1149 $data = array_merge($data, getLabelCounters($link));
1150 $data = array_merge($data, getFeedCounters($link, $active_feed));
1151 $data = array_merge($data, getCategoryCounters($link));
1152
1153 return $data;
1154 }
1155
1156 function getCategoryTitle($link, $cat_id) {
1157
1158 if ($cat_id == -1) {
1159 return __("Special");
1160 } else if ($cat_id == -2) {
1161 return __("Labels");
1162 } else {
1163
1164 $result = db_query($link, "SELECT title FROM ttrss_feed_categories WHERE
1165 id = '$cat_id'");
1166
1167 if (db_num_rows($result) == 1) {
1168 return db_fetch_result($result, 0, "title");
1169 } else {
1170 return __("Uncategorized");
1171 }
1172 }
1173 }
1174
1175
1176 function getCategoryCounters($link) {
1177 $ret_arr = array();
1178
1179 /* Labels category */
1180
1181 $cv = array("id" => -2, "kind" => "cat",
1182 "counter" => getCategoryUnread($link, -2));
1183
1184 array_push($ret_arr, $cv);
1185
1186 $result = db_query($link, "SELECT id AS cat_id, value AS unread,
1187 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2
1188 WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children
1189 FROM ttrss_feed_categories, ttrss_cat_counters_cache
1190 WHERE ttrss_cat_counters_cache.feed_id = id AND
1191 ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND
1192 ttrss_feed_categories.owner_uid = " . $_SESSION["uid"]);
1193
1194 while ($line = db_fetch_assoc($result)) {
1195 $line["cat_id"] = (int) $line["cat_id"];
1196
1197 if ($line["num_children"] > 0) {
1198 $child_counter = getCategoryChildrenUnread($link, $line["cat_id"], $_SESSION["uid"]);
1199 } else {
1200 $child_counter = 0;
1201 }
1202
1203 $cv = array("id" => $line["cat_id"], "kind" => "cat",
1204 "counter" => $line["unread"] + $child_counter);
1205
1206 array_push($ret_arr, $cv);
1207 }
1208
1209 /* Special case: NULL category doesn't actually exist in the DB */
1210
1211 $cv = array("id" => 0, "kind" => "cat",
1212 "counter" => (int) ccache_find($link, 0, $_SESSION["uid"], true));
1213
1214 array_push($ret_arr, $cv);
1215
1216 return $ret_arr;
1217 }
1218
1219 // only accepts real cats (>= 0)
1220 function getCategoryChildrenUnread($link, $cat, $owner_uid = false) {
1221 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1222
1223 $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE parent_cat = '$cat'
1224 AND owner_uid = $owner_uid");
1225
1226 $unread = 0;
1227
1228 while ($line = db_fetch_assoc($result)) {
1229 $unread += getCategoryUnread($link, $line["id"], $owner_uid);
1230 $unread += getCategoryChildrenUnread($link, $line["id"], $owner_uid);
1231 }
1232
1233 return $unread;
1234 }
1235
1236 function getCategoryUnread($link, $cat, $owner_uid = false) {
1237
1238 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1239
1240 if ($cat >= 0) {
1241
1242 if ($cat != 0) {
1243 $cat_query = "cat_id = '$cat'";
1244 } else {
1245 $cat_query = "cat_id IS NULL";
1246 }
1247
1248 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE $cat_query
1249 AND owner_uid = " . $owner_uid);
1250
1251 $cat_feeds = array();
1252 while ($line = db_fetch_assoc($result)) {
1253 array_push($cat_feeds, "feed_id = " . $line["id"]);
1254 }
1255
1256 if (count($cat_feeds) == 0) return 0;
1257
1258 $match_part = implode(" OR ", $cat_feeds);
1259
1260 $result = db_query($link, "SELECT COUNT(int_id) AS unread
1261 FROM ttrss_user_entries
1262 WHERE unread = true AND ($match_part)
1263 AND owner_uid = " . $owner_uid);
1264
1265 $unread = 0;
1266
1267 # this needs to be rewritten
1268 while ($line = db_fetch_assoc($result)) {
1269 $unread += $line["unread"];
1270 }
1271
1272 return $unread;
1273 } else if ($cat == -1) {
1274 return getFeedUnread($link, -1) + getFeedUnread($link, -2) + getFeedUnread($link, -3) + getFeedUnread($link, 0);
1275 } else if ($cat == -2) {
1276
1277 $result = db_query($link, "
1278 SELECT COUNT(unread) AS unread FROM
1279 ttrss_user_entries, ttrss_user_labels2
1280 WHERE article_id = ref_id AND unread = true
1281 AND ttrss_user_entries.owner_uid = '$owner_uid'");
1282
1283 $unread = db_fetch_result($result, 0, "unread");
1284
1285 return $unread;
1286
1287 }
1288 }
1289
1290 function getFeedUnread($link, $feed, $is_cat = false) {
1291 return getFeedArticles($link, $feed, $is_cat, true, $_SESSION["uid"]);
1292 }
1293
1294 function getLabelUnread($link, $label_id, $owner_uid = false) {
1295 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1296
1297 $result = db_query($link, "SELECT COUNT(ref_id) AS unread FROM ttrss_user_entries, ttrss_user_labels2
1298 WHERE owner_uid = '$owner_uid' AND unread = true AND label_id = '$label_id' AND article_id = ref_id");
1299
1300 if (db_num_rows($result) != 0) {
1301 return db_fetch_result($result, 0, "unread");
1302 } else {
1303 return 0;
1304 }
1305 }
1306
1307 function getFeedArticles($link, $feed, $is_cat = false, $unread_only = false,
1308 $owner_uid = false) {
1309
1310 $n_feed = (int) $feed;
1311 $need_entries = false;
1312
1313 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1314
1315 if ($unread_only) {
1316 $unread_qpart = "unread = true";
1317 } else {
1318 $unread_qpart = "true";
1319 }
1320
1321 if ($is_cat) {
1322 return getCategoryUnread($link, $n_feed, $owner_uid);
1323 } else if ($n_feed == -6) {
1324 return 0;
1325 } else if ($feed != "0" && $n_feed == 0) {
1326
1327 $feed = db_escape_string($link, $feed);
1328
1329 $result = db_query($link, "SELECT SUM((SELECT COUNT(int_id)
1330 FROM ttrss_user_entries,ttrss_entries WHERE int_id = post_int_id
1331 AND ref_id = id AND $unread_qpart)) AS count FROM ttrss_tags
1332 WHERE owner_uid = $owner_uid AND tag_name = '$feed'");
1333 return db_fetch_result($result, 0, "count");
1334
1335 } else if ($n_feed == -1) {
1336 $match_part = "marked = true";
1337 } else if ($n_feed == -2) {
1338 $match_part = "published = true";
1339 } else if ($n_feed == -3) {
1340 $match_part = "unread = true AND score >= 0";
1341
1342 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid);
1343
1344 if (DB_TYPE == "pgsql") {
1345 $match_part .= " AND updated > NOW() - INTERVAL '$intl hour' ";
1346 } else {
1347 $match_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
1348 }
1349
1350 $need_entries = true;
1351
1352 } else if ($n_feed == -4) {
1353 $match_part = "true";
1354 } else if ($n_feed >= 0) {
1355
1356 if ($n_feed != 0) {
1357 $match_part = "feed_id = '$n_feed'";
1358 } else {
1359 $match_part = "feed_id IS NULL";
1360 }
1361
1362 } else if ($feed < LABEL_BASE_INDEX) {
1363
1364 $label_id = feed_to_label_id($feed);
1365
1366 return getLabelUnread($link, $label_id, $owner_uid);
1367
1368 }
1369
1370 if ($match_part) {
1371
1372 if ($need_entries) {
1373 $from_qpart = "ttrss_user_entries,ttrss_entries";
1374 $from_where = "ttrss_entries.id = ttrss_user_entries.ref_id AND";
1375 } else {
1376 $from_qpart = "ttrss_user_entries";
1377 }
1378
1379 $query = "SELECT count(int_id) AS unread
1380 FROM $from_qpart WHERE
1381 $unread_qpart AND $from_where ($match_part) AND ttrss_user_entries.owner_uid = $owner_uid";
1382
1383 //echo "[$feed/$query]\n";
1384
1385 $result = db_query($link, $query);
1386
1387 } else {
1388
1389 $result = db_query($link, "SELECT COUNT(post_int_id) AS unread
1390 FROM ttrss_tags,ttrss_user_entries,ttrss_entries
1391 WHERE tag_name = '$feed' AND post_int_id = int_id AND ref_id = ttrss_entries.id
1392 AND $unread_qpart AND ttrss_tags.owner_uid = " . $owner_uid);
1393 }
1394
1395 $unread = db_fetch_result($result, 0, "unread");
1396
1397 return $unread;
1398 }
1399
1400 function getGlobalUnread($link, $user_id = false) {
1401
1402 if (!$user_id) {
1403 $user_id = $_SESSION["uid"];
1404 }
1405
1406 $result = db_query($link, "SELECT SUM(value) AS c_id FROM ttrss_counters_cache
1407 WHERE owner_uid = '$user_id' AND feed_id > 0");
1408
1409 $c_id = db_fetch_result($result, 0, "c_id");
1410
1411 return $c_id;
1412 }
1413
1414 function getGlobalCounters($link, $global_unread = -1) {
1415 $ret_arr = array();
1416
1417 if ($global_unread == -1) {
1418 $global_unread = getGlobalUnread($link);
1419 }
1420
1421 $cv = array("id" => "global-unread",
1422 "counter" => (int) $global_unread);
1423
1424 array_push($ret_arr, $cv);
1425
1426 $result = db_query($link, "SELECT COUNT(id) AS fn FROM
1427 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1428
1429 $subscribed_feeds = db_fetch_result($result, 0, "fn");
1430
1431 $cv = array("id" => "subscribed-feeds",
1432 "counter" => (int) $subscribed_feeds);
1433
1434 array_push($ret_arr, $cv);
1435
1436 return $ret_arr;
1437 }
1438
1439 function getVirtCounters($link) {
1440
1441 $ret_arr = array();
1442
1443 for ($i = 0; $i >= -4; $i--) {
1444
1445 $count = getFeedUnread($link, $i);
1446
1447 $cv = array("id" => $i,
1448 "counter" => (int) $count);
1449
1450 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1451 // $cv["xmsg"] = getFeedArticles($link, $i)." ".__("total");
1452
1453 array_push($ret_arr, $cv);
1454 }
1455
1456 global $pluginhost;
1457
1458 if ($pluginhost) {
1459 $feeds = $pluginhost->get_feeds(-1);
1460
1461 if (is_array($feeds)) {
1462 foreach ($feeds as $feed) {
1463 $cv = array("id" => PluginHost::pfeed_to_feed_id($feed['id']),
1464 "counter" => $feed['sender']->get_unread($feed['id']));
1465
1466 array_push($ret_arr, $cv);
1467 }
1468 }
1469 }
1470
1471 return $ret_arr;
1472 }
1473
1474 function getLabelCounters($link, $descriptions = false) {
1475
1476 $ret_arr = array();
1477
1478 $owner_uid = $_SESSION["uid"];
1479
1480 $result = db_query($link, "SELECT id,caption,COUNT(unread) AS unread
1481 FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON
1482 (ttrss_labels2.id = label_id)
1483 LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND unread = true
1484 AND ttrss_user_entries.owner_uid = $owner_uid)
1485 WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id,
1486 ttrss_labels2.caption");
1487
1488 while ($line = db_fetch_assoc($result)) {
1489
1490 $id = label_to_feed_id($line["id"]);
1491
1492 $label_name = $line["caption"];
1493 $count = $line["unread"];
1494
1495 $cv = array("id" => $id,
1496 "counter" => (int) $count);
1497
1498 if ($descriptions)
1499 $cv["description"] = $label_name;
1500
1501 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1502 // $cv["xmsg"] = getFeedArticles($link, $id)." ".__("total");
1503
1504 array_push($ret_arr, $cv);
1505 }
1506
1507 return $ret_arr;
1508 }
1509
1510 function getFeedCounters($link, $active_feed = false) {
1511
1512 $ret_arr = array();
1513
1514 $query = "SELECT ttrss_feeds.id,
1515 ttrss_feeds.title,
1516 ".SUBSTRING_FOR_DATE."(ttrss_feeds.last_updated,1,19) AS last_updated,
1517 last_error, value AS count
1518 FROM ttrss_feeds, ttrss_counters_cache
1519 WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
1520 AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
1521 AND ttrss_counters_cache.feed_id = id";
1522
1523 $result = db_query($link, $query);
1524 $fctrs_modified = false;
1525
1526 while ($line = db_fetch_assoc($result)) {
1527
1528 $id = $line["id"];
1529 $count = $line["count"];
1530 $last_error = htmlspecialchars($line["last_error"]);
1531
1532 $last_updated = make_local_datetime($link, $line['last_updated'], false);
1533
1534 $has_img = feed_has_icon($id);
1535
1536 if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2)
1537 $last_updated = '';
1538
1539 $cv = array("id" => $id,
1540 "updated" => $last_updated,
1541 "counter" => (int) $count,
1542 "has_img" => (int) $has_img);
1543
1544 if ($last_error)
1545 $cv["error"] = $last_error;
1546
1547 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1548 // $cv["xmsg"] = getFeedArticles($link, $id)." ".__("total");
1549
1550 if ($active_feed && $id == $active_feed)
1551 $cv["title"] = truncate_string($line["title"], 30);
1552
1553 array_push($ret_arr, $cv);
1554
1555 }
1556
1557 return $ret_arr;
1558 }
1559
1560 function get_pgsql_version($link) {
1561 $result = db_query($link, "SELECT version() AS version");
1562 $version = explode(" ", db_fetch_result($result, 0, "version"));
1563 return $version[1];
1564 }
1565
1566 /**
1567 * @return array (code => Status code, message => error message if available)
1568 *
1569 * 0 - OK, Feed already exists
1570 * 1 - OK, Feed added
1571 * 2 - Invalid URL
1572 * 3 - URL content is HTML, no feeds available
1573 * 4 - URL content is HTML which contains multiple feeds.
1574 * Here you should call extractfeedurls in rpc-backend
1575 * to get all possible feeds.
1576 * 5 - Couldn't download the URL content.
1577 */
1578 function subscribe_to_feed($link, $url, $cat_id = 0,
1579 $auth_login = '', $auth_pass = '') {
1580
1581 global $fetch_last_error;
1582
1583 require_once "include/rssfuncs.php";
1584
1585 $url = fix_url($url);
1586
1587 if (!$url || !validate_feed_url($url)) return array("code" => 2);
1588
1589 $contents = @fetch_file_contents($url, false, $auth_login, $auth_pass);
1590
1591 if (!$contents) {
1592 return array("code" => 5, "message" => $fetch_last_error);
1593 }
1594
1595 if (is_html($contents)) {
1596 $feedUrls = get_feeds_from_html($url, $contents);
1597
1598 if (count($feedUrls) == 0) {
1599 return array("code" => 3);
1600 } else if (count($feedUrls) > 1) {
1601 return array("code" => 4, "feeds" => $feedUrls);
1602 }
1603 //use feed url as new URL
1604 $url = key($feedUrls);
1605 }
1606
1607 if ($cat_id == "0" || !$cat_id) {
1608 $cat_qpart = "NULL";
1609 } else {
1610 $cat_qpart = "'$cat_id'";
1611 }
1612
1613 $result = db_query($link,
1614 "SELECT id FROM ttrss_feeds
1615 WHERE feed_url = '$url' AND owner_uid = ".$_SESSION["uid"]);
1616
1617 if (db_num_rows($result) == 0) {
1618 $result = db_query($link,
1619 "INSERT INTO ttrss_feeds
1620 (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method)
1621 VALUES ('".$_SESSION["uid"]."', '$url',
1622 '[Unknown]', $cat_qpart, '$auth_login', '$auth_pass', 0)");
1623
1624 $result = db_query($link,
1625 "SELECT id FROM ttrss_feeds WHERE feed_url = '$url'
1626 AND owner_uid = " . $_SESSION["uid"]);
1627
1628 $feed_id = db_fetch_result($result, 0, "id");
1629
1630 if ($feed_id) {
1631 update_rss_feed($link, $feed_id, true);
1632 }
1633
1634 return array("code" => 1);
1635 } else {
1636 return array("code" => 0);
1637 }
1638 }
1639
1640 function print_feed_select($link, $id, $default_id = "",
1641 $attributes = "", $include_all_feeds = true,
1642 $root_id = false, $nest_level = 0) {
1643
1644 if (!$root_id) {
1645 print "<select id=\"$id\" name=\"$id\" $attributes>";
1646 if ($include_all_feeds) {
1647 $is_selected = ("0" == $default_id) ? "selected=\"1\"" : "";
1648 print "<option $is_selected value=\"0\">".__('All feeds')."</option>";
1649 }
1650 }
1651
1652 if (get_pref($link, 'ENABLE_FEED_CATS')) {
1653
1654 if ($root_id)
1655 $parent_qpart = "parent_cat = '$root_id'";
1656 else
1657 $parent_qpart = "parent_cat IS NULL";
1658
1659 $result = db_query($link, "SELECT id,title,
1660 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1661 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1662 FROM ttrss_feed_categories
1663 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1664
1665 while ($line = db_fetch_assoc($result)) {
1666
1667 for ($i = 0; $i < $nest_level; $i++)
1668 $line["title"] = " - " . $line["title"];
1669
1670 $is_selected = ("CAT:".$line["id"] == $default_id) ? "selected=\"1\"" : "";
1671
1672 printf("<option $is_selected value='CAT:%d'>%s</option>",
1673 $line["id"], htmlspecialchars($line["title"]));
1674
1675 if ($line["num_children"] > 0)
1676 print_feed_select($link, $id, $default_id, $attributes,
1677 $include_all_feeds, $line["id"], $nest_level+1);
1678
1679 $feed_result = db_query($link, "SELECT id,title FROM ttrss_feeds
1680 WHERE cat_id = '".$line["id"]."' AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1681
1682 while ($fline = db_fetch_assoc($feed_result)) {
1683 $is_selected = ($fline["id"] == $default_id) ? "selected=\"1\"" : "";
1684
1685 $fline["title"] = " + " . $fline["title"];
1686
1687 for ($i = 0; $i < $nest_level; $i++)
1688 $fline["title"] = " - " . $fline["title"];
1689
1690 printf("<option $is_selected value='%d'>%s</option>",
1691 $fline["id"], htmlspecialchars($fline["title"]));
1692 }
1693 }
1694
1695 if (!$root_id) {
1696 $is_selected = ($default_id == "CAT:0") ? "selected=\"1\"" : "";
1697
1698 printf("<option $is_selected value='CAT:0'>%s</option>",
1699 __("Uncategorized"));
1700
1701 $feed_result = db_query($link, "SELECT id,title FROM ttrss_feeds
1702 WHERE cat_id IS NULL AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1703
1704 while ($fline = db_fetch_assoc($feed_result)) {
1705 $is_selected = ($fline["id"] == $default_id && !$default_is_cat) ? "selected=\"1\"" : "";
1706
1707 $fline["title"] = " + " . $fline["title"];
1708
1709 for ($i = 0; $i < $nest_level; $i++)
1710 $fline["title"] = " - " . $fline["title"];
1711
1712 printf("<option $is_selected value='%d'>%s</option>",
1713 $fline["id"], htmlspecialchars($fline["title"]));
1714 }
1715 }
1716
1717 } else {
1718 $result = db_query($link, "SELECT id,title FROM ttrss_feeds
1719 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1720
1721 while ($line = db_fetch_assoc($result)) {
1722
1723 $is_selected = ($line["id"] == $default_id) ? "selected=\"1\"" : "";
1724
1725 printf("<option $is_selected value='%d'>%s</option>",
1726 $line["id"], htmlspecialchars($line["title"]));
1727 }
1728 }
1729
1730 if (!$root_id) {
1731 print "</select>";
1732 }
1733 }
1734
1735 function print_feed_cat_select($link, $id, $default_id,
1736 $attributes, $include_all_cats = true, $root_id = false, $nest_level = 0) {
1737
1738 if (!$root_id) {
1739 print "<select id=\"$id\" name=\"$id\" default=\"$default_id\" onchange=\"catSelectOnChange(this)\" $attributes>";
1740 }
1741
1742 if ($root_id)
1743 $parent_qpart = "parent_cat = '$root_id'";
1744 else
1745 $parent_qpart = "parent_cat IS NULL";
1746
1747 $result = db_query($link, "SELECT id,title,
1748 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1749 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1750 FROM ttrss_feed_categories
1751 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1752
1753 while ($line = db_fetch_assoc($result)) {
1754 if ($line["id"] == $default_id) {
1755 $is_selected = "selected=\"1\"";
1756 } else {
1757 $is_selected = "";
1758 }
1759
1760 for ($i = 0; $i < $nest_level; $i++)
1761 $line["title"] = " - " . $line["title"];
1762
1763 if ($line["title"])
1764 printf("<option $is_selected value='%d'>%s</option>",
1765 $line["id"], htmlspecialchars($line["title"]));
1766
1767 if ($line["num_children"] > 0)
1768 print_feed_cat_select($link, $id, $default_id, $attributes,
1769 $include_all_cats, $line["id"], $nest_level+1);
1770 }
1771
1772 if (!$root_id) {
1773 if ($include_all_cats) {
1774 if (db_num_rows($result) > 0) {
1775 print "<option disabled=\"1\">--------</option>";
1776 }
1777
1778 if ($default_id == 0) {
1779 $is_selected = "selected=\"1\"";
1780 } else {
1781 $is_selected = "";
1782 }
1783
1784 print "<option $is_selected value=\"0\">".__('Uncategorized')."</option>";
1785 }
1786 print "</select>";
1787 }
1788 }
1789
1790 function checkbox_to_sql_bool($val) {
1791 return ($val == "on") ? "true" : "false";
1792 }
1793
1794 function getFeedCatTitle($link, $id) {
1795 if ($id == -1) {
1796 return __("Special");
1797 } else if ($id < LABEL_BASE_INDEX) {
1798 return __("Labels");
1799 } else if ($id > 0) {
1800 $result = db_query($link, "SELECT ttrss_feed_categories.title
1801 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1802 cat_id = ttrss_feed_categories.id");
1803 if (db_num_rows($result) == 1) {
1804 return db_fetch_result($result, 0, "title");
1805 } else {
1806 return __("Uncategorized");
1807 }
1808 } else {
1809 return "getFeedCatTitle($id) failed";
1810 }
1811
1812 }
1813
1814 function getFeedIcon($id) {
1815 switch ($id) {
1816 case 0:
1817 return "images/archive.png";
1818 break;
1819 case -1:
1820 return "images/mark_set.svg";
1821 break;
1822 case -2:
1823 return "images/pub_set.svg";
1824 break;
1825 case -3:
1826 return "images/fresh.png";
1827 break;
1828 case -4:
1829 return "images/tag.png";
1830 break;
1831 case -6:
1832 return "images/recently_read.png";
1833 break;
1834 default:
1835 if ($id < LABEL_BASE_INDEX) {
1836 return "images/label.png";
1837 } else {
1838 if (file_exists(ICONS_DIR . "/$id.ico"))
1839 return ICONS_URL . "/$id.ico";
1840 }
1841 break;
1842 }
1843 }
1844
1845 function getFeedTitle($link, $id, $cat = false) {
1846 if ($cat) {
1847 return getCategoryTitle($link, $id);
1848 } else if ($id == -1) {
1849 return __("Starred articles");
1850 } else if ($id == -2) {
1851 return __("Published articles");
1852 } else if ($id == -3) {
1853 return __("Fresh articles");
1854 } else if ($id == -4) {
1855 return __("All articles");
1856 } else if ($id === 0 || $id === "0") {
1857 return __("Archived articles");
1858 } else if ($id == -6) {
1859 return __("Recently read");
1860 } else if ($id < LABEL_BASE_INDEX) {
1861 $label_id = feed_to_label_id($id);
1862 $result = db_query($link, "SELECT caption FROM ttrss_labels2 WHERE id = '$label_id'");
1863 if (db_num_rows($result) == 1) {
1864 return db_fetch_result($result, 0, "caption");
1865 } else {
1866 return "Unknown label ($label_id)";
1867 }
1868
1869 } else if (is_numeric($id) && $id > 0) {
1870 $result = db_query($link, "SELECT title FROM ttrss_feeds WHERE id = '$id'");
1871 if (db_num_rows($result) == 1) {
1872 return db_fetch_result($result, 0, "title");
1873 } else {
1874 return "Unknown feed ($id)";
1875 }
1876 } else {
1877 return $id;
1878 }
1879 }
1880
1881 function make_init_params($link) {
1882 $params = array();
1883
1884 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
1885 "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
1886 "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
1887 "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
1888
1889 $params[strtolower($param)] = (int) get_pref($link, $param);
1890 }
1891
1892 $params["icons_url"] = ICONS_URL;
1893 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
1894 $params["default_view_mode"] = get_pref($link, "_DEFAULT_VIEW_MODE");
1895 $params["default_view_limit"] = (int) get_pref($link, "_DEFAULT_VIEW_LIMIT");
1896 $params["default_view_order_by"] = get_pref($link, "_DEFAULT_VIEW_ORDER_BY");
1897 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
1898 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
1899
1900 $result = db_query($link, "SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
1901 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1902
1903 $max_feed_id = db_fetch_result($result, 0, "mid");
1904 $num_feeds = db_fetch_result($result, 0, "nf");
1905
1906 $params["max_feed_id"] = (int) $max_feed_id;
1907 $params["num_feeds"] = (int) $num_feeds;
1908
1909 $params["collapsed_feedlist"] = (int) get_pref($link, "_COLLAPSED_FEEDLIST");
1910 $params["hotkeys"] = get_hotkeys_map($link);
1911
1912 $params["csrf_token"] = $_SESSION["csrf_token"];
1913 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
1914
1915 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
1916
1917 return $params;
1918 }
1919
1920 function get_hotkeys_info($link) {
1921 $hotkeys = array(
1922 __("Navigation") => array(
1923 "next_feed" => __("Open next feed"),
1924 "prev_feed" => __("Open previous feed"),
1925 "next_article" => __("Open next article"),
1926 "prev_article" => __("Open previous article"),
1927 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
1928 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
1929 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
1930 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
1931 "search_dialog" => __("Show search dialog")),
1932 __("Article") => array(
1933 "toggle_mark" => __("Toggle starred"),
1934 "toggle_publ" => __("Toggle published"),
1935 "toggle_unread" => __("Toggle unread"),
1936 "edit_tags" => __("Edit tags"),
1937 "dismiss_selected" => __("Dismiss selected"),
1938 "dismiss_read" => __("Dismiss read"),
1939 "open_in_new_window" => __("Open in new window"),
1940 "catchup_below" => __("Mark below as read"),
1941 "catchup_above" => __("Mark above as read"),
1942 "article_scroll_down" => __("Scroll down"),
1943 "article_scroll_up" => __("Scroll up"),
1944 "select_article_cursor" => __("Select article under cursor"),
1945 "email_article" => __("Email article"),
1946 "close_article" => __("Close/collapse article"),
1947 "toggle_expand" => __("Toggle article expansion (combined mode)"),
1948 "toggle_widescreen" => __("Toggle widescreen mode"),
1949 "toggle_embed_original" => __("Toggle embed original")),
1950 __("Article selection") => array(
1951 "select_all" => __("Select all articles"),
1952 "select_unread" => __("Select unread"),
1953 "select_marked" => __("Select starred"),
1954 "select_published" => __("Select published"),
1955 "select_invert" => __("Invert selection"),
1956 "select_none" => __("Deselect everything")),
1957 __("Feed") => array(
1958 "feed_refresh" => __("Refresh current feed"),
1959 "feed_unhide_read" => __("Un/hide read feeds"),
1960 "feed_subscribe" => __("Subscribe to feed"),
1961 "feed_edit" => __("Edit feed"),
1962 "feed_catchup" => __("Mark as read"),
1963 "feed_reverse" => __("Reverse headlines"),
1964 "feed_debug_update" => __("Debug feed update"),
1965 "catchup_all" => __("Mark all feeds as read"),
1966 "cat_toggle_collapse" => __("Un/collapse current category"),
1967 "toggle_combined_mode" => __("Toggle combined mode"),
1968 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
1969 __("Go to") => array(
1970 "goto_all" => __("All articles"),
1971 "goto_fresh" => __("Fresh"),
1972 "goto_marked" => __("Starred"),
1973 "goto_published" => __("Published"),
1974 "goto_tagcloud" => __("Tag cloud"),
1975 "goto_prefs" => __("Preferences")),
1976 __("Other") => array(
1977 "create_label" => __("Create label"),
1978 "create_filter" => __("Create filter"),
1979 "collapse_sidebar" => __("Un/collapse sidebar"),
1980 "help_dialog" => __("Show help dialog"))
1981 );
1982
1983 global $pluginhost;
1984 foreach ($pluginhost->get_hooks($pluginhost::HOOK_HOTKEY_INFO) as $plugin) {
1985 $hotkeys = $plugin->hook_hotkey_info($hotkeys);
1986 }
1987
1988 return $hotkeys;
1989 }
1990
1991 function get_hotkeys_map($link) {
1992 $hotkeys = array(
1993 // "navigation" => array(
1994 "k" => "next_feed",
1995 "j" => "prev_feed",
1996 "n" => "next_article",
1997 "p" => "prev_article",
1998 "(38)|up" => "prev_article",
1999 "(40)|down" => "next_article",
2000 // "^(38)|Ctrl-up" => "prev_article_noscroll",
2001 // "^(40)|Ctrl-down" => "next_article_noscroll",
2002 "(191)|/" => "search_dialog",
2003 // "article" => array(
2004 "s" => "toggle_mark",
2005 "*s" => "toggle_publ",
2006 "u" => "toggle_unread",
2007 "*t" => "edit_tags",
2008 "*d" => "dismiss_selected",
2009 "*x" => "dismiss_read",
2010 "o" => "open_in_new_window",
2011 "c p" => "catchup_below",
2012 "c n" => "catchup_above",
2013 "*n" => "article_scroll_down",
2014 "*p" => "article_scroll_up",
2015 "*(38)|Shift+up" => "article_scroll_up",
2016 "*(40)|Shift+down" => "article_scroll_down",
2017 "a *w" => "toggle_widescreen",
2018 "a e" => "toggle_embed_original",
2019 "e" => "email_article",
2020 "a q" => "close_article",
2021 // "article_selection" => array(
2022 "a a" => "select_all",
2023 "a u" => "select_unread",
2024 "a *u" => "select_marked",
2025 "a p" => "select_published",
2026 "a i" => "select_invert",
2027 "a n" => "select_none",
2028 // "feed" => array(
2029 "f r" => "feed_refresh",
2030 "f a" => "feed_unhide_read",
2031 "f s" => "feed_subscribe",
2032 "f e" => "feed_edit",
2033 "f q" => "feed_catchup",
2034 "f x" => "feed_reverse",
2035 "f *d" => "feed_debug_update",
2036 "f *c" => "toggle_combined_mode",
2037 "f c" => "toggle_cdm_expanded",
2038 "*q" => "catchup_all",
2039 "x" => "cat_toggle_collapse",
2040 // "goto" => array(
2041 "g a" => "goto_all",
2042 "g f" => "goto_fresh",
2043 "g s" => "goto_marked",
2044 "g p" => "goto_published",
2045 "g t" => "goto_tagcloud",
2046 "g *p" => "goto_prefs",
2047 // "other" => array(
2048 "(9)|Tab" => "select_article_cursor", // tab
2049 "c l" => "create_label",
2050 "c f" => "create_filter",
2051 "c s" => "collapse_sidebar",
2052 "^(191)|Ctrl+/" => "help_dialog",
2053 );
2054
2055 if (get_pref($link, 'COMBINED_DISPLAY_MODE')) {
2056 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
2057 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
2058 }
2059
2060 global $pluginhost;
2061 foreach ($pluginhost->get_hooks($pluginhost::HOOK_HOTKEY_MAP) as $plugin) {
2062 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
2063 }
2064
2065 $prefixes = array();
2066
2067 foreach (array_keys($hotkeys) as $hotkey) {
2068 $pair = explode(" ", $hotkey, 2);
2069
2070 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
2071 array_push($prefixes, $pair[0]);
2072 }
2073 }
2074
2075 return array($prefixes, $hotkeys);
2076 }
2077
2078 function make_runtime_info($link) {
2079 $data = array();
2080
2081 $result = db_query($link, "SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2082 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2083
2084 $max_feed_id = db_fetch_result($result, 0, "mid");
2085 $num_feeds = db_fetch_result($result, 0, "nf");
2086
2087 $data["max_feed_id"] = (int) $max_feed_id;
2088 $data["num_feeds"] = (int) $num_feeds;
2089
2090 $data['last_article_id'] = getLastArticleId($link);
2091 $data['cdm_expanded'] = get_pref($link, 'CDM_EXPANDED');
2092
2093 $data['dep_ts'] = calculate_dep_timestamp();
2094 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
2095
2096 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
2097
2098 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
2099
2100 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
2101
2102 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
2103
2104 if ($stamp) {
2105 $stamp_delta = time() - $stamp;
2106
2107 if ($stamp_delta > 1800) {
2108 $stamp_check = 0;
2109 } else {
2110 $stamp_check = 1;
2111 $_SESSION["daemon_stamp_check"] = time();
2112 }
2113
2114 $data['daemon_stamp_ok'] = $stamp_check;
2115
2116 $stamp_fmt = date("Y.m.d, G:i", $stamp);
2117
2118 $data['daemon_stamp'] = $stamp_fmt;
2119 }
2120 }
2121 }
2122
2123 if ($_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
2124 $new_version_details = @check_for_update($link);
2125
2126 $data['new_version_available'] = (int) ($new_version_details != false);
2127
2128 $_SESSION["last_version_check"] = time();
2129 $_SESSION["version_data"] = $new_version_details;
2130 }
2131
2132 return $data;
2133 }
2134
2135 function search_to_sql($link, $search) {
2136
2137 $search_query_part = "";
2138
2139 $keywords = explode(" ", $search);
2140 $query_keywords = array();
2141
2142 foreach ($keywords as $k) {
2143 if (strpos($k, "-") === 0) {
2144 $k = substr($k, 1);
2145 $not = "NOT";
2146 } else {
2147 $not = "";
2148 }
2149
2150 $commandpair = explode(":", mb_strtolower($k), 2);
2151
2152 switch ($commandpair[0]) {
2153 case "title":
2154 if ($commandpair[1]) {
2155 array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
2156 db_escape_string($link, mb_strtolower($commandpair[1]))."%'))");
2157 } else {
2158 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2159 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2160 }
2161 break;
2162 case "author":
2163 if ($commandpair[1]) {
2164 array_push($query_keywords, "($not (LOWER(author) LIKE '%".
2165 db_escape_string($link, mb_strtolower($commandpair[1]))."%'))");
2166 } else {
2167 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2168 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2169 }
2170 break;
2171 case "note":
2172 if ($commandpair[1]) {
2173 if ($commandpair[1] == "true")
2174 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
2175 else if ($commandpair[1] == "false")
2176 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
2177 else
2178 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
2179 db_escape_string($link, mb_strtolower($commandpair[1]))."%'))");
2180 } else {
2181 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2182 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2183 }
2184 break;
2185 case "star":
2186
2187 if ($commandpair[1]) {
2188 if ($commandpair[1] == "true")
2189 array_push($query_keywords, "($not (marked = true))");
2190 else
2191 array_push($query_keywords, "($not (marked = false))");
2192 } else {
2193 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2194 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2195 }
2196 break;
2197 case "pub":
2198 if ($commandpair[1]) {
2199 if ($commandpair[1] == "true")
2200 array_push($query_keywords, "($not (published = true))");
2201 else
2202 array_push($query_keywords, "($not (published = false))");
2203
2204 } else {
2205 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2206 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2207 }
2208 break;
2209 default:
2210 if (strpos($k, "@") === 0) {
2211
2212 $user_tz_string = get_pref($link, 'USER_TIMEZONE', $_SESSION['uid']);
2213 $orig_ts = strtotime(substr($k, 1));
2214 $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
2215
2216 //$k = date("Y-m-d", strtotime(substr($k, 1)));
2217
2218 array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
2219 } else {
2220 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2221 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2222 }
2223 }
2224 }
2225
2226 $search_query_part = implode("AND", $query_keywords);
2227
2228 return $search_query_part;
2229 }
2230
2231 function getParentCategories($link, $cat, $owner_uid) {
2232 $rv = array();
2233
2234 $result = db_query($link, "SELECT parent_cat FROM ttrss_feed_categories
2235 WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
2236
2237 while ($line = db_fetch_assoc($result)) {
2238 array_push($rv, $line["parent_cat"]);
2239 $rv = array_merge($rv, getParentCategories($link, $line["parent_cat"], $owner_uid));
2240 }
2241
2242 return $rv;
2243 }
2244
2245 function getChildCategories($link, $cat, $owner_uid) {
2246 $rv = array();
2247
2248 $result = db_query($link, "SELECT id FROM ttrss_feed_categories
2249 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
2250
2251 while ($line = db_fetch_assoc($result)) {
2252 array_push($rv, $line["id"]);
2253 $rv = array_merge($rv, getChildCategories($link, $line["id"], $owner_uid));
2254 }
2255
2256 return $rv;
2257 }
2258
2259 function queryFeedHeadlines($link, $feed, $limit, $view_mode, $cat_view, $search, $search_mode, $override_order = false, $offset = 0, $owner_uid = 0, $filter = false, $since_id = 0, $include_children = false, $ignore_vfeed_group = false) {
2260
2261 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2262
2263 $ext_tables_part = "";
2264
2265 if ($search) {
2266
2267 if (SPHINX_ENABLED) {
2268 $ids = join(",", @sphinx_search($search, 0, 500));
2269
2270 if ($ids)
2271 $search_query_part = "ref_id IN ($ids) AND ";
2272 else
2273 $search_query_part = "ref_id = -1 AND ";
2274
2275 } else {
2276 $search_query_part = search_to_sql($link, $search);
2277 $search_query_part .= " AND ";
2278 }
2279
2280 } else {
2281 $search_query_part = "";
2282 }
2283
2284 if ($filter) {
2285
2286 if (DB_TYPE == "pgsql") {
2287 $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
2288 } else {
2289 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
2290 }
2291
2292 $override_order = "updated DESC";
2293
2294 $filter_query_part = filter_to_sql($link, $filter, $owner_uid);
2295
2296 // Try to check if SQL regexp implementation chokes on a valid regexp
2297 $result = db_query($link, "SELECT true AS true_val FROM ttrss_entries,
2298 ttrss_user_entries, ttrss_feeds, ttrss_feed_categories
2299 WHERE $filter_query_part LIMIT 1", false);
2300
2301 if ($result) {
2302 $test = db_fetch_result($result, 0, "true_val");
2303
2304 if (!$test) {
2305 $filter_query_part = "false AND";
2306 } else {
2307 $filter_query_part .= " AND";
2308 }
2309 } else {
2310 $filter_query_part = "false AND";
2311 }
2312
2313 } else {
2314 $filter_query_part = "";
2315 }
2316
2317 if ($since_id) {
2318 $since_id_part = "ttrss_entries.id > $since_id AND ";
2319 } else {
2320 $since_id_part = "";
2321 }
2322
2323 $view_query_part = "";
2324
2325 if ($view_mode == "adaptive") {
2326 if ($search) {
2327 $view_query_part = " ";
2328 } else if ($feed != -1) {
2329
2330 $unread = getFeedUnread($link, $feed, $cat_view);
2331
2332 if ($cat_view && $feed > 0 && $include_children)
2333 $unread += getCategoryChildrenUnread($link, $feed);
2334
2335 if ($unread > 0)
2336 $view_query_part = " unread = true AND ";
2337
2338 }
2339 }
2340
2341 if ($view_mode == "marked") {
2342 $view_query_part = " marked = true AND ";
2343 }
2344
2345 if ($view_mode == "has_note") {
2346 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
2347 }
2348
2349 if ($view_mode == "published") {
2350 $view_query_part = " published = true AND ";
2351 }
2352
2353 if ($view_mode == "unread" && $feed != -6) {
2354 $view_query_part = " unread = true AND ";
2355 }
2356
2357 if ($limit > 0) {
2358 $limit_query_part = "LIMIT " . $limit;
2359 }
2360
2361 $allow_archived = false;
2362
2363 $vfeed_query_part = "";
2364
2365 // override query strategy and enable feed display when searching globally
2366 if ($search && $search_mode == "all_feeds") {
2367 $query_strategy_part = "true";
2368 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2369 /* tags */
2370 } else if (!is_numeric($feed)) {
2371 $query_strategy_part = "true";
2372 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2373 id = feed_id) as feed_title,";
2374 } else if ($search && $search_mode == "this_cat") {
2375 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2376
2377 if ($feed > 0) {
2378 if ($include_children) {
2379 $subcats = getChildCategories($link, $feed, $owner_uid);
2380 array_push($subcats, $feed);
2381 $cats_qpart = join(",", $subcats);
2382 } else {
2383 $cats_qpart = $feed;
2384 }
2385
2386 $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
2387
2388 } else {
2389 $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
2390 }
2391
2392 } else if ($feed > 0) {
2393
2394 if ($cat_view) {
2395
2396 if ($feed > 0) {
2397 if ($include_children) {
2398 # sub-cats
2399 $subcats = getChildCategories($link, $feed, $owner_uid);
2400
2401 array_push($subcats, $feed);
2402 $query_strategy_part = "cat_id IN (".
2403 implode(",", $subcats).")";
2404
2405 } else {
2406 $query_strategy_part = "cat_id = '$feed'";
2407 }
2408
2409 } else {
2410 $query_strategy_part = "cat_id IS NULL";
2411 }
2412
2413 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2414
2415 } else {
2416 $query_strategy_part = "feed_id = '$feed'";
2417 }
2418 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
2419 $query_strategy_part = "feed_id IS NULL";
2420 $allow_archived = true;
2421 } else if ($feed == 0 && $cat_view) { // uncategorized
2422 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
2423 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2424 } else if ($feed == -1) { // starred virtual feed
2425 $query_strategy_part = "marked = true";
2426 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2427 $allow_archived = true;
2428
2429 if (!$override_order) {
2430 $override_order = "last_marked DESC, date_entered DESC, updated DESC";
2431 }
2432
2433 } else if ($feed == -2) { // published virtual feed OR labels category
2434
2435 if (!$cat_view) {
2436 $query_strategy_part = "published = true";
2437 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2438 $allow_archived = true;
2439
2440 if (!$override_order) {
2441 $override_order = "last_published DESC, date_entered DESC, updated DESC";
2442 }
2443
2444 } else {
2445 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2446
2447 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2448
2449 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
2450 ttrss_user_labels2.article_id = ref_id";
2451
2452 }
2453 } else if ($feed == -6) { // recently read
2454 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
2455 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2456 $allow_archived = true;
2457
2458 if (!$override_order) $override_order = "last_read DESC";
2459 } else if ($feed == -3) { // fresh virtual feed
2460 $query_strategy_part = "unread = true AND score >= 0";
2461
2462 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid);
2463
2464 if (DB_TYPE == "pgsql") {
2465 $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
2466 } else {
2467 $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
2468 }
2469
2470 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2471 } else if ($feed == -4) { // all articles virtual feed
2472 $allow_archived = true;
2473 $query_strategy_part = "true";
2474 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2475 } else if ($feed <= LABEL_BASE_INDEX) { // labels
2476 $label_id = feed_to_label_id($feed);
2477
2478 $query_strategy_part = "label_id = '$label_id' AND
2479 ttrss_labels2.id = ttrss_user_labels2.label_id AND
2480 ttrss_user_labels2.article_id = ref_id";
2481
2482 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2483 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2484 $allow_archived = true;
2485
2486 } else {
2487 $query_strategy_part = "true";
2488 }
2489
2490 $order_by = "score DESC, date_entered DESC, updated DESC";
2491
2492 if ($view_mode == "unread_first") {
2493 $order_by = "unread DESC, $order_by";
2494 }
2495
2496 if ($override_order) {
2497 $order_by = $override_order;
2498 }
2499
2500 $feed_title = "";
2501
2502 if ($search) {
2503 $feed_title = T_sprintf("Search results: %s", $search);
2504 } else {
2505 if ($cat_view) {
2506 $feed_title = getCategoryTitle($link, $feed);
2507 } else {
2508 if (is_numeric($feed) && $feed > 0) {
2509 $result = db_query($link, "SELECT title,site_url,last_error
2510 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
2511
2512 $feed_title = db_fetch_result($result, 0, "title");
2513 $feed_site_url = db_fetch_result($result, 0, "site_url");
2514 $last_error = db_fetch_result($result, 0, "last_error");
2515 } else {
2516 $feed_title = getFeedTitle($link, $feed);
2517 }
2518 }
2519 }
2520
2521 $content_query_part = "content as content_preview, cached_content, ";
2522
2523 if (is_numeric($feed)) {
2524
2525 if ($feed >= 0) {
2526 $feed_kind = "Feeds";
2527 } else {
2528 $feed_kind = "Labels";
2529 }
2530
2531 if ($limit_query_part) {
2532 $offset_query_part = "OFFSET $offset";
2533 }
2534
2535 // proper override_order applied above
2536 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref($link, 'VFEED_GROUP_BY_FEED', $owner_uid)) {
2537 if (!$override_order) {
2538 $order_by = "ttrss_feeds.title, $order_by";
2539 } else {
2540 $order_by = "ttrss_feeds.title, $override_order";
2541 }
2542 }
2543
2544 if (!$allow_archived) {
2545 $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
2546 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
2547
2548 } else {
2549 $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
2550 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
2551 }
2552
2553 $query = "SELECT DISTINCT
2554 date_entered,
2555 guid,
2556 ttrss_entries.id,ttrss_entries.title,
2557 updated,
2558 label_cache,
2559 tag_cache,
2560 always_display_enclosures,
2561 site_url,
2562 note,
2563 num_comments,
2564 comments,
2565 int_id,
2566 hide_images,
2567 unread,feed_id,marked,published,link,last_read,orig_feed_id,
2568 last_marked, last_published,
2569 $vfeed_query_part
2570 $content_query_part
2571 author,score
2572 FROM
2573 $from_qpart
2574 WHERE
2575 $feed_check_qpart
2576 ttrss_user_entries.ref_id = ttrss_entries.id AND
2577 ttrss_user_entries.owner_uid = '$owner_uid' AND
2578 $search_query_part
2579 $filter_query_part
2580 $view_query_part
2581 $since_id_part
2582 $query_strategy_part ORDER BY $order_by
2583 $limit_query_part $offset_query_part";
2584
2585 if ($_REQUEST["debug"]) print $query;
2586
2587 $result = db_query($link, $query);
2588
2589 } else {
2590 // browsing by tag
2591
2592 $select_qpart = "SELECT DISTINCT " .
2593 "date_entered," .
2594 "guid," .
2595 "note," .
2596 "ttrss_entries.id as id," .
2597 "title," .
2598 "updated," .
2599 "unread," .
2600 "feed_id," .
2601 "orig_feed_id," .
2602 "marked," .
2603 "num_comments, " .
2604 "comments, " .
2605 "tag_cache," .
2606 "label_cache," .
2607 "link," .
2608 "last_read," .
2609 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
2610 "last_marked, last_published, " .
2611 $since_id_part .
2612 $vfeed_query_part .
2613 $content_query_part .
2614 "score ";
2615
2616 $feed_kind = "Tags";
2617 $all_tags = explode(",", $feed);
2618 if ($search_mode == 'any') {
2619 $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
2620 $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
2621 $where_qpart = " WHERE " .
2622 "ref_id = ttrss_entries.id AND " .
2623 "ttrss_user_entries.owner_uid = $owner_uid AND " .
2624 "post_int_id = int_id AND $tag_sql AND " .
2625 $view_query_part .
2626 $search_query_part .
2627 $query_strategy_part . " ORDER BY $order_by " .
2628 $limit_query_part;
2629
2630 } else {
2631 $i = 1;
2632 $sub_selects = array();
2633 $sub_ands = array();
2634 foreach ($all_tags as $term) {
2635 array_push($sub_selects, "(SELECT post_int_id from ttrss_tags WHERE tag_name = " . db_quote($term) . " AND owner_uid = $owner_uid) as A$i");
2636 $i++;
2637 }
2638 if ($i > 2) {
2639 $x = 1;
2640 $y = 2;
2641 do {
2642 array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
2643 $x++;
2644 $y++;
2645 } while ($y < $i);
2646 }
2647 array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
2648 array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
2649 $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
2650 $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
2651 }
2652 // error_log("TAG SQL: " . $tag_sql);
2653 // $tag_sql = "tag_name = '$feed'"; DEFAULT way
2654
2655 // error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
2656 $result = db_query($link, $select_qpart . $from_qpart . $where_qpart);
2657 }
2658
2659 return array($result, $feed_title, $feed_site_url, $last_error);
2660
2661 }
2662
2663 function sanitize($link, $str, $force_remove_images = false, $owner = false, $site_url = false) {
2664 if (!$owner) $owner = $_SESSION["uid"];
2665
2666 $res = trim($str); if (!$res) return '';
2667
2668 if (strpos($res, "href=") === false)
2669 $res = rewrite_urls($res);
2670
2671 $charset_hack = '<head>
2672 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
2673 </head>';
2674
2675 $res = trim($res); if (!$res) return '';
2676
2677 libxml_use_internal_errors(true);
2678
2679 $doc = new DOMDocument();
2680 $doc->loadHTML($charset_hack . $res);
2681 $xpath = new DOMXPath($doc);
2682
2683 $entries = $xpath->query('(//a[@href]|//img[@src])');
2684
2685 foreach ($entries as $entry) {
2686
2687 if ($site_url) {
2688
2689 if ($entry->hasAttribute('href'))
2690 $entry->setAttribute('href',
2691 rewrite_relative_url($site_url, $entry->getAttribute('href')));
2692
2693 if ($entry->hasAttribute('src')) {
2694 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
2695
2696 $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
2697
2698 if (file_exists($cached_filename)) {
2699 $src = SELF_URL_PATH . '/image.php?hash=' . sha1($src);
2700 }
2701
2702 $entry->setAttribute('src', $src);
2703 }
2704
2705 if ($entry->nodeName == 'img') {
2706 if (($owner && get_pref($link, "STRIP_IMAGES", $owner)) ||
2707 $force_remove_images || $_SESSION["bw_limit"]) {
2708
2709 $p = $doc->createElement('p');
2710
2711 $a = $doc->createElement('a');
2712 $a->setAttribute('href', $entry->getAttribute('src'));
2713
2714 $a->appendChild(new DOMText($entry->getAttribute('src')));
2715 $a->setAttribute('target', '_blank');
2716
2717 $p->appendChild($a);
2718
2719 $entry->parentNode->replaceChild($p, $entry);
2720 }
2721 }
2722 }
2723
2724 if (strtolower($entry->nodeName) == "a") {
2725 $entry->setAttribute("target", "_blank");
2726 }
2727 }
2728
2729 $entries = $xpath->query('//iframe');
2730 foreach ($entries as $entry) {
2731 $entry->setAttribute('sandbox', 'allow-scripts');
2732
2733 }
2734
2735 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
2736 'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
2737 'caption', 'cite', 'center', 'code', 'col', 'colgroup',
2738 'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
2739 'dt', 'em', 'footer', 'figure', 'figcaption',
2740 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
2741 'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
2742 'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
2743 'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
2744 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
2745 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
2746
2747 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
2748
2749 $disallowed_attributes = array('id', 'style', 'class');
2750
2751 global $pluginhost;
2752
2753 if (isset($pluginhost)) {
2754 foreach ($pluginhost->get_hooks($pluginhost::HOOK_SANITIZE) as $plugin) {
2755 $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes);
2756 if (is_array($retval)) {
2757 $doc = $retval[0];
2758 $allowed_elements = $retval[1];
2759 $disallowed_attributes = $retval[2];
2760 } else {
2761 $doc = $retval;
2762 }
2763 }
2764 }
2765
2766 $doc->removeChild($doc->firstChild); //remove doctype
2767 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
2768 $res = $doc->saveHTML();
2769 return $res;
2770 }
2771
2772 function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
2773 $entries = $doc->getElementsByTagName("*");
2774
2775 foreach ($entries as $entry) {
2776 if (!in_array($entry->nodeName, $allowed_elements)) {
2777 $entry->parentNode->removeChild($entry);
2778 }
2779
2780 if ($entry->hasAttributes()) {
2781 $attrs_to_remove = array();
2782
2783 foreach ($entry->attributes as $attr) {
2784
2785 if (strpos($attr->nodeName, 'on') === 0) {
2786 array_push($attrs_to_remove, $attr);
2787 }
2788
2789 if (in_array($attr->nodeName, $disallowed_attributes)) {
2790 array_push($attrs_to_remove, $attr);
2791 }
2792 }
2793
2794 foreach ($attrs_to_remove as $attr) {
2795 $entry->removeAttributeNode($attr);
2796 }
2797 }
2798 }
2799
2800 return $doc;
2801 }
2802
2803 function check_for_update($link) {
2804 if (CHECK_FOR_NEW_VERSION && $_SESSION['access_level'] >= 10) {
2805 $version_url = "http://tt-rss.org/version.php?ver=" . VERSION .
2806 "&iid=" . sha1(SELF_URL_PATH);
2807
2808 $version_data = @fetch_file_contents($version_url);
2809
2810 if ($version_data) {
2811 $version_data = json_decode($version_data, true);
2812 if ($version_data && $version_data['version']) {
2813
2814 if (version_compare(VERSION, $version_data['version']) == -1) {
2815 return $version_data;
2816 }
2817 }
2818 }
2819 }
2820 return false;
2821 }
2822
2823 function catchupArticlesById($link, $ids, $cmode, $owner_uid = false) {
2824
2825 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2826 if (count($ids) == 0) return;
2827
2828 $tmp_ids = array();
2829
2830 foreach ($ids as $id) {
2831 array_push($tmp_ids, "ref_id = '$id'");
2832 }
2833
2834 $ids_qpart = join(" OR ", $tmp_ids);
2835
2836 if ($cmode == 0) {
2837 db_query($link, "UPDATE ttrss_user_entries SET
2838 unread = false,last_read = NOW()
2839 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2840 } else if ($cmode == 1) {
2841 db_query($link, "UPDATE ttrss_user_entries SET
2842 unread = true
2843 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2844 } else {
2845 db_query($link, "UPDATE ttrss_user_entries SET
2846 unread = NOT unread,last_read = NOW()
2847 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2848 }
2849
2850 /* update ccache */
2851
2852 $result = db_query($link, "SELECT DISTINCT feed_id FROM ttrss_user_entries
2853 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2854
2855 while ($line = db_fetch_assoc($result)) {
2856 ccache_update($link, $line["feed_id"], $owner_uid);
2857 }
2858 }
2859
2860 function get_article_tags($link, $id, $owner_uid = 0, $tag_cache = false) {
2861
2862 $a_id = db_escape_string($link, $id);
2863
2864 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2865
2866 $query = "SELECT DISTINCT tag_name,
2867 owner_uid as owner FROM
2868 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
2869 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
2870
2871 $obj_id = md5("TAGS:$owner_uid:$id");
2872 $tags = array();
2873
2874 /* check cache first */
2875
2876 if ($tag_cache === false) {
2877 $result = db_query($link, "SELECT tag_cache FROM ttrss_user_entries
2878 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
2879
2880 $tag_cache = db_fetch_result($result, 0, "tag_cache");
2881 }
2882
2883 if ($tag_cache) {
2884 $tags = explode(",", $tag_cache);
2885 } else {
2886
2887 /* do it the hard way */
2888
2889 $tmp_result = db_query($link, $query);
2890
2891 while ($tmp_line = db_fetch_assoc($tmp_result)) {
2892 array_push($tags, $tmp_line["tag_name"]);
2893 }
2894
2895 /* update the cache */
2896
2897 $tags_str = db_escape_string($link, join(",", $tags));
2898
2899 db_query($link, "UPDATE ttrss_user_entries
2900 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
2901 AND owner_uid = $owner_uid");
2902 }
2903
2904 return $tags;
2905 }
2906
2907 function trim_array($array) {
2908 $tmp = $array;
2909 array_walk($tmp, 'trim');
2910 return $tmp;
2911 }
2912
2913 function tag_is_valid($tag) {
2914 if ($tag == '') return false;
2915 if (preg_match("/^[0-9]*$/", $tag)) return false;
2916 if (mb_strlen($tag) > 250) return false;
2917
2918 if (function_exists('iconv')) {
2919 $tag = iconv("utf-8", "utf-8", $tag);
2920 }
2921
2922 if (!$tag) return false;
2923
2924 return true;
2925 }
2926
2927 function render_login_form($link) {
2928 require_once "login_form.php";
2929 exit;
2930 }
2931
2932 // from http://developer.apple.com/internet/safari/faq.html
2933 function no_cache_incantation() {
2934 header("Expires: Mon, 22 Dec 1980 00:00:00 GMT"); // Happy birthday to me :)
2935 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
2936 header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); // HTTP/1.1
2937 header("Cache-Control: post-check=0, pre-check=0", false);
2938 header("Pragma: no-cache"); // HTTP/1.0
2939 }
2940
2941 function format_warning($msg, $id = "") {
2942 global $link;
2943 return "<div class=\"warning\" id=\"$id\">
2944 <img src=\"images/sign_excl.svg\"><div class='inner'>$msg</div></div>";
2945 }
2946
2947 function format_notice($msg, $id = "") {
2948 global $link;
2949 return "<div class=\"notice\" id=\"$id\">
2950 <img src=\"images/sign_info.svg\"><div class='inner'>$msg</div></div>";
2951 }
2952
2953 function format_error($msg, $id = "") {
2954 global $link;
2955 return "<div class=\"error\" id=\"$id\">
2956 <img src=\"images/sign_excl.svg\"><div class='inner'>$msg</div></div>";
2957 }
2958
2959 function print_notice($msg) {
2960 return print format_notice($msg);
2961 }
2962
2963 function print_warning($msg) {
2964 return print format_warning($msg);
2965 }
2966
2967 function print_error($msg) {
2968 return print format_error($msg);
2969 }
2970
2971
2972 function T_sprintf() {
2973 $args = func_get_args();
2974 return vsprintf(__(array_shift($args)), $args);
2975 }
2976
2977 function format_inline_player($link, $url, $ctype) {
2978
2979 $entry = "";
2980
2981 $url = htmlspecialchars($url);
2982
2983 if (strpos($ctype, "audio/") === 0) {
2984
2985 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
2986 strpos($_SERVER['HTTP_USER_AGENT'], "Chrome") !== false ||
2987 strpos($_SERVER['HTTP_USER_AGENT'], "Safari") !== false )) {
2988
2989 $id = 'AUDIO-' . uniqid();
2990
2991 $entry .= "<audio id=\"$id\"\" controls style='display : none'>
2992 <source type=\"$ctype\" src=\"$url\"></source>
2993 </audio>";
2994
2995 $entry .= "<span onclick=\"player(this)\"
2996 title=\"".__("Click to play")."\" status=\"0\"
2997 class=\"player\" audio-id=\"$id\">".__("Play")."</span>";
2998
2999 } else {
3000
3001 $entry .= "<object type=\"application/x-shockwave-flash\"
3002 data=\"lib/button/musicplayer.swf?song_url=$url\"
3003 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
3004 <param name=\"movie\"
3005 value=\"lib/button/musicplayer.swf?song_url=$url\" />
3006 </object>";
3007 }
3008
3009 if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
3010 href=\"$url\">" . basename($url) . "</a>";
3011
3012 return $entry;
3013
3014 }
3015
3016 return "";
3017
3018 /* $filename = substr($url, strrpos($url, "/")+1);
3019
3020 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3021 $filename . " (" . $ctype . ")" . "</a>"; */
3022
3023 }
3024
3025 function format_article($link, $id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
3026 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3027
3028 $rv = array();
3029
3030 $rv['id'] = $id;
3031
3032 /* we can figure out feed_id from article id anyway, why do we
3033 * pass feed_id here? let's ignore the argument :( */
3034
3035 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
3036 WHERE ref_id = '$id'");
3037
3038 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
3039
3040 $rv['feed_id'] = $feed_id;
3041
3042 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
3043
3044 if ($mark_as_read) {
3045 $result = db_query($link, "UPDATE ttrss_user_entries
3046 SET unread = false,last_read = NOW()
3047 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3048
3049 ccache_update($link, $feed_id, $owner_uid);
3050 }
3051
3052 $result = db_query($link, "SELECT id,title,link,content,feed_id,comments,int_id,
3053 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
3054 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
3055 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
3056 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
3057 num_comments,
3058 tag_cache,
3059 author,
3060 orig_feed_id,
3061 note,
3062 cached_content
3063 FROM ttrss_entries,ttrss_user_entries
3064 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
3065
3066 if ($result) {
3067
3068 $line = db_fetch_assoc($result);
3069
3070 $tag_cache = $line["tag_cache"];
3071
3072 $line["tags"] = get_article_tags($link, $id, $owner_uid, $line["tag_cache"]);
3073 unset($line["tag_cache"]);
3074
3075 $line["content"] = sanitize($link, $line["content"], false, $owner_uid, $line["site_url"]);
3076
3077 global $pluginhost;
3078
3079 foreach ($pluginhost->get_hooks($pluginhost::HOOK_RENDER_ARTICLE) as $p) {
3080 $line = $p->hook_render_article($line);
3081 }
3082
3083 $num_comments = $line["num_comments"];
3084 $entry_comments = "";
3085
3086 if ($num_comments > 0) {
3087 if ($line["comments"]) {
3088 $comments_url = htmlspecialchars($line["comments"]);
3089 } else {
3090 $comments_url = htmlspecialchars($line["link"]);
3091 }
3092 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
3093 } else {
3094 if ($line["comments"] && $line["link"] != $line["comments"]) {
3095 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
3096 }
3097 }
3098
3099 if ($zoom_mode) {
3100 header("Content-Type: text/html");
3101 $rv['content'] .= "<html><head>
3102 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3103 <title>Tiny Tiny RSS - ".$line["title"]."</title>
3104 <link rel=\"stylesheet\" type=\"text/css\" href=\"tt-rss.css\">
3105 </head><body id=\"ttrssZoom\">";
3106 }
3107
3108 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
3109
3110 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
3111
3112 $entry_author = $line["author"];
3113
3114 if ($entry_author) {
3115 $entry_author = __(" - ") . $entry_author;
3116 }
3117
3118 $parsed_updated = make_local_datetime($link, $line["updated"], true,
3119 $owner_uid, true);
3120
3121 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3122
3123 if ($line["link"]) {
3124 $rv['content'] .= "<div class='postTitle'><a target='_blank'
3125 title=\"".htmlspecialchars($line['title'])."\"
3126 href=\"" .
3127 htmlspecialchars($line["link"]) . "\">" .
3128 $line["title"] . "</a>" .
3129 "<span class='author'>$entry_author</span></div>";
3130 } else {
3131 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
3132 }
3133
3134 $tags_str = format_tags_string($line["tags"], $id);
3135 $tags_str_full = join(", ", $line["tags"]);
3136
3137 if (!$tags_str_full) $tags_str_full = __("no tags");
3138
3139 if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
3140
3141 $rv['content'] .= "<div class='postTags' style='float : right'>
3142 <img src='images/tag.png'
3143 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
3144
3145 if (!$zoom_mode) {
3146 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
3147 <a title=\"".__('Edit tags for this article')."\"
3148 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
3149
3150 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
3151 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
3152 position=\"below\">$tags_str_full</div>";
3153
3154 global $pluginhost;
3155 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_BUTTON) as $p) {
3156 $rv['content'] .= $p->hook_article_button($line);
3157 }
3158
3159 } else {
3160 $tags_str = strip_tags($tags_str);
3161 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
3162 }
3163 $rv['content'] .= "</div>";
3164 $rv['content'] .= "<div clear='both'>";
3165
3166 global $pluginhost;
3167 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
3168 $rv['content'] .= $p->hook_article_left_button($line);
3169 }
3170
3171 $rv['content'] .= "$entry_comments</div>";
3172
3173 if ($line["orig_feed_id"]) {
3174
3175 $tmp_result = db_query($link, "SELECT * FROM ttrss_archived_feeds
3176 WHERE id = ".$line["orig_feed_id"]);
3177
3178 if (db_num_rows($tmp_result) != 0) {
3179
3180 $rv['content'] .= "<div clear='both'>";
3181 $rv['content'] .= __("Originally from:");
3182
3183 $rv['content'] .= "&nbsp;";
3184
3185 $tmp_line = db_fetch_assoc($tmp_result);
3186
3187 $rv['content'] .= "<a target='_blank'
3188 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
3189 $tmp_line['title'] . "</a>";
3190
3191 $rv['content'] .= "&nbsp;";
3192
3193 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
3194 $rv['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_set.svg'></a>";
3195
3196 $rv['content'] .= "</div>";
3197 }
3198 }
3199
3200 $rv['content'] .= "</div>";
3201
3202 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
3203 if ($line['note']) {
3204 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
3205 }
3206 $rv['content'] .= "</div>";
3207
3208 $rv['content'] .= "<div class=\"postContent\">";
3209
3210 $rv['content'] .= $line["content"];
3211 $rv['content'] .= format_article_enclosures($link, $id,
3212 sql_bool_to_bool($line["always_display_enclosures"]),
3213 $line["content"],
3214 sql_bool_to_bool($line["hide_images"]));
3215
3216 $rv['content'] .= "</div>";
3217
3218 $rv['content'] .= "</div>";
3219
3220 }
3221
3222 if ($zoom_mode) {
3223 $rv['content'] .= "
3224 <div class='footer'>
3225 <button onclick=\"return window.close()\">".
3226 __("Close this window")."</button></div>";
3227 $rv['content'] .= "</body></html>";
3228 }
3229
3230 return $rv;
3231
3232 }
3233
3234 function print_checkpoint($n, $s) {
3235 $ts = microtime(true);
3236 echo sprintf("<!-- CP[$n] %.4f seconds -->", $ts - $s);
3237 return $ts;
3238 }
3239
3240 function sanitize_tag($tag) {
3241 $tag = trim($tag);
3242
3243 $tag = mb_strtolower($tag, 'utf-8');
3244
3245 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
3246
3247 // $tag = str_replace('"', "", $tag);
3248 // $tag = str_replace("+", " ", $tag);
3249 $tag = str_replace("technorati tag: ", "", $tag);
3250
3251 return $tag;
3252 }
3253
3254 function get_self_url_prefix() {
3255 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
3256 return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
3257 } else {
3258 return SELF_URL_PATH;
3259 }
3260 }
3261
3262 /**
3263 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
3264 *
3265 * @return string The Mozilla Firefox feed adding URL.
3266 */
3267 function add_feed_url() {
3268 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
3269
3270 $url_path = get_self_url_prefix() .
3271 "/public.php?op=subscribe&feed_url=%s";
3272 return $url_path;
3273 } // function add_feed_url
3274
3275 function encrypt_password($pass, $salt = '', $mode2 = false) {
3276 if ($salt && $mode2) {
3277 return "MODE2:" . hash('sha256', $salt . $pass);
3278 } else if ($salt) {
3279 return "SHA1X:" . sha1("$salt:$pass");
3280 } else {
3281 return "SHA1:" . sha1($pass);
3282 }
3283 } // function encrypt_password
3284
3285 function load_filters($link, $feed_id, $owner_uid, $action_id = false) {
3286 $filters = array();
3287
3288 $cat_id = (int)getFeedCategory($link, $feed_id);
3289
3290 $result = db_query($link, "SELECT * FROM ttrss_filters2 WHERE
3291 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
3292
3293 $check_cats = join(",", array_merge(
3294 getParentCategories($link, $cat_id, $owner_uid),
3295 array($cat_id)));
3296
3297 while ($line = db_fetch_assoc($result)) {
3298 $filter_id = $line["id"];
3299
3300 $result2 = db_query($link, "SELECT
3301 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
3302 FROM ttrss_filters2_rules AS r,
3303 ttrss_filter_types AS t
3304 WHERE
3305 (cat_id IS NULL OR cat_id IN ($check_cats)) AND
3306 (feed_id IS NULL OR feed_id = '$feed_id') AND
3307 filter_type = t.id AND filter_id = '$filter_id'");
3308
3309 $rules = array();
3310 $actions = array();
3311
3312 while ($rule_line = db_fetch_assoc($result2)) {
3313 # print_r($rule_line);
3314
3315 $rule = array();
3316 $rule["reg_exp"] = $rule_line["reg_exp"];
3317 $rule["type"] = $rule_line["type_name"];
3318 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
3319
3320 array_push($rules, $rule);
3321 }
3322
3323 $result2 = db_query($link, "SELECT a.action_param,t.name AS type_name
3324 FROM ttrss_filters2_actions AS a,
3325 ttrss_filter_actions AS t
3326 WHERE
3327 action_id = t.id AND filter_id = '$filter_id'");
3328
3329 while ($action_line = db_fetch_assoc($result2)) {
3330 # print_r($action_line);
3331
3332 $action = array();
3333 $action["type"] = $action_line["type_name"];
3334 $action["param"] = $action_line["action_param"];
3335
3336 array_push($actions, $action);
3337 }
3338
3339
3340 $filter = array();
3341 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
3342 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
3343 $filter["rules"] = $rules;
3344 $filter["actions"] = $actions;
3345
3346 if (count($rules) > 0 && count($actions) > 0) {
3347 array_push($filters, $filter);
3348 }
3349 }
3350
3351 return $filters;
3352 }
3353
3354 function get_score_pic($score) {
3355 if ($score > 100) {
3356 return "score_high.png";
3357 } else if ($score > 0) {
3358 return "score_half_high.png";
3359 } else if ($score < -100) {
3360 return "score_low.png";
3361 } else if ($score < 0) {
3362 return "score_half_low.png";
3363 } else {
3364 return "score_neutral.png";
3365 }
3366 }
3367
3368 function feed_has_icon($id) {
3369 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
3370 }
3371
3372 function init_connection($link) {
3373 if ($link) {
3374
3375 if (DB_TYPE == "pgsql") {
3376 pg_query($link, "set client_encoding = 'UTF-8'");
3377 pg_set_client_encoding("UNICODE");
3378 pg_query($link, "set datestyle = 'ISO, european'");
3379 pg_query($link, "set TIME ZONE 0");
3380 } else {
3381 db_query($link, "SET time_zone = '+0:0'");
3382
3383 if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
3384 db_query($link, "SET NAMES " . MYSQL_CHARSET);
3385 }
3386 }
3387
3388 global $pluginhost;
3389
3390 $pluginhost = new PluginHost($link);
3391 $pluginhost->load(PLUGINS, $pluginhost::KIND_ALL);
3392
3393 return true;
3394 } else {
3395 print "Unable to connect to database:" . db_last_error();
3396 return false;
3397 }
3398 }
3399
3400 function format_tags_string($tags, $id) {
3401
3402 $tags_str = "";
3403 $tags_nolinks_str = "";
3404
3405 $num_tags = 0;
3406
3407 $tag_limit = 6;
3408
3409 $formatted_tags = array();
3410
3411 foreach ($tags as $tag) {
3412 $num_tags++;
3413 $tag_escaped = str_replace("'", "\\'", $tag);
3414
3415 if (mb_strlen($tag) > 30) {
3416 $tag = truncate_string($tag, 30);
3417 }
3418
3419 $tag_str = "<a href=\"javascript:viewfeed('$tag_escaped')\">$tag</a>";
3420
3421 array_push($formatted_tags, $tag_str);
3422
3423 $tmp_tags_str = implode(", ", $formatted_tags);
3424
3425 if ($num_tags == $tag_limit || mb_strlen($tmp_tags_str) > 150) {
3426 break;
3427 }
3428 }
3429
3430 $tags_str = implode(", ", $formatted_tags);
3431
3432 if ($num_tags < count($tags)) {
3433 $tags_str .= ", &hellip;";
3434 }
3435
3436 if ($num_tags == 0) {
3437 $tags_str = __("no tags");
3438 }
3439
3440 return $tags_str;
3441
3442 }
3443
3444 function format_article_labels($labels, $id) {
3445
3446 $labels_str = "";
3447
3448 foreach ($labels as $l) {
3449 $labels_str .= sprintf("<span class='hlLabelRef'
3450 style='color : %s; background-color : %s'>%s</span>",
3451 $l[2], $l[3], $l[1]);
3452 }
3453
3454 return $labels_str;
3455
3456 }
3457
3458 function format_article_note($id, $note, $allow_edit = true) {
3459
3460 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
3461 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
3462 ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
3463
3464 return $str;
3465 }
3466
3467
3468 function get_feed_category($link, $feed_cat, $parent_cat_id = false) {
3469 if ($parent_cat_id) {
3470 $parent_qpart = "parent_cat = '$parent_cat_id'";
3471 $parent_insert = "'$parent_cat_id'";
3472 } else {
3473 $parent_qpart = "parent_cat IS NULL";
3474 $parent_insert = "NULL";
3475 }
3476
3477 $result = db_query($link,
3478 "SELECT id FROM ttrss_feed_categories
3479 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3480
3481 if (db_num_rows($result) == 0) {
3482 return false;
3483 } else {
3484 return db_fetch_result($result, 0, "id");
3485 }
3486 }
3487
3488 function add_feed_category($link, $feed_cat, $parent_cat_id = false) {
3489
3490 if (!$feed_cat) return false;
3491
3492 db_query($link, "BEGIN");
3493
3494 if ($parent_cat_id) {
3495 $parent_qpart = "parent_cat = '$parent_cat_id'";
3496 $parent_insert = "'$parent_cat_id'";
3497 } else {
3498 $parent_qpart = "parent_cat IS NULL";
3499 $parent_insert = "NULL";
3500 }
3501
3502 $feed_cat = mb_substr($feed_cat, 0, 250);
3503
3504 $result = db_query($link,
3505 "SELECT id FROM ttrss_feed_categories
3506 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3507
3508 if (db_num_rows($result) == 0) {
3509
3510 $result = db_query($link,
3511 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
3512 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
3513
3514 db_query($link, "COMMIT");
3515
3516 return true;
3517 }
3518
3519 return false;
3520 }
3521
3522 function getArticleFeed($link, $id) {
3523 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
3524 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
3525
3526 if (db_num_rows($result) != 0) {
3527 return db_fetch_result($result, 0, "feed_id");
3528 } else {
3529 return 0;
3530 }
3531 }
3532
3533 /**
3534 * Fixes incomplete URLs by prepending "http://".
3535 * Also replaces feed:// with http://, and
3536 * prepends a trailing slash if the url is a domain name only.
3537 *
3538 * @param string $url Possibly incomplete URL
3539 *
3540 * @return string Fixed URL.
3541 */
3542 function fix_url($url) {
3543 if (strpos($url, '://') === false) {
3544 $url = 'http://' . $url;
3545 } else if (substr($url, 0, 5) == 'feed:') {
3546 $url = 'http:' . substr($url, 5);
3547 }
3548
3549 //prepend slash if the URL has no slash in it
3550 // "http://www.example" -> "http://www.example/"
3551 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
3552 $url .= '/';
3553 }
3554
3555 if ($url != "http:///")
3556 return $url;
3557 else
3558 return '';
3559 }
3560
3561 function validate_feed_url($url) {
3562 $parts = parse_url($url);
3563
3564 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
3565
3566 }
3567
3568 function get_article_enclosures($link, $id) {
3569
3570 $query = "SELECT * FROM ttrss_enclosures
3571 WHERE post_id = '$id' AND content_url != ''";
3572
3573 $rv = array();
3574
3575 $result = db_query($link, $query);
3576
3577 if (db_num_rows($result) > 0) {
3578 while ($line = db_fetch_assoc($result)) {
3579 array_push($rv, $line);
3580 }
3581 }
3582
3583 return $rv;
3584 }
3585
3586 function save_email_address($link, $email) {
3587 // FIXME: implement persistent storage of emails
3588
3589 if (!$_SESSION['stored_emails'])
3590 $_SESSION['stored_emails'] = array();
3591
3592 if (!in_array($email, $_SESSION['stored_emails']))
3593 array_push($_SESSION['stored_emails'], $email);
3594 }
3595
3596
3597 function get_feed_access_key($link, $feed_id, $is_cat, $owner_uid = false) {
3598
3599 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3600
3601 $sql_is_cat = bool_to_sql_bool($is_cat);
3602
3603 $result = db_query($link, "SELECT access_key FROM ttrss_access_keys
3604 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
3605 AND owner_uid = " . $owner_uid);
3606
3607 if (db_num_rows($result) == 1) {
3608 return db_fetch_result($result, 0, "access_key");
3609 } else {
3610 $key = db_escape_string($link, sha1(uniqid(rand(), true)));
3611
3612 $result = db_query($link, "INSERT INTO ttrss_access_keys
3613 (access_key, feed_id, is_cat, owner_uid)
3614 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
3615
3616 return $key;
3617 }
3618 return false;
3619 }
3620
3621 function get_feeds_from_html($url, $content)
3622 {
3623 $url = fix_url($url);
3624 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
3625
3626 libxml_use_internal_errors(true);
3627
3628 $doc = new DOMDocument();
3629 $doc->loadHTML($content);
3630 $xpath = new DOMXPath($doc);
3631 $entries = $xpath->query('/html/head/link[@rel="alternate"]');
3632 $feedUrls = array();
3633 foreach ($entries as $entry) {
3634 if ($entry->hasAttribute('href')) {
3635 $title = $entry->getAttribute('title');
3636 if ($title == '') {
3637 $title = $entry->getAttribute('type');
3638 }
3639 $feedUrl = rewrite_relative_url(
3640 $baseUrl, $entry->getAttribute('href')
3641 );
3642 $feedUrls[$feedUrl] = $title;
3643 }
3644 }
3645 return $feedUrls;
3646 }
3647
3648 function is_html($content) {
3649 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
3650 }
3651
3652 function url_is_html($url, $login = false, $pass = false) {
3653 return is_html(fetch_file_contents($url, false, $login, $pass));
3654 }
3655
3656 function print_label_select($link, $name, $value, $attributes = "") {
3657
3658 $result = db_query($link, "SELECT caption FROM ttrss_labels2
3659 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
3660
3661 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
3662 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
3663
3664 while ($line = db_fetch_assoc($result)) {
3665
3666 $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
3667
3668 print "<option value=\"".htmlspecialchars($line["caption"])."\"
3669 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
3670
3671 }
3672
3673 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
3674
3675 print "</select>";
3676
3677
3678 }
3679
3680 function format_article_enclosures($link, $id, $always_display_enclosures,
3681 $article_content, $hide_images = false) {
3682
3683 $result = get_article_enclosures($link, $id);
3684 $rv = '';
3685
3686 if (count($result) > 0) {
3687
3688 $entries_html = array();
3689 $entries = array();
3690 $entries_inline = array();
3691
3692 foreach ($result as $line) {
3693
3694 $url = $line["content_url"];
3695 $ctype = $line["content_type"];
3696
3697 if (!$ctype) $ctype = __("unknown type");
3698
3699 $filename = substr($url, strrpos($url, "/")+1);
3700
3701 $player = format_inline_player($link, $url, $ctype);
3702
3703 if ($player) array_push($entries_inline, $player);
3704
3705 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3706 # $filename . " (" . $ctype . ")" . "</a>";
3707
3708 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
3709 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
3710
3711 array_push($entries_html, $entry);
3712
3713 $entry = array();
3714
3715 $entry["type"] = $ctype;
3716 $entry["filename"] = $filename;
3717 $entry["url"] = $url;
3718
3719 array_push($entries, $entry);
3720 }
3721
3722 if ($_SESSION['uid'] && !get_pref($link, "STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
3723 if ($always_display_enclosures ||
3724 !preg_match("/<img/i", $article_content)) {
3725
3726 foreach ($entries as $entry) {
3727
3728 if (preg_match("/image/", $entry["type"]) ||
3729 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
3730
3731 if (!$hide_images) {
3732 $rv .= "<p><img
3733 alt=\"".htmlspecialchars($entry["filename"])."\"
3734 src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
3735 } else {
3736 $rv .= "<p><a target=\"_blank\"
3737 href=\"".htmlspecialchars($entry["url"])."\"
3738 >" .htmlspecialchars($entry["url"]) . "</a></p>";
3739
3740 }
3741 }
3742 }
3743 }
3744 }
3745
3746 if (count($entries_inline) > 0) {
3747 $rv .= "<hr clear='both'/>";
3748 foreach ($entries_inline as $entry) { $rv .= $entry; };
3749 $rv .= "<hr clear='both'/>";
3750 }
3751
3752 $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
3753 "<option value=''>" . __('Attachments')."</option>";
3754
3755 foreach ($entries as $entry) {
3756 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "</option>";
3757
3758 };
3759
3760 $rv .= "</select>";
3761 }
3762
3763 return $rv;
3764 }
3765
3766 function getLastArticleId($link) {
3767 $result = db_query($link, "SELECT MAX(ref_id) AS id FROM ttrss_user_entries
3768 WHERE owner_uid = " . $_SESSION["uid"]);
3769
3770 if (db_num_rows($result) == 1) {
3771 return db_fetch_result($result, 0, "id");
3772 } else {
3773 return -1;
3774 }
3775 }
3776
3777 function build_url($parts) {
3778 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
3779 }
3780
3781 /**
3782 * Converts a (possibly) relative URL to a absolute one.
3783 *
3784 * @param string $url Base URL (i.e. from where the document is)
3785 * @param string $rel_url Possibly relative URL in the document
3786 *
3787 * @return string Absolute URL
3788 */
3789 function rewrite_relative_url($url, $rel_url) {
3790 if (strpos($rel_url, "magnet:") === 0) {
3791 return $rel_url;
3792 } else if (strpos($rel_url, "://") !== false) {
3793 return $rel_url;
3794 } else if (strpos($rel_url, "//") === 0) {
3795 # protocol-relative URL (rare but they exist)
3796 return $rel_url;
3797 } else if (strpos($rel_url, "/") === 0)
3798 {
3799 $parts = parse_url($url);
3800 $parts['path'] = $rel_url;
3801
3802 return build_url($parts);
3803
3804 } else {
3805 $parts = parse_url($url);
3806 if (!isset($parts['path'])) {
3807 $parts['path'] = '/';
3808 }
3809 $dir = $parts['path'];
3810 if (substr($dir, -1) !== '/') {
3811 $dir = dirname($parts['path']);
3812 $dir !== '/' && $dir .= '/';
3813 }
3814 $parts['path'] = $dir . $rel_url;
3815
3816 return build_url($parts);
3817 }
3818 }
3819
3820 function sphinx_search($query, $offset = 0, $limit = 30) {
3821 require_once 'lib/sphinxapi.php';
3822
3823 $sphinxClient = new SphinxClient();
3824
3825 $sphinxClient->SetServer('localhost', 9312);
3826 $sphinxClient->SetConnectTimeout(1);
3827
3828 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
3829 'feed_title' => 20));
3830
3831 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2);
3832 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
3833 $sphinxClient->SetLimits($offset, $limit, 1000);
3834 $sphinxClient->SetArrayResult(false);
3835 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
3836
3837 $result = $sphinxClient->Query($query, SPHINX_INDEX);
3838
3839 $ids = array();
3840
3841 if (is_array($result['matches'])) {
3842 foreach (array_keys($result['matches']) as $int_id) {
3843 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
3844 array_push($ids, $ref_id);
3845 }
3846 }
3847
3848 return $ids;
3849 }
3850
3851 function cleanup_tags($link, $days = 14, $limit = 1000) {
3852
3853 if (DB_TYPE == "pgsql") {
3854 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
3855 } else if (DB_TYPE == "mysql") {
3856 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
3857 }
3858
3859 $tags_deleted = 0;
3860
3861 while ($limit > 0) {
3862 $limit_part = 500;
3863
3864 $query = "SELECT ttrss_tags.id AS id
3865 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
3866 WHERE post_int_id = int_id AND $interval_query AND
3867 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
3868
3869 $result = db_query($link, $query);
3870
3871 $ids = array();
3872
3873 while ($line = db_fetch_assoc($result)) {
3874 array_push($ids, $line['id']);
3875 }
3876
3877 if (count($ids) > 0) {
3878 $ids = join(",", $ids);
3879
3880 $tmp_result = db_query($link, "DELETE FROM ttrss_tags WHERE id IN ($ids)");
3881 $tags_deleted += db_affected_rows($link, $tmp_result);
3882 } else {
3883 break;
3884 }
3885
3886 $limit -= $limit_part;
3887 }
3888
3889 return $tags_deleted;
3890 }
3891
3892 function print_user_stylesheet($link) {
3893 $value = get_pref($link, 'USER_STYLESHEET');
3894
3895 if ($value) {
3896 print "<style type=\"text/css\">";
3897 print str_replace("<br/>", "\n", $value);
3898 print "</style>";
3899 }
3900
3901 }
3902
3903 function rewrite_urls($html) {
3904 libxml_use_internal_errors(true);
3905
3906 $charset_hack = '<head>
3907 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
3908 </head>';
3909
3910 $doc = new DOMDocument();
3911 $doc->loadHTML($charset_hack . $html);
3912 $xpath = new DOMXPath($doc);
3913
3914 $entries = $xpath->query('//*/text()');
3915
3916 foreach ($entries as $entry) {
3917 if (strstr($entry->wholeText, "://") !== false) {
3918 $text = preg_replace("/((?<!=.)((http|https|ftp)+):\/\/[^ ,!]+)/i",
3919 "<a target=\"_blank\" href=\"\\1\">\\1</a>", $entry->wholeText);
3920
3921 if ($text != $entry->wholeText) {
3922 $cdoc = new DOMDocument();
3923 $cdoc->loadHTML($charset_hack . $text);
3924
3925
3926 foreach ($cdoc->childNodes as $cnode) {
3927 $cnode = $doc->importNode($cnode, true);
3928
3929 if ($cnode) {
3930 $entry->parentNode->insertBefore($cnode);
3931 }
3932 }
3933
3934 $entry->parentNode->removeChild($entry);
3935
3936 }
3937 }
3938 }
3939
3940 $node = $doc->getElementsByTagName('body')->item(0);
3941
3942 // http://tt-rss.org/forum/viewtopic.php?f=1&t=970
3943 if ($node)
3944 return $doc->saveXML($node);
3945 else
3946 return $html;
3947 }
3948
3949 function filter_to_sql($link, $filter, $owner_uid) {
3950 $query = array();
3951
3952 if (DB_TYPE == "pgsql")
3953 $reg_qpart = "~";
3954 else
3955 $reg_qpart = "REGEXP";
3956
3957 foreach ($filter["rules"] AS $rule) {
3958 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
3959 $rule['reg_exp']) !== FALSE;
3960
3961 if ($regexp_valid) {
3962
3963 $rule['reg_exp'] = db_escape_string($link, $rule['reg_exp']);
3964
3965 switch ($rule["type"]) {
3966 case "title":
3967 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3968 $rule['reg_exp'] . "')";
3969 break;
3970 case "content":
3971 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
3972 $rule['reg_exp'] . "')";
3973 break;
3974 case "both":
3975 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3976 $rule['reg_exp'] . "') OR LOWER(" .
3977 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
3978 break;
3979 case "tag":
3980 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
3981 $rule['reg_exp'] . "')";
3982 break;
3983 case "link":
3984 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
3985 $rule['reg_exp'] . "')";
3986 break;
3987 case "author":
3988 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
3989 $rule['reg_exp'] . "')";
3990 break;
3991 }
3992
3993 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
3994
3995 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
3996 $qpart .= " AND feed_id = " . db_escape_string($link, $rule["feed_id"]);
3997 }
3998
3999 if (isset($rule["cat_id"])) {
4000
4001 if ($rule["cat_id"] > 0) {
4002 $children = getChildCategories($link, $rule["cat_id"], $owner_uid);
4003 array_push($children, $rule["cat_id"]);
4004
4005 $children = join(",", $children);
4006
4007 $cat_qpart = "cat_id IN ($children)";
4008 } else {
4009 $cat_qpart = "cat_id IS NULL";
4010 }
4011
4012 $qpart .= " AND $cat_qpart";
4013 }
4014
4015 array_push($query, "($qpart)");
4016
4017 }
4018 }
4019
4020 if (count($query) > 0) {
4021 $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
4022 } else {
4023 $fullquery = "(false)";
4024 }
4025
4026 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
4027
4028 return $fullquery;
4029 }
4030
4031 if (!function_exists('gzdecode')) {
4032 function gzdecode($string) { // no support for 2nd argument
4033 return file_get_contents('compress.zlib://data:who/cares;base64,'.
4034 base64_encode($string));
4035 }
4036 }
4037
4038 function get_random_bytes($length) {
4039 if (function_exists('openssl_random_pseudo_bytes')) {
4040 return openssl_random_pseudo_bytes($length);
4041 } else {
4042 $output = "";
4043
4044 for ($i = 0; $i < $length; $i++)
4045 $output .= chr(mt_rand(0, 255));
4046
4047 return $output;
4048 }
4049 }
4050
4051 function read_stdin() {
4052 $fp = fopen("php://stdin", "r");
4053
4054 if ($fp) {
4055 $line = trim(fgets($fp));
4056 fclose($fp);
4057 return $line;
4058 }
4059
4060 return null;
4061 }
4062
4063 function tmpdirname($path, $prefix) {
4064 // Use PHP's tmpfile function to create a temporary
4065 // directory name. Delete the file and keep the name.
4066 $tempname = tempnam($path,$prefix);
4067 if (!$tempname)
4068 return false;
4069
4070 if (!unlink($tempname))
4071 return false;
4072
4073 return $tempname;
4074 }
4075
4076 function getFeedCategory($link, $feed) {
4077 $result = db_query($link, "SELECT cat_id FROM ttrss_feeds
4078 WHERE id = '$feed'");
4079
4080 if (db_num_rows($result) > 0) {
4081 return db_fetch_result($result, 0, "cat_id");
4082 } else {
4083 return false;
4084 }
4085
4086 }
4087
4088 function implements_interface($class, $interface) {
4089 return in_array($interface, class_implements($class));
4090 }
4091
4092 function geturl($url){
4093
4094 (function_exists('curl_init')) ? '' : die('cURL Must be installed for geturl function to work. Ask your host to enable it or uncomment extension=php_curl.dll in php.ini');
4095
4096 $curl = curl_init();
4097 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
4098 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
4099 $header[] = "Cache-Control: max-age=0";
4100 $header[] = "Connection: keep-alive";
4101 $header[] = "Keep-Alive: 300";
4102 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
4103 $header[] = "Accept-Language: en-us,en;q=0.5";
4104 $header[] = "Pragma: ";
4105
4106 curl_setopt($curl, CURLOPT_URL, $url);
4107 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
4108 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
4109 curl_setopt($curl, CURLOPT_HEADER, true);
4110 curl_setopt($curl, CURLOPT_REFERER, $url);
4111 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
4112 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
4113 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
4114 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
4115 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
4116
4117 $html = curl_exec($curl);
4118
4119 $status = curl_getinfo($curl);
4120 curl_close($curl);
4121
4122 if($status['http_code']!=200){
4123 if($status['http_code'] == 301 || $status['http_code'] == 302) {
4124 list($header) = explode("\r\n\r\n", $html, 2);
4125 $matches = array();
4126 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
4127 $url = trim(str_replace($matches[1],"",$matches[0]));
4128 $url_parsed = parse_url($url);
4129 return (isset($url_parsed))? geturl($url, $referer):'';
4130 }
4131 $oline='';
4132 foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
4133 $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
4134 # $handle = @fopen('./curl.error.log', 'a');
4135 # fwrite($handle, $line);
4136 return FALSE;
4137 }
4138 return $url;
4139 }
4140
4141 function get_minified_js($files) {
4142 require_once 'lib/jshrink/Minifier.php';
4143
4144 $rv = '';
4145
4146 foreach ($files as $js) {
4147 if (!isset($_GET['debug'])) {
4148 $cached_file = CACHE_DIR . "/js/$js.js";
4149
4150 if (file_exists($cached_file) &&
4151 is_readable($cached_file) &&
4152 filemtime($cached_file) >= filemtime("js/$js.js")) {
4153
4154 $rv .= file_get_contents($cached_file);
4155
4156 } else {
4157 $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
4158 file_put_contents($cached_file, $minified);
4159 $rv .= $minified;
4160 }
4161 } else {
4162 $rv .= file_get_contents("js/$js.js");
4163 }
4164 }
4165
4166 return $rv;
4167 }
4168
4169 function stylesheet_tag($filename) {
4170 $timestamp = filemtime($filename);
4171
4172 echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
4173 }
4174
4175 function javascript_tag($filename) {
4176 $query = "";
4177
4178 if (!(strpos($filename, "?") === FALSE)) {
4179 $query = substr($filename, strpos($filename, "?")+1);
4180 $filename = substr($filename, 0, strpos($filename, "?"));
4181 }
4182
4183 $timestamp = filemtime($filename);
4184
4185 if ($query) $timestamp .= "&$query";
4186
4187 echo "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
4188 }
4189
4190 function calculate_dep_timestamp() {
4191 $files = array_merge(glob("js/*.js"), glob("*.css"));
4192
4193 $max_ts = -1;
4194
4195 foreach ($files as $file) {
4196 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
4197 }
4198
4199 return $max_ts;
4200 }
4201
4202 function T_js_decl($s1, $s2) {
4203 if ($s1 && $s2) {
4204 $s1 = preg_replace("/\n/", "", $s1);
4205 $s2 = preg_replace("/\n/", "", $s2);
4206
4207 $s1 = preg_replace("/\"/", "\\\"", $s1);
4208 $s2 = preg_replace("/\"/", "\\\"", $s2);
4209
4210 return "T_messages[\"$s1\"] = \"$s2\";\n";
4211 }
4212 }
4213
4214 function init_js_translations() {
4215
4216 print 'var T_messages = new Object();
4217
4218 function __(msg) {
4219 if (T_messages[msg]) {
4220 return T_messages[msg];
4221 } else {
4222 return msg;
4223 }
4224 }
4225
4226 function ngettext(msg1, msg2, n) {
4227 return (parseInt(n) > 1) ? msg2 : msg1;
4228 }';
4229
4230 $l10n = _get_reader();
4231
4232 for ($i = 0; $i < $l10n->total; $i++) {
4233 $orig = $l10n->get_original_string($i);
4234 $translation = __($orig);
4235
4236 print T_js_decl($orig, $translation);
4237 }
4238 }
4239
4240 function label_to_feed_id($label) {
4241 return LABEL_BASE_INDEX - 1 - abs($label);
4242 }
4243
4244 function feed_to_label_id($feed) {
4245 return LABEL_BASE_INDEX - 1 + abs($feed);
4246 }
4247
4248 ?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/