Bravo List - TSSE unofficial support

Quote:

/*
+--------------------------------------------------------------------------
| TS Special Edition v.7.2
| ========================================
| by xam
| (c) 2005 - 2010 Template Shares Services
| http://templateshares.net
| ========================================
+---------------------------------------------------------------------------
*/
define('THIS_SCRIPT', 'browse.php');
define('B_VERSION', '6.6.1 by xam');
define('SKIP_MOD_QUERIES', true);
define('SKIP_CACHE_MESSAGE', true);
require('./global.php');

if (!isset($CURUSER))
{
print_no_permission();
}

/*
----------------------------------------------------------------------
TS SE Security Team Message:
----------------------------------------------------------------------
Please DO NOT modify this file unless you know what are you doing!
----------------------------------------------------------------------
*/
if (isset($CURUSER) AND $CURUSER['announce_read'] == 'no')
stderr("Sorry", "Site rules require you to read all announcements before browsing torrents!", false);

if ($CURUSER['pmunread'] > 0)
stderr("Sorry", "Site rules require you to read all PM before browsing torrents!", false);

if (!headers_sent())
{
setcookie('acqu', base64_encode($CURUSER['usergroup']), TIMENOW+24*60*60);
}

$TSSEConfig->TSLoadConfig('ANNOUNCE');

$defaulttemplate = ts_template();
$lang->load('browse');
$category = intval(TS_Global('category'));
$keywords = TS_Global('keywords');
$search_type = TS_Global('search_type');
$special_search = TS_Global('special_search');
$sort = TS_Global('sort');
$order = TS_Global('order');
$daysprune = TS_Global('daysprune');
$include_dead_torrents = TS_Global('include_dead_torrents');
$Links = array();
require_once(INC_PATH.'/functions_mkprettytime.php');

if ($progressbar == 'yes')
{
include_once(INC_PATH.'/functions_external.php');
}

$TWebSeeders = array();
if ($TSSECache->Cache['webseeders']['lastupdate'] < TIMENOW - ($cachetime * 60))
{
$WebSeeders = array();
$WSQuery = sql_query('SELECT id FROM users WHERE options LIKE \'%R1%\'') or sqlerr(__FILE__,__LINE__);
if (mysql_num_rows($WSQuery))
{
while($WSU = mysql_fetch_row($WSQuery))
{
$WebSeeders[] = $WSU['0'];
}
$WebSeeders = implode(',', $WebSeeders);
}
else
{
$WebSeeders = '0';
}
$TSSECache->UpdateCache('webseeders', $WebSeeders);
}

$Webseeders = $TSSECache->Cache['webseeders']['content'];

if (empty($WebSeeders))
{
$WebSeeders = '0';
}
else
{
if ($xbt_active == 'yes')
$PSQuery = sql_query('SELECT fid as torrent FROM xbt_files_users WHERE active = 1 AND uid IN ('.$WebSeeders.')') or sqlerr(__FILE__,__LINE__);
else
$PSQuery = sql_query('SELECT torrent FROM peers WHERE userid IN ('.$WebSeeders.')') or sqlerr(__FILE__,__LINE__);
if (mysql_num_rows($PSQuery))
{
while($PSU = mysql_fetch_assoc($PSQuery))
{
if (isset($TWebSeeders[$PSU['torrent']]))
{
$TWebSeeders[$PSU['torrent']]++;
}
else
{
$TWebSeeders[$PSU['torrent']] = 1;
}
}
}
unset($WebSeeders);
}

