/**
* Update the release with the new information.
*
* @param array $release
* @param string $name
* @param string $method
* @param boolean $echo
* @param string $type
* @param int $nameStatus
* @param int $show
* @param int $preId
*/
public function updateRelease($release, $name, $method, $echo, $type, $nameStatus, $show, $preId = 0)
{
if ($this->relid !== $release['releaseid']) {
$releaseCleaning = new ReleaseCleaning($this->pdo);
$newName = $releaseCleaning->fixerCleaner($name);
if (strtolower($newName) != strtolower($release["searchname"])) {
$this->matched = true;
$this->relid = $release["releaseid"];
$determinedCategory = $this->category->determineCategory($release['group_id'], $newName);
if ($type === "PAR2, ") {
$newName = ucwords($newName);
if (preg_match('/(.+?)\\.[a-z0-9]{2,3}(PAR2)?$/i', $name, $match)) {
$newName = $match[1];
}
}
$this->fixed++;
$newName = explode("\\", $newName);
$newName = preg_replace(['/^[-=_\\.:\\s]+/', '/[-=_\\.:\\s]+$/'], '', $newName[0]);
if ($this->echooutput === true && $show === 1) {
$groupName = $this->_groups->getByNameByID($release['group_id']);
$oldCatName = $this->category->getNameByID($release['categoryid']);
$newCatName = $this->category->getNameByID($determinedCategory);
if ($type === "PAR2, ") {
echo PHP_EOL;
}
echo $this->pdo->log->headerOver("\nNew name: ") . $this->pdo->log->primary(substr($newName, 0, 255)) . $this->pdo->log->headerOver("Old name: ") . $this->pdo->log->primary($release["searchname"]) . $this->pdo->log->headerOver("Use name: ") . $this->pdo->log->primary($release["name"]) . $this->pdo->log->headerOver("New cat: ") . $this->pdo->log->primary($newCatName) . $this->pdo->log->headerOver("Old cat: ") . $this->pdo->log->primary($oldCatName) . $this->pdo->log->headerOver("Group: ") . $this->pdo->log->primary($groupName) . $this->pdo->log->headerOver("Method: ") . $this->pdo->log->primary($type . $method) . $this->pdo->log->headerOver("ReleaseID: ") . $this->pdo->log->primary($release["releaseid"]);
if (isset($release['filename']) && $release['filename'] != "") {
echo $this->pdo->log->headerOver("Filename: ") . $this->pdo->log->primary($release["filename"]);
}
if ($type !== "PAR2, ") {
echo "\n";
}
}
$newTitle = $this->pdo->escapeString(substr($newName, 0, 255));
if ($echo == true) {
if ($nameStatus == 1) {
$status = '';
switch ($type) {
case "NFO, ":
$status = "isrenamed = 1, iscategorized = 1, proc_nfo = 1,";
break;
case "PAR2, ":
$status = "isrenamed = 1, iscategorized = 1, proc_par2 = 1,";
break;
case "Filenames, ":
case "file matched source: ":
$status = "isrenamed = 1, iscategorized = 1, proc_files = 1,";
break;
case "SHA1, ":
case "MD5, ":
$status = "isrenamed = 1, iscategorized = 1, dehashstatus = 1,";
break;
case "PreDB FT Exact, ":
$status = "isrenamed = 1, iscategorized = 1,";
break;
case "sorter ":
$status = "isrenamed = 1, iscategorized = 1, proc_sorter = 1,";
break;
}
$this->pdo->queryExec(sprintf('
UPDATE releases
SET videos_id = 0, tv_episodes_id = 0, imdbid = NULL, musicinfoid = NULL,
consoleinfoid = NULL, bookinfoid = NULL, anidbid = NULL, preid = %d,
searchname = %s, %s categoryid = %d
WHERE id = %d', $preId, $newTitle, $status, $determinedCategory, $release['releaseid']));
$this->sphinx->updateRelease($release['releaseid'], $this->pdo);
} else {
$newTitle = $this->pdo->escapeString(substr($newName, 0, 255));
$this->pdo->queryExec(sprintf('
UPDATE releases
SET videos_id = 0, tv_episodes_id = 0, imdbid = NULL, musicinfoid = NULL,
consoleinfoid = NULL, bookinfoid = NULL, anidbid = NULL, preid = %d,
searchname = %s, iscategorized = 1, categoryid = %d
WHERE id = %d', $preId, $newTitle, $determinedCategory, $release['releaseid']));
$this->sphinx->updateRelease($release['releaseid'], $this->pdo);
}
}
}
}
$this->done = true;
}
