]> git.wh0rd.org - tt-rss.git/blob - include/functions2.php
git.wh0rd.org / tt-rss.git / blob
? search:


ca58ea6c560517a0fa48127b2fb1fe80a8cf2f0d
[tt-rss.git] / include / functions2.php
1 <?php
2 function make_init_params() {
3 $params = array();
4
5 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
6 "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
7 "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
8 "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
9
10 $params[strtolower($param)] = (int) get_pref($param);
11 }
12
13 $params["icons_url"] = ICONS_URL;
14 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
15 $params["default_view_mode"] = get_pref("_DEFAULT_VIEW_MODE");
16 $params["default_view_limit"] = (int) get_pref("_DEFAULT_VIEW_LIMIT");
17 $params["default_view_order_by"] = get_pref("_DEFAULT_VIEW_ORDER_BY");
18 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
19 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
20 $params["theme"] = get_pref("USER_CSS_THEME", false, false);
21 $params["plugins"] = implode(", ", PluginHost::getInstance()->get_plugin_names());
22
23 $params["php_platform"] = PHP_OS;
24 $params["php_version"] = PHP_VERSION;
25
26 $params["sanity_checksum"] = sha1(file_get_contents("include/sanity_check.php"));
27
28 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
29 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
30
31 $max_feed_id = db_fetch_result($result, 0, "mid");
32 $num_feeds = db_fetch_result($result, 0, "nf");
33
34 $params["max_feed_id"] = (int) $max_feed_id;
35 $params["num_feeds"] = (int) $num_feeds;
36
37 $params["hotkeys"] = get_hotkeys_map();
38
39 $params["csrf_token"] = $_SESSION["csrf_token"];
40 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
41
42 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
43
44 return $params;
45 }
46
47 function get_hotkeys_info() {
48 $hotkeys = array(
49 __("Navigation") => array(
50 "next_feed" => __("Open next feed"),
51 "prev_feed" => __("Open previous feed"),
52 "next_article" => __("Open next article"),
53 "prev_article" => __("Open previous article"),
54 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
55 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
56 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
57 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
58 "search_dialog" => __("Show search dialog")),
59 __("Article") => array(
60 "toggle_mark" => __("Toggle starred"),
61 "toggle_publ" => __("Toggle published"),
62 "toggle_unread" => __("Toggle unread"),
63 "edit_tags" => __("Edit tags"),
64 "dismiss_selected" => __("Dismiss selected"),
65 "dismiss_read" => __("Dismiss read"),
66 "open_in_new_window" => __("Open in new window"),
67 "catchup_below" => __("Mark below as read"),
68 "catchup_above" => __("Mark above as read"),
69 "article_scroll_down" => __("Scroll down"),
70 "article_scroll_up" => __("Scroll up"),
71 "select_article_cursor" => __("Select article under cursor"),
72 "email_article" => __("Email article"),
73 "close_article" => __("Close/collapse article"),
74 "toggle_expand" => __("Toggle article expansion (combined mode)"),
75 "toggle_widescreen" => __("Toggle widescreen mode"),
76 "toggle_embed_original" => __("Toggle embed original")),
77 __("Article selection") => array(
78 "select_all" => __("Select all articles"),
79 "select_unread" => __("Select unread"),
80 "select_marked" => __("Select starred"),
81 "select_published" => __("Select published"),
82 "select_invert" => __("Invert selection"),
83 "select_none" => __("Deselect everything")),
84 __("Feed") => array(
85 "feed_refresh" => __("Refresh current feed"),
86 "feed_unhide_read" => __("Un/hide read feeds"),
87 "feed_subscribe" => __("Subscribe to feed"),
88 "feed_edit" => __("Edit feed"),
89 "feed_catchup" => __("Mark as read"),
90 "feed_reverse" => __("Reverse headlines"),
91 "feed_debug_update" => __("Debug feed update"),
92 "catchup_all" => __("Mark all feeds as read"),
93 "cat_toggle_collapse" => __("Un/collapse current category"),
94 "toggle_combined_mode" => __("Toggle combined mode"),
95 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
96 __("Go to") => array(
97 "goto_all" => __("All articles"),
98 "goto_fresh" => __("Fresh"),
99 "goto_marked" => __("Starred"),
100 "goto_published" => __("Published"),
101 "goto_tagcloud" => __("Tag cloud"),
102 "goto_prefs" => __("Preferences")),
103 __("Other") => array(
104 "create_label" => __("Create label"),
105 "create_filter" => __("Create filter"),
106 "collapse_sidebar" => __("Un/collapse sidebar"),
107 "help_dialog" => __("Show help dialog"))
108 );
109
110 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_INFO) as $plugin) {
111 $hotkeys = $plugin->hook_hotkey_info($hotkeys);
112 }
113
114 return $hotkeys;
115 }
116
117 function get_hotkeys_map() {
118 $hotkeys = array(
119 // "navigation" => array(
120 "k" => "next_feed",
121 "j" => "prev_feed",
122 "n" => "next_article",
123 "p" => "prev_article",
124 "(38)|up" => "prev_article",
125 "(40)|down" => "next_article",
126 // "^(38)|Ctrl-up" => "prev_article_noscroll",
127 // "^(40)|Ctrl-down" => "next_article_noscroll",
128 "(191)|/" => "search_dialog",
129 // "article" => array(
130 "s" => "toggle_mark",
131 "*s" => "toggle_publ",
132 "u" => "toggle_unread",
133 "*t" => "edit_tags",
134 "*d" => "dismiss_selected",
135 "*x" => "dismiss_read",
136 "o" => "open_in_new_window",
137 "c p" => "catchup_below",
138 "c n" => "catchup_above",
139 "*n" => "article_scroll_down",
140 "*p" => "article_scroll_up",
141 "*(38)|Shift+up" => "article_scroll_up",
142 "*(40)|Shift+down" => "article_scroll_down",
143 "a *w" => "toggle_widescreen",
144 "a e" => "toggle_embed_original",
145 "e" => "email_article",
146 "a q" => "close_article",
147 // "article_selection" => array(
148 "a a" => "select_all",
149 "a u" => "select_unread",
150 "a *u" => "select_marked",
151 "a p" => "select_published",
152 "a i" => "select_invert",
153 "a n" => "select_none",
154 // "feed" => array(
155 "f r" => "feed_refresh",
156 "f a" => "feed_unhide_read",
157 "f s" => "feed_subscribe",
158 "f e" => "feed_edit",
159 "f q" => "feed_catchup",
160 "f x" => "feed_reverse",
161 "f *d" => "feed_debug_update",
162 "f *c" => "toggle_combined_mode",
163 "f c" => "toggle_cdm_expanded",
164 "*q" => "catchup_all",
165 "x" => "cat_toggle_collapse",
166 // "goto" => array(
167 "g a" => "goto_all",
168 "g f" => "goto_fresh",
169 "g s" => "goto_marked",
170 "g p" => "goto_published",
171 "g t" => "goto_tagcloud",
172 "g *p" => "goto_prefs",
173 // "other" => array(
174 "(9)|Tab" => "select_article_cursor", // tab
175 "c l" => "create_label",
176 "c f" => "create_filter",
177 "c s" => "collapse_sidebar",
178 "^(191)|Ctrl+/" => "help_dialog",
179 );
180
181 if (get_pref('COMBINED_DISPLAY_MODE')) {
182 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
183 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
184 }
185
186 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_MAP) as $plugin) {
187 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
188 }
189
190 $prefixes = array();
191
192 foreach (array_keys($hotkeys) as $hotkey) {
193 $pair = explode(" ", $hotkey, 2);
194
195 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
196 array_push($prefixes, $pair[0]);
197 }
198 }
199
200 return array($prefixes, $hotkeys);
201 }
202
203 function make_runtime_info() {
204 $data = array();
205
206 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
207 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
208
209 $max_feed_id = db_fetch_result($result, 0, "mid");
210 $num_feeds = db_fetch_result($result, 0, "nf");
211
212 $data["max_feed_id"] = (int) $max_feed_id;
213 $data["num_feeds"] = (int) $num_feeds;
214
215 $data['last_article_id'] = getLastArticleId();
216 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
217
218 $data['dep_ts'] = calculate_dep_timestamp();
219 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
220
221 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
222
223 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
224
225 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
226
227 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
228
229 if ($stamp) {
230 $stamp_delta = time() - $stamp;
231
232 if ($stamp_delta > 1800) {
233 $stamp_check = 0;
234 } else {
235 $stamp_check = 1;
236 $_SESSION["daemon_stamp_check"] = time();
237 }
238
239 $data['daemon_stamp_ok'] = $stamp_check;
240
241 $stamp_fmt = date("Y.m.d, G:i", $stamp);
242
243 $data['daemon_stamp'] = $stamp_fmt;
244 }
245 }
246 }
247
248 if ($_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
249 $new_version_details = @check_for_update();
250
251 $data['new_version_available'] = (int) ($new_version_details != false);
252
253 $_SESSION["last_version_check"] = time();
254 $_SESSION["version_data"] = $new_version_details;
255 }
256
257 return $data;
258 }
259
260 function search_to_sql($search) {
261
262 $search_query_part = "";
263
264 $keywords = str_getcsv($search, " ");
265 $query_keywords = array();
266 $search_words = array();
267
268 foreach ($keywords as $k) {
269 if (strpos($k, "-") === 0) {
270 $k = substr($k, 1);
271 $not = "NOT";
272 } else {
273 $not = "";
274 }
275
276 $commandpair = explode(":", mb_strtolower($k), 2);
277
278 switch ($commandpair[0]) {
279 case "title":
280 if ($commandpair[1]) {
281 array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
282 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
283 } else {
284 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
285 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
286 array_push($search_words, $k);
287 }
288 break;
289 case "author":
290 if ($commandpair[1]) {
291 array_push($query_keywords, "($not (LOWER(author) LIKE '%".
292 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
293 } else {
294 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
295 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
296 array_push($search_words, $k);
297 }
298 break;
299 case "note":
300 if ($commandpair[1]) {
301 if ($commandpair[1] == "true")
302 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
303 else if ($commandpair[1] == "false")
304 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
305 else
306 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
307 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
308 } else {
309 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
310 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
311 if (!$not) array_push($search_words, $k);
312 }
313 break;
314 case "star":
315
316 if ($commandpair[1]) {
317 if ($commandpair[1] == "true")
318 array_push($query_keywords, "($not (marked = true))");
319 else
320 array_push($query_keywords, "($not (marked = false))");
321 } else {
322 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
323 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
324 if (!$not) array_push($search_words, $k);
325 }
326 break;
327 case "pub":
328 if ($commandpair[1]) {
329 if ($commandpair[1] == "true")
330 array_push($query_keywords, "($not (published = true))");
331 else
332 array_push($query_keywords, "($not (published = false))");
333
334 } else {
335 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
336 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
337 if (!$not) array_push($search_words, $k);
338 }
339 break;
340 default:
341 if (strpos($k, "@") === 0) {
342
343 $user_tz_string = get_pref('USER_TIMEZONE', $_SESSION['uid']);
344 $orig_ts = strtotime(substr($k, 1));
345 $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
346
347 //$k = date("Y-m-d", strtotime(substr($k, 1)));
348
349 array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
350 } else {
351 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
352 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
353
354 if (!$not) array_push($search_words, $k);
355 }
356 }
357 }
358
359 $search_query_part = implode("AND", $query_keywords);
360
361 return array($search_query_part, $search_words);
362 }
363
364 function getParentCategories($cat, $owner_uid) {
365 $rv = array();
366
367 $result = db_query("SELECT parent_cat FROM ttrss_feed_categories
368 WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
369
370 while ($line = db_fetch_assoc($result)) {
371 array_push($rv, $line["parent_cat"]);
372 $rv = array_merge($rv, getParentCategories($line["parent_cat"], $owner_uid));
373 }
374
375 return $rv;
376 }
377
378 function getChildCategories($cat, $owner_uid) {
379 $rv = array();
380
381 $result = db_query("SELECT id FROM ttrss_feed_categories
382 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
383
384 while ($line = db_fetch_assoc($result)) {
385 array_push($rv, $line["id"]);
386 $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
387 }
388
389 return $rv;
390 }
391
392 function queryFeedHeadlines($feed, $limit, $view_mode, $cat_view, $search, $search_mode, $override_order = false, $offset = 0, $owner_uid = 0, $filter = false, $since_id = 0, $include_children = false, $ignore_vfeed_group = false, $override_strategy = false, $override_vfeed = false, $start_ts = false) {
393
394 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
395
396 $ext_tables_part = "";
397 $search_words = array();
398
399 if ($search) {
400
401 if (SPHINX_ENABLED) {
402 $ids = join(",", @sphinx_search($search, 0, 500));
403
404 if ($ids)
405 $search_query_part = "ref_id IN ($ids) AND ";
406 else
407 $search_query_part = "ref_id = -1 AND ";
408
409 } else {
410 list($search_query_part, $search_words) = search_to_sql($search);
411 $search_query_part .= " AND ";
412 }
413
414 } else {
415 $search_query_part = "";
416 }
417
418 if ($filter) {
419
420 if (DB_TYPE == "pgsql") {
421 $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
422 } else {
423 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
424 }
425
426 $override_order = "updated DESC";
427
428 $filter_query_part = filter_to_sql($filter, $owner_uid);
429
430 // Try to check if SQL regexp implementation chokes on a valid regexp
431
432
433 $result = db_query("SELECT true AS true_val FROM ttrss_entries,
434 ttrss_user_entries, ttrss_feeds
435 WHERE $filter_query_part LIMIT 1", false);
436
437 if ($result) {
438 $test = db_fetch_result($result, 0, "true_val");
439
440 if (!$test) {
441 $filter_query_part = "false AND";
442 } else {
443 $filter_query_part .= " AND";
444 }
445 } else {
446 $filter_query_part = "false AND";
447 }
448
449 } else {
450 $filter_query_part = "";
451 }
452
453 if ($since_id) {
454 $since_id_part = "ttrss_entries.id > $since_id AND ";
455 } else {
456 $since_id_part = "";
457 }
458
459 $view_query_part = "";
460
461 if ($view_mode == "adaptive") {
462 if ($search) {
463 $view_query_part = " ";
464 } else if ($feed != -1) {
465
466 $unread = getFeedUnread($feed, $cat_view);
467
468 if ($cat_view && $feed > 0 && $include_children)
469 $unread += getCategoryChildrenUnread($feed);
470
471 if ($unread > 0)
472 $view_query_part = " unread = true AND ";
473
474 }
475 }
476
477 if ($view_mode == "marked") {
478 $view_query_part = " marked = true AND ";
479 }
480
481 if ($view_mode == "has_note") {
482 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
483 }
484
485 if ($view_mode == "published") {
486 $view_query_part = " published = true AND ";
487 }
488
489 if ($view_mode == "unread" && $feed != -6) {
490 $view_query_part = " unread = true AND ";
491 }
492
493 if ($limit > 0) {
494 $limit_query_part = "LIMIT " . $limit;
495 }
496
497 $allow_archived = false;
498
499 $vfeed_query_part = "";
500
501 // override query strategy and enable feed display when searching globally
502 if ($search && $search_mode == "all_feeds") {
503 $query_strategy_part = "true";
504 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
505 /* tags */
506 } else if (!is_numeric($feed)) {
507 $query_strategy_part = "true";
508 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
509 id = feed_id) as feed_title,";
510 } else if ($search && $search_mode == "this_cat") {
511 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
512
513 if ($feed > 0) {
514 if ($include_children) {
515 $subcats = getChildCategories($feed, $owner_uid);
516 array_push($subcats, $feed);
517 $cats_qpart = join(",", $subcats);
518 } else {
519 $cats_qpart = $feed;
520 }
521
522 $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
523
524 } else {
525 $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
526 }
527
528 } else if ($feed > 0) {
529
530 if ($cat_view) {
531
532 if ($feed > 0) {
533 if ($include_children) {
534 # sub-cats
535 $subcats = getChildCategories($feed, $owner_uid);
536
537 array_push($subcats, $feed);
538 $query_strategy_part = "cat_id IN (".
539 implode(",", $subcats).")";
540
541 } else {
542 $query_strategy_part = "cat_id = '$feed'";
543 }
544
545 } else {
546 $query_strategy_part = "cat_id IS NULL";
547 }
548
549 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
550
551 } else {
552 $query_strategy_part = "feed_id = '$feed'";
553 }
554 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
555 $query_strategy_part = "feed_id IS NULL";
556 $allow_archived = true;
557 } else if ($feed == 0 && $cat_view) { // uncategorized
558 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
559 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
560 } else if ($feed == -1) { // starred virtual feed
561 $query_strategy_part = "marked = true";
562 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
563 $allow_archived = true;
564
565 if (!$override_order) {
566 $override_order = "last_marked DESC, date_entered DESC, updated DESC";
567 }
568
569 } else if ($feed == -2) { // published virtual feed OR labels category
570
571 if (!$cat_view) {
572 $query_strategy_part = "published = true";
573 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
574 $allow_archived = true;
575
576 if (!$override_order) {
577 $override_order = "last_published DESC, date_entered DESC, updated DESC";
578 }
579
580 } else {
581 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
582
583 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
584
585 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
586 ttrss_user_labels2.article_id = ref_id";
587
588 }
589 } else if ($feed == -6) { // recently read
590 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
591 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
592 $allow_archived = true;
593 $ignore_vfeed_group = true;
594
595 if (!$override_order) $override_order = "last_read DESC";
596
597 /* } else if ($feed == -7) { // shared
598 $query_strategy_part = "uuid != ''";
599 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
600 $allow_archived = true; */
601 } else if ($feed == -3) { // fresh virtual feed
602 $query_strategy_part = "unread = true AND score >= 0";
603
604 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
605
606 if (DB_TYPE == "pgsql") {
607 $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
608 } else {
609 $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
610 }
611
612 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
613 } else if ($feed == -4) { // all articles virtual feed
614 $allow_archived = true;
615 $query_strategy_part = "true";
616 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
617 } else if ($feed <= LABEL_BASE_INDEX) { // labels
618 $label_id = feed_to_label_id($feed);
619
620 $query_strategy_part = "label_id = '$label_id' AND
621 ttrss_labels2.id = ttrss_user_labels2.label_id AND
622 ttrss_user_labels2.article_id = ref_id";
623
624 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
625 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
626 $allow_archived = true;
627
628 } else {
629 $query_strategy_part = "true";
630 }
631
632 $order_by = "score DESC, date_entered DESC, updated DESC";
633
634 if ($view_mode == "unread_first") {
635 $order_by = "unread DESC, $order_by";
636 }
637
638 if ($override_order) {
639 $order_by = $override_order;
640 }
641
642 if ($override_strategy) {
643 $query_strategy_part = $override_strategy;
644 }
645
646 if ($override_vfeed) {
647 $vfeed_query_part = $override_vfeed;
648 }
649
650 $feed_title = "";
651
652 if ($search) {
653 $feed_title = T_sprintf("Search results: %s", $search);
654 } else {
655 if ($cat_view) {
656 $feed_title = getCategoryTitle($feed);
657 } else {
658 if (is_numeric($feed) && $feed > 0) {
659 $result = db_query("SELECT title,site_url,last_error,last_updated
660 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
661
662 $feed_title = db_fetch_result($result, 0, "title");
663 $feed_site_url = db_fetch_result($result, 0, "site_url");
664 $last_error = db_fetch_result($result, 0, "last_error");
665 $last_updated = db_fetch_result($result, 0, "last_updated");
666 } else {
667 $feed_title = getFeedTitle($feed);
668 }
669 }
670 }
671
672
673 $content_query_part = "content, ";
674
675
676 if (is_numeric($feed)) {
677
678 if ($feed >= 0) {
679 $feed_kind = "Feeds";
680 } else {
681 $feed_kind = "Labels";
682 }
683
684 if ($limit_query_part) {
685 $offset_query_part = "OFFSET $offset";
686 }
687
688 // proper override_order applied above
689 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
690 if (!$override_order) {
691 $order_by = "ttrss_feeds.title, $order_by";
692 } else {
693 $order_by = "ttrss_feeds.title, $override_order";
694 }
695 }
696
697 if (!$allow_archived) {
698 $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
699 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
700
701 } else {
702 $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
703 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
704 }
705
706 if ($vfeed_query_part)
707 $vfeed_query_part .= "favicon_avg_color,";
708
709 if ($start_ts) {
710 $start_ts_formatted = date("Y/m/d H:i:s", strtotime($start_ts));
711 $start_ts_query_part = "date_entered >= '$start_ts_formatted' AND";
712 } else {
713 $start_ts_query_part = "";
714 }
715
716 $query = "SELECT DISTINCT
717 date_entered,
718 guid,
719 ttrss_entries.id,ttrss_entries.title,
720 updated,
721 label_cache,
722 tag_cache,
723 always_display_enclosures,
724 site_url,
725 note,
726 num_comments,
727 comments,
728 int_id,
729 uuid,
730 lang,
731 hide_images,
732 unread,feed_id,marked,published,link,last_read,orig_feed_id,
733 last_marked, last_published,
734 $vfeed_query_part
735 $content_query_part
736 author,score
737 FROM
738 $from_qpart
739 WHERE
740 $feed_check_qpart
741 ttrss_user_entries.ref_id = ttrss_entries.id AND
742 ttrss_user_entries.owner_uid = '$owner_uid' AND
743 $search_query_part
744 $start_ts_query_part
745 $filter_query_part
746 $view_query_part
747 $since_id_part
748 $query_strategy_part ORDER BY $order_by
749 $limit_query_part $offset_query_part";
750
751 if ($_REQUEST["debug"]) print $query;
752
753 $result = db_query($query);
754
755 } else {
756 // browsing by tag
757
758 $select_qpart = "SELECT DISTINCT " .
759 "date_entered," .
760 "guid," .
761 "note," .
762 "ttrss_entries.id as id," .
763 "title," .
764 "updated," .
765 "unread," .
766 "feed_id," .
767 "orig_feed_id," .
768 "marked," .
769 "num_comments, " .
770 "comments, " .
771 "tag_cache," .
772 "label_cache," .
773 "link," .
774 "lang," .
775 "uuid," .
776 "last_read," .
777 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
778 "last_marked, last_published, " .
779 $since_id_part .
780 $vfeed_query_part .
781 $content_query_part .
782 "score ";
783
784 $feed_kind = "Tags";
785 $all_tags = explode(",", $feed);
786 if ($search_mode == 'any') {
787 $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
788 $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
789 $where_qpart = " WHERE " .
790 "ref_id = ttrss_entries.id AND " .
791 "ttrss_user_entries.owner_uid = $owner_uid AND " .
792 "post_int_id = int_id AND $tag_sql AND " .
793 $view_query_part .
794 $search_query_part .
795 $query_strategy_part . " ORDER BY $order_by " .
796 $limit_query_part;
797
798 } else {
799 $i = 1;
800 $sub_selects = array();
801 $sub_ands = array();
802 foreach ($all_tags as $term) {
803 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");
804 $i++;
805 }
806 if ($i > 2) {
807 $x = 1;
808 $y = 2;
809 do {
810 array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
811 $x++;
812 $y++;
813 } while ($y < $i);
814 }
815 array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
816 array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
817 $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
818 $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
819 }
820 // error_log("TAG SQL: " . $tag_sql);
821 // $tag_sql = "tag_name = '$feed'"; DEFAULT way
822
823 // error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
824 $result = db_query($select_qpart . $from_qpart . $where_qpart);
825 }
826
827 return array($result, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words);
828
829 }
830
831 function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false, $highlight_words = false, $article_id = false) {
832 if (!$owner) $owner = $_SESSION["uid"];
833
834 $res = trim($str); if (!$res) return '';
835
836 $charset_hack = '<head>
837 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
838 </head>';
839
840 $res = trim($res); if (!$res) return '';
841
842 libxml_use_internal_errors(true);
843
844 $doc = new DOMDocument();
845 $doc->loadHTML($charset_hack . $res);
846 $xpath = new DOMXPath($doc);
847
848 $entries = $xpath->query('(//a[@href]|//img[@src])');
849
850 foreach ($entries as $entry) {
851
852 if ($site_url) {
853
854 if ($entry->hasAttribute('href')) {
855 $entry->setAttribute('href',
856 rewrite_relative_url($site_url, $entry->getAttribute('href')));
857
858 $entry->setAttribute('rel', 'noreferrer');
859 }
860
861 if ($entry->hasAttribute('src')) {
862 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
863
864 $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
865
866 if (file_exists($cached_filename)) {
867 $src = SELF_URL_PATH . '/image.php?hash=' . sha1($src);
868 }
869
870 $entry->setAttribute('src', $src);
871 }
872
873 if ($entry->nodeName == 'img') {
874 if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
875 $force_remove_images || $_SESSION["bw_limit"]) {
876
877 $p = $doc->createElement('p');
878
879 $a = $doc->createElement('a');
880 $a->setAttribute('href', $entry->getAttribute('src'));
881
882 $a->appendChild(new DOMText($entry->getAttribute('src')));
883 $a->setAttribute('target', '_blank');
884
885 $p->appendChild($a);
886
887 $entry->parentNode->replaceChild($p, $entry);
888 }
889 }
890 }
891
892 if (strtolower($entry->nodeName) == "a") {
893 $entry->setAttribute("target", "_blank");
894 }
895 }
896
897 $entries = $xpath->query('//iframe');
898 foreach ($entries as $entry) {
899 $entry->setAttribute('sandbox', 'allow-scripts');
900
901 }
902
903 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
904 'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
905 'caption', 'cite', 'center', 'code', 'col', 'colgroup',
906 'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
907 'dt', 'em', 'footer', 'figure', 'figcaption',
908 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
909 'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
910 'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
911 'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
912 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
913 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
914
915 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
916
917 $disallowed_attributes = array('id', 'style', 'class');
918
919 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SANITIZE) as $plugin) {
920 $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes, $article_id);
921 if (is_array($retval)) {
922 $doc = $retval[0];
923 $allowed_elements = $retval[1];
924 $disallowed_attributes = $retval[2];
925 } else {
926 $doc = $retval;
927 }
928 }
929
930 $doc->removeChild($doc->firstChild); //remove doctype
931 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
932
933 if ($highlight_words) {
934 foreach ($highlight_words as $word) {
935
936 // http://stackoverflow.com/questions/4081372/highlight-keywords-in-a-paragraph
937
938 $elements = $xpath->query("//*/text()");
939
940 foreach ($elements as $child) {
941
942 $fragment = $doc->createDocumentFragment();
943 $text = $child->textContent;
944
945 while (($pos = mb_stripos($text, $word)) !== false) {
946 $fragment->appendChild(new DomText(mb_substr($text, 0, $pos)));
947 $word = mb_substr($text, $pos, mb_strlen($word));
948 $highlight = $doc->createElement('span');
949 $highlight->appendChild(new DomText($word));
950 $highlight->setAttribute('class', 'highlight');
951 $fragment->appendChild($highlight);
952 $text = mb_substr($text, $pos + mb_strlen($word));
953 }
954
955 if (!empty($text)) $fragment->appendChild(new DomText($text));
956
957 $child->parentNode->replaceChild($fragment, $child);
958 }
959 }
960 }
961
962 $res = $doc->saveHTML();
963
964 return $res;
965 }
966
967 function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
968 $xpath = new DOMXPath($doc);
969 $entries = $xpath->query('//*');
970
971 foreach ($entries as $entry) {
972 if (!in_array($entry->nodeName, $allowed_elements)) {
973 $entry->parentNode->removeChild($entry);
974 }
975
976 if ($entry->hasAttributes()) {
977 $attrs_to_remove = array();
978
979 foreach ($entry->attributes as $attr) {
980
981 if (strpos($attr->nodeName, 'on') === 0) {
982 array_push($attrs_to_remove, $attr);
983 }
984
985 if (in_array($attr->nodeName, $disallowed_attributes)) {
986 array_push($attrs_to_remove, $attr);
987 }
988 }
989
990 foreach ($attrs_to_remove as $attr) {
991 $entry->removeAttributeNode($attr);
992 }
993 }
994 }
995
996 return $doc;
997 }
998
999 function check_for_update() {
1000 if (CHECK_FOR_NEW_VERSION && $_SESSION['access_level'] >= 10) {
1001 $version_url = "http://tt-rss.org/version.php?ver=" . VERSION .
1002 "&iid=" . sha1(SELF_URL_PATH);
1003
1004 $version_data = @fetch_file_contents($version_url);
1005
1006 if ($version_data) {
1007 $version_data = json_decode($version_data, true);
1008 if ($version_data && $version_data['version']) {
1009 if (version_compare(VERSION_STATIC, $version_data['version']) == -1) {
1010 return $version_data;
1011 }
1012 }
1013 }
1014 }
1015 return false;
1016 }
1017
1018 function catchupArticlesById($ids, $cmode, $owner_uid = false) {
1019
1020 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1021 if (count($ids) == 0) return;
1022
1023 $tmp_ids = array();
1024
1025 foreach ($ids as $id) {
1026 array_push($tmp_ids, "ref_id = '$id'");
1027 }
1028
1029 $ids_qpart = join(" OR ", $tmp_ids);
1030
1031 if ($cmode == 0) {
1032 db_query("UPDATE ttrss_user_entries SET
1033 unread = false,last_read = NOW()
1034 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1035 } else if ($cmode == 1) {
1036 db_query("UPDATE ttrss_user_entries SET
1037 unread = true
1038 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1039 } else {
1040 db_query("UPDATE ttrss_user_entries SET
1041 unread = NOT unread,last_read = NOW()
1042 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1043 }
1044
1045 /* update ccache */
1046
1047 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
1048 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1049
1050 while ($line = db_fetch_assoc($result)) {
1051 ccache_update($line["feed_id"], $owner_uid);
1052 }
1053 }
1054
1055 function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
1056
1057 $a_id = db_escape_string($id);
1058
1059 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1060
1061 $query = "SELECT DISTINCT tag_name,
1062 owner_uid as owner FROM
1063 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
1064 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
1065
1066 $tags = array();
1067
1068 /* check cache first */
1069
1070 if ($tag_cache === false) {
1071 $result = db_query("SELECT tag_cache FROM ttrss_user_entries
1072 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1073
1074 $tag_cache = db_fetch_result($result, 0, "tag_cache");
1075 }
1076
1077 if ($tag_cache) {
1078 $tags = explode(",", $tag_cache);
1079 } else {
1080
1081 /* do it the hard way */
1082
1083 $tmp_result = db_query($query);
1084
1085 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1086 array_push($tags, $tmp_line["tag_name"]);
1087 }
1088
1089 /* update the cache */
1090
1091 $tags_str = db_escape_string(join(",", $tags));
1092
1093 db_query("UPDATE ttrss_user_entries
1094 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
1095 AND owner_uid = $owner_uid");
1096 }
1097
1098 return $tags;
1099 }
1100
1101 function trim_array($array) {
1102 $tmp = $array;
1103 array_walk($tmp, 'trim');
1104 return $tmp;
1105 }
1106
1107 function tag_is_valid($tag) {
1108 if ($tag == '') return false;
1109 if (preg_match("/^[0-9]*$/", $tag)) return false;
1110 if (mb_strlen($tag) > 250) return false;
1111
1112 if (!$tag) return false;
1113
1114 return true;
1115 }
1116
1117 function render_login_form() {
1118 header('Cache-Control: public');
1119
1120 require_once "login_form.php";
1121 exit;
1122 }
1123
1124 function format_warning($msg, $id = "") {
1125 return "<div class=\"warning\" id=\"$id\">
1126 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
1127 }
1128
1129 function format_notice($msg, $id = "") {
1130 return "<div class=\"notice\" id=\"$id\">
1131 <span><img src=\"images/information.png\"></span><span>$msg</span></div>";
1132 }
1133
1134 function format_error($msg, $id = "") {
1135 return "<div class=\"error\" id=\"$id\">
1136 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
1137 }
1138
1139 function print_notice($msg) {
1140 return print format_notice($msg);
1141 }
1142
1143 function print_warning($msg) {
1144 return print format_warning($msg);
1145 }
1146
1147 function print_error($msg) {
1148 return print format_error($msg);
1149 }
1150
1151
1152 function T_sprintf() {
1153 $args = func_get_args();
1154 return vsprintf(__(array_shift($args)), $args);
1155 }
1156
1157 function format_inline_player($url, $ctype) {
1158
1159 $entry = "";
1160
1161 $url = htmlspecialchars($url);
1162
1163 if (strpos($ctype, "audio/") === 0) {
1164
1165 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
1166 $_SESSION["hasMp3"])) {
1167
1168 $entry .= "<audio preload=\"none\" controls>
1169 <source type=\"$ctype\" src=\"$url\"></source>
1170 </audio>";
1171
1172 } else {
1173
1174 $entry .= "<object type=\"application/x-shockwave-flash\"
1175 data=\"lib/button/musicplayer.swf?song_url=$url\"
1176 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
1177 <param name=\"movie\"
1178 value=\"lib/button/musicplayer.swf?song_url=$url\" />
1179 </object>";
1180 }
1181
1182 if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
1183 href=\"$url\">" . basename($url) . "</a>";
1184
1185 return $entry;
1186
1187 }
1188
1189 return "";
1190
1191 /* $filename = substr($url, strrpos($url, "/")+1);
1192
1193 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1194 $filename . " (" . $ctype . ")" . "</a>"; */
1195
1196 }
1197
1198 function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
1199 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1200
1201 $rv = array();
1202
1203 $rv['id'] = $id;
1204
1205 /* we can figure out feed_id from article id anyway, why do we
1206 * pass feed_id here? let's ignore the argument :(*/
1207
1208 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1209 WHERE ref_id = '$id'");
1210
1211 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
1212
1213 $rv['feed_id'] = $feed_id;
1214
1215 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
1216
1217 if ($mark_as_read) {
1218 $result = db_query("UPDATE ttrss_user_entries
1219 SET unread = false,last_read = NOW()
1220 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1221
1222 ccache_update($feed_id, $owner_uid);
1223 }
1224
1225 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,lang,
1226 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
1227 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
1228 (SELECT title FROM ttrss_feeds WHERE id = feed_id) as feed_title,
1229 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
1230 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
1231 num_comments,
1232 tag_cache,
1233 author,
1234 orig_feed_id,
1235 note
1236 FROM ttrss_entries,ttrss_user_entries
1237 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
1238
1239 if ($result) {
1240
1241 $line = db_fetch_assoc($result);
1242
1243 $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
1244 unset($line["tag_cache"]);
1245
1246 $line["content"] = sanitize($line["content"],
1247 sql_bool_to_bool($line['hide_images']),
1248 $owner_uid, $line["site_url"], false, $line["id"]);
1249
1250 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE) as $p) {
1251 $line = $p->hook_render_article($line);
1252 }
1253
1254 $num_comments = $line["num_comments"];
1255 $entry_comments = "";
1256
1257 if ($num_comments > 0) {
1258 if ($line["comments"]) {
1259 $comments_url = htmlspecialchars($line["comments"]);
1260 } else {
1261 $comments_url = htmlspecialchars($line["link"]);
1262 }
1263 $entry_comments = "<a class=\"postComments\"
1264 target='_blank' href=\"$comments_url\">$num_comments ".
1265 _ngettext("comment", "comments", $num_comments)."</a>";
1266
1267 } else {
1268 if ($line["comments"] && $line["link"] != $line["comments"]) {
1269 $entry_comments = "<a class=\"postComments\" target='_blank' href=\"".htmlspecialchars($line["comments"])."\">".__("comments")."</a>";
1270 }
1271 }
1272
1273 if ($zoom_mode) {
1274 header("Content-Type: text/html");
1275 $rv['content'] .= "<html><head>
1276 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
1277 <title>Tiny Tiny RSS - ".$line["title"]."</title>".
1278 stylesheet_tag("css/tt-rss.css").
1279 stylesheet_tag("css/zoom.css").
1280 stylesheet_tag("css/dijit.css")."
1281
1282 <link rel=\"shortcut icon\" type=\"image/png\" href=\"images/favicon.png\">
1283 <link rel=\"icon\" type=\"image/png\" sizes=\"72x72\" href=\"images/favicon-72px.png\">
1284
1285 <script type=\"text/javascript\">
1286 function openSelectedAttachment(elem) {
1287 try {
1288 var url = elem[elem.selectedIndex].value;
1289
1290 if (url) {
1291 window.open(url);
1292 elem.selectedIndex = 0;
1293 }
1294
1295 } catch (e) {
1296 exception_error(\"openSelectedAttachment\", e);
1297 }
1298 }
1299 </script>
1300 </head><body id=\"ttrssZoom\">";
1301 }
1302
1303 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
1304
1305 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
1306
1307 $entry_author = $line["author"];
1308
1309 if ($entry_author) {
1310 $entry_author = __(" - ") . $entry_author;
1311 }
1312
1313 $parsed_updated = make_local_datetime($line["updated"], true,
1314 $owner_uid, true);
1315
1316 if (!$zoom_mode)
1317 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1318
1319 if ($line["link"]) {
1320 $rv['content'] .= "<div class='postTitle'><a target='_blank'
1321 title=\"".htmlspecialchars($line['title'])."\"
1322 href=\"" .
1323 htmlspecialchars($line["link"]) . "\">" .
1324 $line["title"] . "</a>" .
1325 "<span class='author'>$entry_author</span></div>";
1326 } else {
1327 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
1328 }
1329
1330 if ($zoom_mode) {
1331 $feed_title = "<a href=\"".htmlspecialchars($line["site_url"]).
1332 "\" target=\"_blank\">".
1333 htmlspecialchars($line["feed_title"])."</a>";
1334
1335 $rv['content'] .= "<div class=\"postFeedTitle\">$feed_title</div>";
1336
1337 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1338 }
1339
1340 $tags_str = format_tags_string($line["tags"], $id);
1341 $tags_str_full = join(", ", $line["tags"]);
1342
1343 if (!$tags_str_full) $tags_str_full = __("no tags");
1344
1345 if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
1346
1347 $rv['content'] .= "<div class='postTags' style='float : right'>
1348 <img src='images/tag.png'
1349 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
1350
1351 if (!$zoom_mode) {
1352 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
1353 <a title=\"".__('Edit tags for this article')."\"
1354 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
1355
1356 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
1357 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
1358 position=\"below\">$tags_str_full</div>";
1359
1360 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_BUTTON) as $p) {
1361 $rv['content'] .= $p->hook_article_button($line);
1362 }
1363
1364 } else {
1365 $tags_str = strip_tags($tags_str);
1366 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
1367 }
1368 $rv['content'] .= "</div>";
1369 $rv['content'] .= "<div clear='both'>";
1370
1371 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
1372 $rv['content'] .= $p->hook_article_left_button($line);
1373 }
1374
1375 $rv['content'] .= "$entry_comments</div>";
1376
1377 if ($line["orig_feed_id"]) {
1378
1379 $tmp_result = db_query("SELECT * FROM ttrss_archived_feeds
1380 WHERE id = ".$line["orig_feed_id"]);
1381
1382 if (db_num_rows($tmp_result) != 0) {
1383
1384 $rv['content'] .= "<div clear='both'>";
1385 $rv['content'] .= __("Originally from:");
1386
1387 $rv['content'] .= "&nbsp;";
1388
1389 $tmp_line = db_fetch_assoc($tmp_result);
1390
1391 $rv['content'] .= "<a target='_blank'
1392 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
1393 $tmp_line['title'] . "</a>";
1394
1395 $rv['content'] .= "&nbsp;";
1396
1397 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
1398 $rv['content'] .= "<img title='".__('Feed URL')."' class='tinyFeedIcon' src='images/pub_set.png'></a>";
1399
1400 $rv['content'] .= "</div>";
1401 }
1402 }
1403
1404 $rv['content'] .= "</div>";
1405
1406 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
1407 if ($line['note']) {
1408 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
1409 }
1410 $rv['content'] .= "</div>";
1411
1412 if (!$line['lang']) $line['lang'] = 'en';
1413
1414 $rv['content'] .= "<div class=\"postContent\" lang=\"".$line['lang']."\">";
1415
1416 $rv['content'] .= $line["content"];
1417 $rv['content'] .= format_article_enclosures($id,
1418 sql_bool_to_bool($line["always_display_enclosures"]),
1419 $line["content"],
1420 sql_bool_to_bool($line["hide_images"]));
1421
1422 $rv['content'] .= "</div>";
1423
1424 $rv['content'] .= "</div>";
1425
1426 }
1427
1428 if ($zoom_mode) {
1429 $rv['content'] .= "
1430 <div class='footer'>
1431 <button onclick=\"return window.close()\">".
1432 __("Close this window")."</button></div>";
1433 $rv['content'] .= "</body></html>";
1434 }
1435
1436 return $rv;
1437
1438 }
1439
1440 function print_checkpoint($n, $s) {
1441 $ts = microtime(true);
1442 echo sprintf("<!-- CP[$n] %.4f seconds -->\n", $ts - $s);
1443 return $ts;
1444 }
1445
1446 function sanitize_tag($tag) {
1447 $tag = trim($tag);
1448
1449 $tag = mb_strtolower($tag, 'utf-8');
1450
1451 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
1452
1453 // $tag = str_replace('"', "", $tag);
1454 // $tag = str_replace("+", " ", $tag);
1455 $tag = str_replace("technorati tag: ", "", $tag);
1456
1457 return $tag;
1458 }
1459
1460 function get_self_url_prefix() {
1461 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
1462 return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
1463 } else {
1464 return SELF_URL_PATH;
1465 }
1466 }
1467
1468 /**
1469 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
1470 *
1471 * @return string The Mozilla Firefox feed adding URL.
1472 */
1473 function add_feed_url() {
1474 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
1475
1476 $url_path = get_self_url_prefix() .
1477 "/public.php?op=subscribe&feed_url=%s";
1478 return $url_path;
1479 } // function add_feed_url
1480
1481 function encrypt_password($pass, $salt = '', $mode2 = false) {
1482 if ($salt && $mode2) {
1483 return "MODE2:" . hash('sha256', $salt . $pass);
1484 } else if ($salt) {
1485 return "SHA1X:" . sha1("$salt:$pass");
1486 } else {
1487 return "SHA1:" . sha1($pass);
1488 }
1489 } // function encrypt_password
1490
1491 function load_filters($feed_id, $owner_uid, $action_id = false) {
1492 $filters = array();
1493
1494 $cat_id = (int)getFeedCategory($feed_id);
1495
1496 if ($cat_id == 0)
1497 $null_cat_qpart = "cat_id IS NULL OR";
1498 else
1499 $null_cat_qpart = "";
1500
1501 $result = db_query("SELECT * FROM ttrss_filters2 WHERE
1502 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
1503
1504 $check_cats = join(",", array_merge(
1505 getParentCategories($cat_id, $owner_uid),
1506 array($cat_id)));
1507
1508 while ($line = db_fetch_assoc($result)) {
1509 $filter_id = $line["id"];
1510
1511 $result2 = db_query("SELECT
1512 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
1513 FROM ttrss_filters2_rules AS r,
1514 ttrss_filter_types AS t
1515 WHERE
1516 ($null_cat_qpart (cat_id IS NULL AND cat_filter = false) OR cat_id IN ($check_cats)) AND
1517 (feed_id IS NULL OR feed_id = '$feed_id') AND
1518 filter_type = t.id AND filter_id = '$filter_id'");
1519
1520 $rules = array();
1521 $actions = array();
1522
1523 while ($rule_line = db_fetch_assoc($result2)) {
1524 # print_r($rule_line);
1525
1526 $rule = array();
1527 $rule["reg_exp"] = $rule_line["reg_exp"];
1528 $rule["type"] = $rule_line["type_name"];
1529 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1530
1531 array_push($rules, $rule);
1532 }
1533
1534 $result2 = db_query("SELECT a.action_param,t.name AS type_name
1535 FROM ttrss_filters2_actions AS a,
1536 ttrss_filter_actions AS t
1537 WHERE
1538 action_id = t.id AND filter_id = '$filter_id'");
1539
1540 while ($action_line = db_fetch_assoc($result2)) {
1541 # print_r($action_line);
1542
1543 $action = array();
1544 $action["type"] = $action_line["type_name"];
1545 $action["param"] = $action_line["action_param"];
1546
1547 array_push($actions, $action);
1548 }
1549
1550
1551 $filter = array();
1552 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
1553 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
1554 $filter["rules"] = $rules;
1555 $filter["actions"] = $actions;
1556
1557 if (count($rules) > 0 && count($actions) > 0) {
1558 array_push($filters, $filter);
1559 }
1560 }
1561
1562 return $filters;
1563 }
1564
1565 function get_score_pic($score) {
1566 if ($score > 100) {
1567 return "score_high.png";
1568 } else if ($score > 0) {
1569 return "score_half_high.png";
1570 } else if ($score < -100) {
1571 return "score_low.png";
1572 } else if ($score < 0) {
1573 return "score_half_low.png";
1574 } else {
1575 return "score_neutral.png";
1576 }
1577 }
1578
1579 function feed_has_icon($id) {
1580 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
1581 }
1582
1583 function init_plugins() {
1584 PluginHost::getInstance()->load(PLUGINS, PluginHost::KIND_ALL);
1585
1586 return true;
1587 }
1588
1589 function format_tags_string($tags, $id) {
1590 if (!is_array($tags) || count($tags) == 0) {
1591 return __("no tags");
1592 } else {
1593 $maxtags = min(5, count($tags));
1594
1595 for ($i = 0; $i < $maxtags; $i++) {
1596 $tags_str .= "<a class=\"tag\" href=\"#\" onclick=\"viewfeed('".$tags[$i]."')\">" . $tags[$i] . "</a>, ";
1597 }
1598
1599 $tags_str = mb_substr($tags_str, 0, mb_strlen($tags_str)-2);
1600
1601 if (count($tags) > $maxtags)
1602 $tags_str .= ", &hellip;";
1603
1604 return $tags_str;
1605 }
1606 }
1607
1608 function format_article_labels($labels, $id) {
1609
1610 if (!is_array($labels)) return '';
1611
1612 $labels_str = "";
1613
1614 foreach ($labels as $l) {
1615 $labels_str .= sprintf("<span class='hlLabelRef'
1616 style='color : %s; background-color : %s'>%s</span>",
1617 $l[2], $l[3], $l[1]);
1618 }
1619
1620 return $labels_str;
1621
1622 }
1623
1624 function format_article_note($id, $note, $allow_edit = true) {
1625
1626 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
1627 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
1628 ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
1629
1630 return $str;
1631 }
1632
1633
1634 function get_feed_category($feed_cat, $parent_cat_id = false) {
1635 if ($parent_cat_id) {
1636 $parent_qpart = "parent_cat = '$parent_cat_id'";
1637 $parent_insert = "'$parent_cat_id'";
1638 } else {
1639 $parent_qpart = "parent_cat IS NULL";
1640 $parent_insert = "NULL";
1641 }
1642
1643 $result = db_query(
1644 "SELECT id FROM ttrss_feed_categories
1645 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1646
1647 if (db_num_rows($result) == 0) {
1648 return false;
1649 } else {
1650 return db_fetch_result($result, 0, "id");
1651 }
1652 }
1653
1654 function add_feed_category($feed_cat, $parent_cat_id = false) {
1655
1656 if (!$feed_cat) return false;
1657
1658 db_query("BEGIN");
1659
1660 if ($parent_cat_id) {
1661 $parent_qpart = "parent_cat = '$parent_cat_id'";
1662 $parent_insert = "'$parent_cat_id'";
1663 } else {
1664 $parent_qpart = "parent_cat IS NULL";
1665 $parent_insert = "NULL";
1666 }
1667
1668 $feed_cat = mb_substr($feed_cat, 0, 250);
1669
1670 $result = db_query(
1671 "SELECT id FROM ttrss_feed_categories
1672 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1673
1674 if (db_num_rows($result) == 0) {
1675
1676 $result = db_query(
1677 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
1678 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
1679
1680 db_query("COMMIT");
1681
1682 return true;
1683 }
1684
1685 return false;
1686 }
1687
1688 function getArticleFeed($id) {
1689 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1690 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
1691
1692 if (db_num_rows($result) != 0) {
1693 return db_fetch_result($result, 0, "feed_id");
1694 } else {
1695 return 0;
1696 }
1697 }
1698
1699 /**
1700 * Fixes incomplete URLs by prepending "http://".
1701 * Also replaces feed:// with http://, and
1702 * prepends a trailing slash if the url is a domain name only.
1703 *
1704 * @param string $url Possibly incomplete URL
1705 *
1706 * @return string Fixed URL.
1707 */
1708 function fix_url($url) {
1709 if (strpos($url, '://') === false) {
1710 $url = 'http://' . $url;
1711 } else if (substr($url, 0, 5) == 'feed:') {
1712 $url = 'http:' . substr($url, 5);
1713 }
1714
1715 //prepend slash if the URL has no slash in it
1716 // "http://www.example" -> "http://www.example/"
1717 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
1718 $url .= '/';
1719 }
1720
1721 if ($url != "http:///")
1722 return $url;
1723 else
1724 return '';
1725 }
1726
1727 function validate_feed_url($url) {
1728 $parts = parse_url($url);
1729
1730 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
1731
1732 }
1733
1734 function get_article_enclosures($id) {
1735
1736 $query = "SELECT * FROM ttrss_enclosures
1737 WHERE post_id = '$id' AND content_url != ''";
1738
1739 $rv = array();
1740
1741 $result = db_query($query);
1742
1743 if (db_num_rows($result) > 0) {
1744 while ($line = db_fetch_assoc($result)) {
1745 array_push($rv, $line);
1746 }
1747 }
1748
1749 return $rv;
1750 }
1751
1752 function save_email_address($email) {
1753 // FIXME: implement persistent storage of emails
1754
1755 if (!$_SESSION['stored_emails'])
1756 $_SESSION['stored_emails'] = array();
1757
1758 if (!in_array($email, $_SESSION['stored_emails']))
1759 array_push($_SESSION['stored_emails'], $email);
1760 }
1761
1762
1763 function get_feed_access_key($feed_id, $is_cat, $owner_uid = false) {
1764
1765 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1766
1767 $sql_is_cat = bool_to_sql_bool($is_cat);
1768
1769 $result = db_query("SELECT access_key FROM ttrss_access_keys
1770 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
1771 AND owner_uid = " . $owner_uid);
1772
1773 if (db_num_rows($result) == 1) {
1774 return db_fetch_result($result, 0, "access_key");
1775 } else {
1776 $key = db_escape_string(uniqid(base_convert(rand(), 10, 36)));
1777
1778 $result = db_query("INSERT INTO ttrss_access_keys
1779 (access_key, feed_id, is_cat, owner_uid)
1780 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
1781
1782 return $key;
1783 }
1784 return false;
1785 }
1786
1787 function get_feeds_from_html($url, $content)
1788 {
1789 $url = fix_url($url);
1790 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
1791
1792 libxml_use_internal_errors(true);
1793
1794 $doc = new DOMDocument();
1795 $doc->loadHTML($content);
1796 $xpath = new DOMXPath($doc);
1797 $entries = $xpath->query('/html/head/link[@rel="alternate" and '.
1798 '(contains(@type,"rss") or contains(@type,"atom"))]|/html/head/link[@rel="feed"]');
1799 $feedUrls = array();
1800 foreach ($entries as $entry) {
1801 if ($entry->hasAttribute('href')) {
1802 $title = $entry->getAttribute('title');
1803 if ($title == '') {
1804 $title = $entry->getAttribute('type');
1805 }
1806 $feedUrl = rewrite_relative_url(
1807 $baseUrl, $entry->getAttribute('href')
1808 );
1809 $feedUrls[$feedUrl] = $title;
1810 }
1811 }
1812 return $feedUrls;
1813 }
1814
1815 function is_html($content) {
1816 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
1817 }
1818
1819 function url_is_html($url, $login = false, $pass = false) {
1820 return is_html(fetch_file_contents($url, false, $login, $pass));
1821 }
1822
1823 function print_label_select($name, $value, $attributes = "") {
1824
1825 $result = db_query("SELECT caption FROM ttrss_labels2
1826 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
1827
1828 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
1829 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
1830
1831 while ($line = db_fetch_assoc($result)) {
1832
1833 $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
1834
1835 print "<option value=\"".htmlspecialchars($line["caption"])."\"
1836 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
1837
1838 }
1839
1840 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
1841
1842 print "</select>";
1843
1844
1845 }
1846
1847 function format_article_enclosures($id, $always_display_enclosures,
1848 $article_content, $hide_images = false) {
1849
1850 $result = get_article_enclosures($id);
1851 $rv = '';
1852
1853 if (count($result) > 0) {
1854
1855 $entries_html = array();
1856 $entries = array();
1857 $entries_inline = array();
1858
1859 foreach ($result as $line) {
1860
1861 $url = $line["content_url"];
1862 $ctype = $line["content_type"];
1863 $title = $line["title"];
1864
1865 if (!$ctype) $ctype = __("unknown type");
1866
1867 $filename = substr($url, strrpos($url, "/")+1);
1868
1869 $player = format_inline_player($url, $ctype);
1870
1871 if ($player) array_push($entries_inline, $player);
1872
1873 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1874 # $filename . " (" . $ctype . ")" . "</a>";
1875
1876 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
1877 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
1878
1879 array_push($entries_html, $entry);
1880
1881 $entry = array();
1882
1883 $entry["type"] = $ctype;
1884 $entry["filename"] = $filename;
1885 $entry["url"] = $url;
1886 $entry["title"] = $title;
1887
1888 array_push($entries, $entry);
1889 }
1890
1891 if ($_SESSION['uid'] && !get_pref("STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
1892 if ($always_display_enclosures ||
1893 !preg_match("/<img/i", $article_content)) {
1894
1895 foreach ($entries as $entry) {
1896
1897 if (preg_match("/image/", $entry["type"]) ||
1898 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
1899
1900 if (!$hide_images) {
1901 $rv .= "<p><img
1902 alt=\"".htmlspecialchars($entry["filename"])."\"
1903 src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
1904 } else {
1905 $rv .= "<p><a target=\"_blank\"
1906 href=\"".htmlspecialchars($entry["url"])."\"
1907 >" .htmlspecialchars($entry["url"]) . "</a></p>";
1908 }
1909
1910 if ($entry['title']) {
1911 $rv.= "<div class=\"enclosure_title\">${entry['title']}</div>";
1912 }
1913 }
1914 }
1915 }
1916 }
1917
1918 if (count($entries_inline) > 0) {
1919 $rv .= "<hr clear='both'/>";
1920 foreach ($entries_inline as $entry) { $rv .= $entry; };
1921 $rv .= "<hr clear='both'/>";
1922 }
1923
1924 $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
1925 "<option value=''>" . __('Attachments')."</option>";
1926
1927 foreach ($entries as $entry) {
1928 if ($entry["title"])
1929 $title = "&mdash; " . truncate_string($entry["title"], 30);
1930 else
1931 $title = "";
1932
1933 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "$title</option>";
1934
1935 };
1936
1937 $rv .= "</select>";
1938 }
1939
1940 return $rv;
1941 }
1942
1943 function getLastArticleId() {
1944 $result = db_query("SELECT MAX(ref_id) AS id FROM ttrss_user_entries
1945 WHERE owner_uid = " . $_SESSION["uid"]);
1946
1947 if (db_num_rows($result) == 1) {
1948 return db_fetch_result($result, 0, "id");
1949 } else {
1950 return -1;
1951 }
1952 }
1953
1954 function build_url($parts) {
1955 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
1956 }
1957
1958 /**
1959 * Converts a (possibly) relative URL to a absolute one.
1960 *
1961 * @param string $url Base URL (i.e. from where the document is)
1962 * @param string $rel_url Possibly relative URL in the document
1963 *
1964 * @return string Absolute URL
1965 */
1966 function rewrite_relative_url($url, $rel_url) {
1967 if (strpos($rel_url, ":") !== false) {
1968 return $rel_url;
1969 } else if (strpos($rel_url, "://") !== false) {
1970 return $rel_url;
1971 } else if (strpos($rel_url, "//") === 0) {
1972 # protocol-relative URL (rare but they exist)
1973 return $rel_url;
1974 } else if (strpos($rel_url, "/") === 0)
1975 {
1976 $parts = parse_url($url);
1977 $parts['path'] = $rel_url;
1978
1979 return build_url($parts);
1980
1981 } else {
1982 $parts = parse_url($url);
1983 if (!isset($parts['path'])) {
1984 $parts['path'] = '/';
1985 }
1986 $dir = $parts['path'];
1987 if (substr($dir, -1) !== '/') {
1988 $dir = dirname($parts['path']);
1989 $dir !== '/' && $dir .= '/';
1990 }
1991 $parts['path'] = $dir . $rel_url;
1992
1993 return build_url($parts);
1994 }
1995 }
1996
1997 function sphinx_search($query, $offset = 0, $limit = 30) {
1998 require_once 'lib/sphinxapi.php';
1999
2000 $sphinxClient = new SphinxClient();
2001
2002 $sphinxpair = explode(":", SPHINX_SERVER, 2);
2003
2004 $sphinxClient->SetServer($sphinxpair[0], (int)$sphinxpair[1]);
2005 $sphinxClient->SetConnectTimeout(1);
2006
2007 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
2008 'feed_title' => 20));
2009
2010 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2);
2011 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
2012 $sphinxClient->SetLimits($offset, $limit, 1000);
2013 $sphinxClient->SetArrayResult(false);
2014 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
2015
2016 $result = $sphinxClient->Query($query, SPHINX_INDEX);
2017
2018 $ids = array();
2019
2020 if (is_array($result['matches'])) {
2021 foreach (array_keys($result['matches']) as $int_id) {
2022 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
2023 array_push($ids, $ref_id);
2024 }
2025 }
2026
2027 return $ids;
2028 }
2029
2030 function cleanup_tags($days = 14, $limit = 1000) {
2031
2032 if (DB_TYPE == "pgsql") {
2033 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
2034 } else if (DB_TYPE == "mysql") {
2035 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
2036 }
2037
2038 $tags_deleted = 0;
2039
2040 while ($limit > 0) {
2041 $limit_part = 500;
2042
2043 $query = "SELECT ttrss_tags.id AS id
2044 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
2045 WHERE post_int_id = int_id AND $interval_query AND
2046 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
2047
2048 $result = db_query($query);
2049
2050 $ids = array();
2051
2052 while ($line = db_fetch_assoc($result)) {
2053 array_push($ids, $line['id']);
2054 }
2055
2056 if (count($ids) > 0) {
2057 $ids = join(",", $ids);
2058
2059 $tmp_result = db_query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
2060 $tags_deleted += db_affected_rows($tmp_result);
2061 } else {
2062 break;
2063 }
2064
2065 $limit -= $limit_part;
2066 }
2067
2068 return $tags_deleted;
2069 }
2070
2071 function print_user_stylesheet() {
2072 $value = get_pref('USER_STYLESHEET');
2073
2074 if ($value) {
2075 print "<style type=\"text/css\">";
2076 print str_replace("<br/>", "\n", $value);
2077 print "</style>";
2078 }
2079
2080 }
2081
2082 function filter_to_sql($filter, $owner_uid) {
2083 $query = array();
2084
2085 if (DB_TYPE == "pgsql")
2086 $reg_qpart = "~";
2087 else
2088 $reg_qpart = "REGEXP";
2089
2090 foreach ($filter["rules"] AS $rule) {
2091 $rule['reg_exp'] = str_replace('/', '\/', $rule["reg_exp"]);
2092 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
2093 $rule['reg_exp']) !== FALSE;
2094
2095 if ($regexp_valid) {
2096
2097 $rule['reg_exp'] = db_escape_string($rule['reg_exp']);
2098
2099 switch ($rule["type"]) {
2100 case "title":
2101 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2102 $rule['reg_exp'] . "')";
2103 break;
2104 case "content":
2105 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
2106 $rule['reg_exp'] . "')";
2107 break;
2108 case "both":
2109 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2110 $rule['reg_exp'] . "') OR LOWER(" .
2111 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
2112 break;
2113 case "tag":
2114 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
2115 $rule['reg_exp'] . "')";
2116 break;
2117 case "link":
2118 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
2119 $rule['reg_exp'] . "')";
2120 break;
2121 case "author":
2122 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
2123 $rule['reg_exp'] . "')";
2124 break;
2125 }
2126
2127 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
2128
2129 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
2130 $qpart .= " AND feed_id = " . db_escape_string($rule["feed_id"]);
2131 }
2132
2133 if (isset($rule["cat_id"])) {
2134
2135 if ($rule["cat_id"] > 0) {
2136 $children = getChildCategories($rule["cat_id"], $owner_uid);
2137 array_push($children, $rule["cat_id"]);
2138
2139 $children = join(",", $children);
2140
2141 $cat_qpart = "cat_id IN ($children)";
2142 } else {
2143 $cat_qpart = "cat_id IS NULL";
2144 }
2145
2146 $qpart .= " AND $cat_qpart";
2147 }
2148
2149 $qpart .= " AND feed_id IS NOT NULL";
2150
2151 array_push($query, "($qpart)");
2152
2153 }
2154 }
2155
2156 if (count($query) > 0) {
2157 $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
2158 } else {
2159 $fullquery = "(false)";
2160 }
2161
2162 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
2163
2164 return $fullquery;
2165 }
2166
2167 if (!function_exists('gzdecode')) {
2168 function gzdecode($string) { // no support for 2nd argument
2169 return file_get_contents('compress.zlib://data:who/cares;base64,'.
2170 base64_encode($string));
2171 }
2172 }
2173
2174 function get_random_bytes($length) {
2175 if (function_exists('openssl_random_pseudo_bytes')) {
2176 return openssl_random_pseudo_bytes($length);
2177 } else {
2178 $output = "";
2179
2180 for ($i = 0; $i < $length; $i++)
2181 $output .= chr(mt_rand(0, 255));
2182
2183 return $output;
2184 }
2185 }
2186
2187 function read_stdin() {
2188 $fp = fopen("php://stdin", "r");
2189
2190 if ($fp) {
2191 $line = trim(fgets($fp));
2192 fclose($fp);
2193 return $line;
2194 }
2195
2196 return null;
2197 }
2198
2199 function tmpdirname($path, $prefix) {
2200 // Use PHP's tmpfile function to create a temporary
2201 // directory name. Delete the file and keep the name.
2202 $tempname = tempnam($path,$prefix);
2203 if (!$tempname)
2204 return false;
2205
2206 if (!unlink($tempname))
2207 return false;
2208
2209 return $tempname;
2210 }
2211
2212 function getFeedCategory($feed) {
2213 $result = db_query("SELECT cat_id FROM ttrss_feeds
2214 WHERE id = '$feed'");
2215
2216 if (db_num_rows($result) > 0) {
2217 return db_fetch_result($result, 0, "cat_id");
2218 } else {
2219 return false;
2220 }
2221
2222 }
2223
2224 function implements_interface($class, $interface) {
2225 return in_array($interface, class_implements($class));
2226 }
2227
2228 function geturl($url, $depth = 0){
2229
2230 if ($depth == 20) return $url;
2231
2232 if (!function_exists('curl_init'))
2233 return user_error('CURL Must be installed for geturl function to work. Ask your host to enable it or uncomment extension=php_curl.dll in php.ini', E_USER_ERROR);
2234
2235 $curl = curl_init();
2236 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
2237 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
2238 $header[] = "Cache-Control: max-age=0";
2239 $header[] = "Connection: keep-alive";
2240 $header[] = "Keep-Alive: 300";
2241 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
2242 $header[] = "Accept-Language: en-us,en;q=0.5";
2243 $header[] = "Pragma: ";
2244
2245 curl_setopt($curl, CURLOPT_URL, $url);
2246 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
2247 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
2248 curl_setopt($curl, CURLOPT_HEADER, true);
2249 curl_setopt($curl, CURLOPT_REFERER, $url);
2250 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
2251 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
2252 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
2253 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
2254 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
2255 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
2256
2257 if (defined('_CURL_HTTP_PROXY')) {
2258 curl_setopt($curl, CURLOPT_PROXY, _CURL_HTTP_PROXY);
2259 }
2260
2261 if ((OPENSSL_VERSION_NUMBER >= 0x0090808f) && (OPENSSL_VERSION_NUMBER < 0x10000000)) {
2262 curl_setopt($curl, CURLOPT_SSLVERSION, 3);
2263 }
2264
2265 $html = curl_exec($curl);
2266
2267 $status = curl_getinfo($curl);
2268
2269 if($status['http_code']!=200){
2270 if($status['http_code'] == 301 || $status['http_code'] == 302) {
2271 curl_close($curl);
2272 list($header) = explode("\r\n\r\n", $html, 2);
2273 $matches = array();
2274 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
2275 $url = trim(str_replace($matches[1],"",$matches[0]));
2276 $url_parsed = parse_url($url);
2277 return (isset($url_parsed))? geturl($url, $depth + 1):'';
2278 }
2279
2280 global $fetch_last_error;
2281
2282 $fetch_last_error = curl_errno($curl) . " " . curl_error($curl);
2283 curl_close($curl);
2284
2285 # $oline='';
2286 # foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
2287 # $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
2288 # $handle = @fopen('./curl.error.log', 'a');
2289 # fwrite($handle, $line);
2290 return FALSE;
2291 }
2292 curl_close($curl);
2293 return $url;
2294 }
2295
2296 function get_minified_js($files) {
2297 require_once 'lib/jshrink/Minifier.php';
2298
2299 $rv = '';
2300
2301 foreach ($files as $js) {
2302 if (!isset($_GET['debug'])) {
2303 $cached_file = CACHE_DIR . "/js/".basename($js).".js";
2304
2305 if (file_exists($cached_file) &&
2306 is_readable($cached_file) &&
2307 filemtime($cached_file) >= filemtime("js/$js.js")) {
2308
2309 $rv .= file_get_contents($cached_file);
2310
2311 } else {
2312 $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
2313 file_put_contents($cached_file, $minified);
2314 $rv .= $minified;
2315 }
2316 } else {
2317 $rv .= file_get_contents("js/$js.js");
2318 }
2319 }
2320
2321 return $rv;
2322 }
2323
2324 function stylesheet_tag($filename) {
2325 $timestamp = filemtime($filename);
2326
2327 return "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
2328 }
2329
2330 function javascript_tag($filename) {
2331 $query = "";
2332
2333 if (!(strpos($filename, "?") === FALSE)) {
2334 $query = substr($filename, strpos($filename, "?")+1);
2335 $filename = substr($filename, 0, strpos($filename, "?"));
2336 }
2337
2338 $timestamp = filemtime($filename);
2339
2340 if ($query) $timestamp .= "&$query";
2341
2342 return "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
2343 }
2344
2345 function calculate_dep_timestamp() {
2346 $files = array_merge(glob("js/*.js"), glob("css/*.css"));
2347
2348 $max_ts = -1;
2349
2350 foreach ($files as $file) {
2351 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
2352 }
2353
2354 return $max_ts;
2355 }
2356
2357 function T_js_decl($s1, $s2) {
2358 if ($s1 && $s2) {
2359 $s1 = preg_replace("/\n/", "", $s1);
2360 $s2 = preg_replace("/\n/", "", $s2);
2361
2362 $s1 = preg_replace("/\"/", "\\\"", $s1);
2363 $s2 = preg_replace("/\"/", "\\\"", $s2);
2364
2365 return "T_messages[\"$s1\"] = \"$s2\";\n";
2366 }
2367 }
2368
2369 function init_js_translations() {
2370
2371 print 'var T_messages = new Object();
2372
2373 function __(msg) {
2374 if (T_messages[msg]) {
2375 return T_messages[msg];
2376 } else {
2377 return msg;
2378 }
2379 }
2380
2381 function ngettext(msg1, msg2, n) {
2382 return __((parseInt(n) > 1) ? msg2 : msg1);
2383 }';
2384
2385 $l10n = _get_reader();
2386
2387 for ($i = 0; $i < $l10n->total; $i++) {
2388 $orig = $l10n->get_original_string($i);
2389 if(strpos($orig, "\000") !== FALSE) { // Plural forms
2390 $key = explode(chr(0), $orig);
2391 print T_js_decl($key[0], _ngettext($key[0], $key[1], 1)); // Singular
2392 print T_js_decl($key[1], _ngettext($key[0], $key[1], 2)); // Plural
2393 } else {
2394 $translation = __($orig);
2395 print T_js_decl($orig, $translation);
2396 }
2397 }
2398 }
2399
2400 function label_to_feed_id($label) {
2401 return LABEL_BASE_INDEX - 1 - abs($label);
2402 }
2403
2404 function feed_to_label_id($feed) {
2405 return LABEL_BASE_INDEX - 1 + abs($feed);
2406 }
2407
2408 function format_libxml_error($error) {
2409 return T_sprintf("LibXML error %s at line %d (column %d): %s",
2410 $error->code, $error->line, $error->column,
2411 $error->message);
2412 }
2413 ?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/