mirror of
https://github.com/torrentpier/torrentpier.git
synced 2024-12-15 00:21:17 -08:00
0eba082d41
* Minor improvements * Update index_data.php * Updated * Update usercp_viewprofile.tpl * Update mysql.sql * Update main.php * Update CHANGELOG.md
932 lines
31 KiB
PHP
932 lines
31 KiB
PHP
<?php
|
||
/**
|
||
* TorrentPier – Bull-powered BitTorrent tracker engine
|
||
*
|
||
* @copyright Copyright (c) 2005-2024 TorrentPier (https://torrentpier.com)
|
||
* @link https://github.com/torrentpier/torrentpier for the canonical source repository
|
||
* @license https://github.com/torrentpier/torrentpier/blob/master/LICENSE MIT License
|
||
*/
|
||
|
||
define('BB_SCRIPT', 'tracker');
|
||
|
||
require __DIR__ . '/common.php';
|
||
|
||
// Page config
|
||
$page_cfg['include_bbcode_js'] = true;
|
||
$page_cfg['use_tablesorter'] = true;
|
||
$page_cfg['load_tpl_vars'] = [
|
||
'post_icons'
|
||
];
|
||
|
||
// Session start
|
||
$user->session_start(array('req_login' => $bb_cfg['bt_tor_browse_only_reg']));
|
||
|
||
set_die_append_msg();
|
||
|
||
$tor_search_limit = (IS_AM) ? 2000 : 500;
|
||
$forum_select_size = 25; // forum select box max rows
|
||
$max_forum_name_len = 60; // inside forum select box
|
||
$max_forums_selected = 50;
|
||
$title_match_max_len = 60;
|
||
$poster_name_max_len = 25;
|
||
$tor_colspan = 12; // torrents table colspan with all columns
|
||
$per_page = $bb_cfg['topics_per_page'];
|
||
$tracker_url = basename(__FILE__);
|
||
|
||
$time_format = 'H:i';
|
||
$date_format = 'j-M-y';
|
||
$row_class_1 = 'row1';
|
||
$row_class_2 = 'row2';
|
||
|
||
$start = isset($_REQUEST['start']) ? abs((int)$_REQUEST['start']) : 0;
|
||
|
||
$set_default = isset($_GET['def']);
|
||
$user_id = $userdata['user_id'];
|
||
$lastvisit = (!IS_GUEST) ? $userdata['user_lastvisit'] : '';
|
||
$search_id = (isset($_GET['search_id']) && verify_id($_GET['search_id'], SEARCH_ID_LENGTH)) ? $_GET['search_id'] : '';
|
||
$session_id = $userdata['session_id'];
|
||
|
||
$status = (isset($_POST['status']) && is_array($_POST['status'])) ? $_POST['status'] : [];
|
||
|
||
$cat_forum = $tor_to_show = $search_in_forums_ary = [];
|
||
$title_match_sql = $title_match_q = $search_in_forums_csv = '';
|
||
$tr_error = $poster_error = false;
|
||
$row_num = $tor_count = 0;
|
||
|
||
$torrents_tbl = BB_BT_TORRENTS . ' tor';
|
||
$cat_tbl = BB_CATEGORIES . ' c';
|
||
$forums_tbl = BB_FORUMS . ' f';
|
||
$posts_tbl = BB_POSTS . ' p';
|
||
$topics_tbl = BB_TOPICS . ' t';
|
||
$users_tbl = BB_USERS . ' u';
|
||
$tracker_tbl = BB_BT_TRACKER . ' tr';
|
||
$tr_snap_tbl = BB_BT_TRACKER_SNAP . ' sn';
|
||
$dl_stat_tbl = BB_BT_DLSTATUS . ' dl';
|
||
$attach_desc_tbl = BB_ATTACHMENTS_DESC . ' ad';
|
||
|
||
//
|
||
// Search options
|
||
//
|
||
// Key values
|
||
$search_all = -1;
|
||
$never = -2;
|
||
|
||
$sort_asc = 1;
|
||
$sort_desc = 2;
|
||
|
||
$ord_posted = 1;
|
||
$ord_name = 2;
|
||
$ord_compl = 4;
|
||
$ord_repl = 5;
|
||
$ord_views = 6;
|
||
$ord_size = 7;
|
||
$ord_last_p = 8;
|
||
$ord_last_s = 9;
|
||
$ord_seeders = 10;
|
||
$ord_leechers = 11;
|
||
$ord_sp_up = 12;
|
||
$ord_sp_down = 13;
|
||
|
||
// Order options
|
||
$order_opt = array(
|
||
$ord_posted => array(
|
||
'lang' => $lang['IS_REGISTERED'],
|
||
'sql' => 'tor.reg_time',
|
||
),
|
||
$ord_name => array(
|
||
'lang' => $lang['BT_TOPIC_TITLE'],
|
||
'sql' => 't.topic_title',
|
||
),
|
||
$ord_compl => array(
|
||
'lang' => $lang['COMPLETED'],
|
||
'sql' => 'tor.complete_count',
|
||
),
|
||
$ord_seeders => array(
|
||
'lang' => $lang['SEEDS'],
|
||
'sql' => 'sn.seeders',
|
||
),
|
||
$ord_leechers => array(
|
||
'lang' => $lang['LEECHS'],
|
||
'sql' => 'sn.leechers',
|
||
),
|
||
$ord_sp_up => array(
|
||
'lang' => $lang['SPEED_UP'],
|
||
'sql' => 'sn.speed_up',
|
||
),
|
||
$ord_sp_down => array(
|
||
'lang' => $lang['SPEED_DOWN'],
|
||
'sql' => 'sn.speed_down',
|
||
),
|
||
$ord_repl => array(
|
||
'lang' => $lang['BT_REPLIES'],
|
||
'sql' => 't.topic_replies',
|
||
),
|
||
$ord_views => array(
|
||
'lang' => $lang['BT_VIEWS'],
|
||
'sql' => 't.topic_views',
|
||
),
|
||
$ord_size => array(
|
||
'lang' => $lang['SIZE'],
|
||
'sql' => 'tor.size',
|
||
),
|
||
$ord_last_p => array(
|
||
'lang' => $lang['BT_LAST_POST'],
|
||
'sql' => 't.topic_last_post_id',
|
||
),
|
||
$ord_last_s => array(
|
||
'lang' => $lang['BT_SEEDER_LAST_SEEN'],
|
||
'sql' => 'tor.seeder_last_seen',
|
||
),
|
||
);
|
||
$order_select = [];
|
||
foreach ($order_opt as $val => $opt) {
|
||
$order_select[$opt['lang']] = $val;
|
||
}
|
||
|
||
// Sort direction
|
||
$sort_opt = array(
|
||
$sort_asc => array(
|
||
'lang' => $lang['ASC'],
|
||
'sql' => 'ASC',
|
||
),
|
||
$sort_desc => array(
|
||
'lang' => $lang['DESC'],
|
||
'sql' => 'DESC',
|
||
),
|
||
);
|
||
|
||
// Previous days
|
||
$time_opt = array(
|
||
$search_all => array(
|
||
'lang' => $lang['BT_ALL_DAYS_FOR'],
|
||
'sql' => 0,
|
||
),
|
||
1 => array(
|
||
'lang' => $lang['BT_1_DAY_FOR'],
|
||
'sql' => TIMENOW - 86400,
|
||
),
|
||
3 => array(
|
||
'lang' => $lang['BT_3_DAY_FOR'],
|
||
'sql' => TIMENOW - 86400 * 3,
|
||
),
|
||
7 => array(
|
||
'lang' => $lang['BT_7_DAYS_FOR'],
|
||
'sql' => TIMENOW - 86400 * 7,
|
||
),
|
||
14 => array(
|
||
'lang' => $lang['BT_2_WEEKS_FOR'],
|
||
'sql' => TIMENOW - 86400 * 14,
|
||
),
|
||
30 => array(
|
||
'lang' => $lang['BT_1_MONTH_FOR'],
|
||
'sql' => TIMENOW - 86400 * 30,
|
||
),
|
||
);
|
||
$time_select = [];
|
||
foreach ($time_opt as $val => $opt) {
|
||
$time_select[$opt['lang']] = $val;
|
||
}
|
||
|
||
// Seeder not seen
|
||
$s_not_seen_opt = array(
|
||
$search_all => array(
|
||
'lang' => $lang['BT_DISREGARD'],
|
||
'sql' => 0,
|
||
),
|
||
1 => array(
|
||
'lang' => $lang['BT_1_DAY'],
|
||
'sql' => TIMENOW - 86400,
|
||
),
|
||
3 => array(
|
||
'lang' => $lang['BT_3_DAYS'],
|
||
'sql' => TIMENOW - 86400 * 3,
|
||
),
|
||
7 => array(
|
||
'lang' => $lang['BT_7_DAYS'],
|
||
'sql' => TIMENOW - 86400 * 7,
|
||
),
|
||
14 => array(
|
||
'lang' => $lang['BT_2_WEEKS'],
|
||
'sql' => TIMENOW - 86400 * 14,
|
||
),
|
||
30 => array(
|
||
'lang' => $lang['BT_1_MONTH'],
|
||
'sql' => TIMENOW - 86400 * 30,
|
||
),
|
||
$never => array(
|
||
'lang' => $lang['BT_NEVER'],
|
||
'sql' => 0,
|
||
),
|
||
);
|
||
$s_not_seen_select = [];
|
||
foreach ($s_not_seen_opt as $val => $opt) {
|
||
$s_not_seen_select[$opt['lang']] = $val;
|
||
}
|
||
|
||
if ($release_groups = \TorrentPier\Legacy\Group::get_group_data('all')) {
|
||
$s_rg_opt = array(
|
||
$search_all => array(
|
||
'lang' => $lang['CHOOSE_RELEASE_GROUP'],
|
||
'sql' => 0,
|
||
));
|
||
foreach ($release_groups as $rg) {
|
||
if ($rg['release_group']) {
|
||
$s_rg_opt[$rg['group_id']] = array(
|
||
'lang' => $rg['group_name'],
|
||
'sql' => $rg['group_id'],
|
||
);
|
||
}
|
||
}
|
||
foreach ($s_rg_opt as $val => $opt) {
|
||
$s_release_group_select[$opt['lang']] = $val;
|
||
}
|
||
} else {
|
||
$s_rg_opt = '';
|
||
$s_release_group_select = array($lang['CHOOSE_RELEASE_GROUP'] => 0);
|
||
}
|
||
|
||
$GPC = array(
|
||
# var_name key_name def_value GPC type
|
||
'all_words' => array('allw', 1, CHBOX),
|
||
'active' => array('a', 0, CHBOX),
|
||
'cat' => array('c', null, REQUEST),
|
||
'dl_cancel' => array('dla', 0, CHBOX),
|
||
'dl_compl' => array('dlc', 0, CHBOX),
|
||
'dl_down' => array('dld', 0, CHBOX),
|
||
'dl_will' => array('dlw', 0, CHBOX),
|
||
'forum' => array('f', $search_all, REQUEST),
|
||
'my' => array('my', 0, CHBOX),
|
||
'new' => array('new', 0, CHBOX),
|
||
'title_match' => array('nm', null, REQUEST),
|
||
'order' => array('o', $ord_posted, SELECT),
|
||
'poster_id' => array('pid', null, GET),
|
||
'poster_name' => array('pn', null, REQUEST),
|
||
'user_releases' => array('rid', null, GET),
|
||
'sort' => array('s', $sort_desc, SELECT),
|
||
'seed_exist' => array('sd', 0, CHBOX),
|
||
'show_author' => array('da', 1, CHBOX),
|
||
'show_cat' => array('dc', 0, CHBOX),
|
||
'show_forum' => array('df', 1, CHBOX),
|
||
'show_speed' => array('ds', 0, CHBOX),
|
||
's_rg' => array('srg', $search_all, SELECT),
|
||
's_not_seen' => array('sns', $search_all, SELECT),
|
||
'time' => array('tm', $search_all, SELECT),
|
||
'tor_type' => array('tor_type', 0, CHBOX),
|
||
'hash' => array('hash', null, REQUEST),
|
||
);
|
||
|
||
// Define all GPC vars with default values
|
||
foreach ($GPC as $name => $params) {
|
||
${"{$name}_key"} = $params[KEY_NAME];
|
||
${"{$name}_val"} = $params[DEF_VAL];
|
||
}
|
||
|
||
if (isset($_GET[$user_releases_key])) {
|
||
// Search releases by user
|
||
$_GET[$poster_id_key] = (int)$_GET[$user_releases_key];
|
||
$_REQUEST[$forum_key] = $search_all;
|
||
} elseif (!empty($_REQUEST['max'])) {
|
||
$_REQUEST[$forum_key] = $search_all;
|
||
} else {
|
||
// Get "checkbox" and "select" vars
|
||
foreach ($GPC as $name => $params) {
|
||
if ($params[GPC_TYPE] == CHBOX) {
|
||
checkbox_get_val($params[KEY_NAME], ${"{$name}_val"}, $params[DEF_VAL]);
|
||
} elseif ($params[GPC_TYPE] == SELECT) {
|
||
select_get_val($params[KEY_NAME], ${"{$name}_val"}, ${"{$name}_opt"}, $params[DEF_VAL]);
|
||
}
|
||
}
|
||
}
|
||
|
||
// Random release
|
||
if ($bb_cfg['tracker']['random_release_button'] && isset($_GET['random_release'])) {
|
||
if ($random_release = DB()->fetch_row("SELECT topic_id FROM " . BB_BT_TORRENTS . " WHERE tor_status NOT IN(" . implode(', ', array_keys($bb_cfg['tor_frozen'])) . ") ORDER BY RAND() LIMIT 1")) {
|
||
redirect(TOPIC_URL . $random_release['topic_id']);
|
||
} else {
|
||
bb_die($lang['NO_MATCH']);
|
||
}
|
||
}
|
||
|
||
// Restore torrents list and search settings if we have valid $search_id
|
||
$tor_list_ary = [];
|
||
$tor_list_sql = '';
|
||
|
||
if ($search_id) {
|
||
$row = DB()->fetch_row("
|
||
SELECT search_array, search_settings
|
||
FROM " . BB_SEARCH . "
|
||
WHERE session_id = '$session_id'
|
||
AND search_type = " . SEARCH_TYPE_TRACKER . "
|
||
AND search_id = '" . DB()->escape($search_id) . "'
|
||
LIMIT 1
|
||
");
|
||
|
||
if (empty($row['search_settings'])) {
|
||
bb_die($lang['SESSION_EXPIRED']);
|
||
}
|
||
|
||
$previous_settings = unserialize($row['search_settings']);
|
||
$tor_list_sql = $row['search_array'];
|
||
$tor_list_ary = explode(',', $tor_list_sql);
|
||
$tor_count = count($tor_list_ary);
|
||
unset($row);
|
||
}
|
||
|
||
// Get allowed for searching forums list
|
||
if (!$forums = $datastore->get('cat_forums') and !$datastore->has('cat_forums')) {
|
||
$datastore->update('cat_forums');
|
||
$forums = $datastore->get('cat_forums');
|
||
}
|
||
$cat_title_html = $forums['cat_title_html'];
|
||
$forum_name_html = $forums['forum_name_html'];
|
||
|
||
$excluded_forums_csv = $user->get_excluded_forums(AUTH_READ);
|
||
$allowed_forums = array_diff(explode(',', $forums['tracker_forums']), explode(',', $excluded_forums_csv));
|
||
|
||
foreach ($allowed_forums as $forum_id) {
|
||
$f = $forums['f'][$forum_id];
|
||
$cat_forum['c'][$f['cat_id']][] = $forum_id;
|
||
|
||
if ($f['forum_parent']) {
|
||
$cat_forum['subforums'][$forum_id] = true;
|
||
$cat_forum['forums_with_sf'][$f['forum_parent']] = true;
|
||
}
|
||
}
|
||
unset($forums);
|
||
$datastore->rm('cat_forums');
|
||
|
||
// Get current search settings
|
||
if (!$set_default) {
|
||
// Search in forum or category
|
||
// Get requested cat_id
|
||
$search_in_forums_fary = [];
|
||
|
||
if ($req_cat_id =& $_REQUEST[$cat_key]) {
|
||
if (isset($cat_forum['c'][$req_cat_id])) {
|
||
$valid_forums = $cat_forum['c'][$req_cat_id];
|
||
$forum_val = implode(',', $valid_forums);
|
||
}
|
||
} // Get requested forum_id(s)
|
||
elseif ($req_forums =& $_REQUEST[$forum_key]) {
|
||
if ($req_forums != $search_all) {
|
||
$clean_forums = [];
|
||
if (is_array($req_forums)) {
|
||
$req_forums = implode(',', $req_forums);
|
||
}
|
||
foreach (explode(',', $req_forums) as $req_forum) {
|
||
$clean_forums[] = (int)$req_forum;
|
||
}
|
||
$forum_val = implode(',', array_intersect($clean_forums, $allowed_forums));
|
||
}
|
||
} elseif (isset($previous_settings[$forum_key])) {
|
||
$valid_forums = array_intersect(explode(',', $previous_settings[$forum_key]), $allowed_forums);
|
||
$forum_val = implode(',', $valid_forums);
|
||
}
|
||
|
||
if ($forum_val && $forum_val != $search_all) {
|
||
$search_in_forums_ary = array_slice(explode(',', $forum_val), 0, $max_forums_selected);
|
||
$search_in_forums_fary = array_flip($search_in_forums_ary);
|
||
$search_in_forums_csv = implode(',', $search_in_forums_ary);
|
||
$forum_val = $search_in_forums_csv;
|
||
} else {
|
||
$forum_val = $search_all;
|
||
}
|
||
|
||
// Get poster_id
|
||
if (!$my_val) {
|
||
$req_poster_id = '';
|
||
|
||
if (isset($_GET[$poster_id_key]) && !$search_id) {
|
||
$req_poster_id = (int)$_GET[$poster_id_key];
|
||
} elseif (isset($_POST[$poster_name_key]) && !$search_id) {
|
||
if ($req_poster_name = clean_username($_POST[$poster_name_key])) {
|
||
$poster_name_sql = str_replace("\\'", "''", $req_poster_name);
|
||
|
||
if ($poster_id = get_user_id($poster_name_sql)) {
|
||
$poster_id_val = $poster_id;
|
||
$poster_name_val = stripslashes(html_entity_decode($req_poster_name));
|
||
} else {
|
||
$poster_name_val = $lang['BT_USER_NOT_FOUND'];
|
||
$tr_error = $poster_error = true;
|
||
}
|
||
}
|
||
} elseif ($search_id && $previous_settings[$poster_id_key]) {
|
||
$poster_id_val = (int)$previous_settings[$poster_id_key];
|
||
$poster_name_val = $previous_settings[$poster_name_key] ?: '';
|
||
}
|
||
|
||
if ($req_poster_id) {
|
||
if ($req_poster_id == GUEST_UID) {
|
||
$poster_id_val = GUEST_UID;
|
||
$poster_name_val = $lang['GUEST'];
|
||
} elseif ($poster_name_val = get_username($req_poster_id)) {
|
||
$poster_name_val = stripslashes(html_entity_decode($poster_name_val));
|
||
$poster_id_val = $req_poster_id;
|
||
}
|
||
}
|
||
}
|
||
|
||
if (isset($_REQUEST[$hash_key])) {
|
||
hash_search($_REQUEST[$hash_key]);
|
||
}
|
||
|
||
if (($tm =& $_REQUEST[$title_match_key]) && is_string($tm)) {
|
||
if ($tmp = mb_substr(trim($tm), 0, $title_match_max_len)) {
|
||
$title_match_val = $tmp;
|
||
$title_match_sql = clean_text_match($title_match_val, true, false);
|
||
}
|
||
}
|
||
}
|
||
|
||
$dl_status = [];
|
||
if ($dl_cancel_val) {
|
||
$dl_status[] = DL_STATUS_CANCEL;
|
||
}
|
||
if ($dl_compl_val) {
|
||
$dl_status[] = DL_STATUS_COMPLETE;
|
||
}
|
||
if ($dl_down_val) {
|
||
$dl_status[] = DL_STATUS_DOWN;
|
||
}
|
||
if ($dl_will_val) {
|
||
$dl_status[] = DL_STATUS_WILL;
|
||
}
|
||
$dl_status_csv = implode(',', $dl_status);
|
||
|
||
// Switches
|
||
$seed_exist = (bool)$seed_exist_val;
|
||
$poster_id = (bool)$poster_id_val;
|
||
$title_match = (bool)$title_match_sql;
|
||
$tor_type = (bool)$tor_type_val;
|
||
|
||
$hide_cat = (int)(!$show_cat_val);
|
||
$hide_forum = (int)(!$show_forum_val);
|
||
$hide_author = (int)(!$show_author_val);
|
||
$hide_speed = (int)(!$show_speed_val);
|
||
|
||
$only_new = ($new_val && !IS_GUEST);
|
||
$only_active = ($active_val || $seed_exist);
|
||
$dl_search = ($dl_status && !IS_GUEST);
|
||
$only_my = ($my_val && !IS_GUEST && !$dl_search);
|
||
$prev_days = ($time_val != $search_all);
|
||
$s_release_group = ($s_rg_val != $search_all);
|
||
$s_not_seen = ($s_not_seen_val != $search_all);
|
||
|
||
if ($s_not_seen_val != $search_all) {
|
||
$seed_exist_val = 0;
|
||
}
|
||
if ($seed_exist_val) {
|
||
$active_val = 1;
|
||
}
|
||
if ($dl_search) {
|
||
$my_val = 0;
|
||
}
|
||
|
||
if ($allowed_forums) {
|
||
// Save current search settings
|
||
$save_in_db = array(
|
||
'all_words',
|
||
'active',
|
||
'dl_cancel',
|
||
'dl_compl',
|
||
'dl_down',
|
||
'dl_will',
|
||
'forum',
|
||
'my',
|
||
'new',
|
||
'order',
|
||
'poster_id',
|
||
'poster_name',
|
||
's_not_seen',
|
||
's_rg',
|
||
'seed_exist',
|
||
'show_author',
|
||
'show_cat',
|
||
'show_forum',
|
||
'show_speed',
|
||
'sort',
|
||
'time',
|
||
);
|
||
$curr_set = [];
|
||
foreach ($save_in_db as $name) {
|
||
$curr_set[${"{$name}_key"}] = ${"{$name}_val"};
|
||
}
|
||
$curr_set_sql = DB()->escape(serialize($curr_set));
|
||
|
||
// Text search
|
||
$search_match_topics_csv = '';
|
||
|
||
if ($title_match) {
|
||
$title_match_topics = get_title_match_topics($title_match_sql, $search_in_forums_ary);
|
||
|
||
if (!$search_match_topics_csv = implode(',', $title_match_topics)) {
|
||
$tr_error = true;
|
||
}
|
||
} else {
|
||
$title_match_val = '';
|
||
}
|
||
|
||
// Get torrents list
|
||
if (!$tr_error && !$tor_list_sql) {
|
||
$reg_time = $time_opt[$time_val]['sql'];
|
||
$poster_id_sql = (int)$poster_id_val;
|
||
$rg_id_sql = (int)$s_rg_val;
|
||
$s_seen_time = $s_not_seen_opt[$s_not_seen_val]['sql'];
|
||
$s_seen_sign = ($s_not_seen_val == $never) ? '=' : '<';
|
||
$s_seen_exclude = ($s_not_seen_val == $never) ? '' : "AND tor.seeder_last_seen != 0";
|
||
$order_by_peers = ($order_val == $ord_seeders || $order_val == $ord_leechers);
|
||
$order_by_speed = ($order_val == $ord_sp_up || $order_val == $ord_sp_down);
|
||
|
||
$join_t = in_array($order_val, array($ord_name, $ord_repl, $ord_views, $ord_last_p, $title_match));
|
||
$join_sn = ($only_active || $order_by_peers || $order_by_speed);
|
||
$join_dl = $dl_search;
|
||
|
||
// Start building SQL
|
||
$SQL = DB()->get_empty_sql_array();
|
||
|
||
// SELECT
|
||
$SQL['SELECT'][] = "tor.topic_id";
|
||
|
||
// FROM
|
||
$SQL['FROM'][] = $torrents_tbl;
|
||
|
||
if ($join_t) {
|
||
$SQL['INNER JOIN'][] = "$topics_tbl ON(t.topic_id = tor.topic_id)";
|
||
}
|
||
if ($join_sn) {
|
||
$SQL['LEFT JOIN'][] = "$tr_snap_tbl ON(sn.topic_id = tor.topic_id)";
|
||
}
|
||
if ($join_dl) {
|
||
$SQL['INNER JOIN'][] = "$dl_stat_tbl ON(
|
||
dl.topic_id = tor.topic_id
|
||
AND dl.user_id = $user_id
|
||
AND dl.user_status IN($dl_status_csv)
|
||
)";
|
||
}
|
||
if ($s_release_group) {
|
||
$SQL['LEFT JOIN'][] = "$posts_tbl ON(p.topic_id = tor.topic_id)";
|
||
}
|
||
|
||
// WHERE
|
||
$title_match_notfound_flag = false;
|
||
if ($search_match_topics_csv) {
|
||
$SQL['WHERE'][] = "tor.topic_id IN($search_match_topics_csv)";
|
||
}
|
||
if ($search_in_forums_csv) {
|
||
$SQL['WHERE'][] = "tor.forum_id IN($search_in_forums_csv)";
|
||
}
|
||
if ($excluded_forums_csv) {
|
||
$SQL['WHERE'][] = "tor.forum_id NOT IN($excluded_forums_csv)";
|
||
}
|
||
if ($poster_id) {
|
||
$SQL['WHERE'][] = "tor.poster_id = $poster_id_sql";
|
||
}
|
||
if ($s_release_group) {
|
||
$SQL['WHERE'][] = "p.poster_rg_id = $rg_id_sql";
|
||
}
|
||
if ($only_new) {
|
||
$SQL['WHERE'][] = "tor.reg_time > $lastvisit";
|
||
}
|
||
if ($prev_days) {
|
||
$SQL['WHERE'][] = "tor.reg_time > $reg_time";
|
||
}
|
||
if ($s_not_seen) {
|
||
$SQL['WHERE'][] = "tor.seeder_last_seen $s_seen_sign $s_seen_time $s_seen_exclude";
|
||
}
|
||
if ($only_my) {
|
||
$SQL['WHERE'][] = "tor.poster_id = $user_id";
|
||
}
|
||
if ($only_active) {
|
||
$SQL['WHERE'][] = "sn.topic_id IS NOT NULL";
|
||
}
|
||
if ($seed_exist) {
|
||
$SQL['WHERE'][] = "sn.seeders >= 1";
|
||
}
|
||
if ($tor_type) {
|
||
$SQL['WHERE'][] = "tor.tor_type IN(1,2)";
|
||
}
|
||
if (!empty($status)) {
|
||
$SQL['WHERE'][] = "tor.tor_status IN(" . implode(', ', $status) . ")";
|
||
}
|
||
|
||
// ORDER
|
||
$SQL['ORDER BY'][] = "{$order_opt[$order_val]['sql']} {$sort_opt[$sort_val]['sql']}";
|
||
|
||
// LIMIT
|
||
$SQL['LIMIT'][] = $tor_search_limit;
|
||
|
||
if ($title_match && $title_match_notfound_flag) {
|
||
$tor_list_sql = '';
|
||
$tor_count = 0;
|
||
} else {
|
||
foreach (DB()->fetch_rowset($SQL) as $row) {
|
||
$tor_list_ary[] = $row['topic_id'];
|
||
}
|
||
$tor_list_sql = implode(',', $tor_list_ary);
|
||
$tor_count = count($tor_list_ary);
|
||
}
|
||
}
|
||
|
||
if (!$tor_list_sql || $start > $tor_count) {
|
||
$template->assign_vars(array(
|
||
'TOR_NOT_FOUND' => true,
|
||
'NO_MATCH_MSG' => $lang['NO_MATCH'],
|
||
));
|
||
} else {
|
||
// Save result in DB
|
||
if ($tor_count > $per_page && !$search_id) {
|
||
$search_id = make_rand_str(SEARCH_ID_LENGTH);
|
||
$search_type = SEARCH_TYPE_TRACKER;
|
||
|
||
$columns = 'session_id, search_type, search_id, search_time, search_settings, search_array';
|
||
$values = "'$session_id', $search_type, '$search_id', " . TIMENOW . ", '$curr_set_sql', '$tor_list_sql'";
|
||
|
||
DB()->query("REPLACE INTO " . BB_SEARCH . " ($columns) VALUES ($values)");
|
||
}
|
||
unset($columns, $values, $curr_set_sql, $tor_list_sql);
|
||
|
||
$tor_to_show = ($tor_count > $per_page) ? array_slice($tor_list_ary, $start, $per_page) : $tor_list_ary;
|
||
|
||
if (!$tor_to_show = implode(',', $tor_to_show)) {
|
||
bb_die($lang['NO_SEARCH_MATCH']);
|
||
}
|
||
|
||
// SELECT
|
||
$select = "
|
||
SELECT
|
||
tor.topic_id, tor.post_id, tor.attach_id, tor.size, tor.reg_time, tor.complete_count, tor.seeder_last_seen, tor.tor_status, tor.tor_type,
|
||
t.topic_title, t.topic_time, t.topic_replies, t.topic_views, t.topic_vote, sn.seeders, sn.leechers, tor.info_hash, tor.info_hash_v2, ad.download_count
|
||
";
|
||
$select .= (!$hide_speed) ? ", sn.speed_up, sn.speed_down" : '';
|
||
$select .= (!$hide_forum) ? ", tor.forum_id" : '';
|
||
$select .= (!$hide_cat) ? ", f.cat_id" : '';
|
||
$select .= (!$hide_author) ? ", tor.poster_id, u.username, u.user_rank" : '';
|
||
$select .= (!IS_GUEST) ? ", dl.user_status AS dl_status" : '';
|
||
|
||
// FROM
|
||
$from = "
|
||
FROM $torrents_tbl
|
||
LEFT JOIN $topics_tbl ON(t.topic_id = tor.topic_id)
|
||
";
|
||
$from .= (!$hide_cat) ? "
|
||
LEFT JOIN $forums_tbl ON(f.forum_id = t.forum_id)
|
||
" : '';
|
||
$from .= (!$hide_author) ? "
|
||
LEFT JOIN $users_tbl ON(u.user_id = tor.poster_id)
|
||
" : '';
|
||
$from .= (!IS_GUEST) ? "
|
||
LEFT JOIN $dl_stat_tbl ON(dl.topic_id = tor.topic_id AND dl.user_id = $user_id)
|
||
" : '';
|
||
$from .= "LEFT JOIN $tr_snap_tbl ON(sn.topic_id = tor.topic_id)";
|
||
$from .= "LEFT JOIN $attach_desc_tbl ON(ad.attach_id = tor.attach_id)";
|
||
|
||
// WHERE
|
||
$where = "
|
||
WHERE tor.topic_id IN($tor_to_show)
|
||
";
|
||
|
||
// ORDER
|
||
$order = "ORDER BY " . $order_opt[$order_val]['sql'];
|
||
|
||
// SORT
|
||
$sort = $sort_opt[$sort_val]['sql'];
|
||
|
||
// LIMIT
|
||
$limit = "LIMIT $per_page";
|
||
|
||
$sql = "
|
||
$select
|
||
$from
|
||
$where
|
||
$order
|
||
$sort
|
||
$limit
|
||
";
|
||
|
||
// Build torrents table
|
||
foreach (DB()->fetch_rowset($sql) as $tor) {
|
||
$dl = $tor['speed_down'] ?? 0;
|
||
$ul = $tor['speed_up'] ?? 0;
|
||
|
||
$seeds = $tor['seeders'];
|
||
$leechs = $tor['leechers'];
|
||
$s_last = $tor['seeder_last_seen'];
|
||
$att_id = $tor['attach_id'];
|
||
$size = $tor['size'];
|
||
$tor_magnet = create_magnet($tor['info_hash'], $tor['info_hash_v2'], \TorrentPier\Legacy\Torrent::getPasskey($user_id), html_ent_decode($tor['topic_title']));
|
||
$compl = $tor['complete_count'];
|
||
$dl_sp = $dl ? humn_size($dl, 0, 'KB') . '/s' : '0 KB/s';
|
||
$ul_sp = $ul ? humn_size($ul, 0, 'KB') . '/s' : '0 KB/s';
|
||
|
||
$dl_class = isset($tor['dl_status']) ? $dl_link_css[$tor['dl_status']] : 'genmed';
|
||
$row_class = !($row_num & 1) ? $row_class_1 : $row_class_2;
|
||
$row_num++;
|
||
|
||
$cat_id = (!$hide_cat && isset($tor['cat_id'])) ? $tor['cat_id'] : '';
|
||
$forum_id = (!$hide_forum && isset($tor['forum_id'])) ? $tor['forum_id'] : '';
|
||
$poster_id = (!$hide_author && isset($tor['poster_id'])) ? $tor['poster_id'] : '';
|
||
|
||
$template->assign_block_vars('tor', array(
|
||
'CAT_ID' => $cat_id,
|
||
'CAT_TITLE' => $cat_id ? $cat_title_html[$cat_id] : '',
|
||
'FORUM_ID' => $forum_id,
|
||
'FORUM_NAME' => $forum_id ? $forum_name_html[$forum_id] : '',
|
||
'TOPIC_ID' => $tor['topic_id'],
|
||
'TOPIC_TITLE' => $tor['topic_title'],
|
||
'TOPIC_TIME' => bb_date($tor['topic_time'], 'd-M-y') . ' <b>·</b> ' . delta_time($tor['topic_time']),
|
||
'POST_ID' => $tor['post_id'],
|
||
'POSTER_ID' => $poster_id,
|
||
'USERNAME' => $hide_author ? '' : profile_url(array('username' => $tor['username'], 'user_rank' => $tor['user_rank'])),
|
||
|
||
'ROW_CLASS' => $row_class,
|
||
'ROW_NUM' => $row_num,
|
||
'DL_CLASS' => $dl_class,
|
||
'IS_NEW' => (!IS_GUEST && $tor['reg_time'] > $lastvisit),
|
||
'POLL' => (bool)$tor['topic_vote'],
|
||
'USER_AUTHOR' => (!IS_GUEST && $poster_id == $user_id),
|
||
|
||
'ATTACH_ID' => $att_id,
|
||
'MAGNET' => $tor_magnet,
|
||
'TOR_TYPE' => is_gold($tor['tor_type']),
|
||
|
||
'TOR_FROZEN' => !IS_AM ? isset($bb_cfg['tor_frozen'][$tor['tor_status']]) : '',
|
||
'TOR_STATUS_ICON' => $bb_cfg['tor_icons'][$tor['tor_status']],
|
||
'TOR_STATUS_TEXT' => $lang['TOR_STATUS_NAME'][$tor['tor_status']],
|
||
|
||
'TOR_SIZE_RAW' => $size,
|
||
'TOR_SIZE' => humn_size($size, 1),
|
||
'UL_SPEED' => $ul_sp,
|
||
'DL_SPEED' => $dl_sp,
|
||
'SEEDS' => $seeds ?: 0,
|
||
'SEEDS_TITLE' => $seeds ? $lang['SEEDERS'] : ($lang['SEED_NOT_SEEN'] . ":\n " . (($s_last) ? bb_date($s_last, $date_format) : $lang['NEVER'])),
|
||
'LEECHS' => $leechs ?: 0,
|
||
'COMPLETED' => declension($compl ?: 0, 'times'),
|
||
'DOWNLOADED' => $tor['download_count'],
|
||
'REPLIES' => $tor['topic_replies'],
|
||
'VIEWS' => $tor['topic_views'],
|
||
'ADDED_RAW' => $tor['reg_time'],
|
||
'ADDED_TIME' => bb_date($tor['reg_time'], $time_format),
|
||
'ADDED_DATE' => bb_date($tor['reg_time'], $date_format, false),
|
||
));
|
||
}
|
||
}
|
||
} else {
|
||
$template->assign_vars(array(
|
||
'TOR_NOT_FOUND' => true,
|
||
'NO_MATCH_MSG' => $lang['BT_NO_SEARCHABLE_FORUMS'],
|
||
));
|
||
}
|
||
|
||
// Pagination
|
||
if ($tor_count) {
|
||
$base_url = "$tracker_url?search_id=$search_id";
|
||
$search_matches = ($tor_count == 1) ? sprintf($lang['FOUND_SEARCH_MATCH'], $tor_count) : sprintf($lang['FOUND_SEARCH_MATCHES'], $tor_count);
|
||
$search_max = "(max: $tor_search_limit)";
|
||
|
||
generate_pagination($base_url, $tor_count, $per_page, $start);
|
||
|
||
$template->assign_vars(array(
|
||
'MATCHES' => $search_matches,
|
||
'SERACH_MAX' => $search_max,
|
||
));
|
||
}
|
||
|
||
if (empty($cat_forum)) {
|
||
bb_die($lang['BT_NO_SEARCHABLE_FORUMS']);
|
||
}
|
||
|
||
// Forum select
|
||
$opt = '';
|
||
foreach ($cat_forum['c'] as $cat_id => $forums_ary) {
|
||
$opt .= '<optgroup label=" ' . $cat_title_html[$cat_id] . "\">\n";
|
||
|
||
foreach ($forums_ary as $forum_id) {
|
||
$forum_name = $forum_name_html[$forum_id];
|
||
$forum_name = str_short($forum_name, $max_forum_name_len - 2);
|
||
$style = '';
|
||
if (!isset($cat_forum['subforums'][$forum_id])) {
|
||
$class = 'root_forum has_sf';
|
||
$class .= isset($cat_forum['forums_with_sf'][$forum_id]) ? ' has_sf' : '';
|
||
$style = " class=\"$class\"";
|
||
}
|
||
$selected = (isset($search_in_forums_fary[$forum_id])) ? HTML_SELECTED : '';
|
||
$opt .= '<option id="fs-' . $forum_id . '" value="' . $forum_id . '"' . $style . $selected . '>' . (isset($cat_forum['subforums'][$forum_id]) ? HTML_SF_SPACER : '') . $forum_name . " </option>\n";
|
||
}
|
||
|
||
$opt .= "</optgroup>\n";
|
||
}
|
||
$search_all_opt = '<option value="' . $search_all . '" value="fs-' . $search_all . '"' . (($forum_val == $search_all) ? HTML_SELECTED : '') . '> ' . htmlCHR($lang['ALL_AVAILABLE']) . "</option>\n";
|
||
$cat_forum_select = "\n" . '<select id="fs-main" style="width: 100%;" name="' . $forum_key . '[]" multiple size="' . $forum_select_size . "\">\n" . $search_all_opt . $opt . "</select>\n";
|
||
|
||
// Status select
|
||
if ($bb_cfg['tracker']['search_by_tor_status']) {
|
||
$statuses = '<table border="0" cellpadding="0" cellspacing="0">';
|
||
foreach (array_chunk($bb_cfg['tor_icons'], 2, true) as $statuses_part) {
|
||
$statuses .= '<tr>';
|
||
foreach ($statuses_part as $status_id => $status_styles) {
|
||
$checked_status = in_array($status_id, $status) ? 'checked' : '';
|
||
$statuses .= '<td><p class="chbox"><label><input type="checkbox" name="status[]" value="' . $status_id . '"' . $checked_status . '>' . $status_styles . ' ' . $lang['TOR_STATUS_NAME'][$status_id] . '</label></p></td>';
|
||
}
|
||
$statuses .= '</tr>';
|
||
}
|
||
$statuses .= '</table>';
|
||
}
|
||
|
||
// Sort dir
|
||
$template->assign_vars(array(
|
||
'SORT_NAME' => $sort_key,
|
||
'SORT_ASC' => $sort_asc,
|
||
'SORT_DESC' => $sort_desc,
|
||
'SORT_ASC_CHECKED' => ($sort_val == $sort_asc) ? HTML_CHECKED : '',
|
||
'SORT_DESC_CHECKED' => ($sort_val == $sort_desc) ? HTML_CHECKED : '',
|
||
));
|
||
|
||
// Displaying options
|
||
$tor_type_lang = $lang['GOLD'] . ' / ' . $lang['SILVER'];
|
||
|
||
$template->assign_vars(array(
|
||
'SHOW_CAT_CHBOX' => build_checkbox($show_cat_key, $lang['BT_SHOW_CAT'], $show_cat_val),
|
||
'SHOW_FORUM_CHBOX' => build_checkbox($show_forum_key, $lang['BT_SHOW_FORUM'], $show_forum_val),
|
||
'SHOW_AUTHOR_CHBOX' => build_checkbox($show_author_key, $lang['BT_SHOW_AUTHOR'], $show_author_val),
|
||
'SHOW_SPEED_CHBOX' => build_checkbox($show_speed_key, $lang['BT_SHOW_SPEED'], $show_speed_val),
|
||
'ALL_WORDS_CHBOX' => build_checkbox($all_words_key, $lang['SEARCH_ALL_WORDS'], $all_words_val),
|
||
'TOR_TYPE_CHBOX' => build_checkbox($tor_type_key, $tor_type_lang, $tor_type_val),
|
||
|
||
'ONLY_MY_CHBOX' => build_checkbox($my_key, $lang['BT_ONLY_MY'], $only_my, IS_GUEST),
|
||
'ONLY_ACTIVE_CHBOX' => build_checkbox($active_key, $lang['BT_ONLY_ACTIVE'], $active_val),
|
||
'SEED_EXIST_CHBOX' => build_checkbox($seed_exist_key, $lang['BT_SEED_EXIST'], $seed_exist),
|
||
'ONLY_NEW_CHBOX' => build_checkbox($new_key, $lang['BT_ONLY_NEW'], $only_new, IS_GUEST),
|
||
|
||
'DL_CANCEL_CHBOX' => build_checkbox($dl_cancel_key, $lang['SEARCH_DL_CANCEL'], $dl_cancel_val, IS_GUEST, 'dlCancel'),
|
||
'DL_COMPL_CHBOX' => build_checkbox($dl_compl_key, $lang['SEARCH_DL_COMPLETE'], $dl_compl_val, IS_GUEST, 'dlComplete'),
|
||
'DL_DOWN_CHBOX' => build_checkbox($dl_down_key, $lang['SEARCH_DL_DOWN'], $dl_down_val, IS_GUEST, 'dlDown'),
|
||
'DL_WILL_CHBOX' => build_checkbox($dl_will_key, $lang['SEARCH_DL_WILL'], $dl_will_val, IS_GUEST, 'dlWill'),
|
||
|
||
'POSTER_NAME_NAME' => $poster_name_key,
|
||
'POSTER_NAME_VAL' => htmlCHR($poster_name_val),
|
||
'TITLE_MATCH_NAME' => $title_match_key,
|
||
'TITLE_MATCH_VAL' => htmlCHR($title_match_val),
|
||
|
||
'AJAX_TOPICS' => $user->opt_js['tr_t_ax'],
|
||
'SHOW_TIME_TOPICS' => $user->opt_js['tr_t_t'],
|
||
'SHOW_CURSOR' => $user->opt_js['hl_tr'],
|
||
'HIDE_CONTENTS' => $user->opt_js['h_tsp'],
|
||
|
||
'U_SEARCH_USER' => "search.php?mode=searchuser&input_name=$poster_name_key",
|
||
));
|
||
|
||
// Hidden fields
|
||
$save_through_pages = array(
|
||
'all_words',
|
||
'active',
|
||
'dl_cancel',
|
||
'dl_compl',
|
||
'dl_down',
|
||
'dl_will',
|
||
'my',
|
||
'new',
|
||
'seed_exist',
|
||
'show_author',
|
||
'show_cat',
|
||
'show_forum',
|
||
'show_speed',
|
||
'tor_type',
|
||
);
|
||
$hidden_fields = [];
|
||
foreach ($save_through_pages as $name) {
|
||
$hidden_fields['prev_' . ${"{$name}_key"}] = ${"{$name}_val"};
|
||
}
|
||
|
||
// Set colspan
|
||
$tor_colspan = $tor_colspan - $hide_cat - $hide_forum - $hide_author - $hide_speed;
|
||
|
||
$template->assign_vars(array(
|
||
'PAGE_TITLE' => $lang['TRACKER'],
|
||
'S_HIDDEN_FIELDS' => build_hidden_fields($hidden_fields),
|
||
'CAT_FORUM_SELECT' => $cat_forum_select,
|
||
'ORDER_SELECT' => build_select($order_key, $order_select, $order_val),
|
||
'TIME_SELECT' => build_select($time_key, $time_select, $time_val),
|
||
'S_NOT_SEEN_SELECT' => build_select($s_not_seen_key, $s_not_seen_select, $s_not_seen_val),
|
||
'S_RG_SELECT' => build_select($s_rg_key, $s_release_group_select, $s_rg_val),
|
||
'TOR_SEARCH_ACTION' => $tracker_url,
|
||
'TOR_COLSPAN' => $tor_colspan,
|
||
'TOR_STATUS' => $statuses ?? '',
|
||
'TITLE_MATCH_MAX' => $title_match_max_len,
|
||
'POSTER_NAME_MAX' => $poster_name_max_len,
|
||
'POSTER_ERROR' => $poster_error,
|
||
'SHOW_SEARCH_OPT' => (bool)$allowed_forums,
|
||
'SHOW_CAT' => $show_cat_val,
|
||
'SHOW_FORUM' => $show_forum_val,
|
||
'SHOW_AUTHOR' => $show_author_val,
|
||
'SHOW_SPEED' => $show_speed_val,
|
||
'MAX_FS' => $max_forums_selected,
|
||
'L_MAX_FS' => sprintf($lang['SEL_CHAPTERS_HELP'], $max_forums_selected),
|
||
'TRACKER_URL' => make_url('tracker.php?'),
|
||
|
||
'TR_CAT_URL' => "$tracker_url?$cat_key=",
|
||
'TR_FORUM_URL' => "$tracker_url?$forum_key=",
|
||
'TR_POSTER_URL' => "$tracker_url?$poster_id_key=",
|
||
));
|
||
|
||
print_page('tracker.tpl');
|