Remove WordPress SEO columns from post table

The WordPress SEO plugin by Yoast is very popular, and for a good reason. It uses solid methodology, and is easy enough for folks to use who may not have a solid background in SEO.

That being said, there is a *lot* of data to be displayed. On the post editor, it’s not a big deal, as it’s contained in a metabox and can be minimized easily. But on the post table, it can crowd out other information, especially if you have other data being displayed in the post column. Below is a function that will remove the columns from the post table.

This same function can be used on any post type, including pages and other custom post types. Simply change the manage_edit-post_columns to manage_edit-YOUR_POST_TYPE_columns

That’s it. The great thing about this function is that you can use it to remove other columns as well, for example the author column (if you’re the only writer on the site).

*UPDATE*  You can also uncheck the boxes on the post table under the ‘screen options’ tab. This will only apply to the current user, however.

Remove Shortcut Arrows from Desktop Icons in Windows

In all versions of Windows, whenever you place a shortcut on the desktop, it will overlay an arrow in the bottom left-hand corner as a visual sign that it’s a shortcut. If you don’t care to have that arrow, you can remove it in a couple of different ways. In this article, I’ll talk about a registry hack and also about a freeware utility that gets the job done.

Registry hack is the quickest and easiest way to get rid of the arrows without having to install any third-party programs. It works on Windows Vista, Windows 7 and Windows 8 without any issue. You do have to be a little comfortable using the registry, but it’s really straightforward.

Click on Start and type in regedit in the search box. On Windows 8, go to the Start Screen and starting typing regedit.

image001

Now navigate to the following key:

HKEY_LOCAL_MACHINE – SOFTWARE – Microsoft – Windows – CurrentVersion – Explorer – Shell Icons

Note that you may not have the Shell Icons key under Explorer by default. If it’s not there, right-click on Explorer in the left-hand pane and choose NewKey.key-registry-key

A new key will appear in the left-hand menu and you’ll have to give it a name. Now type in Shell Icons with the capitalization shown in the screenshot above. Then click on Shell Icons in the left pane and you’ll see just a key named Default in the right-hand pane. Right-click on any white area in the right-pane and choose NewString Value.

new-string-value

Change the name to the number 29 and press Enter. Then double-click on the entry to bring up the key editor. In theValue Data field, go ahead and copy and paste the following:

%windir%\System32\shell32.dll,-50 

add-new-key

Click OK and close out the registry editor. Now just log off and log back in or restart your computer and the arrows should be gone from your desktop icons if done correctly. This will also work on 32 or 64-bit versions of Windows.

How to Enable MOD_REWRITE in Ubuntu

A little note first: This is the most basic way to enable mod_rewrite. However, it’s not the best way. The more correct way would be to setup a vhost and change its config, but unless you are a professional and know exactly what you do this thing will do the job perfectly.

Please note that Ubuntu 14.04 LTS comes with Apache 2.4, while Ubuntu 12.04 LTS came with Apache 2.2. This new version introduced different default config filenames and in general some differences.

Activate the mod_rewrite module with

and restart the apache

To use mod_rewrite from within .htaccess files (which is a very common use case), edit the default VirtualHost with

Search for “DocumentRoot /var/www/html” and add the following lines directly below:

Save and exit the nano editor via CTRL-X, “y” and ENTER.

Restart the server again:

Voila! To check if mod_rewrite is installed correctly, check your phpinfo() output.

Metro Theme For phpMyAdmin

phpMyAdmin supports themes since version 2.6.0. All themes are not compatible with all phpMyAdmin versions. You should upgrade your phpMyAdmin to use Metro themes with it.

Modified Theme : Download the Customized Metro Theme

Modified From : http://hplhu.deviantart.com/art/Metro-Theme-v3-for-phpMyAdmin-4-382030120

  • This is a minimalist, clean theme for phpMyAdmin 4, inspired by Windows 8 app design.
  • Tested under Firefox 22, Chrome 27, Safari 5.1.7, Opera 12.12 and Internet Explorer 9 & 10.
  • Using this theme under any earlier version of browsers listed above may cause erroneous appearance. Such browsers like Internet Explorer 6, 7 and 8 are definitely not recommended for this theme.

Installation :

  • Download the customized metro theme
  • Extract and move the extracted folder to /usr/share/phpmyadmin/themes/
  • Change permission sudo chmod -R 0777 /usr/share/phpmyadmin/themes/metro/
  • Now access the phpMyAdmin webpage
  • Change the Theme to Metro.
  • Enjoy

Customization :

  • Change my-pic.png in the ‘img’ folder
  • For any css customization browse css/common.css.php

Happy Coding. Enjoy 🙂

Split WordPress Post to Multiple Pages

All bloggers usually come across long blog posts to be published in their blogs. It’s good that you are giving detailed information on topic with your huge blog post. But have you ever thought what impression it makes on your visitors? Don’t make your visitors scared by showing them a long post in a single page, they may end up reading your post just once they scroll through out the length of your post. I have got a better solution for you, just think of split wordpress post into multiple pages.

How to achieve ?

To split wordpress post simply go to new post, put your WHOLE content in editor now ‘SWITCH TO HTML EDITOR’ and paste  <!–nextpage–>  from where you want your content to be shown in next page.

 

Compatibility Issue with themes

Sometimes pagination is successful but the navigation section does not appear. In other words, your page gets split but you don’t find any link to access them. This is because your present theme is unable to handle the tag for splitting the page. Its a small problem and can be fixed easily. Insert the following line to the theme’s template file.

Often the template file is called single.php. However some themes might not have a separate file for individual posts, and might utilize index.php itself. In this case you will need to edit this file.

 

 

