No database selected

if(!mysql_select_db('db1'))
  exit(mysql_error()); 

if (!@mysql_connect($mysql_host, $mysql_user, $mysql_pass))
        die("[" . mysql_errno() . "] dbconn: mysql_connect: " . mysql_error());
    mysql_select_db($mysql_db)
        or die("dbconn: mysql_select_db: " . mysql_error());
    mysql_query("SET NAMES $mysql_charset");

if (!@mysql_connect($mysql_host, $mysql_user, $mysql_pass))
    {
        err('dbconn: mysql_connect: ' . mysql_error());
    }
    mysql_select_db($mysql_db) or err('dbconn: mysql_select_db: ' + mysql_error());
    mysql_query('SET NAMES '.$mysql_charset);
    register_shutdown_function("mysql_close");

global $mysql_host, $mysql_db, $mysql_user, $mysql_pass;
    if ($mysql_pass!='') {
        $link = @mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Cannot connect to database!"); 
    } else {
        $link = @mysql_connect($mysql_host, $mysql_user) or die("Cannot connect to database!"); 
    }
    mysql_select_db($mysql_db) or die("Cannot select database!");
    return $link;

 <?
$mysql_host = "localhost";
$mysql_user = "superroot";
$mysql_pass = "qwerty54327";
$mysql_db = "torrent";
$mysql_charset = "cp1251";
?>

 <?php
/
*/
# IMPORTANT: Do not edit below unless you know what you are doing!
if(!defined('IN_TRACKER'))
  die('Hacking attempt!');
