##############################################################
## MOD : Stats MOD 
## MOD : Mile
## MOD : 1.0
## :        .
##  : Easy
##   : 5 Minutes
##   : 
##				includes/functions.php
##				includes/page_header.php
##				templates/default/page_header.tpl
##				templates/default/css/main.css
##
##  :  
##				
##				/templates/default/images/head/arrowdown.gif
##				/templates/default/images/head/arrowup.gif
##				/templates/default/images/head/arrowup2.gif
##				/templates/default/images/head/profile.png
##############################################################

# 
#-----[ COPY ]------------------------------------------------ 
#

copy   root/templates/default/images/head/arrowdown.gif  to   templates/default/images/head/arrowdown.gif
copy   root/templates/default/images/head/arrowup.gif  to   templates/default/images/head/arrowup.gif
copy   root/templates/default/images/head/arrowup2.gif  to   templates/default/images/head/arrowup2.gif
copy   root/templates/default/images/head/profile.png  to templates/default/images/head/profile.png

#
#-----[ OPEN ]------------------------------------------------
#

includes/page_header.php

#
#-----[ FIND ]------------------------------------------------
#

else
{
	$u_login_logout = BB_ROOT ."login.$phpEx";
}

#
#-----[ AFTER, ADD ]-----------------------------------------
#

show_bt_userdata_index($userdata['user_id']);

if ($bb_cfg['bt_show_dl_stat_on_index'] && !IS_GUEST)
{
	show_bt_userdata_index($userdata['user_id']);
}

$profile_user_id = $userdata['user_id'];

$seeding = $leeching = $releasing = array();

$sql = 'SELECT f.forum_id, f.forum_name, t.topic_title, tor.size,sn.seeders, sn.leechers, tr.*
	FROM '. FORUMS_TABLE .' f, '. TOPICS_TABLE .' t, '. BT_TRACKER_TABLE .' tr, '. BT_TORRENTS_TABLE .' tor, '. BT_TRACKER_SNAP_TABLE ." sn
	WHERE tr.user_id = $profile_user_id
		AND tr.topic_id = tor.topic_id
		AND sn.topic_id = tor.topic_id
		AND tor.topic_id = t.topic_id
		AND t.forum_id = f.forum_id
	GROUP BY tr.topic_id
	ORDER BY f.forum_name, t.topic_title";

if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query users torrent profile information', '', __LINE__, __FILE__, $sql);
}

if ($rowset = @$db->sql_fetchrowset($result))
{
	$db->sql_freeresult($result);
	$rowset_count = count($rowset);

	for ($i=0; $i<$rowset_count; $i++)
	{
		if ($rowset[$i]['releaser'])
		{
			$releasing[] = $rowset[$i];
		}
		else if ($rowset[$i]['seeder'])
		{
			$seeding[] = $rowset[$i];
		}
		else
		{
			$leeching[] = $rowset[$i];
		}
	}
	unset($rowset);
}

$releasing_count = count($releasing);
$seeding_count = count($seeding);
$leeching_count = count($leeching);



#
#-----[ FIND ]------------------------------------------------
#

'PRIVMSG_IMG'        => $icon_pm,

#
#-----[ AFTER, ADD ]-----------------------------------------
#

	'RELEASING'   => ($releasing_count) ? ($releasing_count)  : 0,
	'SEEDING'     => ($seeding_count) ? ($seeding_count)  : 0,
	'LEECHING'    => ($leeching_count) ?  ($leeching_count)  : 0,
	'AVATAR_IMG_INDEX' 		 => $userdata['user_avatar'] ? $userdata['user_avatar']: 'noavatar.png',

#
#-----[ OPEN ]------------------------------------------------
#

includes/functions.php

#
#-----[ FIND ]------------------------------------------------
#

function show_bt_userdata ($user_id)
{
	$btu = get_bt_userdata($user_id);

	$GLOBALS['template']->assign_vars(array(
		'SHOW_BT_USERDATA' => true,
		'UP_TOTAL'         => humn_size($btu['u_up_total']),
		'UP_BONUS'         => humn_size($btu['u_up_bonus']),
		'RELEASED'         => humn_size($btu['u_up_release']),
		'DOWN_TOTAL'       => humn_size($btu['u_down_total']),
		'DOWN_TOTAL_BYTES' => $btu['u_down_total'],
		'SEED_POINTS'      => $btu['seed_points'],
		'USER_RATIO'       => get_bt_ratio($btu),
		'MIN_DL_FOR_RATIO' => humn_size(MIN_DL_FOR_RATIO),
		'MIN_DL_BYTES'     => MIN_DL_FOR_RATIO,
		'AUTH_KEY'         => $btu['auth_key'],
	));
}

