{

// database connection

public $db;

// connect to database

public function __construct()

{

// attempt to connect

if (

// connection method

!$this->db = (!$_SERVER['tracker']['db_persist'] ?

// default connection

mysql_connect(

$_SERVER['tracker']['db_host'],

$_SERVER['tracker']['db_user'],

$_SERVER['tracker']['db_pass']

) :

// persistent connection

mysql_pconnect(

$_SERVER['tracker']['db_host'],

$_SERVER['tracker']['db_user'],

$_SERVER['tracker']['db_pass']

)

// select database

) OR !mysql_select_db(

$_SERVER['tracker']['db_name'], $this->db

)

// error out if something happened

) tracker_error(

mysql_errno($this->db) . ' - ' .

mysql_error($this->db)

);

}

// close database connection

public function __destruct()

{

mysql_close($this->db);

}

// make sql safe

public function escape_sql($sql)

{

return mysql_real_escape_string($sql, $this->db);

}

// query database

public function query($sql)

{

return mysql_query($sql, $this->db);

}

// return one row

public function fetch_once($sql)

{

// execute query

$query = mysql_query($sql, $this->db) OR tracker_error(mysql_error($this->db));

$result = mysql_fetch_row($query);

// cleanup

mysql_free_result($query);

// return

return $result;

}

// return compact peers

public function peers_compact($sql, &$peers)

{

// fetch peers

$query = mysql_query($sql, $this->db) OR tracker_error('failed to select compact peers');

// build response

while($peer = mysql_fetch_row($query)) $peers .= $peer[0];

// cleanup

mysql_free_result($query);

}

// return dictionary peers

public function peers_dictionary($sql, &$response)

{

// fetch peers

$query = mysql_query($sql, $this->db) OR tracker_error('failed to select peers');

// dotted decimal string ip, 20-byte peer_id, integer port

while($peer = mysql_fetch_row($query)) $response .= 'd2:ip' . strlen($peer[1]) . ":{$peer[1]}" . "7:peer id20:{$peer[0]}4:porti{$peer[2]}ee";

// cleanup

mysql_free_result($query);

}

// return dictionary peers without peer_id

public function peers_dictionary_no_peer_id($sql, &$response)

{

// fetch peers

$query = mysql_query($sql, $this->db) OR tracker_error('failed to select peers');

// dotted decimal string ip, integer port

while($peer = mysql_fetch_row($query)) $response .= 'd2:ip' . strlen($peer[0]) . ":{$peer[0]}4:porti{$peer[1]}ee";

// cleanup

mysql_free_result($query);

}

// full scrape of all torrents

public function full_scrape($sql, &$response)

{

// fetch scrape

$query = mysql_query($sql) OR tracker_error('unable to perform a full scrape');

// 20-byte info_hash, integer complete, integer downloaded, integer incomplete

while ($scrape = mysql_fetch_row($query)) $response .= "20:{$scrape[0]}d8:completei{$scrape[1]}e10:downloadedi0e10:incompletei{$scrape[2]}ee";

// cleanup

mysql_free_result($query);

}

{

// database connection

public $db;

// connect to database

public function __construct()

{

// attempt to connect

$this->db = new mysqli(

// connection method

(!$_SERVER['tracker']['db_persist'] ?

// default connection

$_SERVER['tracker']['db_host'] :

// persistent connection

'p:' . $_SERVER['tracker']['db_host']

),

$_SERVER['tracker']['db_user'],

$_SERVER['tracker']['db_pass'],

$_SERVER['tracker']['db_name']

);

// error out if something happened

if ($this->db->connect_errno) tracker_error(

$this->db->connect_errno . ' - ' .

$this->db->connect_error

);

}

// close database connection

public function __destruct()

{

$this->db->close();

}

// make sql safe

public function escape_sql($sql)

{

return $this->db->real_escape_string($sql);

}

// query database

public function query($sql)

{

return $this->db->query($sql);

}

// return one row

public function fetch_once($sql)

{

// execute query

$query = $this->db->query($sql) OR tracker_error($this->db->error);

$result = $query->fetch_row();

// cleanup

$query->close();

// return

return $result;

}

public function fetch_array($sql)

{

// execute query

$query = $this->db->query($sql) OR tracker_error($this->db->error);

$result = $query->fetch_array();

// cleanup

$query->close();

// return

return $result;

}

public function fetch_all($sql)

{

// execute query

$query = $this->db->query($sql) OR tracker_error($this->db->error);

$result = $query->fetch_assoc();

// cleanup

$query->close();

// return

return $result;

}

// return compact peers

public function peers_compact($sql, &$peers)

{

// fetch peers

$query = $this->db->query($sql) OR tracker_error('failed to select compact peers');

// build response

while($peer = $query->fetch_row()) $peers .= $peer[0];

// cleanup

$query->close();

}

// return dictionary peers

public function peers_dictionary($sql, &$response)

{

// fetch peers

$query = $this->db->query($sql) OR tracker_error('failed to select peers');

// dotted decimal string ip, 20-byte peer_id, integer port

while($peer = $query->fetch_row()) $response .= 'd2:ip' . strlen($peer[1]) . ":{$peer[1]}" . "7:peer id20:{$peer[0]}4:porti{$peer[2]}ee";

// cleanup

$query->close();

}

// return dictionary peers without peer_id

public function peers_dictionary_no_peer_id($sql, &$response)

{

// fetch peers

$query = $this->db->query($sql) OR tracker_error('failed to select peers');

// dotted decimal string ip, integer port

while($peer = $query->fetch_row()) $response .= 'd2:ip' . strlen($peer[0]) . ":{$peer[0]}4:porti{$peer[1]}ee";

// cleanup

$query->close();

}

// full scrape of all torrents

public function full_scrape($sql, &$response)

{

// fetch scrape

$query = $this->db->query($sql) OR tracker_error('unable to perform a full scrape');

// 20-byte info_hash, integer complete, integer downloaded, integer incomplete

while ($scrape = $query->fetch_row()) $response .= "20:{$scrape[0]}d8:completei{$scrape[1]}e10:downloadedi0e10:incompletei{$scrape[2]}ee";

// cleanup

$query->close();

}

{

// database api

public static $api;

// open database connection

public static function open()

{

// php version

$php = PHP_VERSION;

// establish database API

self::$api = (

// default connections

!$_SERVER['tracker']['db_persist'] ? (

// do we support mysqli?

class_exists('mysqli') ?

// use the mysqli api

new peertracker_mysqli() :

// use the mysql api

new peertracker_mysql()

// persistent connections

) : (

// do we support mysqli?

class_exists('mysqli') &&

// PHP is >= 5.3

(($php[0]+0) > 5 || ($php[0]+0) == 5 && ($php[2]+0) >= 3) ?

// use the mysqli api

new peertracker_mysqli() :

// use the mysql api

new peertracker_mysql()

)

);

}

// close database connection

public static function close()

{

// trigger __destruct()

self::$api = null;

}

// database cleanup

public static function clean()

{

// run cleanup once per announce interval

// check 'clean_idle_peers'% of the time to avoid excess queries

if (mt_rand(1, $_SERVER['tracker']['clean_idle_peers']) == 1)

{

// unix timestamp

$time = time();

// fetch last cleanup time

$last = self::$api->fetch_once(

// select last cleanup from tasks

"SELECT value FROM `{$_SERVER['tracker']['db_prefix']}tasks` WHERE name='prune'"

);

// first clean cycle?

if (($last[0] + 0) == 0)

{

self::$api->query(

// set tasks value prune to current unix timestamp

"REPLACE INTO `{$_SERVER['tracker']['db_prefix']}tasks` VALUES('prune', {$time})"

) OR tracker_error('could not perform maintenance');

self::$api->query(

// delete peers that have been idle too long

"DELETE FROM `{$_SERVER['tracker']['db_prefix']}peers` WHERE updated < " .

// idle length is announce interval x 2

($time - ($_SERVER['tracker']['announce_interval'] * 2))

) OR tracker_error('could not perform maintenance');

}

// prune idle peers

elseif (($last[0] + $_SERVER['tracker']['announce_interval']) < $time)

{

self::$api->query(

// set tasks value prune to current unix timestamp

"UPDATE `{$_SERVER['tracker']['db_prefix']}tasks` SET value={$time} WHERE name='prune'"

) OR tracker_error('could not perform maintenance');

self::$api->query(

// delete peers that have been idle too long

"DELETE FROM `{$_SERVER['tracker']['db_prefix']}peers` WHERE updated < " .

// idle length is announce interval x 2

($time - ($_SERVER['tracker']['announce_interval'] * 2))

) OR tracker_error('could not perform maintenance');

}

}

}

// insert new peer

public static function new_peer()

{

self::$api->query(

// insert into the peers table

"INSERT IGNORE INTO `{$_SERVER['tracker']['db_prefix']}peers` " .

// table columns

'(torrent, info_hash, userid, peer_id, compact, ip, port, state, updated) ' .

// 20-byte info_hash, 20-byte peer_id

"VALUES ('$torrentid', '{$_GET['info_hash']}','$userid', '{$_GET['peer_id']}', '" .

// 6-byte compacted peer info

self::$api->escape_sql(pack('Nn', ip2long($_GET['ip']), $_GET['port'])) . "', " .

// dotted decimal string ip, integer port, integer state and unix timestamp updated

"'{$_GET['ip']}', {$_GET['port']}, {$_SERVER['tracker']['seeding']}, " . time() . '); '

) OR tracker_error('failed to add new peer data');

}

// full peer update

public static function update_peer()

{

// update peer

self::$api->query(

// update the peers table

"UPDATE `{$_SERVER['tracker']['db_prefix']}peers` " .

// set the 6-byte compacted peer info

"SET compact='" . self::$api->escape_sql(pack('Nn', ip2long($_GET['ip']), $_GET['port'])) .

// dotted decimal string ip, integer port

"', ip='{$_GET['ip']}', port={$_GET['port']}, " .

// integer state and unix timestamp updated

"state={$_SERVER['tracker']['seeding']}, updated=" . time() .

// that matches the given info_hash and peer_id

" WHERE info_hash='{$_GET['info_hash']}' AND peer_id='{$_GET['peer_id']}'"

) OR tracker_error('failed to update peer data');

}

// update peers last access time

public static function update_last_access()

{

// update peer

self::$api->query(

// set updated to the current unix timestamp

"UPDATE `{$_SERVER['tracker']['db_prefix']}peers` SET updated=" . time() .

// that matches the given info_hash and peer_id

" WHERE info_hash='{$_GET['info_hash']}' AND peer_id='{$_GET['peer_id']}'"

) OR tracker_error('failed to update peers last access');

}

// remove existing peer

public static function delete_peer()

{

// delete peer

self::$api->query(

// delete a peer from the peers table

"DELETE FROM `{$_SERVER['tracker']['db_prefix']}peers` " .

// that matches the given info_hash and peer_id

"WHERE info_hash='{$_GET['info_hash']}' AND peer_id='{$_GET['peer_id']}'"

) OR tracker_error('failed to remove peer data');

/*if (isset($self))

}*/

}

// tracker event handling

public static function event()

{

$updateset = array();

// execute peer select

$pState = self::$api->fetch_once(

// select a peer from the peers table

"SELECT ip, port, state FROM `{$_SERVER['tracker']['db_prefix']}peers` " .

// that matches the given info_hash and peer_id

"WHERE info_hash='{$_GET['info_hash']}' AND peer_id='{$_GET['peer_id']}'"

);

// process tracker event

switch ((isset($_GET['event']) ? $_GET['event'] : false))

{

// client gracefully exited

case 'stopped':

// remove peer

if (isset($pState[2])) self::delete_peer();

break;

// client completed download

case 'completed':

// force seeding status

self::completed();

$_SERVER['tracker']['seeding'] = 1;

// client started download

case 'started':

// client continuing download

default:

// new peer

if (!isset($pState[2])) self::new_peer();

// peer status

elseif (

// check that ip addresses match

$pState[0] != $_GET['ip'] ||

// check that listening ports match

($pState[1]+0) != $_GET['port'] ||

// check whether seeding status match

($pState[2]+0) != $_SERVER['tracker']['seeding']

) self::update_peer();

// update time

else self::update_last_access();

}

}

// tracker peer list

public static function peers()

{

// fetch peer total

$total = self::$api->fetch_once(

// select a count of the number of peers that match the given info_hash

"SELECT COUNT(*) FROM `{$_SERVER['tracker']['db_prefix']}peers` WHERE info_hash='{$_GET['info_hash']}'"

) OR tracker_error('failed to select peer count');

// select

$sql = 'SELECT ' .

// 6-byte compacted peer info

($_GET['compact'] ? 'compact ' :

// 20-byte peer_id

(!$_GET['no_peer_id'] ? 'peer_id, ' : '') .

// dotted decimal string ip, integer port

'ip, port '

) .

// from peers table matching info_hash

"FROM `{$_SERVER['tracker']['db_prefix']}peers` WHERE info_hash='{$_GET['info_hash']}'" .

// less peers than requested, so return them all

($total[0] <= $_GET['numwant'] ? ';' :

// if the total peers count is low, use SQL RAND

($total[0] <= $_SERVER['tracker']['random_limit'] ?

" ORDER BY RAND() LIMIT {$_GET['numwant']};" :

// use a more efficient but less accurate RAND

" LIMIT {$_GET['numwant']} OFFSET " .

mt_rand(0, ($total[0]-$_GET['numwant']))

)

);

// begin response

$response = 'd8:intervali' . $_SERVER['tracker']['announce_interval'] .

'e12:min intervali' . $_SERVER['tracker']['min_interval'] .

'e5:peers';

// compact announce

if ($_GET['compact'])

{

// peers list

$peers = '';

// build response

self::$api->peers_compact($sql, $peers);

// 6-byte compacted peer info

$response .= strlen($peers) . ':' . $peers;

}

// dictionary announce

else

{

// list start

$response .= 'l';

// include peer_id

if (!$_GET['no_peer_id']) self::$api->peers_dictionary($sql, $response);

// omit peer_id

else self::$api->peers_dictionary_no_peer_id($sql, $response);

// list end

$response .= 'e';

}

// send response

echo $response . 'e';

// cleanup

unset($peers);

}

// Private tracking

public static function updateUser()

{

global $db;

// Pid for private tracker

// Only if private tracker is active in admin panel

// echo $pid=md5(uniqid(rand(),true)).'<br />';

//if ($_SERVER['tracker']['open_tracker'] === 'false') {

if (!isset($_GET['passkey']) || strlen($_GET['passkey']) != 32)

tracker_error('This is private tracker! Use your "Personal Passkey" for download this torrent');

else {

$user = self::$api->fetch_once("SELECT id FROM users WHERE passkey = '".self::$api->escape_sql($_GET['passkey'])."' LIMIT 1");

if ($user) {

self::$api->query("UPDATE users SET

upload=IFNULL(upload,0)+ ".self::$api->escape_sql($_GET['uploaded']).",

download=IFNULL(download,0)+ ".self::$api->escape_sql($_GET['downloaded'])."

WHERE id = '".self::$api->escape_sql($user->id)."'");

} else

tracker_error('You are not authorized to download this torrent!');

}

//}

}

public function completed()

{

$ratiocompleted = floor($uploaded / $downloaded * 1000) / 1000;

$updateset[] = "times_completed = times_completed + 1";

//===================== check if torrent has been completed alredy if zo ignore this ======= Decoder ==========

$torrent_chack = mysql_query("SELECT * FROM downloaded WHERE user=$userid AND torrent=$torrentid") or err("Error Event completed client");

$torrent_check = mysql_fetch_array($torrent_chack);

if (!$torrent_check)//================== end of check==== sql below is default dont touch it or you screw up announce.php lol ==========

{

mysql_query("INSERT INTO downloaded (torrent, user, added, username, uploaded, downloaded) VALUES ($torrentid, $userid, NOW(), '$username', $uploaded, $downloaded)") or err("FOUT2");

}

}

// tracker scrape

public static function scrape()

{

// scrape response

$response = 'd5:filesd';

// scrape info_hash

if (isset($_GET['info_hash']))

{

// scrape

$scrape = self::$api->fetch_once(

// select total seeders and leechers

'SELECT SUM(state=1), SUM(state=0) ' .

// from peers

"FROM `{$_SERVER['tracker']['db_prefix']}peers` " .

// that match info_hash

"WHERE info_hash='" . self::$api->escape_sql($_GET['info_hash']) . "'"

) OR tracker_error('unable to scrape the requested torrent');

// 20-byte info_hash, integer complete, integer downloaded, integer incomplete

$response .= "20:{$_GET['info_hash']}d8:completei" . ($scrape[0]+0) .

'e10:downloadedi0e10:incompletei' . ($scrape[1]+0) . 'ee';

}

// full scrape

else

{

// scrape

$sql = 'SELECT ' .

// info_hash, total seeders and leechers

'info_hash, SUM(state=1), SUM(state=0) ' .

// from peers

"FROM `{$_SERVER['tracker']['db_prefix']}peers` " .

// grouped by info_hash

'GROUP BY info_hash';

// build response

self::$api->full_scrape($sql, $response);

}

// send response

echo $response . 'ee';

}

// tracker statistics

public static function stats()

{

if (isset($_GET['info_hash'])) {

// statistics

$stats = self::$api->fetch_once(

// select seeders and leechers

// 'SELECT SUM(state=1), SUM(state=0),' .

'SELECT SUM(state=1), SUM(state=0), ' .

// unique torrents

'info_hash ' .

// from peers

"FROM `{$_SERVER['tracker']['db_prefix']}peers` "

// Where hash

. "WHERE `info_hash` =UNHEX( '" . self::$api->escape_sql($_GET['info_hash']) . "' )"

) OR tracker_error('failed to retrieve tracker statistics');

} else {

// statistics

$stats = self::$api->fetch_once(

// select seeders and leechers

'SELECT SUM(state=1), SUM(state=0),' .

// unique torrents

'COUNT(DISTINCT info_hash) ' .

// from peers

"FROM `{$_SERVER['tracker']['db_prefix']}peers` "

// Where hash

) OR tracker_error('failed to retrieve tracker statistics');

}

// output format

if (isset($_GET['info_hash']))

{

switch ($_GET['stats'])

{

// xml

case 'xml':

header('Content-Type: text/xml');

echo '<?xml version="1.0" encoding="ISO-8859-1"?>' .

'<tracker version="$Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $">' .

'<peers>' . number_format($stats[0] + $stats[1]) . '</peers>' .

'<seeders>' . number_format($stats[0]) . '</seeders>' .

'<leechers>' . number_format($stats[1]) . '</leechers>' .

'<infohash>' . bin2hex($stats[2]) . '</infohash></tracker>';

break;

// json

case 'json':

header('Content-Type: text/javascript');

echo '{"tracker":{"version":"$Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $",' .

'"peers": "' . number_format($stats[0] + $stats[1]) . '",' .

'"seeders":"' . number_format($stats[0]) . '",' .

'"leechers":"' . number_format($stats[1]) . '",' .

'"infohash":"' . bin2hex($stats[2]) . '"}}';

break;

// standard

default:

echo '<!doctype html><html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8">' .

'<title>PeerTracker: $Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $</title>' .

'<body><pre>' . number_format($stats[0] + $stats[1]) .

' peers (' . number_format($stats[0]) . ' seeders + ' . number_format($stats[1]) .

' leechers) on info hash ' . bin2hex($stats[2]) . '</pre></body></html>';

}

} else {

// Sans info hash

switch ($_GET['stats'])

{

// xml

case 'xml':

header('Content-Type: text/xml');

echo '<?xml version="1.0" encoding="ISO-8859-1"?>' .

'<tracker version="$Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $">' .

'<peers>' . number_format($stats[0] + $stats[1]) . '</peers>' .

'<seeders>' . number_format($stats[0]) . '</seeders>' .

'<leechers>' . number_format($stats[1]) . '</leechers>' .

'<torrents>' . number_format($stats[2]) . '</torrents></tracker>';

break;

// json

case 'json':

header('Content-Type: text/javascript');

echo '{"tracker":{"version":"$Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $",' .

'"peers": "' . number_format($stats[0] + $stats[1]) . '",' .

'"seeders":"' . number_format($stats[0]) . '",' .

'"leechers":"' . number_format($stats[1]) . '",' .

'"torrents":"' . number_format($stats[2]) . '"}}';

break;

// standard

default:

echo '<!doctype html><html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8">' .

'<title>PeerTracker: $Id: tracker.mysql.php 164 2010-01-23 22:08:58Z trigunflame $</title>' .

'<body><pre>' . number_format($stats[0] + $stats[1]) .

' peers (' . number_format($stats[0]) . ' seeders + ' . number_format($stats[1]) .

' leechers) in ' . number_format($stats[2]) . ' torrents</pre></body></html>';

}

}

}