NNTmux / newznab-tmux

		$res = $pdo->queryDirect('SELECT id AS releaseid, name, searchname, groups_id, categories_id, dehashstatus FROM releases WHERE predb_id = 0 AND ishashed = 1');

	} else if (isset($argv[1]) && $argv[1] === "full") {

		$res = $pdo->queryDirect('SELECT id AS releaseid, name, searchname, groups_id, categories_id, dehashstatus FROM releases WHERE categories_id = 7020 AND ishashed = 1 AND dehashstatus BETWEEN -6 AND 0');

	} else if (isset($argv[1]) && is_numeric($argv[1])) {

		$res = $pdo->queryDirect('SELECT id AS releaseid, name, searchname, groups_id, categories_id, dehashstatus FROM releases WHERE categories_id = 7020 AND ishashed = 1 AND dehashstatus BETWEEN -6 AND 0 ORDER BY postdate DESC LIMIT ' . $argv[1]);

	}

	$counter = $counted = $total = 0;

	if ($res !== false) {

if (isset($_GET['type'])) {

	$limit = 1;

	if (isset($_GET['limit']) && is_numeric($_GET['limit'])) {

		$limit = $_GET['limit'];

		if ($limit > 100) {

			$limit = 100;

		}

	}

	$offset = 0;

	if (isset($_GET['offset']) && is_numeric($_GET['offset'])) {

		$limit = $orderby = '';

		$show = (isset($args[2]) && $args[2] === 'show') ? 1 : 0;

		if (isset($args[1]) && is_numeric($args[1])) {

			$orderby = "ORDER BY r.id DESC";

			$limit = "LIMIT " . $args[1];

		}

		echo $this->pdo->log->header("\nMatch PreFiles (${args[1]}) Started at " . date('g:i:s'));

		echo $this->pdo->log->primary("Matching predb filename to cleaned release_files.name.\n");