]> git.wh0rd.org - tt-rss.git/blob - include/functions.php
git.wh0rd.org / tt-rss.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
blame | history | raw | HEAD
Merge branch 'master' of github.com:gothfox/Tiny-Tiny-RSS
[tt-rss.git] / include / functions.php
1 <?php
2 define('EXPECTED_CONFIG_VERSION', 26);
3 define('SCHEMA_VERSION', 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 array_push($ret_arr, $cv);
1505 }
1506 }
1507
1508 return $ret_arr;
1509 }
1510
1511 function getLabelCounters($descriptions = false) {
1512
1513 $ret_arr = array();
1514
1515 $owner_uid = $_SESSION["uid"];
1516
1517 $result = db_query("SELECT id,caption,COUNT(u1.unread) AS unread,COUNT(u2.unread) AS total
1518 FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON
1519 (ttrss_labels2.id = label_id)
1520 LEFT JOIN ttrss_user_entries AS u1 ON (u1.ref_id = article_id AND u1.unread = true
1521 AND u1.owner_uid = $owner_uid)
1522 LEFT JOIN ttrss_user_entries AS u2 ON (u2.ref_id = article_id AND u2.unread = false
1523 AND u2.owner_uid = $owner_uid)
1524 WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id,
1525 ttrss_labels2.caption");
1526
1527 while ($line = db_fetch_assoc($result)) {
1528
1529 $id = label_to_feed_id($line["id"]);
1530
1531 $cv = array("id" => $id,
1532 "counter" => (int) $line["unread"],
1533 "auxcounter" => (int) $line["total"]);
1534
1535 if ($descriptions)
1536 $cv["description"] = $line["caption"];
1537
1538 array_push($ret_arr, $cv);
1539 }
1540
1541 return $ret_arr;
1542 }
1543
1544 function getFeedCounters($active_feed = false) {
1545
1546 $ret_arr = array();
1547
1548 $query = "SELECT ttrss_feeds.id,
1549 ttrss_feeds.title,
1550 ".SUBSTRING_FOR_DATE."(ttrss_feeds.last_updated,1,19) AS last_updated,
1551 last_error, value AS count
1552 FROM ttrss_feeds, ttrss_counters_cache
1553 WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
1554 AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
1555 AND ttrss_counters_cache.feed_id = id";
1556
1557 $result = db_query($query);
1558 $fctrs_modified = false;
1559
1560 while ($line = db_fetch_assoc($result)) {
1561
1562 $id = $line["id"];
1563 $count = $line["count"];
1564 $last_error = htmlspecialchars($line["last_error"]);
1565
1566 $last_updated = make_local_datetime($line['last_updated'], false);
1567
1568 $has_img = feed_has_icon($id);
1569
1570 if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2)
1571 $last_updated = '';
1572
1573 $cv = array("id" => $id,
1574 "updated" => $last_updated,
1575 "counter" => (int) $count,
1576 "has_img" => (int) $has_img);
1577
1578 if ($last_error)
1579 $cv["error"] = $last_error;
1580
1581 // if (get_pref('EXTENDED_FEEDLIST'))
1582 // $cv["xmsg"] = getFeedArticles($id)." ".__("total");
1583
1584 if ($active_feed && $id == $active_feed)
1585 $cv["title"] = truncate_string($line["title"], 30);
1586
1587 array_push($ret_arr, $cv);
1588
1589 }
1590
1591 return $ret_arr;
1592 }
1593
1594 function get_pgsql_version() {
1595 $result = db_query("SELECT version() AS version");
1596 $version = explode(" ", db_fetch_result($result, 0, "version"));
1597 return $version[1];
1598 }
1599
1600 /**
1601 * @return array (code => Status code, message => error message if available)
1602 *
1603 * 0 - OK, Feed already exists
1604 * 1 - OK, Feed added
1605 * 2 - Invalid URL
1606 * 3 - URL content is HTML, no feeds available
1607 * 4 - URL content is HTML which contains multiple feeds.
1608 * Here you should call extractfeedurls in rpc-backend
1609 * to get all possible feeds.
1610 * 5 - Couldn't download the URL content.
1611 * 6 - Content is an invalid XML.
1612 */
1613 function subscribe_to_feed($url, $cat_id = 0,
1614 $auth_login = '', $auth_pass = '') {
1615
1616 global $fetch_last_error;
1617
1618 require_once "include/rssfuncs.php";
1619
1620 $url = fix_url($url);
1621
1622 if (!$url || !validate_feed_url($url)) return array("code" => 2);
1623
1624 $contents = @fetch_file_contents($url, false, $auth_login, $auth_pass);
1625
1626 if (!$contents) {
1627 return array("code" => 5, "message" => $fetch_last_error);
1628 }
1629
1630 if (is_html($contents)) {
1631 $feedUrls = get_feeds_from_html($url, $contents);
1632
1633 if (count($feedUrls) == 0) {
1634 return array("code" => 3);
1635 } else if (count($feedUrls) > 1) {
1636 return array("code" => 4, "feeds" => $feedUrls);
1637 }
1638 //use feed url as new URL
1639 $url = key($feedUrls);
1640 }
1641
1642 /* libxml_use_internal_errors(true);
1643 $doc = new DOMDocument();
1644 $doc->loadXML($contents);
1645 $error = libxml_get_last_error();
1646 libxml_clear_errors();
1647
1648 if ($error) {
1649 $error_message = format_libxml_error($error);
1650
1651 return array("code" => 6, "message" => $error_message);
1652 } */
1653
1654 if ($cat_id == "0" || !$cat_id) {
1655 $cat_qpart = "NULL";
1656 } else {
1657 $cat_qpart = "'$cat_id'";
1658 }
1659
1660 $result = db_query(
1661 "SELECT id FROM ttrss_feeds
1662 WHERE feed_url = '$url' AND owner_uid = ".$_SESSION["uid"]);
1663
1664 if (strlen(FEED_CRYPT_KEY) > 0) {
1665 require_once "crypt.php";
1666 $auth_pass = substr(encrypt_string($auth_pass), 0, 250);
1667 $auth_pass_encrypted = 'true';
1668 } else {
1669 $auth_pass_encrypted = 'false';
1670 }
1671
1672 $auth_pass = db_escape_string($auth_pass);
1673
1674 if (db_num_rows($result) == 0) {
1675 $result = db_query(
1676 "INSERT INTO ttrss_feeds
1677 (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method,auth_pass_encrypted)
1678 VALUES ('".$_SESSION["uid"]."', '$url',
1679 '[Unknown]', $cat_qpart, '$auth_login', '$auth_pass', 0, $auth_pass_encrypted)");
1680
1681 $result = db_query(
1682 "SELECT id FROM ttrss_feeds WHERE feed_url = '$url'
1683 AND owner_uid = " . $_SESSION["uid"]);
1684
1685 $feed_id = db_fetch_result($result, 0, "id");
1686
1687 if ($feed_id) {
1688 update_rss_feed($feed_id, true);
1689 }
1690
1691 return array("code" => 1);
1692 } else {
1693 return array("code" => 0);
1694 }
1695 }
1696
1697 function print_feed_select($id, $default_id = "",
1698 $attributes = "", $include_all_feeds = true,
1699 $root_id = false, $nest_level = 0) {
1700
1701 if (!$root_id) {
1702 print "<select id=\"$id\" name=\"$id\" $attributes>";
1703 if ($include_all_feeds) {
1704 $is_selected = ("0" == $default_id) ? "selected=\"1\"" : "";
1705 print "<option $is_selected value=\"0\">".__('All feeds')."</option>";
1706 }
1707 }
1708
1709 if (get_pref('ENABLE_FEED_CATS')) {
1710
1711 if ($root_id)
1712 $parent_qpart = "parent_cat = '$root_id'";
1713 else
1714 $parent_qpart = "parent_cat IS NULL";
1715
1716 $result = db_query("SELECT id,title,
1717 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1718 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1719 FROM ttrss_feed_categories
1720 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1721
1722 while ($line = db_fetch_assoc($result)) {
1723
1724 for ($i = 0; $i < $nest_level; $i++)
1725 $line["title"] = " - " . $line["title"];
1726
1727 $is_selected = ("CAT:".$line["id"] == $default_id) ? "selected=\"1\"" : "";
1728
1729 printf("<option $is_selected value='CAT:%d'>%s</option>",
1730 $line["id"], htmlspecialchars($line["title"]));
1731
1732 if ($line["num_children"] > 0)
1733 print_feed_select($id, $default_id, $attributes,
1734 $include_all_feeds, $line["id"], $nest_level+1);
1735
1736 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1737 WHERE cat_id = '".$line["id"]."' AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1738
1739 while ($fline = db_fetch_assoc($feed_result)) {
1740 $is_selected = ($fline["id"] == $default_id) ? "selected=\"1\"" : "";
1741
1742 $fline["title"] = " + " . $fline["title"];
1743
1744 for ($i = 0; $i < $nest_level; $i++)
1745 $fline["title"] = " - " . $fline["title"];
1746
1747 printf("<option $is_selected value='%d'>%s</option>",
1748 $fline["id"], htmlspecialchars($fline["title"]));
1749 }
1750 }
1751
1752 if (!$root_id) {
1753 $default_is_cat = ($default_id == "CAT:0");
1754 $is_selected = $default_is_cat ? "selected=\"1\"" : "";
1755
1756 printf("<option $is_selected value='CAT:0'>%s</option>",
1757 __("Uncategorized"));
1758
1759 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1760 WHERE cat_id IS NULL AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1761
1762 while ($fline = db_fetch_assoc($feed_result)) {
1763 $is_selected = ($fline["id"] == $default_id && !$default_is_cat) ? "selected=\"1\"" : "";
1764
1765 $fline["title"] = " + " . $fline["title"];
1766
1767 for ($i = 0; $i < $nest_level; $i++)
1768 $fline["title"] = " - " . $fline["title"];
1769
1770 printf("<option $is_selected value='%d'>%s</option>",
1771 $fline["id"], htmlspecialchars($fline["title"]));
1772 }
1773 }
1774
1775 } else {
1776 $result = db_query("SELECT id,title FROM ttrss_feeds
1777 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1778
1779 while ($line = db_fetch_assoc($result)) {
1780
1781 $is_selected = ($line["id"] == $default_id) ? "selected=\"1\"" : "";
1782
1783 printf("<option $is_selected value='%d'>%s</option>",
1784 $line["id"], htmlspecialchars($line["title"]));
1785 }
1786 }
1787
1788 if (!$root_id) {
1789 print "</select>";
1790 }
1791 }
1792
1793 function print_feed_cat_select($id, $default_id,
1794 $attributes, $include_all_cats = true, $root_id = false, $nest_level = 0) {
1795
1796 if (!$root_id) {
1797 print "<select id=\"$id\" name=\"$id\" default=\"$default_id\" onchange=\"catSelectOnChange(this)\" $attributes>";
1798 }
1799
1800 if ($root_id)
1801 $parent_qpart = "parent_cat = '$root_id'";
1802 else
1803 $parent_qpart = "parent_cat IS NULL";
1804
1805 $result = db_query("SELECT id,title,
1806 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1807 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1808 FROM ttrss_feed_categories
1809 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1810
1811 while ($line = db_fetch_assoc($result)) {
1812 if ($line["id"] == $default_id) {
1813 $is_selected = "selected=\"1\"";
1814 } else {
1815 $is_selected = "";
1816 }
1817
1818 for ($i = 0; $i < $nest_level; $i++)
1819 $line["title"] = " - " . $line["title"];
1820
1821 if ($line["title"])
1822 printf("<option $is_selected value='%d'>%s</option>",
1823 $line["id"], htmlspecialchars($line["title"]));
1824
1825 if ($line["num_children"] > 0)
1826 print_feed_cat_select($id, $default_id, $attributes,
1827 $include_all_cats, $line["id"], $nest_level+1);
1828 }
1829
1830 if (!$root_id) {
1831 if ($include_all_cats) {
1832 if (db_num_rows($result) > 0) {
1833 print "<option disabled=\"1\">--------</option>";
1834 }
1835
1836 if ($default_id == 0) {
1837 $is_selected = "selected=\"1\"";
1838 } else {
1839 $is_selected = "";
1840 }
1841
1842 print "<option $is_selected value=\"0\">".__('Uncategorized')."</option>";
1843 }
1844 print "</select>";
1845 }
1846 }
1847
1848 function checkbox_to_sql_bool($val) {
1849 return ($val == "on") ? "true" : "false";
1850 }
1851
1852 function getFeedCatTitle($id) {
1853 if ($id == -1) {
1854 return __("Special");
1855 } else if ($id < LABEL_BASE_INDEX) {
1856 return __("Labels");
1857 } else if ($id > 0) {
1858 $result = db_query("SELECT ttrss_feed_categories.title
1859 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1860 cat_id = ttrss_feed_categories.id");
1861 if (db_num_rows($result) == 1) {
1862 return db_fetch_result($result, 0, "title");
1863 } else {
1864 return __("Uncategorized");
1865 }
1866 } else {
1867 return "getFeedCatTitle($id) failed";
1868 }
1869
1870 }
1871
1872 function getFeedIcon($id) {
1873 switch ($id) {
1874 case 0:
1875 return "images/archive.png";
1876 break;
1877 case -1:
1878 return "images/star.png";
1879 break;
1880 case -2:
1881 return "images/feed.png";
1882 break;
1883 case -3:
1884 return "images/fresh.png";
1885 break;
1886 case -4:
1887 return "images/folder.png";
1888 break;
1889 case -6:
1890 return "images/time.png";
1891 break;
1892 default:
1893 if ($id < LABEL_BASE_INDEX) {
1894 return "images/label.png";
1895 } else {
1896 if (file_exists(ICONS_DIR . "/$id.ico"))
1897 return ICONS_URL . "/$id.ico";
1898 }
1899 break;
1900 }
1901
1902 return false;
1903 }
1904
1905 function getFeedTitle($id, $cat = false) {
1906 if ($cat) {
1907 return getCategoryTitle($id);
1908 } else if ($id == -1) {
1909 return __("Starred articles");
1910 } else if ($id == -2) {
1911 return __("Published articles");
1912 } else if ($id == -3) {
1913 return __("Fresh articles");
1914 } else if ($id == -4) {
1915 return __("All articles");
1916 } else if ($id === 0 || $id === "0") {
1917 return __("Archived articles");
1918 } else if ($id == -6) {
1919 return __("Recently read");
1920 } else if ($id < LABEL_BASE_INDEX) {
1921 $label_id = feed_to_label_id($id);
1922 $result = db_query("SELECT caption FROM ttrss_labels2 WHERE id = '$label_id'");
1923 if (db_num_rows($result) == 1) {
1924 return db_fetch_result($result, 0, "caption");
1925 } else {
1926 return "Unknown label ($label_id)";
1927 }
1928
1929 } else if (is_numeric($id) && $id > 0) {
1930 $result = db_query("SELECT title FROM ttrss_feeds WHERE id = '$id'");
1931 if (db_num_rows($result) == 1) {
1932 return db_fetch_result($result, 0, "title");
1933 } else {
1934 return "Unknown feed ($id)";
1935 }
1936 } else {
1937 return $id;
1938 }
1939 }
1940
1941 function make_init_params() {
1942 $params = array();
1943
1944 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
1945 "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
1946 "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
1947 "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
1948
1949 $params[strtolower($param)] = (int) get_pref($param);
1950 }
1951
1952 $params["icons_url"] = ICONS_URL;
1953 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
1954 $params["default_view_mode"] = get_pref("_DEFAULT_VIEW_MODE");
1955 $params["default_view_limit"] = (int) get_pref("_DEFAULT_VIEW_LIMIT");
1956 $params["default_view_order_by"] = get_pref("_DEFAULT_VIEW_ORDER_BY");
1957 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
1958 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
1959
1960 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
1961 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1962
1963 $max_feed_id = db_fetch_result($result, 0, "mid");
1964 $num_feeds = db_fetch_result($result, 0, "nf");
1965
1966 $params["max_feed_id"] = (int) $max_feed_id;
1967 $params["num_feeds"] = (int) $num_feeds;
1968
1969 $params["hotkeys"] = get_hotkeys_map();
1970
1971 $params["csrf_token"] = $_SESSION["csrf_token"];
1972 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
1973
1974 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
1975
1976 return $params;
1977 }
1978
1979 function get_hotkeys_info() {
1980 $hotkeys = array(
1981 __("Navigation") => array(
1982 "next_feed" => __("Open next feed"),
1983 "prev_feed" => __("Open previous feed"),
1984 "next_article" => __("Open next article"),
1985 "prev_article" => __("Open previous article"),
1986 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
1987 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
1988 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
1989 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
1990 "search_dialog" => __("Show search dialog")),
1991 __("Article") => array(
1992 "toggle_mark" => __("Toggle starred"),
1993 "toggle_publ" => __("Toggle published"),
1994 "toggle_unread" => __("Toggle unread"),
1995 "edit_tags" => __("Edit tags"),
1996 "dismiss_selected" => __("Dismiss selected"),
1997 "dismiss_read" => __("Dismiss read"),
1998 "open_in_new_window" => __("Open in new window"),
1999 "catchup_below" => __("Mark below as read"),
2000 "catchup_above" => __("Mark above as read"),
2001 "article_scroll_down" => __("Scroll down"),
2002 "article_scroll_up" => __("Scroll up"),
2003 "select_article_cursor" => __("Select article under cursor"),
2004 "email_article" => __("Email article"),
2005 "close_article" => __("Close/collapse article"),
2006 "toggle_expand" => __("Toggle article expansion (combined mode)"),
2007 "toggle_widescreen" => __("Toggle widescreen mode"),
2008 "toggle_embed_original" => __("Toggle embed original")),
2009 __("Article selection") => array(
2010 "select_all" => __("Select all articles"),
2011 "select_unread" => __("Select unread"),
2012 "select_marked" => __("Select starred"),
2013 "select_published" => __("Select published"),
2014 "select_invert" => __("Invert selection"),
2015 "select_none" => __("Deselect everything")),
2016 __("Feed") => array(
2017 "feed_refresh" => __("Refresh current feed"),
2018 "feed_unhide_read" => __("Un/hide read feeds"),
2019 "feed_subscribe" => __("Subscribe to feed"),
2020 "feed_edit" => __("Edit feed"),
2021 "feed_catchup" => __("Mark as read"),
2022 "feed_reverse" => __("Reverse headlines"),
2023 "feed_debug_update" => __("Debug feed update"),
2024 "catchup_all" => __("Mark all feeds as read"),
2025 "cat_toggle_collapse" => __("Un/collapse current category"),
2026 "toggle_combined_mode" => __("Toggle combined mode"),
2027 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
2028 __("Go to") => array(
2029 "goto_all" => __("All articles"),
2030 "goto_fresh" => __("Fresh"),
2031 "goto_marked" => __("Starred"),
2032 "goto_published" => __("Published"),
2033 "goto_tagcloud" => __("Tag cloud"),
2034 "goto_prefs" => __("Preferences")),
2035 __("Other") => array(
2036 "create_label" => __("Create label"),
2037 "create_filter" => __("Create filter"),
2038 "collapse_sidebar" => __("Un/collapse sidebar"),
2039 "help_dialog" => __("Show help dialog"))
2040 );
2041
2042 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_INFO) as $plugin) {
2043 $hotkeys = $plugin->hook_hotkey_info($hotkeys);
2044 }
2045
2046 return $hotkeys;
2047 }
2048
2049 function get_hotkeys_map() {
2050 $hotkeys = array(
2051 // "navigation" => array(
2052 "k" => "next_feed",
2053 "j" => "prev_feed",
2054 "n" => "next_article",
2055 "p" => "prev_article",
2056 "(38)|up" => "prev_article",
2057 "(40)|down" => "next_article",
2058 // "^(38)|Ctrl-up" => "prev_article_noscroll",
2059 // "^(40)|Ctrl-down" => "next_article_noscroll",
2060 "(191)|/" => "search_dialog",
2061 // "article" => array(
2062 "s" => "toggle_mark",
2063 "*s" => "toggle_publ",
2064 "u" => "toggle_unread",
2065 "*t" => "edit_tags",
2066 "*d" => "dismiss_selected",
2067 "*x" => "dismiss_read",
2068 "o" => "open_in_new_window",
2069 "c p" => "catchup_below",
2070 "c n" => "catchup_above",
2071 "*n" => "article_scroll_down",
2072 "*p" => "article_scroll_up",
2073 "*(38)|Shift+up" => "article_scroll_up",
2074 "*(40)|Shift+down" => "article_scroll_down",
2075 "a *w" => "toggle_widescreen",
2076 "a e" => "toggle_embed_original",
2077 "e" => "email_article",
2078 "a q" => "close_article",
2079 // "article_selection" => array(
2080 "a a" => "select_all",
2081 "a u" => "select_unread",
2082 "a *u" => "select_marked",
2083 "a p" => "select_published",
2084 "a i" => "select_invert",
2085 "a n" => "select_none",
2086 // "feed" => array(
2087 "f r" => "feed_refresh",
2088 "f a" => "feed_unhide_read",
2089 "f s" => "feed_subscribe",
2090 "f e" => "feed_edit",
2091 "f q" => "feed_catchup",
2092 "f x" => "feed_reverse",
2093 "f *d" => "feed_debug_update",
2094 "f *c" => "toggle_combined_mode",
2095 "f c" => "toggle_cdm_expanded",
2096 "*q" => "catchup_all",
2097 "x" => "cat_toggle_collapse",
2098 // "goto" => array(
2099 "g a" => "goto_all",
2100 "g f" => "goto_fresh",
2101 "g s" => "goto_marked",
2102 "g p" => "goto_published",
2103 "g t" => "goto_tagcloud",
2104 "g *p" => "goto_prefs",
2105 // "other" => array(
2106 "(9)|Tab" => "select_article_cursor", // tab
2107 "c l" => "create_label",
2108 "c f" => "create_filter",
2109 "c s" => "collapse_sidebar",
2110 "^(191)|Ctrl+/" => "help_dialog",
2111 );
2112
2113 if (get_pref('COMBINED_DISPLAY_MODE')) {
2114 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
2115 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
2116 }
2117
2118 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_MAP) as $plugin) {
2119 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
2120 }
2121
2122 $prefixes = array();
2123
2124 foreach (array_keys($hotkeys) as $hotkey) {
2125 $pair = explode(" ", $hotkey, 2);
2126
2127 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
2128 array_push($prefixes, $pair[0]);
2129 }
2130 }
2131
2132 return array($prefixes, $hotkeys);
2133 }
2134
2135 function make_runtime_info() {
2136 $data = array();
2137
2138 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2139 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2140
2141 $max_feed_id = db_fetch_result($result, 0, "mid");
2142 $num_feeds = db_fetch_result($result, 0, "nf");
2143
2144 $data["max_feed_id"] = (int) $max_feed_id;
2145 $data["num_feeds"] = (int) $num_feeds;
2146
2147 $data['last_article_id'] = getLastArticleId();
2148 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
2149
2150 $data['dep_ts'] = calculate_dep_timestamp();
2151 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
2152
2153 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
2154
2155 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
2156
2157 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
2158
2159 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
2160
2161 if ($stamp) {
2162 $stamp_delta = time() - $stamp;
2163
2164 if ($stamp_delta > 1800) {
2165 $stamp_check = 0;
2166 } else {
2167 $stamp_check = 1;
2168 $_SESSION["daemon_stamp_check"] = time();
2169 }
2170
2171 $data['daemon_stamp_ok'] = $stamp_check;
2172
2173 $stamp_fmt = date("Y.m.d, G:i", $stamp);
2174
2175 $data['daemon_stamp'] = $stamp_fmt;
2176 }
2177 }
2178 }
2179
2180 if ($_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
2181 $new_version_details = @check_for_update();
2182
2183 $data['new_version_available'] = (int) ($new_version_details != false);
2184
2185 $_SESSION["last_version_check"] = time();
2186 $_SESSION["version_data"] = $new_version_details;
2187 }
2188
2189 return $data;
2190 }
2191
2192 function search_to_sql($search) {
2193
2194 $search_query_part = "";
2195
2196 $keywords = explode(" ", $search);
2197 $query_keywords = array();
2198
2199 foreach ($keywords as $k) {
2200 if (strpos($k, "-") === 0) {
2201 $k = substr($k, 1);
2202 $not = "NOT";
2203 } else {
2204 $not = "";
2205 }
2206
2207 $commandpair = explode(":", mb_strtolower($k), 2);
2208
2209 switch ($commandpair[0]) {
2210 case "title":
2211 if ($commandpair[1]) {
2212 array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
2213 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2214 } else {
2215 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2216 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2217 }
2218 break;
2219 case "author":
2220 if ($commandpair[1]) {
2221 array_push($query_keywords, "($not (LOWER(author) LIKE '%".
2222 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2223 } else {
2224 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2225 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2226 }
2227 break;
2228 case "note":
2229 if ($commandpair[1]) {
2230 if ($commandpair[1] == "true")
2231 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
2232 else if ($commandpair[1] == "false")
2233 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
2234 else
2235 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
2236 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2237 } else {
2238 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2239 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2240 }
2241 break;
2242 case "star":
2243
2244 if ($commandpair[1]) {
2245 if ($commandpair[1] == "true")
2246 array_push($query_keywords, "($not (marked = true))");
2247 else
2248 array_push($query_keywords, "($not (marked = false))");
2249 } else {
2250 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2251 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2252 }
2253 break;
2254 case "pub":
2255 if ($commandpair[1]) {
2256 if ($commandpair[1] == "true")
2257 array_push($query_keywords, "($not (published = true))");
2258 else
2259 array_push($query_keywords, "($not (published = false))");
2260
2261 } else {
2262 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2263 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2264 }
2265 break;
2266 default:
2267 if (strpos($k, "@") === 0) {
2268
2269 $user_tz_string = get_pref('USER_TIMEZONE', $_SESSION['uid']);
2270 $orig_ts = strtotime(substr($k, 1));
2271 $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
2272
2273 //$k = date("Y-m-d", strtotime(substr($k, 1)));
2274
2275 array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
2276 } else {
2277 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2278 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2279 }
2280 }
2281 }
2282
2283 $search_query_part = implode("AND", $query_keywords);
2284
2285 return $search_query_part;
2286 }
2287
2288 function getParentCategories($cat, $owner_uid) {
2289 $rv = array();
2290
2291 $result = db_query("SELECT parent_cat FROM ttrss_feed_categories
2292 WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
2293
2294 while ($line = db_fetch_assoc($result)) {
2295 array_push($rv, $line["parent_cat"]);
2296 $rv = array_merge($rv, getParentCategories($line["parent_cat"], $owner_uid));
2297 }
2298
2299 return $rv;
2300 }
2301
2302 function getChildCategories($cat, $owner_uid) {
2303 $rv = array();
2304
2305 $result = db_query("SELECT id FROM ttrss_feed_categories
2306 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
2307
2308 while ($line = db_fetch_assoc($result)) {
2309 array_push($rv, $line["id"]);
2310 $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
2311 }
2312
2313 return $rv;
2314 }
2315
2316 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) {
2317
2318 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2319
2320 $ext_tables_part = "";
2321
2322 if ($search) {
2323
2324 if (SPHINX_ENABLED) {
2325 $ids = join(",", @sphinx_search($search, 0, 500));
2326
2327 if ($ids)
2328 $search_query_part = "ref_id IN ($ids) AND ";
2329 else
2330 $search_query_part = "ref_id = -1 AND ";
2331
2332 } else {
2333 $search_query_part = search_to_sql($search);
2334 $search_query_part .= " AND ";
2335 }
2336
2337 } else {
2338 $search_query_part = "";
2339 }
2340
2341 if ($filter) {
2342
2343 if (DB_TYPE == "pgsql") {
2344 $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
2345 } else {
2346 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
2347 }
2348
2349 $override_order = "updated DESC";
2350
2351 $filter_query_part = filter_to_sql($filter, $owner_uid);
2352
2353 // Try to check if SQL regexp implementation chokes on a valid regexp
2354
2355
2356 $result = db_query("SELECT true AS true_val FROM ttrss_entries,
2357 ttrss_user_entries, ttrss_feeds
2358 WHERE $filter_query_part LIMIT 1", false);
2359
2360 if ($result) {
2361 $test = db_fetch_result($result, 0, "true_val");
2362
2363 if (!$test) {
2364 $filter_query_part = "false AND";
2365 } else {
2366 $filter_query_part .= " AND";
2367 }
2368 } else {
2369 $filter_query_part = "false AND";
2370 }
2371
2372 } else {
2373 $filter_query_part = "";
2374 }
2375
2376 if ($since_id) {
2377 $since_id_part = "ttrss_entries.id > $since_id AND ";
2378 } else {
2379 $since_id_part = "";
2380 }
2381
2382 $view_query_part = "";
2383
2384 if ($view_mode == "adaptive") {
2385 if ($search) {
2386 $view_query_part = " ";
2387 } else if ($feed != -1) {
2388
2389 $unread = getFeedUnread($feed, $cat_view);
2390
2391 if ($cat_view && $feed > 0 && $include_children)
2392 $unread += getCategoryChildrenUnread($feed);
2393
2394 if ($unread > 0)
2395 $view_query_part = " unread = true AND ";
2396
2397 }
2398 }
2399
2400 if ($view_mode == "marked") {
2401 $view_query_part = " marked = true AND ";
2402 }
2403
2404 if ($view_mode == "has_note") {
2405 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
2406 }
2407
2408 if ($view_mode == "published") {
2409 $view_query_part = " published = true AND ";
2410 }
2411
2412 if ($view_mode == "unread" && $feed != -6) {
2413 $view_query_part = " unread = true AND ";
2414 }
2415
2416 if ($limit > 0) {
2417 $limit_query_part = "LIMIT " . $limit;
2418 }
2419
2420 $allow_archived = false;
2421
2422 $vfeed_query_part = "";
2423
2424 // override query strategy and enable feed display when searching globally
2425 if ($search && $search_mode == "all_feeds") {
2426 $query_strategy_part = "true";
2427 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2428 /* tags */
2429 } else if (!is_numeric($feed)) {
2430 $query_strategy_part = "true";
2431 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2432 id = feed_id) as feed_title,";
2433 } else if ($search && $search_mode == "this_cat") {
2434 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2435
2436 if ($feed > 0) {
2437 if ($include_children) {
2438 $subcats = getChildCategories($feed, $owner_uid);
2439 array_push($subcats, $feed);
2440 $cats_qpart = join(",", $subcats);
2441 } else {
2442 $cats_qpart = $feed;
2443 }
2444
2445 $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
2446
2447 } else {
2448 $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
2449 }
2450
2451 } else if ($feed > 0) {
2452
2453 if ($cat_view) {
2454
2455 if ($feed > 0) {
2456 if ($include_children) {
2457 # sub-cats
2458 $subcats = getChildCategories($feed, $owner_uid);
2459
2460 array_push($subcats, $feed);
2461 $query_strategy_part = "cat_id IN (".
2462 implode(",", $subcats).")";
2463
2464 } else {
2465 $query_strategy_part = "cat_id = '$feed'";
2466 }
2467
2468 } else {
2469 $query_strategy_part = "cat_id IS NULL";
2470 }
2471
2472 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2473
2474 } else {
2475 $query_strategy_part = "feed_id = '$feed'";
2476 }
2477 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
2478 $query_strategy_part = "feed_id IS NULL";
2479 $allow_archived = true;
2480 } else if ($feed == 0 && $cat_view) { // uncategorized
2481 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
2482 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2483 } else if ($feed == -1) { // starred virtual feed
2484 $query_strategy_part = "marked = true";
2485 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2486 $allow_archived = true;
2487
2488 if (!$override_order) {
2489 $override_order = "last_marked DESC, date_entered DESC, updated DESC";
2490 }
2491
2492 } else if ($feed == -2) { // published virtual feed OR labels category
2493
2494 if (!$cat_view) {
2495 $query_strategy_part = "published = true";
2496 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2497 $allow_archived = true;
2498
2499 if (!$override_order) {
2500 $override_order = "last_published DESC, date_entered DESC, updated DESC";
2501 }
2502
2503 } else {
2504 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2505
2506 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2507
2508 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
2509 ttrss_user_labels2.article_id = ref_id";
2510
2511 }
2512 } else if ($feed == -6) { // recently read
2513 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
2514 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2515 $allow_archived = true;
2516
2517 if (!$override_order) $override_order = "last_read DESC";
2518 } else if ($feed == -3) { // fresh virtual feed
2519 $query_strategy_part = "unread = true AND score >= 0";
2520
2521 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
2522
2523 if (DB_TYPE == "pgsql") {
2524 $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
2525 } else {
2526 $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
2527 }
2528
2529 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2530 } else if ($feed == -4) { // all articles virtual feed
2531 $allow_archived = true;
2532 $query_strategy_part = "true";
2533 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2534 } else if ($feed <= LABEL_BASE_INDEX) { // labels
2535 $label_id = feed_to_label_id($feed);
2536
2537 $query_strategy_part = "label_id = '$label_id' AND
2538 ttrss_labels2.id = ttrss_user_labels2.label_id AND
2539 ttrss_user_labels2.article_id = ref_id";
2540
2541 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2542 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2543 $allow_archived = true;
2544
2545 } else {
2546 $query_strategy_part = "true";
2547 }
2548
2549 $order_by = "score DESC, date_entered DESC, updated DESC";
2550
2551 if ($view_mode == "unread_first") {
2552 $order_by = "unread DESC, $order_by";
2553 }
2554
2555 if ($override_order) {
2556 $order_by = $override_order;
2557 }
2558
2559 $feed_title = "";
2560
2561 if ($search) {
2562 $feed_title = T_sprintf("Search results: %s", $search);
2563 } else {
2564 if ($cat_view) {
2565 $feed_title = getCategoryTitle($feed);
2566 } else {
2567 if (is_numeric($feed) && $feed > 0) {
2568 $result = db_query("SELECT title,site_url,last_error,last_updated
2569 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
2570
2571 $feed_title = db_fetch_result($result, 0, "title");
2572 $feed_site_url = db_fetch_result($result, 0, "site_url");
2573 $last_error = db_fetch_result($result, 0, "last_error");
2574 $last_updated = db_fetch_result($result, 0, "last_updated");
2575 } else {
2576 $feed_title = getFeedTitle($feed);
2577 }
2578 }
2579 }
2580
2581
2582 $content_query_part = "content, content AS content_preview, ";
2583
2584
2585 if (is_numeric($feed)) {
2586
2587 if ($feed >= 0) {
2588 $feed_kind = "Feeds";
2589 } else {
2590 $feed_kind = "Labels";
2591 }
2592
2593 if ($limit_query_part) {
2594 $offset_query_part = "OFFSET $offset";
2595 }
2596
2597 // proper override_order applied above
2598 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
2599 if (!$override_order) {
2600 $order_by = "ttrss_feeds.title, $order_by";
2601 } else {
2602 $order_by = "ttrss_feeds.title, $override_order";
2603 }
2604 }
2605
2606 if (!$allow_archived) {
2607 $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
2608 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
2609
2610 } else {
2611 $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
2612 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
2613 }
2614
2615 if ($vfeed_query_part)
2616 $vfeed_query_part .= "favicon_avg_color,";
2617
2618 $query = "SELECT DISTINCT
2619 date_entered,
2620 guid,
2621 ttrss_entries.id,ttrss_entries.title,
2622 updated,
2623 label_cache,
2624 tag_cache,
2625 always_display_enclosures,
2626 site_url,
2627 note,
2628 num_comments,
2629 comments,
2630 int_id,
2631 hide_images,
2632 unread,feed_id,marked,published,link,last_read,orig_feed_id,
2633 last_marked, last_published,
2634 $vfeed_query_part
2635 $content_query_part
2636 author,score
2637 FROM
2638 $from_qpart
2639 WHERE
2640 $feed_check_qpart
2641 ttrss_user_entries.ref_id = ttrss_entries.id AND
2642 ttrss_user_entries.owner_uid = '$owner_uid' AND
2643 $search_query_part
2644 $filter_query_part
2645 $view_query_part
2646 $since_id_part
2647 $query_strategy_part ORDER BY $order_by
2648 $limit_query_part $offset_query_part";
2649
2650 if ($_REQUEST["debug"]) print $query;
2651
2652 $result = db_query($query);
2653
2654 } else {
2655 // browsing by tag
2656
2657 $select_qpart = "SELECT DISTINCT " .
2658 "date_entered," .
2659 "guid," .
2660 "note," .
2661 "ttrss_entries.id as id," .
2662 "title," .
2663 "updated," .
2664 "unread," .
2665 "feed_id," .
2666 "orig_feed_id," .
2667 "marked," .
2668 "num_comments, " .
2669 "comments, " .
2670 "tag_cache," .
2671 "label_cache," .
2672 "link," .
2673 "last_read," .
2674 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
2675 "last_marked, last_published, " .
2676 $since_id_part .
2677 $vfeed_query_part .
2678 $content_query_part .
2679 "score ";
2680
2681 $feed_kind = "Tags";
2682 $all_tags = explode(",", $feed);
2683 if ($search_mode == 'any') {
2684 $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
2685 $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
2686 $where_qpart = " WHERE " .
2687 "ref_id = ttrss_entries.id AND " .
2688 "ttrss_user_entries.owner_uid = $owner_uid AND " .
2689 "post_int_id = int_id AND $tag_sql AND " .
2690 $view_query_part .
2691 $search_query_part .
2692 $query_strategy_part . " ORDER BY $order_by " .
2693 $limit_query_part;
2694
2695 } else {
2696 $i = 1;
2697 $sub_selects = array();
2698 $sub_ands = array();
2699 foreach ($all_tags as $term) {
2700 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");
2701 $i++;
2702 }
2703 if ($i > 2) {
2704 $x = 1;
2705 $y = 2;
2706 do {
2707 array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
2708 $x++;
2709 $y++;
2710 } while ($y < $i);
2711 }
2712 array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
2713 array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
2714 $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
2715 $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
2716 }
2717 // error_log("TAG SQL: " . $tag_sql);
2718 // $tag_sql = "tag_name = '$feed'"; DEFAULT way
2719
2720 // error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
2721 $result = db_query($select_qpart . $from_qpart . $where_qpart);
2722 }
2723
2724 return array($result, $feed_title, $feed_site_url, $last_error, $last_updated);
2725
2726 }
2727
2728 function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false) {
2729 if (!$owner) $owner = $_SESSION["uid"];
2730
2731 $res = trim($str); if (!$res) return '';
2732
2733 if (strpos($res, "href=") === false)
2734 $res = rewrite_urls($res);
2735
2736 $charset_hack = '<head>
2737 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
2738 </head>';
2739
2740 $res = trim($res); if (!$res) return '';
2741
2742 libxml_use_internal_errors(true);
2743
2744 $doc = new DOMDocument();
2745 $doc->loadHTML($charset_hack . $res);
2746 $xpath = new DOMXPath($doc);
2747
2748 $entries = $xpath->query('(//a[@href]|//img[@src])');
2749
2750 foreach ($entries as $entry) {
2751
2752 if ($site_url) {
2753
2754 if ($entry->hasAttribute('href'))
2755 $entry->setAttribute('href',
2756 rewrite_relative_url($site_url, $entry->getAttribute('href')));
2757
2758 if ($entry->hasAttribute('src')) {
2759 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
2760
2761 $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
2762
2763 if (file_exists($cached_filename)) {
2764 $src = SELF_URL_PATH . '/image.php?hash=' . sha1($src);
2765 }
2766
2767 $entry->setAttribute('src', $src);
2768 }
2769
2770 if ($entry->nodeName == 'img') {
2771 if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
2772 $force_remove_images || $_SESSION["bw_limit"]) {
2773
2774 $p = $doc->createElement('p');
2775
2776 $a = $doc->createElement('a');
2777 $a->setAttribute('href', $entry->getAttribute('src'));
2778
2779 $a->appendChild(new DOMText($entry->getAttribute('src')));
2780 $a->setAttribute('target', '_blank');
2781
2782 $p->appendChild($a);
2783
2784 $entry->parentNode->replaceChild($p, $entry);
2785 }
2786 }
2787 }
2788
2789 if (strtolower($entry->nodeName) == "a") {
2790 $entry->setAttribute("target", "_blank");
2791 }
2792 }
2793
2794 $entries = $xpath->query('//iframe');
2795 foreach ($entries as $entry) {
2796 $entry->setAttribute('sandbox', 'allow-scripts');
2797
2798 }
2799
2800 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
2801 'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
2802 'caption', 'cite', 'center', 'code', 'col', 'colgroup',
2803 'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
2804 'dt', 'em', 'footer', 'figure', 'figcaption',
2805 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
2806 'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
2807 'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
2808 'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
2809 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
2810 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
2811
2812 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
2813
2814 $disallowed_attributes = array('id', 'style', 'class');
2815
2816 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SANITIZE) as $plugin) {
2817 $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes);
2818 if (is_array($retval)) {
2819 $doc = $retval[0];
2820 $allowed_elements = $retval[1];
2821 $disallowed_attributes = $retval[2];
2822 } else {
2823 $doc = $retval;
2824 }
2825 }
2826
2827 $doc->removeChild($doc->firstChild); //remove doctype
2828 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
2829 $res = $doc->saveHTML();
2830 return $res;
2831 }
2832
2833 function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
2834 $xpath = new DOMXPath($doc);
2835 $entries = $xpath->query('//*');
2836
2837 foreach ($entries as $entry) {
2838 if (!in_array($entry->nodeName, $allowed_elements)) {
2839 $entry->parentNode->removeChild($entry);
2840 }
2841
2842 if ($entry->hasAttributes()) {
2843 $attrs_to_remove = array();
2844
2845 foreach ($entry->attributes as $attr) {
2846
2847 if (strpos($attr->nodeName, 'on') === 0) {
2848 array_push($attrs_to_remove, $attr);
2849 }
2850
2851 if (in_array($attr->nodeName, $disallowed_attributes)) {
2852 array_push($attrs_to_remove, $attr);
2853 }
2854 }
2855
2856 foreach ($attrs_to_remove as $attr) {
2857 $entry->removeAttributeNode($attr);
2858 }
2859 }
2860 }
2861
2862 return $doc;
2863 }
2864
2865 function check_for_update() {
2866 if (CHECK_FOR_NEW_VERSION && $_SESSION['access_level'] >= 10) {
2867 $version_url = "http://tt-rss.org/version.php?ver=" . VERSION .
2868 "&iid=" . sha1(SELF_URL_PATH);
2869
2870 $version_data = @fetch_file_contents($version_url);
2871
2872 if ($version_data) {
2873 $version_data = json_decode($version_data, true);
2874 if ($version_data && $version_data['version']) {
2875 if (version_compare(VERSION_STATIC, $version_data['version']) == -1) {
2876 return $version_data;
2877 }
2878 }
2879 }
2880 }
2881 return false;
2882 }
2883
2884 function catchupArticlesById($ids, $cmode, $owner_uid = false) {
2885
2886 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2887 if (count($ids) == 0) return;
2888
2889 $tmp_ids = array();
2890
2891 foreach ($ids as $id) {
2892 array_push($tmp_ids, "ref_id = '$id'");
2893 }
2894
2895 $ids_qpart = join(" OR ", $tmp_ids);
2896
2897 if ($cmode == 0) {
2898 db_query("UPDATE ttrss_user_entries SET
2899 unread = false,last_read = NOW()
2900 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2901 } else if ($cmode == 1) {
2902 db_query("UPDATE ttrss_user_entries SET
2903 unread = true
2904 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2905 } else {
2906 db_query("UPDATE ttrss_user_entries SET
2907 unread = NOT unread,last_read = NOW()
2908 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2909 }
2910
2911 /* update ccache */
2912
2913 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
2914 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2915
2916 while ($line = db_fetch_assoc($result)) {
2917 ccache_update($line["feed_id"], $owner_uid);
2918 }
2919 }
2920
2921 function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
2922
2923 $a_id = db_escape_string($id);
2924
2925 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2926
2927 $query = "SELECT DISTINCT tag_name,
2928 owner_uid as owner FROM
2929 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
2930 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
2931
2932 $tags = array();
2933
2934 /* check cache first */
2935
2936 if ($tag_cache === false) {
2937 $result = db_query("SELECT tag_cache FROM ttrss_user_entries
2938 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
2939
2940 $tag_cache = db_fetch_result($result, 0, "tag_cache");
2941 }
2942
2943 if ($tag_cache) {
2944 $tags = explode(",", $tag_cache);
2945 } else {
2946
2947 /* do it the hard way */
2948
2949 $tmp_result = db_query($query);
2950
2951 while ($tmp_line = db_fetch_assoc($tmp_result)) {
2952 array_push($tags, $tmp_line["tag_name"]);
2953 }
2954
2955 /* update the cache */
2956
2957 $tags_str = db_escape_string(join(",", $tags));
2958
2959 db_query("UPDATE ttrss_user_entries
2960 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
2961 AND owner_uid = $owner_uid");
2962 }
2963
2964 return $tags;
2965 }
2966
2967 function trim_array($array) {
2968 $tmp = $array;
2969 array_walk($tmp, 'trim');
2970 return $tmp;
2971 }
2972
2973 function tag_is_valid($tag) {
2974 if ($tag == '') return false;
2975 if (preg_match("/^[0-9]*$/", $tag)) return false;
2976 if (mb_strlen($tag) > 250) return false;
2977
2978 if (function_exists('iconv')) {
2979 $tag = iconv("utf-8", "utf-8", $tag);
2980 }
2981
2982 if (!$tag) return false;
2983
2984 return true;
2985 }
2986
2987 function render_login_form() {
2988 header('Cache-Control: public');
2989
2990 require_once "login_form.php";
2991 exit;
2992 }
2993
2994 function format_warning($msg, $id = "") {
2995 global $link;
2996 return "<div class=\"warning\" id=\"$id\">
2997 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
2998 }
2999
3000 function format_notice($msg, $id = "") {
3001 global $link;
3002 return "<div class=\"notice\" id=\"$id\">
3003 <span><img src=\"images/information.png\"></span><span>$msg</span></div>";
3004 }
3005
3006 function format_error($msg, $id = "") {
3007 global $link;
3008 return "<div class=\"error\" id=\"$id\">
3009 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
3010 }
3011
3012 function print_notice($msg) {
3013 return print format_notice($msg);
3014 }
3015
3016 function print_warning($msg) {
3017 return print format_warning($msg);
3018 }
3019
3020 function print_error($msg) {
3021 return print format_error($msg);
3022 }
3023
3024
3025 function T_sprintf() {
3026 $args = func_get_args();
3027 return vsprintf(__(array_shift($args)), $args);
3028 }
3029
3030 function format_inline_player($url, $ctype) {
3031
3032 $entry = "";
3033
3034 $url = htmlspecialchars($url);
3035
3036 if (strpos($ctype, "audio/") === 0) {
3037
3038 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
3039 $_SESSION["hasMp3"])) {
3040
3041 $entry .= "<audio preload=\"none\" controls>
3042 <source type=\"$ctype\" src=\"$url\"></source>
3043 </audio>";
3044
3045 } else {
3046
3047 $entry .= "<object type=\"application/x-shockwave-flash\"
3048 data=\"lib/button/musicplayer.swf?song_url=$url\"
3049 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
3050 <param name=\"movie\"
3051 value=\"lib/button/musicplayer.swf?song_url=$url\" />
3052 </object>";
3053 }
3054
3055 if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
3056 href=\"$url\">" . basename($url) . "</a>";
3057
3058 return $entry;
3059
3060 }
3061
3062 return "";
3063
3064 /* $filename = substr($url, strrpos($url, "/")+1);
3065
3066 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3067 $filename . " (" . $ctype . ")" . "</a>"; */
3068
3069 }
3070
3071 function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
3072 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3073
3074 $rv = array();
3075
3076 $rv['id'] = $id;
3077
3078 /* we can figure out feed_id from article id anyway, why do we
3079 * pass feed_id here? let's ignore the argument :(*/
3080
3081 $result = db_query("SELECT feed_id FROM ttrss_user_entries
3082 WHERE ref_id = '$id'");
3083
3084 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
3085
3086 $rv['feed_id'] = $feed_id;
3087
3088 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
3089
3090 if ($mark_as_read) {
3091 $result = db_query("UPDATE ttrss_user_entries
3092 SET unread = false,last_read = NOW()
3093 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3094
3095 ccache_update($feed_id, $owner_uid);
3096 }
3097
3098 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,
3099 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
3100 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
3101 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
3102 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
3103 num_comments,
3104 tag_cache,
3105 author,
3106 orig_feed_id,
3107 note
3108 FROM ttrss_entries,ttrss_user_entries
3109 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
3110
3111 if ($result) {
3112
3113 $line = db_fetch_assoc($result);
3114
3115 $tag_cache = $line["tag_cache"];
3116
3117 $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
3118 unset($line["tag_cache"]);
3119
3120 $line["content"] = sanitize($line["content"],
3121 sql_bool_to_bool($line['hide_images']),
3122 $owner_uid, $line["site_url"]);
3123
3124 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE) as $p) {
3125 $line = $p->hook_render_article($line);
3126 }
3127
3128 $num_comments = $line["num_comments"];
3129 $entry_comments = "";
3130
3131 if ($num_comments > 0) {
3132 if ($line["comments"]) {
3133 $comments_url = htmlspecialchars($line["comments"]);
3134 } else {
3135 $comments_url = htmlspecialchars($line["link"]);
3136 }
3137 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
3138 } else {
3139 if ($line["comments"] && $line["link"] != $line["comments"]) {
3140 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
3141 }
3142 }
3143
3144 if ($zoom_mode) {
3145 header("Content-Type: text/html");
3146 $rv['content'] .= "<html><head>
3147 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3148 <title>Tiny Tiny RSS - ".$line["title"]."</title>
3149 <link rel=\"stylesheet\" type=\"text/css\" href=\"css/tt-rss.css\">
3150 </head><body id=\"ttrssZoom\">";
3151 }
3152
3153 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
3154
3155 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
3156
3157 $entry_author = $line["author"];
3158
3159 if ($entry_author) {
3160 $entry_author = __(" - ") . $entry_author;
3161 }
3162
3163 $parsed_updated = make_local_datetime($line["updated"], true,
3164 $owner_uid, true);
3165
3166 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3167
3168 if ($line["link"]) {
3169 $rv['content'] .= "<div class='postTitle'><a target='_blank'
3170 title=\"".htmlspecialchars($line['title'])."\"
3171 href=\"" .
3172 htmlspecialchars($line["link"]) . "\">" .
3173 $line["title"] . "</a>" .
3174 "<span class='author'>$entry_author</span></div>";
3175 } else {
3176 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
3177 }
3178
3179 $tags_str = format_tags_string($line["tags"], $id);
3180 $tags_str_full = join(", ", $line["tags"]);
3181
3182 if (!$tags_str_full) $tags_str_full = __("no tags");
3183
3184 if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
3185
3186 $rv['content'] .= "<div class='postTags' style='float : right'>
3187 <img src='images/tag.png'
3188 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
3189
3190 if (!$zoom_mode) {
3191 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
3192 <a title=\"".__('Edit tags for this article')."\"
3193 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
3194
3195 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
3196 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
3197 position=\"below\">$tags_str_full</div>";
3198
3199 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_BUTTON) as $p) {
3200 $rv['content'] .= $p->hook_article_button($line);
3201 }
3202
3203 } else {
3204 $tags_str = strip_tags($tags_str);
3205 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
3206 }
3207 $rv['content'] .= "</div>";
3208 $rv['content'] .= "<div clear='both'>";
3209
3210 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
3211 $rv['content'] .= $p->hook_article_left_button($line);
3212 }
3213
3214 $rv['content'] .= "$entry_comments</div>";
3215
3216 if ($line["orig_feed_id"]) {
3217
3218 $tmp_result = db_query("SELECT * FROM ttrss_archived_feeds
3219 WHERE id = ".$line["orig_feed_id"]);
3220
3221 if (db_num_rows($tmp_result) != 0) {
3222
3223 $rv['content'] .= "<div clear='both'>";
3224 $rv['content'] .= __("Originally from:");
3225
3226 $rv['content'] .= "&nbsp;";
3227
3228 $tmp_line = db_fetch_assoc($tmp_result);
3229
3230 $rv['content'] .= "<a target='_blank'
3231 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
3232 $tmp_line['title'] . "</a>";
3233
3234 $rv['content'] .= "&nbsp;";
3235
3236 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
3237 $rv['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_set.svg'></a>";
3238
3239 $rv['content'] .= "</div>";
3240 }
3241 }
3242
3243 $rv['content'] .= "</div>";
3244
3245 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
3246 if ($line['note']) {
3247 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
3248 }
3249 $rv['content'] .= "</div>";
3250
3251 $rv['content'] .= "<div class=\"postContent\">";
3252
3253 $rv['content'] .= $line["content"];
3254 $rv['content'] .= format_article_enclosures($id,
3255 sql_bool_to_bool($line["always_display_enclosures"]),
3256 $line["content"],
3257 sql_bool_to_bool($line["hide_images"]));
3258
3259 $rv['content'] .= "</div>";
3260
3261 $rv['content'] .= "</div>";
3262
3263 }
3264
3265 if ($zoom_mode) {
3266 $rv['content'] .= "
3267 <div class='footer'>
3268 <button onclick=\"return window.close()\">".
3269 __("Close this window")."</button></div>";
3270 $rv['content'] .= "</body></html>";
3271 }
3272
3273 return $rv;
3274
3275 }
3276
3277 function print_checkpoint($n, $s) {
3278 $ts = microtime(true);
3279 echo sprintf("<!-- CP[$n] %.4f seconds -->\n", $ts - $s);
3280 return $ts;
3281 }
3282
3283 function sanitize_tag($tag) {
3284 $tag = trim($tag);
3285
3286 $tag = mb_strtolower($tag, 'utf-8');
3287
3288 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
3289
3290 // $tag = str_replace('"', "", $tag);
3291 // $tag = str_replace("+", " ", $tag);
3292 $tag = str_replace("technorati tag: ", "", $tag);
3293
3294 return $tag;
3295 }
3296
3297 function get_self_url_prefix() {
3298 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
3299 return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
3300 } else {
3301 return SELF_URL_PATH;
3302 }
3303 }
3304
3305 /**
3306 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
3307 *
3308 * @return string The Mozilla Firefox feed adding URL.
3309 */
3310 function add_feed_url() {
3311 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
3312
3313 $url_path = get_self_url_prefix() .
3314 "/public.php?op=subscribe&feed_url=%s";
3315 return $url_path;
3316 } // function add_feed_url
3317
3318 function encrypt_password($pass, $salt = '', $mode2 = false) {
3319 if ($salt && $mode2) {
3320 return "MODE2:" . hash('sha256', $salt . $pass);
3321 } else if ($salt) {
3322 return "SHA1X:" . sha1("$salt:$pass");
3323 } else {
3324 return "SHA1:" . sha1($pass);
3325 }
3326 } // function encrypt_password
3327
3328 function load_filters($feed_id, $owner_uid, $action_id = false) {
3329 $filters = array();
3330
3331 $cat_id = (int)getFeedCategory($feed_id);
3332
3333 $result = db_query("SELECT * FROM ttrss_filters2 WHERE
3334 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
3335
3336 $check_cats = join(",", array_merge(
3337 getParentCategories($cat_id, $owner_uid),
3338 array($cat_id)));
3339
3340 while ($line = db_fetch_assoc($result)) {
3341 $filter_id = $line["id"];
3342
3343 $result2 = db_query("SELECT
3344 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
3345 FROM ttrss_filters2_rules AS r,
3346 ttrss_filter_types AS t
3347 WHERE
3348 (cat_id IS NULL OR cat_id IN ($check_cats)) AND
3349 (feed_id IS NULL OR feed_id = '$feed_id') AND
3350 filter_type = t.id AND filter_id = '$filter_id'");
3351
3352 $rules = array();
3353 $actions = array();
3354
3355 while ($rule_line = db_fetch_assoc($result2)) {
3356 # print_r($rule_line);
3357
3358 $rule = array();
3359 $rule["reg_exp"] = $rule_line["reg_exp"];
3360 $rule["type"] = $rule_line["type_name"];
3361 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
3362
3363 array_push($rules, $rule);
3364 }
3365
3366 $result2 = db_query("SELECT a.action_param,t.name AS type_name
3367 FROM ttrss_filters2_actions AS a,
3368 ttrss_filter_actions AS t
3369 WHERE
3370 action_id = t.id AND filter_id = '$filter_id'");
3371
3372 while ($action_line = db_fetch_assoc($result2)) {
3373 # print_r($action_line);
3374
3375 $action = array();
3376 $action["type"] = $action_line["type_name"];
3377 $action["param"] = $action_line["action_param"];
3378
3379 array_push($actions, $action);
3380 }
3381
3382
3383 $filter = array();
3384 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
3385 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
3386 $filter["rules"] = $rules;
3387 $filter["actions"] = $actions;
3388
3389 if (count($rules) > 0 && count($actions) > 0) {
3390 array_push($filters, $filter);
3391 }
3392 }
3393
3394 return $filters;
3395 }
3396
3397 function get_score_pic($score) {
3398 if ($score > 100) {
3399 return "score_high.png";
3400 } else if ($score > 0) {
3401 return "score_half_high.png";
3402 } else if ($score < -100) {
3403 return "score_low.png";
3404 } else if ($score < 0) {
3405 return "score_half_low.png";
3406 } else {
3407 return "score_neutral.png";
3408 }
3409 }
3410
3411 function feed_has_icon($id) {
3412 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
3413 }
3414
3415 function init_plugins() {
3416 PluginHost::getInstance()->load(PLUGINS, PluginHost::KIND_ALL);
3417
3418 return true;
3419 }
3420
3421 function format_tags_string($tags, $id) {
3422 if (!is_array($tags) || count($tags) == 0) {
3423 return __("no tags");
3424 } else {
3425 $maxtags = min(5, count($tags));
3426
3427 for ($i = 0; $i < $maxtags; $i++) {
3428 $tags_str .= "<a class=\"tag\" href=\"#\" onclick=\"viewfeed('".$tags[$i]."')\">" . $tags[$i] . "</a>, ";
3429 }
3430
3431 $tags_str = mb_substr($tags_str, 0, mb_strlen($tags_str)-2);
3432
3433 if (count($tags) > $maxtags)
3434 $tags_str .= ", &hellip;";
3435
3436 return $tags_str;
3437 }
3438 }
3439
3440 function format_article_labels($labels, $id) {
3441
3442 if (!is_array($labels)) return '';
3443
3444 $labels_str = "";
3445
3446 foreach ($labels as $l) {
3447 $labels_str .= sprintf("<span class='hlLabelRef'
3448 style='color : %s; background-color : %s'>%s</span>",
3449 $l[2], $l[3], $l[1]);
3450 }
3451
3452 return $labels_str;
3453
3454 }
3455
3456 function format_article_note($id, $note, $allow_edit = true) {
3457
3458 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
3459 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
3460 ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
3461
3462 return $str;
3463 }
3464
3465
3466 function get_feed_category($feed_cat, $parent_cat_id = false) {
3467 if ($parent_cat_id) {
3468 $parent_qpart = "parent_cat = '$parent_cat_id'";
3469 $parent_insert = "'$parent_cat_id'";
3470 } else {
3471 $parent_qpart = "parent_cat IS NULL";
3472 $parent_insert = "NULL";
3473 }
3474
3475 $result = db_query(
3476 "SELECT id FROM ttrss_feed_categories
3477 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3478
3479 if (db_num_rows($result) == 0) {
3480 return false;
3481 } else {
3482 return db_fetch_result($result, 0, "id");
3483 }
3484 }
3485
3486 function add_feed_category($feed_cat, $parent_cat_id = false) {
3487
3488 if (!$feed_cat) return false;
3489
3490 db_query("BEGIN");
3491
3492 if ($parent_cat_id) {
3493 $parent_qpart = "parent_cat = '$parent_cat_id'";
3494 $parent_insert = "'$parent_cat_id'";
3495 } else {
3496 $parent_qpart = "parent_cat IS NULL";
3497 $parent_insert = "NULL";
3498 }
3499
3500 $feed_cat = mb_substr($feed_cat, 0, 250);
3501
3502 $result = db_query(
3503 "SELECT id FROM ttrss_feed_categories
3504 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3505
3506 if (db_num_rows($result) == 0) {
3507
3508 $result = db_query(
3509 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
3510 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
3511
3512 db_query("COMMIT");
3513
3514 return true;
3515 }
3516
3517 return false;
3518 }
3519
3520 function getArticleFeed($id) {
3521 $result = db_query("SELECT feed_id FROM ttrss_user_entries
3522 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
3523
3524 if (db_num_rows($result) != 0) {
3525 return db_fetch_result($result, 0, "feed_id");
3526 } else {
3527 return 0;
3528 }
3529 }
3530
3531 /**
3532 * Fixes incomplete URLs by prepending "http://".
3533 * Also replaces feed:// with http://, and
3534 * prepends a trailing slash if the url is a domain name only.
3535 *
3536 * @param string $url Possibly incomplete URL
3537 *
3538 * @return string Fixed URL.
3539 */
3540 function fix_url($url) {
3541 if (strpos($url, '://') === false) {
3542 $url = 'http://' . $url;
3543 } else if (substr($url, 0, 5) == 'feed:') {
3544 $url = 'http:' . substr($url, 5);
3545 }
3546
3547 //prepend slash if the URL has no slash in it
3548 // "http://www.example" -> "http://www.example/"
3549 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
3550 $url .= '/';
3551 }
3552
3553 if ($url != "http:///")
3554 return $url;
3555 else
3556 return '';
3557 }
3558
3559 function validate_feed_url($url) {
3560 $parts = parse_url($url);
3561
3562 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
3563
3564 }
3565
3566 function get_article_enclosures($id) {
3567
3568 $query = "SELECT * FROM ttrss_enclosures
3569 WHERE post_id = '$id' AND content_url != ''";
3570
3571 $rv = array();
3572
3573 $result = db_query($query);
3574
3575 if (db_num_rows($result) > 0) {
3576 while ($line = db_fetch_assoc($result)) {
3577 array_push($rv, $line);
3578 }
3579 }
3580
3581 return $rv;
3582 }
3583
3584 function save_email_address($email) {
3585 // FIXME: implement persistent storage of emails
3586
3587 if (!$_SESSION['stored_emails'])
3588 $_SESSION['stored_emails'] = array();
3589
3590 if (!in_array($email, $_SESSION['stored_emails']))
3591 array_push($_SESSION['stored_emails'], $email);
3592 }
3593
3594
3595 function get_feed_access_key($feed_id, $is_cat, $owner_uid = false) {
3596
3597 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3598
3599 $sql_is_cat = bool_to_sql_bool($is_cat);
3600
3601 $result = db_query("SELECT access_key FROM ttrss_access_keys
3602 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
3603 AND owner_uid = " . $owner_uid);
3604
3605 if (db_num_rows($result) == 1) {
3606 return db_fetch_result($result, 0, "access_key");
3607 } else {
3608 $key = db_escape_string(sha1(uniqid(rand(), true)));
3609
3610 $result = db_query("INSERT INTO ttrss_access_keys
3611 (access_key, feed_id, is_cat, owner_uid)
3612 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
3613
3614 return $key;
3615 }
3616 return false;
3617 }
3618
3619 function get_feeds_from_html($url, $content)
3620 {
3621 $url = fix_url($url);
3622 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
3623
3624 libxml_use_internal_errors(true);
3625
3626 $doc = new DOMDocument();
3627 $doc->loadHTML($content);
3628 $xpath = new DOMXPath($doc);
3629 $entries = $xpath->query('/html/head/link[@rel="alternate"]');
3630 $feedUrls = array();
3631 foreach ($entries as $entry) {
3632 if ($entry->hasAttribute('href')) {
3633 $title = $entry->getAttribute('title');
3634 if ($title == '') {
3635 $title = $entry->getAttribute('type');
3636 }
3637 $feedUrl = rewrite_relative_url(
3638 $baseUrl, $entry->getAttribute('href')
3639 );
3640 $feedUrls[$feedUrl] = $title;
3641 }
3642 }
3643 return $feedUrls;
3644 }
3645
3646 function is_html($content) {
3647 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
3648 }
3649
3650 function url_is_html($url, $login = false, $pass = false) {
3651 return is_html(fetch_file_contents($url, false, $login, $pass));
3652 }
3653
3654 function print_label_select($name, $value, $attributes = "") {
3655
3656 $result = db_query("SELECT caption FROM ttrss_labels2
3657 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
3658
3659 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
3660 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
3661
3662 while ($line = db_fetch_assoc($result)) {
3663
3664 $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
3665
3666 print "<option value=\"".htmlspecialchars($line["caption"])."\"
3667 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
3668
3669 }
3670
3671 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
3672
3673 print "</select>";
3674
3675
3676 }
3677
3678 function format_article_enclosures($id, $always_display_enclosures,
3679 $article_content, $hide_images = false) {
3680
3681 $result = get_article_enclosures($id);
3682 $rv = '';
3683
3684 if (count($result) > 0) {
3685
3686 $entries_html = array();
3687 $entries = array();
3688 $entries_inline = array();
3689
3690 foreach ($result as $line) {
3691
3692 $url = $line["content_url"];
3693 $ctype = $line["content_type"];
3694
3695 if (!$ctype) $ctype = __("unknown type");
3696
3697 $filename = substr($url, strrpos($url, "/")+1);
3698
3699 $player = format_inline_player($url, $ctype);
3700
3701 if ($player) array_push($entries_inline, $player);
3702
3703 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3704 # $filename . " (" . $ctype . ")" . "</a>";
3705
3706 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
3707 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
3708
3709 array_push($entries_html, $entry);
3710
3711 $entry = array();
3712
3713 $entry["type"] = $ctype;
3714 $entry["filename"] = $filename;
3715 $entry["url"] = $url;
3716
3717 array_push($entries, $entry);
3718 }
3719
3720 if ($_SESSION['uid'] && !get_pref("STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
3721 if ($always_display_enclosures ||
3722 !preg_match("/<img/i", $article_content)) {
3723
3724 foreach ($entries as $entry) {
3725
3726 if (preg_match("/image/", $entry["type"]) ||
3727 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
3728
3729 if (!$hide_images) {
3730 $rv .= "<p><img
3731 alt=\"".htmlspecialchars($entry["filename"])."\"
3732 src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
3733 } else {
3734 $rv .= "<p><a target=\"_blank\"
3735 href=\"".htmlspecialchars($entry["url"])."\"
3736 >" .htmlspecialchars($entry["url"]) . "</a></p>";
3737
3738 }
3739 }
3740 }
3741 }
3742 }
3743
3744 if (count($entries_inline) > 0) {
3745 $rv .= "<hr clear='both'/>";
3746 foreach ($entries_inline as $entry) { $rv .= $entry; };
3747 $rv .= "<hr clear='both'/>";
3748 }
3749
3750 $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
3751 "<option value=''>" . __('Attachments')."</option>";
3752
3753 foreach ($entries as $entry) {
3754 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "</option>";
3755
3756 };
3757
3758 $rv .= "</select>";
3759 }
3760
3761 return $rv;
3762 }
3763
3764 function getLastArticleId() {
3765 $result = db_query("SELECT MAX(ref_id) AS id FROM ttrss_user_entries
3766 WHERE owner_uid = " . $_SESSION["uid"]);
3767
3768 if (db_num_rows($result) == 1) {
3769 return db_fetch_result($result, 0, "id");
3770 } else {
3771 return -1;
3772 }
3773 }
3774
3775 function build_url($parts) {
3776 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
3777 }
3778
3779 /**
3780 * Converts a (possibly) relative URL to a absolute one.
3781 *
3782 * @param string $url Base URL (i.e. from where the document is)
3783 * @param string $rel_url Possibly relative URL in the document
3784 *
3785 * @return string Absolute URL
3786 */
3787 function rewrite_relative_url($url, $rel_url) {
3788 if (strpos($rel_url, ":") !== false) {
3789 return $rel_url;
3790 } else if (strpos($rel_url, "://") !== false) {
3791 return $rel_url;
3792 } else if (strpos($rel_url, "//") === 0) {
3793 # protocol-relative URL (rare but they exist)
3794 return $rel_url;
3795 } else if (strpos($rel_url, "/") === 0)
3796 {
3797 $parts = parse_url($url);
3798 $parts['path'] = $rel_url;
3799
3800 return build_url($parts);
3801
3802 } else {
3803 $parts = parse_url($url);
3804 if (!isset($parts['path'])) {
3805 $parts['path'] = '/';
3806 }
3807 $dir = $parts['path'];
3808 if (substr($dir, -1) !== '/') {
3809 $dir = dirname($parts['path']);
3810 $dir !== '/' && $dir .= '/';
3811 }
3812 $parts['path'] = $dir . $rel_url;
3813
3814 return build_url($parts);
3815 }
3816 }
3817
3818 function sphinx_search($query, $offset = 0, $limit = 30) {
3819 require_once 'lib/sphinxapi.php';
3820
3821 $sphinxClient = new SphinxClient();
3822
3823 $sphinxpair = explode(":", SPHINX_SERVER, 2);
3824
3825 $sphinxClient->SetServer($sphinxpair[0], (int)$sphinxpair[1]);
3826 $sphinxClient->SetConnectTimeout(1);
3827
3828 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
3829 'feed_title' => 20));
3830
3831 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2);
3832 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
3833 $sphinxClient->SetLimits($offset, $limit, 1000);
3834 $sphinxClient->SetArrayResult(false);
3835 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
3836
3837 $result = $sphinxClient->Query($query, SPHINX_INDEX);
3838
3839 $ids = array();
3840
3841 if (is_array($result['matches'])) {
3842 foreach (array_keys($result['matches']) as $int_id) {
3843 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
3844 array_push($ids, $ref_id);
3845 }
3846 }
3847
3848 return $ids;
3849 }
3850
3851 function cleanup_tags($days = 14, $limit = 1000) {
3852
3853 if (DB_TYPE == "pgsql") {
3854 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
3855 } else if (DB_TYPE == "mysql") {
3856 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
3857 }
3858
3859 $tags_deleted = 0;
3860
3861 while ($limit > 0) {
3862 $limit_part = 500;
3863
3864 $query = "SELECT ttrss_tags.id AS id
3865 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
3866 WHERE post_int_id = int_id AND $interval_query AND
3867 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
3868
3869 $result = db_query($query);
3870
3871 $ids = array();
3872
3873 while ($line = db_fetch_assoc($result)) {
3874 array_push($ids, $line['id']);
3875 }
3876
3877 if (count($ids) > 0) {
3878 $ids = join(",", $ids);
3879
3880 $tmp_result = db_query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
3881 $tags_deleted += db_affected_rows($tmp_result);
3882 } else {
3883 break;
3884 }
3885
3886 $limit -= $limit_part;
3887 }
3888
3889 return $tags_deleted;
3890 }
3891
3892 function print_user_stylesheet() {
3893 $value = get_pref('USER_STYLESHEET');
3894
3895 if ($value) {
3896 print "<style type=\"text/css\">";
3897 print str_replace("<br/>", "\n", $value);
3898 print "</style>";
3899 }
3900
3901 }
3902
3903 function rewrite_urls($html) {
3904 libxml_use_internal_errors(true);
3905
3906 $charset_hack = '<head>
3907 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
3908 </head>';
3909
3910 $doc = new DOMDocument();
3911 $doc->loadHTML($charset_hack . $html);
3912 $xpath = new DOMXPath($doc);
3913
3914 $entries = $xpath->query('//*/text()');
3915
3916 foreach ($entries as $entry) {
3917 if (strstr($entry->wholeText, "://") !== false) {
3918 $text = preg_replace("/((?<!=.)((http|https|ftp)+):\/\/[^ ,!]+)/i",
3919 "<a target=\"_blank\" href=\"\\1\">\\1</a>", $entry->wholeText);
3920
3921 if ($text != $entry->wholeText) {
3922 $cdoc = new DOMDocument();
3923 $cdoc->loadHTML($charset_hack . $text);
3924
3925
3926 foreach ($cdoc->childNodes as $cnode) {
3927 $cnode = $doc->importNode($cnode, true);
3928
3929 if ($cnode) {
3930 $entry->parentNode->insertBefore($cnode);
3931 }
3932 }
3933
3934 $entry->parentNode->removeChild($entry);
3935
3936 }
3937 }
3938 }
3939
3940 $node = $doc->getElementsByTagName('body')->item(0);
3941
3942 // http://tt-rss.org/forum/viewtopic.php?f=1&t=970
3943 if ($node)
3944 return $doc->saveXML($node);
3945 else
3946 return $html;
3947 }
3948
3949 function filter_to_sql($filter, $owner_uid) {
3950 $query = array();
3951
3952 if (DB_TYPE == "pgsql")
3953 $reg_qpart = "~";
3954 else
3955 $reg_qpart = "REGEXP";
3956
3957 foreach ($filter["rules"] AS $rule) {
3958 $rule['reg_exp'] = str_replace('/', '\/', $rule["reg_exp"]);
3959 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
3960 $rule['reg_exp']) !== FALSE;
3961
3962 if ($regexp_valid) {
3963
3964 $rule['reg_exp'] = db_escape_string($rule['reg_exp']);
3965
3966 switch ($rule["type"]) {
3967 case "title":
3968 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3969 $rule['reg_exp'] . "')";
3970 break;
3971 case "content":
3972 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
3973 $rule['reg_exp'] . "')";
3974 break;
3975 case "both":
3976 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3977 $rule['reg_exp'] . "') OR LOWER(" .
3978 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
3979 break;
3980 case "tag":
3981 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
3982 $rule['reg_exp'] . "')";
3983 break;
3984 case "link":
3985 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
3986 $rule['reg_exp'] . "')";
3987 break;
3988 case "author":
3989 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
3990 $rule['reg_exp'] . "')";
3991 break;
3992 }
3993
3994 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
3995
3996 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
3997 $qpart .= " AND feed_id = " . db_escape_string($rule["feed_id"]);
3998 }
3999
4000 if (isset($rule["cat_id"])) {
4001
4002 if ($rule["cat_id"] > 0) {
4003 $children = getChildCategories($rule["cat_id"], $owner_uid);
4004 array_push($children, $rule["cat_id"]);
4005
4006 $children = join(",", $children);
4007
4008 $cat_qpart = "cat_id IN ($children)";
4009 } else {
4010 $cat_qpart = "cat_id IS NULL";
4011 }
4012
4013 $qpart .= " AND $cat_qpart";
4014 }
4015
4016 array_push($query, "($qpart)");
4017
4018 }
4019 }
4020
4021 if (count($query) > 0) {
4022 $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
4023 } else {
4024 $fullquery = "(false)";
4025 }
4026
4027 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
4028
4029 return $fullquery;
4030 }
4031
4032 if (!function_exists('gzdecode')) {
4033 function gzdecode($string) { // no support for 2nd argument
4034 return file_get_contents('compress.zlib://data:who/cares;base64,'.
4035 base64_encode($string));
4036 }
4037 }
4038
4039 function get_random_bytes($length) {
4040 if (function_exists('openssl_random_pseudo_bytes')) {
4041 return openssl_random_pseudo_bytes($length);
4042 } else {
4043 $output = "";
4044
4045 for ($i = 0; $i < $length; $i++)
4046 $output .= chr(mt_rand(0, 255));
4047
4048 return $output;
4049 }
4050 }
4051
4052 function read_stdin() {
4053 $fp = fopen("php://stdin", "r");
4054
4055 if ($fp) {
4056 $line = trim(fgets($fp));
4057 fclose($fp);
4058 return $line;
4059 }
4060
4061 return null;
4062 }
4063
4064 function tmpdirname($path, $prefix) {
4065 // Use PHP's tmpfile function to create a temporary
4066 // directory name. Delete the file and keep the name.
4067 $tempname = tempnam($path,$prefix);
4068 if (!$tempname)
4069 return false;
4070
4071 if (!unlink($tempname))
4072 return false;
4073
4074 return $tempname;
4075 }
4076
4077 function getFeedCategory($feed) {
4078 $result = db_query("SELECT cat_id FROM ttrss_feeds
4079 WHERE id = '$feed'");
4080
4081 if (db_num_rows($result) > 0) {
4082 return db_fetch_result($result, 0, "cat_id");
4083 } else {
4084 return false;
4085 }
4086
4087 }
4088
4089 function implements_interface($class, $interface) {
4090 return in_array($interface, class_implements($class));
4091 }
4092
4093 function geturl($url){
4094
4095 if (!function_exists('curl_init'))
4096 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);
4097
4098 $curl = curl_init();
4099 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
4100 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
4101 $header[] = "Cache-Control: max-age=0";
4102 $header[] = "Connection: keep-alive";
4103 $header[] = "Keep-Alive: 300";
4104 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
4105 $header[] = "Accept-Language: en-us,en;q=0.5";
4106 $header[] = "Pragma: ";
4107
4108 curl_setopt($curl, CURLOPT_URL, $url);
4109 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
4110 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
4111 curl_setopt($curl, CURLOPT_HEADER, true);
4112 curl_setopt($curl, CURLOPT_REFERER, $url);
4113 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
4114 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
4115 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
4116 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
4117 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
4118 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
4119
4120 $html = curl_exec($curl);
4121
4122 $status = curl_getinfo($curl);
4123
4124 if($status['http_code']!=200){
4125 if($status['http_code'] == 301 || $status['http_code'] == 302) {
4126 curl_close($curl);
4127 list($header) = explode("\r\n\r\n", $html, 2);
4128 $matches = array();
4129 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
4130 $url = trim(str_replace($matches[1],"",$matches[0]));
4131 $url_parsed = parse_url($url);
4132 return (isset($url_parsed))? geturl($url):'';
4133 }
4134
4135 global $fetch_last_error;
4136
4137 $fetch_last_error = curl_errno($curl) . " " . curl_error($curl);
4138 curl_close($curl);
4139
4140 $oline='';
4141 foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
4142 $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
4143 # $handle = @fopen('./curl.error.log', 'a');
4144 # fwrite($handle, $line);
4145 return FALSE;
4146 }
4147 curl_close($curl);
4148 return $url;
4149 }
4150
4151 function get_minified_js($files) {
4152 require_once 'lib/jshrink/Minifier.php';
4153
4154 $rv = '';
4155
4156 foreach ($files as $js) {
4157 if (!isset($_GET['debug'])) {
4158 $cached_file = CACHE_DIR . "/js/".basename($js).".js";
4159
4160 if (file_exists($cached_file) &&
4161 is_readable($cached_file) &&
4162 filemtime($cached_file) >= filemtime("js/$js.js")) {
4163
4164 $rv .= file_get_contents($cached_file);
4165
4166 } else {
4167 $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
4168 file_put_contents($cached_file, $minified);
4169 $rv .= $minified;
4170 }
4171 } else {
4172 $rv .= file_get_contents("js/$js.js");
4173 }
4174 }
4175
4176 return $rv;
4177 }
4178
4179 function stylesheet_tag($filename) {
4180 $timestamp = filemtime($filename);
4181
4182 echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
4183 }
4184
4185 function javascript_tag($filename) {
4186 $query = "";
4187
4188 if (!(strpos($filename, "?") === FALSE)) {
4189 $query = substr($filename, strpos($filename, "?")+1);
4190 $filename = substr($filename, 0, strpos($filename, "?"));
4191 }
4192
4193 $timestamp = filemtime($filename);
4194
4195 if ($query) $timestamp .= "&$query";
4196
4197 echo "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
4198 }
4199
4200 function calculate_dep_timestamp() {
4201 $files = array_merge(glob("js/*.js"), glob("css/*.css"));
4202
4203 $max_ts = -1;
4204
4205 foreach ($files as $file) {
4206 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
4207 }
4208
4209 return $max_ts;
4210 }
4211
4212 function T_js_decl($s1, $s2) {
4213 if ($s1 && $s2) {
4214 $s1 = preg_replace("/\n/", "", $s1);
4215 $s2 = preg_replace("/\n/", "", $s2);
4216
4217 $s1 = preg_replace("/\"/", "\\\"", $s1);
4218 $s2 = preg_replace("/\"/", "\\\"", $s2);
4219
4220 return "T_messages[\"$s1\"] = \"$s2\";\n";
4221 }
4222 }
4223
4224 function init_js_translations() {
4225
4226 print 'var T_messages = new Object();
4227
4228 function __(msg) {
4229 if (T_messages[msg]) {
4230 return T_messages[msg];
4231 } else {
4232 return msg;
4233 }
4234 }
4235
4236 function ngettext(msg1, msg2, n) {
4237 return (parseInt(n) > 1) ? msg2 : msg1;
4238 }';
4239
4240 $l10n = _get_reader();
4241
4242 for ($i = 0; $i < $l10n->total; $i++) {
4243 $orig = $l10n->get_original_string($i);
4244 $translation = __($orig);
4245
4246 print T_js_decl($orig, $translation);
4247 }
4248 }
4249
4250 function label_to_feed_id($label) {
4251 return LABEL_BASE_INDEX - 1 - abs($label);
4252 }
4253
4254 function feed_to_label_id($feed) {
4255 return LABEL_BASE_INDEX - 1 + abs($feed);
4256 }
4257
4258 function format_libxml_error($error) {
4259 return T_sprintf("LibXML error %s at line %d (column %d): %s",
4260 $error->code, $error->line, $error->column,
4261 $error->message);
4262 }
4263
4264 ?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/