The original spam.php doesn't work good
this one works better
admin/spam.php
PHP Code:
<?php
$rootpath = '../';
require_once ( $rootpath."include/bittorrent.php" ) ;
ADMIN::check();
//optimized, secured, added options, fixed some typos by Alex2005 for TBDEV.NET\\
if (get_user_class() < UC_SYSOP)
stderr("Error", "Permission denied.");
$postperpage = 0+$_GET["postperpage"];
$returnto = $_POST["returnto"];
if(isset($_POST["delmp"])) {
$do="DELETE FROM messages WHERE id IN (" . implode(", ", $_POST['delmp']) . ")";
$res=mysql_query($do);
if ($returnto) {
header("Location: ".htmlspecialchars($returnto));
die;
}else{
header ("Refresh: 2; url=/admin/spam.php");
stderr("Success" , "The messages where successfully deleted!");
}
}
//===start page===//
stdhead("Administrative message overview"); ?>
<script language="Javascript" type="text/javascript">
<!-- Begin
var checkflag = "false";
var marked_row = new Array;
function check(field) {
if (checkflag == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;}
checkflag = "true";
}else {
for (i = 0; i < field.length; i++) {
field[i].checked = false; }
checkflag = "false";
}
}
// End -->
</script>
<?
//===START*PAGER===//
$res2 = mysql_query("SELECT COUNT(*) FROM messages $where");
$row = mysql_fetch_array($res2);
$count = $row[0];
if ($postperpage != 0)
$perpage = $postperpage;
else
$perpage = 10;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, $_SERVER["PHP_SELF"] ."?postperpage=$perpage&" );
echo $pagertop;
//===END*PAGER===//
//===Message*amount*selector===//
//query optimized by Alex2005 for TBDEV.NET\\
$res = mysql_query("SELECT msg.receiver, msg.subject, msg.sender, msg.unread, msg.msg, msg.added, msg.id, u1.username AS u1_username, u2.username AS u2_username FROM messages AS msg LEFT JOIN users AS u1 ON u1.id=msg.receiver LEFT JOIN users AS u2 ON u2.id=msg.sender ORDER BY msg.id DESC $limit") or sqlerr(__FILE__, __LINE__);
begin_main_frame("Administrative message overview");
print("<table border=1 cellspacing=0 cellpadding=5>\n");
//===select how many
print("<tr>");
print("<form method=\"GET\" action=\"/admin/spam.php?\">");
//print("<input type=\"hidden\" name=\"postperpage\" value=\"postperpage\">\n");
print("<td class=\"colhead\" colspan=\"3\" align=\"left\"><b>How many messages to show per site: </b><select name=\"postperpage\">\n");
print("<option value=$postperpage>$postperpage</option>\n");
print("<option value=10>10</option>\n"); //==Set*to*value*you*need===//
print("<option value=25>25</option>\n"); //==Set*to*value*you*need===//
print("<option value=50>50</option>\n"); //==Set*to*value*you*need===//
print("<option value=150>150</option>\n"); //==Set*to*value*you*need===//
print("<option value=300>300</option>\n"); //==Set*to*value*you*need===//
print("<option value=500>500</option>\n"); //==Set*to*value*you*need===//
print("<option value=1000>1000</option>\n"); //==Set*to*value*you*need===//
print("<option value=1500>1500</option>\n"); //==Set*to*value*you*need===//
print("<input type=\"submit\" value=\"Set to it!\" /></td><td class=\"colhead\" colspan=\"2\">Times are in GMT.</td></form></tr>");
print("<form method=\"post\" name=\"form\" action=\"/admin/spam.php\">");
print("<input type=\"hidden\" name=\"returnto\" value=\"/admin/spam.php?postperpage=$perpage&page=\">\n");
print("<tr><td class=\"colhead\" align=\"left\" width='1%'>Info</td>".
"<td class=\"colhead\" align='left' width='1%'>Subject</td>".
"<td class=\"colhead\" align=\"left\">Text</td><td class=\"colhead\" align=\"left\" width='1%'>Date</td><td class=\"colhead\" width='1%'>Del</td></tr>\n");
while ($arr = mysql_fetch_assoc($res))
{
$receiver = "<a href=userdetails.php?id=" . $arr["receiver"] . "><b>" . $arr["u1_username"] . "</b></a>";
if($arr["sender"] != 0)
$sender = "<a href=userdetails.php?id=" . $arr["sender"] . "><b>" . $arr["u2_username"] . "</b></a>";
else
$sender = "<font color=red><b>System</b></font>";
$msg = format_comment($arr["msg"]);
//if you have timezone mod, uncomment this code an comment the next one
//$added = display_date_time($arr["added"]);
$added = $arr["added"];
print("<tr><td align=\"left\"><b>Sender:</b> $sender<br><b>Reciever:</b> $receiver<br><b>Read</b> ".($arr["unread"] != "yes" ? "<b><font color=lightgreen>Yes</font></b>" : "<b><font color=red>No</font></b>")."</td>".
"<td align=left>".format_comment($arr['subject'])."</td>".
"<td align=left>$msg</td><td align=left>$added</td><td align=center><input type=\"checkbox\" name=\"delmp[]\" title=\"Mark\" value=\"" . $arr['id'] . "\" /></td></tr>\n");
}
print("<td colspan=\"4\" align=\"right\" class=\"colhead\">Mark all Messages </td><td width=\"2%\" class=\"colhead\">");
?>
<input type=checkbox title='Mark All' value='Mark All' onclick="this.value=check(document.form.elements);">
<?
print("</td></tr>");
print("<tr><td colspan=\"5\" align=\"center\"><input type=\"submit\" value=\"Delete selected messages!\" /></td></tr></form>");
end_main_frame();
print($pagerbottom);
print("</table>");
stdfoot();
//===end page//
?>