require_once($rootpath . 'include/functions_global.php');
require_once($rootpath . 'include/functions_torrenttable.php');
require_once($rootpath . 'include/functions_commenttable.php');
function strip_magic_quotes($arr) {
    foreach ($arr as $k => $v) {
        if (is_array($v)) {
            $arr[$k] = strip_magic_quotes($v);
            } else {
            $arr[$k] = stripslashes($v);
            }
    }
    return $arr;
}
function local_user() {
    return $_SERVER["SERVER_ADDR"] == $_SERVER["REMOTE_ADDR"];
}
function sql_query($query) {
    global $queries, $query_stat, $querytime;
    $queries++;
    $query_start_time = timer(); // Start time
    $result = mysql_query($query);
    $query_end_time = timer(); // End time
    $query_time = ($query_end_time - $query_start_time);
    $querytime = $querytime + $query_time;
    $query_stat[] = array("seconds" => $query_time, "query" => $query);
    return $result;
}
function dbconn($autoclean = false, $lightmode = false) {
    global $mysql_host, $mysql_user, $mysql_pass, $mysql_db, $mysql_charset;
    if (!@mysql_connect($mysql_host, $mysql_user, $mysql_pass))
        die("[" . mysql_errno() . "] dbconn: mysql_connect: " . mysql_error());
    mysql_select_db($mysql_db)
        or die("dbconn: mysql_select_db: " . mysql_error());
    mysql_query("SET NAMES $mysql_charset");
    userlogin($lightmode);
    if (basename($_SERVER['SCRIPT_FILENAME']) == 'index.php')
        register_shutdown_function("autoclean");
    register_shutdown_function("mysql_close");
}
function userlogin($lightmode = false) {
    global $SITE_ONLINE, $default_language, $tracker_lang, $use_lang, $use_ipbans;
    unset($GLOBALS["CURUSER"]);
    if (COOKIE_SALT == '' || (COOKIE_SALT == 'default' && $_SERVER['SERVER_ADDR'] != '127.0.0.1' && $_SERVER['SERVER_ADDR'] != $_SERVER['REMOTE_ADDR']))
        die('Скрипт заблокирован! Измените значение переменной COOKIE_SALT в файле include/init.php на случайное');
    $ip = getip();
    $nip = ip2long($ip);
    if ($use_ipbans && !$lightmode) {
        $res = sql_query("SELECT * FROM bans WHERE $nip >= first AND $nip <= last") or sqlerr(__FILE__, __LINE__);
        if (mysql_num_rows($res) > 0) {
            $comment = mysql_fetch_assoc($res);
            $comment = $comment["comment"];
            header("HTTP/1.0 403 Forbidden");
            print("<html><body><h1>403 Forbidden</h1>Unauthorized IP address.</body></html>\n");
            die;
        }
    }
    $c_uid = $_COOKIE["uid"];
    $c_pass = $_COOKIE["pass"];
    if (!$SITE_ONLINE || empty($c_uid) || empty($c_pass)) {
        if ($use_lang)
            include_once('languages/lang_' . $default_language . '/lang_main.php');
        user_session();
        return;
    }
    $id = intval($c_uid);
    if (!$id || strlen($c_pass) != 32) {
        die("Cokie ID invalid or cookie pass hash problem.");
        /*if ($use_lang)
            include_once('languages/lang_' . $default_language . '/lang_main.php');
        user_session();
        return;*/
    }
    $res = sql_query("SELECT * FROM users WHERE id = $id AND enabled='yes' AND status = 'confirmed'");// or die(mysql_error());
    $row = mysql_fetch_array($res);
    if (!$row) {
        if ($use_lang)
            include_once('languages/lang_' . $default_language . '/lang_main.php');
        user_session();
        return;
    }
    $subnet = explode('.', getip());
    $subnet[2] = $subnet[3] = 0;
    $subnet = implode('.', $subnet); // 255.255.0.0
    if ($c_pass !== md5($row["passhash"] . COOKIE_SALT . $subnet)) {
        if ($use_lang)
            include_once('languages/lang_' . $default_language . '/lang_main.php');
        user_session();
        return;
    }
    sql_query("UPDATE users SET last_access = ".sqlesc(get_date_time()).", ip = ".sqlesc($ip)." WHERE id=" . $row["id"]);// or die(mysql_error());
    $row['ip'] = $ip;
    if ($row['override_class'] < $row['class'])
        $row['class'] = $row['override_class']; // Override class and save in GLOBAL array below.
    $GLOBALS["CURUSER"] = $row;
    if ($use_lang)
        include_once('languages/lang_' . $row['language'] . '/lang_main.php');
    if (!$lightmode)
        user_session();
}
function get_server_load() {
    global $tracker_lang, $phpver;
    if (strtolower(substr(PHP_OS, 0, 3)) === 'win') {
        return 0;
    } elseif (@file_exists("/proc/loadavg")) {
        $load = @file_get_contents("/proc/loadavg");
        $serverload = explode(" ", $load);
        $serverload[0] = round($serverload[0], 4);
        if(!$serverload) {
            $load = @exec("uptime");
            $load = @split("load averages?: ", $load);
            $serverload = explode(",", $load[1]);
        }
    } else {
        $load = @exec("uptime");
        $load = @split("load averages?: ", $load);
        $serverload = explode(",", $load[1]);
    }
    $returnload = trim($serverload[0]);
    if(!$returnload) {
        $returnload = $tracker_lang['unknown'];
    }
    return $returnload;
}
function user_session() {
    global $CURUSER, $use_sessions;
    if (!$use_sessions)
        return;
    $ip = getip();
    $url = getenv("REQUEST_URI");
    if (!$CURUSER) {
        $uid = -1;
        $username = '';
        $class = -1;
    } else {
        $uid = $CURUSER['id'];
        $username = $CURUSER['username'];
        $class = $CURUSER['class'];
    }
    $past = time() - 300;
    $sid = session_id();
    $where = array();
    $updateset = array();
    if ($sid)
        $where[] = "sid = ".sqlesc($sid);
    elseif ($uid)
        $where[] = "uid = $uid";
    else
        $where[] = "ip = ".sqlesc($ip);
    //sql_query("DELETE FROM sessions WHERE ".implode(" AND ", $where));
    $ctime = time();
    $agent = $_SERVER["HTTP_USER_AGENT"];
    $updateset[] = "sid = ".sqlesc($sid);
    $updateset[] = "uid = ".sqlesc($uid);
    $updateset[] = "username = ".sqlesc($username);
    $updateset[] = "class = ".sqlesc($class);
    $updateset[] = "ip = ".sqlesc($ip);
    $updateset[] = "time = ".sqlesc($ctime);
    $updateset[] = "url = ".sqlesc($url);
    $updateset[] = "useragent = ".sqlesc($agent);
    if (count($updateset))
        sql_query("UPDATE sessions SET ".implode(", ", $updateset)." WHERE ".implode(" AND ", $where)) or sqlerr(__FILE__,__LINE__);
    if (mysql_modified_rows() < 1)
        sql_query("INSERT INTO sessions (sid, uid, username, class, ip, time, url, useragent) VALUES (".implode(", ", array_map("sqlesc",
                                    array($sid, $uid, $username, $class, $ip, $ctime, $url, $agent))).")") or sqlerr(__FILE__,__LINE__);
}
function unesc($x) {
    if (get_magic_quotes_gpc())
        return stripslashes($x);
    return $x;
}
function gzip() {
    global $use_gzip;
    static $already_loaded;
    if (extension_loaded('zlib') && ini_get('zlib.output_compression') != '1' && ini_get('output_handler') != 'ob_gzhandler' && $use_gzip && !$already_loaded) {
        @ob_start('ob_gzhandler');
    } elseif (!$already_loaded)
        @ob_start();
    $already_loaded = true;
}
// IP Validation
function validip($ip) {
    if (!empty($ip) && $ip == long2ip(ip2long($ip)))
    {
        // reserved IANA IPv4 addresses
        // http://www.iana.org/assignments/ipv4-address-space
        $reserved_ips = array (
                array('0.0.0.0','2.255.255.255'),
                array('10.0.0.0','10.255.255.255'),
                array('127.0.0.0','127.255.255.255'),
                array('169.254.0.0','169.254.255.255'),
                array('172.16.0.0','172.31.255.255'),
                array('192.0.2.0','192.0.2.255'),
                array('192.168.0.0','192.168.255.255'),
                array('255.255.255.0','255.255.255.255')
        );
        foreach ($reserved_ips as $r) {
                $min = ip2long($r[0]);
                $max = ip2long($r[1]);
                if ((ip2long($ip) >= $min) && (ip2long($ip) <= $max)) return false;
        }
        return true;
    }
    else return false;
}
function getip() {
    // Code commented due to possible hackers/banned users to fake their ip with http headers
    /*if (isset($_SERVER)) {
        if (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && validip($_SERVER['HTTP_X_FORWARDED_FOR'])) {
            $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
        } elseif (isset($_SERVER['HTTP_CLIENT_IP']) && validip($_SERVER['HTTP_CLIENT_IP'])) {
            $ip = $_SERVER['HTTP_CLIENT_IP'];
        } else {
            $ip = $_SERVER['REMOTE_ADDR'];
        }
    } else {
        if (getenv('HTTP_X_FORWARDED_FOR') && validip(getenv('HTTP_X_FORWARDED_FOR'))) {
            $ip = getenv('HTTP_X_FORWARDED_FOR');
        } elseif (getenv('HTTP_CLIENT_IP') && validip(getenv('HTTP_CLIENT_IP'))) {
            $ip = getenv('HTTP_CLIENT_IP');
        } else {
            $ip = getenv('REMOTE_ADDR');
         }
    }*/
    $ip = getenv('REMOTE_ADDR');
    return $ip;
}
function autoclean() {
    global $autoclean_interval, $rootpath;
    $now = time();
    $docleanup = 0;
    $res = sql_query("SELECT value_u FROM avps WHERE arg = 'lastcleantime'");
    $row = mysql_fetch_array($res);
    if (!$row) {
        sql_query("INSERT INTO avps (arg, value_u) VALUES ('lastcleantime',$now)");
        return;
    }
    $ts = $row[0];
    if ($ts + $autoclean_interval > $now)
        return;
    sql_query("UPDATE avps SET value_u=$now WHERE arg='lastcleantime' AND value_u = $ts");
    if (!mysql_affected_rows())
        return;
    require_once($rootpath . 'include/cleanup.php');
    docleanup();
}
function mksize($bytes) {
    if ($bytes < 1000 * 1024)
        return number_format($bytes / 1024, 2) . " kB";
    elseif ($bytes < 1000 * 1048576)
        return number_format($bytes / 1048576, 2) . " MB";
    elseif ($bytes < 1000 * 1073741824)
        return number_format($bytes / 1073741824, 2) . " GB";
    else
        return number_format($bytes / 1099511627776, 2) . " TB";
}
function mksizeint($bytes) {
        $bytes = max(0, $bytes);
        if ($bytes < 1000)
                return floor($bytes) . " B";
        elseif ($bytes < 1000 * 1024)
                return floor($bytes / 1024) . " kB";
        elseif ($bytes < 1000 * 1048576)
                return floor($bytes / 1048576) . " MB";
        elseif ($bytes < 1000 * 1073741824)
                return floor($bytes / 1073741824) . " GB";
        else
                return floor($bytes / 1099511627776) . " TB";
}
function deadtime() {
    global $announce_interval;
    return time() - floor($announce_interval * 1.3);
}
function mkprettytime($s) {
    if ($s < 0)
    $s = 0;
    $t = array();
    foreach (array("60:sec","60:min","24:hour","0:day") as $x) {
        $y = explode(":", $x);
        if ($y[0] > 1) {
            $v = $s % $y[0];
            $s = floor($s / $y[0]);
        } else
            $v = $s;
    $t[$y[1]] = $v;
    }
    if ($t["day"])
    return $t["day"] . "d " . sprintf("%02d:%02d:%02d", $t["hour"], $t["min"], $t["sec"]);
    if ($t["hour"])
    return sprintf("%d:%02d:%02d", $t["hour"], $t["min"], $t["sec"]);
    return sprintf("%d:%02d", $t["min"], $t["sec"]);
}
function mkglobal($vars) {
    if (!is_array($vars))
        $vars = explode(":", $vars);
    foreach ($vars as $v) {
        if (isset($_GET[$v]))
            $GLOBALS[$v] = unesc($_GET[$v]);
        elseif (isset($_POST[$v]))
            $GLOBALS[$v] = unesc($_POST[$v]);
        else
            return 0;
    }
    return 1;
}
function tr($x, $y, $noesc=0, $prints = true, $width = "", $relation = '') {
    if ($noesc)
        $a = $y;
    else {
        $a = htmlspecialchars_uni($y);
        $a = str_replace("\n", "<br />\n", $a);
    }
    if ($prints) {
      $print = "<td width=\"". $width ."\" class=\"heading\" valign=\"top\" align=\"right\">$x</td>";
      $colpan = "align=\"left\"";
    } else {
        $colpan = "colspan=\"2\"";
    }
    print("<tr".( $relation ? " relation=\"$relation\"" : "").">$print<td valign=\"top\" $colpan>$a</td></tr>\n");
}
function validfilename($name) {
    return preg_match('/^[^\0-\x1f:\\\\\/?*\xff#<>|]+$/si', $name);
}
function validemail($email) {
    if (ereg("^([A-Za-z0-9]+_+)|([A-Za-z0-9]+\-+)|([A-Za-z0-9]+\.+)|([A-Za-z0-9]+\++))*[A-Za-z0-9]+@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$", $email)) 
        return true;
    else
        return false;
}
function send_pm($sender, $receiver, $added, $subject, $msg) {
    sql_query('INSERT INTO messages (sender, receiver, added, subject, msg) VALUES ('.implode(', ', array_map('sqlesc', array($sender, $receiver, $added, $subject, $msg))).')') or sqlerr(__FILE__,__LINE__);
}
function sent_mail($to,$fromname,$fromemail,$subject,$body,$multiple=false,$multiplemail='') {
    global $SITENAME,$SITEEMAIL,$smtptype,$smtp,$smtp_host,$smtp_port,$smtp_from,$smtpaddress,$accountname,$accountpassword,$rootpath;
    # Sent Mail Function v.05 by xam (This function to help avoid spam-filters.)
    $result = true;
    if ($smtptype == 'default') {
        @mail($to, $subject, $body, "From: $SITEEMAIL") or $result = false;
    } elseif ($smtptype == 'advanced') {
    # Is the OS Windows or Mac or Linux?
    if (strtoupper(substr(PHP_OS,0,3)=='WIN')) {
        $eol="\r\n";
        $windows = true;
    }
    elseif (strtoupper(substr(PHP_OS,0,3)=='MAC'))
        $eol="\r";
    else
        $eol="\n";
    $mid = md5(getip() . $fromname);
    $name = $_SERVER["SERVER_NAME"];
    $headers .= "From: $fromname <$fromemail>".$eol;
    $headers .= "Reply-To: $fromname <$fromemail>".$eol;
    $headers .= "Return-Path: $fromname <$fromemail>".$eol;
    $headers .= "Message-ID: <$mid thesystem@$name>".$eol;
    $headers .= "X-Mailer: PHP v".phpversion().$eol;
    $headers .= "MIME-Version: 1.0".$eol;
    $headers .= "Content-type: text/plain; charset=windows-1251".$eol;
    $headers .= "X-Sender: PHP".$eol;
    if ($multiple)
        $headers .= "Bcc: $multiplemail.$eol";
    if ($smtp == "yes") {
        ini_set('SMTP', $smtp_host);
        ini_set('smtp_port', $smtp_port);
        if ($windows)
            ini_set('sendmail_from', $smtp_from);
        }
        @mail($to, $subject, $body, $headers) or $result = false;
        ini_restore(SMTP);
        ini_restore(smtp_port);
        if ($windows)
            ini_restore(sendmail_from);
    } elseif ($smtptype == 'external') {
        require_once($rootpath . 'include/smtp/smtp.lib.php');
        $mail = new smtp;
        $mail->debug(true);
        $mail->open($smtp_host, $smtp_port);
        if (!empty($accountname) && !empty($accountpassword))
            $mail->auth($accountname, $accountpassword);
        $mail->from($SITEEMAIL);
        $mail->to($to);
        $mail->subject($subject);
        $mail->body($body);
        $result = $mail->send();
        $mail->close();
    } else
        $result = false;
    return $result;
}
function sqlesc($value) {
    // Stripslashes
   /*if (get_magic_quotes_gpc()) {
       $value = stripslashes($value);
   }*/
   // Quote if not a number or a numeric string
   if (!is_numeric($value)) {
       $value = "'" . mysql_real_escape_string($value) . "'";
   }
   return $value;
}
function sqlwildcardesc($x) {
    return str_replace(array("%","_"), array("\\%","\\_"), mysql_real_escape_string($x));
}
function urlparse($m) {
    $t = $m[0];
    if (preg_match(',^\w+://,', $t))
        return "<a href=\"$t\">$t</a>";
    return "<a href=\"http://$t\">$t</a>";
}
function parsedescr($d, $html) {
    if (!$html) {
      $d = htmlspecialchars_uni($d);
      $d = str_replace("\n", "\n<br>", $d);
    }
    return $d;
}
function stdhead($title = "", $msgalert = true) {
    global $CURUSER, $SITE_ONLINE, $FUNDS, $SITENAME, $DEFAULTBASEURL, $ss_uri, $tracker_lang, $default_theme;
    if (!$SITE_ONLINE)
        die("Site is down for maintenance, please check back again later... thanks<br />");
        header ("Content-Type: text/html; charset=" . $tracker_lang['language_charset']);
        header ("X-Powered-by: TBDev Yuna Scatari Edition - http://bit-torrent.kiev.ua");
        header ("X-Chocolate-to: ICQ 7282521");
        header ("Cache-Control: no-cache");
        header ("Pragma: no-cache");
        if ($title == "")
            $title = $SITENAME .(isset($_GET['yuna'])?" (".TBVERSION.")":'');
        else
            $title = $SITENAME .(isset($_GET['yuna'])?" (".TBVERSION.")":''). " :: " . htmlspecialchars_uni($title);
        if (isset($_GET['styleid']) && $CURUSER) {
            $styleid = $_GET['styleid'];
            if (is_numeric($styleid)) {
                sql_query("UPDATE users SET stylesheet = $styleid WHERE id=" . $CURUSER["id"]) or sqlerr(__FILE__, __LINE__);
                   header("Location: $DEFAULTBASEURL/");
                //$CURUSER["stylesheet"] = $styleid;
            } else {
                die("Сука, ты чего ломаешь?");
            }
        }
    if ($CURUSER) {
        $ss_a = @mysql_fetch_array(@sql_query("SELECT uri FROM stylesheets WHERE id = " . $CURUSER["stylesheet"]));
        if ($ss_a)
            $ss_uri = $ss_a["uri"];
        else
            $ss_uri = $default_theme;
    } else
        $ss_uri = $default_theme;
      if ($msgalert && $CURUSER) {
        $res = sql_query("SELECT COUNT(*) FROM messages WHERE receiver = " . $CURUSER["id"] . " AND unread='yes'") or die("OopppsY!");
        $arr = mysql_fetch_row($res);
        $unread = $arr[0];
      }
    require_once("themes/" . $ss_uri . "/template.php");
    require_once("themes/" . $ss_uri . "/stdhead.php");
} // stdhead
function stdfoot() {
    global $CURUSER, $ss_uri, $tracker_lang, $queries, $tstart, $query_stat, $querytime;
    require_once("themes/" . $ss_uri . "/template.php");
    require_once("themes/" . $ss_uri . "/stdfoot.php");
    if ((DEBUG_MODE || isset($_GET["yuna"])) && count($query_stat)) {
        foreach ($query_stat as $key => $value) {
            print("<div>[".($key+1)."] => <b>".($value["seconds"] > 0.01 ? "<font color=\"red\" title=\"Рекомендуется оптимизировать запрос. Время исполнения превышает норму.\">".$value["seconds"]."</font>" : "<font color=\"green\" title=\"Запрос не нуждается в оптимизации. Время исполнения допустимое.\">".$value["seconds"]."</font>" )."</b> [".htmlspecialchars_uni($value['query'])."]</div>\n");
        }
        print("<br />");
    }
}
function genbark($x,$y) {
    stdhead($y);
    print("<h2>" . htmlspecialchars_uni($y) . "</h2>\n");
    print("<p>" . htmlspecialchars_uni($x) . "</p>\n");
    stdfoot();
    exit();
}
function mksecret($length = 20) {
$set = array("a","A","b","B","c","C","d","D","e","E","f","F","g","G","h","H","i","I","j","J","k","K","l","L","m","M","n","N","o","O","p","P","q","Q","r","R","s","S","t","T","u","U","v","V","w","W","x","X","y","Y","z","Z","1","2","3","4","5","6","7","8","9");
    $str;
    for($i = 1; $i <= $length; $i++)
    {
        $ch = rand(0, count($set)-1);
        $str .= $set[$ch];
    }
    return $str;
}
function httperr($code = 404) {
    $sapi_name = php_sapi_name();
    if ($sapi_name == 'cgi' OR $sapi_name == 'cgi-fcgi') {
        header('Status: 404 Not Found');
    } else {
        header('HTTP/1.1 404 Not Found');
    }
    exit;
}
function gmtime() {
    return strtotime(get_date_time());
}
function logincookie($id, $passhash, $updatedb = 1, $expires = 0x7fffffff) {
    $subnet = explode('.', getip());
    $subnet[2] = $subnet[3] = 0;
    $subnet = implode('.', $subnet); // 255.255.0.0
    setcookie("uid", $id, $expires, "/");
    setcookie("pass", md5($passhash.COOKIE_SALT.$subnet), $expires, "/");
    if ($updatedb)
        sql_query("UPDATE users SET last_login = NOW() WHERE id = $id");
}
function logoutcookie() {
//    setcookie("uid", "", 0x7fffffff, "/");
    setcookie("pass", "", 0x7fffffff, "/");
}
function loggedinorreturn($nowarn = false) {
    global $CURUSER, $DEFAULTBASEURL;
    if (!$CURUSER) {
        header("Location: $DEFAULTBASEURL/login.php?returnto=" . urlencode(basename($_SERVER["REQUEST_URI"])).($nowarn ? "&nowarn=1" : ""));
        exit();
    }
}
function deletetorrent($id) {
    global $torrent_dir;
    $images = mysql_fetch_array(sql_query('SELECT image1, image2, image3, image4, image5 FROM torrents WHERE id = '.$id));
    if ($images) {
        for ($x=1; $x <= 5; $x++) {
            if ($images['image' . $x] != "")
                unlink('torrents/images/' . $images['image' . $x]);
        }
    }
    sql_query("DELETE FROM torrents WHERE id = $id");
    sql_query("DELETE FROM snatched WHERE torrent = $id");
    sql_query("DELETE FROM bookmarks WHERE id = $id");
    sql_query("DELETE FROM readtorrents WHERE torrentid = $id");
    foreach(explode(".","peers.files.comments.ratings") as $x)
        sql_query("DELETE FROM $x WHERE torrent = $id");
    unlink("$torrent_dir/$id.torrent");
}
function pager($rpp, $count, $href, $opts = array()) {
    $pages = ceil($count / $rpp);
    if (!$opts["lastpagedefault"])
        $pagedefault = 0;
    else {
        $pagedefault = floor(($count - 1) / $rpp);
        if ($pagedefault < 0)
            $pagedefault = 0;
    }
    if (isset($_GET["page"])) {
        $page = 0 + (int) $_GET["page"];
        if ($page < 0)
            $page = $pagedefault;
    }
    else
        $page = $pagedefault;
       $pager = "<td class=\"pager\">Страницы:</td><td class=\"pagebr\">&nbsp;</td>";
    $mp = $pages - 1;
    $as = "<b>«</b>";
    if ($page >= 1) {
        $pager .= "<td class=\"pager\">";
        $pager .= "<a href=\"{$href}page=" . ($page - 1) . "\" style=\"text-decoration: none;\">$as</a>";
        $pager .= "</td><td class=\"pagebr\">&nbsp;</td>";
    }
    $as = "<b>»</b>";
    if ($page < $mp && $mp >= 0) {
        $pager2 .= "<td class=\"pager\">";
        $pager2 .= "<a href=\"{$href}page=" . ($page + 1) . "\" style=\"text-decoration: none;\">$as</a>";
        $pager2 .= "</td>$bregs";
    }else     $pager2 .= $bregs;
    if ($count) {
        $pagerarr = array();
        $dotted = 0;
        $dotspace = 3;
        $dotend = $pages - $dotspace;
        $curdotend = $page - $dotspace;
        $curdotstart = $page + $dotspace;
        for ($i = 0; $i < $pages; $i++) {
            if (($i >= $dotspace && $i <= $curdotend) || ($i >= $curdotstart && $i < $dotend)) {
                if (!$dotted)
                   $pagerarr[] = "<td class=\"pager\">...</td><td class=\"pagebr\">&nbsp;</td>";
                $dotted = 1;
                continue;
            }
            $dotted = 0;
            $start = $i * $rpp + 1;
            $end = $start + $rpp - 1;
            if ($end > $count)
                $end = $count;
             $text = $i+1;
            if ($i != $page)
                $pagerarr[] = "<td class=\"pager\"><a title=\"$start&nbsp;-&nbsp;$end\" href=\"{$href}page=$i\" style=\"text-decoration: none;\"><b>$text</b></a></td><td class=\"pagebr\">&nbsp;</td>";
            else
                $pagerarr[] = "<td class=\"highlight\"><b>$text</b></td><td class=\"pagebr\">&nbsp;</td>";
                  }
        $pagerstr = join("", $pagerarr);
        $pagertop = "<table class=\"main\"><tr>$pager $pagerstr $pager2</tr></table>\n";
        $pagerbottom = "Всего $count на $i страницах по $rpp на каждой странице.<br /><br /><table class=\"main\">$pager $pagerstr $pager2</table>\n";
    }
    else {
        $pagertop = $pager;
        $pagerbottom = $pagertop;
    }
    $start = $page * $rpp;
    return array($pagertop, $pagerbottom, "LIMIT $start,$rpp");
}
function downloaderdata($res) {
    $rows = array();
    $ids = array();
    $peerdata = array();
    while ($row = mysql_fetch_assoc($res)) {
        $rows[] = $row;
        $id = $row["id"];
        $ids[] = $id;
        $peerdata[$id] = array(downloaders => 0, seeders => 0, comments => 0);
    }
    if (count($ids)) {
        $allids = implode(",", $ids);
        $res = sql_query("SELECT COUNT(*) AS c, torrent, seeder FROM peers WHERE torrent IN ($allids) GROUP BY torrent, seeder");
        while ($row = mysql_fetch_assoc($res)) {
            if ($row["seeder"] == "yes")
                $key = "seeders";
            else
                $key = "downloaders";
            $peerdata[$row["torrent"]][$key] = $row["c"];
        }
        $res = sql_query("SELECT COUNT(*) AS c, torrent FROM comments WHERE torrent IN ($allids) GROUP BY torrent");
        while ($row = mysql_fetch_assoc($res)) {
            $peerdata[$row["torrent"]]["comments"] = $row["c"];
        }
    }
    return array($rows, $peerdata);
}
function searchfield($s) {
    return preg_replace(array('/[^a-z0-9]/si', '/^\s*/s', '/\s*$/s', '/\s+/s'), array(" ", "", "", " "), $s);
}
function genrelist() {
    $ret = array();
    $res = sql_query("SELECT id, name FROM categories ORDER BY sort ASC");
    while ($row = mysql_fetch_array($res))
        $ret[] = $row;
    return $ret;
}
function linkcolor($num) {
    if (!$num)
        return "red";
//    if ($num == 1)
//        return "yellow";
    return "green";
}
function ratingpic($num) {
    global $pic_base_url, $tracker_lang;
    $r = round($num * 2) / 2;
    if ($r < 1 || $r > 5)
        return;
    return "<img src=\"$pic_base_url$r.gif\" border=\"0\" alt=\"".$tracker_lang['rating'].": $num / 5\" />";
}
function writecomment($userid, $comment) {
    $res = sql_query("SELECT modcomment FROM users WHERE id = '$userid'") or sqlerr(__FILE__, __LINE__);
    $arr = mysql_fetch_assoc($res);
    $modcomment = date("d-m-Y") . " - " . $comment . "" . ($arr[modcomment] != "" ? "\n" : "") . "$arr[modcomment]";
    $modcom = sqlesc($modcomment);
    return sql_query("UPDATE users SET modcomment = $modcom WHERE id = '$userid'") or sqlerr(__FILE__, __LINE__);
}
function hash_pad($hash) {
    return str_pad($hash, 20);
}
function hash_where($name, $hash) {
    $shhash = preg_replace('/ *$/s', "", $hash);
    return "($name = " . sqlesc($hash) . " OR $name = " . sqlesc($shhash) . ")";
}
function get_user_icons($arr, $big = false) {
        if ($big) {
                $donorpic = "starbig.gif";
                $warnedpic = "warnedbig.gif";
                $disabledpic = "disabledbig.gif";
                $style = "style='margin-left: 4pt'";
        } else {
                $donorpic = "star.gif";
                $warnedpic = "warned.gif";
                $disabledpic = "disabled.gif";
                $parkedpic = "parked.gif";
                $style = "style=\"margin-left: 2pt\"";
        }
        $pics = $arr["donor"] == "yes" ? "<img src=\"pic/$donorpic\" alt='Donor' border=\"0\" $style>" : "";
        if ($arr["enabled"] == "yes")
                $pics .= $arr["warned"] == "yes" ? "<img src=pic/$warnedpic alt=\"Warned\" border=0 $style>" : "";
        else
                $pics .= "<img src=\"pic/$disabledpic\" alt=\"Disabled\" border=\"0\" $style>\n";
        $pics .= $arr["parked"] == "yes" ? "<img src=pic/$parkedpic alt=\"Parked\" border=\"0\" $style>" : "";
        return $pics;
}
function parked() {
       global $CURUSER;
       if ($CURUSER["parked"] == "yes")
          stderr($tracker_lang['error'], "Ваш аккаунт припаркован.");
}
// В этой строке забит копирайт. При его убирании можешь поплатиться рабочим трекером ;) В данном случае - убирая строчки ниже ты не сможешь использовать трекер.
define ("VERSION", "Pre 6 RC 0");
define ("TBVERSION", "Powered by <a href=\"http://www.tbdev.net\" target=\"_blank\" style=\"cursor: help;\" title=\"Беспатная OpenSource база\" class=\"copyright\">TBDev</a> v2.1.11pre <a href=\"http://bit-torrent.kiev.ua\" target=\"_blank\" style=\"cursor: help;\" title=\"Сайт разработчика движка\" class=\"copyright\">Yuna Scatari Edition</a> ".VERSION." Copyright &copy; 2001-".date("Y"));
function mysql_modified_rows () {
    $info_str = mysql_info();
    $a_rows = mysql_affected_rows();
    preg_match("/Rows matched: ([0-9]*)/", $info_str, $r_matched);
    return ($a_rows < 1)?($r_matched[1]?$r_matched[1]:0):$a_rows;
}
?>