hey all:<\/p>\n
its what i call, um “dynamically manual” ; )<\/p>\n
on my index page (http:\/\/www.latinosfortexas.com) i have a script to show the last 8 posts, and last 8 comments from the blog.<\/p>\n
of course in the last 24 hours “poker” seems to have been reaaaaal popular. so i simply added an include on my index page:<\/p>\n
which points to a pretty straightforward php page to simply delete comments which include the word “poker”.<\/p>\n i know, a little brute force but works well. i think i ll make a table of spamwords and loop thru them, but for now, tho its not stopped the poker spam, it HAS stopped it from being seen by deleting it.<\/p>\n just sharing,include("spamdeleteauto.php");<\/code><\/p>\n
\n<?php<br \/>
\ninclude("dbaseinfo.inc.php");
\nmysql_connect($hostname,$username,$password);
\n@mysql_select_db($database) or die( "Unable to select database");
\n\t$query = "DELETE FROM <\/code>wp_comments WHERE <\/code>comment_content LIKE '%poker%'";
\n\t$result=mysql_query($query);
\nmysql_close()
\n?>
\n<\/code><\/p>\n
\nm<\/p>\n","protected":false},"template":"","class_list":["post-187530","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/187530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/187530\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=187530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}