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 = "Yes ;)"; $connectable_color = "green"; }else{ $connectable = "Du bist nicht Connectable"; $connectable_color = "red"; } }else{ $connectable ="Keine Connections zur Zeit"; $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"] = ""; } ?>
|