Какво означава този код ?

raio · 9 Юли 2010

Отговор на сървъра MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 И може ли да се оправи ?

stonybg · 9 Юли 2010

дай кода де

да не гадаем на боб

ExpressYourself · 9 Юли 2010

Преди да напишеш LIMIT 1 при изброяването си забраил ` или ' :?:

raio · 9 Юли 2010

Това ще рече, че някой от файловете ми не е как трябва така ли ? а не, че хамп дава грешка ?

ExpressYourself · 9 Юли 2010

raio каза:
Това ще рече, че някой от файловете ми не е как трябва така ли ? а не, че хамп дава грешка ?

Дай си кода.. Колкото и да ти обеснявам трябва да си чел поне малко, за да разбереш за какво става въпрос ;]
Изброявал си елементи от MySQL и докати си ги изброявал, `promenliva`='$promenliva' или (`promenliva`) VALUES ('$promenliva') си изпуснал кавичка ` или '

misho · 9 Юли 2010

Това ще рече, че има грешка в MySQL заявка в страницата, където дава грешката. Виж кое последно си променял! Дай кода тук!

bancov96 · 9 Юли 2010

Дай кода на файла, в който ти дава тази грешка!

raio · 9 Юли 2010

Eто мисля, че от този файл дава тази грешка

Код:

<?

/*
// +--------------------------------------------------------------------------+
// | Project:    TBDevYSE - TBDev Yuna Scatari Edition                        |
// +--------------------------------------------------------------------------+
// | This file is part of TBDevYSE. TBDevYSE is based on TBDev,               |
// | originally by RedBeard of TorrentBits, extensively modified by           |
// | Gartenzwerg.                                                             |
// |                                                                          |
// | TBDevYSE is free software; you can redistribute it and/or modify         |
// | it under the terms of the GNU General Public License as published by     |
// | the Free Software Foundation; either version 2 of the License, or        |
// | (at your option) any later version.                                      |
// |                                                                          |
// | TBDevYSE is distributed in the hope that it will be useful,              |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of           |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            |
// | GNU General Public License for more details.                             |
// |                                                                          |
// | You should have received a copy of the GNU General Public License        |
// | along with TBDevYSE; if not, write to the Free Software Foundation,      |
// | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA            |
// +--------------------------------------------------------------------------+
// |                                               Do not remove above lines! |
// +--------------------------------------------------------------------------+
*/

require "include/bittorrent.php";

dbconn(false);
  if (get_user_class() < UC_USER)
  stderr("Ãðåøêà", "Âèå íÿìàòå íóæíèòå ïðàâà çà ðàçãëåæäàíå íà ñòðàíèöàòà! Òðÿáâà äà ñòå ñ ðàíã íå ïî íèñúê îò Ñóïåð Ïîòðåáèòåë!");
loggedinorreturn();
//start mod invisible 
if (get_user_class() == UC_SYSOP) {
$uid = $_GET['id'];
if ($_GET['invisible'] == "yes") {
mysql_query("update users set invisible='yes' where id=".sqlesc($uid)."") or sqlerr(__FILE__,__LINE__);
}
if ($_GET['invisible'] == "no") {
mysql_query("update users set invisible='no' where id=".sqlesc($uid)."") or sqlerr(__FILE__,__LINE__);
}
}
//end mod invisible  
getpage();

function bark($msg) {
	global $tracker_lang;
	stdhead($tracker_lang['error']);
	stdmsg($tracker_lang['error'], $msg);
	stdfoot();
	exit;
}

function maketable($res)
{
  global $tracker_lang, $use_ttl, $ttl_days;
  $ret = "<table class=main border=1 cellspacing=0 cellpadding=5>" .
    "<tr><td class=colhead align=left>".$tracker_lang['type']."</td><td class=colhead>".$tracker_lang['name']."</td>".($use_ttl ? "<td class=colhead align=center>".$tracker_lang['ttl']."</td>" : "")."<td class=colhead align=center>".$tracker_lang['size']."</td><td class=colhead align=right>".$tracker_lang['details_seeding']."</td><td class=colhead align=right>".$tracker_lang['details_leeching']."</td><td class=colhead align=center>".$tracker_lang['uploaded']."</td>\n" .
    "<td class=colhead align=center>".$tracker_lang['downloaded']."</td><td class=colhead align=center>".$tracker_lang['ratio']."</td></tr>\n";
  while ($arr = mysql_fetch_assoc($res))
  {
    if ($arr["downloaded"] > 0)
    {
      $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3);
      $ratio = "<font color=" . get_ratio_color($ratio) . ">$ratio</font>";
    }
    else
      if ($arr["uploaded"] > 0)
        $ratio = "Inf.";
      else
        $ratio = "---";
    $catid = $arr["catid"];
	$catimage = htmlspecialchars($arr["image"]);
	$catname = htmlspecialchars($arr["catname"]);
	$ttl = ($ttl_days*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600);
	if ($ttl == 1) $ttl .= " ÷àñ"; else $ttl .= " ÷àña";
	$size = str_replace(" ", "<br />", mksize($arr["size"]));
	$uploaded = str_replace(" ", "<br />", mksize($arr["uploaded"]));
	$downloaded = str_replace(" ", "<br />", mksize($arr["downloaded"]));
	$seeders = number_format($arr["seeders"]);
	$leechers = number_format($arr["leechers"]);
    $ret .= "<tr><td style='padding: 0px'><a href=\"browse.php?cat=$catid\"><img src=\"pic/cats/$catimage\" alt=\"$catname\" border=\"0\" /></a></td>\n" .
		"<td><a href=details.php?id=$arr[torrent]&hit=1><b>" . $arr["torrentname"] .
		"</b></a></td>".($use_ttl ? "<td align=center></td>" : "")."<td align=center>$size</td><td align=right>$seeders</td><td align=right>$leechers</td><td align=center>$uploaded</td>\n" .
		"<td align=center>$downloaded</td><td align=center>$ratio</td></tr>\n";
  }
  $ret .= "</table>\n";
  return $ret;
}

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

if (!is_valid_id($id))
  bark($tracker_lang['invalid_id']);

$r = @sql_query("SELECT * FROM users WHERE id=$id") or sqlerr(__FILE__, __LINE__);
$user = mysql_fetch_array($r) or bark("Íÿìà ïîòðåáèòåë ñ òàêîâà ID $id.");
if ($user["status"] == "pending") die;
$r = sql_query("SELECT torrents.id, torrents.name, torrents.seeders, torrents.added, torrents.leechers, torrents.category, categories.name AS catname, categories.image AS catimage, categories.id AS catid FROM torrents LEFT JOIN categories ON torrents.category = categories.id WHERE owner=$id ORDER BY name") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($r) > 0) {
  $torrents = "<table class=main border=1 cellspacing=0 cellpadding=5>\n" .
    "<tr><td class=colhead>".$tracker_lang['type']."</td><td class=colhead>".$tracker_lang['name']."</td>".($use_ttl ? "<td class=colhead align=center></td>" : "")."<td class=colhead>".$tracker_lang['tracker_seeders']."</td><td class=colhead>".$tracker_lang['tracker_leechers']."</td></tr>\n";
  while ($a = mysql_fetch_assoc($r)) {
	$ttl = ($ttl_days*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($a["added"])) / 3600);
	if ($ttl == 1) $ttl .= " ÷àñ"; else $ttl .= " ÷àñîâ";
		//$r2 = sql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
		//$a2 = mysql_fetch_assoc($r2);
		$cat = "<a href=\"browse.php?cat=$a[catid]\"><img src=\"pic/cats/$a[catimage]\" alt=\"$a[catname]\" border=\"0\" /></a>";
      $torrents .= "<tr><td style='padding: 0px'>$cat</td><td><a href=\"details.php?id=" . $a["id"] . "&hit=1\"><b>" . $a["name"] . "</b></a></td>"
      	.($use_ttl ? "<td align=center></td>" : "")
        ."<td align=right>$a[seeders]</td><td align=right>$a[leechers]</td></tr>\n";
  }
  $torrents .= "</table>";
}

$it = sql_query("SELECT u.id, u.username, u.class, i.id AS invitedid, i.username AS invitedname, i.class AS invitedclass FROM users AS u LEFT JOIN users AS i ON i.id = u.invitedby WHERE u.invitedroot = $id OR u.invitedby = $id ORDER BY u.invitedby");
if (mysql_num_rows($it) >= 1) {
	$invitetree = "<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\"><tr>".
		"<td class=\"colhead\">Ïîëüçîâàòåëü</td><td class=\"colhead\">Ïîêàíèë</td>";
	while ($inviter = mysql_fetch_array($it))
		$invitetree .= "<tr><td><a href=\"userdetails.php?id=$inviter[id]\">".get_user_class_color($inviter["class"], $inviter["username"])."</a></td><td><a href=\"userdetails.php?id=$inviter[invitedid]\">".get_user_class_color($inviter["invitedclass"], $inviter["invitedname"])."</a></td></tr>";
	$invitetree .= "</table>";
}

if ($user["ip"] && (get_user_class() >= UC_MODERATOR || $user["id"] == $CURUSER["id"])) {
  $ip = $user["ip"];
  $dom = @gethostbyaddr($user["ip"]);
  if ($dom == $user["ip"] || @gethostbyname($dom) != $user["ip"])
    $addr = $ip;
  else
  {
    $dom = strtoupper($dom);
    $domparts = explode(".", $dom);
    $domain = $domparts[count($domparts) - 2];
    if ($domain == "COM" || $domain == "CO" || $domain == "NET" || $domain == "NE" || $domain == "ORG" || $domain == "OR" )
      $l = 2;
    else
      $l = 1;
    $addr = "$ip ($dom)";
  }
}

