############################################################## ## Название: Статистика как на тапках ## Автор: Roman ## Адаптировал для TorrentPier II: TorrentPier.me,Bustra ## Может нужен кому. ## В принципе очень удобная весчь. ## Перед установкой обязательно делаем бекапы!!! ## ## Cложность установки: Легкая ## ## Время, необходимое для установки: ~ 1 минут ## ## Редактируемые файлы: ## includes/datastore/build_stats.php ## index.php ## templates/default/index.tpl ## language/lang_russian/lang_main.php ## language/lang_english/lang_main.php ## ############################################################## ## Перед установкой этого МОДА, Вы должны создать резервную копию всех файлов, относящихся к этому МОДУ ############################################################## # #-----[ ОТКРЫТЬ ]------------------------------------------ # includes/datastore/build_stats.php # #-----[ НАЙТИ ]------------------------------------------ # // Tracker stats if ($bb_cfg['tor_stats']) { // torrents stat $row = DB()->fetch_row("SELECT COUNT(topic_id) AS torrentcount, SUM(size) AS size FROM ". BB_BT_TORRENTS); $data['torrentcount'] = number_format($row['torrentcount']); $data['size'] = $row['size']; // peers stat $row = DB()->fetch_row("SELECT SUM(seeders) AS seeders, SUM(leechers) AS leechers, ((SUM(speed_up) + SUM(speed_down))/2) AS speed FROM ". BB_BT_TRACKER_SNAP); $data['seeders'] = number_format($row['seeders']); $data['leechers'] = number_format($row['leechers']); $data['peers'] = number_format($row['seeders'] + $row['leechers']); $data['speed'] = $row['speed']; } # #-----[ Заменить на: ]------------------------------------------ # // Tracker stats if ($bb_cfg['tor_stats']) { //up_down total $sql = "SELECT ROUND(SUM(u_up_total+u_down_total)) AS pumped, ROUND(SUM(u_up_total)) AS upl, ROUND(SUM(u_down_total)) AS donl FROM " . BB_BT_USERS; $row = DB()->fetch_row($sql); $data['total_dl_ul'] = $row['pumped']; $data['upload'] = $row['upl']; $data['download'] = $row['donl']; //up_down total end //active seeders begin $sql = 'SELECT COUNT(user_id) AS st FROM '. BB_BT_TRACKER .' WHERE seeder = 1'; $row = DB()->fetch_row($sql); $data['active_seeders'] = number_format($row['st']); //active seeders end //active leechers begin $sql = 'SELECT COUNT(user_id) AS lt FROM '. BB_BT_TRACKER .' WHERE seeder = 0'; $row = DB()->fetch_row($sql); $data['active_leechers'] = number_format($row['lt']); //active leechers end //active leechers begin $sql = 'SELECT COUNT(user_id) AS perv FROM '. BB_BT_TRACKER .''; $row = DB()->fetch_row($sql); $data['active_peers_all'] = number_format($row['perv']); //active leechers end //active seeders begin $sql = 'SELECT COUNT(DISTINCT user_id) AS stu FROM '. BB_BT_TRACKER .' WHERE seeder = 1'; $row = DB()->fetch_row($sql); $data['active_seeders_u'] = number_format($row['stu']); //active seeders end //active leechers begin $sql = 'SELECT COUNT(DISTINCT user_id) AS ltu FROM '. BB_BT_TRACKER .' WHERE seeder = 0'; $row = DB()->fetch_row($sql); $data['active_leechers_u'] = number_format($row['ltu']); //active leechers end //active torrents begin $sql = 'SELECT COUNT(DISTINCT tor.topic_id) AS tt , SUM(tor.size) AS ts FROM '. BB_BT_TRACKER .' tr , '. BB_BT_TORRENTS .' tor WHERE tr.topic_id = tor.topic_id'; $row = DB()->fetch_row($sql); $data['active_tor'] = number_format($row['tt']); $data['active_tor_size'] = $row['ts']; //active torrents end //all torrents begin $sql = ' SELECT COUNT(*) as tn, SUM(size) AS tos FROM '.BB_BT_TORRENTS; $row = DB()->fetch_row($sql); $data['all_tor'] = number_format($row['tn']); $data['all_tor_size'] = $row['tos']; //all torrents end // users speed $sql = 'SELECT sum(speed_up) AS s_ul, sum(speed_down) AS s_dl FROM bb_bt_tracker'; $row = DB()->fetch_row($sql); $data['s_ul'] = $row['s_ul']; $data['s_dl'] = $row['s_dl']; // users speed } # #-----[ ОТКРЫТЬ ]------------------------------------------ # index.php # #-----[ НАЙТИ и удалить ]------------------------------------------ # // Tracker stats 'TORRENTS_STAT' => sprintf($lang['Torrents_stat'], $stats['torrentcount'], humn_size($stats['size'])), 'PEERS_STAT' => sprintf($lang['Peers_stat'], $stats['peers'], $stats['seeders'], $stats['leechers']), 'SPEED_STAT' => sprintf($lang['Speed_stat'], humn_size($stats['speed']) .'/s'), # #-----[ НАЙТИ ]------------------------------------------ # define('SHOW_ONLINE', $show_online_users); # #-----[ ПОСЛЕ ВСТАВИТЬ ]------------------------------------------ # $template->assign_vars(array( 'UD_ALL' => ($bb_cfg['tor_stats']) ? humn_size($stats['total_dl_ul']) : '', 'UPL' => ($bb_cfg['tor_stats']) ? humn_size($stats['upload']) : '', 'S_UL' => ($bb_cfg['tor_stats']) ? humn_size($stats['s_ul']) : '', 'DNL' => ($bb_cfg['tor_stats']) ? humn_size($stats['download']) : '', 'S_DL' => ($bb_cfg['tor_stats']) ? humn_size($stats['s_dl']) : '', 'ST' => ($bb_cfg['tor_stats']) ? $stats['active_seeders'] : '', 'LT' => ($bb_cfg['tor_stats']) ? $stats['active_leechers'] : '', 'STU' => ($bb_cfg['tor_stats']) ? $stats['active_seeders_u'] : '', 'LTU' => ($bb_cfg['tor_stats']) ? $stats['active_leechers_u'] : '', 'PERV' => ($bb_cfg['tor_stats']) ? $stats['active_peers_all'] : '', 'TT' => ($bb_cfg['tor_stats']) ? $stats['active_tor'] : '', 'TS' => ($bb_cfg['tor_stats']) ? humn_size($stats['active_tor_size']) : '', 'TN' => ($bb_cfg['tor_stats']) ? $stats['all_tor'] : '', 'TOS' => ($bb_cfg['tor_stats']) ? humn_size($stats['all_tor_size']) : '', )); # #-----[ ОТКРЫТЬ ]------------------------------------------ # templates/default/index.tpl # #-----[ НАЙТИ ]------------------------------------------ #

