]> 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
add cache-control: public to the login page so that firefox would bother making a...
[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 header('Cache-Control: public');
2929
2930 require_once "login_form.php";
2931 exit;
2932 }
2933
2934 function format_warning($msg, $id = "") {
2935 global $link;
2936 return "<div class=\"warning\" id=\"$id\">
2937 <img src=\"images/sign_excl.svg\"><div class='inner'>$msg</div></div>";
2938 }
2939
2940 function format_notice($msg, $id = "") {
2941 global $link;
2942 return "<div class=\"notice\" id=\"$id\">
2943 <img src=\"images/sign_info.svg\"><div class='inner'>$msg</div></div>";
2944 }
2945
2946 function format_error($msg, $id = "") {
2947 global $link;
2948 return "<div class=\"error\" id=\"$id\">
2949 <img src=\"images/sign_excl.svg\"><div class='inner'>$msg</div></div>";
2950 }
2951
2952 function print_notice($msg) {
2953 return print format_notice($msg);
2954 }
2955
2956 function print_warning($msg) {
2957 return print format_warning($msg);
2958 }
2959
2960 function print_error($msg) {
2961 return print format_error($msg);
2962 }
2963
2964
2965 function T_sprintf() {
2966 $args = func_get_args();
2967 return vsprintf(__(array_shift($args)), $args);
2968 }
2969
2970 function format_inline_player($link, $url, $ctype) {
2971
2972 $entry = "";
2973
2974 $url = htmlspecialchars($url);
2975
2976 if (strpos($ctype, "audio/") === 0) {
2977
2978 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
2979 strpos($_SERVER['HTTP_USER_AGENT'], "Chrome") !== false ||
2980 strpos($_SERVER['HTTP_USER_AGENT'], "Safari") !== false )) {
2981
2982 $id = 'AUDIO-' . uniqid();
2983
2984 $entry .= "<audio id=\"$id\"\" controls style='display : none'>
2985 <source type=\"$ctype\" src=\"$url\"></source>
2986 </audio>";
2987
2988 $entry .= "<span onclick=\"player(this)\"
2989 title=\"".__("Click to play")."\" status=\"0\"
2990 class=\"player\" audio-id=\"$id\">".__("Play")."</span>";
2991
2992 } else {
2993
2994 $entry .= "<object type=\"application/x-shockwave-flash\"
2995 data=\"lib/button/musicplayer.swf?song_url=$url\"
2996 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
2997 <param name=\"movie\"
2998 value=\"lib/button/musicplayer.swf?song_url=$url\" />
2999 </object>";
3000 }
3001
3002 if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
3003 href=\"$url\">" . basename($url) . "</a>";
3004
3005 return $entry;
3006
3007 }
3008
3009 return "";
3010
3011 /* $filename = substr($url, strrpos($url, "/")+1);
3012
3013 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3014 $filename . " (" . $ctype . ")" . "</a>"; */
3015
3016 }
3017
3018 function format_article($link, $id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
3019 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3020
3021 $rv = array();
3022
3023 $rv['id'] = $id;
3024
3025 /* we can figure out feed_id from article id anyway, why do we
3026 * pass feed_id here? let's ignore the argument :( */
3027
3028 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
3029 WHERE ref_id = '$id'");
3030
3031 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
3032
3033 $rv['feed_id'] = $feed_id;
3034
3035 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
3036
3037 if ($mark_as_read) {
3038 $result = db_query($link, "UPDATE ttrss_user_entries
3039 SET unread = false,last_read = NOW()
3040 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3041
3042 ccache_update($link, $feed_id, $owner_uid);
3043 }
3044
3045 $result = db_query($link, "SELECT id,title,link,content,feed_id,comments,int_id,
3046 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
3047 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
3048 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
3049 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
3050 num_comments,
3051 tag_cache,
3052 author,
3053 orig_feed_id,
3054 note,
3055 cached_content
3056 FROM ttrss_entries,ttrss_user_entries
3057 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
3058
3059 if ($result) {
3060
3061 $line = db_fetch_assoc($result);
3062
3063 $tag_cache = $line["tag_cache"];
3064
3065 $line["tags"] = get_article_tags($link, $id, $owner_uid, $line["tag_cache"]);
3066 unset($line["tag_cache"]);
3067
3068 $line["content"] = sanitize($link, $line["content"], false, $owner_uid, $line["site_url"]);
3069
3070 global $pluginhost;
3071
3072 foreach ($pluginhost->get_hooks($pluginhost::HOOK_RENDER_ARTICLE) as $p) {
3073 $line = $p->hook_render_article($line);
3074 }
3075
3076 $num_comments = $line["num_comments"];
3077 $entry_comments = "";
3078
3079 if ($num_comments > 0) {
3080 if ($line["comments"]) {
3081 $comments_url = htmlspecialchars($line["comments"]);
3082 } else {
3083 $comments_url = htmlspecialchars($line["link"]);
3084 }
3085 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
3086 } else {
3087 if ($line["comments"] && $line["link"] != $line["comments"]) {
3088 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
3089 }
3090 }
3091
3092 if ($zoom_mode) {
3093 header("Content-Type: text/html");
3094 $rv['content'] .= "<html><head>
3095 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3096 <title>Tiny Tiny RSS - ".$line["title"]."</title>
3097 <link rel=\"stylesheet\" type=\"text/css\" href=\"tt-rss.css\">
3098 </head><body id=\"ttrssZoom\">";
3099 }
3100
3101 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
3102
3103 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
3104
3105 $entry_author = $line["author"];
3106
3107 if ($entry_author) {
3108 $entry_author = __(" - ") . $entry_author;
3109 }
3110
3111 $parsed_updated = make_local_datetime($link, $line["updated"], true,
3112 $owner_uid, true);
3113
3114 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3115
3116 if ($line["link"]) {
3117 $rv['content'] .= "<div class='postTitle'><a target='_blank'
3118 title=\"".htmlspecialchars($line['title'])."\"
3119 href=\"" .
3120 htmlspecialchars($line["link"]) . "\">" .
3121 $line["title"] . "</a>" .
3122 "<span class='author'>$entry_author</span></div>";
3123 } else {
3124 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
3125 }
3126
3127 $tags_str = format_tags_string($line["tags"], $id);
3128 $tags_str_full = join(", ", $line["tags"]);
3129
3130 if (!$tags_str_full) $tags_str_full = __("no tags");
3131
3132 if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
3133
3134 $rv['content'] .= "<div class='postTags' style='float : right'>
3135 <img src='images/tag.png'
3136 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
3137
3138 if (!$zoom_mode) {
3139 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
3140 <a title=\"".__('Edit tags for this article')."\"
3141 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
3142
3143 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
3144 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
3145 position=\"below\">$tags_str_full</div>";
3146
3147 global $pluginhost;
3148 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_BUTTON) as $p) {
3149 $rv['content'] .= $p->hook_article_button($line);
3150 }
3151
3152 } else {
3153 $tags_str = strip_tags($tags_str);
3154 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
3155 }
3156 $rv['content'] .= "</div>";
3157 $rv['content'] .= "<div clear='both'>";
3158
3159 global $pluginhost;
3160 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
3161 $rv['content'] .= $p->hook_article_left_button($line);
3162 }
3163
3164 $rv['content'] .= "$entry_comments</div>";
3165
3166 if ($line["orig_feed_id"]) {
3167
3168 $tmp_result = db_query($link, "SELECT * FROM ttrss_archived_feeds
3169 WHERE id = ".$line["orig_feed_id"]);
3170
3171 if (db_num_rows($tmp_result) != 0) {
3172
3173 $rv['content'] .= "<div clear='both'>";
3174 $rv['content'] .= __("Originally from:");
3175
3176 $rv['content'] .= "&nbsp;";
3177
3178 $tmp_line = db_fetch_assoc($tmp_result);
3179
3180 $rv['content'] .= "<a target='_blank'
3181 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
3182 $tmp_line['title'] . "</a>";
3183
3184 $rv['content'] .= "&nbsp;";
3185
3186 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
3187 $rv['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_set.svg'></a>";
3188
3189 $rv['content'] .= "</div>";
3190 }
3191 }
3192
3193 $rv['content'] .= "</div>";
3194
3195 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
3196 if ($line['note']) {
3197 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
3198 }
3199 $rv['content'] .= "</div>";
3200
3201 $rv['content'] .= "<div class=\"postContent\">";
3202
3203 $rv['content'] .= $line["content"];
3204 $rv['content'] .= format_article_enclosures($link, $id,
3205 sql_bool_to_bool($line["always_display_enclosures"]),
3206 $line["content"],
3207 sql_bool_to_bool($line["hide_images"]));
3208
3209 $rv['content'] .= "</div>";
3210
3211 $rv['content'] .= "</div>";
3212
3213 }
3214
3215 if ($zoom_mode) {
3216 $rv['content'] .= "
3217 <div class='footer'>
3218 <button onclick=\"return window.close()\">".
3219 __("Close this window")."</button></div>";
3220 $rv['content'] .= "</body></html>";
3221 }
3222
3223 return $rv;
3224
3225 }
3226
3227 function print_checkpoint($n, $s) {
3228 $ts = microtime(true);
3229 echo sprintf("<!-- CP[$n] %.4f seconds -->", $ts - $s);
3230 return $ts;
3231 }
3232
3233 function sanitize_tag($tag) {
3234 $tag = trim($tag);
3235
3236 $tag = mb_strtolower($tag, 'utf-8');
3237
3238 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
3239
3240 // $tag = str_replace('"', "", $tag);
3241 // $tag = str_replace("+", " ", $tag);
3242 $tag = str_replace("technorati tag: ", "", $tag);
3243
3244 return $tag;
3245 }
3246
3247 function get_self_url_prefix() {
3248 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
3249 return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
3250 } else {
3251 return SELF_URL_PATH;
3252 }
3253 }
3254
3255 /**
3256 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
3257 *
3258 * @return string The Mozilla Firefox feed adding URL.
3259 */
3260 function add_feed_url() {
3261 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
3262
3263 $url_path = get_self_url_prefix() .
3264 "/public.php?op=subscribe&feed_url=%s";
3265 return $url_path;
3266 } // function add_feed_url
3267
3268 function encrypt_password($pass, $salt = '', $mode2 = false) {
3269 if ($salt && $mode2) {
3270 return "MODE2:" . hash('sha256', $salt . $pass);
3271 } else if ($salt) {
3272 return "SHA1X:" . sha1("$salt:$pass");
3273 } else {
3274 return "SHA1:" . sha1($pass);
3275 }
3276 } // function encrypt_password
3277
3278 function load_filters($link, $feed_id, $owner_uid, $action_id = false) {
3279 $filters = array();
3280
3281 $cat_id = (int)getFeedCategory($link, $feed_id);
3282
3283 $result = db_query($link, "SELECT * FROM ttrss_filters2 WHERE
3284 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
3285
3286 $check_cats = join(",", array_merge(
3287 getParentCategories($link, $cat_id, $owner_uid),
3288 array($cat_id)));
3289
3290 while ($line = db_fetch_assoc($result)) {
3291 $filter_id = $line["id"];
3292
3293 $result2 = db_query($link, "SELECT
3294 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
3295 FROM ttrss_filters2_rules AS r,
3296 ttrss_filter_types AS t
3297 WHERE
3298 (cat_id IS NULL OR cat_id IN ($check_cats)) AND
3299 (feed_id IS NULL OR feed_id = '$feed_id') AND
3300 filter_type = t.id AND filter_id = '$filter_id'");
3301
3302 $rules = array();
3303 $actions = array();
3304
3305 while ($rule_line = db_fetch_assoc($result2)) {
3306 # print_r($rule_line);
3307
3308 $rule = array();
3309 $rule["reg_exp"] = $rule_line["reg_exp"];
3310 $rule["type"] = $rule_line["type_name"];
3311 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
3312
3313 array_push($rules, $rule);
3314 }
3315
3316 $result2 = db_query($link, "SELECT a.action_param,t.name AS type_name
3317 FROM ttrss_filters2_actions AS a,
3318 ttrss_filter_actions AS t
3319 WHERE
3320 action_id = t.id AND filter_id = '$filter_id'");
3321
3322 while ($action_line = db_fetch_assoc($result2)) {
3323 # print_r($action_line);
3324
3325 $action = array();
3326 $action["type"] = $action_line["type_name"];
3327 $action["param"] = $action_line["action_param"];
3328
3329 array_push($actions, $action);
3330 }
3331
3332
3333 $filter = array();
3334 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
3335 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
3336 $filter["rules"] = $rules;
3337 $filter["actions"] = $actions;
3338
3339 if (count($rules) > 0 && count($actions) > 0) {
3340 array_push($filters, $filter);
3341 }
3342 }
3343
3344 return $filters;
3345 }
3346
3347 function get_score_pic($score) {
3348 if ($score > 100) {
3349 return "score_high.png";
3350 } else if ($score > 0) {
3351 return "score_half_high.png";
3352 } else if ($score < -100) {
3353 return "score_low.png";
3354 } else if ($score < 0) {
3355 return "score_half_low.png";
3356 } else {
3357 return "score_neutral.png";
3358 }
3359 }
3360
3361 function feed_has_icon($id) {
3362 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
3363 }
3364
3365 function init_connection($link) {
3366 if ($link) {
3367
3368 if (DB_TYPE == "pgsql") {
3369 pg_query($link, "set client_encoding = 'UTF-8'");
3370 pg_set_client_encoding("UNICODE");
3371 pg_query($link, "set datestyle = 'ISO, european'");
3372 pg_query($link, "set TIME ZONE 0");
3373 } else {
3374 db_query($link, "SET time_zone = '+0:0'");
3375
3376 if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
3377 db_query($link, "SET NAMES " . MYSQL_CHARSET);
3378 }
3379 }
3380
3381 global $pluginhost;
3382
3383 $pluginhost = new PluginHost($link);
3384 $pluginhost->load(PLUGINS, $pluginhost::KIND_ALL);
3385
3386 return true;
3387 } else {
3388 print "Unable to connect to database:" . db_last_error();
3389 return false;
3390 }
3391 }
3392
3393 function format_tags_string($tags, $id) {
3394
3395 $tags_str = "";
3396 $tags_nolinks_str = "";
3397
3398 $num_tags = 0;
3399
3400 $tag_limit = 6;
3401
3402 $formatted_tags = array();
3403
3404 foreach ($tags as $tag) {
3405 $num_tags++;
3406 $tag_escaped = str_replace("'", "\\'", $tag);
3407
3408 if (mb_strlen($tag) > 30) {
3409 $tag = truncate_string($tag, 30);
3410 }
3411
3412 $tag_str = "<a href=\"javascript:viewfeed('$tag_escaped')\">$tag</a>";
3413
3414 array_push($formatted_tags, $tag_str);
3415
3416 $tmp_tags_str = implode(", ", $formatted_tags);
3417
3418 if ($num_tags == $tag_limit || mb_strlen($tmp_tags_str) > 150) {
3419 break;
3420 }
3421 }
3422
3423 $tags_str = implode(", ", $formatted_tags);
3424
3425 if ($num_tags < count($tags)) {
3426 $tags_str .= ", &hellip;";
3427 }
3428
3429 if ($num_tags == 0) {
3430 $tags_str = __("no tags");
3431 }
3432
3433 return $tags_str;
3434
3435 }
3436
3437 function format_article_labels($labels, $id) {
3438
3439 $labels_str = "";
3440
3441 foreach ($labels as $l) {
3442 $labels_str .= sprintf("<span class='hlLabelRef'
3443 style='color : %s; background-color : %s'>%s</span>",
3444 $l[2], $l[3], $l[1]);
3445 }
3446
3447 return $labels_str;
3448
3449 }
3450
3451 function format_article_note($id, $note, $allow_edit = true) {
3452
3453 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
3454 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
3455 ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
3456
3457 return $str;
3458 }
3459
3460
3461 function get_feed_category($link, $feed_cat, $parent_cat_id = false) {
3462 if ($parent_cat_id) {
3463 $parent_qpart = "parent_cat = '$parent_cat_id'";
3464 $parent_insert = "'$parent_cat_id'";
3465 } else {
3466 $parent_qpart = "parent_cat IS NULL";
3467 $parent_insert = "NULL";
3468 }
3469
3470 $result = db_query($link,
3471 "SELECT id FROM ttrss_feed_categories
3472 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3473
3474 if (db_num_rows($result) == 0) {
3475 return false;
3476 } else {
3477 return db_fetch_result($result, 0, "id");
3478 }
3479 }
3480
3481 function add_feed_category($link, $feed_cat, $parent_cat_id = false) {
3482
3483 if (!$feed_cat) return false;
3484
3485 db_query($link, "BEGIN");
3486
3487 if ($parent_cat_id) {
3488 $parent_qpart = "parent_cat = '$parent_cat_id'";
3489 $parent_insert = "'$parent_cat_id'";
3490 } else {
3491 $parent_qpart = "parent_cat IS NULL";
3492 $parent_insert = "NULL";
3493 }
3494
3495 $feed_cat = mb_substr($feed_cat, 0, 250);
3496
3497 $result = db_query($link,
3498 "SELECT id FROM ttrss_feed_categories
3499 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3500
3501 if (db_num_rows($result) == 0) {
3502
3503 $result = db_query($link,
3504 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
3505 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
3506
3507 db_query($link, "COMMIT");
3508
3509 return true;
3510 }
3511
3512 return false;
3513 }
3514
3515 function getArticleFeed($link, $id) {
3516 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
3517 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
3518
3519 if (db_num_rows($result) != 0) {
3520 return db_fetch_result($result, 0, "feed_id");
3521 } else {
3522 return 0;
3523 }
3524 }
3525
3526 /**
3527 * Fixes incomplete URLs by prepending "http://".
3528 * Also replaces feed:// with http://, and
3529 * prepends a trailing slash if the url is a domain name only.
3530 *
3531 * @param string $url Possibly incomplete URL
3532 *
3533 * @return string Fixed URL.
3534 */
3535 function fix_url($url) {
3536 if (strpos($url, '://') === false) {
3537 $url = 'http://' . $url;
3538 } else if (substr($url, 0, 5) == 'feed:') {
3539 $url = 'http:' . substr($url, 5);
3540 }
3541
3542 //prepend slash if the URL has no slash in it
3543 // "http://www.example" -> "http://www.example/"
3544 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
3545 $url .= '/';
3546 }
3547
3548 if ($url != "http:///")
3549 return $url;
3550 else
3551 return '';
3552 }
3553
3554 function validate_feed_url($url) {
3555 $parts = parse_url($url);
3556
3557 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
3558
3559 }
3560
3561 function get_article_enclosures($link, $id) {
3562
3563 $query = "SELECT * FROM ttrss_enclosures
3564 WHERE post_id = '$id' AND content_url != ''";
3565
3566 $rv = array();
3567
3568 $result = db_query($link, $query);
3569
3570 if (db_num_rows($result) > 0) {
3571 while ($line = db_fetch_assoc($result)) {
3572 array_push($rv, $line);
3573 }
3574 }
3575
3576 return $rv;
3577 }
3578
3579 function save_email_address($link, $email) {
3580 // FIXME: implement persistent storage of emails
3581
3582 if (!$_SESSION['stored_emails'])
3583 $_SESSION['stored_emails'] = array();
3584
3585 if (!in_array($email, $_SESSION['stored_emails']))
3586 array_push($_SESSION['stored_emails'], $email);
3587 }
3588
3589
3590 function get_feed_access_key($link, $feed_id, $is_cat, $owner_uid = false) {
3591
3592 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3593
3594 $sql_is_cat = bool_to_sql_bool($is_cat);
3595
3596 $result = db_query($link, "SELECT access_key FROM ttrss_access_keys
3597 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
3598 AND owner_uid = " . $owner_uid);
3599
3600 if (db_num_rows($result) == 1) {
3601 return db_fetch_result($result, 0, "access_key");
3602 } else {
3603 $key = db_escape_string($link, sha1(uniqid(rand(), true)));
3604
3605 $result = db_query($link, "INSERT INTO ttrss_access_keys
3606 (access_key, feed_id, is_cat, owner_uid)
3607 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
3608
3609 return $key;
3610 }
3611 return false;
3612 }
3613
3614 function get_feeds_from_html($url, $content)
3615 {
3616 $url = fix_url($url);
3617 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
3618
3619 libxml_use_internal_errors(true);
3620
3621 $doc = new DOMDocument();
3622 $doc->loadHTML($content);
3623 $xpath = new DOMXPath($doc);
3624 $entries = $xpath->query('/html/head/link[@rel="alternate"]');
3625 $feedUrls = array();
3626 foreach ($entries as $entry) {
3627 if ($entry->hasAttribute('href')) {
3628 $title = $entry->getAttribute('title');
3629 if ($title == '') {
3630 $title = $entry->getAttribute('type');
3631 }
3632 $feedUrl = rewrite_relative_url(
3633 $baseUrl, $entry->getAttribute('href')
3634 );
3635 $feedUrls[$feedUrl] = $title;
3636 }
3637 }
3638 return $feedUrls;
3639 }
3640
3641 function is_html($content) {
3642 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
3643 }
3644
3645 function url_is_html($url, $login = false, $pass = false) {
3646 return is_html(fetch_file_contents($url, false, $login, $pass));
3647 }
3648
3649 function print_label_select($link, $name, $value, $attributes = "") {
3650
3651 $result = db_query($link, "SELECT caption FROM ttrss_labels2
3652 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
3653
3654 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
3655 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
3656
3657 while ($line = db_fetch_assoc($result)) {
3658
3659 $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
3660
3661 print "<option value=\"".htmlspecialchars($line["caption"])."\"
3662 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
3663
3664 }
3665
3666 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
3667
3668 print "</select>";
3669
3670
3671 }
3672
3673 function format_article_enclosures($link, $id, $always_display_enclosures,
3674 $article_content, $hide_images = false) {
3675
3676 $result = get_article_enclosures($link, $id);
3677 $rv = '';
3678
3679 if (count($result) > 0) {
3680
3681 $entries_html = array();
3682 $entries = array();
3683 $entries_inline = array();
3684
3685 foreach ($result as $line) {
3686
3687 $url = $line["content_url"];
3688 $ctype = $line["content_type"];
3689
3690 if (!$ctype) $ctype = __("unknown type");
3691
3692 $filename = substr($url, strrpos($url, "/")+1);
3693
3694 $player = format_inline_player($link, $url, $ctype);
3695
3696 if ($player) array_push($entries_inline, $player);
3697
3698 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3699 # $filename . " (" . $ctype . ")" . "</a>";
3700
3701 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
3702 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
3703
3704 array_push($entries_html, $entry);
3705
3706 $entry = array();
3707
3708 $entry["type"] = $ctype;
3709 $entry["filename"] = $filename;
3710 $entry["url"] = $url;
3711
3712 array_push($entries, $entry);
3713 }
3714
3715 if ($_SESSION['uid'] && !get_pref($link, "STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
3716 if ($always_display_enclosures ||
3717 !preg_match("/<img/i", $article_content)) {
3718
3719 foreach ($entries as $entry) {
3720
3721 if (preg_match("/image/", $entry["type"]) ||
3722 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
3723
3724 if (!$hide_images) {
3725 $rv .= "<p><img
3726 alt=\"".htmlspecialchars($entry["filename"])."\"
3727 src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
3728 } else {
3729 $rv .= "<p><a target=\"_blank\"
3730 href=\"".htmlspecialchars($entry["url"])."\"
3731 >" .htmlspecialchars($entry["url"]) . "</a></p>";
3732
3733 }
3734 }
3735 }
3736 }
3737 }
3738
3739 if (count($entries_inline) > 0) {
3740 $rv .= "<hr clear='both'/>";
3741 foreach ($entries_inline as $entry) { $rv .= $entry; };
3742 $rv .= "<hr clear='both'/>";
3743 }
3744
3745 $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
3746 "<option value=''>" . __('Attachments')."</option>";
3747
3748 foreach ($entries as $entry) {
3749 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "</option>";
3750
3751 };
3752
3753 $rv .= "</select>";
3754 }
3755
3756 return $rv;
3757 }
3758
3759 function getLastArticleId($link) {
3760 $result = db_query($link, "SELECT MAX(ref_id) AS id FROM ttrss_user_entries
3761 WHERE owner_uid = " . $_SESSION["uid"]);
3762
3763 if (db_num_rows($result) == 1) {
3764 return db_fetch_result($result, 0, "id");
3765 } else {
3766 return -1;
3767 }
3768 }
3769
3770 function build_url($parts) {
3771 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
3772 }
3773
3774 /**
3775 * Converts a (possibly) relative URL to a absolute one.
3776 *
3777 * @param string $url Base URL (i.e. from where the document is)
3778 * @param string $rel_url Possibly relative URL in the document
3779 *
3780 * @return string Absolute URL
3781 */
3782 function rewrite_relative_url($url, $rel_url) {
3783 if (strpos($rel_url, "magnet:") === 0) {
3784 return $rel_url;
3785 } else if (strpos($rel_url, "://") !== false) {
3786 return $rel_url;
3787 } else if (strpos($rel_url, "//") === 0) {
3788 # protocol-relative URL (rare but they exist)
3789 return $rel_url;
3790 } else if (strpos($rel_url, "/") === 0)
3791 {
3792 $parts = parse_url($url);
3793 $parts['path'] = $rel_url;
3794
3795 return build_url($parts);
3796
3797 } else {
3798 $parts = parse_url($url);
3799 if (!isset($parts['path'])) {
3800 $parts['path'] = '/';
3801 }
3802 $dir = $parts['path'];
3803 if (substr($dir, -1) !== '/') {
3804 $dir = dirname($parts['path']);
3805 $dir !== '/' && $dir .= '/';
3806 }
3807 $parts['path'] = $dir . $rel_url;
3808
3809 return build_url($parts);
3810 }
3811 }
3812
3813 function sphinx_search($query, $offset = 0, $limit = 30) {
3814 require_once 'lib/sphinxapi.php';
3815
3816 $sphinxClient = new SphinxClient();
3817
3818 $sphinxClient->SetServer('localhost', 9312);
3819 $sphinxClient->SetConnectTimeout(1);
3820
3821 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
3822 'feed_title' => 20));
3823
3824 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2);
3825 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
3826 $sphinxClient->SetLimits($offset, $limit, 1000);
3827 $sphinxClient->SetArrayResult(false);
3828 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
3829
3830 $result = $sphinxClient->Query($query, SPHINX_INDEX);
3831
3832 $ids = array();
3833
3834 if (is_array($result['matches'])) {
3835 foreach (array_keys($result['matches']) as $int_id) {
3836 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
3837 array_push($ids, $ref_id);
3838 }
3839 }
3840
3841 return $ids;
3842 }
3843
3844 function cleanup_tags($link, $days = 14, $limit = 1000) {
3845
3846 if (DB_TYPE == "pgsql") {
3847 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
3848 } else if (DB_TYPE == "mysql") {
3849 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
3850 }
3851
3852 $tags_deleted = 0;
3853
3854 while ($limit > 0) {
3855 $limit_part = 500;
3856
3857 $query = "SELECT ttrss_tags.id AS id
3858 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
3859 WHERE post_int_id = int_id AND $interval_query AND
3860 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
3861
3862 $result = db_query($link, $query);
3863
3864 $ids = array();
3865
3866 while ($line = db_fetch_assoc($result)) {
3867 array_push($ids, $line['id']);
3868 }
3869
3870 if (count($ids) > 0) {
3871 $ids = join(",", $ids);
3872
3873 $tmp_result = db_query($link, "DELETE FROM ttrss_tags WHERE id IN ($ids)");
3874 $tags_deleted += db_affected_rows($link, $tmp_result);
3875 } else {
3876 break;
3877 }
3878
3879 $limit -= $limit_part;
3880 }
3881
3882 return $tags_deleted;
3883 }
3884
3885 function print_user_stylesheet($link) {
3886 $value = get_pref($link, 'USER_STYLESHEET');
3887
3888 if ($value) {
3889 print "<style type=\"text/css\">";
3890 print str_replace("<br/>", "\n", $value);
3891 print "</style>";
3892 }
3893
3894 }
3895
3896 function rewrite_urls($html) {
3897 libxml_use_internal_errors(true);
3898
3899 $charset_hack = '<head>
3900 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
3901 </head>';
3902
3903 $doc = new DOMDocument();
3904 $doc->loadHTML($charset_hack . $html);
3905 $xpath = new DOMXPath($doc);
3906
3907 $entries = $xpath->query('//*/text()');
3908
3909 foreach ($entries as $entry) {
3910 if (strstr($entry->wholeText, "://") !== false) {
3911 $text = preg_replace("/((?<!=.)((http|https|ftp)+):\/\/[^ ,!]+)/i",
3912 "<a target=\"_blank\" href=\"\\1\">\\1</a>", $entry->wholeText);
3913
3914 if ($text != $entry->wholeText) {
3915 $cdoc = new DOMDocument();
3916 $cdoc->loadHTML($charset_hack . $text);
3917
3918
3919 foreach ($cdoc->childNodes as $cnode) {
3920 $cnode = $doc->importNode($cnode, true);
3921
3922 if ($cnode) {
3923 $entry->parentNode->insertBefore($cnode);
3924 }
3925 }
3926
3927 $entry->parentNode->removeChild($entry);
3928
3929 }
3930 }
3931 }
3932
3933 $node = $doc->getElementsByTagName('body')->item(0);
3934
3935 // http://tt-rss.org/forum/viewtopic.php?f=1&t=970
3936 if ($node)
3937 return $doc->saveXML($node);
3938 else
3939 return $html;
3940 }
3941
3942 function filter_to_sql($link, $filter, $owner_uid) {
3943 $query = array();
3944
3945 if (DB_TYPE == "pgsql")
3946 $reg_qpart = "~";
3947 else
3948 $reg_qpart = "REGEXP";
3949
3950 foreach ($filter["rules"] AS $rule) {
3951 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
3952 $rule['reg_exp']) !== FALSE;
3953
3954 if ($regexp_valid) {
3955
3956 $rule['reg_exp'] = db_escape_string($link, $rule['reg_exp']);
3957
3958 switch ($rule["type"]) {
3959 case "title":
3960 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3961 $rule['reg_exp'] . "')";
3962 break;
3963 case "content":
3964 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
3965 $rule['reg_exp'] . "')";
3966 break;
3967 case "both":
3968 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3969 $rule['reg_exp'] . "') OR LOWER(" .
3970 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
3971 break;
3972 case "tag":
3973 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
3974 $rule['reg_exp'] . "')";
3975 break;
3976 case "link":
3977 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
3978 $rule['reg_exp'] . "')";
3979 break;
3980 case "author":
3981 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
3982 $rule['reg_exp'] . "')";
3983 break;
3984 }
3985
3986 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
3987
3988 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
3989 $qpart .= " AND feed_id = " . db_escape_string($link, $rule["feed_id"]);
3990 }
3991
3992 if (isset($rule["cat_id"])) {
3993
3994 if ($rule["cat_id"] > 0) {
3995 $children = getChildCategories($link, $rule["cat_id"], $owner_uid);
3996 array_push($children, $rule["cat_id"]);
3997
3998 $children = join(",", $children);
3999
4000 $cat_qpart = "cat_id IN ($children)";
4001 } else {
4002 $cat_qpart = "cat_id IS NULL";
4003 }
4004
4005 $qpart .= " AND $cat_qpart";
4006 }
4007
4008 array_push($query, "($qpart)");
4009
4010 }
4011 }
4012
4013 if (count($query) > 0) {
4014 $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
4015 } else {
4016 $fullquery = "(false)";
4017 }
4018
4019 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
4020
4021 return $fullquery;
4022 }
4023
4024 if (!function_exists('gzdecode')) {
4025 function gzdecode($string) { // no support for 2nd argument
4026 return file_get_contents('compress.zlib://data:who/cares;base64,'.
4027 base64_encode($string));
4028 }
4029 }
4030
4031 function get_random_bytes($length) {
4032 if (function_exists('openssl_random_pseudo_bytes')) {
4033 return openssl_random_pseudo_bytes($length);
4034 } else {
4035 $output = "";
4036
4037 for ($i = 0; $i < $length; $i++)
4038 $output .= chr(mt_rand(0, 255));
4039
4040 return $output;
4041 }
4042 }
4043
4044 function read_stdin() {
4045 $fp = fopen("php://stdin", "r");
4046
4047 if ($fp) {
4048 $line = trim(fgets($fp));
4049 fclose($fp);
4050 return $line;
4051 }
4052
4053 return null;
4054 }
4055
4056 function tmpdirname($path, $prefix) {
4057 // Use PHP's tmpfile function to create a temporary
4058 // directory name. Delete the file and keep the name.
4059 $tempname = tempnam($path,$prefix);
4060 if (!$tempname)
4061 return false;
4062
4063 if (!unlink($tempname))
4064 return false;
4065
4066 return $tempname;
4067 }
4068
4069 function getFeedCategory($link, $feed) {
4070 $result = db_query($link, "SELECT cat_id FROM ttrss_feeds
4071 WHERE id = '$feed'");
4072
4073 if (db_num_rows($result) > 0) {
4074 return db_fetch_result($result, 0, "cat_id");
4075 } else {
4076 return false;
4077 }
4078
4079 }
4080
4081 function implements_interface($class, $interface) {
4082 return in_array($interface, class_implements($class));
4083 }
4084
4085 function geturl($url){
4086
4087 (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');
4088
4089 $curl = curl_init();
4090 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
4091 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
4092 $header[] = "Cache-Control: max-age=0";
4093 $header[] = "Connection: keep-alive";
4094 $header[] = "Keep-Alive: 300";
4095 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
4096 $header[] = "Accept-Language: en-us,en;q=0.5";
4097 $header[] = "Pragma: ";
4098
4099 curl_setopt($curl, CURLOPT_URL, $url);
4100 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
4101 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
4102 curl_setopt($curl, CURLOPT_HEADER, true);
4103 curl_setopt($curl, CURLOPT_REFERER, $url);
4104 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
4105 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
4106 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
4107 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
4108 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
4109
4110 $html = curl_exec($curl);
4111
4112 $status = curl_getinfo($curl);
4113 curl_close($curl);
4114
4115 if($status['http_code']!=200){
4116 if($status['http_code'] == 301 || $status['http_code'] == 302) {
4117 list($header) = explode("\r\n\r\n", $html, 2);
4118 $matches = array();
4119 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
4120 $url = trim(str_replace($matches[1],"",$matches[0]));
4121 $url_parsed = parse_url($url);
4122 return (isset($url_parsed))? geturl($url, $referer):'';
4123 }
4124 $oline='';
4125 foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
4126 $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
4127 # $handle = @fopen('./curl.error.log', 'a');
4128 # fwrite($handle, $line);
4129 return FALSE;
4130 }
4131 return $url;
4132 }
4133
4134 function get_minified_js($files) {
4135 require_once 'lib/jshrink/Minifier.php';
4136
4137 $rv = '';
4138
4139 foreach ($files as $js) {
4140 if (!isset($_GET['debug'])) {
4141 $cached_file = CACHE_DIR . "/js/$js.js";
4142
4143 if (file_exists($cached_file) &&
4144 is_readable($cached_file) &&
4145 filemtime($cached_file) >= filemtime("js/$js.js")) {
4146
4147 $rv .= file_get_contents($cached_file);
4148
4149 } else {
4150 $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
4151 file_put_contents($cached_file, $minified);
4152 $rv .= $minified;
4153 }
4154 } else {
4155 $rv .= file_get_contents("js/$js.js");
4156 }
4157 }
4158
4159 return $rv;
4160 }
4161
4162 function stylesheet_tag($filename) {
4163 $timestamp = filemtime($filename);
4164
4165 echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
4166 }
4167
4168 function javascript_tag($filename) {
4169 $query = "";
4170
4171 if (!(strpos($filename, "?") === FALSE)) {
4172 $query = substr($filename, strpos($filename, "?")+1);
4173 $filename = substr($filename, 0, strpos($filename, "?"));
4174 }
4175
4176 $timestamp = filemtime($filename);
4177
4178 if ($query) $timestamp .= "&$query";
4179
4180 echo "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
4181 }
4182
4183 function calculate_dep_timestamp() {
4184 $files = array_merge(glob("js/*.js"), glob("*.css"));
4185
4186 $max_ts = -1;
4187
4188 foreach ($files as $file) {
4189 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
4190 }
4191
4192 return $max_ts;
4193 }
4194
4195 function T_js_decl($s1, $s2) {
4196 if ($s1 && $s2) {
4197 $s1 = preg_replace("/\n/", "", $s1);
4198 $s2 = preg_replace("/\n/", "", $s2);
4199
4200 $s1 = preg_replace("/\"/", "\\\"", $s1);
4201 $s2 = preg_replace("/\"/", "\\\"", $s2);
4202
4203 return "T_messages[\"$s1\"] = \"$s2\";\n";
4204 }
4205 }
4206
4207 function init_js_translations() {
4208
4209 print 'var T_messages = new Object();
4210
4211 function __(msg) {
4212 if (T_messages[msg]) {
4213 return T_messages[msg];
4214 } else {
4215 return msg;
4216 }
4217 }
4218
4219 function ngettext(msg1, msg2, n) {
4220 return (parseInt(n) > 1) ? msg2 : msg1;
4221 }';
4222
4223 $l10n = _get_reader();
4224
4225 for ($i = 0; $i < $l10n->total; $i++) {
4226 $orig = $l10n->get_original_string($i);
4227 $translation = __($orig);
4228
4229 print T_js_decl($orig, $translation);
4230 }
4231 }
4232
4233 function label_to_feed_id($label) {
4234 return LABEL_BASE_INDEX - 1 - abs($label);
4235 }
4236
4237 function feed_to_label_id($feed) {
4238 return LABEL_BASE_INDEX - 1 + abs($feed);
4239 }
4240
4241 ?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/