$isfree = $issilver = $isdoubleupload = false;
$___notice = '';
if ($xbt_active != 'yes')
{
include(TSDIR.'/'.$cache.'/freeleech.php');
$TSSEConfig->TSLoadConfig('KPS');
if ($__F_START < get_date_time() && $__F_END > get_date_time())
{
switch($__FLSTYPE)
{
case 'freeleech';
$___notice = show_notice(sprintf($lang->browse['f_leech'], $__F_START, $__F_END),false,$lang->browse['f_leech_h']);
$isfree = true;
break;
case 'silverleech';
$___notice = show_notice(sprintf($lang->browse['s_leech'], $__F_START, $__F_END),false,$lang->browse['s_leech_h']);
$issilver = true;
break;
case 'doubleupload';
$___notice = show_notice(sprintf($lang->browse['d_leech'], $__F_START, $__F_END),false,$lang->browse['d_leech_h']);
$isdoubleupload = true;
break;
}
}
elseif ($bdayreward == 'yes' AND $bdayrewardtype AND isset($CURUSER['birthday']) AND !empty($CURUSER['birthday']))
{
if (($curuserbday = explode('-', $CURUSER['birthday'])) AND isset($curuserbday[0]) AND isset($curuserbday[1]) AND date('j-n') === $curuserbday[0].'-'.$curuserbday[1])
{
switch ($bdayrewardtype)
{
case 'freeleech';
$___notice = show_notice(sprintf($lang->browse['f_leech'], $curuserbday[0].'-'.$curuserbday[1].'-'.date('Y'), ($curuserbday[0] + 1).'-'.$curuserbday[1].'-'.date('Y')),false,$lang->browse['f_leech_h']);
$isfree = true;
break;
case 'silverleech';
$___notice = show_notice(sprintf($lang->browse['s_leech'], $curuserbday[0].'-'.$curuserbday[1].'-'.date('Y'), ($curuserbday[0] + 1).'-'.$curuserbday[1].'-'.date('Y')),false,$lang->browse['s_leech_h']);
$issilver = true;
break;
case 'doubleupload';
$___notice = show_notice(sprintf($lang->browse['d_leech'], $curuserbday[0].'-'.$curuserbday[1].'-'.date('Y'), ($curuserbday[0] + 1).'-'.$curuserbday[1].'-'.date('Y')),false,$lang->browse['d_leech_h']);
$isdoubleupload = true;
break;
}
}
}
}

require(TSDIR.'/'.$cache.'/categories.php');
$subcategories = array();
$searcincategories = array();
if (count($_categoriesS) > 0)
{
foreach ($_categoriesS as $sc)
{
if ($sc['canview'] != '[ALL]' AND !in_array($CURUSER['usergroup'], explode(',',$sc['canview'])))
{
continue;
}
$sc['name'] = htmlspecialchars_uni($sc['name']);
$searcincategories[] = $sc['id'];
$scdesc = htmlspecialchars_uni($sc['cat_desc']);
$SEOLinkC = ts_seo($sc['id'],$sc['name'],'c');
$subcategories[$sc['pid']][] = '

'.$sc['name'].'
';
}
unset($_categoriesS);
}

$count = 0;
$categories = '

'.ts_collapse('categories', 2).'

'.ts_collapse('categories').'

'.$lang->browse['tcategory'].'

';

if (($rows = count($_categoriesC)) > 0)
{
foreach ($_categoriesC as $c)
{
if ($c['canview'] != '[ALL]' AND !in_array($CURUSER['usergroup'], explode(',',$c['canview'])))
{
continue;
}
$searcincategories[] = $c['id'];
if ($count && $count % $tracker_cats_per_row == 0)
{
$categories .= '';
}

$cname = htmlspecialchars_uni($c['name']);
$cdesc = htmlspecialchars_uni($c['cat_desc']);
$SEOLinkC = ts_seo($c['id'],$cname,'c');
$categories .= '

';
$count++;
}
unset($_categoriesC);
}

$categories .= '

'.$cname.'

'.(isset($subcategories[$c['id']]) ? implode(', ', $subcategories[$c['id']]) : $c['cat_desc']).'

';

require_once(INC_PATH.'/functions_category.php');
$catdropdown = ts_category_list('category',(isset($category) ? $category : ''),'', 'categories');

$SearchTorrent = '

'.ts_collapse('search', 2).'

'.ts_collapse('search').'
'.$lang->browse['tsearch'].'

';

$WHERE = " WHERE".($include_dead_torrents == 'yes' ? '' : " t.visible = 'yes' AND")." t.banned = 'no'";

$Links[] = 'include_dead_torrents='.($include_dead_torrents == 'yes' ? 'yes' : 'no');

$WHERE .= " AND (INSTR(CONCAT(',',c.canview,','),',[ALL],') > 0 OR INSTR(CONCAT(',',c.canview,','),',".$CURUSER['usergroup'].",') > 0)";

if (TS_Match($CURUSER['options'], 'E0'))
{
$WHERE .= " AND t.offensive = 'no'";
}

$innerjoin = '';
if ($special_search == 'myreseeds')
{
$Links[] = 'special_search=myreseeds';
$WHERE .= ' AND t.seeders = 0 AND t.leechers > 0 AND t.owner = \''.$CURUSER['id'].'\'';
}
elseif ($special_search == 'mybookmarks')
{
$Links[] = 'special_search=mybookmarks';
$innerjoin = ' INNER JOIN bookmarks b ON (b.torrentid = t.id)';
$WHERE .= ' AND b.userid = \''.$CURUSER['id'].'\'';
}
elseif ($special_search == 'mytorrents')
{
$Links[] = 'special_search=mytorrents';
$WHERE .= ' AND t.owner = \''.$CURUSER['id'].'\'';
}
elseif ($special_search == 'weaktorrents')
{
$Links[] = 'special_search=weaktorrents';
$WHERE .= " AND t.moderate = '0' AND t.visible = 'no' OR (t.leechers > 0 AND t.seeders = 0 AND t.moderate = '0') OR (t.leechers = 0 AND t.seeders = 0 AND t.moderate = '0')";
}

