PHP Releases::delete方法代碼示例

 /**
  * Perform cleanup of all items in arrays.
  */
 private function doClean()
 {
     $this->numnuked += count($this->cleanup['nuke']);
     $this->nummiscd += count($this->cleanup['misc']);
     if (!$this->echoonly) {
         $releases = new \Releases(['Settings' => $this->pdo]);
         foreach (array_keys($this->cleanup['nuke']) as $id) {
             $releases->delete($id);
         }
         if (count($this->cleanup['misc'])) {
             $sql = 'update releases set categoryid = ' . Category::CAT_MISC_OTHER . ' where categoryid != ' . Category::CAT_MISC_OTHER . ' and id in (' . implode(array_keys($this->cleanup['misc']), ',') . ')';
             $this->pdo->queryExec($sql);
         }
     }
     $this->cleanup = array('nuke' => array(), 'misc' => array());
 }

 /**
  * Reset all stats about a group and delete all releases and binaries associated with that group.
  */
 public function purge($id)
 {
     require_once WWW_DIR . "/lib/binaries.php";
     $db = new DB();
     $releases = new Releases();
     $binaries = new Binaries();
     $this->reset($id);
     $rels = $db->query(sprintf("select ID from releases where groupID = %d", $id));
     foreach ($rels as $rel) {
         $releases->delete($rel["ID"]);
     }
     $bins = $db->query(sprintf("select ID from binaries where groupID = %d", $id));
     foreach ($bins as $bin) {
         $binaries->delete($bin["ID"]);
     }
 }

<?php

