function removeCategory() { $category_id = (int) db_escape_string($_REQUEST["category_id"]); if ($category_id != "") { $this->dbh->query("DELETE FROM ttrss_feed_categories WHERE id = '{$category_id}' AND owner_uid = " . $_SESSION["uid"]); ccache_remove($category_id, $_SESSION["uid"], true); return array(API::STATUS_OK); } else { return array(API::STATUS_ERR, array("error" => 'INCORRECT_USAGE')); } }
static function remove_feed($id, $owner_uid) { if ($id > 0) { /* save starred articles in Archived feed */ db_query("BEGIN"); /* prepare feed if necessary */ $result = db_query("SELECT feed_url FROM ttrss_feeds WHERE id = {$id}\n\t\t\t\tAND owner_uid = {$owner_uid}"); $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url")); $result = db_query("SELECT id FROM ttrss_archived_feeds\n\t\t\t\tWHERE feed_url = '{$feed_url}' AND owner_uid = {$owner_uid}"); if (db_num_rows($result) == 0) { $result = db_query("SELECT MAX(id) AS id FROM ttrss_archived_feeds"); $new_feed_id = (int) db_fetch_result($result, 0, "id") + 1; db_query("INSERT INTO ttrss_archived_feeds\n\t\t\t\t\t(id, owner_uid, title, feed_url, site_url)\n\t\t\t\tSELECT {$new_feed_id}, owner_uid, title, feed_url, site_url from ttrss_feeds\n\t\t\t\tWHERE id = '{$id}'"); $archive_id = $new_feed_id; } else { $archive_id = db_fetch_result($result, 0, "id"); } db_query("UPDATE ttrss_user_entries SET feed_id = NULL,\n\t\t\t\torig_feed_id = '{$archive_id}' WHERE feed_id = '{$id}' AND\n\t\t\t\t\tmarked = true AND owner_uid = {$owner_uid}"); /* Remove access key for the feed */ db_query("DELETE FROM ttrss_access_keys WHERE\n\t\t\t\tfeed_id = '{$id}' AND owner_uid = {$owner_uid}"); /* remove the feed */ db_query("DELETE FROM ttrss_feeds\n\t\t\t\t\tWHERE id = '{$id}' AND owner_uid = {$owner_uid}"); db_query("COMMIT"); if (file_exists(ICONS_DIR . "/{$id}.ico")) { unlink(ICONS_DIR . "/{$id}.ico"); } ccache_remove($id, $owner_uid); } else { label_remove(feed_to_label_id($id), $owner_uid); //ccache_remove($id, $owner_uid); don't think labels are cached } }
function remove_feed_category($link, $id, $owner_uid) { db_query($link, "DELETE FROM ttrss_feed_categories\n\t\t\tWHERE id = '{$id}' AND owner_uid = {$owner_uid}"); ccache_remove($link, $id, $owner_uid, true); }
private function remove_feed($link, $id, $owner_uid) { if ($id > 0) { /* save starred articles in Archived feed */ db_query($link, "BEGIN"); /* prepare feed if necessary */ $result = db_query($link, "SELECT id FROM ttrss_archived_feeds\n\t\t\t\tWHERE id = '{$id}'"); if (db_num_rows($result) == 0) { db_query($link, "INSERT INTO ttrss_archived_feeds\n\t\t\t\t\t(id, owner_uid, title, feed_url, site_url)\n\t\t\t\tSELECT id, owner_uid, title, feed_url, site_url from ttrss_feeds\n\t\t\t \tWHERE id = '{$id}'"); } db_query($link, "UPDATE ttrss_user_entries SET feed_id = NULL,\n\t\t\t\torig_feed_id = '{$id}' WHERE feed_id = '{$id}' AND\n\t\t\t\t\tmarked = true AND owner_uid = {$owner_uid}"); /* Remove access key for the feed */ db_query($link, "DELETE FROM ttrss_access_keys WHERE\n\t\t\t\tfeed_id = '{$id}' AND owner_uid = {$owner_uid}"); /* remove the feed */ db_query($link, "DELETE FROM ttrss_feeds\n\t\t\t\t\tWHERE id = '{$id}' AND owner_uid = {$owner_uid}"); db_query($link, "COMMIT"); if (file_exists(ICONS_DIR . "/{$id}.ico")) { unlink(ICONS_DIR . "/{$id}.ico"); } ccache_remove($link, $id, $owner_uid); } else { label_remove($link, -11 - $id, $owner_uid); ccache_remove($link, -11 - $id, $owner_uid); } }