Tuesday, November 8, 2016

WordPress Interactive SVG Map

This WordPress Plugin is based on Github JQV MAP.

URL: https://github.com/manifestinteractive/jqvmap

Many times we need map in SVG format as Google map does not fit for every requirement. We can have more control on SVG map than Google map. using this plugin you can create map with options as you wish.

You just need to place a shortcode for the plugin on any post or page and the map is loaded on that particular page or post.

Features of the plugin are as follows:

  • Map is displayed in SVG format. 
  • Options to configure Map from the admin section.
  • Options to customize the map output on front-end.
  • The following Maps are available supported by the plugin.
    •   World Map
    •   USA
    •   Europe
    •   Germany
    •   Africa
    •   Asia
    •   Australia
    •   Argentina
    •   Algeria
    •   Brazil
    •   Canada
    •   France
    •   Greece
    •   Iran
    •   Iraq
    •   North America
    •   Russia
    •   South America
    •   Tunisia
    •   Turkey
You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/interactive-svg-map/

WordPress Hide Administrator Bar

This plugin allows the administrator of the website to hide the administrator bar on the front-end. This can be done for all users including administrator himself.

Features of the plugin are as follows:

  • Plugin Option to Hide Admin Bar for all Users in Frontend.
  • Plugin Option to Hide Admin Bar for Non Admin users in Frontend.
  • Plugin Option to Hide Admin Bar for Admin users in Frontend.
  • Plugin option settings to configure to which user will the administrator bar will be visible.

You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/hide-administrator-bar/

WordPress Forbidden Author Words

When managing a multi-author blog there are users who have the rights to post blog post content on the website. Not every time it is possible to check the entire content. So, to avoid misuse of some offensive words or words which may not be quite right for your website can be restricted using this plugin.

Features of the plugin are as follows:

  • Add words in the plugin option that are to be restricted.
  • User can set the option to restrict the word in post title, content or both.
  • user can set the option to display the "Restricted words" as a notice in the entire Admin section and it can be activated or deactivated from Admin.

You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/forbidden-author-words/

WordPress Empty Categories In Widgets

WordPress had a options to show categories list with post count as a widget in sidebar. But empty categories are excluded and only categories which have at-least one post assigned are shown.

Some times we need to show empty categories also in the sidebar. For this we can use this plugin.

Features of the plugin are as follows:

  • Shows Empty Categories In Sidebar as a Widget.


You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/empty-categories-in-widgets/

WordPress Disable Plugin Deactivation

This plugin provides options to disable plugin deactivation, activation, deletion, and update. Many times when working on a project we need to create multiple accounts with administrator rights.

So in many of the cases other users with administrator rights can mess with the plugin settings by activating, deactivating, updating, deleting plugins. To avoid such a mess and scenario this plugin can be used.

Features of the plugin are as follows:

  • Disable plugin activation from the plugin screen in the Admin section.
  • Disable plugin deactivation from the plugin screen in the Admin section.
  • Disable plugin update option from the plugin screen in the Admin section.
  • Disable plugin delete option from the plugin screen in the Admin section.
  • Disable plugin edit link from the plugin screen in the Admin section.


You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/disable-plugin-deactivation/

WordPress Disable Lost Password Email

Many times in WordPress spam users tries to reset password by clicking on the "forget password" link which sends a email to the email address of the user with the reset link. Doing it many times sends multiple emails and may blacklist the domain as spam email domain by the hosting companies and email service providers.

To avoid this many times we need to disable any email sending. To achieve this we can use this plugin. This plugin disables forgot password email for all the users including administrator of the website.

Features of the plugin are as follows:

  • It Disables lost email functionality for all users including the administrator.


You can download and install this plugin at WordPress plugin repository

URL: https://wordpress.org/plugins/disable-lost-password-email/

WordPress Bulk Edit Post Titles

Sometimes we need to edit multiple post titles at same time to give same titles. This feature is not provided by WordPress till now. To overcome this drawback there you can use this plugin which add this functionality.

Features of this plugin:

  • Bulk edit post titles at once.
  • User can select any number of posts.
  • This plugin can work with single as well as multiple post titles.


You can download this plugin at https://wordpress.org/plugins/bulk-edit-post-titles/

WordPress BuddyPress Registration Widget

Want to add BuddyPress Registration Widget in sidebar? You can use this plugin.

Using this plugin you can "Display BuddyPress Registration form as a Widget".

This plugin provides BuddyPress registration form as a widget.

Features of this plugin are as follows:

  • BuddyPress registration form as a widget in sidebar.
  • Disable BuddyPress cover image for all users.
  • Make Profile image mandatory excluding super Admin.


You can download this plugin at https://wordpress.org/plugins/buddy-registration-widget/

WordPress Automatically Empty Trash

This plugin can be used to Automatically Empty Trash after the n number of days the user wishes.

Using this plugin the user can set the number of days from which the trash should be automatically deleted in the plugin option from the Admin plugin section.

Features of the plugin are as follows:

  • Option to set number of days after which the trash should be automatically emptied.


This Plugin can be downloaded at  https://wordpress.org/plugins/automatically-empty-trash/

Tuesday, September 27, 2016

Delete all tables from database using command line

We can drop all tables of a database using an GUI Interface like PHPMYADMIN. But sometimes in some scenarios we do not have access to the GUI Interface like PHPMYADMIN but only tool like command line or command prompt.

In Such scenarios we can drop all the tables of a specific database using the command line. Following are the statements which can be used on the command line to drop all the database tables from the database with ease.

SET FOREIGN_KEY_CHECKS = 0; 

SET @tables = NULL;
SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables
  FROM information_schema.tables 
  WHERE table_schema = 'database_name'; -- specify DB name here.

SET @tables = CONCAT('DROP TABLE ', @tables);
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET FOREIGN_KEY_CHECKS = 1;

That's it all tables from the database will be deleted.

MS SQL : How to identify fragmentation in your indexes?

Almost all of us know what fragmentation in SQL indexes are and how it can affect the performance. For those who are new Index fragmentation...