|
@@ 326-376 (lines=51) @@
|
| 323 |
|
* @param $nameStatus |
| 324 |
|
* @param $show |
| 325 |
|
*/ |
| 326 |
|
public function fixXXXNamesWithFiles($time, $echo, $cats, $nameStatus, $show) |
| 327 |
|
{ |
| 328 |
|
$this->_echoStartMessage($time, 'file names'); |
| 329 |
|
$type = 'Filenames, '; |
| 330 |
|
|
| 331 |
|
if ($cats === 3) { |
| 332 |
|
$query = sprintf(' |
| 333 |
|
SELECT rf.name AS textstring, rel.categories_id, rel.name, rel.searchname, rel.fromname, rel.groups_id, |
| 334 |
|
rf.releases_id AS fileid, rel.id AS releases_id |
| 335 |
|
FROM releases rel |
| 336 |
|
INNER JOIN release_files rf ON (rf.releases_id = rel.id) |
| 337 |
|
WHERE nzbstatus = %d |
| 338 |
|
AND predb_id = 0', |
| 339 |
|
NZB::NZB_ADDED |
| 340 |
|
); |
| 341 |
|
$cats = 2; |
| 342 |
|
} else { |
| 343 |
|
$query = sprintf(' |
| 344 |
|
SELECT rf.name AS textstring, rel.categories_id, rel.name, rel.searchname, rel.fromname, rel.groups_id, |
| 345 |
|
rf.releases_id AS fileid, rel.id AS releases_id |
| 346 |
|
FROM releases rel |
| 347 |
|
INNER JOIN release_files rf ON (rf.releases_id = rel.id) |
| 348 |
|
WHERE (rel.isrenamed = %d OR rel.categories_id IN (%d, %d)) |
| 349 |
|
AND rf.name %s', |
| 350 |
|
self::IS_RENAMED_NONE, |
| 351 |
|
Category::OTHER_MISC, |
| 352 |
|
Category::OTHER_HASHED, |
| 353 |
|
$this->pdo->likeString('SDPORN', true, true) |
| 354 |
|
); |
| 355 |
|
} |
| 356 |
|
|
| 357 |
|
$releases = $this->_getReleases($time, $cats, $query); |
| 358 |
|
if ($releases instanceof \Traversable && $releases !== false) { |
| 359 |
|
|
| 360 |
|
$total = $releases->rowCount(); |
| 361 |
|
if ($total > 0) { |
| 362 |
|
$this->_totalReleases = $total; |
| 363 |
|
echo $this->pdo->log->primary(number_format($total) . ' xxx file names to process.'); |
| 364 |
|
|
| 365 |
|
foreach ($releases as $release) { |
| 366 |
|
$this->done = $this->matched = false; |
| 367 |
|
$this->xxxNameCheck($release, $echo, $type, $nameStatus, $show); |
| 368 |
|
$this->checked++; |
| 369 |
|
$this->_echoRenamed($show); |
| 370 |
|
} |
| 371 |
|
$this->_echoFoundCount($echo, ' files'); |
| 372 |
|
} else { |
| 373 |
|
echo $this->pdo->log->info('Nothing to fix.'); |
| 374 |
|
} |
| 375 |
|
} |
| 376 |
|
} |
| 377 |
|
|
| 378 |
|
/** |
| 379 |
|
* Attempts to fix release names using the File name. |
|
@@ 387-437 (lines=51) @@
|
| 384 |
|
* @param $nameStatus |
| 385 |
|
* @param $show |
| 386 |
|
*/ |
| 387 |
|
public function fixNamesWithSrr($time, $echo, $cats, $nameStatus, $show) |
| 388 |
|
{ |
| 389 |
|
$this->_echoStartMessage($time, 'file names'); |
| 390 |
|
$type = 'Filenames, '; |
| 391 |
|
|
| 392 |
|
if ($cats === 3) { |
| 393 |
|
$query = sprintf(' |
| 394 |
|
SELECT rf.name AS textstring, rel.categories_id, rel.name, rel.searchname, rel.fromname, rel.groups_id, |
| 395 |
|
rf.releases_id AS fileid, rel.id AS releases_id |
| 396 |
|
FROM releases rel |
| 397 |
|
INNER JOIN release_files rf ON (rf.releases_id = rel.id) |
| 398 |
|
WHERE nzbstatus = %d |
| 399 |
|
AND predb_id = 0', |
| 400 |
|
NZB::NZB_ADDED |
| 401 |
|
); |
| 402 |
|
$cats = 2; |
| 403 |
|
} else { |
| 404 |
|
$query = sprintf(' |
| 405 |
|
SELECT rf.name AS textstring, rel.categories_id, rel.name, rel.searchname, rel.fromname, rel.groups_id, |
| 406 |
|
rf.releases_id AS fileid, rel.id AS releases_id |
| 407 |
|
FROM releases rel |
| 408 |
|
INNER JOIN release_files rf ON (rf.releases_id = rel.id) |
| 409 |
|
WHERE (rel.isrenamed = %d OR rel.categories_id IN (%d, %d)) |
| 410 |
|
AND rf.name %s', |
| 411 |
|
self::IS_RENAMED_NONE, |
| 412 |
|
Category::OTHER_MISC, |
| 413 |
|
Category::OTHER_HASHED, |
| 414 |
|
$this->pdo->likeString('.srr', true, false) |
| 415 |
|
); |
| 416 |
|
} |
| 417 |
|
|
| 418 |
|
$releases = $this->_getReleases($time, $cats, $query); |
| 419 |
|
if ($releases instanceof \Traversable && $releases !== false) { |
| 420 |
|
|
| 421 |
|
$total = $releases->rowCount(); |
| 422 |
|
if ($total > 0) { |
| 423 |
|
$this->_totalReleases = $total; |
| 424 |
|
echo $this->pdo->log->primary(number_format($total) . ' srr file extensions to process.'); |
| 425 |
|
|
| 426 |
|
foreach ($releases as $release) { |
| 427 |
|
$this->done = $this->matched = false; |
| 428 |
|
$this->srrNameCheck($release, $echo, $type, $nameStatus, $show); |
| 429 |
|
$this->checked++; |
| 430 |
|
$this->_echoRenamed($show); |
| 431 |
|
} |
| 432 |
|
$this->_echoFoundCount($echo, ' files'); |
| 433 |
|
} else { |
| 434 |
|
echo $this->pdo->log->info('Nothing to fix.'); |
| 435 |
|
} |
| 436 |
|
} |
| 437 |
|
} |
| 438 |
|
|
| 439 |
|
/** |
| 440 |
|
* Attempts to fix release names using the Par2 File. |
NNTmux /
newznab-tmux
