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