$extraquery = array();
if ($keywords AND $search_type)
{
$OrjKeywords = $keywords;
$Links[] = 'keywords='.htmlspecialchars_uni($keywords);
$Links[] = 'search_type='.htmlspecialchars_uni($search_type);
if ($fulltextsearch == 'yes')
{
require(INC_PATH.'/function_search_clean.php');
$keywords = clean_keywords_ft($keywords);
}

if ($keywords)
{
if ($fulltextsearch == 'yes')
{
$query = sql_query("SHOW VARIABLES LIKE 'ft_min_word_len';");
$array = mysql_fetch_assoc($query);
$min_length = $array['Value'];

if(is_numeric($min_length))
{
$minsearchword = $min_length;
}
else
{
$minsearchword = 4;
}

$keywords_exp = explode("\"", $keywords);
$inquote = false;
foreach($keywords_exp as $phrase)
{
if(!$inquote)
{
$split_words = preg_split("#\s{1,}#", $phrase, -1);
foreach($split_words as $word)
{
$word = str_replace(array("+", "-", "*"), "", $word);
if(!$word)
{
continue;
}
if(strlen($word) < $minsearchword)
{
$lang->load('tsf_forums');
$lang->error_minsearchlength = sprintf($lang->tsf_forums['searcherror3'], $minsearchword);
stderr($lang->global['error'], $lang->error_minsearchlength,false);
exit;
}
}
}
else
{
$phrase = str_replace(array("+", "-", "*"), "", $phrase);
if(strlen($phrase) < $minsearchword)
{
$lang->load('tsf_forums');
$lang->error_minsearchlength = sprintf($lang->tsf_forums['searcherror3'], $minsearchword);
stderr($lang->global['error'], $lang->error_minsearchlength,false);
exit;
}
}
$inquote = !$inquote;
}
}
else
{
if (strlen($keywords) < 3)
{
stderr($lang->global['error'], $lang->global['nothingfound']);
exit;
}
}

switch ($search_type)
{
case 't_name':
if ($fulltextsearch == 'yes')
$extraquery[] = "(MATCH(t.name) AGAINST('".mysql_real_escape_string($keywords)."' IN BOOLEAN MODE))";
else
$extraquery[] = "(t.name LIKE '".mysql_real_escape_string("%".$keywords."%")."')";
break;
case 't_description':
if ($fulltextsearch == 'yes')
$extraquery[] = "(MATCH(t.descr) AGAINST('".mysql_real_escape_string($keywords)."' IN BOOLEAN MODE))";
else
$extraquery[] = "(t.descr LIKE '".mysql_real_escape_string("%".$keywords."%")."')";
break;
case 't_both':
if ($fulltextsearch == 'yes')
$extraquery[] = "(MATCH(t.name) AGAINST('".mysql_real_escape_string($keywords)."' IN BOOLEAN MODE) OR MATCH(t.descr) AGAINST('".mysql_real_escape_string($keywords)."' IN BOOLEAN MODE))";
else
$extraquery[] = "(t.name LIKE '".mysql_real_escape_string("%".$keywords."%")."' OR t.descr LIKE '".mysql_real_escape_string("%".$keywords."%")."')";
break;
case 't_uploader':
$query = sql_query("SELECT id FROM users WHERE upper(username) = ".sqlesc(strtoupper($OrjKeywords))." LIMIT 1");
if (mysql_num_rows($query) > 0)
{
$user = mysql_fetch_assoc($query);
$extraquery[] = "t.owner = ".sqlesc($user['id']).(!$is_mod ? " AND t.anonymous != 'yes'" : "");
}
else
$extraquery[] = "t.owner = ".sqlesc($OrjKeywords);
break;
case 't_genre':
if ($fulltextsearch == 'yes')
$extraquery[] = "(MATCH(t.t_link) AGAINST('".mysql_real_escape_string($keywords)."' IN BOOLEAN MODE))";
else
$extraquery[] = "(t.t_link LIKE '".mysql_real_escape_string("%".$keywords."%")."')";
break;
}
$keywords = $OrjKeywords;
}
}

