Spam IP Database and delete button
<h3>The Background and Reason for the SPAM IP Database and Delete</h3>
<p>I actually wrote up half of this article and was still testing the function and lost the whole post, which will teach me for adding it straight into my cms... Anyway I'll write it up again.</p>
<p>So i still have been getting quite a bit of bot comment spam, even after a few other attempts to block this with google recapture, and other techniques, but they still manage to get through which is annoying.</p>
<p>So i had been taking the ip addresses from these spam comments and adding it to an array which i had to update each time i had a new one, so i had to go into the main file and add the new ip, then i had to go into the database and run a delete command for all of the comments matching an IP address.</p>
<p>I was doing this because i thought im not spending time writing a procedure to handle spam. well im sure i have wasted many hours on this now, so im going to make it easy for my self and write a function that you can list the comment and click a button where it will then add the IP address to a block list and also delete all the related spam from that IP.</p>
<p>Sounds easy now that im typing about it, and it is actually i have done the function and page in about an hour ish once i got into the groove. I love that coding groove, but its hard to get into sometimes.</p>
<p>Anyway this is what i did. Some of the code links to other bits in the CMS so this example code probably wont work for you out of the box.</p>
<h3>New Spam Block Class</h3>
<p>Create a new class extend for the block list to live in.</p>
<h4>PHP</h4>
<pre><code class="php hljs">class ipblock extends core {
public $classextend = true; // this must be set to true! :)
public $addtomenu = false;
public $addsectionbutton = true; // add this class to the section menu
public $addtoadminmenu = false; // add this class to the main admin menu
public $nicename = "IPBlock";
public $nicedescription = "Blocked IP Addresses - If you made it here you should not see this...";
public $dbtablename = "ipblock";
public $imagesenabled = false;
public $loadarray = [
"id",
"uid",
"insdate",
"title",
"additional",
"category",
"ip",
];
}</code></pre>
<p>Load the ips and block them once they are added to this new class and database.</p>
<h4>PHP</h4>
<pre><code class="php hljs">//Load the IP Blocked List
$ipblockarray = $ipblock->listdistinct(
"ip",
0,
5000,
"ip",
"DESC"
);
foreach ($ipblockarray as $ipblockval) {
if($SERVER['REMOTEADDR'] == $ipblockval) {
echo "no spam thx";
return false;
}
}</code></pre>
<p>Change the template for the comments admin list and add a delete button</p>
<h4>HTML</h4>
<pre><code class="html hljs xml"><a href='/block-delete/comments/[@userip]/' class='btn btn-danger'>Block + Delete [@userip]</a></code></pre>
<p>Create a new block-delete page to handle the blocks and delete functions. this will also check that the ip should be blocked and deleted before proceeding and then allow the user to go back to the comments list if there is any more spam to be blocked or deleted. </p>
<h4>PHP</h4>
<pre><code class="php hljs">$alerttemplate = new template("alert.html");<br />$alerttemplate->set("alerttype", "danger");<br />$alerttemplate->set("content", "This will delete all $p2 from IP $p3 and block it. Are you sure?");<br />$alerthtml = $alerttemplate->output();<br />$pagecontent .= $alerthtml;<br />$pagecontent .= "<p><a href='/$p1/$p2/$p3/confirm/' class='btn btn-danger'>Yes Delete and Block</a></p>";<br />if($p4 == "confirm") {<br /> $ipblock->title = $p3;<br /> $ipblock->ip = $p3;<br /> $ipblock->add();<br /> $p2safe = $comments->db->escapeString($p2);<br /> $p3safe = $comments->db->escapeString($p3);<br /> $sql = "delete from $p2safe where userip = '$p3safe' ";<br /> $result = $comments->db->query($sql);<br /> $alerttemplate = new template("alert.html");<br /> $alerttemplate->set("alerttype", "success");<br /> $alerttemplate->set("content", "Blocked and Deleted. <a href='/list/$p2/' class='btn btn-primary'>Back to $p2 List</a>");<br /> $alerthtml = $alerttemplate->output();<br /> $pagecontent .= $alert_html;<br />}</code></pre>
<p>And done. This was actually easier than i thought for some reason i had been putting it off. </p>
<p>Here is a graphical flow of the process.</p>
<p><img src="https://i.imgur.com/nodvY1w.png" /></p>
<p>Click Block + Delete</p>
<p><img src="https://i.imgur.com/aQ1PHo3.png" /></p>
<p>Click on Confirm or the Yes Delete and Block and onto the next step, running the delete function and blocking the IP.</p>
<p><img src="https://i.imgur.com/6rULmsm.png" /></p>
<p>Ok all should be deleted and blocked, check the IP is in the ipblock db.</p>
<p><img src="https://i.imgur.com/eW9b8y2.png" /></p>
View Statistics
Add Comment
Other Items in php functions
Related Search Terms
Other Categories in Code
