session_start(array('req_login' => true));
$page_cfg['use_tablesorter'] = true;
if(isset($_GET['u']) && @$_GET['u'] != $userdata['user_id'] && IS_AM)
{
$user_id= (int) $_GET['u'];
}
else
{
$user_id = $userdata['user_id'];
}
$i = $upload_all = $download_all = $bonus_all = $download_torrent_all = 0;
$user_info = get_username_from_id($user_id);
$sql = "SELECT ta.*, t.topic_title, f.forum_name, f.forum_id, tor.tor_type, tor.tor_status
FROM bb_bt_torrent_activity ta
LEFT JOIN bb_topics t ON(t.topic_id = ta.topic_id)
LEFT JOIN bb_forums f ON(f.forum_id = t.forum_id)
LEFT JOIN bb_bt_torrents tor ON(tor.topic_id = ta.topic_id)
WHERE ta.user_id = $user_id
ORDER BY f.forum_name, t.topic_title";
if (!$result = DB()->sql_query($sql))
{
bb_die('Ваша история закачек пуста');
}
while ($row = DB()->sql_fetchrow($result))
{
$upload_all += $row['torrent_upload'];
$download_all += $row['torrent_download'];
$download_torrent_all += $row['torrent_all_download'];
$bonus_all += $row['torrent_bonus'];
if($row['torrent_download'] > 0)
{
$pre_ratio = round($row['torrent_upload'] / $row['torrent_download'], 2);
if($pre_ratio != 0 && $pre_ratio < 1)
{
$ratio = ''.$pre_ratio.'';
$ratio_dgt = $pre_ratio;
}
if($pre_ratio == 0 || $pre_ratio > 1000)
{
$ratio = '∞';
$ratio_dgt = 0;
}
if($pre_ratio != 0 && $pre_ratio > 1 && $pre_ratio <= 1000 )
{
$ratio = ''.$pre_ratio.'';
$ratio_dgt = $pre_ratio;
}
}
else
{
$ratio = '∞';
$ratio_dgt = 0;
}
$is_gold = '';
if (isset($row['tor_type']))
{
if ($row['tor_type'] == TOR_TYPE_GOLD)
{
$is_gold = '
';
}
elseif ($row['tor_type'] == TOR_TYPE_SILVER)
{
$is_gold = '
';
}
}
$template->assign_block_vars('history', array(
'ROW_CLASS' => !($i % 2) ? 'row2' : 'row1',
'FORUM_URL' => ($row['forum_id']) ? ''.htmlCHR($row['forum_name']).'' : '---',
'TOPIC_URL' => ($row['topic_title']) ? ''.$row['topic_title'].'' : 'Топик удален',
'TORRENT_UP' => humn_size($row['torrent_upload']),
'TORRENT_UP_B' => $row['torrent_upload'],
'TORRENT_DOWN' => humn_size($row['torrent_download']),
'TORRENT_DOWN_B' => $row['torrent_download'],
'TORRENT_ALL_DOWN' => humn_size($row['torrent_all_download']),
'TORRENT_ALL_DOWN_B' => $row['torrent_all_download'],
'TORRENT_RATIO' => $ratio,
'TORRENT_RATIO_DGT' => $ratio_dgt,
'TORRENT_BONUS' => humn_size($row['torrent_bonus']),
'TORRENT_BONUS_B' => $row['torrent_bonus'],
'TORRENT_TIME' => delta_time(0, $row['torrent_time']),
'TORRENT_TIME_DGT' => ($row['torrent_time']) ? $row['torrent_time'] : 0,
'TORRENT_TYPE' => $is_gold,
'TORRENT_STATUS' => $row['tor_status'],
'TORRENT_TIME_ST' => ($row['torrent_time_st']) ? create_date($bb_cfg['default_dateformat'], $row['torrent_time_st'], $userdata['user_timezone']) : '--',
'TORRENT_TIME_ST_DGT' => ($row['torrent_time_st']) ? $row['torrent_time_st'] : 0,
));
}
$template->assign_vars(array(
'SUM_UP' => humn_size($upload_all),
'SUM_DOWN' => humn_size($download_all),
'SUM_ALL_DOWN' => humn_size($download_torrent_all),
'SUM_BONUS' => humn_size($bonus_all),
'USER_INFO' => $user_info['username'],
'PAGE_TITLE' => 'История активности на трекере',
));
print_page('activity_tr.tpl');