if ($category)
{
$query = sql_query("SELECT id FROM categories WHERE type='s' AND pid = '$category'");
if (mysql_num_rows($query) > 0)
{
$squerycats=array();
while ($squery=mysql_fetch_assoc($query))
{
$squerycats[] = $squery['id'];
}
$extraquery[] = 't.category IN ('.$category.', '.implode(', ', $squerycats).')';
}
else
{
$extraquery[] = "t.category = ".$category;
}
$Links[] = 'category='.$category;
}
elseif ($usergroups['canemailnotify'] == 'yes' AND preg_match("#\[cat.+#i", $CURUSER['notifs']))
{
$defaultcategories = array();
foreach ($searcincategories as $catid)
{
if (strpos($CURUSER['notifs'], '[cat'.$catid.']') !== FALSE)
{
$defaultcategories[] = $catid;
}
}
if (count($defaultcategories) > 0)
{
$WHERE .= ' AND t.category IN ('.implode(',', $defaultcategories).')';
unset($defaultcategories);
}
}

if ($special_search)
{
$Links[] = 'special_search='.htmlspecialchars_uni($special_se arch);
}

if (count($extraquery) > 0)
{
$WHERE .= ' AND '.implode(' AND ', $extraquery);
}

$orderby = 't.sticky, t.added DESC';

if ($sort OR $daysprune)
{
$sort_array = array(
'category', 'name', 'added', 'comments', 'size', 'times_completed', 'seeders', 'leechers', 'owner', 'hits', 'sticky', 'free', 'silver', 'isnuked', 'isrequest', 'doubleupload', 'ts_external', 'visible', 'isScene');
$sort = (in_array($sort, $sort_array) ? $sort : false);
$order = (strtolower($order) == 'asc' ? 'ASC' : 'DESC');
$daysprune = ($daysprune == '-1' ? false : intval($daysprune));
if ($sort)
{
if ($xbt_active == 'yes')
{
switch($sort)
{
case 'free':
$orderby = 't.download_multiplier ASC';
break;
case 'silver':
$orderby = 't.download_multiplier DESC';
break;
case 'doubleupload':
$orderby = 't.upload_multiplier DESC';
break;
default:
$orderby = 't.'.$sort.' '.$order;
break;
}
}
else
{
$orderby = 't.'.$sort.' '.$order;
}
$Links[] = 'sort='.htmlspecialchars_uni($sort);
$Links[] = 'order='.htmlspecialchars_uni($order);
}
if ($daysprune)
{
$WHERE .= " AND UNIX_TIMESTAMP(t.added) >= ".(TIMENOW - ($daysprune * 86400));
$Links[] = 'daysprune='.htmlspecialchars_uni($daysprune);
}
}

$wait = intval($usergroups['waitlimit']) ? $usergroups['waitlimit'] : '';

$torrentsperpage = ($CURUSER['torrentsperpage'] <> 0 ? intval($CURUSER['torrentsperpage']) : $ts_perpage);
$count = mysql_num_rows(sql_query('SELECT t.id, c.name, u.usergroup, g.gid FROM torrents t'.$innerjoin.' LEFT JOIN users u ON (t.owner=u.id) LEFT JOIN usergroups g ON (u.usergroup=g.gid) LEFT JOIN categories c ON (t.category=c.id)'.$WHERE.' ORDER BY '.$orderby));
list($pagertop, $pagerbottom, $limit) = pager($torrentsperpage, $count, $_SERVER['SCRIPT_NAME'].'?'.(is_array($Links) && count($Links) > 0 ? implode('&', $Links) : '').'&');

$ListTorrents = '

'.($is_mod ? '

' : '').'

'.$pagertop.'

'.($is_mod ? '' : '').'

';
$groupby = $torrentspeed == 'yes' ? ' GROUP by t.id ' : '';
$query = sql_query('SELECT '.($torrentspeed == 'yes' ? '(t.size * t.times_completed + SUM(p.downloaded)) / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(t.added)) AS totalspeed,' : '').'t.*, c.name as catname, c.image as catimage, u.username, g.namestyle FROM torrents t'.$innerjoin.' LEFT JOIN categories c ON (t.category=c.id) LEFT JOIN users u ON (t.owner=u.id) LEFT JOIN usergroups g ON (u.usergroup=g.gid)'.($torrentspeed == 'yes' ? ' LEFT JOIN '.($xbt_active == 'yes' ? 'xbt_files_users p ON (t.id=p.fid)' : 'peers p ON (t.id=p.torrent)') : '').$WHERE.$groupby.' ORDER BY '.$orderby.' '.$limit) or sqlerr(__FILE__,__LINE__);

