Tag Archives: Spam

How To Clean Unnecessary Tables From MySQL Database?

Cleaning unnecessary database tables means deleting tables that were created before by some plugin and now are not in use on your website. Removing such tables lightens up your MySQL database. In this lesson, you will learn about cleaning up a database manually and with plugins’ help.

Before making any changes, always ensure and be careful when deleting database tables, as removing the wrong ones can break your WordPress site. Always keep a full WordPress database backup.

Step-1, access your hosting’s cPanel and locate the phpMyAdmin option under the Databases section. Click on it to access the database management interface.

Step-2 In phpMyAdmin, find your WordPress database on the left-hand side panel. Click on the name of the database to view the tables it contains.

Step-3 Now identify unnecessary tables. Unnecessary tables might come from uninstalled plugins or themes. Tables that don’t seem to match the standard WordPress table names like wp_posts, wp_users, or wp_options may be safe to delete. Some tables have a prefix based on the name of a plugin (e.g., wp_woocommerce_* for WooCommerce).

Step-4 Once you identify the tables you no longer need, select them by checking the box next to each table. Then, scroll down and choose Drop from the options in the dropdown menu. Confirm the deletion.

Automatically Identify & Clean MySQL Database Tables

Alternatively, You can clean your database with a plugin. Plugins such as WP-Optimize or Advanced Database Cleaner let you automatically identify and clean up unnecessary tables without manually going into phpMyAdmin.

These WordPress plugins provide you with an easy way to clean up unnecessary database tables from your WordPress site.

How To Disable WordPress Comments By Referers?

You can disable your website comments by referers which means you can ban visitors from some websites from viewing or adding comments to your website’s posts, pages etc.

How to disable comments by referer?

Disable Comments By Referer is the new WordPress plugin that lets you selectively disable comments for visitors coming from certain websites (e.g. reddit).

Install and activate the plugin then follow the given steps:

  1. Upon activation visit your admin area Dashboard -> Settings -> Discussion page
  2. Scroll down to ‘Referer Blacklist for Comments’ section (added at the very bottom of the page).
  3. Type the a comma-separated bare hostnames, (ex: www.reddit.com, news.ycombinator.com.) in the given text area as shown in following given screenshot:

That’s all. Save your settings and you are done. How it works?

If a visitor’s HTTP referer matches to one of the hosts you’ve blacklisted then the your post will look like as comments have been disabled on your website, neither existing comments nor the new comment form is displayed.

How To Use JavaScript For Cloaking Email Addresses In WordPress ?

Now you can very easily enable JavaScript for cloaking email addresses present in your WordPress site content like posts, pages, CPTs and other shortcode supported areas including text and black studio widgets.

Continue reading How To Use JavaScript For Cloaking Email Addresses In WordPress ?

One Click Bulk Comment Management For WordPress

Bulk Comments Management is the new WordPress plugin that lets you (site administrators) delete and disable different comment types in just one click.

Continue reading One Click Bulk Comment Management For WordPress

Increase WordPress Security By Locking Down HTaccess, WP-Config.php, Hiding Readme.html & Other Files

With new WordPress plugin you can improve your websites security by disabling a few insecure features. You can automatically hide the readme.html file, license.txt file, set permissions for wp-config.php and .htaccess file so that hackers cannot modify them.

Continue reading Increase WordPress Security By Locking Down HTaccess, WP-Config.php, Hiding Readme.html & Other Files

Automatically Encode Mailto & Plain Email Address Links And Hide Them From Spambots In Your WordPress Site

You can easily encode mailto and plain email address links on your WordPress site and hide them from spambots. Email Encoder Bundle is a free WordPress plugin that plugin works directly when activated. Simply install and activate it, after activation visit your admin area Dashboard -> Settings -> Email Encoder Bundle plugin option page and check where you want options to take effect like you can enable it on all posts, comments and text widgets. You can set it to automatically encode both mailto and plain email addresses links, you can set class for mailto links and there are few more useful options.

Continue reading Automatically Encode Mailto & Plain Email Address Links And Hide Them From Spambots In Your WordPress Site

Trick Spambots By Enabling Real Dynamic JavaScript Encryption In Email Addresses Present Inside Your WordPress Site Content

Posting an email address inside your blog post increases the risk of directing spams towards email inbox. BetterAntiSpamBot is a free WordPress plugin that lets you post email address with better protection against spambots. The plugin encrypts email addresses with a dynamically generated JavaScript function.

Continue reading Trick Spambots By Enabling Real Dynamic JavaScript Encryption In Email Addresses Present Inside Your WordPress Site Content

Replacing WordPress Commenting System With Google+ Comments Hosted By Google

Google has already introduced Google+ comments for Blogger’s weblogs but now you can  have them for your WordPress site. From the day Google+ introduced its comments for Blogger.com, WP plugin developers started posting various hacks and plugins for adding the same feature to WordPress sites but most of the plugins in WordPress Plugins Repository that enables Google+ comments to WordPress are broken. But now there is a new plugin called Google+ Comments, it allows you to enable Google+ comments in your WordPress based website.

