I wasn’t sure if you meant users or commentators, so I took both. SQL The email is saved in $wpdb->comments in the column comment_author_email for comments. It is saved in $wpdb->users in the column user_email for users. To get the domain part from the email in comments, we can use: SELECT ( SUBSTR( `comment_author_email`, INSTR( … Read more
You could hook intop pre_comment_on_post: add_action( ‘pre_comment_on_post’, function(){ if ( empty ( $_SERVER[‘HTTP_REFERER’] ) ) exit; }); But … be aware, not all requests without an referer are actually spam posts. Some firewalls and proxies strip this field. And most automated spam comes with a Referer field filled with the name of the spammed domain. … Read more
You can use this SQL query to approve all spam comments: UPDATE wp_comments SET comment_approved = 1 WHERE comment_approved = ‘spam’;
You should be able to back up your site through your hosting control panel. This is a better option than adding bloat to your WP install to duplicate functionality you already have elsewhere.
Did you try a search from the Posts (Admin) screen? (And also the Pages (Admin) screen? And sometimes a googles of your site might find it: use something like search-term site:example.com …depends on how current the googles are for your site. But sometimes works well. Added To answer your question/comment: Remember that there is no … Read more
Thank you so much for your reply. It helped me figure out what’s going on. I get a far bit of spam submissions via my contact form, these spam submissions include URLs. Although they are being flagged as spam and filtered out, WordPress still creates an oembed_cache entry in the database for them. I have … Read more
If you had posts and pages live before you made that change above you will have to go to those pages and turn off pings and comments as well. Go to the Page list and in the backend, select all your pages (checkbox) and then under “Bulk Actions” choose edit. Under the Comments dropdown set … Read more
Anything that is found in the publicly accessible HTML of a website or page can be indexed by Search Engines, or spam bots. If you don’t want a spam bot finding something, don’t put it on a public page.
Of course this is possible it would just require some custom coding. This is an open ended question so I’ll give you an open ended answer of how I may go about this. Add phone number field to user contact Use the profile_update hook to store a random code associated with that number Create a … Read more
I think there are two decent options here. Let WordPress keep its mail function, but hook in once or twice wp_mail() has several hooks that will be helpful for you to replace the built in behavior, which is basically to use php’s simple little mailer. Here are a couple of those helpful hooks that I … Read more