WordPress Nested meta_query Using Multiple Relation OR & AND

WP_Meta_Query is a class defined in wp-includes/meta.php that generates the necessary SQL for meta-related queries. It greatly improved the possibility to query posts by custom fields. In the WP core, it’s used in the WP_Query and WP_User_Query classes.

meta_query is used by WP_Query while we have a situation like we have to search for something that is not native by wordpress and was added by custom code known as custom field.

So, when we have a simple search that contains only one meta key to search through the thing is quite easy like below,

After that we got a condition that we have to search through different meta keys having one single value, there comes the role of “meta_query”. For that we have a code as follows,

Finally we got a situation where we have multiple meta_key with more than one conditions. Suppose I am searching a lawyer with his Area of Law and location, and also location is divided in to three parts i.e. city, state and zip. Here I have to select one of the three meta keys like “city”, “state” & “zip” and also I have to compare it with “Area of Law”. Here is the situation where native functionality of WordPress fails to integrate the functionality. So by googling so much I found the following solution that uses both relation keys i.e. OR & AND in single meta_query. Here is the example,

While some say it works and some denies, in my case this query failed completely. In my case I used an array of keys for “key” and compared it with a sting value inserted for the “value”. But whatever I did, totally violets the rule for meta_query as type of key should be a string while I am putting an array. It only gave me a warning that invalid argument for “trim()” as I was providing an array instead of string. Otherwise it created the exact result that was expected. Here is the query,

More exact solution is much appreciated.

Convert Sublime Text Editor to Licensed Version

Cracking guide for Sublime Text 3 Build 3059 / 3065 ( Mac / Win x86_64 / Windows x86 / Linux x64 / Linux x86 )

MacOS

Build 3059

MD5: 59bab8f71f8c096cd3f72cd73851515d

Rename it to: Sublime Text

Make it executable with: chmod u+x Sublime\ Text

Replace it with: Sublime Text.app => Contents => MacOS => "Sublime Text"

You don’t need to use license.

DONE

Build 3065

Download from here:

https://db.tt/UkPLsKrd

or:

http://cl.ly/XJUe/Sublime%20Text%20mac%203065%20cracked%20build%203065

Windows x64

Build 3059

MD5: 6ddaa1fb63c6d7d4eae9ec39f1fa5d76

Rename it to: sublime_text.exe

Replace it with the one in your installation folder: e.g. [Installation Folder]/sublime_text.exe

You don’t need to use license.

DONE

Build 3065

Download from here:

https://db.tt/rviitEyS

or:

http://cl.ly/2b2b171Z3J1C/sublime_text%20cracked%20win64%20build%203065.exe

Windows x86

Build 3059

MD5: 8569b2cfa26677d72f322c8358f349c0

Rename it to: sublime_text.exe

Replace it with the one in your installation folder: e.g. [Installation Folder]/sublime_text.exe

You will paste a license key for this something like:

or write your own key.

DONE

Build 3065

Download from here:

https://db.tt/1lnRdzW3

or:

http://cl.ly/1w2G0t3P133x/sublime_text%20cracked%20×86%20build%203065.exe

Linux x64

Build 3059

MD5: 552726c06917c711f9950e2eda6c928f

Rename it to: sublime_text

Make it executable with: chmod u+x sublime_text

Replace it with the one in your installation folder: e.g. [Installation Folder]/sublime_text

You don’t need to use license.

DONE

Build 3065

Download from here:

https://db.tt/zBKKF6Ba

or:

http://cl.ly/1z0S25150Y0I/sublime_text%20crack%20linux%2064%20build%203065

Linux x86

MD5: 98dbbcf51e7768f973f0afaf4424cfef

Rename it to: sublime_text

Make it executable with: chmod u+x sublime_text

Replace it with the one in your installation folder: e.g. [Installation Folder]/sublime_text

You don’t need to use license.

DONE

Sublime Text License Keys

Sublime Text 2.x (for all Builds)

Sublime Text 3.x (before Build 309X)

Sublime Text 3.x (after Build 309X)

*** Do make sure there is not any additional string before “—– BEGIN LICENSE —–” and after “—— END LICENSE ——“, including any space or carriage return character.

Reference One

Reference Two

Don’t forget to buy sublime text 🙂

Make Checkboxes Act Like Radio Buttons Using jQuery

This tutorial shows you how to make Check boxes act like radio buttons, this really need when the designer designed a quiz page with check boxes instead of radio buttons and the client wants only in that way. Sad isn’t it?

But don’t worry here is the solution for that,
jQuery Part:

Importing Excel files into MySQL with PHP

If you have Excel files that need to be imported to MySQL using PHP, here are the steps. You need only the class file of PHPExcelReader to read the excel file, rest of the things you can do using simple functionalists of PHP. The PHPExcelReader class file is attached to the end of this document.

After including the class file to the required PHP file where the upload script will be written, you only need to initiate the class , set a upload folder and call the required function, that’s it.

Then simply initiate the class,

$data = new Spreadsheet_Excel_Reader();

Rest of the script you can get from the attached document. Importing Excel files into MySQL with PHP is a easy task. Click here to download the whole script. Happy Coding… 🙂

Simple Image Scroll Using Javascript Marquee

Simple image scroll using javascript marquee, only with the help of jQuery and marquee.js. Only need to add the javascripts and the scrolling div. This script will only output a div with a number of images scrolling inside it. You can add more functionality to it later as per your need.

Then you need to add the css for image container and the images,

That’s it. You have integrated your scroll. You can download the attached zip file which contains the html and js files here.