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