#
#-----[ AFTER, ADD ]-----------------------------------------
#


function show_bt_userdata_index ($user_id)
{
	$btu = get_bt_userdata($user_id);

	$GLOBALS['template']->assign_vars(array(
		'SHOW_BT_USERDATA1' => true,
		'UP_TOTAL1'         => humn_size($btu['u_up_total']),
		'UP_BONUS1'         => humn_size($btu['u_up_bonus']),
		'RELEASED1'         => humn_size($btu['u_up_release']),
		'DOWN_TOTAL1'       => humn_size($btu['u_down_total']),
		'DOWN_TOTAL_BYTES1' => $btu['u_down_total'],
		'SEED_POINTS1'      => $btu['seed_points'], //    -    
		'USER_RATIO1'       => get_bt_ratio($btu),
		'MIN_DL_FOR_RATIO1' => humn_size(MIN_DL_FOR_RATIO),
		'MIN_DL_BYTES1'     => MIN_DL_FOR_RATIO,
		'AUTH_KEY1'         => $btu['auth_key'],
	));
}



#
#-----[ OPEN ]------------------------------------------------
#

templates/default/page_header.tpl

#
#-----[ FIND ]------------------------------------------------
#

<!--/main_nav-->

#
#-----[ AFTER, ADD ]------------------------------------------------
#

      

<!--  Stats MOD on Index+ -->
<!-- IF LOGGED_IN -->
<div style="position: absolute; top: 25px; right: 1px;">
       <div id="user_ratio" >
       <table align="right" cellpadding="0">
		<tr><td><b>{L_YOUR_RATIO}</b></td><td><!-- IF DOWN_TOTAL_BYTES1 gt MIN_DL_BYTES1 --><b>{USER_RATIO1}</b><!-- ELSE --><b></b> (DL < {MIN_DL_FOR_RATIO1})<!-- ENDIF --></td></tr>
        <tr><td>{L_DOWNLOADED}</td><td class="leechmed"><b>{DOWN_TOTAL1}</b></td></tr>
        <tr><td>{L_UPLOADED}</td><td class="seedmed"><b>{UP_TOTAL1}</b></td></tr>
        <tr><td> </td><td class="seedmed">{RELEASED1}</td></tr>
        <tr><td></td><td class="seedmed">{UP_BONUS1}</td></tr>
<tr><tr><td nowrap> :</td><td class="seedmed"><b class="points">{SEED_POINTS1}</b>&nbsp;[<a class="med" href="profile.php?mode=bonus">{L_SEED_POINTS_EXCHANGE}</a>]</td></tr>
        <tr><td></td><td><span class="cursor_help" title=" ~  ."><img src=templates/default/images/head/arrowup.gif>{RELEASING}</span>  <span class="cursor_help" title=" ~    ."><img src=templates/default/images/head/arrowup2.gif>{SEEDING}</span>  <span class="cursor_help" title=" ~    ,       100% ..    ,      "><img src=templates/default/images/head/arrowdown.gif>{LEECHING}</span></td></tr>
         <div style="position: absolute; top: 18px; right: 227px;">
    <p class="avatar"><img src="images/avatars/{AVATAR_IMG_INDEX}" alt="" border="0" /></p></div>
				</table>
		</div>    </div>

<!-- ENDIF -->
<!--/ Stats MOD on Index+ -->

#
#-----[ OPEN ]------------------------------------------------
#

templates/default/css/main.css

#
#-----[ FIND ]------------------------------------------------
# 

   


#
#-----[ AFTER, ADD ]-----------------------------------------
#

.stata-table {
Margin-bottom: 2px !important;
height: 120px;
width: 333;
BackGround-Image: url(../images/head/profile.png);
BackGround-position: center center;
BackGround-Repeat: repeat-x;
}

.stata-table_park {
Margin-bottom: 2px !important;
height: 120px;
width: 333;
BackGround-Image: url(../images/head/profile_park.png);
BackGround-position: center center;
BackGround-Repeat: repeat-x;
}

#user_ratio {
padding: 2px 2px 2px 2px;
margin-top: 4px; 
margin-bottom: 4px;
height: 124px;
width: 341px;
background-image: url(../images/profile.png);
background-position: left top;
background-repeat: no-repeat;
}  
#user_ratio td {
padding: 0px 5px 0px 5px ; 
font-size: 11px;
}
