$query="select count(id) from spam";
$query2=mysql_query($query) or die(mysql_error());
$query3=mysql_fetch_array($query2);
$num = $query3[0];
$pagenum = $num / 50;
$pagecount = 0;
if ($currentpage == "") { $currentpage = "page1.php"; $display_start = 1; $display_end = 50;}
$currentpage = str_replace("page","",$subcat1);
$currentpage = str_replace(".php","",$currentpage);
if ($currentpage) { $display_start = ($currentpage * 50) - 50; $display_end = ($currentpage * 50); }
$nextpage = $currentpage + 1;
$previous = $currentpage -1;
echo " Navigation: Home Spamlist ";
while ($pagecount < $pagenum) {
$pagecount = $pagecount + 1;
echo "$pagecount ";
}
echo "
";
$query = "select sender,domain,id,complete,date,subject from spam where id <= '$display_end' and id >= '$display_start' and domain != 'bruning.com' and domain != 'clementrealestate.com' and domain != 'indemand.net' and domain != 'sportspool.com' and domain != 'carreck.com' and domain != 'spamalert.org' and domain != 'natools.com' order by sender asc";
$query2 = mysql_query($query) or die (mysql_error());
echo " ";
while ($query3 = mysql_fetch_array($query2)) {
$count = $count + 1;
$sender = $query3['sender'];
$id = $query3['id'];
$date = $query3['date'];
$subject = $query3['subject'];
$subject = str_replace("bruning","Spammer",$subject); $sender = str_replace("bruning","Spammer",$sender);
$subject = str_replace("carreck","Spammer",$subject); $sender = str_replace("carreck","Spammer",$sender);
$subject = str_replace("indemand","Spammer",$subject); $sender = str_replace("indemand","Spammer",$sender);
$subject = str_replace("avidshopper","Spammer",$subject); $sender = str_replace("avidshopper","Spammer",$sender);
$subject = str_replace("sportspool","Spammer",$subject); $sender = str_replace("sportspool","Spammer",$sender);
$subject = str_replace("spamalert","Spammer",$subject); $sender = str_replace("spamalert","Spammer",$sender);
$subject = str_replace("clementrealestate","Spammer",$subject); $sender = str_replace("clementrealestate","Spammer",$sender);
$subject = str_replace("marvinwood","Spammer",$subject); $sender = str_replace("marvinwood","Spammer",$sender);
$subject = str_replace("managemylistings","Spammer",$subject); $sender = str_replace("managemylistings","Spammer",$sender);
$subject = str_replace("canadadebt","Spammer",$subject); $sender = str_replace("canadadebt","Spammer",$sender);
$subject = str_replace("cecraig","Spammer",$subject); $sender = str_replace("cecraig","Spammer",$sender);
if ($sender) { echo "" . $sender . " - (" . $date . ") - " . $subject . "
"; }
} //end of while
echo " | ";
?>
|