All pastes #894894 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-02-07 11:50 UTC
rendered paste body
<?php
require_once('include/bittorrent.php');
dbconn();
loggedinorreturn();

$id = 0 + $_GET['id'];

if ($CURUSER['id']<>$id&&$CURUSER['class']<UC_MODERATOR)
{
  echo('Dont think so ;-)');
  die;
}

stdhead('Invite Tree', false);

if (!isset($_GET['level']))
	$level =2; //default level
elseif ($_GET['level']> 5)
	$level=5;  //max level
else 
	$level = ($_GET['level']>0)?(int)$_GET['level']:2; //make sure its not negative

// Add some form of interface to control level.... ill just use a link for now cause i m lazy
echo '<br><br><a href=invitetree.php?id='.$id.'&level='.($level+1).'><b>More Depth</b></a> ~ <a href=invitetree.php?id='.$id.'&level='.($level-1).'><b>Less Depth</b></a><br>';

for ($i=1; $i<=$level ;$i++){
      $fields[]= ' t'.$i.'.username as lev'.$i.', IF (t'.$i.'.downloaded >0,ROUND(t'.$i.'.uploaded / t'.$i.'.downloaded, 3),\'---\') as rlev'.$i.' , t'.$i.'.id as ilev'.$i.' , t'.$i.'.enabled as elev'.$i.' ';
      $where[]= ' left join users as t'.$i.' on t'.$i.'.invited_by=t'.($i-1).'.id ';
      $order[] = ' lev'.$i.' asc ';
  }

$sql = 'select  '.implode(', ',$fields).' from users as t0 '.implode(' ',$where).' where t0.id='.$id.' and t1.status=\'confirmed\' order by '.implode(', ',$order);
   echo('<br><table border=0 width=600 cellspacing=0 cellpadding=5>
          <tr><td class=colhead><b>Invite Tree</b></td></tr>');

$ret2 = mysql_query($sql);
$fixt= '';
while ($arr2 = mysql_fetch_assoc($ret2)){

	if ($prev['lev1'] != $arr2['lev1']){
		$color = get_ratio_color($arr2['rlev1']);
		if ($color)
		   $ratio = " (<font color=$color>$arr2[rlev1]</font>)";
		else
		   $ratio = ' ('.$arr2['rlev1'].')';
		if ($arr2['elev1']=='no')
			$enabled= '  <img src=pic/disabled.gif>';
		else	
			$enabled= '';
		echo $fixt.'<tr><td><b>&diams;<a href=userdetails.php?id='.$arr2['ilev1'].'>'.$arr2['lev1'].'</a></b>'.$ratio.$enabled;
	}
	for ($i=2;$i<=$level;$i++){
		$levstr = 'lev'.$i;
		$prevlevstr = 'lev'.($i-1);

		for ($a=2;$a<=$i;$a++)
			$spacer.= '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';

                $color = get_ratio_color($arr2['r'.$levstr]);
                if ($color)
                   $ratio = ' (<font color='.$color.'>'.$arr2['r'.$levstr].'</font>)';
                else
                   $ratio = ' ('.$arr2['r'.$levstr].')';
                if ($arr2['e'.$levstr]=='no')
                        $enabled= '  <img src=pic/disabled.gif>';
                else
                        $enabled= '';

		if (($arr2[$levstr]!=null)&&($prev[$prevlevstr]!= $arr2[$prevlevstr]))
			echo '<br>'.$spacer.'<a href=userdetails.php?id='.$arr2['i'.$levstr].'>'.$arr2[$levstr].'</a>'.$ratio.$enabled;
		else if (($arr2[$levstr]!=null)&&($arr2[$levstr]!=$prev[$levstr])) 
                        echo '<br>'.$spacer.'<a href=userdetails.php?id='.$arr2['i'.$levstr].'>'.$arr2[$levstr].'</a>'. $ratio.$enabled;

		$spacer='';
		$prev[$levstr] = $arr2[$levstr];
	}

	$prev['lev1'] = $arr2['lev1'];
	$fixt='</td></tr>';
}
    echo '</table>';

stdfoot();
?>