root/modules/pref-feeds.php

<?php

    function batch_edit_cbox($elem, $label = false) {
        print "<input type=\"checkbox\" title=\"".__("Check to enable field")."\"
            onchange=\"batchFeedsToggleField(this, '$elem', '$label')\">";
    }

    function module_pref_feeds($link) {

        global $update_intervals;
        global $purge_intervals;
        global $update_methods;

        $subop = $_REQUEST["subop"];
        $quiet = $_REQUEST["quiet"];

        if ($subop == "massSubscribe") {
            $ids = split(",", db_escape_string($_GET["ids"]));

            $subscribed = array();

            foreach ($ids as $id) {
                $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
                    WHERE id = '$id'");

                $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
                $title = db_escape_string(db_fetch_result($result, 0, "title"));

                $title_orig = db_fetch_result($result, 0, "title");

                $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
                    feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);

                if (db_num_rows($result) == 0) {            
                    $result = db_query($link,
                        "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id) 
                        VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");

                    array_push($subscribed, $title_orig);
                }
            }

            if (count($subscribed) > 0) {
                $msg = "<b>".__('Subscribed to feeds:')."</b>".
                    "<ul class=\"nomarks\">";

                foreach ($subscribed as $title) {
                    $msg .= "<li>$title</li>";
                }
                $msg .= "</ul>";

                print format_notice($msg);
            }
        }        

        if ($subop == "browse") {

            if (!ENABLE_FEED_BROWSER) {
                print __("Feed browser is administratively disabled.");
                return;
            }

            print "<div id=\"infoBoxTitle\">".__('Other feeds: Top 25')."</div>";
            
            print "<div class=\"infoBoxContents\">";

            print "<p>".__("Showing top 25 registered feeds, sorted by popularity:")."</p>";

            $owner_uid = $_SESSION["uid"];

            $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers
                  FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf 
                    WHERE tf.feed_url = ttrss_feeds.feed_url 
                        AND owner_uid = '$owner_uid') GROUP BY feed_url 
                            ORDER BY subscribers DESC LIMIT 25");

            print "<ul class='browseFeedList' id='browseFeedList'>";

            $feedctr = 0;
            
            while ($line = db_fetch_assoc($result)) {
                $feed_url = $line["feed_url"];
                $subscribers = $line["subscribers"];

                $det_result = db_query($link, "SELECT site_url,title,id 
                    FROM ttrss_feeds WHERE feed_url = '$feed_url' LIMIT 1");

                $details = db_fetch_assoc($det_result);
            
                $icon_file = ICONS_DIR . "/" . $details["id"] . ".ico";

                if (file_exists($icon_file) && filesize($icon_file) > 0) {
                        $feed_icon = "<img class=\"tinyFeedIcon\"    src=\"" . ICONS_URL . 
                            "/".$details["id"].".ico\">";
                } else {
                    $feed_icon = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\">";
                }

                $check_box = "<input onclick='toggleSelectListRow(this)' class='feedBrowseCB' 
                    type=\"checkbox\" id=\"FBCHK-" . $details["id"] . "\">";

                $class = ($feedctr % 2) ? "even" : "odd";

                print "<li class='$class' id=\"FBROW-".$details["id"]."\">$check_box".
                    "$feed_icon " . $details["title"] . 
                    "&nbsp;<span class='subscribers'>($subscribers)</span></li>";

                    ++$feedctr;
            }

            if ($feedctr == 0) {
                print "<li style=\"text-align : center\"><p>".__('No feeds found.')."</p></li>";
                $subscribe_btn_disabled = "disabled";
            } else {
                $subscribe_btn_disabled = "";
            }

            print "</ul>";

            print "<div align='center'>
                <input type=\"submit\" class=\"button\" 
                $subscribe_btn_disabled
                onclick=\"feedBrowserSubscribe()\" value=\"".__('Subscribe')."\">
                <input type='submit' class='button'            
                onclick=\"closeInfoBox()\" value=\"".__('Cancel')."\"></div>";

            print "</div>";
            return;
        }

        if ($subop == "editfeed") {
            $feed_id = db_escape_string($_REQUEST["id"]);

            $result = db_query($link, 
                "SELECT * FROM ttrss_feeds WHERE id = '$feed_id' AND
                    owner_uid = " . $_SESSION["uid"]);

            $title = htmlspecialchars(db_fetch_result($result,
                0, "title"));

            $icon_file = ICONS_DIR . "/$feed_id.ico";
    
            if (file_exists($icon_file) && filesize($icon_file) > 0) {
                    $feed_icon = "<img width=\"16\" height=\"16\"
                        src=\"" . ICONS_URL . "/$feed_id.ico\">";
            } else {
                $feed_icon = "";
            }

            print "<div id=\"infoBoxTitle\">".__('Feed Editor')."</div>";

            print "<div class=\"infoBoxContents\">";

            print "<form id=\"edit_feed_form\" onsubmit=\"return false\">";    

            print "<input type=\"hidden\" name=\"id\" value=\"$feed_id\">";
            print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">";
            print "<input type=\"hidden\" name=\"subop\" value=\"editSave\">";

            print "<div class=\"dlgSec\">".__("Feed")."</div>";
            print "<div class=\"dlgSecCont\">";

            /* Title */

            print "<input style=\"font-size : 16px\" size=\"40\" onkeypress=\"return filterCR(event, feedEditSave)\"
                            name=\"title\" value=\"$title\">";

            /* Feed URL */

            $feed_url = db_fetch_result($result, 0, "feed_url");
            $feed_url = htmlspecialchars(db_fetch_result($result,
                0, "feed_url"));

            print "<br/>";

            print __('URL:') . " ";
            print "<input size=\"40\" onkeypress=\"return filterCR(event, feedEditSave)\"
                name=\"feed_url\" value=\"$feed_url\">";

            /* Category */

            if (get_pref($link, 'ENABLE_FEED_CATS')) {

                $cat_id = db_fetch_result($result, 0, "cat_id");

                print "<br/>";

                print __('Place in category:') . " ";

                $parent_feed = db_fetch_result($result, 0, "parent_feed");

                if (sprintf("%d", $parent_feed) > 0) {
                    $disabled = "disabled";
                } else {
                    $disabled = "";
                }

                print_feed_cat_select($link, "cat_id", $cat_id, $disabled);
            }

            /* Link to */

            print "<br/>";

            print __('Link to feed:') . " ";

            $tmp_result = db_query($link, "SELECT COUNT(id) AS count
                FROM ttrss_feeds WHERE parent_feed = '$feed_id'");

            $linked_count = db_fetch_result($tmp_result, 0, "count");

            $parent_feed = db_fetch_result($result, 0, "parent_feed");

            if ($linked_count > 0) {
                $disabled = "disabled";
            } else {
                $disabled = "";
            }

            print "<select $disabled name=\"parent_feed\">";
            
            print "<option value=\"0\">".__('Not linked')."</option>";

            if (get_pref($link, 'ENABLE_FEED_CATS')) {
                if ($cat_id) {
                    $cat_qpart = "AND cat_id = '$cat_id'";
                } else {
                    $cat_qpart = "AND cat_id IS NULL";
                }
            }

            $tmp_result = db_query($link, "SELECT id,title FROM ttrss_feeds
                WHERE id != '$feed_id' AND owner_uid = ".$_SESSION["uid"]." AND
                      (SELECT COUNT(id) FROM ttrss_feeds AS T2 WHERE T2.id = ttrss_feeds.parent_feed) = 0
                    $cat_qpart ORDER BY title");

                if (db_num_rows($tmp_result) > 0) {
                    print "<option disabled>--------</option>";
                }

                while ($tmp_line = db_fetch_assoc($tmp_result)) {
                    if ($tmp_line["id"] == $parent_feed) {
                        $is_selected = "selected";
                    } else {
                        $is_selected = "";
                    }
                    printf("<option $is_selected value='%d'>%s</option>", 
                        $tmp_line["id"], $tmp_line["title"]);
                }

            print "</select>";


            print "</div>";

            print "<div class=\"dlgSec\">".__("Update")."</div>";
            print "<div class=\"dlgSecCont\">";

            /* Update Interval */

            $update_interval = db_fetch_result($result, 0, "update_interval");

            print_select_hash("update_interval", $update_interval, $update_intervals);

            /* Update method */

            if (ALLOW_SELECT_UPDATE_METHOD) {
                $update_method = db_fetch_result($result, 0, "update_method");

                print " " . __('using') . " ";
                print_select_hash("update_method", $update_method, $update_methods);            
            }

            /* Purge intl */

            print "<br/>";

            $purge_interval = db_fetch_result($result, 0, "purge_interval");

            print __('Article purging:') . " ";

            print_select_hash("purge_interval", $purge_interval, $purge_intervals);

            print "</div>";
            print "<div class=\"dlgSec\">".__("Authentication")."</div>";
            print "<div class=\"dlgSecCont\">";

            $auth_login = htmlspecialchars(db_fetch_result($result, 0, "auth_login"));

            print __('Login:') . " ";
            print "<input size=\"20\" onkeypress=\"return filterCR(event, feedEditSave)\"
                name=\"auth_login\" value=\"$auth_login\">";

            print " " . __("Password:") . " ";

            $auth_pass = htmlspecialchars(db_fetch_result($result, 0, "auth_pass"));

            print "<input size=\"20\" type=\"password\" name=\"auth_pass\" 
                onkeypress=\"return filterCR(event, feedEditSave)\"
                value=\"$auth_pass\">";

            print "</div>";
            print "<div class=\"dlgSec\">".__("Options")."</div>";
            print "<div class=\"dlgSecCont\">";

            print "<div style=\"line-height : 100%\">";

            $private = sql_bool_to_bool(db_fetch_result($result, 0, "private"));

            if ($private) {
                $checked = "checked";
            } else {
                $checked = "";
            }

            print "<input type=\"checkbox\" name=\"private\" id=\"private\" 
                $checked>&nbsp;<label for=\"private\">".__('Hide from "Other Feeds"')."</label>";

            $rtl_content = sql_bool_to_bool(db_fetch_result($result, 0, "rtl_content"));

            if ($rtl_content) {
                $checked = "checked";
            } else {
                $checked = "";
            }

            print "<br/><input type=\"checkbox\" id=\"rtl_content\" name=\"rtl_content\"
                $checked>&nbsp;<label for=\"rtl_content\">".__('Right-to-left content')."</label>";

            $hidden = sql_bool_to_bool(db_fetch_result($result, 0, "hidden"));

            if ($hidden) {
                $checked = "checked";
            } else {
                $checked = "";
            }

            print "<br/><input type=\"checkbox\" id=\"hidden\" name=\"hidden\"
                $checked>&nbsp;<label for=\"hidden\">".__('Hide from my feed list')."</label>";

            $include_in_digest = sql_bool_to_bool(db_fetch_result($result, 0, "include_in_digest"));

            if ($include_in_digest) {
                $checked = "checked";
            } else {
                $checked = "";
            }

            print "<br/><input type=\"checkbox\" id=\"include_in_digest\" 
                name=\"include_in_digest\"
                $checked>&nbsp;<label for=\"include_in_digest\">".__('Include in e-mail digest')."</label>";

            $cache_images = sql_bool_to_bool(db_fetch_result($result, 0, "cache_images"));

            if ($cache_images) {
                $checked = "checked";
            } else {
                $checked = "";
            }

            if (ENABLE_SIMPLEPIE && SIMPLEPIE_CACHE_IMAGES) {
                $disabled = "";
                $label_class = "";
            } else {
                $disabled = "disabled";
                $label_class = "class='insensitive'";
            }

            print "<br/><input type=\"checkbox\" id=\"cache_images\" 
                name=\"cache_images\" $disabled
                $checked>&nbsp;<label $label_class for=\"cache_images\">".
                __('Cache images locally')."</label>";


            print "</div>";
            print "</div>";

            print "</form>";

            $title = htmlspecialchars($title, ENT_QUOTES);

            print "<div class='dlgButtons'>
                <div style=\"float : left\">
                    <input type='submit' class='button'            
                    onclick='return unsubscribeFeed($feed_id, \"$title\")' value=\"".__('Unsubscribe')."\">
                </div>
                <input type=\"submit\" class=\"button\" 
                onclick=\"return feedEditSave()\" value=\"".__('Save')."\">
                <input type='submit' class='button'            
                onclick=\"return feedEditCancel()\" value=\"".__('Cancel')."\">
                </div>";

            return;
        }

        if ($subop == "editfeeds") {

            $feed_ids = db_escape_string($_REQUEST["ids"]);

            print "<div id=\"infoBoxTitle\">".__('Multiple Feed Editor')."</div>";

            print "<div class=\"infoBoxContents\">";

            print "<form id=\"batch_edit_feed_form\" onsubmit=\"return false\">";    

            print "<input type=\"hidden\" name=\"ids\" value=\"$feed_ids\">";
            print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">";
            print "<input type=\"hidden\" name=\"subop\" value=\"batchEditSave\">";

            print "<div class=\"dlgSec\">".__("Feed")."</div>";
            print "<div class=\"dlgSecCont\">";

            /* Title */

            print "<input disabled style=\"font-size : 16px\" size=\"35\" onkeypress=\"return filterCR(event, feedEditSave)\"
                            name=\"title\" value=\"$title\">";

            batch_edit_cbox("title");

            /* Feed URL */

            print "<br/>";

            print __('URL:') . " ";
            print "<input disabled size=\"40\" onkeypress=\"return filterCR(event, feedEditSave)\"
                name=\"feed_url\" value=\"$feed_url\">";

            batch_edit_cbox("feed_url");

            /* Category */

            if (get_pref($link, 'ENABLE_FEED_CATS')) {

                print "<br/>";

                print __('Place in category:') . " ";

                print_feed_cat_select($link, "cat_id", $cat_id, "disabled");

                batch_edit_cbox("cat_id");

            }

            print "</div>";

            print "<div class=\"dlgSec\">".__("Update")."</div>";
            print "<div class=\"dlgSecCont\">";

            /* Update Interval */

            print_select_hash("update_interval", $update_interval, $update_intervals, 
                "disabled");

            batch_edit_cbox("update_interval");

            /* Update method */

            if (ALLOW_SELECT_UPDATE_METHOD) {
                print " " . __('using') . " ";
                print_select_hash("update_method", $update_method, $update_methods, 
                    "disabled");            
                batch_edit_cbox("update_method");
            }

            /* Purge intl */

            print "<br/>";

            print __('Article purging:') . " ";

            print_select_hash("purge_interval", $purge_interval, $purge_intervals,
                "disabled");

            batch_edit_cbox("purge_interval");

            print "</div>";
            print "<div class=\"dlgSec\">".__("Authentication")."</div>";
            print "<div class=\"dlgSecCont\">";

            print __('Login:') . " ";
            print "<input disabled size=\"15\" onkeypress=\"return filterCR(event, feedEditSave)\"
                name=\"auth_login\" value=\"$auth_login\">";

            batch_edit_cbox("auth_login");

            print " " . __("Password:") . " ";

            print "<input disabled size=\"15\" type=\"password\" name=\"auth_pass\" 
                onkeypress=\"return filterCR(event, feedEditSave)\"
                value=\"$auth_pass\">";

            batch_edit_cbox("auth_pass");

            print "</div>";
            print "<div class=\"dlgSec\">".__("Options")."</div>";
            print "<div class=\"dlgSecCont\">";

            print "<div style=\"line-height : 100%\">";

            print "<input disabled type=\"checkbox\" name=\"private\" id=\"private\" 
                $checked>&nbsp;<label id=\"private_l\" class='insensitive' for=\"private\">".__('Hide from "Other Feeds"')."</label>";

            print "&nbsp;"; batch_edit_cbox("private", "private_l");

            print "<br/><input disabled type=\"checkbox\" id=\"rtl_content\" name=\"rtl_content\"
                $checked>&nbsp;<label class='insensitive' id=\"rtl_content_l\" for=\"rtl_content\">".__('Right-to-left content')."</label>";

            print "&nbsp;"; batch_edit_cbox("rtl_content", "rtl_content_l");

            print "<br/><input disabled type=\"checkbox\" id=\"hidden\" name=\"hidden\"
                $checked>&nbsp;<label class='insensitive' id=\"hidden_l\" for=\"hidden\">".__('Hide from my feed list')."</label>";

            print "&nbsp;"; batch_edit_cbox("hidden", "hidden_l");

            print "<br/><input disabled type=\"checkbox\" id=\"include_in_digest\" 
                name=\"include_in_digest\" 
                $checked>&nbsp;<label