query("SELECT cfgname FROM pg_ts_config"); while ($row = $res->fetch()) { array_push($rv, ucfirst($row['cfgname'])); } } return $rv; } function batch_edit_cbox($elem, $label = false) { print ""; } function renamecat() { $title = clean($_REQUEST['title']); $id = clean($_REQUEST['id']); if ($title) { $sth = $this->pdo->prepare("UPDATE ttrss_feed_categories SET title = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$title, $id, $_SESSION['uid']]); } } private function get_category_items($cat_id) { if (clean($_REQUEST['mode']) != 2) $search = $_SESSION["prefs_feed_search"]; else $search = ""; // first one is set by API $show_empty_cats = clean($_REQUEST['force_show_empty']) || (clean($_REQUEST['mode']) != 2 && !$search); $items = array(); $sth = $this->pdo->prepare("SELECT id, title FROM ttrss_feed_categories WHERE owner_uid = ? AND parent_cat = ? ORDER BY order_id, title"); $sth->execute([$_SESSION['uid'], $cat_id]); while ($line = $sth->fetch()) { $cat = array(); $cat['id'] = 'CAT:' . $line['id']; $cat['bare_id'] = (int)$line['id']; $cat['name'] = $line['title']; $cat['items'] = array(); $cat['checkbox'] = false; $cat['type'] = 'category'; $cat['unread'] = -1; $cat['child_unread'] = -1; $cat['auxcounter'] = -1; $cat['parent_id'] = $cat_id; $cat['items'] = $this->get_category_items($line['id']); $num_children = $this->calculate_children_count($cat); $cat['param'] = vsprintf(_ngettext('(%d feed)', '(%d feeds)', (int) $num_children), $num_children); if ($num_children > 0 || $show_empty_cats) array_push($items, $cat); } $fsth = $this->pdo->prepare("SELECT id, title, last_error, ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated, update_interval FROM ttrss_feeds WHERE cat_id = :cat AND owner_uid = :uid AND (:search = '' OR (LOWER(title) LIKE :search OR LOWER(feed_url) LIKE :search)) ORDER BY order_id, title"); $fsth->execute([":cat" => $cat_id, ":uid" => $_SESSION['uid'], ":search" => $search ? "%$search%" : ""]); while ($feed_line = $fsth->fetch()) { $feed = array(); $feed['id'] = 'FEED:' . $feed_line['id']; $feed['bare_id'] = (int)$feed_line['id']; $feed['auxcounter'] = -1; $feed['name'] = $feed_line['title']; $feed['checkbox'] = false; $feed['unread'] = -1; $feed['error'] = $feed_line['last_error']; $feed['icon'] = Feeds::getFeedIcon($feed_line['id']); $feed['param'] = make_local_datetime( $feed_line['last_updated'], true); $feed['updates_disabled'] = (int)($feed_line['update_interval'] < 0); array_push($items, $feed); } return $items; } function getfeedtree() { print json_encode($this->makefeedtree()); } function makefeedtree() { if (clean($_REQUEST['mode']) != 2) $search = $_SESSION["prefs_feed_search"]; else $search = ""; $root = array(); $root['id'] = 'root'; $root['name'] = __('Feeds'); $root['items'] = array(); $root['type'] = 'category'; $enable_cats = get_pref('ENABLE_FEED_CATS'); if (clean($_REQUEST['mode']) == 2) { if ($enable_cats) { $cat = $this->feedlist_init_cat(-1); } else { $cat['items'] = array(); } foreach (array(-4, -3, -1, -2, 0, -6) as $i) { array_push($cat['items'], $this->feedlist_init_feed($i)); } /* Plugin feeds for -1 */ $feeds = PluginHost::getInstance()->get_feeds(-1); if ($feeds) { foreach ($feeds as $feed) { $feed_id = PluginHost::pfeed_to_feed_id($feed['id']); $item = array(); $item['id'] = 'FEED:' . $feed_id; $item['bare_id'] = (int)$feed_id; $item['auxcounter'] = -1; $item['name'] = $feed['title']; $item['checkbox'] = false; $item['error'] = ''; $item['icon'] = $feed['icon']; $item['param'] = ''; $item['unread'] = -1; $item['type'] = 'feed'; array_push($cat['items'], $item); } } if ($enable_cats) { array_push($root['items'], $cat); } else { $root['items'] = array_merge($root['items'], $cat['items']); } $sth = $this->pdo->prepare("SELECT * FROM ttrss_labels2 WHERE owner_uid = ? ORDER by caption"); $sth->execute([$_SESSION['uid']]); if (get_pref('ENABLE_FEED_CATS')) { $cat = $this->feedlist_init_cat(-2); } else { $cat['items'] = array(); } $num_labels = 0; while ($line = $sth->fetch()) { ++$num_labels; $label_id = Labels::label_to_feed_id($line['id']); $feed = $this->feedlist_init_feed($label_id, false, 0); $feed['fg_color'] = $line['fg_color']; $feed['bg_color'] = $line['bg_color']; array_push($cat['items'], $feed); } if ($num_labels) { if ($enable_cats) { array_push($root['items'], $cat); } else { $root['items'] = array_merge($root['items'], $cat['items']); } } } if ($enable_cats) { $show_empty_cats = clean($_REQUEST['force_show_empty']) || (clean($_REQUEST['mode']) != 2 && !$search); $sth = $this->pdo->prepare("SELECT id, title FROM ttrss_feed_categories WHERE owner_uid = ? AND parent_cat IS NULL ORDER BY order_id, title"); $sth->execute([$_SESSION['uid']]); while ($line = $sth->fetch()) { $cat = array(); $cat['id'] = 'CAT:' . $line['id']; $cat['bare_id'] = (int)$line['id']; $cat['auxcounter'] = -1; $cat['name'] = $line['title']; $cat['items'] = array(); $cat['checkbox'] = false; $cat['type'] = 'category'; $cat['unread'] = -1; $cat['child_unread'] = -1; $cat['items'] = $this->get_category_items($line['id']); $num_children = $this->calculate_children_count($cat); $cat['param'] = vsprintf(_ngettext('(%d feed)', '(%d feeds)', (int) $num_children), $num_children); if ($num_children > 0 || $show_empty_cats) array_push($root['items'], $cat); $root['param'] += count($cat['items']); } /* Uncategorized is a special case */ $cat = array(); $cat['id'] = 'CAT:0'; $cat['bare_id'] = 0; $cat['auxcounter'] = -1; $cat['name'] = __("Uncategorized"); $cat['items'] = array(); $cat['type'] = 'category'; $cat['checkbox'] = false; $cat['unread'] = -1; $cat['child_unread'] = -1; $fsth = $this->pdo->prepare("SELECT id, title,last_error, ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated, update_interval FROM ttrss_feeds WHERE cat_id IS NULL AND owner_uid = :uid AND (:search = '' OR (LOWER(title) LIKE :search OR LOWER(feed_url) LIKE :search)) ORDER BY order_id, title"); $fsth->execute([":uid" => $_SESSION['uid'], ":search" => $search ? "%$search%" : ""]); while ($feed_line = $fsth->fetch()) { $feed = array(); $feed['id'] = 'FEED:' . $feed_line['id']; $feed['bare_id'] = (int)$feed_line['id']; $feed['auxcounter'] = -1; $feed['name'] = $feed_line['title']; $feed['checkbox'] = false; $feed['error'] = $feed_line['last_error']; $feed['icon'] = Feeds::getFeedIcon($feed_line['id']); $feed['param'] = make_local_datetime( $feed_line['last_updated'], true); $feed['unread'] = -1; $feed['type'] = 'feed'; $feed['updates_disabled'] = (int)($feed_line['update_interval'] < 0); array_push($cat['items'], $feed); } $cat['param'] = vsprintf(_ngettext('(%d feed)', '(%d feeds)', count($cat['items'])), count($cat['items'])); if (count($cat['items']) > 0 || $show_empty_cats) array_push($root['items'], $cat); $num_children = $this->calculate_children_count($root); $root['param'] = vsprintf(_ngettext('(%d feed)', '(%d feeds)', (int) $num_children), $num_children); } else { $fsth = $this->pdo->prepare("SELECT id, title, last_error, ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated, update_interval FROM ttrss_feeds WHERE owner_uid = :uid AND (:search = '' OR (LOWER(title) LIKE :search OR LOWER(feed_url) LIKE :search)) ORDER BY order_id, title"); $fsth->execute([":uid" => $_SESSION['uid'], ":search" => $search ? "%$search%" : ""]); while ($feed_line = $fsth->fetch()) { $feed = array(); $feed['id'] = 'FEED:' . $feed_line['id']; $feed['bare_id'] = (int)$feed_line['id']; $feed['auxcounter'] = -1; $feed['name'] = $feed_line['title']; $feed['checkbox'] = false; $feed['error'] = $feed_line['last_error']; $feed['icon'] = Feeds::getFeedIcon($feed_line['id']); $feed['param'] = make_local_datetime( $feed_line['last_updated'], true); $feed['unread'] = -1; $feed['type'] = 'feed'; $feed['updates_disabled'] = (int)($feed_line['update_interval'] < 0); array_push($root['items'], $feed); } $root['param'] = vsprintf(_ngettext('(%d feed)', '(%d feeds)', count($root['items'])), count($root['items'])); } $fl = array(); $fl['identifier'] = 'id'; $fl['label'] = 'name'; if (clean($_REQUEST['mode']) != 2) { $fl['items'] = array($root); } else { $fl['items'] = $root['items']; } return $fl; } function catsortreset() { $sth = $this->pdo->prepare("UPDATE ttrss_feed_categories SET order_id = 0 WHERE owner_uid = ?"); $sth->execute([$_SESSION['uid']]); } function feedsortreset() { $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET order_id = 0 WHERE owner_uid = ?"); $sth->execute([$_SESSION['uid']]); } private function process_category_order(&$data_map, $item_id, $parent_id = false, $nest_level = 0) { $prefix = ""; for ($i = 0; $i < $nest_level; $i++) $prefix .= " "; Debug::log("$prefix C: $item_id P: $parent_id"); $bare_item_id = substr($item_id, strpos($item_id, ':')+1); if ($item_id != 'root') { if ($parent_id && $parent_id != 'root') { $parent_bare_id = substr($parent_id, strpos($parent_id, ':')+1); $parent_qpart = $parent_bare_id; } else { $parent_qpart = null; } $sth = $this->pdo->prepare("UPDATE ttrss_feed_categories SET parent_cat = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$parent_qpart, $bare_item_id, $_SESSION['uid']]); } $order_id = 1; $cat = $data_map[$item_id]; if ($cat && is_array($cat)) { foreach ($cat as $item) { $id = $item['_reference']; $bare_id = substr($id, strpos($id, ':')+1); Debug::log("$prefix [$order_id] $id/$bare_id"); if ($item['_reference']) { if (strpos($id, "FEED") === 0) { $cat_id = ($item_id != "root") ? $bare_item_id : null; $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET order_id = ?, cat_id = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$order_id, $cat_id ? $cat_id : null, $bare_id, $_SESSION['uid']]); } else if (strpos($id, "CAT:") === 0) { $this->process_category_order($data_map, $item['_reference'], $item_id, $nest_level+1); $sth = $this->pdo->prepare("UPDATE ttrss_feed_categories SET order_id = ? WHERE id = ? AND owner_uid = ?"); $sth->execute([$order_id, $bare_id, $_SESSION['uid']]); } } ++$order_id; } } } function savefeedorder() { $data = json_decode($_POST['payload'], true); #file_put_contents("/tmp/saveorder.json", clean($_POST['payload'])); #$data = json_decode(file_get_contents("/tmp/saveorder.json"), true); if (!is_array($data['items'])) $data['items'] = json_decode($data['items'], true); # print_r($data['items']); if (is_array($data) && is_array($data['items'])) { # $cat_order_id = 0; $data_map = array(); $root_item = false; foreach ($data['items'] as $item) { # if ($item['id'] != 'root') { if (is_array($item['items'])) { if (isset($item['items']['_reference'])) { $data_map[$item['id']] = array($item['items']); } else { $data_map[$item['id']] = $item['items']; } } if ($item['id'] == 'root') { $root_item = $item['id']; } } $this->process_category_order($data_map, $root_item); } } function removeicon() { $feed_id = clean($_REQUEST["feed_id"]); $sth = $this->pdo->prepare("SELECT id FROM ttrss_feeds WHERE id = ? AND owner_uid = ?"); $sth->execute([$feed_id, $_SESSION['uid']]); if ($row = $sth->fetch()) { @unlink(ICONS_DIR . "/$feed_id.ico"); $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET favicon_avg_color = NULL where id = ?"); $sth->execute([$feed_id]); } } function uploadicon() { header("Content-type: text/html"); if (is_uploaded_file($_FILES['icon_file']['tmp_name'])) { $tmp_file = tempnam(CACHE_DIR . '/upload', 'icon'); $result = move_uploaded_file($_FILES['icon_file']['tmp_name'], $tmp_file); if (!$result) { return; } } else { return; } $icon_file = $tmp_file; $feed_id = clean($_REQUEST["feed_id"]); $rc = 2; // failed if (is_file($icon_file) && $feed_id) { if (filesize($icon_file) < 65535) { $sth = $this->pdo->prepare("SELECT id FROM ttrss_feeds WHERE id = ? AND owner_uid = ?"); $sth->execute([$feed_id, $_SESSION['uid']]); if ($row = $sth->fetch()) { @unlink(ICONS_DIR . "/$feed_id.ico"); if (rename($icon_file, ICONS_DIR . "/$feed_id.ico")) { $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET favicon_avg_color = '' WHERE id = ?"); $sth->execute([$feed_id]); $rc = 0; } } } else { $rc = 1; } } if (is_file($icon_file)) @unlink($icon_file); print $rc; return; } function editfeed() { global $purge_intervals; global $update_intervals; $feed_id = clean($_REQUEST["id"]); $sth = $this->pdo->prepare("SELECT * FROM ttrss_feeds WHERE id = ? AND owner_uid = ?"); $sth->execute([$feed_id, $_SESSION['uid']]); if ($row = $sth->fetch()) { print '
'; $title = htmlspecialchars($row["title"]); print_hidden("id", "$feed_id"); print_hidden("op", "pref-feeds"); print_hidden("method", "editSave"); print "
".__("Feed")."
"; print "
"; /* Title */ print "
"; print ""; print "
"; /* Feed URL */ $feed_url = htmlspecialchars($row["feed_url"]); print "
"; print " "; print ""; $last_error = $row["last_error"]; if ($last_error) { print " error"; } print "
"; /* Category */ if (get_pref('ENABLE_FEED_CATS')) { $cat_id = $row["cat_id"]; print "
"; print " "; print_feed_cat_select("cat_id", $cat_id, 'dojoType="fox.form.Select"'); print "
"; } /* Site URL */ $site_url = htmlspecialchars($row["site_url"]); print "
"; print " "; print ""; print "
"; /* FTS Stemming Language */ if (DB_TYPE == "pgsql") { $feed_language = $row["feed_language"]; if (!$feed_language) $feed_language = get_pref('DEFAULT_SEARCH_LANGUAGE'); print "
"; print " "; print_select("feed_language", $feed_language, $this::get_ts_languages(), 'dojoType="fox.form.Select"'); print "
"; } print "
"; print "
".__("Update")."
"; print "
"; /* Update Interval */ $update_interval = $row["update_interval"]; print "
"; print " "; print_select_hash("update_interval", $update_interval, $update_intervals, 'dojoType="fox.form.Select"'); print "
"; /* Purge intl */ $purge_interval = $row["purge_interval"]; print "
"; print " "; print_select_hash("purge_interval", $purge_interval, $purge_intervals, 'dojoType="fox.form.Select" ' . ((FORCE_ARTICLE_PURGE == 0) ? "" : 'disabled="1"')); print "
"; print "
"; $auth_login = htmlspecialchars($row["auth_login"]); $auth_pass = htmlspecialchars($row["auth_pass"]); $auth_enabled = $auth_login !== '' || $auth_pass !== ''; $auth_style = $auth_enabled ? '' : 'display: none'; print "
"; print "
".__("Authentication")."
"; print "
"; print "
"; print ""; print "
"; print ""; print "
".__('Hint: you need to fill in your login information if your feed requires authentication, except for Twitter feeds.')."
"; print "
"; print "
"; $auth_checked = $auth_enabled ? 'checked' : ''; print ""; print '
'; print "
"; $include_in_digest = $row["include_in_digest"]; if ($include_in_digest) { $checked = "checked=\"1\""; } else { $checked = ""; } print "
"; print ""; print "
"; $always_display_enclosures = $row["always_display_enclosures"]; if ($always_display_enclosures) { $checked = "checked"; } else { $checked = ""; } print "
"; print ""; print "
"; $hide_images = $row["hide_images"]; if ($hide_images) { $checked = "checked=\"1\""; } else { $checked = ""; } print "
"; print ""; print "
"; $cache_images = $row["cache_images"]; if ($cache_images) { $checked = "checked=\"1\""; } else { $checked = ""; } print "
"; print ""; print "
"; $mark_unread_on_update = $row["mark_unread_on_update"]; if ($mark_unread_on_update) { $checked = "checked"; } else { $checked = ""; } print "
"; print ""; print "
"; print '
'; /* Icon */ print ""; print "
"; print ""; print '
'; PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_EDIT_FEED, "hook_prefs_edit_feed", $feed_id); print "
"; $title = htmlspecialchars($title, ENT_QUOTES); print ""; } } function editfeeds() { global $purge_intervals; global $update_intervals; $feed_ids = clean($_REQUEST["ids"]); print_notice("Enable the options you wish to apply using checkboxes on the right:"); print "

