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


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