]> git.wh0rd.org - tt-rss.git/blob - include/functions.php
git.wh0rd.org / tt-rss.git / blob
? search:


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