function peerstable($res)
{
$ret = "<table align='center' cellpadding=\"3\" cellspacing=\"0\" class=\"table_table\" width=\"100%\" border=\"1\"><tr><th class='table_head'>" . T_("NAME") . "</th><th class='table_head'>" . T_("SIZE") . "</th><th class='table_head'>" . T_("UPLOADED") . "</th>\n<th class='table_head'>" . T_("DOWNLOADED") . "</th><th class='table_head'>" . T_("RATIO") . "</th></tr>\n";
while ($arr = mysql_fetch_assoc($res)) {
$res2 = SQL_Query_exec("SELECT name,size FROM torrents WHERE id={$arr['torrent']} ORDER BY name");
$arr2 = mysql_fetch_assoc($res2);
if ($arr["downloaded"] > 0) {
$ratio = number_format($arr["uploaded"] / $arr["downloaded"], 2);
} else {
$ratio = "---";
}
$ret .= "<tr><td class='table_col1'><a href='torrents-details.php?id={$arr['torrent']}&hit=1'><b>" . htmlspecialchars($arr2["name"]) . "</b></a></td><td align='center' class='table_col2'>" . mksize($arr2["size"]) . "</td><td align='center' class='table_col1'>" . mksize($arr["uploaded"]) . "</td><td align='center' class='table_col2'>" . mksize($arr["downloaded"]) . "</td><td align='center' class='table_col1'>{$ratio}</td></tr>\n";
}
$ret .= "</table>\n";
return $ret;
}
show_error_msg(T_("FILE_NOT_FOUND"), T_("FILE_UNREADABLE"), 1);
}
$name = $row['filename'];
$friendlyurl = str_replace("http://", "", $site_config["SITEURL"]);
$friendlyname = str_replace(".torrent", "", $name);
$friendlyext = ".torrent";
$name = $friendlyname . "[" . $friendlyurl . "]" . $friendlyext;
SQL_Query_exec("UPDATE torrents SET hits = hits + 1 WHERE id = {$id}");
require_once "backend/BEncode.php";
require_once "backend/BDecode.php";
//if user dont have a passkey generate one, only if tracker is set to members only
if ($site_config["MEMBERSONLY"]) {
if (strlen($CURUSER['passkey']) != 32) {
$rand = array_sum(explode(" ", microtime()));
$CURUSER['passkey'] = md5($CURUSER['username'] . $rand . $CURUSER['secret'] . $rand * mt_rand());
SQL_Query_exec("UPDATE users SET passkey='{$CURUSER['passkey']}' WHERE id={$CURUSER['id']}");
}
}
if ($row["external"] != 'yes' && $site_config["MEMBERSONLY"]) {
// local torrent so add passkey
$dict = BDecode(file_get_contents($fn));
$dict['announce'] = sprintf($site_config["PASSKEYURL"], $CURUSER["passkey"]);
unset($dict['announce-list']);
$data = BEncode($dict);
//header('Content-Disposition: attachment; filename="'.$name.'"');
header('Content-Disposition: attachment; filename=' . sqlesc($name) . '');
//header('Content-Length: ' . strlen($data));
header("Content-Type: application/x-bittorrent");
print $data;
} else {
// external torrent so no passkey needed
$res = SQL_Query_exec("SELECT id, name FROM torrents WHERE id = {$id}");
$row = mysql_fetch_array($res);
if (!$row) {
show_error_msg(T_("ERROR"), "News id invalid", 0);
stdfoot();
}
echo "<center><b>" . T_("COMMENTSFOR") . "</b> <a href='torrents-details.php?id=" . $row['id'] . "'>" . htmlspecialchars($row['name']) . "</a></center><br />";
}
begin_frame(T_("COMMENTS"));
$subres = SQL_Query_exec("SELECT COUNT(*) FROM comments WHERE {$type} = {$id}");
$subrow = mysql_fetch_array($subres);
$commcount = $subrow[0];
if ($commcount) {
list($pagertop, $pagerbottom, $limit) = pager(10, $commcount, "comments.php?id={$id}&type={$type}&");
$commquery = "SELECT comments.id, text, user, comments.added, avatar, signature, username, title, class, uploaded, downloaded, privacy, donated FROM comments LEFT JOIN users ON comments.user = users.id WHERE {$type} = {$id} ORDER BY comments.id {$limit}";
$commres = SQL_Query_exec($commquery);
} else {
unset($commres);
}
if ($commcount) {
print $pagertop;
commenttable($commres, $type);
print $pagerbottom;
} else {
print "<br /><b>" . T_("NOCOMMENTS") . "</b><br />\n";
}
echo "<center>";
echo "<form name=\"comment\" method=\"post\" action=\"comments.php?type={$type}&id={$id}&takecomment=yes\">";
echo textbbcode("comment", "body") . "<br />";
echo "<input type=\"submit\" value=\"" . T_("ADDCOMMENT") . "\" />";
echo "</form></center>";
print "<br /><center><a href='torrents.php'>" . T_("BROWSE_TORRENTS") . "</a> - <a href='torrents-search.php'>" . T_("SEARCH_TORRENTS") . "</a></center><br />";
if ($site_config["MEMBERSONLY"] && !$CURUSER) {
echo "<br /><br /><center><b>" . T_("BROWSE_MEMBERS_ONLY") . "</b></center><br /><br />";
} else {
$query = "SELECT torrents.id, torrents.anon, torrents.announce, torrents.category, torrents.leechers, torrents.nfo, torrents.seeders, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.comments, torrents.numfiles, torrents.filename, torrents.owner, torrents.external, torrents.freeleech, categories.name AS cat_name, categories.image AS cat_pic, categories.parent_cat AS cat_parent, users.username, users.privacy, IF(torrents.numratings < 2, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id WHERE visible = 'yes' AND banned = 'no' ORDER BY id DESC LIMIT 25";
$res = SQL_Query_exec($query);
if (mysql_num_rows($res)) {
torrenttable($res);
} else {
print "<div class='f-border'>";
print "<div class='f-cat' width='100%'>" . T_("NOTHING_FOUND") . "</div>";
print "<div>";
print T_("NO_UPLOADS");
print "</div>";
print "</div>";
}
if ($CURUSER) {
SQL_Query_exec("UPDATE users SET last_browse=" . gmtime() . " WHERE id={$CURUSER['id']}");
}
}
end_frame();
if (!$site_config["MEMBERSONLY"] || $CURUSER) {
}
if ($site_config['DISCLAIMERON']) {
begin_frame(T_("DISCLAIMER"));
echo "<MARQUEE behavior=\"scroll\" align=\"center\" direction=\"up\" height=\"80\" scrollamount=\"0.8\" scrolldelay= \"20\" onmouseover='this.stop()' onmouseout='this.start()'>\n";
echo T_("DISCLAIMERTXT");
echo "</marquee>";
end_frame();
}
stdfoot();
<?php
//
// TorrentTrader v2.x
// $LastChangedDate: 2012-09-28 20:35:06 +0100 (Fri, 28 Sep 2012) $
// $LastChangedBy: torrenttrader $
//
// http://www.torrenttrader.org
//
require_once "backend/functions.php";
dbconn();
$id = (int) $_GET["id"];
$md5 = $_GET["secret"];
$email = $_GET["email"];
if (!$id || !$md5 || !$email) {
show_error_msg(T_("ERROR"), T_("MISSING_FORM_DATA"), 1);
}
$res = SQL_Query_exec("SELECT `editsecret` FROM `users` WHERE `enabled` = 'yes' AND `status` = 'confirmed' AND `editsecret` != '' AND `id` = '{$id}'");
$row = mysql_fetch_assoc($res);
if (!$row) {
show_error_msg(T_("ERROR"), T_("NOTHING_FOUND"), 1);
}
$sec = $row["editsecret"];
if ($md5 != md5($sec . $email . $sec)) {
show_error_msg(T_("ERROR"), T_("NOTHING_FOUND"), 1);
}
SQL_Query_exec("UPDATE `users` SET `editsecret` = '', `email` = " . sqlesc($email) . " WHERE `id` = '{$id}' AND `editsecret` = " . sqlesc($row["editsecret"]));
header("Refresh: 0; url=account.php");
header("Location: account.php");
if ($site_config["MEMBERSONLY"]) {
loggedinonly();
if ($CURUSER["view_torrents"] == "no") {
show_error_msg(T_("ERROR"), T_("NO_TORRENT_VIEW"), 1);
}
}
$id = (int) $_GET["id"];
$res = SQL_Query_exec("SELECT name, external, banned FROM torrents WHERE id = {$id}");
$row = mysql_fetch_assoc($res);
if (!$row || $row["banned"] == "yes" && $CURUSER["edit_torrents"] == "no") {
show_error_msg(T_("ERROR"), T_("TORRENT_NOT_FOUND"), 1);
}
if ($row["external"] == "yes") {
show_error_msg(T_("ERROR"), T_("THIS_TORRENT_IS_EXTERNALLY_TRACKED"), 1);
}
$res = SQL_Query_exec("SELECT users.id, users.username, users.uploaded, users.downloaded, users.privacy, completed.date FROM users LEFT JOIN completed ON users.id = completed.userid WHERE users.enabled = 'yes' AND completed.torrentid = '{$id}'");
if (mysql_num_rows($res) == 0) {
show_error_msg(T_("ERROR"), T_("NO_DOWNLOADS_YET"), 1);
}
$title = sprintf(T_("COMPLETED_DOWNLOADS"), CutName($row["name"], 40));
stdhead($title);
begin_frame($title);
?>
<table cellpadding="3" cellspacing="0" align="center" class="table_table">
<tr>
<th class="table_head"><?php
echo T_("USERNAME");
?>
</th>
<th class="table_head"><?php
if ($row[image1]) {
$del = unlink($site_config["torrent_dir"] . "/images/{$row['image1']}");
$updateset[] = "image1 = ''";
}
}
$img2action = $_POST['img2action'];
if ($img2action == "update") {
$updateset[] = "image2 = " . sqlesc(uploadimage(1, $row["image2"], $id));
}
if ($img2action == "delete") {
if ($row[image2]) {
$del = unlink($site_config["torrent_dir"] . "/images/{$row['image2']}");
$updateset[] = "image2 = ''";
}
}
SQL_Query_exec("UPDATE torrents SET " . join(",", $updateset) . " WHERE id = {$id}");
$returl = "torrents-edit.php?id={$id}&edited=1";
if (isset($_POST["returnto"])) {
$returl = $_POST["returnto"];
}
write_log("Torrent {$id} (" . htmlspecialchars($_POST["name"]) . ") was edited by {$CURUSER['username']}");
header("Location: {$returl}");
die;
}
//END SAVE TO DB
//UPDATE CATEGORY DROPDOWN
$catdropdown = "<select name=\"type\">\n";
$cats = genrelist();
foreach ($cats as $catdropdownubrow) {
$catdropdown .= "<option value=\"" . $catdropdownubrow["id"] . "\"";
if ($catdropdownubrow["id"] == $row["category"]) {
if (strtolower(substr($val, 0, 4)) != "udp:") {
SQL_Query_exec("INSERT INTO `announce` (`torrent`, `url`) VALUES({$id}, " . sqlesc($val) . ")");
}
}
}
if ($nfo == 'yes') {
move_uploaded_file($nfofilename, "{$nfo_dir}/{$id}.nfo");
}
//EXTERNAL SCRAPE
if ($external == 'yes' && $site_config['UPLOADSCRAPE']) {
$tracker = str_replace("/announce", "/scrape", $announce);
$stats = torrent_scrape_url($tracker, $infohash);
$seeders = (int) strip_tags($stats['seeds']);
$leechers = (int) strip_tags($stats['peers']);
$downloaded = (int) strip_tags($stats['downloaded']);
SQL_Query_exec("UPDATE torrents SET leechers='" . $leechers . "', seeders='" . $seeders . "',times_completed='" . $downloaded . "',last_action= '" . get_date_time() . "',visible='yes' WHERE id='" . $id . "'");
}
//END SCRAPE
write_log(sprintf(T_("TORRENT_UPLOADED"), htmlspecialchars($name), $CURUSER["username"]));
//Uploaded ok message (update later)
if ($external == 'no') {
$message = sprintf(T_("TORRENT_UPLOAD_LOCAL"), $name, $id, $id);
} else {
$message = sprintf(T_("TORRENT_UPLOAD_EXTERNAL"), $name, $id);
}
show_error_msg(T_("UPLOAD_COMPLETE"), $message, 1);
die;
}
//takeupload
///////////////////// FORMAT PAGE ////////////////////////
stdhead(T_("UPLOAD"));
<?php
//USERS ONLINE
begin_block(T_("NEWEST_MEMBERS"));
$expire = 600;
// time in seconds
if (($rows = $TTCache->Get("newestmember_block", $expire)) === false) {
$res = SQL_Query_exec("SELECT id, username FROM users WHERE enabled = 'yes' AND status='confirmed' AND privacy != 'strong' ORDER BY id DESC LIMIT 5");
$rows = array();
while ($row = mysql_fetch_assoc($res)) {
$rows[] = $row;
}
$TTCache->Set("newestmember_block", $rows, $expire);
}
if (!$rows) {
?>
<p class="text-center"><?php
echo T_("NOTHING_FOUND");
?>
</p>
<?php
} else {
?>
<div class="list-group">
<?php
foreach ($rows as $row) {
?>
<a href='account-details.php?id=<?php
echo $row["id"];
?>
' class="list-group-item"><?php
<?php
if (!$site_config["MEMBERSONLY"] || $CURUSER) {
begin_block(T_("BROWSE_TORRENTS"));
$catsquery = SQL_Query_exec("SELECT distinct parent_cat FROM categories ORDER BY parent_cat");
echo "<div id='maincats' class='bMenu'><ul>\n";
echo "<li><a href='torrents.php'>" . T_("SHOW_ALL") . "</a></li>\n";
while ($catsrow = mysql_fetch_assoc($catsquery)) {
echo "<li><a href='torrents.php?parent_cat=" . urlencode($catsrow['parent_cat']) . "'>{$catsrow['parent_cat']}</a></li>\n";
}
echo "</ul></div>\n";
end_block();
}
<?php
if (!$site_config["MEMBERSONLY"] || $CURUSER) {
begin_block(T_("LATEST_TORRENTS"));
$expire = 900;
// time in seconds
if (($latestuploadsrecords = $TTCache->Get("latestuploadsblock", $expire)) === false) {
$latestuploadsquery = SQL_Query_exec("SELECT id, name, size, seeders, leechers FROM torrents WHERE banned='no' AND visible = 'yes' ORDER BY id DESC LIMIT 5");
$latestuploadsrecords = array();
while ($latestuploadsrecord = mysql_fetch_assoc($latestuploadsquery)) {
$latestuploadsrecords[] = $latestuploadsrecord;
}
$TTCache->Set("latestuploadsblock", $latestuploadsrecords, $expire);
}
if ($latestuploadsrecords) {
foreach ($latestuploadsrecords as $row) {
$char1 = 18;
//cut length
$smallname = htmlspecialchars(CutName($row["name"], $char1));
echo "<a href='torrents-details.php?id={$row['id']}' title='" . htmlspecialchars($row["name"]) . "'>{$smallname}</a><br />\n";
echo "- [" . T_("SIZE") . ": " . mksize($row["size"]) . "]<br /><br />\n";
}
} else {
print "<center>" . T_("NOTHING_FOUND") . "</center>\n";
}
end_block();
}
while ($ss_a = mysql_fetch_assoc($ss_r)) {
$ss_id = $ss_a["id"];
$ss_name = $ss_a["name"];
$ss_sa[$ss_name] = $ss_id;
}
ksort($ss_sa);
reset($ss_sa);
while (list($ss_name, $ss_id) = each($ss_sa)) {
if ($ss_id == $CURUSER["stylesheet"]) {
$ss = " selected='selected'";
} else {
$ss = "";
}
$stylesheets .= "<option value='{$ss_id}'{$ss}>{$ss_name}</option>\n";
}
$lang_r = SQL_Query_exec("SELECT * from languages");
$lang_sa = array();
while ($lang_a = mysql_fetch_assoc($lang_r)) {
$lang_id = $lang_a["id"];
$lang_name = $lang_a["name"];
$lang_sa[$lang_name] = $lang_id;
}
ksort($lang_sa);
reset($lang_sa);
while (list($lang_name, $lang_id) = each($lang_sa)) {
if ($lang_id == $CURUSER["language"]) {
$lang = " selected='selected'";
} else {
$lang = "";
}
$languages .= "<option value='{$lang_id}'{$lang}>{$lang_name}</option>\n";
function navmenu()
{
global $site_config;
//Get Last Cleanup
$res = SQL_Query_exec("SELECT last_time FROM tasks WHERE task = 'cleanup'");
$row = mysql_fetch_row($res);
if (!$row) {
$lastclean = "never done...";
} else {
$row[0] = gmtime() - $row[0];
$days = intval($row[0] / 86400);
$row[0] -= $days * 86400;
$hours = intval($row[0] / 3600);
$row[0] -= $hours * 3600;
$mins = intval($row[0] / 60);
$secs = $row[0] - $mins * 60;
$lastclean = "{$days} days, {$hours} hrs, {$mins} minutes, {$secs} seconds ago.";
}
begin_frame(T_("MENU"));
print "Last cleanup performed: " . $lastclean . " [<a href='admincp.php?action=forceclean'>" . T_("FORCE_CLEAN") . "</a>]<br /><br />";
if ($site_config["ttversion"] != "2-svn") {
$file = @file_get_contents('https://www.torrenttrader.org/tt2version.php');
if ($site_config['ttversion'] >= $file) {
echo "<br /><center><b>" . T_("YOU_HAVE_LATEST_VER_INSTALLED") . " v{$site_config['ttversion']}</b></center>";
} else {
echo "<br /><center><b><font class='error'>" . T_("NEW_VERSION_OF_TT_NOW_AVAIL") . ": v" . $file . " you have v" . $site_config['ttversion'] . "<br /> Please visit <a href=http://www.torrenttrader.org>TorrentTrader.org</a> to upgrade.</font></b></center>";
}
}
$res = SQL_Query_exec("SELECT VERSION() AS mysql_version");
$row = mysql_fetch_assoc($res);
$mysqlver = $row['mysql_version'];
$pending = get_row_count("users", "WHERE status = 'pending' AND invited_by = '0'");
echo "<center><b>" . T_("USERS_AWAITING_VALIDATION") . ":</b> <a href='admincp.php?action=confirmreg'>({$pending})</a></center><br />";
echo "<center>" . T_("VERSION_MYSQL") . ": <b>" . $mysqlver . "</b><br />" . T_("VERSION_PHP") . ": <b>" . phpversion() . "</b></center>";
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><a href="admincp.php?action=usersearch"><img src="images/admin/user_search.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("ADVANCED_USER_SEARCH");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=avatars"><img src="images/admin/avatar_log.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("AVATAR_LOG");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=backups"><img src="images/admin/db_backup.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("BACKUPS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=ipbans"><img src="images/admin/ip_block.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("BANNED_IPS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=bannedtorrents"><img src="images/admin/banned_torrents.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("BANNED_TORRENTS");
?>
</a><br /></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=blocks&do=view"><img src="images/admin/blocks.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("BLOCKS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=cheats"><img src="images/admin/cheats.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("DETECT_POSS_CHEATS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=emailbans"><img src="images/admin/mail_bans.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("EMAIL_BANS");
?>
</a><br /></td>
<td align="center"><a href="faq-manage.php"><img src="images/admin/faq.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("FAQ");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=freetorrents"><img src="images/admin/free_leech.png" border="0" width="32" height="32" alt="" /><br />Freeleech Torrents<?php
/*echo T_("TORRENTS_FREE_LEECH");*/
?>
</a><br /></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=lastcomm"><img src="images/admin/comments.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("LATEST_COMMENTS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=masspm"><img src="images/admin/mass_pm.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("MASS_PM");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=messagespy"><img src="images/admin/message_spy.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("MESSAGE_SPY");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=news&do=view"><img src="images/admin/news.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("NEWS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=peers"><img src="images/admin/peer_list.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("PEERS_LIST");
?>
</a><br /></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=polls&do=view"><img src="images/admin/polls.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("POLLS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=reports&do=view"><img src="images/admin/report_system.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("REPORTS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=rules&do=view"><img src="images/admin/rules.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("RULES");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=sitelog"><img src="images/admin/site_log.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("SITELOG");
?>
</a><br /></td>
<td align="center"><a href="teams-create.php"><img src="images/admin/teams.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("TEAMS");
?>
</a><br /></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=style"><img src="images/admin/themes.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("THEME_MANAGEMENT");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=categories&do=view"><img src="images/admin/torrent_cats.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("TORRENT_CAT_VIEW");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=torrentlangs&do=view"><img src="images/admin/torrent_lang.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("TORRENT_LANG");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=torrentmanage"><img src="images/admin/torrents.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("TORRENTS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=groups&do=view"><img src="images/admin/user_groups.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("USER_GROUPS_VIEW");
?>
</a><br /></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=warned"><img src="images/admin/warned_user.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("WARNED_USERS");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=whoswhere"><img src="images/admin/whos_where.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("WHOS_WHERE");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=censor"><img src="images/admin/word_censor.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("WORD_CENSOR");
?>
</a><br /></td>
<td align="center"><a href="admincp.php?action=forum"><img src="images/admin/forums.png" border="0" width="32" height="32" alt="" /><br /><?php
echo T_("FORUM_MANAGEMENT");
?>
<br /></a></td>
<td align="center"><a href="admincp.php?action=users"><img src="images/admin/simple_user_search.png" border="0" width="32" height="32" alt="" /><br />Simple User Search<br /></a></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td align="center"><a href="admincp.php?action=privacylevel"><img src="images/admin/privacy_level.png" border="0" width="32" height="32" alt="" /><br />Privacy Level<br /></a></td>
<td align="center"><a href="admincp.php?action=pendinginvite"><img src="images/admin/pending_invited_user.png" border="0" width="32" height="32" alt="" /><br />Pending Invited Users<br /></a></td>
<td align="center"><a href="admincp.php?action=invited"><img src="images/admin/invited_user.png" border="0" width="32" height="32" alt="" /><br />Invited Users<br /></a></td>
<td align="center"><a href="admincp.php?action=sqlerr"><img src="images/admin/sql_error.png" border="0" width="32" height="32" alt="" /><br />SQL Error<br /></a></td>
<td align="center"><a href="admincp.php?action=settings"><img src="images/admin/config.png" border="0" width="32" height="32" alt="" /><br />Configuration<br /></a></td>
</tr>
</table>
<?php
end_frame();
}
function SQL_Query_exec_cached($query, $cache_time = 300, $cache_blank = 1)
{
global $TTCache;
$cache = "queries/" . sha1($query);
if (($rows = $TTCache->Get($cache, $cache_time)) === false) {
$res = SQL_Query_exec($query);
$rows = array();
while ($row = mysql_fetch_assoc($res)) {
$rows[] = $row;
}
if (count($rows) || $cache_blank) {
$TTCache->Set($cache, $rows, $cache_time);
}
}
return count($rows) ? $rows : false;
}
$ncomments = number_format(get_row_count("comments"));
$nmessages = number_format(get_row_count("messages"));
$ntor = number_format(get_row_count("torrents"));
$totaltoday = number_format(get_row_count("users", "WHERE users.last_access>='{$date_time}'"));
$regtoday = number_format(get_row_count("users", "WHERE users.added>='{$date_time}'"));
$todaytor = number_format(get_row_count("torrents", "WHERE torrents.added>='{$date_time}'"));
$guests = number_format(getguests());
$seeders = get_row_count("peers", "WHERE seeder='yes'");
$leechers = get_row_count("peers", "WHERE seeder='no'");
$members = number_format(get_row_count("users", "WHERE UNIX_TIMESTAMP('" . get_date_time() . "') - UNIX_TIMESTAMP(users.last_access) < 900"));
$totalonline = $members + $guests;
$result = SQL_Query_exec("SELECT SUM(downloaded) AS totaldl FROM users");
while ($row = mysql_fetch_array($result)) {
$totaldownloaded = $row["totaldl"];
}
$result = SQL_Query_exec("SELECT SUM(uploaded) AS totalul FROM users");
while ($row = mysql_fetch_array($result)) {
$totaluploaded = $row["totalul"];
}
$localpeers = $leechers + $seeders;
if ($CURUSER["edit_users"] == "yes") {
begin_block(T_("STATS"));
?>
<ul class="list-unstyled">
<p><strong><?php
echo T_("TORRENTS");
?>
</strong></p>
<li><i class="fa fa-folder-open-o"></i> <?php
echo T_("TRACKING");
if (mysql_num_rows($res) == 0) {
print "Invalid Forum ID";
end_frame();
stdfoot();
die;
}
$arr = mysql_fetch_array($res);
print "<b>Are you sure you would like to report the following forum post:</b><br /><a href='forums.php?action=viewtopic&topicid={$forumid}&page=p#post{$forumpost}'><b>{$arr['subject']}</b></a>?<br />";
print "<b>Reason</b> (required): <form method='post' action='report.php'><input type='hidden' name='forumid' value='{$forumid}' /><input type='hidden' name='forumpost' value='{$forumpost}'><input type='text' size='100' name='reason' /><input type='submit' value='Confirm' /></form>";
end_frame();
stdfoot();
die;
}
//report comment form
if ($comment != "") {
$res = SQL_Query_exec("SELECT id, text FROM comments WHERE id={$comment}");
if (mysql_num_rows($res) == 0) {
print "Invalid Comment";
end_frame();
stdfoot();
die;
}
$arr = mysql_fetch_assoc($res);
print "<b>Are you sure you would like to report Comment:</b><br /><br /><b>" . format_comment($arr["text"]) . "</b>?<br />";
print "<p>Please note, this is <b>not</b> to be used to report leechers, we have scripts in place to deal with them</p>";
print "<b>Reason</b> (required): <form method='post' action='report.php'><input type='hidden' name='comment' value='{$comment}' /><input type='text' size='100' name='reason' /><input type='submit' value='Confirm' /></form>";
end_frame();
stdfoot();
die;
}
//error
$id = (int) cleanstr($_REQUEST["id"]);
$do = $_POST["do"];
$nfo = $site_config["nfo_dir"] . "/{$id}.nfo";
if ($do == "update") {
if (is_file($nfo)) {
file_put_contents($nfo, $_POST['content']);
write_log("NFO ({$id}) was updated by {$CURUSER['username']}.");
show_error_msg(T_("NFO_UPDATED"), T_("NFO_UPDATED"), 1);
}
}
if ($do == "delete") {
$reason = htmlspecialchars($_POST["reason"]);
if (get_row_count("torrents", "WHERE `nfo` = 'yes' AND `id` = {$id}")) {
unlink($nfo);
write_log("NFO ({$id}) was deleted by {$CURUSER['username']} {$reason}");
SQL_Query_exec("UPDATE `torrents` SET `nfo` = 'no' WHERE `id` = {$id}");
show_error_msg(T_("NFO_DELETED"), T_("NFO_DELETED"), 1);
}
show_error_msg(T_("ERROR"), sprintf(T_("NFO_NOT_EXIST"), $id), 1);
}
if (!is_valid_id($id) || !($contents = file_get_contents($nfo))) {
show_error_msg(T_("ERROR"), T_("NFO_NOT_FOUND"), 1);
}
stdhead(T_("NFO_EDITOR"));
begin_frame(T_("NFO_EDIT"));
?>
<center>
<form method="post" action="nfo-edit.php">
<input type="hidden" name="id" value="<?php
echo $id;
<div class="fltRight">
<?php
if (!$CURUSER) {
echo "";
} else {
print T_("<font color='white'>Howdy!</font>") . " " . class_user($CURUSER[username]) . "";
$userdownloaded = mksize($CURUSER["downloaded"]);
$useruploaded = mksize($CURUSER["uploaded"]);
if ($CURUSER["uploaded"] > 0 && $CURUSER["downloaded"] == 0) {
$userratio = "Inf.";
} elseif ($CURUSER["downloaded"] > 0) {
$userratio = number_format($CURUSER["uploaded"] / $CURUSER["downloaded"], 2);
} else {
$userratio = "---";
}
$query_slots = @mysql_fetch_row(@SQL_Query_exec("SELECT COUNT(DISTINCT torrent) FROM peers WHERE userid = {$CURUSER['id']} AND seeder='no'"));
$maxslot = avail_slots($CURUSER["id"], $CURUSER["class"]);
$slots = number_format($maxslot) . "/" . number_format($query_slots[0]);
$invites = $CURUSER["invites"];
$seedbonus = $CURUSER["seedbonus"];
print ", <img src='../images/download.png' border='none' height='20' width='20' alt='Downloaded' title='Downloaded'> <font color='#CC0000'><b>{$userdownloaded}</b> </font> <img src='../images/upload.png' border='none' height='20' width='20' alt='Uploaded' title='Uploaded'> <font color='#009900'><b>{$useruploaded}</b></font> <img src='../images/ratio.png' border='none' height='20' width='20' alt='Ratio' title='Ratio'> <font color='blue'><b>{$userratio}</b></font> <img src='../images/invite.png' border='none' height='20' width='20' alt='Invites' title='invites'> <b><font color='white'>Invites</font></b> : <a href='" . $site_config["SITEURL"] . "../invite.php'><b><font color='purple'>{$invites}</font></b></a> <font color='white'><b>Download Slots:</b></font> <b><font color='yellow'>{$slots}</b></font>";
echo " <a class='profile' href='" . $site_config["SITEURL"] . "/account/'><img src='/images/setting.png' border='none' height='20' width='20' alt='Account Setting' title='Account Setting'></a> <a class='account' href='../user/?id={$CURUSER['id']}'><img src='../images/profile.png' border='none' height='20' width='20' alt='Profile' title='Profile'></a> <a class='logout' href=\"" . $site_config["SITEURL"] . "/account-logout.php\"><img src='../images/logout.png' border='none' height='20' width='20' alt='Logout' title='Logout'></a>";
//check for new pm's
$res = mysql_query("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " and unread='yes' AND location IN ('in','both')") or print mysql_error();
$arr = mysql_fetch_row($res);
$unreadmail = $arr[0];
if ($unreadmail) {
print "<embed src='../mail.mp3' autostart='true' width='0' height='0' hidden='true'><a class='mail_n' href=" . $site_config["SITEURL"] . "/message/?inbox><img src='../images/mails.png' border='none' height='20' width='20' alt='New PM' title='({$unreadmail}) New PM'S'><font color='red'>({$unreadmail})</font><p></a> ";
} else {
print "<a class='mail' href=" . $site_config["SITEURL"] . "/message/><img src='../images/mail.png' border='none' height='20' width='20' alt='My Messages' title='My Messages'></a> ";
}
<?php
if (!$site_config["MEMBERSONLY"] || $CURUSER) {
begin_block(T_("SEEDERS_WANTED"));
$external = "external = 'no'";
// Uncomment below to include external torrents
$external = 1;
$expires = 600;
// Cache time in seconds
if (($rows = $TTCache->Get("seedwanted_block", $expires)) === false) {
$res = SQL_Query_exec("SELECT id, name, seeders, leechers FROM torrents WHERE seeders = 0 AND leechers > 0 AND banned = 'no' AND {$external} ORDER BY leechers DESC LIMIT 5");
$rows = array();
while ($row = mysql_fetch_assoc($res)) {
$rows[] = $row;
}
$TTCache->Set("seedwanted_block", $rows, $expires);
}
if (!$rows) {
?>
<p class="text-center"><?php
echo T_("NOTHING_FOUND");
?>
</p>
<?php
} else {
foreach ($rows as $row) {
$char1 = 20;
//cut length
$smallname = htmlspecialchars(CutName($row["name"], $char1));
?>
$msg = "" . EMAIL_NOT_VALID . "";
$kind = "" . ERROR . "";
} else {
$res = SQL_Query_exec("SELECT id, username, email FROM users WHERE email=" . sqlesc($email) . " LIMIT 1");
$arr = mysql_fetch_assoc($res);
if (!$arr) {
$msg = "" . EMAIL_NOT_FOUND . "";
$kind = "" . ERROR . "";
}
if ($arr) {
$sec = mksecret();
$secmd5 = md5($sec);
$id = $arr['id'];
$body = "" . SOMEONE_FROM . " " . $_SERVER["REMOTE_ADDR"] . ", " . REC_MSG1 . " ({$email}) " . REC_MSG2 . " \r\n\r\n " . REC_MSG3 . " \r\n\r\n " . REC_MSG4 . " " . $arr["username"] . " \r\n " . REC_MSG5 . "\n\n{$site_config['SITEURL']}/account-recover.php?id={$id}&secret={$secmd5}\n\n\n" . $site_config["SITENAME"] . "\r\n";
@sendmail($arr["email"], "" . REC_YOUR_ACC_DETAILS . "", $body, "", "-f" . $site_config['SITEEMAIL']);
$res2 = SQL_Query_exec("UPDATE `users` SET `secret` = " . sqlesc($sec) . " WHERE `email`= " . sqlesc($email) . " LIMIT 1");
$msg = sprintf("" . MAIL_RECOVER . "", htmlspecialchars($email));
$kind = "" . SUCCESS . "";
}
}
}
if ($kind != "0") {
show_error2("" . NOTICE . "", "{$kind}: {$msg}", 0);
}
if (is_valid_id($_GET["id"]) && strlen($_GET["secret"]) == 32) {
?>
<div>
<form method="post" action="account-recover.php">
<fieldset>
<legend><?php
?>
</a></li>
<?php
if ($CURUSER["control_panel"] == "yes") {
?>
<li><a href='admincp.php'><?php
echo T_("STAFFCP");
?>
</a></li>
<?php
}
//check for new pm's
$res = SQL_Query_exec("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " and unread='yes' AND location IN ('in','both')");
$arr = mysql_fetch_row($res);
$unreadmail = $arr[0];
if ($unreadmail) {
?>
<li><a href='mailbox.php?inbox'><strong><span class="label label-warning"><?php
echo $unreadmail;
?>
</span> <?php
echo P_("NEWPM", $unreadmail);
?>
</strong></a></li>
<?php
} else {
// $LastChangedDate: 2012-09-19 19:13:35 +0100 (Wed, 19 Sep 2012) $
// $LastChangedBy: torrenttrader $
//
// http://www.torrenttrader.org
//
//
require_once "backend/functions.php";
dbconn();
stdhead(T_("FAQ"));
$faq_categ = null;
$res = SQL_Query_exec("SELECT `id`, `question`, `flag` FROM `faq` WHERE `type`='categ' ORDER BY `order` ASC");
while ($arr = mysql_fetch_array($res, MYSQL_BOTH)) {
$faq_categ[$arr[id]][title] = $arr[question];
$faq_categ[$arr[id]][flag] = $arr[flag];
}
$res = SQL_Query_exec("SELECT `id`, `question`, `answer`, `flag`, `categ` FROM `faq` WHERE `type`='item' ORDER BY `order` ASC");
while ($arr = mysql_fetch_array($res, MYSQL_BOTH)) {
$faq_categ[$arr[categ]][items][$arr[id]][question] = $arr[question];
$faq_categ[$arr[categ]][items][$arr[id]][answer] = $arr[answer];
$faq_categ[$arr[categ]][items][$arr[id]][flag] = $arr[flag];
}
if (isset($faq_categ)) {
// gather orphaned items
foreach ($faq_categ as $id => $temp) {
if (!array_key_exists("title", $faq_categ[$id])) {
foreach ($faq_categ[$id][items] as $id2 => $temp) {
$faq_orphaned[$id2][question] = $faq_categ[$id][items][$id2][question];
$faq_orphaned[$id2][answer] = $faq_categ[$id][items][$id2][answer];
$faq_orphaned[$id2][flag] = $faq_categ[$id][items][$id2][flag];
unset($faq_categ[$id]);
}
// TorrentTrader v2.x
// $LastChangedDate: 2011-10-20 11:45:04 +0100 (Thu, 20 Oct 2011) $
// $LastChangedBy: x-cooly-btit $
//
// http://www.torrenttrader.org
//
require_once "backend/functions.php";
dbconn();
$id = (int) $_GET["id"];
$md5 = $_GET["secret"];
if (!$id || !$md5) {
show_error_msg(T_("ERROR"), T_("INVALID_ID"), 1);
}
$res = SQL_Query_exec("SELECT `password`, `secret`, `status` FROM `users` WHERE `id` = '{$id}'");
$row = mysql_fetch_assoc($res);
if (!$row) {
show_error_msg(T_("ERROR"), sprintf(T_("CONFIRM_EXPIRE"), $site_config['signup_timeout'] / 86400), 1);
}
if ($row["status"] != "pending") {
header("Refresh: 0; url=account-confirm-ok.php?type=confirmed");
die;
}
if ($md5 != md5($row["secret"])) {
show_error_msg(T_("ERROR"), T_("SIGNUP_ACTIVATE_LINK"), 1);
}
$secret = mksecret();
SQL_Query_exec("UPDATE `users` SET `secret` = " . sqlesc($secret) . ", `status` = 'confirmed' WHERE `id` = '{$id}' AND `secret` = " . sqlesc($row["secret"]) . " AND `status` = 'pending'");
if (!mysql_affected_rows()) {
show_error_msg(T_("ERROR"), T_("SIGNUP_UNABLE"), 1);
}
header("Refresh: 0; url=account-confirm-ok.php?type=confirm");
<td><?php
echo T_("AGE");
?>
:</td>
<td><input type="text" size="40" name="age" maxlength="3" /></td>
</tr>
<tr>
<td><?php
echo T_("COUNTRY");
?>
:</td>
<td>
<select name="country" size="1">
<?php
$countries = "<option value=\"0\">---- " . T_("NONE_SELECTED") . " ----</option>\n";
$ct_r = SQL_Query_exec("SELECT id,name,domain from countries ORDER BY name");
while ($ct_a = mysql_fetch_assoc($ct_r)) {
$countries .= "<option value=\"{$ct_a['id']}\">{$ct_a['name']}</option>\n";
}
?>
<?php
echo $countries;
?>
</select>
</td>
</tr>
<tr>
<td><?php
echo T_("GENDER");
?>
:</td>
}
// $sender = $arr['sendername'];
if ($arr["receiver"] == $CURUSER['id']) {
$sentto = "Yourself";
} elseif (is_valid_id($arr["receiver"])) {
$res2 = SQL_Query_exec("SELECT username FROM users WHERE `id` = {$arr['receiver']}");
$arr2 = mysql_fetch_assoc($res2);
$sentto = "<a href=\"account-details.php?id={$arr['receiver']}\">" . ($arr2["username"] ? $arr2["username"] : "******") . "</a>";
} else {
$sentto = T_("SYSTEM");
}
$subject = $arr['subject'] ? htmlspecialchars($arr['subject']) : "no subject";
if (@$_GET['read'] == $arr['id']) {
$reading = true;
if (isset($_GET['inbox']) && $arr["unread"] == "yes") {
SQL_Query_exec("UPDATE messages SET `unread` = 'no' WHERE `id` = {$arr['id']} AND `receiver` = {$CURUSER['id']}");
}
}
if ($arr["unread"] == "yes") {
$format = "font-weight:bold;";
$unread = true;
}
$table[' '] = th_left("<input type=\"checkbox\" name=\"msgs[{$arr['id']}]\" " . ($reading ? "checked='checked'" : "") . " onclick=\"this.form.remove.disabled=true;\" />", 1);
$table['Sender'] = th_left("{$sender}", 1, $format);
$table['Sent_to'] = th_left("{$sentto}", 1, $format);
$table['Subject'] = th_left("<a href=\"javascript:read({$arr['id']});\"><img src=\"" . $site_config["SITEURL"] . "/images/plus.gif\" id=\"img_{$arr['id']}\" class=\"read\" border=\"0\" alt='' /></a> <a href=\"javascript:read({$arr['id']});\">{$subject}</a>", 1, $format);
$table['Date'] = th_left(utc_to_tz($arr['added']), 1, $format);
table($table, $tablefmt);
$display = "<div>" . format_comment($arr['msg']) . "<br /><br />";
if (isset($_GET['inbox']) && is_valid_id($arr["sender"])) {
$display .= "<input type=\"submit\" name=\"compose[{$arr['id']}]\" value=\"Reply\" /> \n";
function avail_slots($userid, $class)
{
$queries = SQL_Query_exec("SELECT `maxslots` FROM `groups` WHERE `group_id` = {$class}");
$row = mysql_fetch_array($queries);
$res_user = SQL_Query_exec("SELECT id, warned FROM users WHERE id = {$userid}");
$row_user = mysql_fetch_array($res_user);
if ($row_user['warned'] == 'yes') {
$maxslot = 1;
} else {
$maxslot = $row[0];
}
return $maxslot;
}
stdhead(T_("FAQ_MANAGEMENT"));
begin_frame();
print "<h1 align=\"center\">Add Section</h1>";
print "<form method=\"post\" action=\"faq-actions.php?action=addnewsect\">";
print "<table border=\"0\" class=\"table_table\" cellspacing=\"0\" cellpadding=\"10\" align=\"center\">\n";
print "<tr><td class='table_col1'>Title:</td><td class='table_col1'><input style=\"width: 300px;\" type=\"text\" name=\"title\" value=\"\" /></td></tr>\n";
print "<tr><td class='table_col2'>Status:</td><td class='table_col2'><select name=\"flag\" style=\"width: 110px;\"><option value=\"0\" style=\"color: #ff0000;\">Hidden</option><option value=\"1\" style=\"color: #000000;\" selected=\"selected\">Normal</option></select></td></tr>";
print "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" name=\"edit\" value=\"Add\" style=\"width: 60px;\" /></td></tr>\n";
print "</table></form>";
end_frame();
stdfoot();
} elseif ($_GET[action] == "addnewitem" && $_POST[question] != NULL && $_POST[answer] != NULL && is_valid_int($_POST[flag]) && is_valid_int($_POST[categ])) {
$question = sqlesc($_POST[question]);
$answer = sqlesc($_POST[answer]);
$res = SQL_Query_exec("SELECT MAX(`order`) FROM `faq` WHERE `type`='item' AND `categ`='{$_POST['categ']}'");
while ($arr = mysql_fetch_array($res, MYSQL_BOTH)) {
$order = $arr[0] + 1;
}
SQL_Query_exec("INSERT INTO `faq` (`type`, `question`, `answer`, `flag`, `categ`, `order`) VALUES ('item', {$question}, {$answer}, '{$_POST['flag']}', '{$_POST['categ']}', '{$order}')");
header("Refresh: 0; url=faq-manage.php");
} elseif ($_GET[action] == "addnewsect" && $_POST[title] != NULL && is_valid_int($_POST[flag])) {
$title = sqlesc($_POST[title]);
$res = SQL_Query_exec("SELECT MAX(`order`) FROM `faq` WHERE `type`='categ'");
while ($arr = mysql_fetch_array($res, MYSQL_BOTH)) {
$order = $arr[0] + 1;
}
SQL_Query_exec("INSERT INTO `faq` (`type`, `question`, `answer`, `flag`, `categ`, `order`) VALUES ('categ', {$title}, '', '{$_POST['flag']}', '0', '{$order}')");
header("Refresh: 0; url=faq-manage.php");
} else {
header("Refresh: 0; url=faq-manage.php");
}
}
print "<a href=\"../user/?id=" . $user["id"] . "\"><font style=\" color: " . $color . "\">" . class_user($user["username"]) . "</font></a>, ";
}
echo "<br /><b>" . T_("TORRENTS") . "</b>";
echo "<br /><small>" . T_("TRACKING") . ":<small><b> {$ntor} " . P_("TORRENT", $ntor) . "</b></small>";
echo "<br /><small>" . T_("NEW_TODAY") . ":<small><b> " . $todaytor . "</b></small>";
echo "<br />" . T_("SEEDERS") . ":<b> " . number_format($seeders) . "</b><br />" . T_("LEECHERS") . ":<b> " . number_format($leechers) . "</b>";
echo "<br /><small>" . T_("PEERS") . ":<b> " . number_format($localpeers) . "</b></small>";
echo "<br /><small>" . T_("DOWNLOADED") . ":<b> " . mksize($totaldownloaded) . "</b></small>";
echo "<br /><small>" . T_("UPLOADED") . ":<b> " . mksize($totaluploaded) . "</b></small>";
echo "<br /><b>Total Members</b>";
echo "<b> {$registered} " . P_("MEMBER", $registered) . "</b>";
print "<center><font color='red' size='2'><b>Administrator</b></font> | <font color='#00FF00' size='2'><b>Super Moderator</b></font> | <font color='#009900' size='2'><b>Moderator</b></font> | <font color='#0000FF' size='2'><b>Uploader</b></font> | <font color='#990099' size='2'><b>V.I.P</b></font> | <font color='#FF7519' size='2'><b>Power User</b></font> | <font color='#00FFFF' size='2'><b>User</b></font></center>, ";
end_frame();
begin_frame("{$members2} Users Online Last 24 Hours");
$resew = SQL_Query_exec("SELECT id, username, class, donated, warned FROM users WHERE UNIX_TIMESTAMP('" . get_date_time() . "') - UNIX_TIMESTAMP(users.last_access) <= 86400 ORDER BY username");
while ($arr = mysql_fetch_assoc($resew)) {
if ($todayactive) {
$todayactive .= ", ";
}
switch ($arr["class"]) {
case 7:
$arr["username"] = "******" . class_user($arr['username']) . "</font>";
break;
case 6:
$arr["username"] = "******" . class_user($arr['username']) . "</font>";
break;
case 5:
$arr["username"] = "******" . class_user($arr['username']) . "</font>";
break;
case 4:
if ($_GET['page'] > '1') {
$lowerlimit = $_GET['page'] * 100 - 100;
$upperlimit = $_GET['page'] * 100;
} else {
$lowerlimit = 0;
$upperlimit = 100;
}
} else {
$lowerlimit = 0;
$upperlimit = 100;
}
$query = 'SELECT * FROM shoutbox ORDER BY msgid DESC LIMIT ' . $lowerlimit . ',' . $upperlimit;
} else {
$query = 'SELECT * FROM shoutbox ORDER BY msgid DESC LIMIT 20';
}
$result = SQL_Query_exec($query);
$alt = false;
while ($row = mysql_fetch_assoc($result)) {
if ($alt) {
echo '<tr class="shoutbox_noalt">';
$alt = false;
} else {
echo '<tr class="shoutbox_alt">';
$alt = true;
}
echo '<td style="font-size: 9px; width: 118px;">';
echo "<div align='left' style='float: left'>";
echo date('jS M, g:ia', utc_to_tz_time($row['date']));
echo "</div>";
if ($CURUSER["edit_users"] == "yes" || $CURUSER['username'] == $row['user']) {
echo "<div align='right' style='float: right'><a href='" . $site_config['SITEURL'] . "/shoutbox.php?del=" . $row['msgid'] . "' style='font-size: 8px'>[D]</a></div>";
<?php
//
// TorrentTrader v2.x
// $LastChangedDate: 2011-10-27 20:00:39 +0100 (Thu, 27 Oct 2011) $
// $LastChangedBy: dj-howarth1 $
//
// http://www.torrenttrader.org
//
require_once "backend/functions.php";
dbconn();
stdhead(T_("SITE_RULES"));
$res = SQL_Query_exec("SELECT * FROM `rules` ORDER BY `id`");
while ($row = mysql_fetch_assoc($res)) {
if ($row["public"] == "yes") {
begin_frame($row["title"]);
echo format_comment($row["text"]);
end_frame();
} else {
if ($row["public"] == "no" && $row["class"] <= $CURUSER["class"]) {
begin_frame($row["title"]);
echo format_comment($row["text"]);
end_frame();
}
}
}
stdfoot();
