} } if (!empty($_GET['year'])) { $Years = explode('-', $_GET['year']); if (is_number($Years[0]) || empty($Years[0]) && !empty($Years[1]) && is_number($Years[1])) { if (count($Years) === 1) { $SphQL->where('year', (int) $Years[0]); $SphQLTor->where('year', (int) $Years[0]); } else { if (empty($Years[1]) || !is_number($Years[1])) { $Years[1] = PHP_INT_MAX; } elseif ($Years[0] > $Years[1]) { $Years = array_reverse($Years); } $SphQL->where_between('year', array((int) $Years[0], (int) $Years[1])); $SphQLTor->where_between('year', array((int) $Years[0], (int) $Years[1])); } } } if (isset($_GET['haslog']) && $_GET['haslog'] !== '') { if ($_GET['haslog'] === '100') { $SphQL->where('logscore', 100); $SphQLTor->where('logscore', 100); } elseif ($_GET['haslog'] < 0) { // Exclude torrents with log score equal to 100 $SphQL->where('logscore', 100, true); $SphQL->where('haslog', 1); $SphQLTor->where('logscore', 100, true); $SphQLTor->where('haslog', 1); } elseif ($_GET['haslog'] == 0) { $SphQL->where('haslog', 0);
if (count($Years) === 1) { $SphQL->where('year', $Years[0]); $SphQLTor->where('year', $Years[0]); } else { if (empty($Years[0])) { $SphQL->where_lt('year', $Years[1], true); $SphQLTor->where_lt('year', $Years[1], true); } elseif (empty($Years[1]) || !is_number($Years[1])) { $SphQL->where_gt('year', $Years[0], true); $SphQLTor->where_gt('year', $Years[0], true); } else { if ($Years[0] > $Years[1]) { $Years = array_reverse($Years); } $SphQL->where_between('year', array($Years[0], $Years[1])); $SphQLTor->where_between('year', array($Years[0], $Years[1])); } } $Filtered = true; } } if (isset($_GET['haslog']) && $_GET['haslog'] !== '') { if ($_GET['haslog'] === '100') { $SphQL->where('logscore', 100); $SphQLTor->where('logscore', 100); } elseif ($_GET['haslog'] < 0) { // Look for torrents with log score < 100 $SphQL->where_lt('logscore', 100); $SphQL->where('haslog', 1); $SphQLTor->where_lt('logscore', 100); $SphQLTor->where('haslog', 1);