"; print_hidden("ids", "$feed_ids"); print_hidden("op", "pref-feeds"); print_hidden("method", "batchEditSave"); print "

".__("Feed")."
"; print "
"; /* Category */ if (get_pref('ENABLE_FEED_CATS')) { print "
"; print " "; print_feed_cat_select("cat_id", false, 'disabled="1" dojoType="fox.form.Select"'); $this->batch_edit_cbox("cat_id"); print "
"; } /* FTS Stemming Language */ if (DB_TYPE == "pgsql") { print "
"; print " "; print_select("feed_language", "", $this::get_ts_languages(), 'disabled="1" dojoType="fox.form.Select"'); $this->batch_edit_cbox("feed_language"); print "
"; } print "
"; print "
".__("Update")."
"; print "
"; /* Update Interval */ print "
"; print " "; print_select_hash("update_interval", "", $update_intervals, 'disabled="1" dojoType="fox.form.Select"'); $this->batch_edit_cbox("update_interval"); print "
"; /* Purge intl */ if (FORCE_ARTICLE_PURGE == 0) { print "
"; print " "; print_select_hash("purge_interval", "", $purge_intervals, 'disabled="1" dojoType="fox.form.Select"'); $this->batch_edit_cbox("purge_interval"); print "
"; } print "
"; print "
".__("Authentication")."
"; print "
"; print "
"; print ""; $this->batch_edit_cbox("auth_login"); print ""; $this->batch_edit_cbox("auth_pass"); print "
"; print "
"; print "
".__("Options")."
"; print "
"; print "
"; print ""; print " "; $this->batch_edit_cbox("include_in_digest", "include_in_digest_l"); print "
"; print ""; print " "; $this->batch_edit_cbox("always_display_enclosures", "always_display_enclosures_l"); print "
"; print ""; print " "; $this->batch_edit_cbox("hide_images", "hide_images_l"); print "
"; print ""; print " "; $this->batch_edit_cbox("cache_images", "cache_images_l"); print "
"; print ""; print " "; $this->batch_edit_cbox("mark_unread_on_update", "mark_unread_on_update_l"); print "
"; print "
"; print ""; return; } function batchEditSave() { return $this->editsaveops(true); } function editSave() { return $this->editsaveops(false); } function editsaveops($batch) { $feed_title = trim(clean($_POST["title"])); $feed_url = trim(clean($_POST["feed_url"])); $site_url = trim(clean($_POST["site_url"])); $upd_intl = (int) clean($_POST["update_interval"]); $purge_intl = (int) clean($_POST["purge_interval"]); $feed_id = (int) clean($_POST["id"]); /* editSave */ $feed_ids = explode(",", clean($_POST["ids"])); /* batchEditSave */ $cat_id = (int) clean($_POST["cat_id"]); $auth_login = trim(clean($_POST["auth_login"])); $auth_pass = trim(clean($_POST["auth_pass"])); $private = checkbox_to_sql_bool(clean($_POST["private"])); $include_in_digest = checkbox_to_sql_bool( clean($_POST["include_in_digest"])); $cache_images = checkbox_to_sql_bool( clean($_POST["cache_images"])); $hide_images = checkbox_to_sql_bool( clean($_POST["hide_images"])); $always_display_enclosures = checkbox_to_sql_bool( clean($_POST["always_display_enclosures"])); $mark_unread_on_update = checkbox_to_sql_bool( clean($_POST["mark_unread_on_update"])); $feed_language = trim(clean($_POST["feed_language"])); if (!$batch) { if (clean($_POST["need_auth"]) !== 'on') { $auth_login = ''; $auth_pass = ''; } /* $sth = $this->pdo->prepare("SELECT feed_url FROM ttrss_feeds WHERE id = ?"); $sth->execute([$feed_id]); $row = $sth->fetch();$orig_feed_url = $row["feed_url"]; $reset_basic_info = $orig_feed_url != $feed_url; */ $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET cat_id = :cat_id, title = :title, feed_url = :feed_url, site_url = :site_url, update_interval = :upd_intl, purge_interval = :purge_intl, auth_login = :auth_login, auth_pass = :auth_pass, auth_pass_encrypted = false, private = :private, cache_images = :cache_images, hide_images = :hide_images, include_in_digest = :include_in_digest, always_display_enclosures = :always_display_enclosures, mark_unread_on_update = :mark_unread_on_update, feed_language = :feed_language WHERE id = :id AND owner_uid = :uid"); $sth->execute([":title" => $feed_title, ":cat_id" => $cat_id ? $cat_id : null, ":feed_url" => $feed_url, ":site_url" => $site_url, ":upd_intl" => $upd_intl, ":purge_intl" => $purge_intl, ":auth_login" => $auth_login, ":auth_pass" => $auth_pass, ":private" => (int)$private, ":cache_images" => (int)$cache_images, ":hide_images" => (int)$hide_images, ":include_in_digest" => (int)$include_in_digest, ":always_display_enclosures" => (int)$always_display_enclosures, ":mark_unread_on_update" => (int)$mark_unread_on_update, ":feed_language" => $feed_language, ":id" => $feed_id, ":uid" => $_SESSION['uid']]); /* if ($reset_basic_info) { RSSUtils::set_basic_feed_info($feed_id); } */ PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_SAVE_FEED, "hook_prefs_save_feed", $feed_id); } else { $feed_data = array(); foreach (array_keys($_POST) as $k) { if ($k != "op" && $k != "method" && $k != "ids") { $feed_data[$k] = clean($_POST[$k]); } } $this->pdo->beginTransaction(); $feed_ids_qmarks = arr_qmarks($feed_ids); foreach (array_keys($feed_data) as $k) { $qpart = ""; switch ($k) { case "title": $qpart = "title = " . $this->pdo->quote($feed_title); break; case "feed_url": $qpart = "feed_url = " . $this->pdo->quote($feed_url); break; case "update_interval": $qpart = "update_interval = " . $this->pdo->quote($upd_intl); break; case "purge_interval": $qpart = "purge_interval =" . $this->pdo->quote($purge_intl); break; case "auth_login": $qpart = "auth_login = " . $this->pdo->quote($auth_login); break; case "auth_pass": $qpart = "auth_pass =" . $this->pdo->quote($auth_pass). ", auth_pass_encrypted = false"; break; case "private": $qpart = "private = " . $this->pdo->quote($private); break; case "include_in_digest": $qpart = "include_in_digest = " . $this->pdo->quote($include_in_digest); break; case "always_display_enclosures": $qpart = "always_display_enclosures = " . $this->pdo->quote($always_display_enclosures); break; case "mark_unread_on_update": $qpart = "mark_unread_on_update = " . $this->pdo->quote($mark_unread_on_update); break; case "cache_images": $qpart = "cache_images = " . $this->pdo->quote($cache_images); break; case "hide_images": $qpart = "hide_images = " . $this->pdo->quote($hide_images); break; case "cat_id": if (get_pref('ENABLE_FEED_CATS')) { if ($cat_id) { $qpart = "cat_id = " . $this->pdo->quote($cat_id); } else { $qpart = 'cat_id = NULL'; } } else { $qpart = ""; } break; case "feed_language": $qpart = "feed_language = " . $this->pdo->quote($feed_language); break; } if ($qpart) { $sth = $this->pdo->prepare("UPDATE ttrss_feeds SET $qpart WHERE id IN ($feed_ids_qmarks) AND owner_uid = ?"); $sth->execute(array_merge($feed_ids, [$_SESSION['uid']])); } } $this->pdo->commit(); } return; } function remove() { $ids = explode(",", clean($_REQUEST["ids"])); foreach ($ids as $id) { Pref_Feeds::remove_feed($id, $_SESSION["uid"]); } return; } function removeCat() { $ids = explode(",", clean($_REQUEST["ids"])); foreach ($ids as $id) { $this->remove_feed_category($id, $_SESSION["uid"]); } } function addCat() { $feed_cat = trim(clean($_REQUEST["cat"])); Feeds::add_feed_category($feed_cat); } function index() { print "
"; print "
rss_feed ".__('Feeds')."\">"; $sth = $this->pdo->prepare("SELECT COUNT(id) AS num_errors FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ?"); $sth->execute([$_SESSION['uid']]); if ($row = $sth->fetch()) { $num_errors = $row["num_errors"]; } else { $num_errors = 0; } if ($num_errors > 0) { $error_button = ""; } $inactive_button = ""; $feed_search = clean($_REQUEST["search"]); if (array_key_exists("search", $_REQUEST)) { $_SESSION["prefs_feed_search"] = $feed_search; } else { $feed_search = $_SESSION["prefs_feed_search"]; } print '
'; print "
"; #toolbar print "
"; print "
". "" . __('Select').""; print "
"; print "
".__('All')."
"; print "
".__('None')."
"; print "
"; print "
". "" . __('Feeds').""; print "
"; print "
".__('Subscribe to feed')."
"; print "
".__('Edit selected feeds')."
"; print "
".__('Reset sort order')."
"; print "
".__('Batch subscribe')."
"; print "
" .__('Unsubscribe')."
"; print "
"; if (get_pref('ENABLE_FEED_CATS')) { print "
". "" . __('Categories').""; print "
"; print "
".__('Add category')."
"; print "
".__('Reset sort order')."
"; print "
".__('Remove selected')."
"; print "
"; } print $error_button; print $inactive_button; print "
"; # toolbar //print '
'; print '
'; print "
". __("Loading, please wait...")."
"; $auto_expand = $feed_search != "" ? "true" : "false"; print "
"; # print "
# ".__('Hint: you can drag feeds and categories around.')." #
"; print '
'; print '
'; print "
"; # feeds pane print "
"; print "

" . __("Using OPML you can export and import your feeds, filters, labels and Tiny Tiny RSS settings.") . "

"; print_notice("Only main settings profile can be migrated using OPML."); print ""; print "
"; print "
"; print "
"; print ""; print " "; print "
"; print "

"; print "

" . __("Published OPML") . "

"; print "

" . __('Your OPML can be published publicly and can be subscribed by anyone who knows the URL below.') . " " . __("Published OPML does not include your Tiny Tiny RSS settings, feeds that require authentication or feeds hidden from Popular feeds.") . "

"; print " "; PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_TAB_SECTION, "hook_prefs_tab_section", "prefFeedsOPML"); print "
"; # pane print "
share ".__('Published & shared articles / Generated feeds')."\">"; print "

" . __('Published articles can be subscribed by anyone who knows the following URL:') . "

"; $rss_url = '-2::' . htmlspecialchars(get_self_url_prefix() . "/public.php?op=rss&id=-2&view-mode=all_articles");; print " "; print " "; PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_TAB_SECTION, "hook_prefs_tab_section", "prefFeedsPublishedGenerated"); print "
"; #pane PluginHost::getInstance()->run_hooks(PluginHost::HOOK_PREFS_TAB, "hook_prefs_tab", "prefFeeds"); print ""; #container } private function feedlist_init_cat($cat_id) { $obj = array(); $cat_id = (int) $cat_id; $obj['id'] = 'CAT:' . $cat_id; $obj['items'] = array(); $obj['name'] = Feeds::getCategoryTitle($cat_id); $obj['type'] = 'category'; $obj['unread'] = (int) Feeds::getCategoryUnread($cat_id); $obj['bare_id'] = $cat_id; return $obj; } private function feedlist_init_feed($feed_id, $title = false, $unread = false, $error = '', $updated = '') { $obj = array(); $feed_id = (int) $feed_id; if (!$title) $title = Feeds::getFeedTitle($feed_id, false); if ($unread === false) $unread = getFeedUnread($feed_id, false); $obj['id'] = 'FEED:' . $feed_id; $obj['name'] = $title; $obj['unread'] = (int) $unread; $obj['type'] = 'feed'; $obj['error'] = $error; $obj['updated'] = $updated; $obj['icon'] = Feeds::getFeedIcon($feed_id); $obj['bare_id'] = $feed_id; $obj['auxcounter'] = 0; return $obj; } function inactiveFeeds() { if (DB_TYPE == "pgsql") { $interval_qpart = "NOW() - INTERVAL '3 months'"; } else { $interval_qpart = "DATE_SUB(NOW(), INTERVAL 3 MONTH)"; } $sth = $this->pdo->prepare("SELECT ttrss_feeds.title, ttrss_feeds.site_url, ttrss_feeds.feed_url, ttrss_feeds.id, MAX(updated) AS last_article FROM ttrss_feeds, ttrss_entries, ttrss_user_entries WHERE (SELECT MAX(updated) FROM ttrss_entries, ttrss_user_entries WHERE ttrss_entries.id = ref_id AND ttrss_user_entries.feed_id = ttrss_feeds.id) < $interval_qpart AND ttrss_feeds.owner_uid = ? AND ttrss_user_entries.feed_id = ttrss_feeds.id AND ttrss_entries.id = ref_id GROUP BY ttrss_feeds.title, ttrss_feeds.id, ttrss_feeds.site_url, ttrss_feeds.feed_url ORDER BY last_article"); $sth->execute([$_SESSION['uid']]); print "
"; print "
". "" . __('Select').""; print "
"; print "
".__('All')."
"; print "
".__('None')."
"; print "
"; print "
"; #toolbar print "
"; print ""; $lnum = 1; while ($line = $sth->fetch()) { $feed_id = $line["id"]; print ""; print ""; print ""; print ""; ++$lnum; } print "
"; print "". htmlspecialchars($line["title"]).""; print ""; print make_local_datetime($line['last_article'], false); print "
"; print "
"; print ""; } function feedsWithErrors() { $sth = $this->pdo->prepare("SELECT id,title,feed_url,last_error,site_url FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ?"); $sth->execute([$_SESSION['uid']]); print "
"; print "
". "" . __('Select').""; print "
"; print "
".__('All')."
"; print "
".__('None')."
"; print "
"; print "
"; #toolbar print "
"; print ""; $lnum = 1; while ($line = $sth->fetch()) { $feed_id = $line["id"]; print ""; print ""; print ""; print ""; ++$lnum; } print "
"; print "". htmlspecialchars($line["title"]).": "; print ""; print htmlspecialchars($line["last_error"]); print ""; print "
"; print "
"; print ""; } private function remove_feed_category($id, $owner_uid) { $sth = $this->pdo->prepare("DELETE FROM ttrss_feed_categories WHERE id = ? AND owner_uid = ?"); $sth->execute([$id, $owner_uid]); } static function remove_feed($id, $owner_uid) { foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_UNSUBSCRIBE_FEED) as $p) { if (! $p->hook_unsubscribe_feed($id, $owner_uid)) { user_error("Feed $id (owner: $owner_uid) not removed due to plugin error (HOOK_UNSUBSCRIBE_FEED).", E_USER_WARNING); return; } } $pdo = Db::pdo(); if ($id > 0) { $pdo->beginTransaction(); /* save starred articles in Archived feed */ /* prepare feed if necessary */ $sth = $pdo->prepare("SELECT feed_url FROM ttrss_feeds WHERE id = ? AND owner_uid = ?"); $sth->execute([$id, $owner_uid]); if ($row = $sth->fetch()) { $feed_url = $row["feed_url"]; $sth = $pdo->prepare("SELECT id FROM ttrss_archived_feeds WHERE feed_url = ? AND owner_uid = ?"); $sth->execute([$feed_url, $owner_uid]); if ($row = $sth->fetch()) { $archive_id = $row["id"]; } else { $res = $pdo->query("SELECT MAX(id) AS id FROM ttrss_archived_feeds"); $row = $res->fetch(); $new_feed_id = (int)$row['id'] + 1; $sth = $pdo->prepare("INSERT INTO ttrss_archived_feeds (id, owner_uid, title, feed_url, site_url, created) SELECT ?, owner_uid, title, feed_url, site_url, NOW() from ttrss_feeds WHERE id = ?"); $sth->execute([$new_feed_id, $id]); $archive_id = $new_feed_id; } $sth = $pdo->prepare("UPDATE ttrss_user_entries SET feed_id = NULL, orig_feed_id = ? WHERE feed_id = ? AND marked = true AND owner_uid = ?"); $sth->execute([$archive_id, $id, $owner_uid]); /* Remove access key for the feed */ $sth = $pdo->prepare("DELETE FROM ttrss_access_keys WHERE feed_id = ? AND owner_uid = ?"); $sth->execute([$id, $owner_uid]); /* remove the feed */ $sth = $pdo->prepare("DELETE FROM ttrss_feeds WHERE id = ? AND owner_uid = ?"); $sth->execute([$id, $owner_uid]); } $pdo->commit(); if (file_exists(ICONS_DIR . "/$id.ico")) { unlink(ICONS_DIR . "/$id.ico"); } } else { Labels::remove(Labels::feed_to_label_id($id), $owner_uid); } } function batchSubscribe() { print_hidden("op", "pref-feeds"); print_hidden("method", "batchaddfeeds"); print "
".__("One valid feed per line (no detection is done)")."
"; print "
"; print ""; if (get_pref('ENABLE_FEED_CATS')) { print "
"; print " "; print_feed_cat_select("cat", false, 'dojoType="fox.form.Select"'); print "
"; } print "
"; print ""; print ""; print ""; print "
"; print "
"; print ""; } function batchAddFeeds() { $cat_id = clean($_REQUEST['cat']); $feeds = explode("\n", clean($_REQUEST['feeds'])); $login = clean($_REQUEST['login']); $pass = trim(clean($_REQUEST['pass'])); $csth = $this->pdo->prepare("SELECT id FROM ttrss_feeds WHERE feed_url = ? AND owner_uid = ?"); $isth = $this->pdo->prepare("INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id,auth_login,auth_pass,update_method,auth_pass_encrypted) VALUES (?, ?, '[Unknown]', ?, ?, ?, 0, false)"); foreach ($feeds as $feed) { $feed = trim($feed); if (Feeds::validate_feed_url($feed)) { $this->pdo->beginTransaction(); $csth->execute([$feed, $_SESSION['uid']]); if (!$csth->fetch()) { $isth->execute([$_SESSION['uid'], $feed, $cat_id ? $cat_id : null, $login, $pass]); } $this->pdo->commit(); } } } function regenOPMLKey() { $this->update_feed_access_key('OPML:Publish', false, $_SESSION["uid"]); $new_link = Opml::opml_publish_url(); print json_encode(array("link" => $new_link)); } function regenFeedKey() { $feed_id = clean($_REQUEST['id']); $is_cat = clean($_REQUEST['is_cat']); $new_key = $this->update_feed_access_key($feed_id, $is_cat); print json_encode(["link" => $new_key]); } private function update_feed_access_key($feed_id, $is_cat, $owner_uid = false) { if (!$owner_uid) $owner_uid = $_SESSION["uid"]; // clear old value and generate new one $sth = $this->pdo->prepare("DELETE FROM ttrss_access_keys WHERE feed_id = ? AND is_cat = ? AND owner_uid = ?"); $sth->execute([$feed_id, bool_to_sql_bool($is_cat), $owner_uid]); return Feeds::get_feed_access_key($feed_id, $is_cat, $owner_uid); } // Silent function clearKeys() { $sth = $this->pdo->prepare("DELETE FROM ttrss_access_keys WHERE owner_uid = ?"); $sth->execute([$_SESSION['uid']]); } private function calculate_children_count($cat) { $c = 0; foreach ($cat['items'] as $child) { if ($child['type'] == 'category') { $c += $this->calculate_children_count($child); } else { $c += 1; } } return $c; } function getinactivefeeds() { if (DB_TYPE == "pgsql") { $interval_qpart = "NOW() - INTERVAL '3 months'"; } else { $interval_qpart = "DATE_SUB(NOW(), INTERVAL 3 MONTH)"; } $sth = $this->pdo->prepare("SELECT COUNT(id) AS num_inactive FROM ttrss_feeds WHERE (SELECT MAX(updated) FROM ttrss_entries, ttrss_user_entries WHERE ttrss_entries.id = ref_id AND ttrss_user_entries.feed_id = ttrss_feeds.id) < $interval_qpart AND ttrss_feeds.owner_uid = ?"); $sth->execute([$_SESSION['uid']]); if ($row = $sth->fetch()) { print (int)$row["num_inactive"]; } } static function subscribe_to_feed_url() { $url_path = get_self_url_prefix() . "/public.php?op=subscribe&feed_url=%s"; return $url_path; } }