$r = mysql_query("SELECT snatched.torrent AS id, snatched.uploaded, snatched.seeder, snatched.downloaded, snatched.startdat, snatched.completedat, snatched.last_action, categories.name AS catname, categories.image AS catimage, categories.id AS catid, torrents.name, torrents.seeders, torrents.leechers FROM snatched JOIN torrents ON torrents.id = snatched.torrent JOIN categories ON torrents.category = categories.id WHERE snatched.finished='yes' AND userid = $id ORDER BY torrent") or sqlerr(__FILE__,__LINE__);
if (mysql_num_rows($r) > 0) {
$completed = "<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\">\n" .
  "<tr><td class=\"colhead\">Òèï</td><td class=\"colhead\">Èìå</td><td class=\"colhead\">Êà÷èë</td><td class=\"colhead\">Ñâàëèë</td><td class=\"colhead\">Êà÷èë</td><td class=\"colhead\">Ñâàëèë</td><td class=\"colhead\">Ðåéòèíã</td><td class=\"colhead\">Çàïî÷íàë / Çàâúðøèë</td><td class=\"colhead\">Äåéñòâèå</td><td class=\"colhead\">Ñèéäâàù</td></tr>\n";
while ($a = mysql_fetch_array($r)) {
if ($a["downloaded"] > 0) {
      $ratio = number_format($a["uploaded"] / $a["downloaded"], 3);
      $ratio = "<font color=\"" . get_ratio_color($ratio) . "\">$ratio</font>";
   } else
	if ($a["uploaded"] > 0)
        $ratio = "Inf.";
	else
		$ratio = "---";
$uploaded = mksize($a["uploaded"]);
$downloaded = mksize($a["downloaded"]);
if ($a["seeder"] == 'yes')
	$seeder = "<font color=\"green\">Äà</font>";
else
	$seeder = "<font color=\"red\">Íåò</font>";
	$cat = "<a href=\"browse.php?cat=$a[catid]\"><img src=\"pic/cats/$a[catimage]\" alt=\"$a[catname]\" border=\"0\" /></a>";
    $completed .= "<tr><td style=\"padding: 0px\">$cat</td><td><nobr><a href=\"details.php?id=" . $a["id"] . "&hit=1\"><b>" . $a["name"] . "</b></a></nobr></td>" .
      "<td align=\"right\">$a[seeders]</td><td align=\"right\">$a[leechers]</td><td align=\"right\">$uploaded</td><td align=\"right\">$downloaded</td><td align=\"center\">$ratio</td><td align=\"center\"><nobr>$a[startdat]<br />$a[completedat]</nobr></td><td align=\"center\"><nobr>$a[last_action]</nobr></td><td align=\"center\">$seeder</td>\n";
}
$completed .= "</table>";
}

if ($user[added] == "0000-00-00 00:00:00")
	$joindate = 'N/A';
else
	$joindate = "$user[added] (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($user["added"])) . " ".$tracker_lang['ago'].")";
$lastseen = $user["last_access"];
if ($lastseen == "0000-00-00 00:00:00")
	$lastseen = $tracker_lang['never'];
else {
  $lastseen .= " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($lastseen)) . " ".$tracker_lang['ago'].")";
}
  $res = sql_query("SELECT COUNT(*) FROM comments WHERE user = " . $user[id]) or sqlerr(__FILE__, __LINE__);
  $arr3 = mysql_fetch_row($res);
  $torrentcomments = $arr3[0];

  

//if ($user['donated'] > 0)
//  $don = "<img src=pic/starbig.gif>";

$res = sql_query("SELECT name, flagpic FROM countries WHERE id = $user[country] LIMIT 1") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 1)
{
  $arr = mysql_fetch_assoc($res);
  $country = "<td class=\"embedded\"><img src=\"pic/flag/$arr[flagpic]\" alt=\"$arr[name]\" style=\"margin-left: 8pt\"></td>";
}
 $res = mysql_query("SELECT name,image FROM groups WHERE id=".$user["groups"]." LIMIT 1") or sqlerr();  
if (mysql_num_rows($res) == 1)   
{   
 $arr = mysql_fetch_assoc($res);   
 $groups = "<img src=\"/pic/groups/".$arr["image"]."\" alt=\"".$arr["name"]."\"> ";   
}  
//if ($user["donor"] == "yes") $donor = "<td class=embedded><img src=pic/starbig.gif alt='Donor' style='margin-left: 4pt'></td>";
//if ($user["warned"] == "yes") $warned = "<td class=embedded><img src=pic/warnedbig.gif alt='Warned' style='margin-left: 4pt'></td>";

if ($user["gender"] == "1") $gender = "<img src=\"".$pic_base_url."male.gif\" alt=\"Ìúæ\" title=\"Ìúæ\">";
elseif ($user["gender"] == "2") $gender = "<img src=\"".$pic_base_url."female.gif\" alt=\"Æåíà\" title=\"Æåíà\">";
//elseif ($user["gender"] == "Í/Ä") $gender = "<td class=embedded><img src=".$pic_base_url."na.gif alt='Í/Ä' style='margin-left: 4pt'></td>";

$res = sql_query("SELECT torrent, added, uploaded, downloaded, torrents.name AS torrentname, categories.name AS catname, categories.id AS catid, size, image, category, seeders, leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid = $id AND seeder='no'") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) > 0)
  $leeching = maketable($res);
$res = sql_query("SELECT torrent, added, uploaded, downloaded, torrents.name AS torrentname, categories.name AS catname, categories.id AS catid, size, image, category, seeders, leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid = $id AND seeder='yes'") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) > 0)
  $seeding = maketable($res);
