function maketable($res)
{
global $INSTALLER09, $lang, $CURUSER;
$htmlout = '';
$htmlout .= "<table class='main' border='1' cellspacing='0' cellpadding='5'>" . "<tr><td class='colhead' align='center'>{$lang['userdetails_type']}</td>\r\n <td class='colhead'>{$lang['userdetails_name']}</td>\r\n <td class='colhead' align='center'>{$lang['userdetails_size']}</td>\r\n <td class='colhead' align='right'>{$lang['userdetails_se']}</td>\r\n <td class='colhead' align='right'>{$lang['userdetails_le']}</td>\r\n <td class='colhead' align='center'>{$lang['userdetails_upl']}</td>\n" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead' align='center'>{$lang['userdetails_downl']}</td>") . "\r\n <td class='colhead' align='center'>{$lang['userdetails_ratio']}</td></tr>\n";
foreach ($res as $arr) {
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 = "{$lang['userdetails_inf']}";
} else {
$ratio = "---";
}
}
$catimage = "{$INSTALLER09['pic_base_url']}caticons/{$CURUSER['categorie_icon']}/{$arr['image']}";
$catname = htmlsafechars($arr["catname"]);
$catimage = "<img src=\"" . htmlsafechars($catimage) . "\" title=\"{$catname}\" alt=\"{$catname}\" width='42' height='42' />";
$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"]);
$htmlout .= "<tr><td style='padding: 0px'>{$catimage}</td>\n" . "<td><a href='details.php?id=" . (int) $arr['torrent'] . "&hit=1'><b>" . htmlsafechars($arr['torrentname']) . "</b></a></td><td align='center'>{$size}</td><td align='right'>{$seeders}</td><td align='right'>{$leechers}</td><td align='center'>{$uploaded}</td>\n" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='center'>{$downloaded}</td>") . "<td align='center'>{$ratio}</td></tr>\n";
}
$htmlout .= "</table>\n";
return $htmlout;
}
function do_sort($arr, $empty = false)
{
global $CURUSER, $lang;
$count = $arr->num_rows;
$ret_html = '';
if ($empty) {
if ($count < 1) {
return false;
}
while ($res = mysqli_fetch_assoc($arr)) {
$ret_html .= "<tr><td align='center'><a href='details.php?id=" . (int) $res['id'] . "'>" . htmlsafechars($res['name']) . "</a></td><td align='center'>" . date('h:i:s d/m/Y', $res['added']) . "</td><td align='center'><a class='btn-small btn btn-danger' href='edit.php?id=" . (int) $res['id'] . "' >" . $lang['mtor_edit'] . "</a></td></tr>";
}
return $ret_html;
}
if ($count == 1) {
$res = mysqli_fetch_assoc($arr);
$users[$res['checked_by']] = isset($users[$res['checked_by']]) && $users[$res['checked_by']] > 0 ? $users[$res['checked_by']] + 1 : 1;
$ret_html .= "<tr><td align='center'><a href='details.php?id=" . (int) $res['id'] . "'>" . htmlsafechars($res['name']) . "</a></td><td align='center'><a href='userdetails.php?id=" . (int) $res['uid'] . "'><font color='#" . get_user_class_color($CURUSER['class']) . "'>" . htmlsafechars($res['checked_by']) . "</font></a></td><td align='center'>" . date('h:i:s d/m/Y', $res['checked_when']) . "</td></tr>";
return array($users, $ret_html);
} elseif ($count > 1) {
while ($res = mysqli_fetch_assoc($arr)) {
$users[$res['checked_by']] = isset($users[$res['checked_by']]) && $users[$res['checked_by']] > 0 ? $users[$res['checked_by']] + 1 : 1;
$ret_html .= "<tr><td align='center'><a href='details.php?id=" . (int) $res['id'] . "'>" . htmlsafechars($res['name']) . "</a></td><td align='center'><a href='userdetails.php?id=" . (int) $res['uid'] . "'>" . htmlsafechars($res['checked_by']) . "</a></td><td align='center'>" . date('h:i:s d/m/Y', $res['checked_when']) . "</td></tr>";
}
return array($users, $ret_html);
}
}
function cloud()
{
//min / max font sizes
$small = 10;
$big = 35;
//get tag info from worker function
$tags = searchcloud();
//amounts
if (isset($tags)) {
$minimum_count = min(array_values($tags));
$maximum_count = max(array_values($tags));
$spread = $maximum_count - $minimum_count;
if ($spread == 0) {
$spread = 1;
}
$cloud_html = '';
$cloud_tags = array();
foreach ($tags as $tag => $count) {
$size = $small + ($count - $minimum_count) * ($big - $small) / $spread;
//set up colour array for font colours.
$colour_array = array('yellow', 'green', 'blue', 'purple', 'orange', '#0099FF');
//spew out some html malarky!
$cloud_tags[] = '<a style="color:' . $colour_array[mt_rand(0, 5)] . '; font-size: ' . floor($size) . 'px' . '" class="tag_cloud" href="browse.php?search=' . urlencode($tag) . '&searchin=all&incldead=1' . '" title="\'' . htmlsafechars($tag) . '\' returned a count of ' . $count . '">' . htmlsafechars(stripslashes($tag)) . '</a>';
}
$cloud_html = join("\n", $cloud_tags) . "\n";
return $cloud_html;
}
}
function docleanup($data)
{
global $INSTALLER09, $queries, $mc1;
set_time_limit(1200);
ignore_user_abort(1);
//== delete torrents - ????
$days = 30;
$dt = TIME_NOW - $days * 86400;
sql_query("UPDATE torrents SET flags='1' WHERE added < {$dt} AND seeders='0' AND leechers='0'") or sqlerr(__FILE__, __LINE__);
$res = sql_query("SELECT id, name FROM torrents WHERE mtime < {$dt} AND seeders='0' AND leechers='0' AND flags='1'") or sqlerr(__FILE__, __LINE__);
while ($arr = mysqli_fetch_assoc($res)) {
sql_query("DELETE files.*, comments.*, thankyou.*, thanks.*, thumbsup.*, bookmarks.*, coins.*, rating.*, xbt_files_users.* FROM xbt_files_users\n LEFT JOIN files ON files.torrent = xbt_files_users.fid\n LEFT JOIN comments ON comments.torrent = xbt_files_users.fid\n LEFT JOIN thankyou ON thankyou.torid = xbt_files_users.fid\n LEFT JOIN thanks ON thanks.torrentid = xbt_files_users.fid\n LEFT JOIN bookmarks ON bookmarks.torrentid = xbt_files_users.fid\n LEFT JOIN coins ON coins.torrentid = xbt_files_users.fid\n LEFT JOIN rating ON rating.torrent = xbt_files_users.fid\n LEFT JOIN thumbsup ON thumbsup.torrentid = xbt_files_users.fid\n WHERE xbt_files_users.fid =" . sqlesc($arr['id'])) or sqlerr(__FILE__, __LINE__);
@unlink("{$INSTALLER09['torrent_dir']}/{$arr['id']}.torrent");
write_log("Torrent " . (int) $arr['id'] . " (" . htmlsafechars($arr['name']) . ") was deleted by system (older than {$days} days and no seeders)");
}
if ($queries > 0) {
write_log("Delete Old Torrents XBT Clean -------------------- Delete Old XBT Torrents cleanup Complete using {$queries} queries --------------------");
}
if (false !== mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$data['clean_desc'] = mysqli_affected_rows($GLOBALS["___mysqli_ston"]) . " items deleted/updated";
}
if ($data['clean_log']) {
cleanup_log($data);
}
}
function DoStaff($staff, $staffclass, $cols = 2)
{
global $INSTALLER09;
$htmlout = '';
$dt = TIME_NOW - 180;
$counter = count($staff);
$rows = ceil($counter / $cols);
$cols = $counter < $cols ? $counter : $cols;
$r = 0;
$htmlout .= "<div class='global_text'><div class='headline'><h2>{$staffclass}</h2></div><div class='row'><div class='col-md-12'><table class='table table-bordered'>";
for ($ia = 0; $ia < $rows; $ia++) {
$htmlout .= "<tr>";
for ($i = 0; $i < $cols; $i++) {
if (isset($staff[$r])) {
$htmlout .= "<td class='staff_username'><a href='userdetails.php?id=" . (int) $staff[$r]['id'] . "'><font color='#" . get_user_class_color($staff[$r]['class']) . "'><b>" . htmlsafechars($staff[$r]['username']) . "</b></font></a></td>" . "\n <td class='staff_online'><img style='vertical-align: middle;' src='images/staff" . ($staff[$r]['last_access'] > $dt && $staff[$r]['perms'] < bt_options::PERMS_STEALTH ? "/online.png" : "/offline.png") . "' border='0' height='16' alt='' /></td>" . "\n <td class='staff_online'><a href='pm_system.php?action=send_message&receiver=" . (int) $staff[$r]['id'] . "&returnto=" . urlencode($_SERVER['REQUEST_URI']) . "'><img style='vertical-align: middle;' src='{$INSTALLER09['pic_base_url']}mailicon.png' border='0' title=\"Personal Message\" alt='' /></a></td>" . "\n <td class='staff_online'><img style='vertical-align: middle;' height='16' src='{$INSTALLER09['pic_base_url']}flag/" . htmlsafechars($staff[$r]['flagpic']) . "' border='0' alt='" . htmlsafechars($staff[$r]['name']) . "' /></td>";
$r++;
} else {
$htmlout .= "<td> </td>";
}
}
$htmlout .= "</tr>";
}
$htmlout .= "</table></div></div></div>";
return $htmlout;
}
function bjtable($res, $frame_caption)
{
global $lang, $CURUSER;
$htmlout = '';
$htmlout .= begin_frame($frame_caption, true);
$htmlout .= begin_table();
$htmlout .= "<tr>\n <td class='colhead'>Rank</td>\n <td class='colhead' align='left'>{$lang['bj_user']}</td>\n <td class='colhead' align='right'>{$lang['bj_wins']}</td>\n <td class='colhead' align='right'>{$lang['bj_losses']}</td>\n <td class='colhead' align='right'>{$lang['bj_games']}</td>\n <td class='colhead' align='right'>{$lang['bj_percentage']}</td>\n <td class='colhead' align='right'>{$lang['bj_win_loss']}</td>\n </tr>";
$num = 0;
while ($a = mysqli_fetch_assoc($res)) {
++$num;
//==Calculate Win %
$win_perc = number_format($a['wins'] / $a['games'] * 100, 1);
//==Add a user's +/- statistic
$plus_minus = $a['wins'] - $a['losses'];
if ($plus_minus >= 0) {
$plus_minus = mksize(($a['wins'] - $a['losses']) * 100 * 1024 * 1024);
} else {
$plus_minus = "-";
$plus_minus .= mksize(($a['losses'] - $a['wins']) * 100 * 1024 * 1024);
}
$htmlout .= "<tr><td>{$num}</td><td align='left'>" . "<b><a href='userdetails.php?id=" . (int) $a['id'] . "'>" . htmlsafechars($a['username']) . "</a></b></td>" . "<td align='right'>" . number_format($a['wins'], 0) . "</td>" . "<td align='right'>" . number_format($a['losses'], 0) . "</td>" . "<td align='right'>" . number_format($a['games'], 0) . "</td>" . "<td align='right'>{$win_perc}</td>" . "<td align='right'>{$plus_minus}</td>" . "</tr>\n";
}
$htmlout .= end_table();
$htmlout .= end_frame();
return $htmlout;
}
function print_list()
{
global $uid, $tid, $ajax;
$target = $ajax ? '_self' : '_parent';
$qt = sql_query("SELECT th.userid, u.username, u.seedbonus FROM thanks as th INNER JOIN users as u ON u.id=th.userid WHERE th.torrentid=" . sqlesc($tid) . " ORDER BY u.class DESC") or sqlerr(__FILE__, __LINE__);
$list = array();
$hadTh = false;
if (mysqli_num_rows($qt) > 0) {
while ($a = mysqli_fetch_assoc($qt)) {
$list[] = '<a href=\'userdetails.php?id=' . (int) $a['userid'] . '\' target=\'' . $target . '\'>' . htmlsafechars($a['username']) . '</a>';
$ids[] = (int) $a['userid'];
}
$hadTh = in_array($uid, $ids) ? true : false;
}
if ($ajax) {
return json_encode(array('list' => count($list) > 0 ? join(', ', $list) : 'Not yet', 'hadTh' => $hadTh, 'status' => true));
} else {
$form = !$hadTh ? "<br/><form action='thanks.php' method='post'><input type='submit' class='btn' name='submit' value='Say thanks' /><input type='hidden' name='torrentid' value='{$tid}' /><input type='hidden' name='action' value='add' /></form>" : "";
$out = count($list) > 0 ? join(', ', $list) : 'Not yet';
return <<<IFRAME
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<style type='text/css'>
body { margin:0;padding:0;
\t font-size:12px;
\t font-family:arial,sans-serif;
\t color: #FFFFFF;
}
a, a:link, a:visited {
text-decoration: none;
color: #FFFFFF;
font-size:12px;
}
a:hover {
color: #FFFFFF
text-decoration:underline;
}
.btn {
background-color:#890537;
border:1px solid #000000;
color:#FFFFFF;
font-family:arial,sans-serif;
font-size:12px;
padding:1px 3px;
}
</style>
<title>::</title>
</head>
<body>
{$out}{$form}
</body>
</html>
IFRAME;
}
}
function tr($x, $y, $noesc = 0)
{
if ($noesc) {
$a = $y;
} else {
$a = htmlsafechars($y);
$a = str_replace("\n", "<br />\n", $a);
}
return "<tr><td class='heading' valign='top' align='right'>{$x}</td><td valign='top' align='left'>{$a}</td></tr>\n";
}
function snatchtable_staff($res)
{
global $INSTALLER09, $lang, $CURUSER, $id;
$htmlout_snatch = '';
$count2 = 0;
// $htmlout_snatch .= "<tr><td class='one' align='right' valign='top'><b>{$lang['userdetails_snatched']}</b></td><td class='one'>";
$htmlout_snatch .= "<table border='1' cellspacing='0' cellpadding='5' align='center'><tr><td class='colhead' align='center'>{$lang['userdetails_s_cat']}</td><td class='colhead' align='left'>{$lang['userdetails_s_torr']}</td>" . "<td class='colhead' align='center'>{$lang['userdetails_s_sl']}</td><td class='colhead' align='center'>{$lang['userdetails_s_up']}" . ($INSTALLER09['ratio_free'] ? "" : "{$lang['userdetails_s_down']}") . "</td><td class='colhead' align='center'>{$lang['userdetails_s_tsize']}</td>" . "<td class='colhead' align='center'>{$lang['userdetails_ratio']}</td><td class='colhead' align='center'>{$lang['userdetails_client']}</td></tr>";
while ($arr = mysqli_fetch_assoc($res)) {
//=======change colors
$count2 = ++$count2 % 2;
$class = $count2 == 0 ? 'one' : 'two';
//=== speed color red fast green slow ;)
if ($arr["upspeed"] > 0) {
$ul_speed = $arr["upspeed"] > 0 ? mksize($arr["upspeed"]) : ($arr["seedtime"] > 0 ? mksize($arr["uploaded"] / ($arr["seedtime"] + $arr["leechtime"])) : mksize(0));
} else {
$ul_speed = mksize($arr["uploaded"] / ($arr['l_a'] - $arr['s'] + 1));
}
if ($arr["downspeed"] > 0) {
$dl_speed = $arr["downspeed"] > 0 ? mksize($arr["downspeed"]) : ($arr["leechtime"] > 0 ? mksize($arr["downloaded"] / $arr["leechtime"]) : mksize(0));
} else {
$dl_speed = mksize($arr["downloaded"] / ($arr['c'] - $arr['s'] + 1));
}
switch (true) {
case $dl_speed > 600:
$dlc = 'red';
break;
case $dl_speed > 300:
$dlc = 'orange';
break;
case $dl_speed > 200:
$dlc = 'yellow';
break;
case $dl_speed < 100:
$dlc = 'Chartreuse';
break;
}
if ($arr["downloaded"] > 0) {
$ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3);
$ratio = "<font color='" . get_ratio_color($ratio) . "'><b>{$lang['userdetails_s_ratio']}</b><br />{$ratio}</font>";
} else {
if ($arr["uploaded"] > 0) {
$ratio = $lang['userdetails_inf'];
} else {
$ratio = "N/A";
}
}
if (XBT_TRACKER === false) {
$htmlout_snatch .= "<tr><td class='{$class}' align='center'>" . ($arr['owner'] == $id ? "<b><font color='orange'>{$lang['userdetails_s_towner']}</font></b><br />" : "" . ($arr['complete_date'] != '0' ? "<b><font color='lightgreen'>{$lang['userdetails_s_fin']}</font></b><br />" : "<b><font color='red'>{$lang['userdetails_s_nofin']}</font></b><br />") . "") . "<img src='{$INSTALLER09['pic_base_url']}caticons/{$CURUSER['categorie_icon']}/" . htmlsafechars($arr['image']) . "' alt='" . htmlsafechars($arr['name']) . "' title='" . htmlsafechars($arr['name']) . "' /></td>" . "\n <td class='{$class}'><a class='altlink' href='{$INSTALLER09['baseurl']}/details.php?id=" . (int) $arr['torrentid'] . "'><b>" . htmlsafechars($arr['torrent_name']) . "</b></a>" . ($arr['complete_date'] != '0' ? "<br /><font color='yellow'>{$lang['userdetails_s_started']}" . get_date($arr['start_date'], 0, 1) . "</font><br />" : "<font color='yellow'>{$lang['userdetails_s_started']}" . get_date($arr['start_date'], 0, 1) . "</font><br /><font color='orange'>{$lang['userdetails_s_laction']}" . get_date($arr['last_action'], 0, 1) . "</font>" . get_date($arr['complete_date'], 0, 1) . " " . ($arr['complete_date'] == '0' ? "" . ($arr['owner'] == $id ? "" : "[ " . mksize($arr["size"] - $arr["downloaded"]) . "{$lang['userdetails_s_still']}]") . "" : "") . "") . $lang['userdetails_s_finished'] . get_date($arr['complete_date'], 0, 1) . "" . ($arr['complete_date'] != '0' ? "<br /><font color='silver'>{$lang['userdetails_s_ttod']}" . ($arr['leechtime'] != '0' ? mkprettytime($arr['leechtime']) : mkprettytime($arr['c'] - $arr['s']) . "") . "</font> <font color='{$dlc}'>[ {$lang['userdetails_s_dled']} {$dl_speed} ]</font><br />" : "<br />") . "<font color='lightblue'>" . ($arr['seedtime'] != '0' ? $lang['userdetails_s_tseed'] . mkprettytime($arr['seedtime']) . " </font><font color='{$dlc}'> " : $lang['userdetails_s_tseedn']) . "</font><font color='lightgreen'> [ {$lang['userdetails_s_uspeed']} " . $ul_speed . " ] </font>" . ($arr['complete_date'] == '0' ? "<br /><font color='{$dlc}'>{$lang['userdetails_s_dspeed']}{$dl_speed}</font>" : "") . "</td>" . "\n <td align='center' class='{$class}'>{$lang['userdetails_s_seed']}" . (int) $arr['seeders'] . "<br />{$lang['userdetails_s_leech']}" . (int) $arr['leechers'] . "</td><td align='center' class='{$class}'><font color='lightgreen'>{$lang['userdetails_s_upld']}<br /><b>" . mksize($arr["uploaded"]) . "</b></font>" . ($INSTALLER09['ratio_free'] ? "" : "<br /><font color='orange'>{$lang['userdetails_s_dld']}<br /><b>" . mksize($arr["downloaded"]) . "</b></font>") . "</td><td align='center' class='{$class}'>" . mksize($arr["size"]) . "" . ($INSTALLER09['ratio_free'] ? "" : "<br />{$lang['userdetails_s_diff']}<br /><font color='orange'><b>" . mksize($arr['size'] - $arr["downloaded"]) . "</b></font>") . "</td><td align='center' class='{$class}'>" . $ratio . "<br />" . ($arr['seeder'] == 'yes' ? "<font color='lightgreen'><b>{$lang['userdetails_s_seeding']}</b></font>" : "<font color='red'><b>{$lang['userdetails_s_nseeding']}</b></font>") . "</td><td align='center' class='{$class}'>" . htmlsafechars($arr["agent"]) . "<br />{$lang['userdetails_s_port']}" . (int) $arr["port"] . "<br />" . ($arr["connectable"] == 'yes' ? "<b>{$lang['userdetails_s_conn']}</b> <font color='lightgreen'>{$lang['userdetails_yes']}</font>" : "<b>{$lang['userdetails_s_conn']}</b> <font color='red'><b>{$lang['userdetails_no']}</b></font>") . "</td></tr>\n";
} else {
$htmlout_snatch .= "<tr><td class='{$class}' align='center'>" . ($arr['owner'] == $id ? "<b><font color='orange'>{$lang['userdetails_s_towner']}</font></b><br />" : "" . ($arr['completedtime'] != '0' ? "<b><font color='lightgreen'>{$lang['userdetails_s_fin']}</font></b><br />" : "<b><font color='red'>{$lang['userdetails_s_nofin']}</font></b><br />") . "") . "<img src='{$INSTALLER09['pic_base_url']}caticons/{$CURUSER['categorie_icon']}/" . htmlsafechars($arr['image']) . "' alt='" . htmlsafechars($arr['name']) . "' title='" . htmlsafechars($arr['name']) . "' /></td>" . "\n <td class='{$class}'><a class='altlink' href='{$INSTALLER09['baseurl']}/details.php?id=" . (int) $arr['fid'] . "'><b>" . htmlsafechars($arr['torrent_name']) . "</b></a>" . ($arr['completedtime'] != '0' ? "<br /><font color='yellow'>{$lang['userdetails_s_started']}" . get_date($arr['started'], 0, 1) . "</font><br />" : "<font color='yellow'>started:" . get_date($arr['started'], 0, 1) . "</font><br /><font color='orange'>{$lang['userdetails_s_laction']}" . get_date($arr['mtime'], 0, 1) . "</font>" . get_date($arr['completedtime'], 0, 1) . " " . ($arr['completedtime'] == '0' ? "" . ($arr['owner'] == $id ? "" : "[ " . mksize($arr["size"] - $arr["downloaded"]) . "{$lang['userdetails_s_still']}]") . "" : "") . "") . "{$lang['userdetails_s_finished']}" . get_date($arr['completedtime'], 0, 1) . "" . ($arr['completedtime'] != '0' ? "<br /><font color='silver'>{$lang['userdetails_s_ttod']}" . ($arr['leechtime'] != '0' ? mkprettytime($arr['leechtime']) : mkprettytime($arr['c'] - $arr['s']) . "") . "</font> <font color='{$dlc}'>[ {$lang['userdetails_s_dled']} {$dl_speed} ]</font><br />" : "<br />") . "<font color='lightblue'>" . ($arr['seedtime'] != '0' ? "{$lang['userdetails_s_tseed']}" . mkprettytime($arr['seedtime']) . " </font><font color='{$dlc}'> " : "{$lang['userdetails_s_tseedn']}") . "</font><font color='lightgreen'> [{$lang['userdetails_s_uspeed']}" . $ul_speed . " ] </font>" . ($arr['completedtime'] == '0' ? "<br /><font color='{$dlc}'>{$lang['userdetails_s_dspeed']} {$dl_speed}</font>" : "") . "</td>" . "\n <td align='center' class='{$class}'>{$lang['userdetails_s_seed']}" . (int) $arr['seeders'] . "<br />{$lang['userdetails_s_leech']}" . (int) $arr['leechers'] . "</td><td align='center' class='{$class}'><font color='lightgreen'>{$lang['userdetails_s_upld']}<br /><b>" . mksize($arr["uploaded"]) . "</b></font>" . ($INSTALLER09['ratio_free'] ? "" : "<br /><font color='orange'>{$lang['userdetails_s_dld']}<br /><b>" . mksize($arr["downloaded"]) . "</b></font>") . "</td><td align='center' class='{$class}'>" . mksize($arr["size"]) . "" . ($INSTALLER09['ratio_free'] ? "" : "<br />{$lang['userdetails_s_diff']}<br /><font color='orange'><b>" . mksize($arr['size'] - $arr["downloaded"]) . "</b></font>") . "</td><td align='center' class='{$class}'>" . $ratio . "<br />" . ($arr['active'] == 1 ? "<font color='lightgreen'><b>{$lang['userdetails_s_seeding']}</b></font>" : "<font color='red'><b>{$lang['userdetails_s_nseeding']}</b></font>") . "</td><td align='center' class='{$class}'>" . htmlsafechars($arr["peer_id"]) . "<br />" . ($arr["connectable"] == 1 ? "<b>{$lang['userdetails_s_conn']}</b> <font color='lightgreen'>{$lang['userdetails_yes']}</font>" : "<b>{$lang['userdetails_s_conn']}</b> <font color='red'><b>{$lang['userdetails_no']}</b></font>") . "</td></tr>\n";
}
}
$htmlout_snatch .= "</table>\n";
return $htmlout_snatch;
}
/**
* https://github.com/Bigjoos/
* Licence Info: GPL
* Copyright (C) 2010 U-232 v.3
* A bittorrent tracker source based on TBDev.net/tbsource/bytemonsoon.
* Project Leaders: Mindless, putyn.
*
*/
function check_banned_emails($email)
{
global $lang;
$expl = explode("@", $email);
$wildemail = "*@" . $expl[1];
/* Ban emails by x0r @tbdev.net */
$res = sql_query("SELECT id, comment FROM bannedemails WHERE email = " . sqlesc($email) . " OR email = " . sqlesc($wildemail)) or sqlerr(__FILE__, __LINE__);
if ($arr = mysqli_fetch_assoc($res)) {
stderr("{$lang['takesignup_user_error']}", "{$lang['takesignup_bannedmail']}" . htmlsafechars($arr['comment']));
}
}
function peer_list($array)
{
global $INSTALLER09, $lang;
$htmlout = '';
$htmlout .= "<table width='100%' border='1' cellpadding='5' style='border-collapse:collapse'>\n <tr>\n <td align='center' class='colhead'>{$lang['catol_user']}</td>\n <td align='center' class='colhead'>{$lang['catol_port']}&{$lang['catol_ip']}</td>\n <td align='center' class='colhead'>{$lang['catol_ratio']}</td>\n <td align='center' class='colhead'>{$lang['catol_downloaded']}</td>\n <td align='center' class='colhead'>{$lang['catol_uploaded']}</td>\n <td align='center' class='colhead'>{$lang['catol_started']}</td>\n <td align='center' class='colhead'>{$lang['catol_finished']}</td>\n </tr>";
foreach ($array as $p) {
$time = max(1, TIME_NOW - $p["started"] - (TIME_NOW - $p["last_action"]));
$htmlout .= "<tr>\n <td align='center'><a href='userdetails.php?id=" . (int) $p["p_uid"] . "' >" . htmlsafechars($p["p_user"]) . "</a></td>\n <td align='center'>" . ($CURUSER['class'] >= UC_STAFF ? htmlsafechars($p["ip"]) . " : " . (int) $p["port"] : "xx.xx.xx.xx:xxxx") . "</td>\n <td align='center'>" . ($p["downloaded"] > 0 ? number_format($p["uploaded"] / $p["downloaded"], 2) : ($p["uploaded"] > 0 ? "∞" : "---")) . "</td>\n <td align='center'>" . ($p["downloaded"] > 0 ? mksize($p["downloaded"]) . " @" . mksize(($p["downloaded"] - $p["downloadoffset"]) / $time) . "s" : "0kb") . "</td>\n <td align='center'>" . ($p["uploaded"] > 0 ? mksize($p["uploaded"]) . " @" . mksize(($p["uploaded"] - $p["uploadoffset"]) / $time) . "s" : "0kb") . "</td>\n <td align='center'>" . get_date($p["started"], 'LONG', 0, 1) . "</td>\n <td align='center'>" . get_date($p["finishedat"], 'LONG', 0, 1) . "</td>\n </tr>";
}
$htmlout .= "</table>";
return $htmlout;
}
function failedloginscheck()
{
global $INSTALLER09;
$total = 0;
$ip = getip();
$res = sql_query("SELECT SUM(attempts) FROM failedlogins WHERE ip=" . sqlesc($ip)) or sqlerr(__FILE__, __LINE__);
list($total) = mysqli_fetch_row($res);
if ($total >= $INSTALLER09['failedlogins']) {
sql_query("UPDATE failedlogins SET banned = 'yes' WHERE ip=" . sqlesc($ip)) or sqlerr(__FILE__, __LINE__);
stderr("Login Locked!", "You have been <b>Exceeded</b> the allowed maximum login attempts without successful login, therefore your ip address <b>(" . htmlsafechars($ip) . ")</b> has been locked for 24 hours.");
}
}
function stealth($id, $stealth = true)
{
global $CURUSER, $mc1, $INSTALLER09;
$setbits = $clrbits = 0;
if ($stealth) {
$display = 'is';
$setbits |= bt_options::PERMS_STEALTH;
// stealth on
} else {
$display = 'is not';
$clrbits |= bt_options::PERMS_STEALTH;
// stealth off
}
// update perms
if ($setbits || $clrbits) {
sql_query('UPDATE users SET perms = ((perms | ' . $setbits . ') & ~' . $clrbits . ')
WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
}
// grab current data
$res = sql_query('SELECT username, perms, modcomment FROM users
WHERE id = ' . sqlesc($id) . ' LIMIT 1') or sqlerr(__FILE__, __LINE__);
$row = mysqli_fetch_assoc($res);
$row['perms'] = (int) $row['perms'];
$modcomment = get_date(TIME_NOW, '', 1) . ' - ' . $display . ' in Stealth Mode thanks to ' . $CURUSER['username'] . "\n" . $row['modcomment'];
sql_query('UPDATE users SET modcomment = ' . sqlesc($modcomment) . ' WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
// update caches
$mc1->begin_transaction('user' . $id);
$mc1->update_row(false, array('perms' => $row['perms']));
$mc1->commit_transaction($INSTALLER09['expires']['user_cache']);
$mc1->begin_transaction('MyUser_' . $id);
$mc1->update_row(false, array('perms' => $row['perms']));
$mc1->commit_transaction($INSTALLER09['expires']['curuser']);
$mc1->begin_transaction('user_stats_' . $id);
$mc1->update_row(false, array('modcomment' => $modcomment));
$mc1->commit_transaction($INSTALLER09['expires']['user_stats']);
if ($id == $CURUSER['id']) {
$mc1->begin_transaction('user' . $CURUSER['id']);
$mc1->update_row(false, array('perms' => $row['perms']));
$mc1->commit_transaction($INSTALLER09['expires']['user_cache']);
$mc1->begin_transaction('MyUser_' . $CURUSER['id']);
$mc1->update_row(false, array('perms' => $row['perms']));
$mc1->commit_transaction($INSTALLER09['expires']['curuser']);
$mc1->begin_transaction('user_stats_' . $CURUSER['id']);
$mc1->update_row(false, array('modcomment' => $modcomment));
$mc1->commit_transaction($INSTALLER09['expires']['user_stats']);
}
write_log('Member [b][url=userdetails.php?id=' . $id . ']' . htmlsafechars($row['username']) . '[/url][/b] ' . $display . ' in Stealth Mode thanks to [b]' . $CURUSER['username'] . '[/b]');
// header ouput
$mc1->cache_value('display_stealth' . $CURUSER['id'], $display, 5);
header('Location: userdetails.php?id=' . $id);
exit;
}
function check($task_name = 'Default')
{
global $CURUSER, $INSTALLER09, $lang, $_SESSION;
$returl = isset($_SERVER['HTTP_REFERER']) ? htmlsafechars($_SERVER['HTTP_REFERER']) : $INSTALLER09['baseurl'] . "/login.php";
$returl = str_replace('&', '&', $returl);
if (isset($_SESSION['HTTP_USER_AGENT']) && $_SESSION['HTTP_USER_AGENT'] != $_SERVER['HTTP_USER_AGENT']) {
stderr("Error", "Please resubmit the form. <a href='" . $returl . "'>Click HERE</a>", false);
}
if (isset($_SESSION['Task']) && $_SESSION['Task'] != md5('user_id:' . $CURUSER['id'] . '::taskname-' . $task_name . '::' . $_SESSION['Task_Time'])) {
stderr("Error", "Please resubmit the form. <a href='" . $returl . "'>Click HERE</a>", false);
}
$this->create();
}
function snatchtable($res)
{
global $INSTALLER09, $lang, $CURUSER;
$htmlout = '';
$htmlout = "<table class='main' border='1' cellspacing='0' cellpadding='5'>\n <tr>\n<td class='colhead'>{$lang['userdetails_s_cat']}</td>\n<td class='colhead'>{$lang['userdetails_s_torr']}</td>\n<td class='colhead'>{$lang['userdetails_s_up']}</td>\n<td class='colhead'>{$lang['userdetails_rate']}</td>\n" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead'>{$lang['userdetails_downl']}</td>") . "\n" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead'>{$lang['userdetails_rate']}</td>") . "\n<td class='colhead'>{$lang['userdetails_ratio']}</td>\n<td class='colhead'>{$lang['userdetails_activity']}</td>\n<td class='colhead'>{$lang['userdetails_s_fin']}</td>\n</tr>";
while ($arr = mysqli_fetch_assoc($res)) {
$upspeed = $arr["upspeed"] > 0 ? mksize($arr["upspeed"]) : ($arr["seedtime"] > 0 ? mksize($arr["uploaded"] / ($arr["seedtime"] + $arr["leechtime"])) : mksize(0));
$downspeed = $arr["downspeed"] > 0 ? mksize($arr["downspeed"]) : ($arr["leechtime"] > 0 ? mksize($arr["downloaded"] / $arr["leechtime"]) : mksize(0));
$ratio = $arr["downloaded"] > 0 ? number_format($arr["uploaded"] / $arr["downloaded"], 3) : ($arr["uploaded"] > 0 ? "Inf." : "---");
$XBT_or_PHP = XBT_TRACKER == true ? $arr['fid'] : $arr['torrentid'];
$XBT_or_PHP_TIME = XBT_TRACKER == true ? $arr["completedtime"] : $arr["complete_date"];
$htmlout .= "<tr>\n <td style='padding: 0px'><img src='{$INSTALLER09['pic_base_url']}caticons/{$CURUSER['categorie_icon']}/" . htmlsafechars($arr["catimg"]) . "' alt='" . htmlsafechars($arr["catname"]) . "' width='42' height='42' /></td>\n <td><a href='details.php?id=" . (int) $XBT_or_PHP . "'><b>" . (strlen($arr["name"]) > 50 ? substr($arr["name"], 0, 50 - 3) . "..." : htmlsafechars($arr["name"])) . "</b></a></td>\n <td>" . mksize($arr["uploaded"]) . "</td>\n <td>{$upspeed}/s</td>\n " . ($INSTALLER09['ratio_free'] ? "" : "<td>" . mksize($arr["downloaded"]) . "</td>") . "\n " . ($INSTALLER09['ratio_free'] ? "" : "<td>{$downspeed}/s</td>") . "\n <td>{$ratio}</td>\n <td>" . mkprettytime($arr["seedtime"] + $arr["leechtime"]) . "</td>\n <td>" . ($XBT_or_PHP_TIME != 0 ? "<font color='green'><b>{$lang['userdetails_yes']}</b></font>" : "<font color='red'><b>{$lang['userdetails_no']}</b></font>") . "</td>\n </tr>\n";
}
$htmlout .= "</table>\n";
return $htmlout;
}
function block_cache()
{
global $block_set_cache;
$block_out = "<" . "?php\n\n\$BLOCKS = array(\n";
foreach ($_POST as $k => $v) {
$block_out .= $k == 'block_undefined' ? "\t'{$k}' => '" . htmlsafechars($v) . "',\n" : "\t'{$k}' => " . intval($v) . ",\n";
}
$block_out .= "\n);\n\n?" . ">";
if (is_file($block_set_cache) && is_writable(pathinfo($block_set_cache, PATHINFO_DIRNAME))) {
$filenum = fopen($block_set_cache, 'w');
ftruncate($filenum, 0);
fwrite($filenum, $block_out);
fclose($filenum);
}
redirect('staffpanel.php?tool=block.settings&action=block.settings', 'Block Settings Have Been Updated!', 3);
}
function getRate($id, $what)
{
global $CURUSER, $mc1;
if ($id == 0 || !in_array($what, array('topic', 'torrent'))) {
return;
}
//== lets memcache $what f****r
$keys['rating'] = 'rating_' . $what . '_' . $id . '_' . $CURUSER['id'];
if (($rating_cache = $mc1->get_value($keys['rating'])) === false) {
$qy = sql_query("SELECT sum(r.rating) as sum, count(r.rating) as count, r2.id as rated, r2.rating FROM rating as r LEFT JOIN rating as r2 ON (r2." . $what . " = " . sqlesc($id) . " AND r2.user = "******"id"]) . ") WHERE r." . $what . " = " . sqlesc($id) . " GROUP BY r." . $what) or sqlerr(__FILE__, __LINE__);
$rating_cache = mysqli_fetch_assoc($qy);
$mc1->cache_value($keys['rating'], $rating_cache, 0);
}
//== lets memcache $count f****r
$keys['rating_count'] = 'rating_count_' . $what . '_' . $id . '_' . $CURUSER['id'];
if (($completecount = $mc1->get_value($keys['rating_count'])) === false) {
$completeres = sql_query("SELECT * FROM " . (XBT_TRACKER == true ? "xbt_files_users" : "snatched") . " WHERE " . (XBT_TRACKER == true ? "completedtime !=0" : "complete_date !=0") . " AND " . (XBT_TRACKER == true ? "uid" : "userid") . " = " . $CURUSER['id'] . " AND " . (XBT_TRACKER == true ? "fid" : "torrentid") . " = " . $id);
$completecount = mysqli_num_rows($completeres);
$mc1->cache_value($keys['rating_count'], $completecount, 180);
}
// outputs
$p = $rating_cache["count"] > 0 ? round($rating_cache["sum"] / $rating_cache["count"] * 20, 2) : 0;
if ($rating_cache["rated"]) {
$rate = "<ul class=\"star-rating\" title=\"You rated this " . $what . " " . htmlsafechars($rating_cache["rating"]) . " star" . (htmlsafechars($rating_cache["rating"]) > 1 ? "s" : "") . "\"><li style=\"width: " . $p . "%;\" class=\"current-rating\">.</li></ul>";
} elseif ($what == 'torrent' && $completecount == 0) {
$rate = "<ul class=\"star-rating\" title=\"You must download this " . $what . " in order to rate it.\"><li style=\"width: " . $p . "%;\" class=\"current-rating\">.</li></ul>";
} else {
$i = 1;
$rate = "<ul class=\"star-rating\"><li style=\"width: " . $p . "%;\" class=\"current-rating\">.</li>";
foreach (array("one-star", "two-stars", "three-stars", "four-stars", "five-stars") as $star) {
$rate .= "<li><a href=\"rating.php?id=" . (int) $id . "&rate=" . $i . "&ref=" . urlencode($_SERVER["REQUEST_URI"]) . "&what=" . $what . "\" class=\"" . $star . "\" onclick=\"do_rate(" . $i . "," . $id . ",'" . $what . "'); return false\" title=\"" . $i . " star" . ($i > 1 ? "s" : "") . " out of 5\" >{$i}</a></li>";
$i++;
}
$rate .= "</ul>";
}
switch ($what) {
case "torrent":
$return = "<div id=\"rate_" . $id . "\">" . $rate . "</div>";
break;
case "topic":
$return = "<div id=\"rate_" . $id . "\">" . $rate . "</div>";
break;
}
return $return;
}
function dltable($name, $arr, $torrent)
{
global $CURUSER, $lang, $INSTALLER09;
$htmlout = '';
if (!count($arr)) {
return $htmlout = "<div align='left'><b>{$lang['peerslist_no']} {$name} {$lang['peerslist_data_available']}</b></div>\n";
}
$htmlout = "\n";
$htmlout .= "<table width='100%' class='main' border='1' cellspacing='0' cellpadding='5'>\n";
$htmlout .= "<tr><td colspan='11' class='colhead'>" . count($arr) . " {$name}</td></tr>" . "<tr><td class='colhead'>{$lang['peerslist_user_ip']}</td>" . "<td class='colhead' align='center'>{$lang['peerslist_connectable']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_uploaded']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_rate']}</td>" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead' align='right'>{$lang['peerslist_downloaded']}</td>") . "" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead' align='right'>{$lang['peerslist_rate']}</td>") . "" . "<td class='colhead' align='right'>{$lang['peerslist_ratio']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_complete']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_connected']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_idle']}</td>" . "<td class='colhead' align='left'>{$lang['peerslist_client']}</td></tr>\n";
$now = TIME_NOW;
$mod = $CURUSER['class'] >= UC_STAFF;
foreach ($arr as $e) {
$htmlout .= "<tr>\n";
if ($e['username']) {
if (($e['tanonymous'] == 'yes' && $e['owner'] == $e['userid'] || $e['anonymous'] == 'yes' or $e['paranoia'] >= 2) && $CURUSER['id'] != $e['userid'] && $CURUSER['class'] < UC_STAFF) {
$htmlout .= "<td><b>Kezer Soze</b></td>\n";
} else {
$htmlout .= "<td><a href='userdetails.php?id=" . (int) $e['userid'] . "'><b>" . htmlsafechars($e['username']) . "</b></a></td>\n";
}
} else {
$htmlout .= "<td>" . ($mod ? $e["ip"] : preg_replace('/\\.\\d+$/', ".xxx", $e["ip"])) . "</td>\n";
}
$secs = max(1, $now - $e["st"] - ($now - $e["la"]));
$htmlout .= "<td align='center'>" . ($e['connectable'] == "yes" ? "{$lang['peerslist_yes']}" : "<font color='red'>{$lang['peerslist_no']}</font>") . "</td>\n";
$htmlout .= "<td align='right'>" . mksize($e["uploaded"]) . "</td>\n";
$htmlout .= "<td align='right'><span style=\"white-space: nowrap;\">" . mksize(($e["uploaded"] - $e["uploadoffset"]) / $secs) . "/s</span></td>\n";
$htmlout .= "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='right'>" . mksize($e["downloaded"]) . "</td>") . "\n";
if ($e["seeder"] == "no") {
$htmlout .= "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='right'><span style=\"white-space: nowrap;\">" . mksize(($e["downloaded"] - $e["downloadoffset"]) / $secs) . "/s</span></td>") . "\n";
} else {
$htmlout .= "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='right'><span style=\"white-space: nowrap;\">" . mksize(($e["downloaded"] - $e["downloadoffset"]) / max(1, $e["finishedat"] - $e['st'])) . "/s</span></td>") . "\n";
}
$htmlout .= "<td align=\"right\">" . member_ratio($e['uploaded'], $INSTALLER09['ratio_free'] ? "0" : $e['downloaded']) . "</td>\n";
$htmlout .= "<td align='right'>" . sprintf("%.2f%%", 100 * (1 - $e["to_go"] / $torrent["size"])) . "</td>\n";
$htmlout .= "<td align='right'>" . mkprettytime($now - $e["st"]) . "</td>\n";
$htmlout .= "<td align='right'>" . mkprettytime($now - $e["la"]) . "</td>\n";
$htmlout .= "<td align='left'>" . htmlsafechars(getagent($e["agent"], $e['peer_id'])) . "</td>\n";
$htmlout .= "</tr>\n";
}
$htmlout .= "</table>\n";
return $htmlout;
}
function rep_cache()
{
global $rep_set_cache, $INSTALLER09;
$rep_out = "<" . "?php\n\n\$GVARS = array(\n";
foreach ($_POST as $k => $v) {
$rep_out .= $k == 'rep_undefined' ? "\t'{$k}' => '" . htmlsafechars($v, ENT_QUOTES) . "',\n" : "\t'{$k}' => " . intval($v) . ",\n";
}
$rep_out .= "\t'g_rep_negative' => TRUE,\n";
$rep_out .= "\t'g_rep_seeown' => TRUE,\n";
$rep_out .= "\t'g_rep_use' => \$CURUSER['class'] > UC_USER ? TRUE : FALSE\n";
$rep_out .= "\n);\n\n?" . ">";
if (file_exists($rep_set_cache) && is_writable(pathinfo($rep_set_cache, PATHINFO_DIRNAME))) {
$filenum = fopen($rep_set_cache, 'w');
ftruncate($filenum, 0);
fwrite($filenum, $rep_out);
fclose($filenum);
//echo '<pre>'.$rep_out.'</pre>';exit;
}
redirect('staffpanel.php?tool=reputation_settings', 'Reputation Settings Have Been Updated!', 3);
}
function usercommenttable($rows)
{
$htmlout = '';
global $CURUSER, $INSTALLER09, $userid, $lang;
$htmlout .= "<table class='main' width='750' border='0' cellspacing='0' cellpadding='0'>" . "<tr><td class='embedded'>";
$htmlout .= begin_frame();
$count = 0;
foreach ($rows as $row) {
$htmlout .= "<p class='sub'>#" . (int) $row["id"] . " by ";
if (isset($row["username"])) {
$title = $row["title"];
if ($title == "") {
$title = get_user_class_name($row["class"]);
} else {
$title = htmlsafechars($title);
}
$htmlout .= "<a name='comm" . (int) $row['id'] . "' href='userdetails.php?id=" . (int) $row['user'] . "'><b>" . htmlsafechars($row['username']) . "</b></a>" . ($row["donor"] == "yes" ? "<img src=\"{$INSTALLER09['pic_base_url']}star.gif\" alt='{$lang['userdetails_donor']}' />" : "") . ($row["warned"] >= "1" ? "<img src=" . "\"{$INSTALLER09['pic_base_url']}warned.gif\" alt=\"{$lang['userdetails_warned']}\" />" : "") . " ({$title})\n";
} else {
$htmlout .= "<a name=\"comm" . (int) $row["id"] . "\"><i>{$lang['userdetails_orphaned']}</i></a>\n";
}
$htmlout .= " " . get_date($row["added"], 'DATE', 0, 1) . "" . ($userid == $CURUSER["id"] || $row["user"] == $CURUSER["id"] || $CURUSER['class'] >= UC_STAFF ? " - [<a href='usercomment.php?action=edit&cid=" . (int) $row['id'] . "'>{$lang['userdetails_comm_edit']}</a>]" : "") . ($userid == $CURUSER["id"] || $CURUSER['class'] >= UC_STAFF ? " - [<a href='usercomment.php?action=delete&cid=" . (int) $row['id'] . "'>{$lang['userdetails_comm_delete']}</a>]" : "") . ($row["editedby"] && $CURUSER['class'] >= UC_STAFF ? " - [<a href='usercomment.php?action=vieworiginal&cid=" . (int) $row['id'] . "'>{$lang['userdetails_comm_voriginal']}</a>]" : "") . "</p>\n";
$avatar = $CURUSER["avatars"] == "yes" ? htmlsafechars($row["avatar"]) : "";
if (!$avatar) {
$avatar = "{$INSTALLER09['pic_base_url']}default_avatar.gif";
}
$text = format_comment($row["text"]);
if ($row["editedby"]) {
$text .= "<font size='1' class='small'><br /><br />{$lang['userdetails_comm_ledited']}<a href='userdetails.php?id=" . (int) $row['editedby'] . "'><b>" . htmlsafechars($row['username']) . "</b></a> " . get_date($row['editedat'], 'DATE', 0, 1) . "</font>\n";
}
$htmlout .= "<table width='100%' border='1' cellspacing='0' cellpadding='5'>";
$htmlout .= "<tr valign='top'>\n";
$htmlout .= "<td align='center' width='150' style='padding:0px'><img width='150' src=\"{$avatar}\" alt=\"Avatar\" /></td>\n";
$htmlout .= "<td class='text'>{$text}</td>\n";
$htmlout .= "</tr>\n";
$htmlout .= "</table>";
}
$htmlout .= end_frame();
$htmlout .= "</td></tr></table>";
return $htmlout;
}
function docleanup($data)
{
global $INSTALLER09, $queries, $mc1;
set_time_limit(0);
ignore_user_abort(1);
//== Pm birthday users
$current_date = getdate();
$res = sql_query("SELECT id, username, class, donor, title, warned, enabled, chatpost, leechwarn, pirate, king, uploaded, birthday FROM users WHERE MONTH(birthday) = " . sqlesc($current_date['mon']) . " AND DAYOFMONTH(birthday) = " . sqlesc($current_date['mday']) . " ORDER BY username ASC") or sqlerr(__FILE__, __LINE__);
$msgs_buffer = $users_buffer = array();
if (mysqli_num_rows($res) > 0) {
while ($arr = mysqli_fetch_assoc($res)) {
$msg = "Hey there " . htmlsafechars($arr['username']) . " happy birthday, hope you have a good day we awarded you 10 gig...Njoi.\n";
$subject = "Its your birthday!!";
$msgs_buffer[] = '(0,' . $arr['id'] . ', ' . TIME_NOW . ', ' . sqlesc($msg) . ', ' . sqlesc($subject) . ')';
$users_buffer[] = '(' . $arr['id'] . ', 10737418240)';
$update['uploaded'] = $arr['uploaded'] + 10737418240;
$mc1->begin_transaction('userstats_' . $arr['id']);
$mc1->update_row(false, array('uploaded' => $update['uploaded']));
$mc1->commit_transaction($INSTALLER09['expires']['u_stats']);
$mc1->begin_transaction('user_stats_' . $arr['id']);
$mc1->update_row(false, array('uploaded' => $update['uploaded']));
$mc1->commit_transaction($INSTALLER09['expires']['user_stats']);
}
$count = count($users_buffer);
if ($count > 0) {
sql_query("INSERT INTO messages (sender,receiver,added,msg,subject) VALUES " . implode(', ', $msgs_buffer)) or sqlerr(__FILE__, __LINE__);
sql_query("INSERT INTO users (id, uploaded) VALUES " . implode(', ', $users_buffer) . " ON DUPLICATE key UPDATE uploaded=uploaded+values(uploaded)") or sqlerr(__FILE__, __LINE__);
write_log("Cleanup: Pm'd' " . $count . " member(s) and awarded a birthday prize");
}
unset($users_buffer, $msgs_buffer, $count);
}
//==End
if (false !== mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$data['clean_desc'] = mysqli_affected_rows($GLOBALS["___mysqli_ston"]) . " items deleted/updated";
}
if ($data['clean_log']) {
cleanup_log($data);
}
}
function dltable($name, $arr, $torrent)
{
global $CURUSER, $lang, $INSTALLER09;
$htmlout = '';
if (!count($arr)) {
return $htmlout = "<div align='left'><b>{$lang['peerslist_no']} {$name} {$lang['peerslist_data_available']}</b></div>\n";
}
$htmlout = "\n";
$htmlout .= "<table class='table table-bordered'>\n";
$htmlout .= "<tr><td colspan='11' class='colhead'>" . count($arr) . " {$name}</td></tr>" . "<tr><td class='colhead'>{$lang['peerslist_user_ip']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_uploaded']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_rate']}</td>" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead' align='right'>{$lang['peerslist_downloaded']}</td>") . "" . "" . ($INSTALLER09['ratio_free'] ? "" : "<td class='colhead' align='right'>{$lang['peerslist_rate']}</td>") . "" . "<td class='colhead' align='right'>{$lang['peerslist_ratio']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_complete']}</td>" . "<td class='colhead' align='right'>{$lang['peerslist_idle']}</td>" . "<td class='colhead' align='left'>{$lang['peerslist_client']}</td></tr>\n";
$now = TIME_NOW;
$mod = $CURUSER['class'] >= UC_STAFF;
foreach ($arr as $e) {
$htmlout .= "<tr>\n";
$upspeed = $e["upspeed"] > 0 ? mksize($e["upspeed"]) : ($e["seedtime"] > 0 ? mksize($e["uploaded"] / ($e["seedtime"] + $e["leechtime"])) : mksize(0));
$downspeed = $e["downspeed"] > 0 ? mksize($e["downspeed"]) : ($e["leechtime"] > 0 ? mksize($e["downloaded"] / $e["leechtime"]) : mksize(0));
if ($e['username']) {
if (($e['tanonymous'] == 'yes' && $e['owner'] == $e['uid'] || $e['anonymous'] == 'yes' or $e['paranoia'] >= 2 && $CURUSER['id'] != $e['uid']) && $CURUSER['class'] < UC_STAFF) {
$htmlout .= "<td><b>Kezer Soze</b></td>\n";
} else {
$htmlout .= "<td><a href='userdetails.php?id=" . (int) $e['uid'] . "'><b>" . htmlsafechars($e['username']) . "</b></a></td>\n";
}
} else {
$htmlout .= "<td>" . ($mod ? XBT_IP_CONVERT($e["ipa"]) : preg_replace('/\\.\\d+$/', ".xxx", XBT_IP_CONVERT($e["ipa"]))) . "</td>\n";
}
$htmlout .= "<td align='right'>" . mksize($e["uploaded"]) . "</td>\n";
$htmlout .= "<td align='right'><span style=\"white-space: nowrap;\">" . htmlsafechars($upspeed) . "/s</span></td>\n";
$htmlout .= "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='right'>" . mksize($e["downloaded"]) . "</td>") . "\n";
$htmlout .= "" . ($INSTALLER09['ratio_free'] ? "" : "<td align='right'><span style=\"white-space: nowrap;\">" . htmlsafechars($downspeed) . "/s</span></td>") . "\n";
$htmlout .= "<td align=\"right\">" . member_ratio($e['uploaded'], $INSTALLER09['ratio_free'] ? "0" : $e['downloaded']) . "</td>\n";
$htmlout .= "<td align='right'>" . sprintf("%.2f%%", 100 * (1 - $e["left"] / $torrent["size"])) . "</td>\n";
$htmlout .= "<td align='right'>" . mkprettytime($now - $e["la"]) . "</td>\n";
$htmlout .= "<td align='left'>" . htmlsafechars(getagent($e["peer_id"], $e['peer_id'])) . "</td>\n";
$htmlout .= "</tr>\n";
}
$htmlout .= "</table>\n";
return $htmlout;
}
} else {
$HTMLOUT .= "<br />\n <form name=\"p2p\" method=\"post\" action=\"casino.php\">\n <h1>{$INSTALLER09['site_name']} {$lang['casino_stdhead']} - {$lang['casino_bet_p2p_with_other_users']}:</h1>\n <table width='650' cellspacing='0' cellpadding='3'>";
$HTMLOUT .= "<tr><td align=\"center\" colspan=\"2\" class=\"colhead\">{$lang['casino_place_bet']}</td></tr>";
$HTMLOUT .= "<tr><td align=\"center\"><b>{$lang['casino_amount_to_bet']}</b>\n <input type=\"text\" name=\"amnt\" size=\"5\" value=\"1\" />\n <select name=\"unit\">\n <option value=\"1\">MB</option>\n <option value=\"2\">GB</option>\n </select></td></tr>";
$HTMLOUT .= "<tr><td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\"{$lang['casino_gamble']}!\" />";
$HTMLOUT .= "</td></tr></table></form><br />";
}
} else {
$HTMLOUT .= "<b>{$lang['casino_you_already_have']} " . htmlsafechars($maxusrbet) . " {$lang['casino_open_bets_wait_until_they_are_comp']}.</b><br /><br />";
}
//== Open Bets table
$HTMLOUT .= "<table width=\"650\" cellspacing=\"0\" cellpadding=\"3\">";
$HTMLOUT .= "<tr><td align=\"center\" class=\"colhead\" colspan=\"4\">{$lang['casino_open_bets']}</td></tr>";
$HTMLOUT .= "<tr>\n <td align=\"center\" width=\"15%\"><b>{$lang['casino_name']}</b></td><td width=\"15%\" align=\"center\"><b>{$lang['casino_amount']}</b></td>\n <td width=\"45%\" align=\"center\"><b>{$lang['casino_time']}</b></td><td align=\"center\"><b>{$lang['casino_take_bet']}</b></td>\n </tr>";
while ($res = mysqli_fetch_assoc($loca)) {
$HTMLOUT .= "<tr>\n <td align=\"center\">" . htmlsafechars($res['proposed']) . "</td>\n <td align=\"center\">" . htmlsafechars(mksize($res['amount'])) . "</td>\n <td align=\"center\">" . get_date($res['time'], 'LONG', 0, 1) . "</td>\n <td align=\"center\"><b><a href='{$casino}?takebet=" . (int) $res['id'] . "'>{$lang['casino_this']}</a></b></td>\n </tr>";
$abcdefgh = 1;
}
if ($abcdefgh == false) {
$HTMLOUT .= "<tr><td align='center' colspan='4'>{$lang['casino_sorry_no_bets_currently']}.</td></tr>";
}
$HTMLOUT .= "</table><br />";
//== Bet on color table
$HTMLOUT .= "<form name=\"casino\" method=\"post\" action=\"casino.php\">\n <table class=\"message\" width=\"650\" cellspacing=\"0\" cellpadding=\"5\">\n";
$HTMLOUT .= "<tr><td align=\"center\" class=\"colhead\" colspan=\"2\">{$lang['casino_bet_on_a_colour']}</td></tr>";
$HTMLOUT .= tr($lang['casino_black'], "<input name=\"color\" type=\"radio\" checked=\"checked\" value=\"black\" />", 1);
$HTMLOUT .= tr($lang['casino_red'], "<input name=\"color\" type=\"radio\" checked=\"checked\" value=\"red\" />", 1);
$HTMLOUT .= tr($lang['casino_how_much'], "\n <select name=\"betmb\">\n <option value=\"{$bet_value1}\">" . mksize($bet_value1) . "</option>\n <option value=\"{$bet_value2}\">" . mksize($bet_value2) . "</option>\n <option value=\"{$bet_value3}\">" . mksize($bet_value3) . "</option>\n <option value=\"{$bet_value4}\">" . mksize($bet_value4) . "</option>\n <option value=\"{$bet_value5}\">" . mksize($bet_value5) . "</option>\n <option value=\"{$bet_value6}\">" . mksize($bet_value6) . "</option>\n <option value=\"{$bet_value7}\">" . mksize($bet_value7) . "</option>\n </select>", 1);
if ($show_real_chance) {
$real_chance = $cheat_value + 1;
} else {
foreach ($shouts as $arr) {
if ($arr['to_user'] != $CURUSER['id'] && $arr['to_user'] != 0 && $arr['userid'] != $CURUSER['id']) {
continue;
}
$private = '';
if ($arr['to_user'] == $CURUSER['id'] && $arr['to_user'] > 0) {
$private = "<a href=\"javascript:private_reply('" . htmlsafechars($arr['username']) . "')\"><img src=\"{$INSTALLER09['pic_base_url']}private-shout.png\" alt=\"Private shout\" title=\"Private shout! click to reply to " . htmlsafechars($arr['username']) . "\" width=\"16\" style=\"padding-left:2px;padding-right:2px;\" border=\"0\" /></a>";
}
$edit = $CURUSER['class'] >= UC_STAFF || $arr['userid'] == $CURUSER['id'] && ($CURUSER['class'] >= UC_POWER_USER && $CURUSER['class'] <= UC_STAFF) ? "<a href='{$INSTALLER09['baseurl']}/shoutbox.php?edit=" . (int) $arr['id'] . "&user="******"'><img src='{$INSTALLER09['pic_base_url']}button_edit2.gif' border='0' alt=\"Edit Shout\" title=\"Edit Shout\" /></a> " : "";
$del = $CURUSER['class'] >= UC_STAFF ? "<a href='./shoutbox.php?del=" . (int) $arr['id'] . "'><img src='{$INSTALLER09['pic_base_url']}button_delete2.gif' border='0' alt=\"Delete Single Shout\" title=\"Delete Single Shout\" /></a> " : "";
$delall = $CURUSER['class'] == UC_MAX ? "<a href='./shoutbox.php?delall' onclick=\"confirm_delete(); return false;\"><img src='{$INSTALLER09['pic_base_url']}del.png' border='0' alt=\"Empty Shout\" title=\"Empty Shout\" /></a> " : "";
//$delall
$pm = $CURUSER['id'] != $arr['userid'] ? "<span class='date' style=\"color:{$dtcolor}\"><a target='_blank' href='./pm_system.php?action=send_message&receiver=" . (int) $arr['userid'] . "'><img src='{$INSTALLER09['pic_base_url']}button_pm2.gif' border='0' alt=\"Pm User\" title=\"Pm User\" /></a></span>\n" : "";
$date = get_date($arr["date"], 0, 1);
$reply = $CURUSER['id'] != $arr['userid'] ? "<a href=\"javascript:window.top.SmileIT('[b][i]=> [color=#" . get_user_class_color($arr['class']) . "]" . ($arr['perms'] & bt_options::PERMS_STEALTH ? "UnKnown" : htmlsafechars($arr['username'])) . "[/color] -[/i][/b]','shbox','shbox_text')\"><img height='10' src='{$INSTALLER09['pic_base_url']}reply.gif' title='Reply' alt='Reply' style='border:none;' /></a>" : "";
$user_stuff = $arr;
$user_stuff['id'] = $arr['perms'] & bt_options::PERMS_STEALTH ? "" . ($user_stuff['id'] = $INSTALLER09['bot_id'] . "") : "" . ($user_stuff['id'] = (int) $arr['userid'] . "");
$user_stuff['username'] = $arr['perms'] & bt_options::PERMS_STEALTH ? "" . ($user_stuff['username'] = '******' . "") : "" . ($user_stuff['username'] = htmlsafechars($arr['username']) . "");
$HTMLOUT .= "<tr style='background-color:{$bg};'><td><span class='size1' style='color:{$fontcolor};'>[{$date}]</span>\n{$del}{$edit}{$pm}{$reply}{$private} " . format_username($user_stuff, true) . "<span class='size2' style='color:{$fontcolor};'>" . format_comment($arr["text"]) . "\n</span></td></tr>\n";
}
$HTMLOUT .= "</table>";
} else {
//== If there are no shouts
if (empty($shouts)) {
$HTMLOUT .= "<tr style='background-color:{$bg};'><td><span class='size1' style='color:{$fontcolor};'>No shouts here</span></td></tr>\n";
}
$HTMLOUT .= "</table>";
}
}
$HTMLOUT .= "</body></html>";
echo $HTMLOUT;
} else {
$showdates = "<img src=\"{$INSTALLER09['pic_base_url']}off.gif\" alt=\"Showing of Dates Disabled\" title=\"Disabled\" />";
}
$HTMLOUT .= "<tr><td align=\"center\">{$username}</td><td align=\"center\">{$text}</td><td align=\"center\">{$start}</td><td align=\"center\">{$end}</td><td align=\"center\">{$freeleech}</td><td align=\"center\">{$doubleUpload}</td><td align=\"center\">{$halfdownload}</td><td align=\"center\">{$showdates}</td><td align=\"center\"><input type=\"submit\" name=\"editEvent_{$id}\" value=\"Edit\" /> <input type=\"submit\" onclick=\"return checkAllGood('{$text}')\" name=\"removeEvent_{$id}\" value=\"Remove\" /></td></tr>";
}
$HTMLOUT .= "<tr><td colspan='9' align='right'><input type='submit' name='editEvent_-1' value='Add Event' /></td></tr></table>";
foreach ($_POST as $key => $value) {
if (gettype($pos = strpos($key, "_")) != 'boolean') {
$id = (int) substr($key, $pos + 1);
if (gettype(strpos($key, "editEvent_")) != 'boolean') {
if ($id == -1) {
$HTMLOUT .= "<table>\n<tr><th align='right'>Userid</th><td><input type='text' name='userid' value='{$CURUSER["id"]}' /></td></tr>\n<tr><th align='right'>Text</th><td><input type='text' name='editText' /></td></tr>\n<tr><th align='right'>Start Time</th><td><input type='text' name='editStartTime' /></td></tr>\n<tr><th align='right'>End Time</th><td><input type='text' name='editEndTime' /></td></tr>\n<tr><th align='right'>Freeleech</th><td><input type='checkbox' name='editFreeleech' /></td></tr>\n<tr><th align='right'>DoubleUpload</th><td><input type='checkbox' name='editDoubleupload' /></td></tr>\n<tr><th align='right'>halfdownload</th><td><input type='checkbox' name='editHalfdownload' /></td></tr>\n<tr><th align='right'>Show Dates</th><td><input type='checkbox' name='editShowDates' /></td></tr>\n<tr><td colspan='2' align='center'><input type='submit' name='saveEvent_-1' value='Save Changes' /></td></tr>\n</table>";
} else {
foreach ($scheduled_events as $scheduled_event) {
if ($id == $scheduled_event['id']) {
$text = htmlsafechars($scheduled_event['overlayText']);
$start = get_date((int) $scheduled_event['startTime'], 'DATE');
$end = get_date((int) $scheduled_event['endTime'], 'DATE');
$freeleech = (bool) (int) $scheduled_event['freeleechEnabled'];
if ($freeleech) {
$freeleech = "checked=\"checked\"";
} else {
$freeleech = "";
}
$doubleupload = (bool) (int) $scheduled_event['duploadEnabled'];
if ($doubleupload) {
$doubleupload = "checked=\"checked\"";
} else {
$doubleupload = "";
}
$halfdownload = (bool) (int) $scheduled_event['hdownEnabled'];
$offers[] = $offer;
}
$mc1->cache_value('offers_', $offers, $INSTALLER09['expires']['off_limit']);
}
}
if (count($offers) > 0) {
$HTMLOUT .= "<table class='table table-striped table-bordered'>";
$HTMLOUT .= " <thead><tr>\n <th class='col-md-1 text-left'><b>Category</b></th>\n <th class='col-md-5 text-left'><b>Title</b></th>\n\t <th class='col-md-1 text-center'><b>Added</b></th>\n \t<th class='col-md-1 text-center''>Comm</th> \n \t<th class='col-md-1 text-center''>Votes</th>\n \t<th class='col-md-1 text-center''>Offered</th>\n <th class='col-md-1 text-center''>Status</th>\n </tr></thead>\n";
if ($offers) {
foreach ($offers as $offerarr) {
$torrname = htmlsafechars($offerarr['offer_name']);
$offerarr['cat_name'] = htmlsafechars($change[$offerarr['category']]['name']);
$offerarr['cat_pic'] = htmlsafechars($change[$offerarr['category']]['image']);
$status = $offerarr['status'] == 'approved' ? '<span style="color: limegreen;font-weight: bold;">Approved!</span>' : ($offerarr['status'] == 'pending' ? '<span style="color: skyblue;font-weight: bold;">Pending...</span>' : '<span style="color: red;font-weight: bold;">denied</span>');
if (strlen($torrname) > 50) {
$torrname = substr($torrname, 0, 50) . "...";
}
$HTMLOUT .= " <tbody><tr>\n <td class='text-center'><img src='{$INSTALLER09['pic_base_url']}caticons/{$CURUSER['categorie_icon']}/" . htmlsafechars($offerarr["cat_pic"]) . "' alt='" . htmlsafechars($offerarr["cat_name"]) . "' title='" . htmlsafechars($offerarr["cat_name"]) . "' /></td>\n <td class='text-left'><a href=\"{$INSTALLER09['baseurl']}/offers.php?action=offer_details&id=" . (int) $offerarr['offer_id'] . "&hit=1\" >{$torrname}</a></td>\n\t\t<td class='text-center'>" . get_date($offerarr['added'], 'LONG') . "</td>\n \t<td class='text-center'>" . number_format($offerarr['comments']) . "</td> \n \t<td class='text-center'>yes: " . number_format($offerarr['vote_yes_count']) . "<br />\n \t\t\t\t no: " . number_format($offerarr['vote_no_count']) . "</td> \n \t<td class='text-center'>" . print_user_stuff($offerarr) . "</td>\n\t\t<td class='text-center'>" . $status . "</td>\n</tr></tbody>";
}
$HTMLOUT .= "</table></div>";
} else {
//== If there are no offers
if (empty($offers)) {
$HTMLOUT .= "<tbody><tr><td class='text-left' colspan='5'>No Offers Found</td></tr></tbody></table></div>";
}
}
}
//==End
$HTMLOUT .= "</div></div></div>";
// End Class
// End File
$mc1->update_row(false, array('bjlosses' => $update['bjlosses']));
$mc1->commit_transaction($INSTALLER09['expires']['curuser']);
$mc1->begin_transaction('user' . $CURUSER['id']);
$mc1->update_row(false, array('bjlosses' => $update['bjlosses']));
$mc1->commit_transaction($INSTALLER09['expires']['user_cache']);
}
sql_query("INSERT INTO messages (sender, receiver, added, msg, subject) VALUES(0, " . $a['userid'] . ", {$now}, {$msg}, {$subject})");
$mc1->delete_value('inbox_new_' . $a['userid']);
$mc1->delete_value('inbox_new_sb_' . $a['userid']);
sql_query("DELETE FROM blackjack WHERE userid IN (" . sqlesc($CURUSER['id']) . ", " . sqlesc($a['userid']) . ")");
$HTMLOUT .= "<tr><td align='center'>Your opponent was " . htmlsafechars($a["username"]) . ", he/she had " . htmlsafechars($a['points']) . " points, {$winorlose}.<br /><br /><b><a href='/blackjack.php'>Play again</a></b></td></tr>";
} else {
sql_query("UPDATE blackjack SET status = 'waiting', date=" . $now . ", gameover='yes' WHERE userid = " . sqlesc($CURUSER['id']));
$HTMLOUT .= "<tr><td align='center'>There are no other players, so you'll have to wait until someone plays against you.<br />You will receive a PM with the game results.<br /><br /><b><a href='/blackjack.php'>Back</a></b><br /></td></tr>";
}
$HTMLOUT .= "</table></td></tr></table><br />";
echo stdhead('Blackjack') . $HTMLOUT . stdfoot();
}
} else {
$sql = sql_query('SELECT bjwins, bjlosses ' . 'FROM users ' . 'WHERE id = ' . sqlesc($CURUSER['id'])) or sqlerr(__FILE__, __LINE__);
$User = mysqli_fetch_assoc($sql);
$User['bjwins'] = (int) $User['bjwins'];
$User['bjlosses'] = (int) $User['bjlosses'];
$tot_wins = (int) $User['bjwins'];
$tot_losses = (int) $User['bjlosses'];
$tot_games = $tot_wins + $tot_losses;
$win_perc = $tot_losses == 0 ? $tot_wins == 0 ? "---" : "100%" : ($tot_wins == 0 ? "0" : number_format($tot_wins / $tot_games * 100, 1)) . '%';
$plus_minus = ($tot_wins - $tot_losses < 0 ? '-' : '') . mksize(($tot_wins - $tot_losses >= 0 ? $tot_wins - $tot_losses : $tot_losses - $tot_wins) * $mb);
$HTMLOUT .= "<h1>{$INSTALLER09['site_name']} Blackjack</h1>\n\t<table cellspacing='0' cellpadding='3' width='400'>\n\t<tr><td colspan='2' align='center'>\n\t<table class='message' width='100%' cellspacing='0' cellpadding='10' bgcolor='white'>\n\t<tr><td align='center'><img src='{$INSTALLER09['pic_base_url']}cards/tp.bmp' width='71' height='96' border='0' alt='' /> <img src='{$INSTALLER09['pic_base_url']}cards/vp.bmp' width='71' height='96' border='0' alt='' /></td></tr>\n\t<tr><td align='left'>You must collect 21 points without going over.<br /><br />\n\t<b>NOTE:</b> By playing blackjack, you are betting 100 MB of upload credit!</td></tr>\n\t<tr><td align='center'>\n\t<form method='post' action='" . $_SERVER['PHP_SELF'] . "'><input type='hidden' name='game' value='hit' readonly='readonly' /><input type='hidden' name='start_' value='yes' readonly='readonly' /><input type='submit' value='Start!' /></form>\n\t</td></tr></table>\n\t</td></tr></table>\n\t<br /><br /><br />\n <table cellspacing='0' cellpadding='3' width='400'>\n <tr><td colspan='2' align='center'>\n <h1>Personal Statistics</h1></td></tr>\n <tr><td align='left'><b>Wins</b></td><td align='center'><b>" . htmlsafechars($tot_wins) . "</b></td></tr>\n <tr><td align='left'><b>Losses</b></td><td align='center'><b>" . htmlsafechars($tot_losses) . "</b></td></tr>\n <tr><td align='left'><b>Games Played</b></td><td align='center'><b>" . htmlsafechars($tot_games) . "</b></td></tr>\n <tr><td align='left'><b>Win Percentage</b></td><td align='center'><b>" . htmlsafechars($win_perc) . "</b></td></tr>\n <tr><td align='left'><b>+/-</b></td><td align='center'><b>" . htmlsafechars($plus_minus) . "</b></td></tr>\n </table>";
echo stdhead('Blackjack') . $HTMLOUT . stdfoot();
}
if (!empty($_POST["desact"])) {
sql_query("UPDATE users SET enabled = 'no' WHERE id IN (" . implode(", ", array_map("sqlesc", $_POST["desact"])) . ")") or sqlerr(__FILE__, __LINE__);
}
}
$HTMLOUT .= "<div class='row'><div class='col-md-12'>";
$HTMLOUT .= "<h2>{$lang['cheaters_users']}</h2>";
$res = sql_query("SELECT COUNT(*) FROM cheaters") or sqlerr(__FILE__, __LINE__);
$row = mysqli_fetch_array($res);
$count = $row[0];
$perpage = 15;
$pager = pager($perpage, $count, "staffpanel.php?tool=cheaters&action=cheaters&");
$HTMLOUT .= "<form action='staffpanel.php?tool=cheaters&action=cheaters' method='post'>\n<script type='text/javascript'>\n/*<![CDATA[*/\nfunction klappe(id)\n{var klappText=document.getElementById('k'+id);var klappBild=document.getElementById('pic'+id);if(klappText.style.display=='none'){klappText.style.display='block';}\nelse{klappText.style.display='none';}}\nfunction klappe_news(id)\n{var klappText=document.getElementById('k'+id);var klappBild=document.getElementById('pic'+id);if(klappText.style.display=='none'){klappText.style.display='block';klappBild.src='{$INSTALLER09['pic_base_url']}minus.gif';}\nelse{klappText.style.display='none';klappBild.src='{$INSTALLER09['pic_base_url']}plus.gif';}}\t\n</script>\n<script type='text/javascript'>\nvar checkflag = 'false';\nfunction check(field) {\nif (checkflag == 'false') {\nfor (i = 0; i < field.length; i++) {\nfield[i].checked = true;}\ncheckflag = 'true';\nreturn 'Uncheck All Disable'; }\nelse {\nfor (i = 0; i < field.length; i++) {\nfield[i].checked = false; }\ncheckflag = 'false';\nreturn 'Check All Disable'; }\n}\nfunction check2(field) {\nif (checkflag == 'false') {\nfor (i = 0; i < field.length; i++) {\nfield[i].checked = true;}\ncheckflag = 'true';\nreturn 'Uncheck All Remove'; }\nelse {\nfor (i = 0; i < field.length; i++) {\nfield[i].checked = false; }\ncheckflag = 'false';\nreturn 'Check All Remove'; }\n}\n/*]]>*/\n</script>";
if ($count > $perpage) {
$HTMLOUT .= $pager['pagertop'];
}
$HTMLOUT .= "<table class='table table-bordered'>\n<tr>\n<td>#</td>\n<td>{$lang['cheaters_uname']}</td>\n<td>{$lang['cheaters_d']}</td>\n<td>{$lang['cheaters_r']}</td></tr>\n";
$res = sql_query("SELECT c.id as cid, c.added, c.userid, c.torrentid, c.client, c.rate, c.beforeup, c.upthis, c.timediff, c.userip, u.id, u.username, u.class, u.downloaded, u.uploaded, u.chatpost, u.leechwarn, u.warned, u.pirate, u.king, u.donor, u.enabled, t.id AS tid, t.name AS tname FROM cheaters AS c LEFT JOIN users AS u ON u.id=c.userid LEFT JOIN torrents AS t ON t.id=c.torrentid ORDER BY added DESC " . $pager['limit']) or sqlerr(__FILE__, __LINE__);
while ($arr = mysqli_fetch_assoc($res)) {
$torrname = htmlsafechars(CutName($arr["tname"], 80));
$users = $arr;
$users['id'] = (int) $arr['userid'];
$cheater = "<b><a href='{$INSTALLER09['baseurl']}/userdetails.php?id=" . (int) $arr['id'] . "'>" . format_username($users) . "</a></b>{$lang['cheaters_hbcc']}<br />\n <b>{$lang['cheaters_torrent']} <a href='{$INSTALLER09['baseurl']}/details.php?id=" . (int) $arr['tid'] . "' title='{$torrname}'>{$torrname}</a></b>\n<br />{$lang['cheaters_upped']} <b>" . mksize((int) $arr['upthis']) . "</b><br />{$lang['cheaters_speed']} <b>" . mksize((int) $arr['rate']) . "/s</b><br />{$lang['cheaters_within']} <b>" . (int) $arr['timediff'] . " {$lang['cheaters_sec']}</b><br />{$lang['cheaters_uc']} <b>" . htmlsafechars($arr['client']) . "</b><br />{$lang['cheaters_ipa']} <b>" . htmlsafechars($arr['userip']) . "</b>";
$HTMLOUT .= "<tr><td>" . (int) $arr['cid'] . "</td>\n <td>" . format_username($users) . "<a href=\"javascript:klappe('a1" . (int) $arr['cid'] . "')\"> {$lang['cheaters_added']}" . get_date($arr['added'], 'DATE') . "</a>\n <div id=\"ka1" . (int) $arr['cid'] . "\" style=\"display: none;\"><font color=\"black\">{$cheater}</font></div></td>\n <td><input type=\"checkbox\" name=\"desact[]\" value=\"" . (int) $arr["id"] . "\"/></td>\n <td><input type=\"checkbox\" name=\"remove[]\" value=\"" . (int) $arr["cid"] . "\"/></td></tr>";
}
$HTMLOUT .= "<tr>\n<td>\n<input type=\"button\" value=\"{$lang['cheaters_cad']}\" onclick=\"this.value=check(this.form.elements['desact[]'])\"/> <input type=\"button\" value=\"{$lang['cheaters_car']}\" onclick=\"this.value=check(this.form.elements['remove[]'])\"/> <input type=\"hidden\" name=\"nowarned\" value=\"nowarned\" /><input type=\"submit\" name=\"submit\" value=\"{$lang['cheaters_ac']}\" />\n</td>\n</tr>\n</table></form>";
if ($count > $perpage) {
$HTMLOUT .= $pager['pagerbottom'];
}
$HTMLOUT .= "</div></div>";
echo stdhead($lang['cheaters_stdhead']) . $HTMLOUT . stdfoot();
die;
$cats = implode(', ', array_map('sqlesc', $validate_cats));
}
if (!empty($torrent_pass)) {
if (strlen($torrent_pass) != 32) {
die("Your passkey is not long enough! Go to " . $INSTALLER09['site_name'] . " and reset your passkey");
} else {
if (get_row_count("users", "where torrent_pass="******"Your passkey is invalid !Go to " . $INSTALLER09['site_name'] . " and reset your passkey");
}
}
} else {
die('Your link doesn\'t have a passkey');
}
$INSTALLER09['rssdescr'] = $INSTALLER09['site_name'] . " some motto goes here!";
$where = !empty($cats) ? "t.category IN (" . $cats . ") AND " : '';
$counts = array(15, 30, 50, 100);
if (!empty($_GET["count"]) && in_array((int) $_GET["count"], $counts)) {
$limit = 'LIMIT ' . (int) $_GET['count'];
} else {
$limit = 'LIMIT 15';
}
header("Content-Type: application/xml");
$HTMLOUT = "<?xml version=\"1.0\" encoding=\"windows-1251\" ?>\n<rss version=\"0.91\">\n<channel>\n" . "<title>" . $INSTALLER09['site_name'] . "</title>\n<link>" . $INSTALLER09['baseurl'] . "</link>\n<description>" . $INSTALLER09['rssdescr'] . "</description>\n" . "<language>en-usde</language>\n<copyright>Copyright © " . date('Y') . " " . $INSTALLER09['site_name'] . "</copyright>\n<webMaster>" . $INSTALLER09['site_email'] . "</webMaster>\n" . "<image><title>" . $INSTALLER09['site_name'] . "</title>\n<url>" . $INSTALLER09['baseurl'] . "/favicon.ico</url>\n<link>" . $INSTALLER09['baseurl'] . "</link>\n" . "<width>16</width>\n<height>16</height>\n<description>" . $INSTALLER09['rssdescr'] . "</description>\n</image>\n";
$res = sql_query('SELECT t.id,t.name,t.descr,t.size,t.category,t.seeders,t.leechers,t.added, c.name as catname FROM torrents as t LEFT JOIN categories as c ON t.category = c.id WHERE ' . $where . ' t.visible="yes" ORDER BY t.added DESC ' . $limit) or sqlerr(__FILE__, __LINE__);
while ($a = mysqli_fetch_assoc($res)) {
$link = $INSTALLER09['baseurl'] . ($feed == "dl" ? "/download.php?torrent=" . (int) $a['id'] . '&torrent_pass='******'catname']) . " {$br} Size: " . mksize((int) $a["size"]) . " {$br} Leechers: " . (int) $a["leechers"] . " {$br} Seeders: " . (int) $a["seeders"] . " {$br} Added: " . get_date($a['added'], 'DATE') . " {$br} Description: " . htmlsafechars(substr($a["descr"], 0, 450)) . " {$br}</description>\n</item>\n";
}
$HTMLOUT .= "</channel>\n</rss>\n";
echo $HTMLOUT;
$smallname = substr(htmlsafechars($row["name"]), 0, 25);
if ($smallname != htmlsafechars($row["name"])) {
$smallname .= '...';
}
$HTMLOUT .= '<tr>
<td><a href="userdetails.php?id=' . (int) $row['userid'] . '">' . htmlsafechars($row['username']) . '</a></td>
<td><a href="details.php?id=' . (int) $row['torrent'] . '">' . $smallname . '</a></td>
<td align="center">' . htmlsafechars($row['ip']) . '</td>
<td align="center">' . htmlsafechars($row['port']) . '</td>
<td align="center">' . htmlsafechars(mksize($row['uploaded'])) . '</td>
' . ($INSTALLER09['ratio_free'] ? '' : '<td align="center">' . htmlsafechars(mksize($row['downloaded'])) . '</td>') . '
<td align="center">' . htmlsafechars($row['passkey']) . '</td>
<td align="center">' . ($row['connectable'] == 'yes' ? "<img src='" . $INSTALLER09['pic_base_url'] . "aff_tick.gif' alt='Yes' title='Yes' />" : "<img src='" . $INSTALLER09['pic_base_url'] . "aff_cross.gif' alt='No' title='No' />") . '</td>
<td align="center">' . ($row['seeder'] == 'yes' ? "<img src='" . $INSTALLER09['pic_base_url'] . "aff_tick.gif' alt='Yes' title='Yes' />" : "<img src='" . $INSTALLER09['pic_base_url'] . "aff_cross.gif' alt='No' title='No' />") . '</td>
<td align="center">' . get_date($row['started'], 'DATE', 0, 1) . '</td>
<td align="center">' . get_date($row['last_action'], 'DATE', 0, 1) . '</td>
<td align="center">' . htmlsafechars(mksize($row['uploadoffset'])) . '</td>
' . ($INSTALLER09['ratio_free'] ? '' : '<td align="center">' . htmlsafechars(mksize($row['downloadoffset'])) . '</td>') . '
<td align="center">' . htmlsafechars(mksize($row['to_go'])) . '</td>
</tr>';
}
$HTMLOUT .= "</table>";
} else {
$HTMLOUT .= "No peers found";
}
if ($count > $peersperpage) {
$HTMLOUT .= $pager['pagerbottom'];
}
$HTMLOUT .= end_main_frame();
echo stdhead('Peer Overview') . $HTMLOUT . stdfoot();
die;
