2 define('EXPECTED_CONFIG_VERSION', 26);
3 define('SCHEMA_VERSION', 107);
5 $fetch_last_error = false;
8 function __autoload($class) {
9 $class_file = str_replace("_", "/", strtolower(basename($class)));
11 $file = dirname(__FILE__
)."/../classes/$class_file.php";
13 if (file_exists($file)) {
19 mb_internal_encoding("UTF-8");
20 date_default_timezone_set('UTC');
21 if (defined('E_DEPRECATED')) {
22 error_reporting(E_ALL
& ~E_NOTICE
& ~E_DEPRECATED
);
24 error_reporting(E_ALL
& ~E_NOTICE
);
27 require_once 'config.php';
29 if (DB_TYPE
== "pgsql") {
30 define('SUBSTRING_FOR_DATE', 'SUBSTRING_FOR_DATE');
32 define('SUBSTRING_FOR_DATE', 'SUBSTRING');
35 define('THEME_VERSION_REQUIRED', 1.1);
38 * Return available translations names.
41 * @return array A array of available translations.
43 function get_translations() {
45 "auto" => "Detect automatically",
51 "fr_FR" => "Français",
52 "hu_HU" => "Magyar (Hungarian)",
53 "it_IT" => "Italiano",
54 "ja_JP" => "日本語 (Japanese)",
55 "lv_LV" => "Latviešu",
56 "nb_NO" => "Norwegian bokmål",
60 "pt_BR" => "Portuguese/Brazil",
61 "zh_CN" => "Simplified Chinese");
66 require_once "lib/accept-to-gettext.php";
67 require_once "lib/gettext/gettext.inc";
70 function startup_gettext() {
72 # Get locale from Accept-Language header
73 $lang = al2gt(array_keys(get_translations()), "text/html");
75 if (defined('_TRANSLATION_OVERRIDE_DEFAULT')) {
76 $lang = _TRANSLATION_OVERRIDE_DEFAULT
;
79 if ($_SESSION["language"] && $_SESSION["language"] != "auto") {
80 $lang = $_SESSION["language"];
84 if (defined('LC_MESSAGES')) {
85 _setlocale(LC_MESSAGES
, $lang);
86 } else if (defined('LC_ALL')) {
87 _setlocale(LC_ALL
, $lang);
90 _bindtextdomain("messages", "locale");
92 _textdomain("messages");
93 _bind_textdomain_codeset("messages", "UTF-8");
99 require_once 'db-prefs.php';
100 require_once 'version.php';
101 require_once 'ccache.php';
102 require_once 'labels.php';
104 define('SELF_USER_AGENT', 'Tiny Tiny RSS/' . VERSION
. ' (http://tt-rss.org/)');
105 ini_set('user_agent', SELF_USER_AGENT
);
107 require_once 'lib/pubsubhubbub/publisher.php';
110 $utc_tz = new DateTimeZone('UTC');
111 $schema_version = false;
114 * Print a timestamped debug message.
116 * @param string $msg The debug message.
119 function _debug($msg) {
120 $ts = strftime("%H:%M:%S", time());
121 if (function_exists('posix_getpid')) {
122 $ts = "$ts/" . posix_getpid();
125 if (!(defined('QUIET') && QUIET
)) {
126 print "[$ts] $msg\n";
129 if (defined('LOGFILE')) {
130 $fp = fopen(LOGFILE
, 'a+');
133 fputs($fp, "[$ts] $msg\n");
141 * Purge a feed old posts.
143 * @param mixed $link A database connection.
144 * @param mixed $feed_id The id of the purged feed.
145 * @param mixed $purge_interval Olderness of purged posts.
146 * @param boolean $debug Set to True to enable the debug. False by default.
150 function purge_feed($link, $feed_id, $purge_interval, $debug = false) {
152 if (!$purge_interval) $purge_interval = feed_purge_interval($link, $feed_id);
156 $result = db_query($link,
157 "SELECT owner_uid FROM ttrss_feeds WHERE id = '$feed_id'");
161 if (db_num_rows($result) == 1) {
162 $owner_uid = db_fetch_result($result, 0, "owner_uid");
165 if ($purge_interval == -1 ||
!$purge_interval) {
167 ccache_update($link, $feed_id, $owner_uid);
172 if (!$owner_uid) return;
174 if (FORCE_ARTICLE_PURGE
== 0) {
175 $purge_unread = get_pref($link, "PURGE_UNREAD_ARTICLES",
178 $purge_unread = true;
179 $purge_interval = FORCE_ARTICLE_PURGE
;
182 if (!$purge_unread) $query_limit = " unread = false AND ";
184 if (DB_TYPE
== "pgsql") {
185 $pg_version = get_pgsql_version($link);
187 if (preg_match("/^7\./", $pg_version) ||
preg_match("/^8\.0/", $pg_version)) {
189 $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
190 ttrss_entries.id = ref_id AND
192 feed_id = '$feed_id' AND
194 ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
198 $result = db_query($link, "DELETE FROM ttrss_user_entries
200 WHERE ttrss_entries.id = ref_id AND
202 feed_id = '$feed_id' AND
204 ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
207 $rows = pg_affected_rows($result);
211 /* $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
212 marked = false AND feed_id = '$feed_id' AND
213 (SELECT date_updated FROM ttrss_entries WHERE
214 id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */
216 $result = db_query($link, "DELETE FROM ttrss_user_entries
217 USING ttrss_user_entries, ttrss_entries
218 WHERE ttrss_entries.id = ref_id AND
220 feed_id = '$feed_id' AND
222 ttrss_entries.date_updated < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)");
224 $rows = mysql_affected_rows($link);
228 ccache_update($link, $feed_id, $owner_uid);
231 _debug("Purged feed $feed_id ($purge_interval): deleted $rows articles");
235 } // function purge_feed
237 function feed_purge_interval($link, $feed_id) {
239 $result = db_query($link, "SELECT purge_interval, owner_uid FROM ttrss_feeds
240 WHERE id = '$feed_id'");
242 if (db_num_rows($result) == 1) {
243 $purge_interval = db_fetch_result($result, 0, "purge_interval");
244 $owner_uid = db_fetch_result($result, 0, "owner_uid");
246 if ($purge_interval == 0) $purge_interval = get_pref($link,
247 'PURGE_OLD_DAYS', $owner_uid);
249 return $purge_interval;
256 function purge_orphans($link, $do_output = false) {
258 // purge orphaned posts in main content table
259 $result = db_query($link, "DELETE FROM ttrss_entries WHERE
260 (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
263 $rows = db_affected_rows($link, $result);
264 _debug("Purged $rows orphaned posts.");
268 function get_feed_update_interval($link, $feed_id) {
269 $result = db_query($link, "SELECT owner_uid, update_interval FROM
270 ttrss_feeds WHERE id = '$feed_id'");
272 if (db_num_rows($result) == 1) {
273 $update_interval = db_fetch_result($result, 0, "update_interval");
274 $owner_uid = db_fetch_result($result, 0, "owner_uid");
276 if ($update_interval != 0) {
277 return $update_interval;
279 return get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $owner_uid, false);
287 function fetch_file_contents($url, $type = false, $login = false, $pass = false, $post_query = false, $timeout = false) {
288 $login = urlencode($login);
289 $pass = urlencode($pass);
291 global $fetch_last_error;
293 if (function_exists('curl_init') && !ini_get("open_basedir")) {
295 if (ini_get("safe_mode")) {
296 $ch = curl_init(geturl($url));
298 $ch = curl_init($url);
301 curl_setopt($ch, CURLOPT_CONNECTTIMEOUT
, $timeout ?
$timeout : 15);
302 curl_setopt($ch, CURLOPT_TIMEOUT
, $timeout ?
$timeout : 45);
303 curl_setopt($ch, CURLOPT_FOLLOWLOCATION
, !ini_get("safe_mode"));
304 curl_setopt($ch, CURLOPT_MAXREDIRS
, 20);
305 curl_setopt($ch, CURLOPT_BINARYTRANSFER
, true);
306 curl_setopt($ch, CURLOPT_RETURNTRANSFER
, true);
307 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER
, false);
308 curl_setopt($ch, CURLOPT_HTTPAUTH
, CURLAUTH_ANY
);
309 curl_setopt($ch, CURLOPT_USERAGENT
, SELF_USER_AGENT
);
310 curl_setopt($ch, CURLOPT_ENCODING
, "gzip");
311 curl_setopt($ch, CURLOPT_REFERER
, $url);
314 curl_setopt($ch, CURLOPT_POST
, true);
315 curl_setopt($ch, CURLOPT_POSTFIELDS
, $post_query);
319 curl_setopt($ch, CURLOPT_USERPWD
, "$login:$pass");
321 $contents = @curl_exec
($ch);
323 if (curl_errno($ch) === 23 ||
curl_errno($ch) === 61) {
324 curl_setopt($ch, CURLOPT_ENCODING
, 'none');
325 $contents = @curl_exec
($ch);
328 if ($contents === false) {
329 $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
334 $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE
);
335 $content_type = curl_getinfo($ch, CURLINFO_CONTENT_TYPE
);
337 if ($http_code != 200 ||
$type && strpos($content_type, "$type") === false) {
338 if (curl_errno($ch) != 0) {
339 $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
341 $fetch_last_error = "HTTP Code: $http_code";
351 if ($login && $pass ){
352 $url_parts = array();
354 preg_match("/(^[^:]*):\/\/(.*)/", $url, $url_parts);
356 if ($url_parts[1] && $url_parts[2]) {
357 $url = $url_parts[1] . "://$login:$pass@" . $url_parts[2];
361 $data = @file_get_contents
($url);
363 @$gzdecoded = gzdecode($data);
364 if ($gzdecoded) $data = $gzdecoded;
366 if (!$data && function_exists('error_get_last')) {
367 $error = error_get_last();
368 $fetch_last_error = $error["message"];
376 * Try to determine the favicon URL for a feed.
377 * adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
378 * http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
380 * @param string $url A feed or page URL
382 * @return mixed The favicon URL, or false if none was found.
384 function get_favicon_url($url) {
386 $favicon_url = false;
388 if ($html = @fetch_file_contents
($url)) {
390 libxml_use_internal_errors(true);
392 $doc = new DOMDocument();
393 $doc->loadHTML($html);
394 $xpath = new DOMXPath($doc);
396 $base = $xpath->query('/html/head/base');
397 foreach ($base as $b) {
398 $url = $b->getAttribute("href");
402 $entries = $xpath->query('/html/head/link[@rel="shortcut icon" or @rel="icon"]');
403 if (count($entries) > 0) {
404 foreach ($entries as $entry) {
405 $favicon_url = rewrite_relative_url($url, $entry->getAttribute("href"));
412 $favicon_url = rewrite_relative_url($url, "/favicon.ico");
415 } // function get_favicon_url
417 function check_feed_favicon($site_url, $feed, $link) {
418 # print "FAVICON [$site_url]: $favicon_url\n";
420 $icon_file = ICONS_DIR
. "/$feed.ico";
422 if (!file_exists($icon_file)) {
423 $favicon_url = get_favicon_url($site_url);
426 // Limiting to "image" type misses those served with text/plain
427 $contents = fetch_file_contents($favicon_url); // , "image");
430 // Crude image type matching.
431 // Patterns gleaned from the file(1) source code.
432 if (preg_match('/^\x00\x00\x01\x00/', $contents)) {
433 // 0 string \000\000\001\000 MS Windows icon resource
434 //error_log("check_feed_favicon: favicon_url=$favicon_url isa MS Windows icon resource");
436 elseif (preg_match('/^GIF8/', $contents)) {
437 // 0 string GIF8 GIF image data
438 //error_log("check_feed_favicon: favicon_url=$favicon_url isa GIF image");
440 elseif (preg_match('/^\x89PNG\x0d\x0a\x1a\x0a/', $contents)) {
441 // 0 string \x89PNG\x0d\x0a\x1a\x0a PNG image data
442 //error_log("check_feed_favicon: favicon_url=$favicon_url isa PNG image");
444 elseif (preg_match('/^\xff\xd8/', $contents)) {
445 // 0 beshort 0xffd8 JPEG image data
446 //error_log("check_feed_favicon: favicon_url=$favicon_url isa JPG image");
449 //error_log("check_feed_favicon: favicon_url=$favicon_url isa UNKNOWN type");
455 $fp = @fopen
($icon_file, "w");
458 fwrite($fp, $contents);
460 chmod($icon_file, 0644);
467 function print_select($id, $default, $values, $attributes = "") {
468 print "<select name=\"$id\" id=\"$id\" $attributes>";
469 foreach ($values as $v) {
471 $sel = "selected=\"1\"";
477 print "<option value=\"$v\" $sel>$v</option>";
482 function print_select_hash($id, $default, $values, $attributes = "") {
483 print "<select name=\"$id\" id='$id' $attributes>";
484 foreach (array_keys($values) as $v) {
486 $sel = 'selected="selected"';
492 print "<option $sel value=\"$v\">".$values[$v]."</option>";
498 function print_radio($id, $default, $true_is, $values, $attributes = "") {
499 foreach ($values as $v) {
506 if ($v == $true_is) {
507 $sel .= " value=\"1\"";
509 $sel .= " value=\"0\"";
512 print "<input class=\"noborder\" dojoType=\"dijit.form.RadioButton\"
513 type=\"radio\" $sel $attributes name=\"$id\"> $v ";
518 function initialize_user_prefs($link, $uid, $profile = false) {
520 $uid = db_escape_string($link, $uid);
524 $profile_qpart = "AND profile IS NULL";
526 $profile_qpart = "AND profile = '$profile'";
529 if (get_schema_version($link) < 63) $profile_qpart = "";
531 db_query($link, "BEGIN");
533 $result = db_query($link, "SELECT pref_name,def_value FROM ttrss_prefs");
535 $u_result = db_query($link, "SELECT pref_name
536 FROM ttrss_user_prefs WHERE owner_uid = '$uid' $profile_qpart");
538 $active_prefs = array();
540 while ($line = db_fetch_assoc($u_result)) {
541 array_push($active_prefs, $line["pref_name"]);
544 while ($line = db_fetch_assoc($result)) {
545 if (array_search($line["pref_name"], $active_prefs) === FALSE) {
546 // print "adding " . $line["pref_name"] . "<br>";
548 if (get_schema_version($link) < 63) {
549 db_query($link, "INSERT INTO ttrss_user_prefs
550 (owner_uid,pref_name,value) VALUES
551 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')");
554 db_query($link, "INSERT INTO ttrss_user_prefs
555 (owner_uid,pref_name,value, profile) VALUES
556 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."', $profile)");
562 db_query($link, "COMMIT");
566 function get_ssl_certificate_id() {
567 if ($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"]) {
568 return sha1($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"] .
569 $_SERVER["REDIRECT_SSL_CLIENT_V_START"] .
570 $_SERVER["REDIRECT_SSL_CLIENT_V_END"] .
571 $_SERVER["REDIRECT_SSL_CLIENT_S_DN"]);
576 function authenticate_user($link, $login, $password, $check_only = false) {
578 if (!SINGLE_USER_MODE
) {
583 foreach ($pluginhost->get_hooks($pluginhost::HOOK_AUTH_USER
) as $plugin) {
585 $user_id = (int) $plugin->authenticate($login, $password);
588 $_SESSION["auth_module"] = strtolower(get_class($plugin));
593 if ($user_id && !$check_only) {
594 $_SESSION["uid"] = $user_id;
596 $result = db_query($link, "SELECT login,access_level,pwd_hash FROM ttrss_users
597 WHERE id = '$user_id'");
599 $_SESSION["name"] = db_fetch_result($result, 0, "login");
600 $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level");
601 $_SESSION["csrf_token"] = sha1(uniqid(rand(), true));
603 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
606 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
607 $_SESSION["pwd_hash"] = db_fetch_result($result, 0, "pwd_hash");
609 $_SESSION["last_version_check"] = time();
611 initialize_user_prefs($link, $_SESSION["uid"]);
620 $_SESSION["uid"] = 1;
621 $_SESSION["name"] = "admin";
622 $_SESSION["access_level"] = 10;
624 $_SESSION["hide_hello"] = true;
625 $_SESSION["hide_logout"] = true;
627 $_SESSION["auth_module"] = false;
629 if (!$_SESSION["csrf_token"]) {
630 $_SESSION["csrf_token"] = sha1(uniqid(rand(), true));
633 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
635 initialize_user_prefs($link, $_SESSION["uid"]);
641 function make_password($length = 8) {
644 $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ";
648 while ($i < $length) {
649 $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
651 if (!strstr($password, $char)) {
659 // this is called after user is created to initialize default feeds, labels
662 // user preferences are checked on every login, not here
664 function initialize_user($link, $uid) {
666 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
667 values ('$uid', 'Tiny Tiny RSS: New Releases',
668 'http://tt-rss.org/releases.rss')");
670 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
671 values ('$uid', 'Tiny Tiny RSS: Forum',
672 'http://tt-rss.org/forum/rss.php')");
675 function logout_user() {
677 if (isset($_COOKIE[session_name()])) {
678 setcookie(session_name(), '', time()-42000, '/');
682 function validate_csrf($csrf_token) {
683 return $csrf_token == $_SESSION['csrf_token'];
686 function validate_session($link) {
687 if (SINGLE_USER_MODE
) return true;
689 $check_ip = $_SESSION['ip_address'];
691 switch (SESSION_CHECK_ADDRESS
) {
696 $check_ip = substr($check_ip, 0, strrpos($check_ip, '.')+
1);
699 $check_ip = substr($check_ip, 0, strrpos($check_ip, '.'));
700 $check_ip = substr($check_ip, 0, strrpos($check_ip, '.')+
1);
704 if ($check_ip && strpos($_SERVER['REMOTE_ADDR'], $check_ip) !== 0) {
705 $_SESSION["login_error_msg"] =
706 __("Session failed to validate (incorrect IP)");
710 if ($_SESSION["ref_schema_version"] != get_schema_version($link, true))
713 if ($_SESSION["uid"]) {
715 $result = db_query($link,
716 "SELECT pwd_hash FROM ttrss_users WHERE id = '".$_SESSION["uid"]."'");
718 $pwd_hash = db_fetch_result($result, 0, "pwd_hash");
720 if ($pwd_hash != $_SESSION["pwd_hash"]) {
725 /* if ($_SESSION["cookie_lifetime"] && $_SESSION["uid"]) {
727 //print_r($_SESSION);
729 if (time() > $_SESSION["cookie_lifetime"]) {
737 function load_user_plugins($link, $owner_uid) {
739 $plugins = get_pref($link, "_ENABLED_PLUGINS", $owner_uid);
742 $pluginhost->load($plugins, $pluginhost::KIND_USER
, $owner_uid);
744 if (get_schema_version($link) > 100) {
745 $pluginhost->load_data();
750 function login_sequence($link) {
751 $_SESSION["prefs_cache"] = false;
753 if (SINGLE_USER_MODE
) {
754 authenticate_user($link, "admin", null);
756 load_user_plugins($link, $_SESSION["uid"]);
758 if (!$_SESSION["uid"] ||
!validate_session($link)) {
760 if (AUTH_AUTO_LOGIN
&& authenticate_user($link, null, null)) {
761 $_SESSION["ref_schema_version"] = get_schema_version($link, true);
763 authenticate_user($link, null, null, true);
766 if (!$_SESSION["uid"]) render_login_form($link);
769 /* bump login timestamp */
770 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
772 $_SESSION["last_login_update"] = time();
775 if ($_SESSION["uid"] && $_SESSION["language"] && SESSION_COOKIE_LIFETIME
> 0) {
776 setcookie("ttrss_lang", $_SESSION["language"],
777 time() + SESSION_COOKIE_LIFETIME
);
780 if ($_SESSION["uid"]) {
782 load_user_plugins($link, $_SESSION["uid"]);
786 db_query($link, "DELETE FROM ttrss_counters_cache WHERE owner_uid = ".
787 $_SESSION["uid"] . " AND
788 (SELECT COUNT(id) FROM ttrss_feeds WHERE
789 ttrss_feeds.id = feed_id) = 0");
791 db_query($link, "DELETE FROM ttrss_cat_counters_cache WHERE owner_uid = ".
792 $_SESSION["uid"] . " AND
793 (SELECT COUNT(id) FROM ttrss_feed_categories WHERE
794 ttrss_feed_categories.id = feed_id) = 0");
801 function truncate_string($str, $max_len, $suffix = '…') {
802 if (mb_strlen($str, "utf-8") > $max_len - 3) {
803 return mb_substr($str, 0, $max_len, "utf-8") . $suffix;
809 function convert_timestamp($timestamp, $source_tz, $dest_tz) {
812 $source_tz = new DateTimeZone($source_tz);
813 } catch (Exception
$e) {
814 $source_tz = new DateTimeZone('UTC');
818 $dest_tz = new DateTimeZone($dest_tz);
819 } catch (Exception
$e) {
820 $dest_tz = new DateTimeZone('UTC');
823 $dt = new DateTime(date('Y-m-d H:i:s', $timestamp), $source_tz);
824 return $dt->format('U') +
$dest_tz->getOffset($dt);
827 function make_local_datetime($link, $timestamp, $long, $owner_uid = false,
828 $no_smart_dt = false) {
830 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
831 if (!$timestamp) $timestamp = '1970-01-01 0:00';
836 # We store date in UTC internally
837 $dt = new DateTime($timestamp, $utc_tz);
839 if ($tz_offset == -1) {
841 $user_tz_string = get_pref($link, 'USER_TIMEZONE', $owner_uid);
844 $user_tz = new DateTimeZone($user_tz_string);
845 } catch (Exception
$e) {
849 $tz_offset = $user_tz->getOffset($dt);
852 $user_timestamp = $dt->format('U') +
$tz_offset;
855 return smart_date_time($link, $user_timestamp,
856 $tz_offset, $owner_uid);
859 $format = get_pref($link, 'LONG_DATE_FORMAT', $owner_uid);
861 $format = get_pref($link, 'SHORT_DATE_FORMAT', $owner_uid);
863 return date($format, $user_timestamp);
867 function smart_date_time($link, $timestamp, $tz_offset = 0, $owner_uid = false) {
868 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
870 if (date("Y.m.d", $timestamp) == date("Y.m.d", time() +
$tz_offset)) {
871 return date("G:i", $timestamp);
872 } else if (date("Y", $timestamp) == date("Y", time() +
$tz_offset)) {
873 $format = get_pref($link, 'SHORT_DATE_FORMAT', $owner_uid);
874 return date($format, $timestamp);
876 $format = get_pref($link, 'LONG_DATE_FORMAT', $owner_uid);
877 return date($format, $timestamp);
881 function sql_bool_to_bool($s) {
882 if ($s == "t" ||
$s == "1" ||
strtolower($s) == "true") {
889 function bool_to_sql_bool($s) {
897 // Session caching removed due to causing wrong redirects to upgrade
898 // script when get_schema_version() is called on an obsolete session
899 // created on a previous schema version.
900 function get_schema_version($link, $nocache = false) {
901 global $schema_version;
903 if (!$schema_version) {
904 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
905 $version = db_fetch_result($result, 0, "schema_version");
906 $schema_version = $version;
909 return $schema_version;
913 function sanity_check($link) {
914 require_once 'errors.php';
917 $schema_version = get_schema_version($link, true);
919 if ($schema_version != SCHEMA_VERSION
) {
923 if (DB_TYPE
== "mysql") {
924 $result = db_query($link, "SELECT true", false);
925 if (db_num_rows($result) != 1) {
930 if (db_escape_string($link, "testTEST") != "testTEST") {
934 return array("code" => $error_code, "message" => $ERRORS[$error_code]);
937 function file_is_locked($filename) {
938 if (function_exists('flock')) {
939 $fp = @fopen
(LOCK_DIRECTORY
. "/$filename", "r");
941 if (flock($fp, LOCK_EX | LOCK_NB
)) {
952 return true; // consider the file always locked and skip the test
955 function make_lockfile($filename) {
956 $fp = fopen(LOCK_DIRECTORY
. "/$filename", "w");
958 if ($fp && flock($fp, LOCK_EX | LOCK_NB
)) {
959 if (function_exists('posix_getpid')) {
960 fwrite($fp, posix_getpid() . "\n");
968 function make_stampfile($filename) {
969 $fp = fopen(LOCK_DIRECTORY
. "/$filename", "w");
971 if (flock($fp, LOCK_EX | LOCK_NB
)) {
972 fwrite($fp, time() . "\n");
981 function sql_random_function() {
982 if (DB_TYPE
== "mysql") {
989 function catchup_feed($link, $feed, $cat_view, $owner_uid = false, $max_id = false) {
991 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
993 //if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
995 $ref_check_qpart = ($max_id &&
996 !get_pref($link, 'REVERSE_HEADLINES')) ?
"ref_id <= '$max_id'" : "true";
998 if (is_numeric($feed)) {
1004 $children = getChildCategories($link, $feed, $owner_uid);
1005 array_push($children, $feed);
1007 $children = join(",", $children);
1009 $cat_qpart = "cat_id IN ($children)";
1011 $cat_qpart = "cat_id IS NULL";
1014 db_query($link, "UPDATE ttrss_user_entries
1015 SET unread = false,last_read = NOW()
1016 WHERE feed_id IN (SELECT id FROM ttrss_feeds WHERE $cat_qpart)
1017 AND $ref_check_qpart AND unread = true
1018 AND owner_uid = $owner_uid");
1020 } else if ($feed == -2) {
1022 db_query($link, "UPDATE ttrss_user_entries
1023 SET unread = false,last_read = NOW() WHERE (SELECT COUNT(*)
1024 FROM ttrss_user_labels2 WHERE article_id = ref_id) > 0
1025 AND $ref_check_qpart
1026 AND unread = true AND owner_uid = $owner_uid");
1029 } else if ($feed > 0) {
1031 db_query($link, "UPDATE ttrss_user_entries
1032 SET unread = false,last_read = NOW()
1033 WHERE feed_id = '$feed'
1034 AND $ref_check_qpart AND unread = true
1035 AND owner_uid = $owner_uid");
1037 } else if ($feed < 0 && $feed > -10) { // special, like starred
1040 db_query($link, "UPDATE ttrss_user_entries
1041 SET unread = false,last_read = NOW()
1043 AND $ref_check_qpart AND unread = true
1044 AND owner_uid = $owner_uid");
1048 db_query($link, "UPDATE ttrss_user_entries
1049 SET unread = false,last_read = NOW()
1050 WHERE published = true
1051 AND $ref_check_qpart AND unread = true
1052 AND owner_uid = $owner_uid");
1057 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE");
1059 if (DB_TYPE
== "pgsql") {
1060 $match_part = "updated > NOW() - INTERVAL '$intl hour' ";
1062 $match_part = "updated > DATE_SUB(NOW(),
1063 INTERVAL $intl HOUR) ";
1066 $result = db_query($link, "SELECT id FROM ttrss_entries,
1067 ttrss_user_entries WHERE $match_part AND
1069 ttrss_user_entries.ref_id = ttrss_entries.id AND
1070 owner_uid = $owner_uid");
1072 $affected_ids = array();
1074 while ($line = db_fetch_assoc($result)) {
1075 array_push($affected_ids, $line["id"]);
1078 catchupArticlesById($link, $affected_ids, 0);
1082 db_query($link, "UPDATE ttrss_user_entries
1083 SET unread = false,last_read = NOW()
1084 WHERE $ref_check_qpart AND unread = true AND
1085 owner_uid = $owner_uid");
1088 } else if ($feed < -10) { // label
1090 $label_id = -$feed - 11;
1092 db_query($link, "UPDATE ttrss_user_entries, ttrss_user_labels2
1093 SET unread = false, last_read = NOW()
1094 WHERE label_id = '$label_id' AND unread = true
1095 AND $ref_check_qpart
1096 AND owner_uid = '$owner_uid' AND ref_id = article_id");
1100 ccache_update($link, $feed, $owner_uid, $cat_view);
1103 db_query($link, "BEGIN");
1105 $tag_name = db_escape_string($link, $feed);
1107 $result = db_query($link, "SELECT post_int_id FROM ttrss_tags
1108 WHERE tag_name = '$tag_name' AND owner_uid = $owner_uid");
1110 while ($line = db_fetch_assoc($result)) {
1111 db_query($link, "UPDATE ttrss_user_entries SET
1112 unread = false, last_read = NOW()
1113 WHERE $ref_check_qpart AND unread = true
1114 AND int_id = " . $line["post_int_id"]);
1116 db_query($link, "COMMIT");
1120 function getAllCounters($link) {
1121 $data = getGlobalCounters($link);
1123 $data = array_merge($data, getVirtCounters($link));
1124 $data = array_merge($data, getLabelCounters($link));
1125 $data = array_merge($data, getFeedCounters($link, $active_feed));
1126 $data = array_merge($data, getCategoryCounters($link));
1131 function getCategoryTitle($link, $cat_id) {
1133 if ($cat_id == -1) {
1134 return __("Special");
1135 } else if ($cat_id == -2) {
1136 return __("Labels");
1139 $result = db_query($link, "SELECT title FROM ttrss_feed_categories WHERE
1142 if (db_num_rows($result) == 1) {
1143 return db_fetch_result($result, 0, "title");
1145 return __("Uncategorized");
1151 function getCategoryCounters($link) {
1154 /* Labels category */
1156 $cv = array("id" => -2, "kind" => "cat",
1157 "counter" => getCategoryUnread($link, -2));
1159 array_push($ret_arr, $cv);
1161 $result = db_query($link, "SELECT id AS cat_id, value AS unread,
1162 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2
1163 WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children
1164 FROM ttrss_feed_categories, ttrss_cat_counters_cache
1165 WHERE ttrss_cat_counters_cache.feed_id = id AND
1166 ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND
1167 ttrss_feed_categories.owner_uid = " . $_SESSION["uid"]);
1169 while ($line = db_fetch_assoc($result)) {
1170 $line["cat_id"] = (int) $line["cat_id"];
1172 if ($line["num_children"] > 0) {
1173 $child_counter = getCategoryChildrenUnread($link, $line["cat_id"], $_SESSION["uid"]);
1178 $cv = array("id" => $line["cat_id"], "kind" => "cat",
1179 "counter" => $line["unread"] +
$child_counter);
1181 array_push($ret_arr, $cv);
1184 /* Special case: NULL category doesn't actually exist in the DB */
1186 $cv = array("id" => 0, "kind" => "cat",
1187 "counter" => (int) ccache_find($link, 0, $_SESSION["uid"], true));
1189 array_push($ret_arr, $cv);
1194 // only accepts real cats (>= 0)
1195 function getCategoryChildrenUnread($link, $cat, $owner_uid = false) {
1196 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1198 $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE parent_cat = '$cat'
1199 AND owner_uid = $owner_uid");
1203 while ($line = db_fetch_assoc($result)) {
1204 $unread +
= getCategoryUnread($link, $line["id"], $owner_uid);
1205 $unread +
= getCategoryChildrenUnread($link, $line["id"], $owner_uid);
1211 function getCategoryUnread($link, $cat, $owner_uid = false) {
1213 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1218 $cat_query = "cat_id = '$cat'";
1220 $cat_query = "cat_id IS NULL";
1223 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE $cat_query
1224 AND owner_uid = " . $owner_uid);
1226 $cat_feeds = array();
1227 while ($line = db_fetch_assoc($result)) {
1228 array_push($cat_feeds, "feed_id = " . $line["id"]);
1231 if (count($cat_feeds) == 0) return 0;
1233 $match_part = implode(" OR ", $cat_feeds);
1235 $result = db_query($link, "SELECT COUNT(int_id) AS unread
1236 FROM ttrss_user_entries
1237 WHERE unread = true AND ($match_part)
1238 AND owner_uid = " . $owner_uid);
1242 # this needs to be rewritten
1243 while ($line = db_fetch_assoc($result)) {
1244 $unread +
= $line["unread"];
1248 } else if ($cat == -1) {
1249 return getFeedUnread($link, -1) +
getFeedUnread($link, -2) +
getFeedUnread($link, -3) +
getFeedUnread($link, 0);
1250 } else if ($cat == -2) {
1252 $result = db_query($link, "
1253 SELECT COUNT(unread) AS unread FROM
1254 ttrss_user_entries, ttrss_user_labels2
1255 WHERE article_id = ref_id AND unread = true
1256 AND ttrss_user_entries.owner_uid = '$owner_uid'");
1258 $unread = db_fetch_result($result, 0, "unread");
1265 function getFeedUnread($link, $feed, $is_cat = false) {
1266 return getFeedArticles($link, $feed, $is_cat, true, $_SESSION["uid"]);
1269 function getLabelUnread($link, $label_id, $owner_uid = false) {
1270 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1272 $result = db_query($link, "SELECT COUNT(ref_id) AS unread FROM ttrss_user_entries, ttrss_user_labels2
1273 WHERE owner_uid = '$owner_uid' AND unread = true AND label_id = '$label_id' AND article_id = ref_id");
1275 if (db_num_rows($result) != 0) {
1276 return db_fetch_result($result, 0, "unread");
1282 function getFeedArticles($link, $feed, $is_cat = false, $unread_only = false,
1283 $owner_uid = false) {
1285 $n_feed = (int) $feed;
1286 $need_entries = false;
1288 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1291 $unread_qpart = "unread = true";
1293 $unread_qpart = "true";
1297 return getCategoryUnread($link, $n_feed, $owner_uid);
1298 } else if ($n_feed == -6) {
1300 } else if ($feed != "0" && $n_feed == 0) {
1302 $feed = db_escape_string($link, $feed);
1304 $result = db_query($link, "SELECT SUM((SELECT COUNT(int_id)
1305 FROM ttrss_user_entries,ttrss_entries WHERE int_id = post_int_id
1306 AND ref_id = id AND $unread_qpart)) AS count FROM ttrss_tags
1307 WHERE owner_uid = $owner_uid AND tag_name = '$feed'");
1308 return db_fetch_result($result, 0, "count");
1310 } else if ($n_feed == -1) {
1311 $match_part = "marked = true";
1312 } else if ($n_feed == -2) {
1313 $match_part = "published = true";
1314 } else if ($n_feed == -3) {
1315 $match_part = "unread = true AND score >= 0";
1317 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid);
1319 if (DB_TYPE
== "pgsql") {
1320 $match_part .= " AND updated > NOW() - INTERVAL '$intl hour' ";
1322 $match_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
1325 $need_entries = true;
1327 } else if ($n_feed == -4) {
1328 $match_part = "true";
1329 } else if ($n_feed >= 0) {
1332 $match_part = "feed_id = '$n_feed'";
1334 $match_part = "feed_id IS NULL";
1337 } else if ($feed < -10) {
1339 $label_id = -$feed - 11;
1341 return getLabelUnread($link, $label_id, $owner_uid);
1347 if ($need_entries) {
1348 $from_qpart = "ttrss_user_entries,ttrss_entries";
1349 $from_where = "ttrss_entries.id = ttrss_user_entries.ref_id AND";
1351 $from_qpart = "ttrss_user_entries";
1354 $query = "SELECT count(int_id) AS unread
1355 FROM $from_qpart WHERE
1356 $unread_qpart AND $from_where ($match_part) AND ttrss_user_entries.owner_uid = $owner_uid";
1358 //echo "[$feed/$query]\n";
1360 $result = db_query($link, $query);
1364 $result = db_query($link, "SELECT COUNT(post_int_id) AS unread
1365 FROM ttrss_tags,ttrss_user_entries,ttrss_entries
1366 WHERE tag_name = '$feed' AND post_int_id = int_id AND ref_id = ttrss_entries.id
1367 AND $unread_qpart AND ttrss_tags.owner_uid = " . $owner_uid);
1370 $unread = db_fetch_result($result, 0, "unread");
1375 function getGlobalUnread($link, $user_id = false) {
1378 $user_id = $_SESSION["uid"];
1381 $result = db_query($link, "SELECT SUM(value) AS c_id FROM ttrss_counters_cache
1382 WHERE owner_uid = '$user_id' AND feed_id > 0");
1384 $c_id = db_fetch_result($result, 0, "c_id");
1389 function getGlobalCounters($link, $global_unread = -1) {
1392 if ($global_unread == -1) {
1393 $global_unread = getGlobalUnread($link);
1396 $cv = array("id" => "global-unread",
1397 "counter" => (int) $global_unread);
1399 array_push($ret_arr, $cv);
1401 $result = db_query($link, "SELECT COUNT(id) AS fn FROM
1402 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1404 $subscribed_feeds = db_fetch_result($result, 0, "fn");
1406 $cv = array("id" => "subscribed-feeds",
1407 "counter" => (int) $subscribed_feeds);
1409 array_push($ret_arr, $cv);
1414 function getVirtCounters($link) {
1418 for ($i = 0; $i >= -4; $i--) {
1420 $count = getFeedUnread($link, $i);
1422 $cv = array("id" => $i,
1423 "counter" => (int) $count);
1425 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1426 // $cv["xmsg"] = getFeedArticles($link, $i)." ".__("total");
1428 array_push($ret_arr, $cv);
1434 function getLabelCounters($link, $descriptions = false) {
1438 $owner_uid = $_SESSION["uid"];
1440 $result = db_query($link, "SELECT id,caption,COUNT(unread) AS unread
1441 FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON
1442 (ttrss_labels2.id = label_id)
1443 LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND unread = true)
1444 WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id,
1445 ttrss_labels2.caption");
1447 while ($line = db_fetch_assoc($result)) {
1449 $id = -$line["id"] - 11;
1451 $label_name = $line["caption"];
1452 $count = $line["unread"];
1454 $cv = array("id" => $id,
1455 "counter" => (int) $count);
1458 $cv["description"] = $label_name;
1460 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1461 // $cv["xmsg"] = getFeedArticles($link, $id)." ".__("total");
1463 array_push($ret_arr, $cv);
1469 function getFeedCounters($link, $active_feed = false) {
1473 $query = "SELECT ttrss_feeds.id,
1475 ".SUBSTRING_FOR_DATE
."(ttrss_feeds.last_updated,1,19) AS last_updated,
1476 last_error, value AS count
1477 FROM ttrss_feeds, ttrss_counters_cache
1478 WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
1479 AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
1480 AND ttrss_counters_cache.feed_id = id";
1482 $result = db_query($link, $query);
1483 $fctrs_modified = false;
1485 while ($line = db_fetch_assoc($result)) {
1488 $count = $line["count"];
1489 $last_error = htmlspecialchars($line["last_error"]);
1491 $last_updated = make_local_datetime($link, $line['last_updated'], false);
1493 $has_img = feed_has_icon($id);
1495 if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2)
1498 $cv = array("id" => $id,
1499 "updated" => $last_updated,
1500 "counter" => (int) $count,
1501 "has_img" => (int) $has_img);
1504 $cv["error"] = $last_error;
1506 // if (get_pref($link, 'EXTENDED_FEEDLIST'))
1507 // $cv["xmsg"] = getFeedArticles($link, $id)." ".__("total");
1509 if ($active_feed && $id == $active_feed)
1510 $cv["title"] = truncate_string($line["title"], 30);
1512 array_push($ret_arr, $cv);
1519 function get_pgsql_version($link) {
1520 $result = db_query($link, "SELECT version() AS version");
1521 $version = explode(" ", db_fetch_result($result, 0, "version"));
1526 * @return array (code => Status code, message => error message if available)
1528 * 0 - OK, Feed already exists
1529 * 1 - OK, Feed added
1531 * 3 - URL content is HTML, no feeds available
1532 * 4 - URL content is HTML which contains multiple feeds.
1533 * Here you should call extractfeedurls in rpc-backend
1534 * to get all possible feeds.
1535 * 5 - Couldn't download the URL content.
1537 function subscribe_to_feed($link, $url, $cat_id = 0,
1538 $auth_login = '', $auth_pass = '') {
1540 global $fetch_last_error;
1542 require_once "include/rssfuncs.php";
1544 $url = fix_url($url);
1546 if (!$url ||
!validate_feed_url($url)) return array("code" => 2);
1548 $contents = @fetch_file_contents
($url, false, $auth_login, $auth_pass);
1551 return array("code" => 5, "message" => $fetch_last_error);
1554 if (is_html($contents)) {
1555 $feedUrls = get_feeds_from_html($url, $contents);
1557 if (count($feedUrls) == 0) {
1558 return array("code" => 3);
1559 } else if (count($feedUrls) > 1) {
1560 return array("code" => 4, "feeds" => $feedUrls);
1562 //use feed url as new URL
1563 $url = key($feedUrls);
1566 if ($cat_id == "0" ||
!$cat_id) {
1567 $cat_qpart = "NULL";
1569 $cat_qpart = "'$cat_id'";
1572 $result = db_query($link,
1573 "SELECT id FROM ttrss_feeds
1574 WHERE feed_url = '$url' AND owner_uid = ".$_SESSION["uid"]);
1576 if (db_num_rows($result) == 0) {
1577 $result = db_query($link,
1578 "INSERT INTO ttrss_feeds
1579 (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method)
1580 VALUES ('".$_SESSION["uid"]."', '$url',
1581 '[Unknown]', $cat_qpart, '$auth_login', '$auth_pass', 0)");
1583 $result = db_query($link,
1584 "SELECT id FROM ttrss_feeds WHERE feed_url = '$url'
1585 AND owner_uid = " . $_SESSION["uid"]);
1587 $feed_id = db_fetch_result($result, 0, "id");
1590 update_rss_feed($link, $feed_id, true);
1593 return array("code" => 1);
1595 return array("code" => 0);
1599 function print_feed_select($link, $id, $default_id = "",
1600 $attributes = "", $include_all_feeds = true,
1601 $root_id = false, $nest_level = 0) {
1604 print "<select id=\"$id\" name=\"$id\" $attributes>";
1605 if ($include_all_feeds) {
1606 $is_selected = ("0" == $default_id) ?
"selected=\"1\"" : "";
1607 print "<option $is_selected value=\"0\">".__('All feeds')."</option>";
1611 if (get_pref($link, 'ENABLE_FEED_CATS')) {
1614 $parent_qpart = "parent_cat = '$root_id'";
1616 $parent_qpart = "parent_cat IS NULL";
1618 $result = db_query($link, "SELECT id,title,
1619 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1620 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1621 FROM ttrss_feed_categories
1622 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1624 while ($line = db_fetch_assoc($result)) {
1626 for ($i = 0; $i < $nest_level; $i++
)
1627 $line["title"] = " - " . $line["title"];
1629 $is_selected = ("CAT:".$line["id"] == $default_id) ?
"selected=\"1\"" : "";
1631 printf("<option $is_selected value='CAT:%d'>%s</option>",
1632 $line["id"], htmlspecialchars($line["title"]));
1634 if ($line["num_children"] > 0)
1635 print_feed_select($link, $id, $default_id, $attributes,
1636 $include_all_feeds, $line["id"], $nest_level+
1);
1638 $feed_result = db_query($link, "SELECT id,title FROM ttrss_feeds
1639 WHERE cat_id = '".$line["id"]."' AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1641 while ($fline = db_fetch_assoc($feed_result)) {
1642 $is_selected = ($fline["id"] == $default_id) ?
"selected=\"1\"" : "";
1644 $fline["title"] = " + " . $fline["title"];
1646 for ($i = 0; $i < $nest_level; $i++
)
1647 $fline["title"] = " - " . $fline["title"];
1649 printf("<option $is_selected value='%d'>%s</option>",
1650 $fline["id"], htmlspecialchars($fline["title"]));
1655 $is_selected = ($default_id == "CAT:0") ?
"selected=\"1\"" : "";
1657 printf("<option $is_selected value='CAT:0'>%s</option>",
1658 __("Uncategorized"));
1660 $feed_result = db_query($link, "SELECT id,title FROM ttrss_feeds
1661 WHERE cat_id IS NULL AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1663 while ($fline = db_fetch_assoc($feed_result)) {
1664 $is_selected = ($fline["id"] == $default_id && !$default_is_cat) ?
"selected=\"1\"" : "";
1666 $fline["title"] = " + " . $fline["title"];
1668 for ($i = 0; $i < $nest_level; $i++
)
1669 $fline["title"] = " - " . $fline["title"];
1671 printf("<option $is_selected value='%d'>%s</option>",
1672 $fline["id"], htmlspecialchars($fline["title"]));
1677 $result = db_query($link, "SELECT id,title FROM ttrss_feeds
1678 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1680 while ($line = db_fetch_assoc($result)) {
1682 $is_selected = ($line["id"] == $default_id) ?
"selected=\"1\"" : "";
1684 printf("<option $is_selected value='%d'>%s</option>",
1685 $line["id"], htmlspecialchars($line["title"]));
1694 function print_feed_cat_select($link, $id, $default_id,
1695 $attributes, $include_all_cats = true, $root_id = false, $nest_level = 0) {
1698 print "<select id=\"$id\" name=\"$id\" default=\"$default_id\" onchange=\"catSelectOnChange(this)\" $attributes>";
1702 $parent_qpart = "parent_cat = '$root_id'";
1704 $parent_qpart = "parent_cat IS NULL";
1706 $result = db_query($link, "SELECT id,title,
1707 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1708 c2.parent_cat = ttrss_feed_categories.id) AS num_children
1709 FROM ttrss_feed_categories
1710 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1712 while ($line = db_fetch_assoc($result)) {
1713 if ($line["id"] == $default_id) {
1714 $is_selected = "selected=\"1\"";
1719 for ($i = 0; $i < $nest_level; $i++
)
1720 $line["title"] = " - " . $line["title"];
1723 printf("<option $is_selected value='%d'>%s</option>",
1724 $line["id"], htmlspecialchars($line["title"]));
1726 if ($line["num_children"] > 0)
1727 print_feed_cat_select($link, $id, $default_id, $attributes,
1728 $include_all_cats, $line["id"], $nest_level+
1);
1732 if ($include_all_cats) {
1733 if (db_num_rows($result) > 0) {
1734 print "<option disabled=\"1\">--------</option>";
1737 if ($default_id == 0) {
1738 $is_selected = "selected=\"1\"";
1743 print "<option $is_selected value=\"0\">".__('Uncategorized')."</option>";
1749 function checkbox_to_sql_bool($val) {
1750 return ($val == "on") ?
"true" : "false";
1753 function getFeedCatTitle($link, $id) {
1755 return __("Special");
1756 } else if ($id < -10) {
1757 return __("Labels");
1758 } else if ($id > 0) {
1759 $result = db_query($link, "SELECT ttrss_feed_categories.title
1760 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1761 cat_id = ttrss_feed_categories.id");
1762 if (db_num_rows($result) == 1) {
1763 return db_fetch_result($result, 0, "title");
1765 return __("Uncategorized");
1768 return "getFeedCatTitle($id) failed";
1773 function getFeedIcon($id) {
1776 return "images/archive.png";
1779 return "images/mark_set.svg";
1782 return "images/pub_set.svg";
1785 return "images/fresh.png";
1788 return "images/tag.png";
1791 return "images/recently_read.png";
1795 return "images/label.png";
1797 if (file_exists(ICONS_DIR
. "/$id.ico"))
1798 return ICONS_URL
. "/$id.ico";
1804 function getFeedTitle($link, $id, $cat = false) {
1806 return getCategoryTitle($link, $id);
1807 } else if ($id == -1) {
1808 return __("Starred articles");
1809 } else if ($id == -2) {
1810 return __("Published articles");
1811 } else if ($id == -3) {
1812 return __("Fresh articles");
1813 } else if ($id == -4) {
1814 return __("All articles");
1815 } else if ($id === 0 ||
$id === "0") {
1816 return __("Archived articles");
1817 } else if ($id == -6) {
1818 return __("Recently read");
1819 } else if ($id < -10) {
1820 $label_id = -$id - 11;
1821 $result = db_query($link, "SELECT caption FROM ttrss_labels2 WHERE id = '$label_id'");
1822 if (db_num_rows($result) == 1) {
1823 return db_fetch_result($result, 0, "caption");
1825 return "Unknown label ($label_id)";
1828 } else if (is_numeric($id) && $id > 0) {
1829 $result = db_query($link, "SELECT title FROM ttrss_feeds WHERE id = '$id'");
1830 if (db_num_rows($result) == 1) {
1831 return db_fetch_result($result, 0, "title");
1833 return "Unknown feed ($id)";
1840 function make_init_params($link) {
1843 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
1844 "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
1845 "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE", "DEFAULT_ARTICLE_LIMIT",
1846 "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
1848 $params[strtolower($param)] = (int) get_pref($link, $param);
1851 $params["icons_url"] = ICONS_URL
;
1852 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME
;
1853 $params["default_view_mode"] = get_pref($link, "_DEFAULT_VIEW_MODE");
1854 $params["default_view_limit"] = (int) get_pref($link, "_DEFAULT_VIEW_LIMIT");
1855 $params["default_view_order_by"] = get_pref($link, "_DEFAULT_VIEW_ORDER_BY");
1856 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
1858 $result = db_query($link, "SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
1859 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1861 $max_feed_id = db_fetch_result($result, 0, "mid");
1862 $num_feeds = db_fetch_result($result, 0, "nf");
1864 $params["max_feed_id"] = (int) $max_feed_id;
1865 $params["num_feeds"] = (int) $num_feeds;
1867 $params["collapsed_feedlist"] = (int) get_pref($link, "_COLLAPSED_FEEDLIST");
1868 $params["hotkeys"] = get_hotkeys_map($link);
1870 $params["csrf_token"] = $_SESSION["csrf_token"];
1871 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
1873 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE
;
1878 function get_hotkeys_info($link) {
1880 __("Navigation") => array(
1881 "next_feed" => __("Open next feed"),
1882 "prev_feed" => __("Open previous feed"),
1883 "next_article" => __("Open next article"),
1884 "prev_article" => __("Open previous article"),
1885 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
1886 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
1887 "search_dialog" => __("Show search dialog")),
1888 __("Article") => array(
1889 "toggle_mark" => __("Toggle starred"),
1890 "toggle_publ" => __("Toggle published"),
1891 "toggle_unread" => __("Toggle unread"),
1892 "edit_tags" => __("Edit tags"),
1893 "dismiss_selected" => __("Dismiss selected"),
1894 "dismiss_read" => __("Dismiss read"),
1895 "open_in_new_window" => __("Open in new window"),
1896 "catchup_below" => __("Mark below as read"),
1897 "catchup_above" => __("Mark above as read"),
1898 "article_scroll_down" => __("Scroll down"),
1899 "article_scroll_up" => __("Scroll up"),
1900 "select_article_cursor" => __("Select article under cursor"),
1901 "email_article" => __("Email article"),
1902 "close_article" => __("Close/collapse article"),
1903 "toggle_widescreen" => __("Toggle widescreen mode"),
1904 "toggle_embed_original" => __("Toggle embed original")),
1905 __("Article selection") => array(
1906 "select_all" => __("Select all articles"),
1907 "select_unread" => __("Select unread"),
1908 "select_marked" => __("Select starred"),
1909 "select_published" => __("Select published"),
1910 "select_invert" => __("Invert selection"),
1911 "select_none" => __("Deselect everything")),
1912 __("Feed") => array(
1913 "feed_refresh" => __("Refresh current feed"),
1914 "feed_unhide_read" => __("Un/hide read feeds"),
1915 "feed_subscribe" => __("Subscribe to feed"),
1916 "feed_edit" => __("Edit feed"),
1917 "feed_catchup" => __("Mark as read"),
1918 "feed_reverse" => __("Reverse headlines"),
1919 "feed_debug_update" => __("Debug feed update"),
1920 "catchup_all" => __("Mark all feeds as read"),
1921 "cat_toggle_collapse" => __("Un/collapse current category"),
1922 "toggle_combined_mode" => __("Toggle combined mode")),
1923 __("Go to") => array(
1924 "goto_all" => __("All articles"),
1925 "goto_fresh" => __("Fresh"),
1926 "goto_marked" => __("Starred"),
1927 "goto_published" => __("Published"),
1928 "goto_tagcloud" => __("Tag cloud"),
1929 "goto_prefs" => __("Preferences")),
1930 __("Other") => array(
1931 "create_label" => __("Create label"),
1932 "create_filter" => __("Create filter"),
1933 "collapse_sidebar" => __("Un/collapse sidebar"),
1934 "help_dialog" => __("Show help dialog"))
1940 function get_hotkeys_map($link) {
1942 // "navigation" => array(
1945 "n" => "next_article",
1946 "p" => "prev_article",
1947 "(38)|up" => "prev_article",
1948 "(40)|down" => "next_article",
1949 // "^(38)|Ctrl-up" => "prev_article_noscroll",
1950 // "^(40)|Ctrl-down" => "next_article_noscroll",
1951 "(191)|/" => "search_dialog",
1952 // "article" => array(
1953 "s" => "toggle_mark",
1954 "*s" => "toggle_publ",
1955 "u" => "toggle_unread",
1956 "*t" => "edit_tags",
1957 "*d" => "dismiss_selected",
1958 "*x" => "dismiss_read",
1959 "o" => "open_in_new_window",
1960 "c p" => "catchup_below",
1961 "c n" => "catchup_above",
1962 "*n" => "article_scroll_down",
1963 "*p" => "article_scroll_up",
1964 "*(38)|Shift+up" => "article_scroll_up",
1965 "*(40)|Shift+down" => "article_scroll_down",
1966 "a *w" => "toggle_widescreen",
1967 "a e" => "toggle_embed_original",
1968 "e" => "email_article",
1969 "a q" => "close_article",
1970 // "article_selection" => array(
1971 "a a" => "select_all",
1972 "a u" => "select_unread",
1973 "a *u" => "select_marked",
1974 "a p" => "select_published",
1975 "a i" => "select_invert",
1976 "a n" => "select_none",
1978 "f r" => "feed_refresh",
1979 "f a" => "feed_unhide_read",
1980 "f s" => "feed_subscribe",
1981 "f e" => "feed_edit",
1982 "f q" => "feed_catchup",
1983 "f x" => "feed_reverse",
1984 "f *d" => "feed_debug_update",
1985 "f *c" => "toggle_combined_mode",
1986 "*q" => "catchup_all",
1987 "x" => "cat_toggle_collapse",
1989 "g a" => "goto_all",
1990 "g f" => "goto_fresh",
1991 "g s" => "goto_marked",
1992 "g p" => "goto_published",
1993 "g t" => "goto_tagcloud",
1994 "g *p" => "goto_prefs",
1995 // "other" => array(
1996 "(9)|Tab" => "select_article_cursor", // tab
1997 "c l" => "create_label",
1998 "c f" => "create_filter",
1999 "c s" => "collapse_sidebar",
2000 "^(191)|Ctrl+/" => "help_dialog",
2003 if (get_pref($link, 'COMBINED_DISPLAY_MODE')) {
2004 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
2005 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
2009 foreach ($pluginhost->get_hooks($pluginhost::HOOK_HOTKEY_MAP
) as $plugin) {
2010 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
2013 $prefixes = array();
2015 foreach (array_keys($hotkeys) as $hotkey) {
2016 $pair = explode(" ", $hotkey, 2);
2018 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
2019 array_push($prefixes, $pair[0]);
2023 return array($prefixes, $hotkeys);
2026 function make_runtime_info($link) {
2029 $result = db_query($link, "SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2030 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2032 $max_feed_id = db_fetch_result($result, 0, "mid");
2033 $num_feeds = db_fetch_result($result, 0, "nf");
2035 $data["max_feed_id"] = (int) $max_feed_id;
2036 $data["num_feeds"] = (int) $num_feeds;
2038 $data['last_article_id'] = getLastArticleId($link);
2039 $data['cdm_expanded'] = get_pref($link, 'CDM_EXPANDED');
2041 $data['dep_ts'] = calculate_dep_timestamp();
2042 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
2044 if (file_exists(LOCK_DIRECTORY
. "/update_daemon.lock")) {
2046 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
2048 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
2050 $stamp = (int) @file_get_contents
(LOCK_DIRECTORY
. "/update_daemon.stamp");
2053 $stamp_delta = time() - $stamp;
2055 if ($stamp_delta > 1800) {
2059 $_SESSION["daemon_stamp_check"] = time();
2062 $data['daemon_stamp_ok'] = $stamp_check;
2064 $stamp_fmt = date("Y.m.d, G:i", $stamp);
2066 $data['daemon_stamp'] = $stamp_fmt;
2071 if ($_SESSION["last_version_check"] +
86400 +
rand(-1000, 1000) < time()) {
2072 $new_version_details = @check_for_update
($link);
2074 $data['new_version_available'] = (int) ($new_version_details != false);
2076 $_SESSION["last_version_check"] = time();
2077 $_SESSION["version_data"] = $new_version_details;
2083 function search_to_sql($link, $search) {
2085 $search_query_part = "";
2087 $keywords = explode(" ", $search);
2088 $query_keywords = array();
2090 foreach ($keywords as $k) {
2091 if (strpos($k, "-") === 0) {
2098 $commandpair = explode(":", mb_strtolower($k), 2);
2100 if ($commandpair[0] == "note" && $commandpair[1]) {
2102 if ($commandpair[1] == "true")
2103 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
2105 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
2107 } else if ($commandpair[0] == "star" && $commandpair[1]) {
2109 if ($commandpair[1] == "true")
2110 array_push($query_keywords, "($not (marked = true))");
2112 array_push($query_keywords, "($not (marked = false))");
2114 } else if ($commandpair[0] == "pub" && $commandpair[1]) {
2116 if ($commandpair[1] == "true")
2117 array_push($query_keywords, "($not (published = true))");
2119 array_push($query_keywords, "($not (published = false))");
2121 } else if (strpos($k, "@") === 0) {
2123 $user_tz_string = get_pref($link, 'USER_TIMEZONE', $_SESSION['uid']);
2124 $orig_ts = strtotime(substr($k, 1));
2125 $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
2127 //$k = date("Y-m-d", strtotime(substr($k, 1)));
2129 array_push($query_keywords, "(".SUBSTRING_FOR_DATE
."(updated,1,LENGTH('$k')) $not = '$k')");
2131 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2132 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2136 $search_query_part = implode("AND", $query_keywords);
2138 return $search_query_part;
2141 function getParentCategories($link, $cat, $owner_uid) {
2144 $result = db_query($link, "SELECT parent_cat FROM ttrss_feed_categories
2145 WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
2147 while ($line = db_fetch_assoc($result)) {
2148 array_push($rv, $line["parent_cat"]);
2149 $rv = array_merge($rv, getParentCategories($link, $line["parent_cat"], $owner_uid));
2155 function getChildCategories($link, $cat, $owner_uid) {
2158 $result = db_query($link, "SELECT id FROM ttrss_feed_categories
2159 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
2161 while ($line = db_fetch_assoc($result)) {
2162 array_push($rv, $line["id"]);
2163 $rv = array_merge($rv, getChildCategories($link, $line["id"], $owner_uid));
2169 function queryFeedHeadlines($link, $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) {
2171 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2173 $ext_tables_part = "";
2177 if (SPHINX_ENABLED
) {
2178 $ids = join(",", @sphinx_search
($search, 0, 500));
2181 $search_query_part = "ref_id IN ($ids) AND ";
2183 $search_query_part = "ref_id = -1 AND ";
2186 $search_query_part = search_to_sql($link, $search);
2187 $search_query_part .= " AND ";
2191 $search_query_part = "";
2196 if (DB_TYPE
== "pgsql") {
2197 $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
2199 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
2202 $override_order = "updated DESC";
2204 $filter_query_part = filter_to_sql($link, $filter, $owner_uid);
2206 // Try to check if SQL regexp implementation chokes on a valid regexp
2207 $result = db_query($link, "SELECT true AS true_val FROM ttrss_entries,
2208 ttrss_user_entries, ttrss_feeds, ttrss_feed_categories
2209 WHERE $filter_query_part LIMIT 1", false);
2212 $test = db_fetch_result($result, 0, "true_val");
2215 $filter_query_part = "false AND";
2217 $filter_query_part .= " AND";
2220 $filter_query_part = "false AND";
2224 $filter_query_part = "";
2228 $since_id_part = "ttrss_entries.id > $since_id AND ";
2230 $since_id_part = "";
2233 $view_query_part = "";
2235 if ($view_mode == "adaptive" ||
$view_query_part == "noscores") {
2237 $view_query_part = " ";
2238 } else if ($feed != -1) {
2240 $unread = getFeedUnread($link, $feed, $cat_view);
2242 if ($cat_view && $feed > 0 && $include_children)
2243 $unread +
= getCategoryChildrenUnread($link, $feed);
2246 $view_query_part = " unread = true AND ";
2251 if ($view_mode == "marked") {
2252 $view_query_part = " marked = true AND ";
2255 if ($view_mode == "published") {
2256 $view_query_part = " published = true AND ";
2259 if ($view_mode == "unread") {
2260 $view_query_part = " unread = true AND ";
2263 if ($view_mode == "updated") {
2264 $view_query_part = " (last_read is null and unread = false) AND ";
2268 $limit_query_part = "LIMIT " . $limit;
2271 $allow_archived = false;
2273 $vfeed_query_part = "";
2275 // override query strategy and enable feed display when searching globally
2276 if ($search && $search_mode == "all_feeds") {
2277 $query_strategy_part = "true";
2278 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2280 } else if (!is_numeric($feed)) {
2281 $query_strategy_part = "true";
2282 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2283 id = feed_id) as feed_title,";
2284 } else if ($search && $search_mode == "this_cat") {
2285 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2288 if ($include_children) {
2289 $subcats = getChildCategories($link, $feed, $owner_uid);
2290 array_push($subcats, $feed);
2291 $cats_qpart = join(",", $subcats);
2293 $cats_qpart = $feed;
2296 $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
2299 $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
2302 } else if ($feed > 0) {
2307 if ($include_children) {
2309 $subcats = getChildCategories($link, $feed, $owner_uid);
2311 array_push($subcats, $feed);
2312 $query_strategy_part = "cat_id IN (".
2313 implode(",", $subcats).")";
2316 $query_strategy_part = "cat_id = '$feed'";
2320 $query_strategy_part = "cat_id IS NULL";
2323 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2326 $query_strategy_part = "feed_id = '$feed'";
2328 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
2329 $query_strategy_part = "feed_id IS NULL";
2330 $allow_archived = true;
2331 } else if ($feed == 0 && $cat_view) { // uncategorized
2332 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
2333 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2334 } else if ($feed == -1) { // starred virtual feed
2335 $query_strategy_part = "marked = true";
2336 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2337 $allow_archived = true;
2339 if (!$override_order) {
2340 if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) {
2341 $override_order = "date_entered";
2343 $override_order = "last_marked DESC, date_entered DESC";
2347 } else if ($feed == -2) { // published virtual feed OR labels category
2350 $query_strategy_part = "published = true";
2351 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2352 $allow_archived = true;
2354 if (!$override_order) {
2355 if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) {
2356 $override_order = "date_entered";
2358 $override_order = "last_published DESC, date_entered DESC";
2363 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2365 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2367 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
2368 ttrss_user_labels2.article_id = ref_id";
2371 } else if ($feed == -6) { // recently read
2372 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
2373 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2374 $allow_archived = true;
2376 if (!$override_order) $override_order = "last_read DESC";
2377 } else if ($feed == -3) { // fresh virtual feed
2378 $query_strategy_part = "unread = true AND score >= 0";
2380 $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid);
2382 if (DB_TYPE
== "pgsql") {
2383 $query_strategy_part .= " AND updated > NOW() - INTERVAL '$intl hour' ";
2385 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
2388 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2389 } else if ($feed == -4) { // all articles virtual feed
2390 $query_strategy_part = "true";
2391 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2392 } else if ($feed <= -10) { // labels
2393 $label_id = -$feed - 11;
2395 $query_strategy_part = "label_id = '$label_id' AND
2396 ttrss_labels2.id = ttrss_user_labels2.label_id AND
2397 ttrss_user_labels2.article_id = ref_id";
2399 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2400 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2401 $allow_archived = true;
2404 $query_strategy_part = "true";
2407 if (get_pref($link, "SORT_HEADLINES_BY_FEED_DATE", $owner_uid)) {
2408 $date_sort_field = "updated";
2410 $date_sort_field = "date_entered";
2413 if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) {
2414 $order_by = "$date_sort_field";
2416 $order_by = "$date_sort_field DESC";
2419 if ($view_mode != "noscores") {
2420 $order_by = "score DESC, $order_by";
2423 if ($view_mode == "unread_first") {
2424 $order_by = "unread DESC, $order_by";
2427 if ($override_order) {
2428 $order_by = $override_order;
2434 $feed_title = T_sprintf("Search results: %s", $search);
2437 $feed_title = getCategoryTitle($link, $feed);
2439 if (is_numeric($feed) && $feed > 0) {
2440 $result = db_query($link, "SELECT title,site_url,last_error
2441 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
2443 $feed_title = db_fetch_result($result, 0, "title");
2444 $feed_site_url = db_fetch_result($result, 0, "site_url");
2445 $last_error = db_fetch_result($result, 0, "last_error");
2447 $feed_title = getFeedTitle($link, $feed);
2452 $content_query_part = "content as content_preview, cached_content, ";
2454 if (is_numeric($feed)) {
2457 $feed_kind = "Feeds";
2459 $feed_kind = "Labels";
2462 if ($limit_query_part) {
2463 $offset_query_part = "OFFSET $offset";
2466 // proper override_order applied above
2467 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref($link, 'VFEED_GROUP_BY_FEED', $owner_uid)) {
2468 if (!$override_order) {
2469 $order_by = "ttrss_feeds.title, $order_by";
2471 $order_by = "ttrss_feeds.title, $override_order";
2475 if (!$allow_archived) {
2476 $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
2477 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
2480 $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
2481 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
2484 $query = "SELECT DISTINCT
2487 ttrss_entries.id,ttrss_entries.title,
2491 always_display_enclosures,
2498 unread,feed_id,marked,published,link,last_read,orig_feed_id,
2499 last_marked, last_published,
2500 ".SUBSTRING_FOR_DATE
."(last_read,1,19) as last_read_noms,
2503 ".SUBSTRING_FOR_DATE
."(updated,1,19) as updated_noms,
2509 ttrss_user_entries.ref_id = ttrss_entries.id AND
2510 ttrss_user_entries.owner_uid = '$owner_uid' AND
2515 $query_strategy_part ORDER BY $order_by
2516 $limit_query_part $offset_query_part";
2518 if ($_REQUEST["debug"]) print $query;
2520 $result = db_query($link, $query);
2525 $select_qpart = "SELECT DISTINCT " .
2529 "ttrss_entries.id as id," .
2542 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
2543 "last_marked, last_published, " .
2544 SUBSTRING_FOR_DATE
. "(last_read,1,19) as last_read_noms," .
2547 $content_query_part .
2548 SUBSTRING_FOR_DATE
. "(updated,1,19) as updated_noms," .
2551 $feed_kind = "Tags";
2552 $all_tags = explode(",", $feed);
2553 if ($search_mode == 'any') {
2554 $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
2555 $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
2556 $where_qpart = " WHERE " .
2557 "ref_id = ttrss_entries.id AND " .
2558 "ttrss_user_entries.owner_uid = $owner_uid AND " .
2559 "post_int_id = int_id AND $tag_sql AND " .
2561 $search_query_part .
2562 $query_strategy_part . " ORDER BY $order_by " .
2567 $sub_selects = array();
2568 $sub_ands = array();
2569 foreach ($all_tags as $term) {
2570 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");
2577 array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
2582 array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
2583 array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
2584 $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
2585 $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
2587 // error_log("TAG SQL: " . $tag_sql);
2588 // $tag_sql = "tag_name = '$feed'"; DEFAULT way
2590 // error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
2591 $result = db_query($link, $select_qpart . $from_qpart . $where_qpart);
2594 return array($result, $feed_title, $feed_site_url, $last_error);
2598 function sanitize($link, $str, $force_remove_images = false, $owner = false, $site_url = false) {
2599 if (!$owner) $owner = $_SESSION["uid"];
2601 $res = trim($str); if (!$res) return '';
2603 if (strpos($res, "href=") === false)
2604 $res = rewrite_urls($res);
2606 $charset_hack = '<head>
2607 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
2610 $res = trim($res); if (!$res) return '';
2612 libxml_use_internal_errors(true);
2614 $doc = new DOMDocument();
2615 $doc->loadHTML($charset_hack . $res);
2616 $xpath = new DOMXPath($doc);
2618 $entries = $xpath->query('(//a[@href]|//img[@src])');
2620 foreach ($entries as $entry) {
2624 if ($entry->hasAttribute('href'))
2625 $entry->setAttribute('href',
2626 rewrite_relative_url($site_url, $entry->getAttribute('href')));
2628 if ($entry->hasAttribute('src')) {
2629 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
2631 $cached_filename = CACHE_DIR
. '/images/' . sha1($src) . '.png';
2633 if (file_exists($cached_filename)) {
2634 $src = SELF_URL_PATH
. '/image.php?hash=' . sha1($src);
2637 $entry->setAttribute('src', $src);
2640 if ($entry->nodeName
== 'img') {
2641 if (($owner && get_pref($link, "STRIP_IMAGES", $owner)) ||
2642 $force_remove_images) {
2644 $p = $doc->createElement('p');
2646 $a = $doc->createElement('a');
2647 $a->setAttribute('href', $entry->getAttribute('src'));
2649 $a->appendChild(new DOMText($entry->getAttribute('src')));
2650 $a->setAttribute('target', '_blank');
2652 $p->appendChild($a);
2654 $entry->parentNode
->replaceChild($p, $entry);
2659 if (strtolower($entry->nodeName
) == "a") {
2660 $entry->setAttribute("target", "_blank");
2664 $entries = $xpath->query('//iframe');
2665 foreach ($entries as $entry) {
2666 $entry->setAttribute('sandbox', 'allow-scripts');
2672 if (isset($pluginhost)) {
2673 foreach ($pluginhost->get_hooks($pluginhost::HOOK_SANITIZE
) as $plugin) {
2674 $doc = $plugin->hook_sanitize($doc, $site_url);
2678 $doc->removeChild($doc->firstChild
); //remove doctype
2679 $doc = strip_harmful_tags($doc);
2680 $res = $doc->saveHTML();
2684 function strip_harmful_tags($doc) {
2685 $entries = $doc->getElementsByTagName("*");
2687 $allowed_elements = array('a', 'address', 'audio', 'article',
2688 'b', 'big', 'blockquote', 'body', 'br', 'cite', 'center',
2689 'code', 'dd', 'del', 'details', 'div', 'dl', 'font',
2690 'dt', 'em', 'footer', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6',
2691 'header', 'html', 'i', 'img', 'ins', 'kbd',
2692 'li', 'nav', 'ol', 'p', 'pre', 'q', 's','small',
2693 'source', 'span', 'strike', 'strong', 'sub', 'summary',
2694 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead',
2695 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
2697 if ($_SESSION['hasSandbox']) array_push($allowed_elements, 'iframe');
2699 $disallowed_attributes = array('id', 'style', 'class');
2701 foreach ($entries as $entry) {
2702 if (!in_array($entry->nodeName
, $allowed_elements)) {
2703 $entry->parentNode
->removeChild($entry);
2706 if ($entry->hasAttributes()) {
2707 $attrs_to_remove = array();
2709 foreach ($entry->attributes
as $attr) {
2711 if (strpos($attr->nodeName
, 'on') === 0) {
2712 array_push($attrs_to_remove, $attr);
2715 if (in_array($attr->nodeName
, $disallowed_attributes)) {
2716 array_push($attrs_to_remove, $attr);
2720 foreach ($attrs_to_remove as $attr) {
2721 $entry->removeAttributeNode($attr);
2729 function check_for_update($link) {
2730 if (CHECK_FOR_NEW_VERSION
&& $_SESSION['access_level'] >= 10) {
2731 $version_url = "http://tt-rss.org/version.php?ver=" . VERSION
.
2732 "&iid=" . sha1(SELF_URL_PATH
);
2734 $version_data = @fetch_file_contents
($version_url);
2736 if ($version_data) {
2737 $version_data = json_decode($version_data, true);
2738 if ($version_data && $version_data['version']) {
2740 if (version_compare(VERSION
, $version_data['version']) == -1) {
2741 return $version_data;
2749 function catchupArticlesById($link, $ids, $cmode, $owner_uid = false) {
2751 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2752 if (count($ids) == 0) return;
2756 foreach ($ids as $id) {
2757 array_push($tmp_ids, "ref_id = '$id'");
2760 $ids_qpart = join(" OR ", $tmp_ids);
2763 db_query($link, "UPDATE ttrss_user_entries SET
2764 unread = false,last_read = NOW()
2765 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2766 } else if ($cmode == 1) {
2767 db_query($link, "UPDATE ttrss_user_entries SET
2769 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2771 db_query($link, "UPDATE ttrss_user_entries SET
2772 unread = NOT unread,last_read = NOW()
2773 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2778 $result = db_query($link, "SELECT DISTINCT feed_id FROM ttrss_user_entries
2779 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2781 while ($line = db_fetch_assoc($result)) {
2782 ccache_update($link, $line["feed_id"], $owner_uid);
2786 function get_article_tags($link, $id, $owner_uid = 0, $tag_cache = false) {
2788 $a_id = db_escape_string($link, $id);
2790 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2792 $query = "SELECT DISTINCT tag_name,
2793 owner_uid as owner FROM
2794 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
2795 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
2797 $obj_id = md5("TAGS:$owner_uid:$id");
2800 /* check cache first */
2802 if ($tag_cache === false) {
2803 $result = db_query($link, "SELECT tag_cache FROM ttrss_user_entries
2804 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
2806 $tag_cache = db_fetch_result($result, 0, "tag_cache");
2810 $tags = explode(",", $tag_cache);
2813 /* do it the hard way */
2815 $tmp_result = db_query($link, $query);
2817 while ($tmp_line = db_fetch_assoc($tmp_result)) {
2818 array_push($tags, $tmp_line["tag_name"]);
2821 /* update the cache */
2823 $tags_str = db_escape_string($link, join(",", $tags));
2825 db_query($link, "UPDATE ttrss_user_entries
2826 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
2827 AND owner_uid = $owner_uid");
2833 function trim_array($array) {
2835 array_walk($tmp, 'trim');
2839 function tag_is_valid($tag) {
2840 if ($tag == '') return false;
2841 if (preg_match("/^[0-9]*$/", $tag)) return false;
2842 if (mb_strlen($tag) > 250) return false;
2844 if (function_exists('iconv')) {
2845 $tag = iconv("utf-8", "utf-8", $tag);
2848 if (!$tag) return false;
2853 function render_login_form($link) {
2854 require_once "login_form.php";
2858 // from http://developer.apple.com/internet/safari/faq.html
2859 function no_cache_incantation() {
2860 header("Expires: Mon, 22 Dec 1980 00:00:00 GMT"); // Happy birthday to me :)
2861 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
2862 header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); // HTTP/1.1
2863 header("Cache-Control: post-check=0, pre-check=0", false);
2864 header("Pragma: no-cache"); // HTTP/1.0
2867 function format_warning($msg, $id = "") {
2869 return "<div class=\"warning\" id=\"$id\">
2870 <img src=\"images/sign_excl.svg\">$msg</div>";
2873 function format_notice($msg, $id = "") {
2875 return "<div class=\"notice\" id=\"$id\">
2876 <img src=\"images/sign_info.svg\">$msg</div>";
2879 function format_error($msg, $id = "") {
2881 return "<div class=\"error\" id=\"$id\">
2882 <img src=\"images/sign_excl.svg\">$msg</div>";
2885 function print_notice($msg) {
2886 return print format_notice($msg);
2889 function print_warning($msg) {
2890 return print format_warning($msg);
2893 function print_error($msg) {
2894 return print format_error($msg);
2898 function T_sprintf() {
2899 $args = func_get_args();
2900 return vsprintf(__(array_shift($args)), $args);
2903 function format_inline_player($link, $url, $ctype) {
2907 $url = htmlspecialchars($url);
2909 if (strpos($ctype, "audio/") === 0) {
2911 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
2912 strpos($_SERVER['HTTP_USER_AGENT'], "Chrome") !== false ||
2913 strpos($_SERVER['HTTP_USER_AGENT'], "Safari") !== false )) {
2915 $id = 'AUDIO-' . uniqid();
2917 $entry .= "<audio id=\"$id\"\" controls style='display : none'>
2918 <source type=\"$ctype\" src=\"$url\"></source>
2921 $entry .= "<span onclick=\"player(this)\"
2922 title=\"".__("Click to play")."\" status=\"0\"
2923 class=\"player\" audio-id=\"$id\">".__("Play")."</span>";
2927 $entry .= "<object type=\"application/x-shockwave-flash\"
2928 data=\"lib/button/musicplayer.swf?song_url=$url\"
2929 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
2930 <param name=\"movie\"
2931 value=\"lib/button/musicplayer.swf?song_url=$url\" />
2935 if ($entry) $entry .= " <a target=\"_blank\"
2936 href=\"$url\">" . basename($url) . "</a>";
2944 /* $filename = substr($url, strrpos($url, "/")+1);
2946 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
2947 $filename . " (" . $ctype . ")" . "</a>"; */
2951 function format_article($link, $id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
2952 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2958 /* we can figure out feed_id from article id anyway, why do we
2959 * pass feed_id here? let's ignore the argument :( */
2961 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
2962 WHERE ref_id = '$id'");
2964 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
2966 $rv['feed_id'] = $feed_id;
2968 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
2970 if ($mark_as_read) {
2971 $result = db_query($link, "UPDATE ttrss_user_entries
2972 SET unread = false,last_read = NOW()
2973 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
2975 ccache_update($link, $feed_id, $owner_uid);
2978 $result = db_query($link, "SELECT id,title,link,content,feed_id,comments,int_id,
2979 ".SUBSTRING_FOR_DATE
."(updated,1,16) as updated,
2980 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
2981 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
2988 FROM ttrss_entries,ttrss_user_entries
2989 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
2993 $line = db_fetch_assoc($result);
2995 $tag_cache = $line["tag_cache"];
2997 $line["tags"] = get_article_tags($link, $id, $owner_uid, $line["tag_cache"]);
2998 unset($line["tag_cache"]);
3000 $line["content"] = sanitize($link, $line["content"], false, $owner_uid, $line["site_url"]);
3004 foreach ($pluginhost->get_hooks($pluginhost::HOOK_RENDER_ARTICLE
) as $p) {
3005 $line = $p->hook_render_article($line);
3008 $num_comments = $line["num_comments"];
3009 $entry_comments = "";
3011 if ($num_comments > 0) {
3012 if ($line["comments"]) {
3013 $comments_url = htmlspecialchars($line["comments"]);
3015 $comments_url = htmlspecialchars($line["link"]);
3017 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
3019 if ($line["comments"] && $line["link"] != $line["comments"]) {
3020 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
3025 header("Content-Type: text/html");
3026 $rv['content'] .= "<html><head>
3027 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3028 <title>Tiny Tiny RSS - ".$line["title"]."</title>
3029 <link rel=\"stylesheet\" type=\"text/css\" href=\"tt-rss.css\">
3030 </head><body id=\"ttrssZoom\">";
3033 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
3035 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
3037 $entry_author = $line["author"];
3039 if ($entry_author) {
3040 $entry_author = __(" - ") . $entry_author;
3043 $parsed_updated = make_local_datetime($link, $line["updated"], true,
3046 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3048 if ($line["link"]) {
3049 $rv['content'] .= "<div class='postTitle'><a target='_blank'
3050 title=\"".htmlspecialchars($line['title'])."\"
3052 htmlspecialchars($line["link"]) . "\">" .
3053 $line["title"] . "</a>" .
3054 "<span class='author'>$entry_author</span></div>";
3056 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
3059 $tags_str = format_tags_string($line["tags"], $id);
3060 $tags_str_full = join(", ", $line["tags"]);
3062 if (!$tags_str_full) $tags_str_full = __("no tags");
3064 if (!$entry_comments) $entry_comments = " "; # placeholder
3066 $rv['content'] .= "<div class='postTags' style='float : right'>
3067 <img src='images/tag.png'
3068 class='tagsPic' alt='Tags' title='Tags'> ";
3071 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
3072 <a title=\"".__('Edit tags for this article')."\"
3073 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
3075 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
3076 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
3077 position=\"below\">$tags_str_full</div>";
3081 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_BUTTON
) as $p) {
3082 $rv['content'] .= $p->hook_article_button($line);
3087 $tags_str = strip_tags($tags_str);
3088 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
3090 $rv['content'] .= "</div>";
3091 $rv['content'] .= "<div clear='both'>$entry_comments</div>";
3093 if ($line["orig_feed_id"]) {
3095 $tmp_result = db_query($link, "SELECT * FROM ttrss_archived_feeds
3096 WHERE id = ".$line["orig_feed_id"]);
3098 if (db_num_rows($tmp_result) != 0) {
3100 $rv['content'] .= "<div clear='both'>";
3101 $rv['content'] .= __("Originally from:");
3103 $rv['content'] .= " ";
3105 $tmp_line = db_fetch_assoc($tmp_result);
3107 $rv['content'] .= "<a target='_blank'
3108 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
3109 $tmp_line['title'] . "</a>";
3111 $rv['content'] .= " ";
3113 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
3114 $rv['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_set.svg'></a>";
3116 $rv['content'] .= "</div>";
3120 $rv['content'] .= "</div>";
3122 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
3123 if ($line['note']) {
3124 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
3126 $rv['content'] .= "</div>";
3128 $rv['content'] .= "<div class=\"postContent\">";
3130 $rv['content'] .= $line["content"];
3132 $rv['content'] .= format_article_enclosures($link, $id,
3133 $always_display_enclosures, $line["content"], $line["hide_images"]);
3135 $rv['content'] .= "</div>";
3137 $rv['content'] .= "</div>";
3143 <div class='footer'>
3144 <button onclick=\"return window.close()\">".
3145 __("Close this window")."</button></div>";
3146 $rv['content'] .= "</body></html>";
3153 function print_checkpoint($n, $s) {
3154 $ts = microtime(true);
3155 echo sprintf("<!-- CP[$n] %.4f seconds -->", $ts - $s);
3159 function sanitize_tag($tag) {
3162 $tag = mb_strtolower($tag, 'utf-8');
3164 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
3166 // $tag = str_replace('"', "", $tag);
3167 // $tag = str_replace("+", " ", $tag);
3168 $tag = str_replace("technorati tag: ", "", $tag);
3173 function get_self_url_prefix() {
3174 if (strrpos(SELF_URL_PATH
, "/") === strlen(SELF_URL_PATH
)-1) {
3175 return substr(SELF_URL_PATH
, 0, strlen(SELF_URL_PATH
)-1);
3177 return SELF_URL_PATH
;
3182 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
3184 * @return string The Mozilla Firefox feed adding URL.
3186 function add_feed_url() {
3187 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
3189 $url_path = get_self_url_prefix() .
3190 "/public.php?op=subscribe&feed_url=%s";
3192 } // function add_feed_url
3194 function encrypt_password($pass, $salt = '', $mode2 = false) {
3195 if ($salt && $mode2) {
3196 return "MODE2:" . hash('sha256', $salt . $pass);
3198 return "SHA1X:" . sha1("$salt:$pass");
3200 return "SHA1:" . sha1($pass);
3202 } // function encrypt_password
3204 function load_filters($link, $feed_id, $owner_uid, $action_id = false) {
3207 $cat_id = (int)getFeedCategory($link, $feed_id);
3209 $result = db_query($link, "SELECT * FROM ttrss_filters2 WHERE
3210 owner_uid = $owner_uid AND enabled = true");
3212 $check_cats = join(",", array_merge(
3213 getParentCategories($link, $cat_id, $owner_uid),
3216 while ($line = db_fetch_assoc($result)) {
3217 $filter_id = $line["id"];
3219 $result2 = db_query($link, "SELECT
3220 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
3221 FROM ttrss_filters2_rules AS r,
3222 ttrss_filter_types AS t
3224 (cat_id IS NULL OR cat_id IN ($check_cats)) AND
3225 (feed_id IS NULL OR feed_id = '$feed_id') AND
3226 filter_type = t.id AND filter_id = '$filter_id'");
3231 while ($rule_line = db_fetch_assoc($result2)) {
3232 # print_r($rule_line);
3235 $rule["reg_exp"] = $rule_line["reg_exp"];
3236 $rule["type"] = $rule_line["type_name"];
3237 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
3239 array_push($rules, $rule);
3242 $result2 = db_query($link, "SELECT a.action_param,t.name AS type_name
3243 FROM ttrss_filters2_actions AS a,
3244 ttrss_filter_actions AS t
3246 action_id = t.id AND filter_id = '$filter_id'");
3248 while ($action_line = db_fetch_assoc($result2)) {
3249 # print_r($action_line);
3252 $action["type"] = $action_line["type_name"];
3253 $action["param"] = $action_line["action_param"];
3255 array_push($actions, $action);
3260 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
3261 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
3262 $filter["rules"] = $rules;
3263 $filter["actions"] = $actions;
3265 if (count($rules) > 0 && count($actions) > 0) {
3266 array_push($filters, $filter);
3273 function get_score_pic($score) {
3275 return "score_high.png";
3276 } else if ($score > 0) {
3277 return "score_half_high.png";
3278 } else if ($score < -100) {
3279 return "score_low.png";
3280 } else if ($score < 0) {
3281 return "score_half_low.png";
3283 return "score_neutral.png";
3287 function feed_has_icon($id) {
3288 return is_file(ICONS_DIR
. "/$id.ico") && filesize(ICONS_DIR
. "/$id.ico") > 0;
3291 function init_connection($link) {
3294 if (DB_TYPE
== "pgsql") {
3295 pg_query($link, "set client_encoding = 'UTF-8'");
3296 pg_set_client_encoding("UNICODE");
3297 pg_query($link, "set datestyle = 'ISO, european'");
3298 pg_query($link, "set TIME ZONE 0");
3300 db_query($link, "SET time_zone = '+0:0'");
3302 if (defined('MYSQL_CHARSET') && MYSQL_CHARSET
) {
3303 db_query($link, "SET NAMES " . MYSQL_CHARSET
);
3309 $pluginhost = new PluginHost($link);
3310 $pluginhost->load(PLUGINS
, $pluginhost::KIND_ALL
);
3314 print "Unable to connect to database:" . db_last_error();
3319 function format_tags_string($tags, $id) {
3322 $tags_nolinks_str = "";
3328 $formatted_tags = array();
3330 foreach ($tags as $tag) {
3332 $tag_escaped = str_replace("'", "\\'", $tag);
3334 if (mb_strlen($tag) > 30) {
3335 $tag = truncate_string($tag, 30);
3338 $tag_str = "<a href=\"javascript:viewfeed('$tag_escaped')\">$tag</a>";
3340 array_push($formatted_tags, $tag_str);
3342 $tmp_tags_str = implode(", ", $formatted_tags);
3344 if ($num_tags == $tag_limit ||
mb_strlen($tmp_tags_str) > 150) {
3349 $tags_str = implode(", ", $formatted_tags);
3351 if ($num_tags < count($tags)) {
3352 $tags_str .= ", …";
3355 if ($num_tags == 0) {
3356 $tags_str = __("no tags");
3363 function format_article_labels($labels, $id) {
3367 foreach ($labels as $l) {
3368 $labels_str .= sprintf("<span class='hlLabelRef'
3369 style='color : %s; background-color : %s'>%s</span>",
3370 $l[2], $l[3], $l[1]);
3377 function format_article_note($id, $note, $allow_edit = true) {
3379 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
3380 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
3381 ($allow_edit ?
__('(edit note)') : "")."</div>$note</div>";
3387 function get_feed_category($link, $feed_cat, $parent_cat_id = false) {
3388 if ($parent_cat_id) {
3389 $parent_qpart = "parent_cat = '$parent_cat_id'";
3390 $parent_insert = "'$parent_cat_id'";
3392 $parent_qpart = "parent_cat IS NULL";
3393 $parent_insert = "NULL";
3396 $result = db_query($link,
3397 "SELECT id FROM ttrss_feed_categories
3398 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3400 if (db_num_rows($result) == 0) {
3403 return db_fetch_result($result, 0, "id");
3407 function add_feed_category($link, $feed_cat, $parent_cat_id = false) {
3409 if (!$feed_cat) return false;
3411 db_query($link, "BEGIN");
3413 if ($parent_cat_id) {
3414 $parent_qpart = "parent_cat = '$parent_cat_id'";
3415 $parent_insert = "'$parent_cat_id'";
3417 $parent_qpart = "parent_cat IS NULL";
3418 $parent_insert = "NULL";
3421 $result = db_query($link,
3422 "SELECT id FROM ttrss_feed_categories
3423 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3425 if (db_num_rows($result) == 0) {
3427 $result = db_query($link,
3428 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
3429 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
3431 db_query($link, "COMMIT");
3439 function getArticleFeed($link, $id) {
3440 $result = db_query($link, "SELECT feed_id FROM ttrss_user_entries
3441 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
3443 if (db_num_rows($result) != 0) {
3444 return db_fetch_result($result, 0, "feed_id");
3451 * Fixes incomplete URLs by prepending "http://".
3452 * Also replaces feed:// with http://, and
3453 * prepends a trailing slash if the url is a domain name only.
3455 * @param string $url Possibly incomplete URL
3457 * @return string Fixed URL.
3459 function fix_url($url) {
3460 if (strpos($url, '://') === false) {
3461 $url = 'http://' . $url;
3462 } else if (substr($url, 0, 5) == 'feed:') {
3463 $url = 'http:' . substr($url, 5);
3466 //prepend slash if the URL has no slash in it
3467 // "http://www.example" -> "http://www.example/"
3468 if (strpos($url, '/', strpos($url, ':') +
3) === false) {
3472 if ($url != "http:///")
3478 function validate_feed_url($url) {
3479 $parts = parse_url($url);
3481 return ($parts['scheme'] == 'http' ||
$parts['scheme'] == 'feed' ||
$parts['scheme'] == 'https');
3485 function get_article_enclosures($link, $id) {
3487 $query = "SELECT * FROM ttrss_enclosures
3488 WHERE post_id = '$id' AND content_url != ''";
3492 $result = db_query($link, $query);
3494 if (db_num_rows($result) > 0) {
3495 while ($line = db_fetch_assoc($result)) {
3496 array_push($rv, $line);
3503 function save_email_address($link, $email) {
3504 // FIXME: implement persistent storage of emails
3506 if (!$_SESSION['stored_emails'])
3507 $_SESSION['stored_emails'] = array();
3509 if (!in_array($email, $_SESSION['stored_emails']))
3510 array_push($_SESSION['stored_emails'], $email);
3514 function get_feed_access_key($link, $feed_id, $is_cat, $owner_uid = false) {
3516 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3518 $sql_is_cat = bool_to_sql_bool($is_cat);
3520 $result = db_query($link, "SELECT access_key FROM ttrss_access_keys
3521 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
3522 AND owner_uid = " . $owner_uid);
3524 if (db_num_rows($result) == 1) {
3525 return db_fetch_result($result, 0, "access_key");
3527 $key = db_escape_string($link, sha1(uniqid(rand(), true)));
3529 $result = db_query($link, "INSERT INTO ttrss_access_keys
3530 (access_key, feed_id, is_cat, owner_uid)
3531 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
3538 function get_feeds_from_html($url, $content)
3540 $url = fix_url($url);
3541 $baseUrl = substr($url, 0, strrpos($url, '/') +
1);
3543 libxml_use_internal_errors(true);
3545 $doc = new DOMDocument();
3546 $doc->loadHTML($content);
3547 $xpath = new DOMXPath($doc);
3548 $entries = $xpath->query('/html/head/link[@rel="alternate"]');
3549 $feedUrls = array();
3550 foreach ($entries as $entry) {
3551 if ($entry->hasAttribute('href')) {
3552 $title = $entry->getAttribute('title');
3554 $title = $entry->getAttribute('type');
3556 $feedUrl = rewrite_relative_url(
3557 $baseUrl, $entry->getAttribute('href')
3559 $feedUrls[$feedUrl] = $title;
3565 function is_html($content) {
3566 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
3569 function url_is_html($url, $login = false, $pass = false) {
3570 return is_html(fetch_file_contents($url, false, $login, $pass));
3573 function print_label_select($link, $name, $value, $attributes = "") {
3575 $result = db_query($link, "SELECT caption FROM ttrss_labels2
3576 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
3578 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
3579 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
3581 while ($line = db_fetch_assoc($result)) {
3583 $issel = ($line["caption"] == $value) ?
"selected=\"1\"" : "";
3585 print "<option value=\"".htmlspecialchars($line["caption"])."\"
3586 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
3590 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
3597 function format_article_enclosures($link, $id, $always_display_enclosures,
3598 $article_content, $hide_images = false) {
3600 $result = get_article_enclosures($link, $id);
3603 if (count($result) > 0) {
3605 $entries_html = array();
3607 $entries_inline = array();
3609 foreach ($result as $line) {
3611 $url = $line["content_url"];
3612 $ctype = $line["content_type"];
3614 if (!$ctype) $ctype = __("unknown type");
3616 $filename = substr($url, strrpos($url, "/")+
1);
3618 $player = format_inline_player($link, $url, $ctype);
3620 if ($player) array_push($entries_inline, $player);
3622 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3623 # $filename . " (" . $ctype . ")" . "</a>";
3625 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
3626 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
3628 array_push($entries_html, $entry);
3632 $entry["type"] = $ctype;
3633 $entry["filename"] = $filename;
3634 $entry["url"] = $url;
3636 array_push($entries, $entry);
3639 if ($_SESSION['uid'] && !get_pref($link, "STRIP_IMAGES")) {
3640 if ($always_display_enclosures ||
3641 !preg_match("/<img/i", $article_content)) {
3643 foreach ($entries as $entry) {
3645 if (preg_match("/image/", $entry["type"]) ||
3646 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
3648 if (!$hide_images) {
3650 alt=\"".htmlspecialchars($entry["filename"])."\"
3651 src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
3653 $rv .= "<p><a target=\"_blank\"
3654 href=\"".htmlspecialchars($entry["url"])."\"
3655 >" .htmlspecialchars($entry["url"]) . "</a></p>";
3663 if (count($entries_inline) > 0) {
3664 $rv .= "<hr clear='both'/>";
3665 foreach ($entries_inline as $entry) { $rv .= $entry; };
3666 $rv .= "<hr clear='both'/>";
3669 $rv .= "<br/><div dojoType=\"dijit.form.DropDownButton\">".
3670 "<span>" . __('Attachments')."</span>";
3671 $rv .= "<div dojoType=\"dijit.Menu\" style=\"display: none;\">";
3673 foreach ($entries_html as $entry) { $rv .= $entry; };
3675 $rv .= "</div></div>";
3681 function getLastArticleId($link) {
3682 $result = db_query($link, "SELECT MAX(ref_id) AS id FROM ttrss_user_entries
3683 WHERE owner_uid = " . $_SESSION["uid"]);
3685 if (db_num_rows($result) == 1) {
3686 return db_fetch_result($result, 0, "id");
3692 function build_url($parts) {
3693 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
3697 * Converts a (possibly) relative URL to a absolute one.
3699 * @param string $url Base URL (i.e. from where the document is)
3700 * @param string $rel_url Possibly relative URL in the document
3702 * @return string Absolute URL
3704 function rewrite_relative_url($url, $rel_url) {
3705 if (strpos($rel_url, "magnet:") === 0) {
3707 } else if (strpos($rel_url, "://") !== false) {
3709 } else if (strpos($rel_url, "//") === 0) {
3710 # protocol-relative URL (rare but they exist)
3712 } else if (strpos($rel_url, "/") === 0)
3714 $parts = parse_url($url);
3715 $parts['path'] = $rel_url;
3717 return build_url($parts);
3720 $parts = parse_url($url);
3721 if (!isset($parts['path'])) {
3722 $parts['path'] = '/';
3724 $dir = $parts['path'];
3725 if (substr($dir, -1) !== '/') {
3726 $dir = dirname($parts['path']);
3727 $dir !== '/' && $dir .= '/';
3729 $parts['path'] = $dir . $rel_url;
3731 return build_url($parts);
3735 function sphinx_search($query, $offset = 0, $limit = 30) {
3736 require_once 'lib/sphinxapi.php';
3738 $sphinxClient = new SphinxClient();
3740 $sphinxClient->SetServer('localhost', 9312);
3741 $sphinxClient->SetConnectTimeout(1);
3743 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
3744 'feed_title' => 20));
3746 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2
);
3747 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25
);
3748 $sphinxClient->SetLimits($offset, $limit, 1000);
3749 $sphinxClient->SetArrayResult(false);
3750 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
3752 $result = $sphinxClient->Query($query, SPHINX_INDEX
);
3756 if (is_array($result['matches'])) {
3757 foreach (array_keys($result['matches']) as $int_id) {
3758 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
3759 array_push($ids, $ref_id);
3766 function cleanup_tags($link, $days = 14, $limit = 1000) {
3768 if (DB_TYPE
== "pgsql") {
3769 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
3770 } else if (DB_TYPE
== "mysql") {
3771 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
3776 while ($limit > 0) {
3779 $query = "SELECT ttrss_tags.id AS id
3780 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
3781 WHERE post_int_id = int_id AND $interval_query AND
3782 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
3784 $result = db_query($link, $query);
3788 while ($line = db_fetch_assoc($result)) {
3789 array_push($ids, $line['id']);
3792 if (count($ids) > 0) {
3793 $ids = join(",", $ids);
3796 $tmp_result = db_query($link, "DELETE FROM ttrss_tags WHERE id IN ($ids)");
3797 $tags_deleted +
= db_affected_rows($link, $tmp_result);
3802 $limit -= $limit_part;
3807 return $tags_deleted;
3810 function print_user_stylesheet($link) {
3811 $value = get_pref($link, 'USER_STYLESHEET');
3814 print "<style type=\"text/css\">";
3815 print str_replace("<br/>", "\n", $value);
3821 function rewrite_urls($html) {
3822 libxml_use_internal_errors(true);
3824 $charset_hack = '<head>
3825 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
3828 $doc = new DOMDocument();
3829 $doc->loadHTML($charset_hack . $html);
3830 $xpath = new DOMXPath($doc);
3832 $entries = $xpath->query('//*/text()');
3834 foreach ($entries as $entry) {
3835 if (strstr($entry->wholeText
, "://") !== false) {
3836 $text = preg_replace("/((?<!=.)((http|https|ftp)+):\/\/[^ ,!]+)/i",
3837 "<a target=\"_blank\" href=\"\\1\">\\1</a>", $entry->wholeText
);
3839 if ($text != $entry->wholeText
) {
3840 $cdoc = new DOMDocument();
3841 $cdoc->loadHTML($charset_hack . $text);
3844 foreach ($cdoc->childNodes
as $cnode) {
3845 $cnode = $doc->importNode($cnode, true);
3848 $entry->parentNode
->insertBefore($cnode);
3852 $entry->parentNode
->removeChild($entry);
3858 $node = $doc->getElementsByTagName('body')->item(0);
3860 // http://tt-rss.org/forum/viewtopic.php?f=1&t=970
3862 return $doc->saveXML($node);
3867 function filter_to_sql($link, $filter, $owner_uid) {
3870 if (DB_TYPE
== "pgsql")
3873 $reg_qpart = "REGEXP";
3875 foreach ($filter["rules"] AS $rule) {
3876 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
3877 $rule['reg_exp']) !== FALSE;
3879 if ($regexp_valid) {
3881 $rule['reg_exp'] = db_escape_string($link, $rule['reg_exp']);
3883 switch ($rule["type"]) {
3885 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3886 $rule['reg_exp'] . "')";
3889 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
3890 $rule['reg_exp'] . "')";
3893 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
3894 $rule['reg_exp'] . "') OR LOWER(" .
3895 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
3898 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
3899 $rule['reg_exp'] . "')";
3902 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
3903 $rule['reg_exp'] . "')";
3906 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
3907 $rule['reg_exp'] . "')";
3911 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
3913 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
3914 $qpart .= " AND feed_id = " . db_escape_string($link, $rule["feed_id"]);
3917 if (isset($rule["cat_id"])) {
3919 if ($rule["cat_id"] > 0) {
3920 $children = getChildCategories($link, $rule["cat_id"], $owner_uid);
3921 array_push($children, $rule["cat_id"]);
3923 $children = join(",", $children);
3925 $cat_qpart = "cat_id IN ($children)";
3927 $cat_qpart = "cat_id IS NULL";
3930 $qpart .= " AND $cat_qpart";
3933 array_push($query, "($qpart)");
3938 if (count($query) > 0) {
3939 $fullquery = "(" . join($filter["match_any_rule"] ?
"OR" : "AND", $query) . ")";
3941 $fullquery = "(false)";
3944 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
3949 if (!function_exists('gzdecode')) {
3950 function gzdecode($string) { // no support for 2nd argument
3951 return file_get_contents('compress.zlib://data:who/cares;base64,'.
3952 base64_encode($string));
3956 function get_random_bytes($length) {
3957 if (function_exists('openssl_random_pseudo_bytes')) {
3958 return openssl_random_pseudo_bytes($length);
3962 for ($i = 0; $i < $length; $i++
)
3963 $output .= chr(mt_rand(0, 255));
3969 function read_stdin() {
3970 $fp = fopen("php://stdin", "r");
3973 $line = trim(fgets($fp));
3981 function tmpdirname($path, $prefix) {
3982 // Use PHP's tmpfile function to create a temporary
3983 // directory name. Delete the file and keep the name.
3984 $tempname = tempnam($path,$prefix);
3988 if (!unlink($tempname))
3994 function getFeedCategory($link, $feed) {
3995 $result = db_query($link, "SELECT cat_id FROM ttrss_feeds
3996 WHERE id = '$feed'");
3998 if (db_num_rows($result) > 0) {
3999 return db_fetch_result($result, 0, "cat_id");
4006 function implements_interface($class, $interface) {
4007 return in_array($interface, class_implements($class));
4010 function geturl($url){
4012 (function_exists('curl_init')) ?
'' : die('cURL Must be installed for geturl function to work. Ask your host to enable it or uncomment extension=php_curl.dll in php.ini');
4014 $curl = curl_init();
4015 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
4016 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
4017 $header[] = "Cache-Control: max-age=0";
4018 $header[] = "Connection: keep-alive";
4019 $header[] = "Keep-Alive: 300";
4020 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
4021 $header[] = "Accept-Language: en-us,en;q=0.5";
4022 $header[] = "Pragma: ";
4024 curl_setopt($curl, CURLOPT_URL
, $url);
4025 curl_setopt($curl, CURLOPT_USERAGENT
, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
4026 curl_setopt($curl, CURLOPT_HTTPHEADER
, $header);
4027 curl_setopt($curl, CURLOPT_HEADER
, true);
4028 curl_setopt($curl, CURLOPT_REFERER
, $url);
4029 curl_setopt($curl, CURLOPT_ENCODING
, 'gzip,deflate');
4030 curl_setopt($curl, CURLOPT_AUTOREFERER
, true);
4031 curl_setopt($curl, CURLOPT_RETURNTRANSFER
, true);
4032 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
4033 curl_setopt($curl, CURLOPT_TIMEOUT
, 60);
4035 $html = curl_exec($curl);
4037 $status = curl_getinfo($curl);
4040 if($status['http_code']!=200){
4041 if($status['http_code'] == 301 ||
$status['http_code'] == 302) {
4042 list($header) = explode("\r\n\r\n", $html, 2);
4044 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
4045 $url = trim(str_replace($matches[1],"",$matches[0]));
4046 $url_parsed = parse_url($url);
4047 return (isset($url_parsed))?
geturl($url, $referer):'';
4050 foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
4051 $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
4052 # $handle = @fopen('./curl.error.log', 'a');
4053 # fwrite($handle, $line);
4059 function get_minified_js($files) {
4060 require_once 'lib/jshrink/Minifier.php';
4064 foreach ($files as $js) {
4065 if (!isset($_GET['debug'])) {
4066 $cached_file = CACHE_DIR
. "/js/$js.js";
4068 if (file_exists($cached_file) &&
4069 is_readable($cached_file) &&
4070 filemtime($cached_file) >= filemtime("js/$js.js")) {
4072 $rv .= file_get_contents($cached_file);
4075 $minified = JShrink\Minifier
::minify(file_get_contents("js/$js.js"));
4076 file_put_contents($cached_file, $minified);
4080 $rv .= file_get_contents("js/$js.js");
4087 function stylesheet_tag($filename) {
4088 $timestamp = filemtime($filename);
4090 echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
4093 function javascript_tag($filename) {
4096 if (!(strpos($filename, "?") === FALSE)) {
4097 $query = substr($filename, strpos($filename, "?")+
1);
4098 $filename = substr($filename, 0, strpos($filename, "?"));
4101 $timestamp = filemtime($filename);
4103 if ($query) $timestamp .= "&$query";
4105 echo "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
4108 function calculate_dep_timestamp() {
4109 $files = array_merge(glob("js/*.js"), glob("*.css"));
4113 foreach ($files as $file) {
4114 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
4120 function T_js_decl($s1, $s2) {
4122 $s1 = preg_replace("/\n/", "", $s1);
4123 $s2 = preg_replace("/\n/", "", $s2);
4125 $s1 = preg_replace("/\"/", "\\\"", $s1);
4126 $s2 = preg_replace("/\"/", "\\\"", $s2);
4128 return "T_messages[\"$s1\"] = \"$s2\";\n";
4132 function init_js_translations() {
4134 print 'var T_messages = new Object();
4137 if (T_messages[msg]) {
4138 return T_messages[msg];
4144 function ngettext(msg1, msg2, n) {
4145 return (parseInt(n) > 1) ? msg2 : msg1;
4148 $l10n = _get_reader();
4150 for ($i = 0; $i < $l10n->total
; $i++
) {
4151 $orig = $l10n->get_original_string($i);
4152 $translation = __($orig);
4154 print T_js_decl($orig, $translation);