$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";
} elseif (isset($_GET['draft']) || isset($_GET['templates'])) {
$display .= "<input type=\"submit\" name=\"compose[{$arr['id']}]\" value=\"Edit\" /> ";
}
if (isset($_GET['inbox']) && $arr['unread'] == 'yes') {
$display .= "<input type=\"submit\" name=\"mark[{$arr['id']}]\" value=\"Mark as Read\" /> \n";
}
$display .= "<input type=\"submit\" name=\"remove[{$arr['id']}]\" value=\"Delete\" /> \n";
$display .= "</div>";
table(td_left($display, 1, "padding:0 6px 6px 6px"), $tablefmt, "id=\"msg_{$arr['id']}\" style=\"display:none;\"");
}
// if ($count)
$user['last_access'] = '---';
}
if ($user['ip']) {
$ipstr = $user['ip'];
} else {
$ipstr = "---";
}
$pul = $user['uploaded'];
$pdl = $user['downloaded'];
$auxres = SQL_Query_exec("SELECT COUNT(DISTINCT p.id) FROM forum_posts AS p LEFT JOIN forum_topics as t ON p.topicid = t.id\n\t\t\tLEFT JOIN forum_forums AS f ON t.forumid = f.id WHERE p.userid = " . $user['id'] . " AND f.minclassread <= " . $CURUSER['class']);
$n = mysql_fetch_row($auxres);
$n_posts = $n[0];
$auxres = SQL_Query_exec("SELECT COUNT(id) FROM comments WHERE user = "******"<tr><td class='table_col1' align='center'><b><a href='account-details.php?id={$user['id']}'>{$user['username']}</a></b></td>" . "<td class='table_col2' align='center'>" . $ipstr . "</td><td class='table_col1' align='center'>" . $user['email'] . "</td>" . "<td class='table_col2' align='center'>" . utc_to_tz($user['added']) . "</td>" . "<td class='table_col1' align='center'>" . $user['last_access'] . "</td>" . "<td class='table_col2' align='center'>" . $user['status'] . "</td>" . "<td class='table_col1' align='center'>" . $user['enabled'] . "</td>" . "<td class='table_col2' align='center'>" . ratios($pul, $pdl) . "</td>" . "<td class='table_col1' align='center'>" . mksize($user['uploaded']) . "</td>" . "<td class='table_col2' align='center'>" . mksize($user['downloaded']) . "</td>" . "<td class='table_col1' align='center'>{$n_posts} " . P_("POST", $n_posts) . "<br />{$n_comments} " . P_("COMMENT", $n_comments) . "</td>" . "<td class='table_col2' align='center'>" . ($user["enabled"] == "yes" && $user["warned"] == "no" ? "--" : ($user["enabled"] == "no" ? "<img src=\"images/disable.png\" title=\"" . T_("DISABLED") . "\" alt=\"Disabled\" />" : "") . ($user["warned"] == "yes" ? "<img src=\"images/warned.png\" title=\"" . T_("WARNED") . "\" alt=\"Warned\" />" : "")) . "</td>" . "<td class='table_col1' align='center'><input type='checkbox' name=\"warndisable[]\" value='" . $user['id'] . "' /><input type='hidden' name=\"referer\" value=\"{$_SERVER['REQUEST_URI']}\" /></td></tr>\n";
}
echo "</table>\n <br />\n\t\t\t<table border='0' align='center' cellspacing='0' cellpadding='0'>\n\t\t\t<tr><td colspan='2'></td></tr>\n\t\t\t<tr><td align='right'><img src=\"images/disable.png\" alt=\"Disabled\" /> <input type='submit' name='disable' value=\"Disable Selected Accounts\" /></td><td style=\"border: none; padding: 2px;\" align='left'><input type='submit' name='enable' value=\"Enable Selected Accounts\" /> <img src=\"images/disable.png\" alt=\"Disabled\" /> <img src=\"images/check.gif\" alt=\"Ok\" /></td></tr>\n\t\t\t<tr><td colspan='2'><br /><br /></td></tr>\n\t\t\t<tr><td align='center'><img src=\"images/warned.png\" alt=\"Warned\" /> <input type='submit' name='warn' value=\"Warn Selected\" /></td><td align='left'><input type='submit' name='unwarn' value=\"Remove Warning Selected\" /> <img src=\"images/warned.png\" alt=\"Warned\" /> <img src=\"images/check.gif\" alt=\"Ok\" /></td></tr>\n\t\t\t<tr><td align='center' colspan='2'>Mod Comment (reason):<input type='text' size='30' name='warnpm' /></td></tr>\n\t\t\t</table></form>\n";
if ($count > $perpage) {
echo $pagerbottom;
}
}
}
end_frame();
stdfoot();
}
// End Advanced User Search
// Forum management
if ($action == "forum") {
$error_ac == "";
if ($_POST["do"] == "add_this_forum") {
$peers = get_row_count("peers", "WHERE torrent = '{$id}' AND userid = '{$row['id']}' AND seeder = 'yes'") ? "<font color='green'>" . T_("YES") . "</font>" : "<font color='#ff0000'>" . T_("NO") . "</font>";
?>
<tr>
<td class="table_col1"><a href="account-details.php?id=<?php
echo $row["id"];
?>
"><?php
echo $row["username"];
?>
</a></td>
<td class="table_col2"><?php
echo $peers;
?>
</td>
<td class="table_col1"><?php
echo utc_to_tz($row["date"]);
?>
</td>
<td class="table_col2"><?php
echo number_format($ratio, 2);
?>
</td>
</tr>
<?php
}
?>
</table>
<center><a href="torrents-details.php?id=<?php
echo $id;
?>
function latestforumposts()
{
print "<div class='f-border f-latestpost'><table width='100%' cellspacing='0'><tr class='f-title'>" . "<th align='left' width=''>Latest Topic Title</th>" . "<th align='center' width='47'>Replies</th>" . "<th align='center' width='47'>Views</th>" . "<th align='center' width='85'>Author</th>" . "<th align='right' width='150'>Last Post</th>" . "</tr>";
/// HERE GOES THE QUERY TO RETRIEVE DATA FROM THE DATABASE AND WE START LOOPING ///
$for = SQL_Query_exec("SELECT * FROM forum_topics ORDER BY lastpost DESC LIMIT 5");
if (mysql_num_rows($for) == 0) {
print "<tr class='f-row'><td class='alt1' align='center' colspan='5'><b>No Latest Topics</b></td></tr>";
}
while ($topicarr = mysql_fetch_assoc($for)) {
// Set minclass
$res = SQL_Query_exec("SELECT name,minclassread,guest_read FROM forum_forums WHERE id={$topicarr['forumid']}");
$forum = mysql_fetch_assoc($res);
if ($forum && get_user_class() >= $forum["minclassread"] || $forum["guest_read"] == "yes") {
$forumname = "<a href='?action=viewforum&forumid={$topicarr['forumid']}'><b>" . htmlspecialchars($forum["name"]) . "</b></a>";
$topicid = $topicarr["id"];
$topic_title = stripslashes($topicarr["subject"]);
$topic_userid = $topicarr["userid"];
// Topic Views
$views = $topicarr["views"];
// End
/// GETTING TOTAL NUMBER OF POSTS ///
$res = SQL_Query_exec("SELECT COUNT(*) FROM forum_posts WHERE topicid={$topicid}");
$arr = mysql_fetch_row($res);
$posts = $arr[0];
$replies = max(0, $posts - 1);
/// GETTING USERID AND DATE OF LAST POST ///
$res = SQL_Query_exec("SELECT * FROM forum_posts WHERE topicid={$topicid} ORDER BY id DESC LIMIT 1");
$arr = mysql_fetch_assoc($res);
$postid = 0 + $arr["id"];
$userid = 0 + $arr["userid"];
$added = utc_to_tz($arr["added"]);
/// GET NAME OF LAST POSTER ///
$res = SQL_Query_exec("SELECT id, username FROM users WHERE id={$userid}");
if (mysql_num_rows($res) == 1) {
$arr = mysql_fetch_assoc($res);
$username = "******";
} else {
$username = "******";
}
/// GET NAME OF THE AUTHOR ///
$res = SQL_Query_exec("SELECT username FROM users WHERE id={$topic_userid}");
if (mysql_num_rows($res) == 1) {
$arr = mysql_fetch_assoc($res);
$author = "<a href='account-details.php?id={$topic_userid}'>{$arr['username']}</a>";
} else {
$author = "Unknown[{$topic_userid}]";
}
/// GETTING THE LAST INFO AND MAKE THE TABLE ROWS ///
$r = SQL_Query_exec("SELECT lastpostread FROM forum_readposts WHERE userid={$userid} AND topicid={$topicid}");
$a = mysql_fetch_row($r);
$new = !$a || $postid > $a[0];
$subject = "<a href='forums.php?action=viewtopic&topicid={$topicid}'><b>" . stripslashes(encodehtml($topicarr["subject"])) . "</b></a>";
print "<tr class='f-row'><td class='f-img' width='100%'>{$subject}</td>" . "<td class='alt2' align='center'>{$replies}</td>" . "<td class='alt3' align='center'>{$views}</td>" . "<td class='alt2' align='center'>{$author}</td>" . "<td class='alt3' align='right'><small>by {$username}<br /></small><small style='white-space: nowrap'>{$added}</small></td>";
print "</tr>";
}
// while
}
print "</table></div><br />";
}
:</b> <?php
echo $CURUSER["level"];
?>
<br />
<b><?php
echo T_("EMAIL");
?>
:</b> <?php
echo $CURUSER["email"];
?>
<br />
<b><?php
echo T_("JOINED");
?>
:</b> <?php
echo utc_to_tz($CURUSER["added"]);
?>
<br />
<b><?php
echo T_("AGE");
?>
:</b> <?php
echo $CURUSER["age"];
?>
<br />
<b><?php
echo T_("GENDER");
?>
:</b> <?php
echo T_($CURUSER["gender"]);
?>
if ($page == 1) {
$browsemenu .= "";
} else {
$browsemenu .= "<a href='?{$q}&page=" . ($page - 1) . "'>[Prev]</a>";
}
$browsemenu .= " ";
if ($page == $pages) {
$browsemenu .= "";
} else {
$browsemenu .= "<a href='?{$q}&page=" . ($page + 1) . "'>[Next]</a>";
}
$offset = max(0, $page * $perpage - $perpage);
$res = SQL_Query_exec("SELECT users.*, groups.level FROM users INNER JOIN groups ON groups.group_id=users.class WHERE {$query} ORDER BY username LIMIT {$offset},{$perpage}");
print "<br /><table border='0' class='table_table' width='100%' cellpadding='3' cellspacing='3'><tr><th class='table_head'>" . T_("USERNAME") . "</th><th class='table_head'>" . T_("REGISTERED") . "</th><th class='table_head'>" . T_("LAST_ACCESS") . "</th><th class='table_head'>" . T_("CLASS") . "</th>\n";
while ($arr = mysql_fetch_assoc($res)) {
$cres = SQL_Query_exec("SELECT name,flagpic FROM countries WHERE id={$arr['country']}");
if ($carr = mysql_fetch_assoc($cres)) {
$country = "";
} else {
$country = "";
}
/* if ($arr['added'] == '0000-00-00 00:00:00')
$arr['added'] = '-';
if ($arr['last_access'] == '0000-00-00 00:00:00')
$arr['last_access'] = T_("NEVER");*/
print "<tr><td class='table_col1' align='left'><a href='../user/?id={$arr['id']}'><b>{$arr['username']}</b></a>" . ($arr["donated"] > 0 ? "<img src='{$site_config['SITEURL']}/images/star.png' border='0' alt='Donated' />" : "") . "</td>" . "<td align=\"center\" class='table_col2'>" . utc_to_tz($arr["added"]) . "</td><td align=\"center\" class='table_col1'>" . utc_to_tz($arr["last_access"]) . "</td>" . "<td class='table_col2' align='center'>" . T_($arr["level"]) . "</td>{$country}</tr>\n";
}
print '</table>';
print "<br /><p align='center'>{$pagemenu}<br />{$browsemenu}</p>";
end_frame();
stdfoot();
show_error_msg(T_("ERROR"), "No teams available, to create a group please contact <a href='staff.php'>staff</a>.", 1);
}
stdhead("Teams View");
begin_frame("Teams View");
echo '<center>Please <a href="staff.php">contact</a> a member of staff if you would like a new team creating</center><br />';
while ($row = mysql_fetch_assoc($res)) {
?>
<table border="0" cellspacing="0" cellpadding="3" width="100%" class="table_table">
<tr>
<th class="table_head" width="10%"></th>
<th class="table_head" width="90%">Owner: <?php
echo $row["username"] ? '<a href="account-details.php?id=' . $row["owner"] . '">' . htmlspecialchars($row["username"]) . '</a>' : "Unknown User";
?>
- Added: <?php
echo utc_to_tz($row["added"]);
?>
</th>
</tr>
<tr>
<td class="table_col1" width="10%"><img src="<?php
echo htmlspecialchars($row["image"]);
?>
" border="0" alt="<?php
echo htmlspecialchars($row["name"]);
?>
" title="<?php
echo htmlspecialchars($row["name"]);
?>
" /></td>
<td class="table_col2" width="90%" valign="top" align="left"><b>Name:</b><?php
<th class="table_head"><?php
echo T_("TYPE");
?>
</th>
</tr>
<?php
while ($arr = mysql_fetch_assoc($res)) {
if ($arr["warnedby"] == 0) {
$wusername = T_("SYSTEM");
} else {
$res2 = SQL_Query_exec("SELECT id,username FROM users WHERE id = " . $arr['warnedby'] . "");
$arr2 = mysql_fetch_assoc($res2);
$wusername = htmlspecialchars($arr2["username"]);
}
$arr['added'] = utc_to_tz($arr['added']);
$arr['expiry'] = utc_to_tz($arr['expiry']);
$addeddate = substr($arr['added'], 0, strpos($arr['added'], " "));
$expirydate = substr($arr['expiry'], 0, strpos($arr['expiry'], " "));
print "<tr><td class='table_col1' align='center'>{$addeddate}</td><td class='table_col2' align='center'>{$expirydate}</td><td class='table_col1'>" . format_comment($arr['reason']) . "</td><td class='table_col2' align='center'><a href='account-details.php?id=" . $arr2['id'] . "'>" . $wusername . "</a></td><td class='table_col1' align='center'>" . $arr['type'] . "</td></tr>\n";
}
echo "</table>\n";
} else {
echo T_("NO_WARNINGS");
}
print "<form method='post' action='admin-modtasks.php'>\n";
print "<input type='hidden' name='action' value='addwarning' />\n";
print "<input type='hidden' name='userid' value='{$id}' />\n";
echo "<br /><br /><center><table border='0'><tr><td align='right'><b>" . T_("REASON") . ":</b> </td><td align='left'><textarea cols='40' rows='5' name='reason'></textarea></td></tr>";
echo "<tr><td align='right'><b>" . T_("EXPIRE") . ":</b> </td><td align='left'><input type='text' size='4' name='expiry' />(days)</td></tr>";
echo "<tr><td align='right'><b>" . T_("TYPE") . ":</b> </td><td align='left'><input type='text' size='10' name='type' /></td></tr>";
echo "<tr><td colspan='2' align='center'><input type='submit' value='" . T_("ADD_WARNING") . "' /></td></tr></table></center></form>";