Continue reading Replacing WordPress Commenting System With Google+ Comments Hosted By Google

How To Bring Disqus Recent Comments Widget Back To WordPress Installations ?

Disqus is a popular global commenting system for weblogs which improves discussion by connecting conversations across the world wide web. Recently Discus Comment System for WordPress has dropped support for recent comments widget. This tutorial explains you how you can easily enable Discus recent comments widget in your WordPress site.

Continue reading How To Bring Disqus Recent Comments Widget Back To WordPress Installations ?

Quick And Easy Way To Disable Or Delete All Approved, Pending, Spam WordPress Comments & Pings In Just A Click

AI Disable Comments, new WordPress plugin provides you an easiest way to disable all approved, pending or spam comment & pings from your WordPress site in just one click. The plugin provides you a check box list where you can select what group (approved, pending, spam) of comments you like to delete. You can also disable comments & trackbacks from your your WordPress site.

Continue reading Quick And Easy Way To Disable Or Delete All Approved, Pending, Spam WordPress Comments & Pings In Just A Click

Automatically Add Spam IP To Comment Blacklist In WordPress

With new WordPress plugin called Comment Auto Blacklist automatically adds IPs of spam comments to comment blacklist settings field in your WordPress site.

Continue reading Automatically Add Spam IP To Comment Blacklist In WordPress

Easiest Way Of Blocking Visitors From Selected Countries Or Targeting Specific Countries For Traffic In WordPress

Although there are many WordPress plugins, hacks and other cPanel tricks that allows you to block visitors on some defined conditions. Here is an easiest way of blocking visitors from selected countries and it is the best method if you want to target traffic from a specific country or region.

Continue reading Easiest Way Of Blocking Visitors From Selected Countries Or Targeting Specific Countries For Traffic In WordPress

Some Of The Best Plugins That Boosts User Engagement Time And Page Views In WordPress

Here is a list of four selected WordPress plugins which you can use for boosting your website page views as they keep your visitors engaged with your content by showing them what they are looking for in your website.

Continue reading Some Of The Best Plugins That Boosts User Engagement Time And Page Views In WordPress

Now Use Tablet And Smartphone Style UnLock Slider For Fighting Spams In WordPress

Now a days smartphone and tablets provides you a slider for unlocking your device. You might have seen this feature in iPhone, Nokia N-Series, Sony Xperia and other popular brands; their smartphone automatically locks and to unlock it you need sliding your finger from left to right on the screen. Now you can use same kind of slider in your WordPress site for fighting spams in comments.

Continue reading Now Use Tablet And Smartphone Style UnLock Slider For Fighting Spams In WordPress

Conditional CAPTCHA For WordPress: Ask Commenters To Solve A Simple CAPTCHA If Akismet Thinks That Their Comment Is Spam

Akismet is a powerful plugin for detecting spams but sometimes it puts some good comments also in spam list. You can reduce this type of activity by making your WordPress site commenters to solve a simple CAPTCHA only if Akismet thinks that their comment is spam.

Continue reading Conditional CAPTCHA For WordPress: Ask Commenters To Solve A Simple CAPTCHA If Akismet Thinks That Their Comment Is Spam

Defeat Automated Spambot Comments That Gets Collected In WordPress Spams Folder

Akismet is best spam detector plugin but all comments made by spam bots end up in your WordPress Spams folder. This tutorial is about a light weight WordPress plugin that you can easily use with Akismet and increase a step for spambots when posting comments in your WordPress blog.

Continue reading Defeat Automated Spambot Comments That Gets Collected In WordPress Spams Folder

How To Delete All Pending Comments In Just One Click In WordPress ?

Spams and meaningless comments are common in all WordPress sites. Generally what actually happen is you approve right comments and ignore spams etc and in this way after some time you create a big collection of pending comments. Here is a quick and easy way to delete all pending comments from your WordPress site.

Continue reading How To Delete All Pending Comments In Just One Click In WordPress ?

How To Block Machine Generated Spams In WordPress Even Before They Get To Your Server ?

This is another powerful trick of stopping all machine generated spam comments much before they hit your web server. This can be dome by using a simple WordPress plugin called Cookies for Comments, the plugin sets a cookie on a random URL and that URL is checked everytime when a comment is posted on your website. In-case if the cookie is missing, it marks the comment as spam.

Continue reading How To Block Machine Generated Spams In WordPress Even Before They Get To Your Server ?

Defensio Anti-Spam For WordPress: An Alternative To Popular Akismet Plugin

All WordPress bloggers know about Akismet plugin that detects both manual and bot spammers posting comments on WordPress, also give you choice to set auto deletion of spam comments, there are its free feature; it also gives you some premium plans you can purchase from its site Akismet.Com. This article is about another plugin that also may become a good alternative of Akismet if you give it a try. We are discussing about Defensio Anti-Spam.

Continue reading Defensio Anti-Spam For WordPress: An Alternative To Popular Akismet Plugin