/// MOD KUBOK///
if ($user['kubok1'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok1.gif\" alt=\"Íàãðàäà çà ïîñòîÿíåí ñèèä\" title=\"Íàãðàäà çà ïîñòîÿíåí ñèèä\">";
if ($user['kubok2'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok2.gif\" alt=\"Íàãðàäà çà êà÷åí óíèêàëåí òîðåíò\" title=\"Íàãðàäà çà êà÷åí óíèêàëåí òîðåíò\">";
if ($user['kubok3'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok3.gif\" alt=\"Íàãðàäà çà ñóïåð îïèñàíèå\" title=\"Íàãðàäà çà ñóïåð îïèñàíèå\">";
if ($user['kubok4'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok4.gif\" alt=\"Íàãðàäà çà àêòèâíîñò âúâ ôîðóìà\" title=\"Íàãðàäà çà àêòèâíîñò âúâ ôîðóìà\">";
if ($user['kubok5'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok5.gif\" alt=\"Íàãðàäà çà áðîé êà÷åíè òîðåíòè\" title=\"Íàãðàäà çà áðîé êà÷åíè òîðåíòè\">";
if ($user['kubok6'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok6.gif\" alt=\"Íàãðàäà çà íàé-àêòèâåí úïëîóäåð\" title=\"Íàãðàäà çà íàé-àêòèâåí úïëîóäåð\">";
if ($user['nagrada1'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada1.gif\" alt=\"Íàãðàäà çà ïðèíîñ êúì ñàéòà\" title=\"Íàãðàäà çà ïðèíîñ êúì ñàéòà\">";
if ($user['nagrada2'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada2.gif\" alt=\"Íàãðàäà çà ïîìîù êúì îñòàíàëèòå ïîòðåáèòåëè\" title=\"Íàãðàäà çà ïîìîù êúì îñòàíàëèòå ïîòðåáèòåëè\">";
if ($user['nagrada3'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada3.gif\" alt=\"Íàãðàäà çà îáåêòèâåí êîìåíòàð êúì òîðåíò\" title=\"Íàãðàäà çà îáåêòèâåí êîìåíòàð êúì òîðåíò\">";
/// MOD KUBOK/// 
///////////////// BIRTHDAY MOD /////////////////////
if ($user[birthday] != "0000-00-00")
{
        //$current = date("Y-m-d", time());
        $current = date("Y-m-d", time() + $CURUSER['tzoffset'] * 60);
        list($year2, $month2, $day2) = split('-', $current);
        $birthday = $user["birthday"];
        $birthday = date("Y-m-d", strtotime($birthday));
        list($year1, $month1, $day1) = split('-', $birthday);
        if($month2 < $month1)
        {
                $age = $year2 - $year1 - 1;
        }
        if($month2 == $month1)
        {
                if($day2 < $day1)
                {
                        $age = $year2 - $year1 - 1;
                }
                else
                {
                        $age = $year2 - $year1;
                }
        }
        if($month2 > $month1)
        {
                $age = $year2 - $year1;
        }

}
///////////////// BIRTHDAY MOD /////////////////////

stdhead("Ïðîñìîòð ïðîôèëÿ " . $user["username"]);
$enabled = $user["enabled"] == 'yes';
print("<p><table class=\"main\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">".
"<tr><td class=\"embedded\"><h1 style=\"margin:0px\">$user[username]" . get_user_icons($user, true) . "</h1></td>$country</tr></table></p>\n");

if (!$enabled)
  print("<p><b>Ýòîò àêêàóíò îòêëþ÷åí</b></p>\n");
elseif ($CURUSER["id"] <> $user["id"]) {
  $r = sql_query("SELECT id FROM friends WHERE userid=$CURUSER[id] AND friendid = $id") or sqlerr(__FILE__, __LINE__);
  $friend = mysql_num_rows($r);
  $r = sql_query("SELECT id FROM blocks WHERE userid=$CURUSER[id] AND blockid = $id") or sqlerr(__FILE__, __LINE__);
  $block = mysql_num_rows($r);
if ($user["class"] < UC_MODERATOR || $CURUSER["class"] >= UC_MODERATOR)
  if ($friend)
    print("<p>(<a href=\"friends.php?action=delete&type=friend&targetid=$id\">Ìàõíè îò ïðèÿòåëè</a>)</p>\n");
  elseif($block)
    print("<p>(<a href=\"friends.php?action=delete&type=block&targetid=$id\">Ìàõíè îò áëîêèðàíè</a>)</p>\n");
  else
  {
    print("<p>(<a href=\"friends.php?action=add&type=friend&targetid=$id\">Äîáàâè â ïðèÿòåëè</a>)");
    print(" - (<a href=\"friends.php?action=add&type=block&targetid=$id\">Äîáàâè â áëîêèðàíè</a>)</p>\n");
  }
}
  if ($user["pcoff"] == 'yes')
{
print("<font size=\"2\" color=\"yellow\">PC-âêëþ÷åí</font>");        }
   else
   {
  print("<font size=\"2\" color=\"red\">PC-èçêëþ÷åí</font>");
   }
begin_main_frame();
?>
<table width=100% border=1 cellspacing=0 cellpadding=5>
<tr><td class=rowhead width=1%>Ðåãèñòðèðàí</td><td align=left width=99%><?=$joindate?></td></tr>
<?
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if (get_user_class() > UC_MODERATOR)
print("<tr><td class=rowhead><font color=white>Ïîñëåäåí ïúò å áèë â òðàêåðà</font></td><td 
align=left>$lastseen</td></tr>\n");
?>
<?
$dt = gmtime() - 180; 
$dt = sqlesc(get_date_time($dt)); 
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
print("<tr><td class=rowhead width=1%>Â òðàêåðà</td> 
<td class=row1 align=left width=99%>" . ("'".$user['last_access']."'">$dt?"<font color=green><b>Äà</b></font> / <font color=gray>Íå</font>" : "<font color=gray>Äà</font> / <font color=red><b>Íå</b></font>" ) . "</td></tr>"); 
?>
<?
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
	print("<tr><td class=\"rowhead\">Email</td><td align=\"left\"><a href=\"mailto:$user[email]\">$user[email]</a></td></tr>\n");
if ($addr)
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
  print("<tr><td class=rowhead>IP</td><td align=left><a href=http://www.ripe.net/perl/whois?form_type=simple&full_query_string=&searchtext=$ip>$ip ($dom)</a> $ban</td></tr>\n");
  print("<tr><td class=rowhead>Ñèñòåìíà èíôîðìàöèÿ</td><td align=left>". getenv("HTTP_USER_AGENT") ."</td></tr>\n");
  print("<tr><td class=rowhead><font color=white>Íàãðàäè</font></td><td align=left>$kubok</td></tr>\n");
  //  if ($user["id"] == $CURUSER["id"] || get_user_class() >= UC_MODERATOR)
//	{
?>

<tr><td class=rowhead>Ïîðò</font></td><td class=tablea align=left><?=$user['port']?></td></tr>
<tr><td class=rowhead>Êëèåíò</font></td><td class=tablea align=left><?=$user['agent']?></td></tr>
<tr><td class=rowhead>Êà÷åíî</td><td align=left><?=mksize($user["uploaded"])?></td></tr>
<tr><td class=rowhead>Ñâàëåíî</td><td align=left><?=mksize($user["downloaded"])?></td></tr>
<?if (get_user_class() == UC_SYSOP && $user['invisible'] == "no") {
print("<tr><td class=\"rowhead\">Âèäåí</td><td align=\"left\"><a href=userdetails.php?invisible=yes&id=".$user['id'].">Ñäåëàòü íåâèäèìûì</a></td></tr>");
}
if (get_user_class() == UC_SYSOP && $user['invisible'] == "yes") {
print("<tr><td class=\"rowhead\">Íåâèäåí</td><td align=\"left\"><a href=userdetails.php?invisible=no&id=".$user['id'].">Ñäåëàòü âèäèìûì</a></td></tr>");
}?> 
<tr><td class=rowhead>Îáù òðàôèê</td><td align=left><?=mksize($user["downloaded"] + $user["uploaded"])?></td></tr>
<?
$speedu = mysql_query("SELECT sum(((p.uploaded - p.uploadoffset )) / (
unix_timestamp(p.last_action) - unix_timestamp(p.started))) AS speed FROM peers p INNER
JOIN users u ON p.userid=u.id WHERE u.id=$user[id]");
$tu=mysql_fetch_array($speedu);
$speeduu = mksize($tu["speed"])or sqlerr(__FILE__, __LINE__);

print("<tr><td class=rowhead><font color=white>Ñêîðîñò íà êà÷âàíå</font></td><td 
align=left>$speeduu</td></tr>\n");

$speedd = mysql_query("SELECT sum(((p.downloaded - p.downloadoffset )) / (
unix_timestamp(p.last_action) - unix_timestamp(p.started))) AS speed FROM peers p INNER
JOIN users u ON p.userid=u.id WHERE u.id=$user[id]");
$td=mysql_fetch_array($speedd);
$speeddd = mksize($td["speed"])or sqlerr(__FILE__, __LINE__);

print("<tr><td class=rowhead><font color=white>Ñêîðîñò íà ñâàëÿíå</font></td><td 
align=left>$speeddd</td></tr>\n");  

if (get_user_class() >= UC_MODERATOR)
	print("<tr><td class=\"rowhead\">Ïîêàíè</td><td align=left><a href=\"invite.php?id=$id\">".$user["invites"]."</a></td></tr>");
if ($user["invitedby"] != 0) {
	$inviter = mysql_fetch_assoc(sql_query("SELECT username FROM users WHERE id = ".sqlesc($user["invitedby"])));
	print("<tr><td class=\"rowhead\">Ïîêàíèë</td><td align=\"left\"><a href=\"userdetails.php?id=$user[invitedby]\">$inviter[username]</a></td></tr>");
}
if ($user["downloaded"] > 0) {
  $sr = $user["uploaded"] / $user["downloaded"];
  if ($sr >= 4)
    $s = "w00t";
  else if ($sr >= 2)
    $s = "grin";
  else if ($sr >= 1)
    $s = "smile1";
  else if ($sr >= 0.5)
    $s = "noexpression";
  else if ($sr >= 0.25)
    $s = "sad";
  else
    $s = "cry";
  $sr = floor($sr * 1000) / 1000;
  $sr = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td class=\"embedded\"><font color=\"" . get_ratio_color($sr) . "\">" . number_format($sr, 3) . "</font></td><td class=\"embedded\">  <img src=\"pic/smilies/$s.gif\"></td></tr></table>";
  print("<tr><td class=\"rowhead\" style=\"vertical-align: middle\">Ðåéòèíã</td><td align=\"left\" valign=\"center\" style=\"padding-top: 1px; padding-bottom: 0px\">$sr</td></tr>\n");
  print("<tr><td class=\"rowhead\">Áîíóñ</td><td align=\"left\">".($user['bonus'])."</a></td></tr>\n"); 
}
if (get_user_class() >= UC_MODERATOR)
{        
if (!$_GET["ratings"])

                tr("Get Ratings<br /><a href=\"userdetails.php?id=$id&ratings=1$keepget#ratings\" class=\"sublink\">[See full list]</a>", $row["numratings"] . " ratings", 1);

            else {

                tr("Get Ratings", $row["numratings"] . " ratings", 1);


                $s = "<table class=main border=\"1\" cellspacing=0 cellpadding=\"5\">\n";


                $subres = mysql_query("SELECT * FROM ratings WHERE user = $id ORDER BY user");

$s.="<tr><td class=colhead>Path</td><td class=colhead align=right>Size</td></tr>\n";
                while ($subrow = mysql_fetch_array($subres)) {
$ratingid=$subrow["torrent"];
$sd=mysql_query("SELECT name FROM torrents WHERE id=$ratingid");
$fetched_result = mysql_fetch_array($sd);
$sd = $fetched_result['name'];
                    $s .= "<tr><td><a href=details.php?id=$ratingid>" . $sd .

                            "</a></td><td align=\"right\">" . $subrow["rating"] . "</td></tr>\n";
                }
                $s .= "</table>\n";
                tr("<a name=\"filelist\">Rating's</a><br /><a href=\"userdetails.php?id=$id$keepget\" class=\"sublink\">[Hide list]</a>", $s, 1);
            }}
//}
if ($user["icq"] || $user["msn"] || $user["aim"] || $user["yahoo"] || $user["skype"])
{

if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
print("<tr><td class=rowhead><b>Âðúçêà</b></td><td align=left>\n");

if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["icq"])
    print("<img src=\"http://web.icq.com/whitepages/online?icq=$user[icq]&img=5\" alt=\"icq\" border=\"0\" /> $user[icq] <br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["msn"])
    print("<img src=\"pic/contact/msn.gif\" alt=\"msn\" border=\"0\" /> $user[msn]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["aim"])
    print("<img src=\"pic/contact/aim.gif\" alt=\"aim\" border=\"0\" /> $user[aim]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["yahoo"])
    print("<img src=\"pic/contact/yahoo.gif\" alt=\"yahoo\" border=\"0\" /> $user[yahoo]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["skype"])
    print("<img src=\"pic/contact/skype.gif\" alt=\"skype\" border=\"0\" /> $user[skype]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["mirc"])
    print("<img src=\"pic/contact/mirc.gif\" alt=\"mirc\" border=\"0\" /> $user[mirc]\n");
?> 
</td>
</tr>

<?
}
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["website"])
	print("<tr><td class=\"rowhead\">Ñàéò</td><td align=\"left\"><a href=\"$user[website]\" target=\"_blank\">$user[website]</a></td></tr>\n");
//if ($user['donated'] > 0 && (get_user_class() >= UC_MODERATOR || $CURUSER["id"] == $user["id"]))
//  print("<tr><td class=rowhead>Donated</td><td align=left>$$user[donated]</td></tr>\n");
if ($user["avatar"])
	print("<tr><td class=\"rowhead\">Àâàòàð</td><td align=left><img src=\"" . htmlspecialchars($user["avatar"]) . "\"></td></tr>\n");
print("<tr><td class=\"rowhead\">Ðàíã</td><td align=\"left\"><b> <img src=" . get_user_class_image($user["class"]) . " alt=" . get_user_class_name($user["class"]) . "></td></tr>\n");
//////////////////////////////////////////////////////////////
///////////////  Ìîä àâòîïîíèæåíèÿ àïëîàäåðîâ  //////////////
////////////////////////////////////////////////////////////

if ($user["class"] == 3){ //Åñëè àïëîàäåð

   if (get_user_class() >= UC_MODERATOR or $user["id"] == $CURUSER["id"]){ //Äîñòóï Ìîäåðàòîðàì è âûøå, ñàìîìó ïîëüçîâàòåëþ

   $fromup = sql_query("SELECT releas, days, sended FROM uploaders WHERE userid=".$user['id']."") or sqlerr(__FILE__,__LINE__);
   $testup = mysql_fetch_array($fromup); //Âûáèðàåì ïîëüçîâàòåëÿ èç òàáëèöû àïëîàäåðîâ
   
   if (!$testup){ //Åñëè ïî êàêîé-òî ïðè÷èíå åãî íåò â òàáëèöå uploaders (ïðîâåðêà)
   $messtxt = "<font color='red'><b>Ïðîâåðêà ïîëüçîâàòåëÿ íå ïðîèçâîäèòñÿ</b></font>"; //Âûâîäèìîå ñîîáùåíèå
   }
   else
   {
       $days = "<font color='red'><b>".$testup['days']." äí.</b></font>"; //Ñêîëüêî äíåé äî âîçìîæíîãî ïîíèæåíèÿ
   
       if ($testup['releas'] == "no"){ //Åñòü èëè íåò ðåëèçû 
       $releas = "<font color='red'><b>ÂÊË</b> (íåò ðåëèçîâ)</font>";
       } else {
       $releas = "<font color='green'><b>ÂÛÊË</b> (åñòü ðåëèçû)</font>";
       }
   
       if ($testup['sended'] == "yes"){ //Îòïðàâëåíî ëè ïðåäóïðåæäåíèå 
       $sended = "<font color='red'>, <b>ïðåäóïðåæäåí</b>(<b>à</b>)</b></font>";
       } else {
       $sended = "";
       }
   
   $messtxt = "<b>Îñòàëîñü</b>: ".$days."  <b>Ïîíèæåíèå</b>: ".$releas."".$sended.""; //Âûâîäèìîå ñîîáùåíèå
   }

   print("<tr><td class=\"rowhead\">Àâòîïîíèæåíèå</td><td align=left>".$messtxt."</td></tr>\n"); //Âûâîäèì â ïðîôèëü
   }
}
//////////////////////////////////////////////////////////////
///////////////  Ìîä àâòîïîíèæåíèÿ àïëîàäåðîâ  //////////////
////////////////////////////////////////////////////////////   
print("<tr><td class=\"rowhead\">Òèòëà</td><td align=\"left\"><b>" . ($user["title"] != "" ? "  <span style=\"color: red;\">{$user["title"]}</span>" : "") . "</b></td></tr>\n");
print("<tr><td class=\"rowhead\">Ïîë</td><td align=\"left\">$gender</td></tr>\n");
if($user["birthday"]!='0000-00-00') {
        print("<tr><td class=\"rowhead\">Âúçðàñò</td><td align=\"left\">$age</td></tr>\n");
        $birthday = date("d.m.Y", strtotime($birthday));
        print("<tr><td class=\"rowhead\">Äàòà íà ðàæäàíå</td><td align=\"left\">$birthday</td></tr>\n");

$month_of_birth = substr($user["birthday"], 5, 2);
        $day_of_birth = substr($user["birthday"], 8, 2);
        for($i = 0; $i < count($zodiac); $i++) {
                if (($month_of_birth == substr($zodiac[$i][2], 3, 2)))  {
                        if ($day_of_birth >= substr($zodiac[$i][2], 0, 2)) {
                                $zodiac_img = $zodiac[$i][1];
                                $zodiac_name = $zodiac[$i][0];
                        }
                        else {
                                if ($i == 11) {
                                        $zodiac_img = $zodiac[0][1];
                                        $zodiac_name = $zodiac[0][0];
                                }
                                else {
                                        $zodiac_img = $zodiac[$i+1][1];
                                        $zodiac_name = $zodiac[$i+1][0];
                                }
                        }
                }

        }

print("<tr><td class=\"rowhead\">Çîäèàêàëåí çíàê</td><td align=\"left\"><img src=\"pic/zodiac/" . $zodiac_img . "\" alt=\"" . $zodiac_name . "\" title=\"" . $zodiac_name . "\"></td></tr>\n");

}

if ($user['simpaty'] != 0) {
        if ((get_user_class() >= UC_MODERATOR && $user['class'] < get_user_class()) || $user['id'] == $CURUSER['id']) {
                $simpaty = ($user['simpaty'] > 0?'<img src="pic/thum_good.gif" border="0"> <a href="mysimpaty.php?id=' . $user['id'] . '">' . $user['simpaty'] . '</a>':'<img src="pic/thum_bad.gif" border="0"> <a href="mysimpaty.php?id=' . $user['id'] . '">' . $user['simpaty'] . '</a>');
        }
        else {
                $simpaty = ($user['simpaty'] > 0?'<img src="pic/thum_good.gif"> ' . $user['simpaty']:'<img src="pic/thum_bad.gif"> ' . $user['simpaty']);
        }
} 

if ($user['simpaty'] != 0) {
print("<tr><td class=\"rowhead\">Ðåñïåêòè</td><td align=\"left\">$simpaty</td></tr>\n");
};

print("<tr><td class=\"rowhead\">Êîìåíòàðè</td>");
if ($torrentcomments && (($user["class"] >= UC_POWER_USER && $user["id"] == $CURUSER["id"]) || get_user_class() >= UC_MODERATOR))
	print("<td align=\"left\"><a href=\"userhistory.php?action=viewcomments&id=$id\">$torrentcomments</a></td></tr>\n");
else
	print("<td align=\"left\">$torrentcomments</td></tr>\n");
if (get_user_class() >= UC_MODERATOR)
    print("<tr><td class=rowhead width=1%><font color=red>Delete all Com.</font></td><td align=left width=99%><a href=comdel.php?id=$id><b>Click Here</b></a></td></tr>\n");


?><script language="javascript" type="text/javascript" src="js/show_hide.js"></script><?
$dt = sqlesc(get_date_time(gmtime() - 180)); //-- 3 minutes without activity
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["last_access"] < $dt)
  print("<tr><td class=\"rowhead\">Â ìîìåíòà</td><td class=tablea>(No useractivity)</td></tr>\n");
else
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
  print("<tr><td class=\"rowhead\">Â ìîìåíòà</td><td class=tablea>". $user["page_now"] ."</td></tr>\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if (!$user["page_now"])
  print("<tr><td class=\"rowhead\">Â ìîìåíòà</td><td class=tablea>(Never active)</td></tr>\n");
if ($user["groups"]) { 
  print("<tr><td class=\"rowhead\"><b>Îòáîð</b></td><td class=\"tablea\" align=\"left\">".$groups."</td></tr>\n");    
  }
if ($torrents)
 print("<tr valign=\"top\"><td class=\"rowhead\">Êà÷åíè Òîðåíòè</td><td align=\"left\"><a href=\"javascript: show_hide('s1')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics1\" title=\"Ïîêàçàòü\"></a><div id=\"ss1\" style=\"display: none;\">$torrents</div></td></tr>\n");
if ($seeding)
 print("<tr valign=\"top\"><td class=\"rowhead\">Â ìîìåíòà ñèéäâà</td><td align=\"left\"><a href=\"javascript: show_hide('s2')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics2\" title=\"Ïîêàçàòü\"></a><div id=\"ss2\" style=\"display: none;\">$seeding</div></td></tr>\n");
if ($leeching)
 print("<tr valign=\"top\"><td class=\"rowhead\">Â ìîìåíòà ñìúêâà</td><td align=\"left\"><a href=\"javascript: show_hide('s3')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics3\" title=\"Ïîêàçàòü\"></a><div id=\"ss3\" style=\"display: none;\">$leeching</div></td></tr>\n");
if ($completed)
 print("<tr valign=\"top\"><td class=\"rowhead\">Èçòåãëåíè Òîðåíòè</td><td align=\"left\"><a href=\"javascript: show_hide('s4')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics4\"></a><div id=\"ss4\" style=\"display: none;\">$completed</div></td></tr>\n");
if ($invitetree)
 print("<tr valign=\"top\"><td class=\"rowhead\">Ïîêàíà</td><td align=\"left\"><a href=\"javascript: show_hide('s5')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics5\"></a><div id=\"ss5\" style=\"display: none;\">$invitetree</div></td></tr>\n");

if ($user["info"])
 print("<tr valign=\"top\"><td align=\"left\" colspan=\"2\" class=\"text\" bgcolor=\"#F4F4F0\">" . format_comment($user["info"]) . "</td></tr>\n");

if ($CURUSER["id"] != $user["id"])
	if (get_user_class() >= UC_MODERATOR)
  	$showpmbutton = 1;
	elseif ($user["acceptpms"] == "yes")
	{
		$r = sql_query("SELECT id FROM blocks WHERE userid = $user[id] AND blockid = $CURUSER[id]") or sqlerr(__FILE__,__LINE__);
		$showpmbutton = (mysql_num_rows($r) == 1 ? 0 : 1);
	}
	elseif ($user["acceptpms"] == "friends")
	{
		$r = sql_query("SELECT id FROM friends WHERE userid = $user[id] AND friendid = $CURUSER[id]") or sqlerr(__FILE__,__LINE__);
		$showpmbutton = (mysql_num_rows($r) == 1 ? 1 : 0);
	}
if ($showpmbutton)
$elapsed = (date('U')-strtotime($user['last_download'])) / 60;
$elapsed = (int) $elapsed;
print("<tr><td class=rowhead>Ïîñëåäíî ñâàëÿíå</td><td align=left>".$user['last_download'].", èçìèíàëè ìèíóòè: ".$elapsed ."</td></tr>\n"); 
	print("<tr><td colspan=2 align=center><form method=\"get\" action=\"message.php\"> 
        <input type=\"hidden\" name=\"receiver\" value=" .$user["id"] . "> 
        <input type=\"hidden\" name=\"action\" value=\"sendmessage\"> 
        <input type=submit value=\"Èçïðàòè ËÑ\" style=\"height: 23px\"> 
        </form></td></tr>");

print("</table>\n");
begin_frame("Ïîäàðúöè íà ïîòðåáèòåëÿ $user[username]", true);
$gifts = mysql_query("SELECT * FROM gift WHERE sender='$user[id]' ORDER BY id DESC");
$gift = mysql_fetch_array ($gifts);
if ($gift[sender] == '') { 
stdmsg($tracker_lang['error'], 'Òîçè ïîòðåáèòåë íÿìà ïîäàðúöè!');
  }else{
do {
print ("<a href=\"gift/$gift[idgift].jpg\" rel=\"sexylightbox\"><img style='width:96px; height:96px; border-style:none;' src='gift/$gift[idgift].jpg'></a>");
print (" ");
} while ($gift = mysql_fetch_array ($gifts));}
?>
<div align="right">
<form action="gift.php" method="post">
<input name="userid" type="hidden" value="<?=$user[id]?>">
<input name="addressee" type="hidden" value="<?=$CURUSER[id]?>">
<input name="username" type="hidden" value="<?=$user[username]?>">
<input name="submit" type="submit" value="Âñè÷êè ïîäàðúöè">
</form></div>
<div align="right">
<form action="addgift.php" method="post">
<input name="userid" type="hidden" value="<?=$user[id]?>">
<input name="username" type="hidden" value="<?=$user[username]?>">
<input name="submit" type="submit" value="Ïîäàðè ïîäàðúê">
</form></div>
<font color='red'>Âíèìàíèå, âñåêè åäèí ïîäàðúê ñòðóâà îïðåäåëåí áðîé áîíóñ òî÷êè!</font>
<?
end_frame();
////////////////////////////////////////////////////////////////////////////////
/////////////////////=========Îïöèè Äèðåêòîðà===========///////////////////////
//////////////////////////////////////////////////////////////////////////////

if (get_user_class() == UC_SYSOP){
  print("<br>");
  begin_frame("Îïöèè íà Øåôà", true);
  print("<form method=\"post\" action=\"takeuseredit.php\">");
  print("<input type=\"hidden\" name=\"id\" value=\"".$id."\">");
  print("<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\" width=\"100%\">");

//Ñìåíèòü èìÿ

  print("<tr><td c

misho · 9 Юли 2010

Пробвай така. Но ако това не става, нямам сили да се ровя повече в кода, много е. Поне някакви насоки къде си пипал. :lol:
А и внимавай като го заместваш да не изтървеш нещо, че не си копирал целия код, а само до някъде. :wink:

Код:

<?

/*
// +--------------------------------------------------------------------------+
// | Project:    TBDevYSE - TBDev Yuna Scatari Edition                        |
// +--------------------------------------------------------------------------+
// | This file is part of TBDevYSE. TBDevYSE is based on TBDev,               |
// | originally by RedBeard of TorrentBits, extensively modified by           |
// | Gartenzwerg.                                                             |
// |                                                                          |
// | TBDevYSE is free software; you can redistribute it and/or modify         |
// | it under the terms of the GNU General Public License as published by     |
// | the Free Software Foundation; either version 2 of the License, or        |
// | (at your option) any later version.                                      |
// |                                                                          |
// | TBDevYSE is distributed in the hope that it will be useful,              |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of           |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            |
// | GNU General Public License for more details.                             |
// |                                                                          |
// | You should have received a copy of the GNU General Public License        |
// | along with TBDevYSE; if not, write to the Free Software Foundation,      |
// | Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA            |
// +--------------------------------------------------------------------------+
// |                                               Do not remove above lines! |
// +--------------------------------------------------------------------------+
*/

require "include/bittorrent.php";

dbconn(false);
  if (get_user_class() < UC_USER)
  stderr("A?aoea", "Aea iyiaoa io?ieoa i?aaa ca ?acaea?aaia ia no?aieoaoa! O?yaaa aa noa n ?aia ia ii ienue io Noia? Iio?aaeoae!");
loggedinorreturn();
//start mod invisible 
if (get_user_class() == UC_SYSOP) {
$uid = $_GET['id'];
if ($_GET['invisible'] == "yes") {
mysql_query("update users set invisible='yes' where id=".sqlesc($uid)."") or sqlerr(__FILE__,__LINE__);
}
if ($_GET['invisible'] == "no") {
mysql_query("update users set invisible='no' where id=".sqlesc($uid)."") or sqlerr(__FILE__,__LINE__);
}
}
//end mod invisible  
getpage();

function bark($msg) {
	global $tracker_lang;
	stdhead($tracker_lang['error']);
	stdmsg($tracker_lang['error'], $msg);
	stdfoot();
	exit;
}

function maketable($res)
{
  global $tracker_lang, $use_ttl, $ttl_days;
  $ret = "<table class=main border=1 cellspacing=0 cellpadding=5>" .
    "<tr><td class=colhead align=left>".$tracker_lang['type']."</td><td class=colhead>".$tracker_lang['name']."</td>".($use_ttl ? "<td class=colhead align=center>".$tracker_lang['ttl']."</td>" : "")."<td class=colhead align=center>".$tracker_lang['size']."</td><td class=colhead align=right>".$tracker_lang['details_seeding']."</td><td class=colhead align=right>".$tracker_lang['details_leeching']."</td><td class=colhead align=center>".$tracker_lang['uploaded']."</td>\n" .
    "<td class=colhead align=center>".$tracker_lang['downloaded']."</td><td class=colhead align=center>".$tracker_lang['ratio']."</td></tr>\n";
  while ($arr = mysql_fetch_assoc($res))
  {
    if ($arr["downloaded"] > 0)
    {
      $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3);
      $ratio = "<font color=" . get_ratio_color($ratio) . ">$ratio</font>";
    }
    else
      if ($arr["uploaded"] > 0)
        $ratio = "Inf.";
      else
        $ratio = "---";
    $catid = $arr["catid"];
	$catimage = htmlspecialchars($arr["image"]);
	$catname = htmlspecialchars($arr["catname"]);
	$ttl = ($ttl_days*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600);
	if ($ttl == 1) $ttl .= " ?an"; else $ttl .= " ?ana";
	$size = str_replace(" ", "<br />", mksize($arr["size"]));
	$uploaded = str_replace(" ", "<br />", mksize($arr["uploaded"]));
	$downloaded = str_replace(" ", "<br />", mksize($arr["downloaded"]));
	$seeders = number_format($arr["seeders"]);
	$leechers = number_format($arr["leechers"]);
    $ret .= "<tr><td style='padding: 0px'><a href=\"browse.php?cat=$catid\"><img src=\"pic/cats/$catimage\" alt=\"$catname\" border=\"0\" /></a></td>\n" .
		"<td><a href=details.php?id=$arr[torrent]&hit=1><b>" . $arr["torrentname"] .
		"</b></a></td>".($use_ttl ? "<td align=center></td>" : "")."<td align=center>$size</td><td align=right>$seeders</td><td align=right>$leechers</td><td align=center>$uploaded</td>\n" .
		"<td align=center>$downloaded</td><td align=center>$ratio</td></tr>\n";
  }
  $ret .= "</table>\n";
  return $ret;
}

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

if (!is_valid_id($id))
  bark($tracker_lang['invalid_id']);

$r = @sql_query("SELECT * FROM users WHERE id=$id") or sqlerr(__FILE__, __LINE__);
$user = mysql_fetch_array($r) or bark("Iyia iio?aaeoae n oaeiaa ID $id.");
if ($user["status"] == "pending") die;
$r = sql_query("SELECT torrents.id, torrents.name, torrents.seeders, torrents.added, torrents.leechers, torrents.category, categories.name AS catname, categories.image AS catimage, categories.id AS catid FROM torrents LEFT JOIN categories ON torrents.category = categories.id WHERE owner=$id ORDER BY name") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($r) > 0) {
  $torrents = "<table class=main border=1 cellspacing=0 cellpadding=5>\n" .
    "<tr><td class=colhead>".$tracker_lang['type']."</td><td class=colhead>".$tracker_lang['name']."</td>".($use_ttl ? "<td class=colhead align=center></td>" : "")."<td class=colhead>".$tracker_lang['tracker_seeders']."</td><td class=colhead>".$tracker_lang['tracker_leechers']."</td></tr>\n";
  while ($a = mysql_fetch_assoc($r)) {
	$ttl = ($ttl_days*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($a["added"])) / 3600);
	if ($ttl == 1) $ttl .= " ?an"; else $ttl .= " ?ania";
		//$r2 = sql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
		//$a2 = mysql_fetch_assoc($r2);
		$cat = "<a href=\"browse.php?cat=$a[catid]\"><img src=\"pic/cats/$a[catimage]\" alt=\"$a[catname]\" border=\"0\" /></a>";
      $torrents .= "<tr><td style='padding: 0px'>$cat</td><td><a href=\"details.php?id=" . $a["id"] . "&hit=1\"><b>" . $a["name"] . "</b></a></td>"
      	.($use_ttl ? "<td align=center></td>" : "")
        ."<td align=right>$a[seeders]</td><td align=right>$a[leechers]</td></tr>\n";
  }
  $torrents .= "</table>";
}

$it = sql_query("SELECT u.id, u.username, u.class, i.id AS invitedid, i.username AS invitedname, i.class AS invitedclass FROM users AS u LEFT JOIN users AS i ON i.id = u.invitedby WHERE u.invitedroot = $id OR u.invitedby = $id ORDER BY u.invitedby");
if (mysql_num_rows($it) >= 1) {
	$invitetree = "<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\"><tr>".
		"<td class=\"colhead\">Iieuciaaoaeu</td><td class=\"colhead\">Iieaiee</td>";
	while ($inviter = mysql_fetch_array($it))
		$invitetree .= "<tr><td><a href=\"userdetails.php?id=$inviter[id]\">".get_user_class_color($inviter["class"], $inviter["username"])."</a></td><td><a href=\"userdetails.php?id=$inviter[invitedid]\">".get_user_class_color($inviter["invitedclass"], $inviter["invitedname"])."</a></td></tr>";
	$invitetree .= "</table>";
}

if ($user["ip"] && (get_user_class() >= UC_MODERATOR || $user["id"] == $CURUSER["id"])) {
  $ip = $user["ip"];
  $dom = @gethostbyaddr($user["ip"]);
  if ($dom == $user["ip"] || @gethostbyname($dom) != $user["ip"])
    $addr = $ip;
  else
  {
    $dom = strtoupper($dom);
    $domparts = explode(".", $dom);
    $domain = $domparts[count($domparts) - 2];
    if ($domain == "COM" || $domain == "CO" || $domain == "NET" || $domain == "NE" || $domain == "ORG" || $domain == "OR" )
      $l = 2;
    else
      $l = 1;
    $addr = "$ip ($dom)";
  }
}

$r = mysql_query("SELECT snatched.torrent AS id, snatched.uploaded, snatched.seeder, snatched.downloaded, snatched.startdat, snatched.completedat, snatched.last_action, categories.name AS catname, categories.image AS catimage, categories.id AS catid, torrents.name, torrents.seeders, torrents.leechers FROM snatched JOIN torrents ON torrents.id = snatched.torrent JOIN categories ON torrents.category = categories.id WHERE snatched.finished='yes' AND userid = $id ORDER BY torrent") or sqlerr(__FILE__,__LINE__);
if (mysql_num_rows($r) > 0) {
$completed = "<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\">\n" .
  "<tr><td class=\"colhead\">Oei</td><td class=\"colhead\">Eia</td><td class=\"colhead\">Ea?ee</td><td class=\"colhead\">Naaeee</td><td class=\"colhead\">Ea?ee</td><td class=\"colhead\">Naaeee</td><td class=\"colhead\">?aeoeia</td><td class=\"colhead\">Caii?iae / Caau?oee</td><td class=\"colhead\">Aaenoaea</td><td class=\"colhead\">Neeaaau</td></tr>\n";
while ($a = mysql_fetch_array($r)) {
if ($a["downloaded"] > 0) {
      $ratio = number_format($a["uploaded"] / $a["downloaded"], 3);
      $ratio = "<font color=\"" . get_ratio_color($ratio) . "\">$ratio</font>";
   } else
	if ($a["uploaded"] > 0)
        $ratio = "Inf.";
	else
		$ratio = "---";
$uploaded = mksize($a["uploaded"]);
$downloaded = mksize($a["downloaded"]);
if ($a["seeder"] == 'yes')
	$seeder = "<font color=\"green\">Aa</font>";
else
	$seeder = "<font color=\"red\">Iao</font>";
	$cat = "<a href=\"browse.php?cat=$a[catid]\"><img src=\"pic/cats/$a[catimage]\" alt=\"$a[catname]\" border=\"0\" /></a>";
    $completed .= "<tr><td style=\"padding: 0px\">$cat</td><td><nobr><a href=\"details.php?id=" . $a["id"] . "&hit=1\"><b>" . $a["name"] . "</b></a></nobr></td>" .
      "<td align=\"right\">$a[seeders]</td><td align=\"right\">$a[leechers]</td><td align=\"right\">$uploaded</td><td align=\"right\">$downloaded</td><td align=\"center\">$ratio</td><td align=\"center\"><nobr>$a[startdat]<br />$a[completedat]</nobr></td><td align=\"center\"><nobr>$a[last_action]</nobr></td><td align=\"center\">$seeder</td>\n";
}
$completed .= "</table>";
}

if ($user[added] == "0000-00-00 00:00:00")
	$joindate = 'N/A';
else
	$joindate = "$user[added] (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($user["added"])) . " ".$tracker_lang['ago'].")";
$lastseen = $user["last_access"];
if ($lastseen == "0000-00-00 00:00:00")
	$lastseen = $tracker_lang['never'];
else {
  $lastseen .= " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($lastseen)) . " ".$tracker_lang['ago'].")";
}
  $res = sql_query("SELECT COUNT(*) FROM comments WHERE user = " . $user[id]) or sqlerr(__FILE__, __LINE__);
  $arr3 = mysql_fetch_row($res);
  $torrentcomments = $arr3[0];

  

//if ($user['donated'] > 0)
//  $don = "<img src=pic/starbig.gif>";

$res = sql_query("SELECT name, flagpic FROM countries WHERE id = $user[country] LIMIT 1") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 1)
{
  $arr = mysql_fetch_assoc($res);
  $country = "<td class=\"embedded\"><img src=\"pic/flag/$arr[flagpic]\" alt=\"$arr[name]\" style=\"margin-left: 8pt\"></td>";
}
 $res = mysql_query("SELECT name,image FROM groups WHERE id=".$user['groups']." LIMIT 1") or sqlerr();  
if (mysql_num_rows($res) == 1)   
{   
 $arr = mysql_fetch_assoc($res);   
 $groups = "<img src=\"/pic/groups/".$arr["image"]."\" alt=\"".$arr["name"]."\"> ";   
}  
//if ($user["donor"] == "yes") $donor = "<td class=embedded><img src=pic/starbig.gif alt='Donor' style='margin-left: 4pt'></td>";
//if ($user["warned"] == "yes") $warned = "<td class=embedded><img src=pic/warnedbig.gif alt='Warned' style='margin-left: 4pt'></td>";

if ($user["gender"] == "1") $gender = "<img src=\"".$pic_base_url."male.gif\" alt=\"Iu?\" title=\"Iu?\">";
elseif ($user["gender"] == "2") $gender = "<img src=\"".$pic_base_url."female.gif\" alt=\"?aia\" title=\"?aia\">";
//elseif ($user["gender"] == "I/A") $gender = "<td class=embedded><img src=".$pic_base_url."na.gif alt='I/A' style='margin-left: 4pt'></td>";

$res = sql_query("SELECT torrent, added, uploaded, downloaded, torrents.name AS torrentname, categories.name AS catname, categories.id AS catid, size, image, category, seeders, leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid = $id AND seeder='no'") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) > 0)
  $leeching = maketable($res);
$res = sql_query("SELECT torrent, added, uploaded, downloaded, torrents.name AS torrentname, categories.name AS catname, categories.id AS catid, size, image, category, seeders, leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid = $id AND seeder='yes'") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) > 0)
  $seeding = maketable($res);
/// MOD KUBOK///
if ($user['kubok1'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok1.gif\" alt=\"Iaa?aaa ca iinoiyiai neea\" title=\"Iaa?aaa ca iinoiyiai neea\">";
if ($user['kubok2'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok2.gif\" alt=\"Iaa?aaa ca ea?ai oieeaeai oi?aio\" title=\"Iaa?aaa ca ea?ai oieeaeai oi?aio\">";
if ($user['kubok3'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok3.gif\" alt=\"Iaa?aaa ca noia? iienaiea\" title=\"Iaa?aaa ca noia? iienaiea\">";
if ($user['kubok4'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok4.gif\" alt=\"Iaa?aaa ca aeoeaiino aua oi?oia\" title=\"Iaa?aaa ca aeoeaiino aua oi?oia\">";
if ($user['kubok5'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok5.gif\" alt=\"Iaa?aaa ca a?ie ea?aie oi?aioe\" title=\"Iaa?aaa ca a?ie ea?aie oi?aioe\">";
if ($user['kubok6'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/kubok6.gif\" alt=\"Iaa?aaa ca iae-aeoeaai uieioaa?\" title=\"Iaa?aaa ca iae-aeoeaai uieioaa?\">";
if ($user['nagrada1'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada1.gif\" alt=\"Iaa?aaa ca i?eiin eui naeoa\" title=\"Iaa?aaa ca i?eiin eui naeoa\">";
if ($user['nagrada2'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada2.gif\" alt=\"Iaa?aaa ca iiiiu eui inoaiaeeoa iio?aaeoaee\" title=\"Iaa?aaa ca iiiiu eui inoaiaeeoa iio?aaeoaee\">";
if ($user['nagrada3'] == "yes")
    $kubok .= "<img src=\"pic/kubkinagrady/nagrada3.gif\" alt=\"Iaa?aaa ca iaaeoeaai eiiaioa? eui oi?aio\" title=\"Iaa?aaa ca iaaeoeaai eiiaioa? eui oi?aio\">";
/// MOD KUBOK/// 
///////////////// BIRTHDAY MOD /////////////////////
if ($user[birthday] != "0000-00-00")
{
        //$current = date("Y-m-d", time());
        $current = date("Y-m-d", time() + $CURUSER['tzoffset'] * 60);
        list($year2, $month2, $day2) = split('-', $current);
        $birthday = $user["birthday"];
        $birthday = date("Y-m-d", strtotime($birthday));
        list($year1, $month1, $day1) = split('-', $birthday);
        if($month2 < $month1)
        {
                $age = $year2 - $year1 - 1;
        }
        if($month2 == $month1)
        {
                if($day2 < $day1)
                {
                        $age = $year2 - $year1 - 1;
                }
                else
                {
                        $age = $year2 - $year1;
                }
        }
        if($month2 > $month1)
        {
                $age = $year2 - $year1;
        }

}
///////////////// BIRTHDAY MOD /////////////////////

stdhead("I?iniio? i?ioeey " . $user["username"]);
$enabled = $user["enabled"] == 'yes';
print("<p><table class=\"main\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">".
"<tr><td class=\"embedded\"><h1 style=\"margin:0px\">$user[username]" . get_user_icons($user, true) . "</h1></td>$country</tr></table></p>\n");

if (!$enabled)
  print("<p><b>Yoio aeeaoio ioee??ai</b></p>\n");
elseif ($CURUSER["id"] <> $user["id"]) {
  $r = sql_query("SELECT id FROM friends WHERE userid=$CURUSER[id] AND friendid = $id") or sqlerr(__FILE__, __LINE__);
  $friend = mysql_num_rows($r);
  $r = sql_query("SELECT id FROM blocks WHERE userid=$CURUSER[id] AND blockid = $id") or sqlerr(__FILE__, __LINE__);
  $block = mysql_num_rows($r);
if ($user["class"] < UC_MODERATOR || $CURUSER["class"] >= UC_MODERATOR)
  if ($friend)
    print("<p>(<a href=\"friends.php?action=delete&type=friend&targetid=$id\">Iaoie io i?eyoaee</a>)</p>\n");
  elseif($block)
    print("<p>(<a href=\"friends.php?action=delete&type=block&targetid=$id\">Iaoie io aeiee?aie</a>)</p>\n");
  else
  {
    print("<p>(<a href=\"friends.php?action=add&type=friend&targetid=$id\">Aiaaae a i?eyoaee</a>)");
    print(" - (<a href=\"friends.php?action=add&type=block&targetid=$id\">Aiaaae a aeiee?aie</a>)</p>\n");
  }
}
  if ($user["pcoff"] == 'yes')
{
print("<font size=\"2\" color=\"yellow\">PC-aee??ai</font>");        }
   else
   {
  print("<font size=\"2\" color=\"red\">PC-ecee??ai</font>");
   }
begin_main_frame();
?>
<table width=100% border=1 cellspacing=0 cellpadding=5>
<tr><td class=rowhead width=1%>?aaeno?e?ai</td><td align=left width=99%><?=$joindate?></td></tr>
<?
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if (get_user_class() > UC_MODERATOR)
print("<tr><td class=rowhead><font color=white>Iineaaai iuo a aee a o?aea?a</font></td><td 
align=left>$lastseen</td></tr>\n");
?>
<?
$dt = gmtime() - 180; 
$dt = sqlesc(get_date_time($dt)); 
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
print("<tr><td class=rowhead width=1%>A o?aea?a</td> 
<td class=row1 align=left width=99%>" . ("'".$user['last_access']."'">$dt?"<font color=green><b>Aa</b></font> / <font color=gray>Ia</font>" : "<font color=gray>Aa</font> / <font color=red><b>Ia</b></font>" ) . "</td></tr>"); 
?>
<?
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
	print("<tr><td class=\"rowhead\">Email</td><td align=\"left\"><a href=\"mailto:$user[email]\">$user[email]</a></td></tr>\n");
if ($addr)
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
  print("<tr><td class=rowhead>IP</td><td align=left><a href=http://www.ripe.net/perl/whois?form_type=simple&full_query_string=&searchtext=$ip>$ip ($dom)</a> $ban</td></tr>\n");
  print("<tr><td class=rowhead>Nenoaiia eioi?iaoey</td><td align=left>". getenv("HTTP_USER_AGENT") ."</td></tr>\n");
  print("<tr><td class=rowhead><font color=white>Iaa?aae</font></td><td align=left>$kubok</td></tr>\n");
  //  if ($user["id"] == $CURUSER["id"] || get_user_class() >= UC_MODERATOR)
//	{
?>

<tr><td class=rowhead>Ii?o</font></td><td class=tablea align=left><?=$user['port']?></td></tr>
<tr><td class=rowhead>Eeeaio</font></td><td class=tablea align=left><?=$user['agent']?></td></tr>
<tr><td class=rowhead>Ea?aii</td><td align=left><?=mksize($user["uploaded"])?></td></tr>
<tr><td class=rowhead>Naaeaii</td><td align=left><?=mksize($user["downloaded"])?></td></tr>
<?if (get_user_class() == UC_SYSOP && $user['invisible'] == "no") {
print("<tr><td class=\"rowhead\">Aeaai</td><td align=\"left\"><a href=userdetails.php?invisible=yes&id=".$user['id'].">Naaeaou iaaeaeiui</a></td></tr>");
}
if (get_user_class() == UC_SYSOP && $user['invisible'] == "yes") {
print("<tr><td class=\"rowhead\">Iaaeaai</td><td align=\"left\"><a href=userdetails.php?invisible=no&id=".$user['id'].">Naaeaou aeaeiui</a></td></tr>");
}?> 
<tr><td class=rowhead>Iau o?aoee</td><td align=left><?=mksize($user["downloaded"] + $user["uploaded"])?></td></tr>
<?
$speedu = mysql_query("SELECT sum(((p.uploaded - p.uploadoffset )) / (
unix_timestamp(p.last_action) - unix_timestamp(p.started))) AS speed FROM peers p INNER
JOIN users u ON p.userid=u.id WHERE u.id=$user[id]");
$tu=mysql_fetch_array($speedu);
$speeduu = mksize($tu["speed"])or sqlerr(__FILE__, __LINE__);

print("<tr><td class=rowhead><font color=white>Nei?ino ia ea?aaia</font></td><td 
align=left>$speeduu</td></tr>\n");

$speedd = mysql_query("SELECT sum(((p.downloaded - p.downloadoffset )) / (
unix_timestamp(p.last_action) - unix_timestamp(p.started))) AS speed FROM peers p INNER
JOIN users u ON p.userid=u.id WHERE u.id=$user[id]");
$td=mysql_fetch_array($speedd);
$speeddd = mksize($td["speed"])or sqlerr(__FILE__, __LINE__);

print("<tr><td class=rowhead><font color=white>Nei?ino ia naaeyia</font></td><td 
align=left>$speeddd</td></tr>\n");  

if (get_user_class() >= UC_MODERATOR)
	print("<tr><td class=\"rowhead\">Iieaie</td><td align=left><a href=\"invite.php?id=$id\">".$user["invites"]."</a></td></tr>");
if ($user["invitedby"] != 0) {
	$inviter = mysql_fetch_assoc(sql_query("SELECT username FROM users WHERE id = ".sqlesc($user["invitedby"])));
	print("<tr><td class=\"rowhead\">Iieaiee</td><td align=\"left\"><a href=\"userdetails.php?id=$user[invitedby]\">$inviter[username]</a></td></tr>");
}
if ($user["downloaded"] > 0) {
  $sr = $user["uploaded"] / $user["downloaded"];
  if ($sr >= 4)
    $s = "w00t";
  else if ($sr >= 2)
    $s = "grin";
  else if ($sr >= 1)
    $s = "smile1";
  else if ($sr >= 0.5)
    $s = "noexpression";
  else if ($sr >= 0.25)
    $s = "sad";
  else
    $s = "cry";
  $sr = floor($sr * 1000) / 1000;
  $sr = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td class=\"embedded\"><font color=\"" . get_ratio_color($sr) . "\">" . number_format($sr, 3) . "</font></td><td class=\"embedded\">  <img src=\"pic/smilies/$s.gif\"></td></tr></table>";
  print("<tr><td class=\"rowhead\" style=\"vertical-align: middle\">?aeoeia</td><td align=\"left\" valign=\"center\" style=\"padding-top: 1px; padding-bottom: 0px\">$sr</td></tr>\n");
  print("<tr><td class=\"rowhead\">Aiion</td><td align=\"left\">".($user['bonus'])."</a></td></tr>\n"); 
}
if (get_user_class() >= UC_MODERATOR)
{        
if (!$_GET["ratings"])

                tr("Get Ratings<br /><a href=\"userdetails.php?id=$id&ratings=1$keepget#ratings\" class=\"sublink\">[See full list]</a>", $row["numratings"] . " ratings", 1);

            else {

                tr("Get Ratings", $row["numratings"] . " ratings", 1);


                $s = "<table class=main border=\"1\" cellspacing=0 cellpadding=\"5\">\n";


                $subres = mysql_query("SELECT * FROM ratings WHERE user = $id ORDER BY user");

$s.="<tr><td class=colhead>Path</td><td class=colhead align=right>Size</td></tr>\n";
                while ($subrow = mysql_fetch_array($subres)) {
$ratingid=$subrow["torrent"];
$sd=mysql_query("SELECT name FROM torrents WHERE id=$ratingid");
$fetched_result = mysql_fetch_array($sd);
$sd = $fetched_result['name'];
                    $s .= "<tr><td><a href=details.php?id=$ratingid>" . $sd .

                            "</a></td><td align=\"right\">" . $subrow["rating"] . "</td></tr>\n";
                }
                $s .= "</table>\n";
                tr("<a name=\"filelist\">Rating's</a><br /><a href=\"userdetails.php?id=$id$keepget\" class=\"sublink\">[Hide list]</a>", $s, 1);
            }}
//}
if ($user["icq"] || $user["msn"] || $user["aim"] || $user["yahoo"] || $user["skype"])
{

if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
print("<tr><td class=rowhead><b>A?ucea</b></td><td align=left>\n");

if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["icq"])
    print("<img src=\"http://web.icq.com/whitepages/online?icq=$user[icq]&img=5\" alt=\"icq\" border=\"0\" /> $user[icq] <br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["msn"])
    print("<img src=\"pic/contact/msn.gif\" alt=\"msn\" border=\"0\" /> $user[msn]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["aim"])
    print("<img src=\"pic/contact/aim.gif\" alt=\"aim\" border=\"0\" /> $user[aim]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["yahoo"])
    print("<img src=\"pic/contact/yahoo.gif\" alt=\"yahoo\" border=\"0\" /> $user[yahoo]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["skype"])
    print("<img src=\"pic/contact/skype.gif\" alt=\"skype\" border=\"0\" /> $user[skype]<br />\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["mirc"])
    print("<img src=\"pic/contact/mirc.gif\" alt=\"mirc\" border=\"0\" /> $user[mirc]\n");
?> 
</td>
</tr>

<?
}
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["website"])
	print("<tr><td class=\"rowhead\">Naeo</td><td align=\"left\"><a href=\"$user[website]\" target=\"_blank\">$user[website]</a></td></tr>\n");
//if ($user['donated'] > 0 && (get_user_class() >= UC_MODERATOR || $CURUSER["id"] == $user["id"]))
//  print("<tr><td class=rowhead>Donated</td><td align=left>$$user[donated]</td></tr>\n");
if ($user["avatar"])
	print("<tr><td class=\"rowhead\">Aaaoa?</td><td align=left><img src=\"" . htmlspecialchars($user["avatar"]) . "\"></td></tr>\n");
print("<tr><td class=\"rowhead\">?aia</td><td align=\"left\"><b> <img src=" . get_user_class_image($user["class"]) . " alt=" . get_user_class_name($user["class"]) . "></td></tr>\n");
//////////////////////////////////////////////////////////////
///////////////  Iia aaoiiiie?aiey aieiaaa?ia  //////////////
////////////////////////////////////////////////////////////

if ($user["class"] == 3){ //Anee aieiaaa?

   if (get_user_class() >= UC_MODERATOR or $user["id"] == $CURUSER["id"]){ //Ainooi Iiaa?aoi?ai e auoa, naiiio iieuciaaoae?

   $fromup = sql_query("SELECT releas, days, sended FROM uploaders WHERE userid=".$user['id']."") or sqlerr(__FILE__,__LINE__);
   $testup = mysql_fetch_array($fromup); //Auae?aai iieuciaaoaey ec oaaeeou aieiaaa?ia
   
   if (!$testup){ //Anee ii eaeie-oi i?e?eia aai iao a oaaeeoa uploaders (i?iaa?ea)
   $messtxt = "<font color='red'><b>I?iaa?ea iieuciaaoaey ia i?iecaiaeony</b></font>"; //Auaiaeiia niiauaiea
   }
   else
   {
       $days = "<font color='red'><b>".$testup['days']." ai.</b></font>"; //Neieuei aiae ai aicii?iiai iiie?aiey
   
       if ($testup['releas'] == "no"){ //Anou eee iao ?aeecu 
       $releas = "<font color='red'><b>AEE</b> (iao ?aeecia)</font>";
       } else {
       $releas = "<font color='green'><b>AUEE</b> (anou ?aeecu)</font>";
       }
   
       if ($testup['sended'] == "yes"){ //Ioi?aaeaii ee i?aaoi?a?aaiea 
       $sended = "<font color='red'>, <b>i?aaoi?a?aai</b>(<b>a</b>)</b></font>";
       } else {
       $sended = "";
       }
   
   $messtxt = "<b>Inoaeinu</b>: ".$days."  <b>Iiie?aiea</b>: ".$releas."".$sended.""; //Auaiaeiia niiauaiea
   }

   print("<tr><td class=\"rowhead\">Aaoiiiie?aiea</td><td align=left>".$messtxt."</td></tr>\n"); //Auaiaei a i?ioeeu
   }
}
//////////////////////////////////////////////////////////////
///////////////  Iia aaoiiiie?aiey aieiaaa?ia  //////////////
////////////////////////////////////////////////////////////   
print("<tr><td class=\"rowhead\">Oeoea</td><td align=\"left\"><b>" . ($user["title"] != "" ? "  <span style=\"color: red;\">{$user["title"]}</span>" : "") . "</b></td></tr>\n");
print("<tr><td class=\"rowhead\">Iie</td><td align=\"left\">$gender</td></tr>\n");
if($user["birthday"]!='0000-00-00') {
        print("<tr><td class=\"rowhead\">Auc?ano</td><td align=\"left\">$age</td></tr>\n");
        $birthday = date("d.m.Y", strtotime($birthday));
        print("<tr><td class=\"rowhead\">Aaoa ia ?a?aaia</td><td align=\"left\">$birthday</td></tr>\n");

$month_of_birth = substr($user["birthday"], 5, 2);
        $day_of_birth = substr($user["birthday"], 8, 2);
        for($i = 0; $i < count($zodiac); $i++) {
                if (($month_of_birth == substr($zodiac[$i][2], 3, 2)))  {
                        if ($day_of_birth >= substr($zodiac[$i][2], 0, 2)) {
                                $zodiac_img = $zodiac[$i][1];
                                $zodiac_name = $zodiac[$i][0];
                        }
                        else {
                                if ($i == 11) {
                                        $zodiac_img = $zodiac[0][1];
                                        $zodiac_name = $zodiac[0][0];
                                }
                                else {
                                        $zodiac_img = $zodiac[$i+1][1];
                                        $zodiac_name = $zodiac[$i+1][0];
                                }
                        }
                }

        }

print("<tr><td class=\"rowhead\">Ciaeaeaeai ciae</td><td align=\"left\"><img src=\"pic/zodiac/" . $zodiac_img . "\" alt=\"" . $zodiac_name . "\" title=\"" . $zodiac_name . "\"></td></tr>\n");

}

if ($user['simpaty'] != 0) {
        if ((get_user_class() >= UC_MODERATOR && $user['class'] < get_user_class()) || $user['id'] == $CURUSER['id']) {
                $simpaty = ($user['simpaty'] > 0?'<img src="pic/thum_good.gif" border="0"> <a href="mysimpaty.php?id=' . $user['id'] . '">' . $user['simpaty'] . '</a>':'<img src="pic/thum_bad.gif" border="0"> <a href="mysimpaty.php?id=' . $user['id'] . '">' . $user['simpaty'] . '</a>');
        }
        else {
                $simpaty = ($user['simpaty'] > 0?'<img src="pic/thum_good.gif"> ' . $user['simpaty']:'<img src="pic/thum_bad.gif"> ' . $user['simpaty']);
        }
} 

if ($user['simpaty'] != 0) {
print("<tr><td class=\"rowhead\">?aniaeoe</td><td align=\"left\">$simpaty</td></tr>\n");
};

print("<tr><td class=\"rowhead\">Eiiaioa?e</td>");
if ($torrentcomments && (($user["class"] >= UC_POWER_USER && $user["id"] == $CURUSER["id"]) || get_user_class() >= UC_MODERATOR))
	print("<td align=\"left\"><a href=\"userhistory.php?action=viewcomments&id=$id\">$torrentcomments</a></td></tr>\n");
else
	print("<td align=\"left\">$torrentcomments</td></tr>\n");
if (get_user_class() >= UC_MODERATOR)
    print("<tr><td class=rowhead width=1%><font color=red>Delete all Com.</font></td><td align=left width=99%><a href=comdel.php?id=$id><b>Click Here</b></a></td></tr>\n");


?><script language="javascript" type="text/javascript" src="js/show_hide.js"></script><?
$dt = sqlesc(get_date_time(gmtime() - 180)); //-- 3 minutes without activity
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if ($user["last_access"] < $dt)
  print("<tr><td class=\"rowhead\">A iiiaioa</td><td class=tablea>(No useractivity)</td></tr>\n");
else
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
  print("<tr><td class=\"rowhead\">A iiiaioa</td><td class=tablea>". $user["page_now"] ."</td></tr>\n");
if (get_user_class() > UC_USER)
if (get_user_class() > UC_POWER_USER)
if (get_user_class() > UC_VIP)
if (get_user_class() > UC_UPLOADER)
if (!$user["page_now"])
  print("<tr><td class=\"rowhead\">A iiiaioa</td><td class=tablea>(Never active)</td></tr>\n");
if ($user["groups"]) { 
  print("<tr><td class=\"rowhead\"><b>Ioai?</b></td><td class=\"tablea\" align=\"left\">".$groups."</td></tr>\n");    
  }
if ($torrents)
 print("<tr valign=\"top\"><td class=\"rowhead\">Ea?aie Oi?aioe</td><td align=\"left\"><a href=\"javascript: show_hide('s1')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics1\" title=\"Iieacaou\"></a><div id=\"ss1\" style=\"display: none;\">$torrents</div></td></tr>\n");
if ($seeding)
 print("<tr valign=\"top\"><td class=\"rowhead\">A iiiaioa neeaaa</td><td align=\"left\"><a href=\"javascript: show_hide('s2')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics2\" title=\"Iieacaou\"></a><div id=\"ss2\" style=\"display: none;\">$seeding</div></td></tr>\n");
if ($leeching)
 print("<tr valign=\"top\"><td class=\"rowhead\">A iiiaioa niueaa</td><td align=\"left\"><a href=\"javascript: show_hide('s3')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics3\" title=\"Iieacaou\"></a><div id=\"ss3\" style=\"display: none;\">$leeching</div></td></tr>\n");
if ($completed)
 print("<tr valign=\"top\"><td class=\"rowhead\">Ecoaaeaie Oi?aioe</td><td align=\"left\"><a href=\"javascript: show_hide('s4')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics4\"></a><div id=\"ss4\" style=\"display: none;\">$completed</div></td></tr>\n");
if ($invitetree)
 print("<tr valign=\"top\"><td class=\"rowhead\">Iieaia</td><td align=\"left\"><a href=\"javascript: show_hide('s5')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pics5\"></a><div id=\"ss5\" style=\"display: none;\">$invitetree</div></td></tr>\n");

if ($user["info"])
 print("<tr valign=\"top\"><td align=\"left\" colspan=\"2\" class=\"text\" bgcolor=\"#F4F4F0\">" . format_comment($user["info"]) . "</td></tr>\n");

if ($CURUSER["id"] != $user["id"])
	if (get_user_class() >= UC_MODERATOR)
  	$showpmbutton = 1;
	elseif ($user["acceptpms"] == "yes")
	{
		$r = sql_query("SELECT id FROM blocks WHERE userid = $user[id] AND blockid = $CURUSER[id]") or sqlerr(__FILE__,__LINE__);
		$showpmbutton = (mysql_num_rows($r) == 1 ? 0 : 1);
	}
	elseif ($user["acceptpms"] == "friends")
	{
		$r = sql_query("SELECT id FROM friends WHERE userid = $user[id] AND friendid = $CURUSER[id]") or sqlerr(__FILE__,__LINE__);
		$showpmbutton = (mysql_num_rows($r) == 1 ? 1 : 0);
	}
if ($showpmbutton)
$elapsed = (date('U')-strtotime($user['last_download'])) / 60;
$elapsed = (int) $elapsed;
print("<tr><td class=rowhead>Iineaaii naaeyia</td><td align=left>".$user['last_download'].", ecieiaee ieiooe: ".$elapsed ."</td></tr>\n"); 
	print("<tr><td colspan=2 align=center><form method=\"get\" action=\"message.php\"> 
        <input type=\"hidden\" name=\"receiver\" value=" .$user["id"] . "> 
        <input type=\"hidden\" name=\"action\" value=\"sendmessage\"> 
        <input type=submit value=\"Eci?aoe EN\" style=\"height: 23px\"> 
        </form></td></tr>");

print("</table>\n");
begin_frame("Iiaa?uoe ia iio?aaeoaey $user[username]", true);
$gifts = mysql_query("SELECT * FROM gift WHERE sender='$user[id]' ORDER BY id DESC");
$gift = mysql_fetch_array ($gifts);
if ($gift[sender] == '') { 
stdmsg($tracker_lang['error'], 'Oice iio?aaeoae iyia iiaa?uoe!');
  }else{
do {
print ("<a href=\"gift/$gift[idgift].jpg\" rel=\"sexylightbox\"><img style='width:96px; height:96px; border-style:none;' src='gift/$gift[idgift].jpg'></a>");
print (" ");
} while ($gift = mysql_fetch_array ($gifts));}
?>
<div align="right">
<form action="gift.php" method="post">
<input name="userid" type="hidden" value="<?=$user[id]?>">
<input name="addressee" type="hidden" value="<?=$CURUSER[id]?>">
<input name="username" type="hidden" value="<?=$user[username]?>">
<input name="submit" type="submit" value="Ane?ee iiaa?uoe">
</form></div>
<div align="right">
<form action="addgift.php" method="post">
<input name="userid" type="hidden" value="<?=$user[id]?>">
<input name="username" type="hidden" value="<?=$user[username]?>">
<input name="submit" type="submit" value="Iiaa?e iiaa?ue">
</form></div>
<font color='red'>Aieiaiea, anaee aaei iiaa?ue no?oaa ii?aaaeai a?ie aiion oi?ee!</font>
<?
end_frame();
////////////////////////////////////////////////////////////////////////////////
/////////////////////=========Iioee Ae?aeoi?a===========///////////////////////
//////////////////////////////////////////////////////////////////////////////

if (get_user_class() == UC_SYSOP){
  print("<br>");
  begin_frame("Iioee ia Oaoa", true);
  print("<form method=\"post\" action=\"takeuseredit.php\">");
  print("<input type=\"hidden\" name=\"id\" value=\"".$id."\">");
  print("<table class=\"main\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\" width=\"100%\">");

//Niaieou eiy

  print("<tr><td c

Какво означава този код ?

raio

Registered

stonybg

Registered

ExpressYourself

Registered

raio

Registered

ExpressYourself

Registered

misho

Registered

bancov96

Registered

raio

Registered

misho

Registered