Miscellany

		<?php
 if ($CURUSER)
 {
$res = mysql_query("SELECT downloaded FROM users WHERE id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
    $arr = mysql_fetch_row($res);
    $curuserdownloaded = $arr[0];
    $res = mysql_query("SELECT uploaded FROM users WHERE id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
    $arr = mysql_fetch_row($res);
    $curuseruploaded = $arr[0];
$ratio = ($curuserdownloaded > 0?number_format(($curuseruploaded + $curuserseederbonusupload) / $curuserdownloaded, 3):"Inf.");
$res99 = mysql_query("SELECT seedbonus FROM users WHERE id=$CURUSER[id]") or sqlerr(__FILE__, __LINE__);
$arr99 = mysql_fetch_assoc($res99);
$bonus = number_format($arr99['seedbonus'], 1);
//Messages
$res = mysql_query("SELECT COUNT(*) FROM `messages` WHERE `folder_in` AND `receiver`=" . $CURUSER["id"]) or die("0");
$arr = mysql_fetch_row($res);
$inbox = $arr[0];
$res = mysql_query("SELECT COUNT(*) FROM `messages` WHERE `folder_out` AND `sender`=" . $CURUSER["id"]) or die("0");
$arr = mysql_fetch_row($res);
$sentbox = $arr[0];
//connectable anzeige start
$res5 = mysql_query("SELECT connectable FROM peers WHERE userid=" . $CURUSER["id"] . "")or sqlerr(__FILE__, __LINE__);
if($row = mysql_fetch_row($res5)){
$connect = $row[0];
if($connect == "yes"){
$connectable = "<a title='Alles O.K! Gute Verbindung!'><b><font color=green>Yes ;)</a></font></b>";
$connectable_color = "green";
}else{
$connectable = "<b><a title='Wenn du ständig nicht connectable bist hast du Locale Probleme!'><font color=red>Du bist nicht Connectable</a></font></b>";
$connectable_color = "red";
}
}else{
$connectable ="<b><a title='Unbekannt'><font color=blue>Keine Connections zur Zeit</font></a></b>";
$connectable_color = "blue";
}


         $seedsarr = @mysql_fetch_assoc(mysql_query("SELECT COUNT(*) AS `cnt` FROM `peers` WHERE `userid`=" . $CURUSER["id"] . " AND `seeder`='yes'"));
        $seeds = $seedsarr["cnt"];
        $leechesarr = @mysql_fetch_assoc(mysql_query("SELECT COUNT(*) AS `cnt` FROM `peers` WHERE `userid`=" . $CURUSER["id"] . " AND `seeder`='no'"));
        $leeches = $leechesarr["cnt"];
		        $tlimits = get_torrent_limits($CURUSER);

        if ($ratio < 0.5) {
            $ratiowarn = " style=\"background-color:red;color:white;\"";
        } elseif ($ratio < 0.75) {
            $ratiowarn = " style=\"background-color:#FFFF00;color:black;\"";
        }

        if ($tlimits["seeds"] >= 0) {
            if ($tlimits["seeds"] - $seeds < 1)
                $seedwarn = " style=\"background-color:red;color:white;\"";
            $tlimits["seeds"] = " / " . $tlimits["seeds"];
        } else
            $tlimits["seeds"] = "";
        if ($tlimits["leeches"] >= 0) {
            if ($tlimits["leeches"] - $leeches < 1)
                $leechwarn = " style=\"background-color:red;color:white;\"";
            $tlimits["leeches"] = " / " . $tlimits["leeches"];
        } else
            $tlimits["leeches"] = "";
        if ($tlimits["total"] >= 0) {
            if ($tlimits["total"] - $leeches + $seeds < 1)
                $totalwarn = " style=\"background-color:red;color:white;\"";
            $tlimits["total"] = " / " . $tlimits["total"];
        } else
            $tlimits["total"] = "";
			}

?>

		<?php
 if ($CURUSER)
 { ?>

<table cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tablea">

  <tr>
   <td class="tablea"><table style="width:100%" cellspacing="0" cellpadding="0" border="0">
    <tr>
     <td class="bottom" align="left"><span class="smallfont"><b>Willkommen, </b>&nbsp; <b><a href="userdetails.php?id=<?=$CURUSER["id"]?>"><?=htmlspecialchars($CURUSER["username"])?></a></b>&nbsp; [<a href="logout.php">ausloggen</a>] <span class="Stil1"></span></span>&nbsp;&nbsp;
	 <a href="mybonus.php"><font color=orange><b>Seedbonus:</b>&nbsp;<?echo "$bonus";?></a></font><?php print(" <b><font color=\"$connectable_color\">Connectable:</font></b>  $connectable"); ?><br/>
	 <font color="#0000FF"><b>Ratio:&nbsp;</b></font><?echo "$ratio";?> </font> </font>&nbsp;&nbsp;
	  <font color="#00CC00"><b>Hochgeladen:</b></font> <font color=black><?=mksize($CURUSER["uploaded"])?> </font>&nbsp;&nbsp;
	  <font color=red><b>Runtergeladen:</b></font> <font color=black><?=mksize($CURUSER["downloaded"])?>  </font>&nbsp;&nbsp;
	  <font color=1900D1><b>Aktive Torrents:</b>&nbsp;</font> <?=($seeds + $leeches) . $tlimits["total"]?></span></font>&nbsp;&nbsp;
	  <img alt="Torrents seeding" title="Torrents seeding" src="pic/arrowup.gif"><?=$seeds . $tlimits["seeds"]?>
	   <img alt="Torrents leeching" title="Torrents leeching" src="pic/arrowdown.gif"><?=$leeches . $tlimits["leeches"]?>&nbsp;
	   <td style="text-align:right"><td style="text-align:right">
	   <?
            			print("&nbsp;&nbsp;&nbsp;<a href=friends.php><img style=border:none alt=Buddylist title=Buddylist src=pic/user.png></a>");

?>
 <td align="right">
                 <a href="messages.php?folder=-1" title="Inbox"><img src="pic/pm/pn2_inbox.gif" border="0"></a>&nbsp;(<?=$inbox?>) &nbsp;
                 <a href="messages.php?folder=-2" title="Outbox"w><img src="pic/pm/pn2_sentbox.gif" border="0"></a>&nbsp;(<?=$sentbox?>)&nbsp;
             </td>
</td>     </td>