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);
}
}