{TORRENTS_STAT}

{PEERS_STAT}

{SPEED_STAT}

# #-----[ Заменить на: ]------------------------------------------ # {L_STATISTICS_TRACKER_S}
{L_SEEDING_S} {STU} ({S_UL}/s)
{L_DLDOWN_2} {LTU} ({S_DL}/s)
{L_TORRENT_S} {TT} {TOS}
{L_TORRENT_D2} {UPL}
{L_TORRENT_S2} {DNL}
{L_TORRENT_FULL} {TS}
{L_PEERS_FULL} {PERV}
Seeders: {ST}
Leechers: {LT}
# #-----[ ОТКРЫТЬ ]------------------------------------------ # language/lang_russian/lang_main.php # #-----[ НАЙТИ ]------------------------------------------ # ?> # #-----[ ПОСЛЕ ВСТАВИТЬ ]------------------------------------------ # // // Статистика как на тапках // $lang['STATISTICS_TRACKER_S'] = 'Статистика по трекеру:'; $lang['SEEDING_S'] = 'Раздают:'; $lang['DLDOWN_2'] = 'Качают:'; $lang['TORRENT_S'] = 'Торрентов:'; $lang['TORRENT_D2'] = 'Через трекер отдано:'; $lang['TORRENT_S2'] = 'Через трекер скачано:'; $lang['TORRENT_FULL'] = 'Объем всех торрентов:'; $lang['PEERS_FULL'] = 'Пиров всего:'; # #-----[ ОТКРЫТЬ ]------------------------------------------ # language/lang_english/lang_main.php # #-----[ НАЙТИ ]------------------------------------------ # ?> # #-----[ ПОСЛЕ ВСТАВИТЬ ]------------------------------------------ # // // Статистика как на тапках // $lang['STATISTICS_TRACKER_S'] = 'Statistics on the tracker:'; $lang['SEEDING_S'] = 'Seeding:'; $lang['DLDOWN_2'] = 'Leeching:'; $lang['TORRENT_S'] = 'Torrents:'; $lang['TORRENT_D2'] = 'Seeding through tracker:'; $lang['TORRENT_S2'] = 'Leeching through tracker:'; $lang['TORRENT_FULL'] = 'Total size of torrents:'; $lang['PEERS_FULL'] = 'Peers:'; # #-----[ СОХРАНИТЬ/ЗАКРЫТЬ ВСЕ ФАЙЛЫ ]------------------------------------------ # # КОНЕЦ!