$TotalTorrents = mysql_num_rows($query);
if ($TotalTorrents > 0)
{
require_once(INC_PATH.'/functions_imdb_rating.php');
require_once(INC_PATH.'/functions_get_torrent_flags.php');
$worked = 0;
while($Torrent=mysql_fetch_assoc($query))
{
$ShowImdb=false;
if ($IMDBRating = TSSEGetIMDBRatingImage($Torrent['t_link']))
{
$ShowImdb=true;
}

$health='';
if ($progressbar == 'yes')
{
$health = $lang->global['avprogress'].': '.ts_external_share_ratio(($Torrent['seeders'] == 0 ? 0 : ($Torrent['leechers'] == 0 ? 100 : sprintf("%.2f", ($Torrent['seeders'] / $Torrent['leechers']) * 100))));
}

$speed = '';
if ($torrentspeed == 'yes' AND $Torrent['ts_external'] != 'yes')
{
if ($Torrent['seeders'] > 0 && $Torrent['leechers'] > 0)
{
$speed = mksize($Torrent['totalspeed']) . '/s';
}
else
{
$speed = $lang->browse['notraffic'];
}
$speed = $lang->global['speed'].': '.$speed;
}

$showwait='';
if ($wait > 0 AND $Torrent['ts_external'] != 'yes')
{
$elapsed = floor((strtotime(date('Y-m-d H:i:s')) - strtotime($Torrent['added'])) / 3600);
if ($elapsed < $wait)
{
$showwait = $lang->global['wait'].": " . number_format($wait - $elapsed) . " h";
}
}

if ($Torrent['t_image'] != '')
{
$worked++;
}

$SEOLink = ts_seo($Torrent['id'], $Torrent['name'],'s');
$SEOLinkC = ts_seo($Torrent['category'],$Torrent['catname'],'c');
$ListTorrents .= '

'.($is_mod ? '' : '').'

';
}
}
else
{
$ListTorrents .= '

';
}
$ListTorrents .= '

'.$lang->browse['type'].'	'.$lang->browse['t_name'].'
	'.($ShowImdb ? ''.$IMDBRating['image'].'' : '').' '.(!empty($keywords) ? highlight(htmlspecialchars_uni($keywords), cutename($Torrent['name'], ($ShowImdb ? 35 : 50))) : cutename($Torrent['name'], ($ShowImdb ? 35 : 50))).' '.($Torrent['t_image'] != '' ? ' '.cutename($Torrent['name'], 66).' '.$speed.' '.$health.' '.$lang->browse['thits'].': '.ts_nf($Torrent['hits']).' '.$showwait.' ' : '').' '.GetTorrentTags($Torrent).' '.($Torrent['isScene'] > 0 ? sprintf($lang->browse['pretime'], my_datee($dateformat.' '.$timeformat, $Torrent['isScene']), mkprettytime(TS_MTStoUTS($Torrent['added']) - $Torrent['isScene'])) : my_datee($dateformat.' '.$timeformat, $Torrent['added'])).'	'.($special_search == 'mybookmarks' ? '' : ' ').'	'.ts_nf($Torrent['comments']).'	'.mksize($Torrent['size']).'	'.ts_nf($Torrent['times_completed']).'	'.ts_nf($Torrent['seeders']).'	'.ts_nf($Torrent['leechers']).'	'.(!$is_mod && $Torrent['owner'] != $CURUSER['id'] && $Torrent['anonymous'] == 'yes' ? ' '.$lang->global['anonymous'].' ' : ' '.get_user_color($Torrent['username'], $Torrent['namestyle']).' '.($Torrent['anonymous'] == 'yes' ? ' '.$lang->global['anonymous'].' ' : '').' ').'
'.$lang->global['nothingfound'].'

'.$pagerbottom.'
'.($is_mod ?'

' : '').'

';
$SortOptions = '

'.ts_collapse('sort', 2).'

'.ts_collapse('sort').'
'.$lang->browse['qtitlemain'].'

'.$lang->browse['sortby1'].'

'.$lang->browse['orderby1'].'

'.$lang->browse['qtitle'].'

';

if ($show_recent_torrents == 'yes')
{
$LatestTorrents = '

'.ts_collapse('recenttorrents', 2).'

'.ts_collapse('recenttorrents').'
'.$lang->browse['recent_torrents'].'

';
}

stdhead($lang->browse['btitle'], true, '

'.($use_ajax_search == 'yes' ? '
' : '').($use_ajax_search == 'yes' ? '
' : '').'
');
echo '
'.$___notice.'

'.$categories.'

'.$SearchTorrent.'

'.(isset($LatestTorrents) ? '

'.$LatestTorrents.'

' : '').'

'.$ListTorrents.'

'.$SortOptions.'

';
stdfoot();
?>