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