require_once "config.php";
$page = new AdminPage();
if (isset($_GET['id'])) {
    $releases = new Releases();
    $releases->delete($_GET['id']);
}
if (isset($_GET['from'])) {
    $referrer = $_GET['from'];
} else {
    $referrer = $_SERVER['HTTP_REFERER'];
}
header("Location: " . $referrer);

     # regular expression entry abort futher checks
     $strerr = str_pad((int) $errcnt, 2, " ", STR_PAD_LEFT);
     if (isset($bl["ID"])) {
         echo "{$strerr}. id=" . $bl["ID"] . ", ";
     }
     echo " name=" . $header["name"] . "\n";
     echo "\t regex={$regex}\n";
     echo "\t error=" . $e->getMessage() . "\n\n";
     exit(1);
 }
 if ($blacklist_check) {
     $errcnt++;
     echo 'BL: /' . $bl['regex'] . '/i matched ' . $header['ID'] . '/' . $header['name'] . " (" . $header['groupname'] . ")\n";
     if ($purgeMatched && isset($header['ID']) && $header['ID'] > 0) {
         // Support purging if enabled
         $release->delete($header['ID']);
     }
     # ensure whitelist flags are off to avoid extra processing
     # at the end of this loop (Below)
     $whitelist = array();
     break;
 }
 if ($use_CategorySizeRestrictions == true && $header['categoryID']) {
     $sizes = null;
     if ($use_NNCategorySizeRestrictions) {
         $sizes = $category->getSizeRangeById($header['categoryID']);
     } else {
         if (array_key_exists($header['categoryID'], $categoryRestrictions)) {
             $sizes = $categoryRestrictions[$header['categoryID']];
         }
     }

//
//$sql = "select ID from releases where fromname = 'PowerBUS@gmail.com (PowerBUS)'";
//
// [5] delete all under a certain amount of completion
//
//$sql = "select ID from releases where completion != 0 and completion != 100 and completion < 99";
//
// [6] all audio which contains a file with .exe in
//
//$sql = "select distinct r.ID from releasefiles rf inner join releases r on r.id = rf.releaseID and r.categoryID like '3%' where rf.name like '%.exe'";
//
// [7] delete all releases for a name
//
//$sql = "select ID from releases where searchname like '%Friday The 13th The Series S03 -enjoy-%'";
//
// [8] delete all releases for a regex
//
//$sql = "select ID from releases where regexID = 1307";
//
// [9] delete all releases under a certain size (100MB) for a category
//
//$sql = "select ID from releases where categoryID like '2%' and size < 104857600";
if ($sql == "") {
    echo "You must uncomment one of the sql selects above to determine which releases are to be deleted.";
} else {
    $rel = $db->query($sql);
    echo "about to delete " . count($rel) . " release(s)";
    foreach ($rel as $r) {
        $releases->delete($r['ID']);
    }
}

 public function processUnwanted()
 {
     $r = new Releases();
     $currTime_ori = $this->pdo->queryOneRow("SELECT NOW() as now");
     //
     // Delete any passworded releases
     //
     if ($this->pdo->getSetting('deletepasswordedrelease') == 1) {
         echo "PostPrc : Removing unwanted releases\n";
         $result = $this->pdo->query("select id from releases where passwordstatus > 0");
         foreach ($result as $row) {
             $r->delete($row["id"]);
         }
     }
     //
     // Delete any releases which are older than site's release retention days
     //
     if ($this->pdo->getSetting('releaseretentiondays') != 0) {
         echo "PostPrc : Deleting releases older than " . $this->pdo->getSetting('releaseretentiondays') . " days\n";
         $result = $this->pdo->query(sprintf("select id from releases where postdate < %s - interval %d day", $this->pdo->escapeString($currTime_ori["now"]), $this->pdo->getSetting('releaseretentiondays')));
         foreach ($result as $row) {
             $r->delete($row["id"]);
         }
     }
     //
     // Delete any audiopreviews older than site->audiopreviewprune days
     //
     if ($this->pdo->getSetting('audiopreviewprune') > 0) {
         $result = $this->pdo->query(sprintf("select guid from releases where categoryid in (select id from category where parentid = " . Category::CAT_PARENT_MUSIC . ") and haspreview = 2 and adddate < %s - interval %d day", $this->pdo->escapeString($currTime_ori["now"]), $this->pdo->getSetting('audiopreviewprune')));
         if (sizeof($result) > 0) {
             echo "PostPrc : Deleting " . count($result) . " audio previews older than " . $this->pdo->getSetting('audiopreviewprune') . " days\n";
             foreach ($result as $row) {
                 $r->updateHasPreview($row["guid"], 0);
                 $this->deleteAudioSample($row["guid"]);
             }
         }
     }
     //
     // Delete any releases suspected of being spam/virus
     //
     if ($this->pdo->getSetting('removespam') != 0) {
         $spamIDs = array();
         //
         // all releases where the only file inside the rars is *.exe and they are not in the PC category
         //
         $sql = "select releasefiles.releaseid as id from releasefiles inner join  ( select releaseid, count(*) as totnum from  releasefiles group by releaseid ) x on x.releaseid = releasefiles.releaseid and x.totnum = 1 inner join releases on releases.id = releasefiles.releaseid left join releasenfo on releasenfo.releaseid = releases.id where (releasefiles.name like '%.exe' or releasefiles.name like '%.scr') and (releases.categoryid not in (select id from category where parentid = " . Category::CAT_PARENT_PC . ") or (releases.categoryid in (select id from category where parentid = " . Category::CAT_PARENT_PC . ") and releasenfo.id is null)) group by releasefiles.releaseid";
         $result = $this->pdo->query($sql);
         $spamIDs = array_merge($result, $spamIDs);
         //
         // all releases containing exe not in permitted categories
         //
         if ($this->pdo->getSetting('exepermittedcategories') != '') {
             $sql = sprintf("select releasefiles.releaseid as id from releasefiles  inner join releases on releases.id = releasefiles.releaseid  left join releasenfo on releasenfo.releaseid = releases.id  where releasefiles.name like '%%.exe'  and releases.categoryid not in (%s)  group by releasefiles.releaseid", $this->pdo->getSetting('exepermittedcategories'));
             $result = $this->pdo->query($sql);
             $spamIDs = array_merge($result, $spamIDs);
         }
         //
         // delete all releases which contain a file with password.url in it
         //
         $sql = "select distinct releasefiles.releaseid as id from releasefiles where name = 'password.url'";
         $result = $this->pdo->query($sql);
         $spamIDs = array_merge($result, $spamIDs);
         //
         // all releases where the only file inside the rars is *.rar
         //
         $sql = "select releasefiles.releaseid as id from releasefiles  inner join  ( select releaseid, count(*) as totnum from releasefiles group by releaseid ) x on x.releaseid = releasefiles.releaseid and x.totnum = 1 inner join releases on releases.id = releasefiles.releaseid where releasefiles.name like '%.rar' group by releasefiles.releaseid";
         $result = $this->pdo->query($sql);
         $spamIDs = array_merge($result, $spamIDs);
         //
         // all audio which contains a file with .exe in
         //
         $sql = "select distinct r.id from releasefiles rf inner join releases r on r.id = rf.releaseid and r.categoryid in (select id from category where parentid = " . Category::CAT_PARENT_MUSIC . ") where (rf.name like '%.exe' or rf.name like '%.bin')";
         $result = $this->pdo->query($sql);
         $spamIDs = array_merge($result, $spamIDs);
         if (count($spamIDs) > 0) {
             echo "PostPrc : Deleting " . count($spamIDs) . " spam releases\n";
             foreach ($spamIDs as $row) {
                 $r->delete($row["id"]);
             }
         }
     }
 }

             }
             if (!file_exists($importedpath . basename($nzbFile))) {
                 rename($nzbFile, $importedpath . basename($nzbFile));
             }
         }
     } else {
         echo sprintf("%0" . $digits . "d %.2f%% Error : Failed to write file to disk %s\n", $items - $num, $num / $items * 100, $nzbfilename);
         if ($movefiles) {
             if (!file_exists($errorpath)) {
                 mkdir($errorpath);
             }
             if (!file_exists($errorpath . basename($nzbFile))) {
                 rename($nzbFile, $errorpath . basename($nzbFile));
             }
         }
         $releases->delete($relid);
     }
 } else {
     $numbins = 0;
     $numparts = 0;
     $binaryId = 0;
     $groupRegexes = $releaseRegex->getForGroup($groupName);
     foreach ($nzbInfo->nzb as $postFile) {
         $regexMatches = [];
         foreach ($groupRegexes as $groupRegex) {
             $regexCheck = $releaseRegex->performMatch($groupRegex, $postFile["subject"]);
             if ($regexCheck !== false) {
                 $regexMatches = $regexCheck;
                 break;
             }
         }

$releases = new Releases();
$category = new Category();
// set the current action
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
$id = isset($_REQUEST['id']) && is_array($_REQUEST['id']) ? $_REQUEST['id'] : '';
$page->smarty->assign('action', $action);
$page->smarty->assign('idArr', $id);
switch ($action) {
    case 'doedit':
    case 'edit':
        $success = false;
        if ($action == 'doedit') {
            $upd = $releases->updatemulti($_REQUEST["id"], $_REQUEST["category"], $_REQUEST["grabs"], $_REQUEST["tvinfoID"], $_REQUEST["season"], $_REQUEST['imdbID']);
            if ($upd !== false) {
                $success = true;
            } else {
            }
        }
        $page->smarty->assign('success', $success);
        $page->smarty->assign('from', isset($_REQUEST['from']) ? $_REQUEST['from'] : '');
        $page->smarty->assign('catlist', $category->getForSelect());
        $page->content = $page->smarty->fetch('ajax_release-edit.tpl');
        echo $page->content;
        break;
    case 'dodelete':
        $releases->delete($_REQUEST["id"], true);
        break;
    default:
        $page->show404();
        break;
}

 public function processGID($limit = 500, $batch = 5000, $delete_broken_releases = false)
 {
     // Process until someone presses cntrl-c
     $db = new DB();
     $nzb = new NZB();
     $processed = 0;
     // We need an offset for tracking unhandled issues
     $offset = 0;
     $fsql = 'SELECT ID, name, guid FROM releases ' . 'WHERE GID IS NULL ORDER BY adddate DESC LIMIT %d,%d';
     $usql = "UPDATE releases SET GID = '%s' WHERE ID = %d";
     while (1) {
         // finish
         if ($limit > 0 && $processed >= $limit) {
             break;
         }
         $batch = $limit > 0 && $batch > $limit ? $limit : $batch;
         $res = $db->query(sprintf($fsql, $offset, $batch));
         if (!$res) {
             break;
         }
         if (count($res) <= 0) {
             break;
         }
         $offset += $batch;
         foreach ($res as $r) {
             $nzbfile = $nzb->getNZBPath($r["guid"]);
             if ($nzbfile === Null) {
                 continue;
             }
             $nzbInfo = new NzbInfo();
             if (!$nzbInfo->loadFromFile($nzbfile)) {
                 if ($delete_broken_releases) {
                     $release = new Releases();
                     $release->delete($r['ID']);
                     // Free the variable in an attempt to recover memory
                     unset($release);
                     echo '-';
                 } else {
                     // Skip over this one for future fetches
                     $offset++;
                 }
                 continue;
             }
             $gid = false;
             if (!empty($nzbInfo->gid)) {
                 $gid = $nzbInfo->gid;
             }
             // Free the variable in an attempt to recover memory
             unset($nzbInfo);
             if (!$gid) {
                 if ($delete_broken_releases) {
                     $release = new Releases();
                     $release->delete($r['ID']);
                     unset($release);
                     echo '-';
                 } else {
                     // Skip over this one for future fetches
                     $offset++;
                 }
                 continue;
             }
             // Update DB With Global Identifer
             $ures = $db->exec(sprintf($usql, $gid, $r['ID']));
             if ($ures < 0) {
                 printf("\nPostPrc : Failed to update: %s\n", $r['name']);
             }
             // make noise...
             echo '.';
             $processed += 1;
         }
     }
     # Batch update for comment table
     $usql = 'UPDATE releasecomment, releases ' . 'SET releasecomment.GID = releases.GID ' . 'WHERE releases.ID = releasecomment.releaseID ' . 'AND releasecomment.GID IS NULL ' . 'AND releases.GID IS NOT NULL ';
     $affected = $db->exec(sprintf($usql));
     if ($affected > 0) {
         $processed += $affected;
     }
     return $processed;
 }