if (isset($_GET['year'])) {
if (is_number($_GET['year']) || $_GET['year'] === '0') {
$SphQL->where('year', $_GET['year']);
} else {
error(404);
}
}
if (!empty($_GET['page']) && is_number($_GET['page']) && $_GET['page'] > 0) {
$Page = $_GET['page'];
$Offset = ($Page - 1) * REQUESTS_PER_PAGE;
$SphQL->limit($Offset, REQUESTS_PER_PAGE, $Offset + REQUESTS_PER_PAGE);
} else {
$Page = 1;
$SphQL->limit(0, REQUESTS_PER_PAGE, REQUESTS_PER_PAGE);
}
$SphQLResult = $SphQL->query();
$NumResults = (int) $SphQLResult->get_meta('total_found');
if ($NumResults > 0) {
$SphRequests = $SphQLResult->to_array('id');
if ($OrderBy === 'random') {
$NumResults = count($SphRequests);
}
if ($NumResults > REQUESTS_PER_PAGE) {
if (($Page - 1) * REQUESTS_PER_PAGE > $NumResults) {
$Page = 0;
}
$PageLinks = Format::get_pages($Page, $NumResults, REQUESTS_PER_PAGE);
}
}
$CurrentURL = Format::get_url(array('order', 'sort', 'page'));
View::show_header($Title, 'requests');
$NumResults = SPHINX_MAX_MATCHES;
}
if ($NumResults) {
$Groups = Torrents::get_groups($GroupIDs);
if (!empty($Groups) && $GroupResults) {
$TorrentIDs = array();
foreach ($Groups as $Group) {
if (!empty($Group['Torrents'])) {
$TorrentIDs = array_merge($TorrentIDs, array_keys($Group['Torrents']));
}
}
$TorrentCount = count($TorrentIDs);
if ($TorrentCount > 0) {
// Get a list of all torrent ids that match the search query
$SphQLTor->where('id', $TorrentIDs)->limit(0, $TorrentCount, $TorrentCount);
$SphQLResultTor = $SphQLTor->query();
$TorrentIDs = $SphQLResultTor->to_pair('id', 'id');
// Because isset() is faster than in_array()
}
}
}
/** End run search query and collect results **/
if ($NumResults == 0) {
$DB->query("\n\tSELECT\n\t\ttags.Name,\n\t\t((COUNT(tags.Name) - 2) * (SUM(tt.PositiveVotes) - SUM(tt.NegativeVotes))) / (tags.Uses * 0.8) AS Score\n\tFROM xbt_snatched AS s\n\t\tINNER JOIN torrents AS t ON t.ID = s.fid\n\t\tINNER JOIN torrents_group AS g ON t.GroupID = g.ID\n\t\tINNER JOIN torrents_tags AS tt ON tt.GroupID = g.ID\n\t\tINNER JOIN tags ON tags.ID = tt.TagID\n\tWHERE s.uid = '{$LoggedUser['ID']}'\n\t\tAND tt.TagID != '13679'\n\t\tAND tt.TagID != '4820'\n\t\tAND tt.TagID != '2838'\n\t\tAND g.CategoryID = '1'\n\t\tAND tags.Uses > '10'\n\tGROUP BY tt.TagID\n\tORDER BY Score DESC\n\tLIMIT 8");
$JsonYouMightLike = array();
while (list($Tag) = $DB->next_record()) {
$JsonYouMightLike[] = $Tag;
}
json_die("success", array('results' => array(), 'youMightLike' => $JsonYouMightLike));
}
$Bookmarks = Bookmarks::all_bookmarks('torrent');
