WordPress Database – Run MySQL Search and Replace

Moving Wordpress

Once in a while, I need to move a WordPress installation from one server to another, or from root domain to a subdomain (for example – move WordPress from www.mywebsite.com to blog.mywebsite.com).

There are probably easier ways to do this, but sometimes I just like to take the hard way if it means it’s safer. The procedure is straightforward: you need to make sure you backup the database and the files, move them to the new location and replace every string in the database that contains the old address with the new address.

My process is pretty simple:

  • Download all of the files from the server through FTP.
  • Login to phpmyadmin and export the DB.
  • Upload the files to the new location.
  • Import the exported DB to the new phpmyadmin.
  • Find any traces of the old location in the DB and replace them with the new location.

How to Run a “Find and Replace” MySQL Query for WordPress’ Database

Basically we need to run the following queries for numerous tables:

  1. Postmeta
  2. Posts
  3. Options

And here are the queries:

UPDATE wp_options SET option_value = replace(option_value, 'http://the-old-domain.com', 'http://the-new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://the-old-domain.com','http://the-new-domain.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://the-old-domain.com', 'http://the-new-domain.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://the-old-domain.com', 'http://the-new-domain.com');

Copy 1 line at a time, paste in the phpmyadmin – > SQL box and click “Go”. Do this for all 4 queries.

MySQL - Find and Replace
MySQL – Find and Replace

Don’t forget to check out “Moving WordPress” and “Changing The Site URL” guides for more details about the process.

Good Luck!

How To Create a Clickable Map

How to create a clickable map

Have you ever wanted to include an interactive map on your website, but you just don’t know the technical stuff behind doing it? Even if you aren’t tech savvy- there is a way that you can create these maps- even custom maps- to include on your site. With MakeaClickableMap.com you can create beautiful clickable maps that will not only be clear and concise, but also interactive. Let’s learn how it works, and see if it is worth your while.

How To Make a Clickable Map

Step 1: First, you will want to go to www.makeaclickablemap.com. Once you get there, use the slider at the top of the page to choose a country. Then, a map of the country will instantly load, and will be ready for editing. The tool is so easy to use, because all of the editing tools are laid out for you, and clearly labeled. Please note: Not all the available maps are on the homepage. To get a full list, click the “Maps” on the menu. Another option is to click on the available country maps as shown here:

Step 2: Once you have your map loaded, you will then need to select the dimensions of your map. This is basically just the width and height of your map. This is something that you can adjust until you get it exactly where you want it, so don’t worry if your dimensions are a bit off at first. You can set only the width or height of the map, and the other variable will auto adjust, in order to keep the map’s proportions.

Step 3: Once you have the dimensions set, you will then need to adjust the font, colors and hover colors. This is really where you can customize it to be exactly what you want it to be- because it will ultimately determine how the map looks once you insert it into your site.

Step 4: The next option that you will need to choose is the background color. It is usually best to choose a color that will blend well with the color of your site’s background. This helps the map to look like it belongs on your site- rather than just an ordinary copy and paste map. Another option is to have a transparent background, that will blend with any background that’s behind the map.

Step 5: Next, you will set the “Region” settings, which allows you to set colors for various areas on the map, including hover colors.

Step 6: It is then time to set the Stroke color, type and width. This is basically the outline of the map, and you can customize it to either not show an outline at all, or to show a solid or dashed line.

Step 7: For the final three settings, you will want to decide whether you want to open links in a new window, show the names of the places on the map, or show small tips when the area is hovered over.

Step 8: When you complete these steps, you will be ready to finish up the map so that it will be ready for use. To do this, you will need to choose whether you want to get the map for free, or pay a small fee to give you options to edit it as many times as you’d like.

Step 9: Once you choose your selection, the IFRAME code for your map will appear. You can then copy and paste it into the code of your site, and it will automatically show your clickable map when people visit your site.

Is it Worth Your While?

For those that know how to do code on their own, this may not really be a necessary tool- although it does take away most of the leg work, and can free up some of your time. For those that don’t know the coding world, then this tool can actually be a lifesaver. The maps are very affordable, and if you just need a quick map of the United States that won’t require editing, you can use the tool for free! There really is nothing to lose. We recommend that you try it out, and see how it works. You might need to play around with it a few times until you understand how all of the features work.

Even the premium maps, such as the non-US maps, and other editable maps, only cost a small amount. For the convenience that this tool has to offer, we feel that it is well worth every penny spent to create a map! Give it a try today, and you are sure to find that it not only saves you time, but also helps you to have professional, concise maps that are ready in just minutes for your site.

Upcoming planned features are responsive maps, inactive areas and custom hover colors for each area.


Batch Geocode Addresses Using Bing Maps API and an Excel Worksheet

One of the projects that I’m working on nowadays, required me to batch geocode almost 8,000 addresses into latitude and longitude coordinates, and then display it on a Google map, using Google’s fusion table. All my data lives in an Excel worksheet. I’m not familiar with this world of geocoding, Google Maps API, etc. but I had to find a solution in order to make this process easy.

I thought about the idea of having a macro as part of my excel worksheet, that will connect to Google Maps / Bing maps and will pull data from my worksheet, geocode it using the API and will return the latitude and longitude coordinates.

While researching the web, I found out that someone already thought about it, and created a wonderful tool, based on an Excel worksheet and Bing Maps’ API. It’s called Excel Geocoding Tool.

How to batch geocode addresses with Bing Maps and Microsoft Excel

So the process is pretty simple:

  1. Download the Excel file from the Excel Geocoding Tool website.
  2. If the file is opened in “Protected View” (yellow bar on the top of the page), click “Enable Editing”.
  3. Enable Macros:
  4. Enable macros in Excel 2013 (Office 365): File -> Options -> on the left side, choose “Trust Center” -> click on “Trust Center Settings”.
  5. Enable macros in Excel 2007,2010: Click on the Office button -> “Excel Options” -> “Trust Center” -> Trust Center Settings” -> “Macro Settings”.
  6. Under “Macro Settings” choose “Enable all macros” and check the “Trust access to the VBA project object model”.
  7. When you’re done using the Excel Geocoding Tool, don’t forget to disable the macros.
  8. In order to use the tool, you need to create a Bing Maps API key.
  9. Once you get your key, copy and paste it in the “Bing Maps Key” field:
Batch Geocode Addresses Using Bing Maps API and Excel Worksheet
Paste your API key here

Now all you have to do, is navigate to the next sheet called “Geocode”, paste your addresses in the “location” column and click “Geocode all rows”, or “Geocode selected rows”:

Don’t forget that if you get the Bing Trial API key, you’re limited to 10,000 addresses in total. If you need more, just create another account (hotmail.com, outlook.com) and get another key.

How To Enable Google Analytics Demographics And Interest Reports In WordPress

How To Enable Google Analytics Demographics And Interest Reports In WordPress

If you’re running a WordPress blog, and have Google Analytics installed in order to track and analyze the traffic to your blog, you probably noticed that when you go to Google Analytics and click “Audience -> Demographics -> Age / Gender” it says that you need to validate tracking code after you have made this one-line, one-time update.

So I was trying to add this one line with my analytics plugin with no success. I also followed all of the instructions Google provides in order to make it happen.

Then, I tried to install a couple of different Google Analytics plugins for WordPress, even ones that declared they support demographics.

In the end, I succeeded in enabling it by playing around with the plugin’s code (Google Analytics for WordPress).

WordPress Demographics and Interest Reports support

Using this method, you can enable the demographics report on your WordPress blog. Please remember that since we’re going to change the plugin’s source code, every time you update the plugin, you’ll have to modify the code again, until some developer develops a decent analytics plugin to support demographics and interest reports.

Let’s begin:

1. Uninstall each and every analytics plugin from your blog.

2. Add this plugin to WordPress.

3. Activate the plugin, and go to “Settings -> Google Analytics”.

4. Authenticate the plugin with your Analytics account (just follow the instructions on the plugin’s settings page).

5. Using FTP software, go to “wp-content/plugins/google-analytics-for-wordpress/frontend/” and edit the file “class-frontend.php”.

6. Go to line 293, or search for ga.src.

7. Replace the following code:

ga.src = <!--?php if ( $this--->options['gajslocalhosting'] && !empty( $this->options['gajsurl'] ) ) {
echo "'" . $this->options['gajsurl'] . "';";
} else {
$script = 'ga.js';
if ( current_user_can( 'manage_options' ) && $this->options['debug'] )
$script = 'u/ga_debug.js';
echo "('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/" . $script . "'";

with the following code:

ga.src = <?php</pre>
if ( $this->options['gajslocalhosting'] && !empty( $this->options['gajsurl'] ) ) {
echo "'" . $this->options['gajsurl'] . "';";
} else {
$script = 'dc.js';
if ( current_user_can( 'manage_options' ) && $this->options['debug'] )
$script = 'u/ga_debug.js';
echo "('https:' == document.location.protocol ? 'https://' : 'http://') + 'stats.g.doubleclick.net/" . $script . "'";

8. If you have any cache plugin installed, clear the cache. Otherwise it won’t work.

9.Go back to Google Analytics -> Audience -> Demographics -> Age / Gender and click “Validate tracking code“.

10. If everything goes well, you should get this:

Google Analytics Demographics And Interest Reports In WordPress

What is Trello and How to Use Trello

Trello Example Board

Trello is currently being marketed as a collaboration tool that can help to organize various projects and make it easier to get things done on time. You can use it to organize your tasks, create checklists and search assignments- among other things- and the possibilities are virtually endless when it comes to using this website. It can be used in a variety of different ways.

If you are looking for a better way to keep yourself organized, then Trello really can help. It is not only fun to use, it is practical- and best of all it is free to download!

Trello Example Board
Trello Example Board

Using Trello for Project Collaboration

Trello was originally created as a project collaboration tool. It uses boards, checklists, cards, and various labels to assign tasks to members of your team, and you can also see what is in progress and who is working on what assignments. It is one of the easiest ways for you to handle the task management in your workplace, or in your home environment. It can help with both large and small collaborative projects.

Whether you are trying to set up a large project for a large number of freelancers that work remotely, or you are just trying to set up a chore list for the people in your household, Trello can help! If you haven’t already started using this great tool, then you don’t know what you are missing out on. Let’s go over some of the information about how it works, and how it can help you.

Add members to Trello
Add members to Trello

Understanding the Components of Trello

It is important to understand the three basic components that make up Trello. They include the boards, the lists and the cards.

Boards: Boards are actually used to help when it comes to managing large projects or campaigns. You use it board to build your project on the program. You may have a separate board for various projects that you have going on, to keep them separate and keep them on track. You can manage the board, and determine how small or how large you need it to be. It really is completely customizable, and it makes it easy for you to stay on track with your goals.

  • On the right of your board, you will notice that there are various different functions that you can choose from. You can add members, change settings, and filter.
  • You can also take a look at the activity feed within your board, just to see how much progress is being made, and by whom.

Lists: Lists are used along with the boards, and they separate and track the tasks into columns- based on categories. This helps you to see what is going on with the project, and how many tasks are required to finish the project. You can modify your lists as needed to make sure that you are on the right track with everything.

Move cards on Trello by dragging them from list to list
Move cards on Trello by dragging them from list to list

Cards: Cards are actually the components that fall under the lists. They are the individual tasks that are assigned to the lists within your boards. Each card is a task that is assigned to certain members of your team, and you can track progress on the cards as well. This is basically a small ‘checklist’ of sorts.

  • If you click on a particular card within your list, you will be able to see properties. You can also add due dates, team members, files, or checklists to the card.
  • You can also take a look at the progress on the card, if you take a look at the progress bar that is located on the bottom of the card.

Now that you have a better understanding of the basic components of Trello, are you ready to get started with it? This gives you a bit of a background on the program, but using it is something that you will actually learn best through first hand experience. Sure, you can watch tutorials and learn various tips and tricks, but many things you will actually be able to learn by simply playing around with the website.

Who Can Use Trello?

Trello can actually be used by both professionals and individuals. It helps to make it easier to manage time, and get things done. For people that procrastinate, this can actually be a life saving tool! Don’t let yourself get backed up with projects, or spend time trying to figure out how to effectively manage your projects! Instead, why not just give Trello a try? It has really started taking the world by storm, and many people are finding it to be a tool that they just can’t live without now that they have tried it and found it effective at helping with time and project management.

Trello Card
Trello Card
Trello iOS app
Trello iOS app

How to Use Trello

Using Trello is actually quite simple, at first glance. You can use it to make lists within lists, and you can drag and drop tasks, and it is really just a fun tool to use. While it appears really simple, there are various features that may make your experience with this tool a lot smoother. In fact, you can use certain features to help you when it comes to switching boards, editing cards, uploading attachments, and much more. There are also shortcuts that you can use to make it easier for you to get things done.

All in all, Trello seems to really be making a positive impact on the world. In a world where it seems like the days just get shorter and shorter, it makes sense that we would need to find a way to make things just a little bit easier. This is perhaps one of the main reasons why Trello was introduced- and definitely one of the main reasons why it has been such a hit!

Sign up to Trello

Facebook Plugin Breaks WordPress’ Pagination

Facebook WordPress Plugin Breaks Pagination

For one of the websites I created, XpatGirls.com, I installed Facebook’s official plugin for WordPress. It’s a nice plugin, that adds some “social” elements to your blog, instead of installing different plugins for different purposes, including:

  • Facebook’s Open Graph Protocol
  • Insights
  • Like, Send and follow buttons
  • Recommendation bar etc.

So, I installed the plugin on the website, like I do with almost every website that I build. A couple of weeks later, I found out that WordPress’ pagination was broken. Although the pagination appeared at the bottom of the blog, clicking on the page numbers / previous / next – would do nothing but navigate to the main page. So like everytime there’s a problem with WordPress, I started disabling themes and plugins, in order to isolate the problem, and then resolve it.

How to fix WordPress’ pagination problem caused by Facebook plugin

In the end, I found out that the Facebook plugin was the trouble maker.

To make a long story short, and to make your life easier, try adding the following piece of code to the end of the file functions.php (inside the theme’s folder). It solved my problem, and I hope it’ll solve yours.

function td_pagination_fix() {
 global $wp_query;
add_action( 'wp', 'td_pagination_fix', 111 );

I assume it only happens with specific themes, so if you encountered this issue, please mention your theme in the comments below.

Bluehost vs GoDaddy – Webhost Wars: Which Should You Choose?


These days, looking for the best web hosting company for your website / blog can be a nightmare. With thousands of companies offering web hosting services, it could be likened to finding a needle in a haystack. As a result, many become overwhelmed and end up making the wrong choice. And we all know that is a mistake you cannot afford to make. Thus, it is important to do some research, narrow down your choices, and make in-depth comparisons between and among these web hosting companies. Two of the names that make most shortlists are Bluehost and GoDaddy, and these are the two webhosting providers that we will be comparing in this article.

Bluehost and GoDaddy

In the world of web hosting, both Bluehost and GoDaddy are considered to be veterans. Bluehost was founded in 1996 and GoDaddy a year later, in 1997. With more than 15 years in the industry, it comes as no surprise that these companies now host millions of domains. Bluehost, with its sister companies FastDomain and HostMonster, hosts over 2 million domains all over the world. GoDaddy, on the other hand, is the fastest growing web host today, with more than 55 million domains under management as of 2013.

Clearly, these two hosting companies have a lot to offer. The question is: when it comes to shared hosting, which is the better choice? In order to answer that question, we have to take a deeper look at their differences and similarities, if any.

Hosting Packages and Prices

First, let us take a look at the hosting products or packages offered by both companies. Bluehost has always specialized in shared web hosting from the beginning, although it also started offering VPS and Dedicated Server hosting in 2013. GoDaddy on the other hand has established itself as a one-stop-shop, with a wide variety of products to varied users. Aside from basic shared web hosting, GoDaddy also offers advanced hosting options, such as VPS, dedicated servers, managed hosting, and even reseller hosting.

Bluehost offers two shared hosting packages: Basic and Pro. At $4.95 per month, Bluehost provides Basic users with UNLIMITED domains, storage, websites, and email accounts; a free domain; automated backups; and 24/7 technical and customer support. Upgrading to a pro account will increase the monthly rate to $19.99, with Pro features thrown in, such as domain privacy; more than 5 times better server performance; a dedicated IP address; SSL certificate; Backups PRO; and additional 10 anti-spam email accounts. What’s more, these packages come with a money-back guarantee.

Godaddy Hosting Packages
Godaddy Hosting Packages

GoDaddy, on the other hand, offers three packages: Economy, Deluxe, and Ultimate. Their basic plan, Economy, consists of 1 website, 100 GB disc space, 10 MySQL databases for Linux OS or 1 MS SQL Database for Windows OS, and 100 email addresses. Originally, Economy is priced at a monthly rate of $6.99 but is now lowered to only $4.99 per month. Their Deluxe Package supposedly offers the best value among their shared web hosting services. From $8.99, users now need only pay $5.99 per month to host unlimited websites, with unlimited bandwidth and disk space, 25 MySQL Databases for Linux OS or 2 MS SQL Databases for Windows OS, and 500 email addresses. GoDaddy’s Ultimate Package is priced at $7.99 per month (it used to be $14.99) and has similar features as the Deluxe Package, except for unlimited databases and 1000 email addresses instead of 500. Users also get Premium DNS and SSL certificate, subject to certain restrictions.

Verdict: The Basic packages of both Bluehost and GoDaddy are both priced almost the same monthly rate, at $4.95 and $4.99, respectively. Those who opt for a Basic plan will get more value from Bluehost’s offering, considering how it offers almost unlimited everything, including databases. GoDaddy’s Basic package, on the other hand, is severely limited in comparison. The price disparity becomes more glaringly significant if you update to a higher plan. Upgrading to a Pro package in Bluehost costs $19.99 monthly, while the GoDaddy’s Ultimate package is priced at a lower $7.99 per month. Users with multiple websites will also end up saving a lot of money with Bluehost because you can host them all using one package. But if you only have the one website, GoDaddy’s Economy package’s 1 website limitation won’t be an issue. Now, if you are on a tight budget, looking for a dirt-cheap basic web hosting service, Bluehost is the obvious choice. However, if you plan on getting a higher-than-basic account and you can live with certain limitations, there’s no doubt that GoDaddy will cost you a lot less.  The money-back guarantee in Bluehost’s package also goes a long way in putting customers’ minds at ease.

Hosting Features

The features of both web hosting companies’ shared web hosting services were mentioned earlier in their package offerings; now it’s time to dig a little deeper. Bluehost offers more flexibility when it comes to its databases, using PHPMyAdmin and MySQL, while GoDaddy is limited to MySQL only. Bluehost also wins, on all counts, with respect to disk space, easily trumping GoDaddy’s disk space limitations.

Again, if you only have a single website that you plan to host, GoDaddy works just fine. But the unlimited websites, domains and email accounts offered by Bluehost makes it ideal for those who are planning to host multiple websites, since they no longer have to get separate hosting plans for each domain. Unless you choose GoDaddy’s Economy plan, the disk space provision of both web hosts is also the same: unlimited.

The unlimited file transfer capability available in Bluehost also makes it the more attractive option. While it is true that GoDaddy also offers backups, there is no denying that Bluehost gives the better deal, with its automated data backups, which is further enhanced when you go Pro.

Both Bluehost and GoDaddy also offer e-commerce applications, which is perfect for users who need an online store management system in their websites. In this regard, Bluehost once again comes out on top, boasting e-commerce applications and platforms such as Zen Cart, SSL, Shared SSL, CubeCart, Agora and Magento. GoDaddy, on the other hand, only has Zen Cart and SSL.

Another area where Bluehost offers more is the accumulation of web statistics. It has referrer logs, a raw Log Manager, error logs, AWStats, and Webilizer. GoDaddy has none of these.

Verdict: Setting the price factor aside, comparing the two companies’ Basic packages based on features alone shows Bluehost as the clear winner. In fact, even if you compare the features of Bluehost’s Pro package to that of GoDaddy’s Ultimate package, Bluehost still wins by a mile.


There is now the question on which web hosting is more user-friendly. Of course, your level of technical know-how will be factored in. This aspect may not matter much to experts who are fairly adept at programming, but beginners will naturally prefer an interface or setup that is very easy to understand, navigate, and use.

Take a look at the “backend” – the screen, dashboard or control panel – users are presented with once they have purchased a hosting account and logged into the web hosting site. Bluehost’s control panel is called, well, cPanel. At first glance, the smattering of icons and options on the screen is daunting, but once you get the hang of it, navigating through it is very easy and straightforward. GoDaddy has come up with its own custom backend which looks initially to be uncomplicated. However, it is only when you attempt to do more that things with GoDaddy’s interface becomes tricky, not to mention frustrating. There is also the matter of Bluehost’s automated script installer – the Softaculous – being more intuitive and faster, allowing the installation of more than 300 popular software for the website to be hosted. GoDaddy’s script installer offers only a handful of applications.

Bluehost's CPanel
Bluehost’s cPanel

There is also a waiting period involved when managing websites via GoDaddy’s in-house backend. This is because it queues all requests related to website or account management. Users end up having to wait for at certain length of time until their requests will be processed.

Verdict: GoDaddy’s control panel is user-friendly IF you prefer something that is easy to use, and you don’t really plan on making changes or hosting account management actions that go beyond the basics. However, in the long run, Bluehost’s user interface offers more flexibility and options, as well as speed. Don’t be intimidated by the “many icons and options” seen on the screen; they’re there for a reason, and that is to give you more control or power over managing your accounts.

Customer Support

It is inevitable that you should run into problems or certain issues with your web hosting, and it certainly helps if your chosen hosting service can be reached at any time of the day (because, really, problems arise when we least expect – or want – them to). Fortunately, both Bluehost and GoDaddy offer exceptional 24/7customer support, starting from a very informative FAQ and Help sections to interactive tools, such as email and phone.

GoDaddy’s phone support has a 36-minute expected wait time, and utilizing only one phone line – no toll-free phone number. Bluehost, on the other hand, involves an average wait time of 9 minutes through two phone lines: a toll-free line for users in the United States and another line for customers outside the US. The email support of both web hosts is done via support tickets. Bluehost guarantees a response period of 24 hours when contacted via email, while GoDaddy do not give out any assurances as to how quick they can respond, only that priority is given to users who are logged into their site. Meanwhile, Buehost also has a live chat team available to assist customers in real time, 24 hours a day, 7 days a week.

Another noteworthy addition to the customer support of these two webhosts is the integration of user forums in their customer support. GoDaddy also set up its own blog for news and updates about its products and services, and hosts the GoDaddy IdeaShare, for a more interactive user experience. Bluehost also deserves commendation for uploading video tutorials on their site, while maintaining a deep and vast knowledgebase. Bluehost users can also keep track of their support history when they log into their accounts on the site. Speaking of interactive, Bluehost and GoDaddy also tapped into the social media trend, making their presence felt on Facebook and Twitter.

Verdict: GoDaddy’s customer support gets the job done. From firsthand experience by many users, GoDaddy’s support is “adequate” and “meets their expectations”. But the clear winner for this round is still Bluehost, with its fast response time and customer service that “exceeds expectations”. Now this does not come as a surprise at all, since Bluehost is one of the highest rated in terms of customer support.


It’s time to take a look at the performance – in terms of speed – of both web hosts. Website speed tests conducted on Bluehost and GoDaddy showed that they both set low memory limits initially. Bluehost has the upper hand in this, since it allows the option of upgrading to Bluehost Pro, which speeds up performance by up to 5 times. In GoDaddy, the hosting account will require more optimization in order to get better performance. As things are right now, there are quite a huge number of customer complaints about GoDaddy web servers being unable to handle high loads of traffic.

Verdict: Basically, Bluehost and GoDaddy do not have significant differences when it comes to load time. It is, however, general knowledge that GoDaddy’s web servers are much slower when it comes to processing time. If you are thinking long-term, Bluehost is the better choice.

Other Products

As mentioned earlier, Bluehost also started offering VPS hosting and dedicated server hosting in 2013, two products that were already included in GoDaddy’s product line. Both web hosts also offer a number of packages or plans for these products. For purposes of comparison, we will focus on their “best value” plans.

Bluehost’s Enhanced VPS hosting charges $29.99 for the first month, renewable at $59.99 for every succeeding month. This is certainly more expensive than GoDaddy’s Value VPS plan, which has a monthly fee of $39.99 (discounts are available for 12-month and 24-month prepayments). Both plans support a monthly bandwidth of 2,000GB (or 2TB) and 60 GB storage. However, Bluehost’s plan offers 4GB available RAM, which is twice more than GoDaddy’s 2GB RAM. Bluehost also threw in two CPU cores, 2 IPs, and a free domain.

When it comes to dedicated servers, GoDaddy’s Value Deal’s features include Intel Core i5 quad core CPU and a 4GB RAM. Customers will also get a storage of 2 x 300 GB hard drives, and a monthly bandwidth of 10TB. All these are at a monthly fee of $149.99, with discounts available if customers choose a 12-month or 24-month term. Bluehost, on the other hand, offers its Enhanced plan at $99.99 for the first month, then renews at $199.99 per month. It also features a 4 x 2.5 GHz quad core CPU, a 10TB bandwidth, and 1TB storage. However, it has 8GB available RAM against GoDaddy’s 4GB. Aside from a free domain, those who avail of this plan will also get 4 IPs.

Verdict: You know what they say about getting what you pay for. On a monthly basis – after the first month – Bluehost’s VPS hosting and dedicated servers hosting is more expensive. But it makes up for the price by adding more features and functionality in their packages.

The Verdict: Bluehost or GoDaddy?

When it comes to package offerings, hosting features, usability, performance, customer support, and other product offerings, Bluehost is way ahead of the race against GoDaddy. It is in the pricing that things get quite tricky because, well, looking at the figures alone, it is clear that Bluehost is the more expensive web host. Cost-benefit analysis, however, would show that you will still get the most bang for your buck even if you pay for the higher price tag attached to Bluehost’s hosting services instead of GoDaddy.

Now, which one should you choose? The answer will depend on what you actually need in a web hosting company. Your know-how, and even your willingness to learn about how these web hosts work, will also have to be factored in. If you are looking to invest in a web host that will serve you well in the long run, and you do not want to be hampered by the limitations set by GoDaddy, then go for Bluehost. In fact, if you want to get the best overall deal on web hosting, Bluehost is the one that is highly recommended. If, on the other hand, you are operating under strict budget constraints, and you do not foresee GoDaddy’s limitations to be a problem with your hosting, then there’s no reason why you shouldn’t go for GoDaddy.

Whatever choice you make, you have to be sure that you have given it proper thought, and weighed the pros and cons while taking into consideration your own needs and particular circumstances.

2 Step Verification for WordPress

2 step verification for WordPress

The more popular your Blog becomes, the more vulnerable it becomes, or as they say – with great power comes great responsibility. So if your WordPress Blog enjoys heavy traffic, you have to find new and creative ways to protect it against the bad guys.

I already wrote about how to protect WordPress by limiting the number of login attempts, and as a matter of fact, since I’ve installed this plugin (2 weeks ago) in order to protect my Blog, I realized how important it is. There were 85 attempts to break into my site. Well done plugin. Well done.

So let’s say you have this plugin installed, but unfortunately someone succeeded to guess the username and password. That means you have a visitor in the admin area, and trust me – you don’t want it to happen.

So let’s add another layer of protection here, and call it 2 step verification for WordPress, using Google Authenticator.

How to enable 2 step verification for WordPress:

The Google Authenticator plugin for WordPress gives you two-factor authentication using the Google Authenticator app for Android / iPhone / Blackberry.

The process of 2 step verification is pretty simple – After typing in the right username and password, WordPress will ask you for a verification code, and you’d have to enter it on the login screen. As long as your phone with you, no one has access to your Blog (even if they have cracked the username and password). In order to enable it, follow this process:

Google Authenticator Settings
Google Authenticator Settings
  1. Go to the plugin download page, download it and install it on your Blog / Website.
  2. Install Google Authenticator on your smartphone: Android / iPhone / Blackberry.
  3. In WordPress, go to your profile (Users Menu -> Your profile) and check the “Active” option.
  4. Run the app on your Smartphone, type in your email address and the Secret code from your profile page on WordPress, or scan the QR code.

You’re done. From now on, every time you login to WordPress, you’ll have to run the Google Authenticator on your Smartphone, and type into WordPress the code provided by the app. This specific code is available only for the next 20 seconds.

8 Tips for Upgrading & Customizing WordPress’ Admin Panel

8 Tips for Upgrading & Customizing WordPress' Admin Panel
Guest post by Eliyahu Lev - Interactive Designer and WordPress Developer.
Originally published in Hebrew here.

WordPress is an easy-to-use wonderful system. I keep telling clients “If you can handle Microsoft Word, you can handle WordPress”, but we can always make WordPress better. Attached are some tips and tricks for WordPress’ Admin Panel. All of the following code snippets should be added to the file functions.php. Don’t forget to backup before you start working.

Remove admin bar

I, personally, find the admin bar pretty annoying. This is how you remove it from your website:

add_filter('show_admin_bar', '__return_false');

Change the text in the footer

By default it says “Thank you for creating with WordPress”. My suggestion is to leave it as is, and add your credit as well:

function remove_footer_admin () {
 echo "Website By <a href="http://www.yourdomain">Your name</a>";
 add_filter('admin_footer_text', 'remove_footer_admin');

Remove widgets from the Home Screen

There is a lot of useless stuff here. This is how to hide it:

function tidy_dashboard(){
global $wp_meta_boxes, $current_user;
// remove incoming links info for authors or editors
if(in_array('author', $current_user->roles) || in_array('editor', $current_user->roles))
 unset($wp_meta_boxes['dashboard']['normal ']['core']['dashboard_incoming_links']);
// remove the plugins info and news feeds for everyone
//Right Now - Comments, Posts, Pages at a glance
//Recent Comments
//Incoming Links
//Plugins - Popular, New and Recently updated WordPress Plugins
//Wordpress Development Blog Feed
//Other WordPress News Feed
//Quick Press Form
//Recent Drafts List
//add our function to the dashboard setup hook
 add_action('wp_dashboard_setup', 'tidy_dashboard');

Add a message to the login screen

This trick is great if you want to add some custom text / message to the login screen:

function custom_login_message() {
$message = '

your message.

return $message;
add_filter('login_message', 'custom_login_message');

Remove irrelevant Menus and Sub-Menus

If you want to prevent the client from certain functions such as changing the theme, or adding / removing plugins etc., here’s an example of how to remove parts of the menu:

function remove_submenus() {global $submenu;

unset($submenu['index.php'][10]); // Removes 'Updates'.
unset($submenu['themes.php'][5]); // Removes 'Themes'.
unset($submenu['options-general.php'][15]); // Removes 'Writing'.
unset($submenu['options-general.php'][25]); // Removes 'Discussion'.
}add_action('admin_menu', 'remove_submenus');

Change the Logo on the login screen

By default, WordPress’ logo is displayed. You can change the image to your client’s logo. Pay attention to the image path “images/logo-admin.png”:

function custom_login_logo() {
 echo '</pre>
<style type="text/css"><!--
 h1 a { display:block; background-image: url('.get_bloginfo('template_director y').'/images/logo-admin.png) !important; width:330px!important; height:100px! important; background-size: 330px 100px!important; }
add_action('login_head', 'custom_login_logo');

Remove HTML editor in posts / pages

Avoid people messing with code. Don’t worry, the Admin will retain full access to the HTML editor:

add_filter( 'wp_default_editor', create_function('', 'return "tinymce";') );
add_action( 'admin_head', 'disable_html_editor_wps' );
function disable_html_editor_wps() {
 global $current_user;
 if ($current_user->user_level != 10) {
 echo '</pre>
<style type="text/css"><!--
#editor-toolbar #edButtonHTML, #quicktags {display: none;}

Remove columns on the posts page

This snippet will help you remove select columns from the posts page, like author name, post category, tags and comments:

function my_columns_filter( $columns ) {
return $columns;
add_filter( 'manage_edit-post_columns', 'my_columns_filter', 10, 1 );

16 Metro Style Themes

16 Metro Style Themes

Metro Style themes – WordPress Themes, Website Templates, Magento Themes, Admin Dashboards, Mobile Themes and vCard templates. Get them all!

MetroShop – Premium Responsive Magento theme

MetroShop – Premium Responsive Magento theme
MetroShop – Premium Responsive Magento theme

MetroShop is a universal 100% responsive Magento theme for any kind of shop with stylish MetroUI style design and powerful backend and it’s created with using the latest HTML5 and CSS3 features. Admin panel with easy navigation and dozens of configuration options allows you to change every thing in theme. You can manage colors of theme elements, select 500+ amazing fonts, apply 200+ pattern backgrounds and setup different theme settings and effects.

Demo | Buy

Rocket Board – Metro WordPress Theme

Rocket Board - Metro WordPress Theme
Rocket Board – Metro WordPress Theme

Rocket Board is a super awesome portfolio WordPress Theme with METRO style. You can set each thumbnail size as 1×1, 1×2, 2×1 or 2×2 easily. This theme also allow user to set specific colour on each metro box or just use the default colour from admin panel. You can also set the first state of metro box to show as colour box or show as feature image. This theme has 9 predefined background colours and 8 overlay patterns or if you need to upload your own background image, it’s just fine.

Demo | Buy

Metronic – Responsive Admin Dashboard Template

Metronic - Responsive Admin Dashboard Template
Metronic – Responsive Admin Dashboard Template

Metronic is a responsive and multipurpose admin and front-end theme powered with Twitter Bootstrap 3.0 Framework. Metronic can be used for any type of web applications: custom admin panels, admin dashboards, CMS, CRM, SAAS and websites: business, corporate, portfolio, blog. Metronic has a sleek, clean and intuitive metro style design which makes your next project look awesome and yet user friendly. Metronic has a huge collection of plugins and UI components and works seamlessly on all major web browsers, tablets and phones.

Demo | Buy

One Touch – Multifunctional Metro Stylish Theme

One Touch - Multifunctional Metro Stylish Theme
One Touch – Multifunctional Metro Stylish Theme

The fast, easy, light template will decorate almost any site on WordPress. The structure of this template such is what it perfectly will be suitable for all, from the entertaining blog to a serious corporate site. Styles are included in a template for WooCommerce so you will be able to create without problems the catalog with shop on your site.

Demo | Buy

Metro vCard – Responsive Metro Style vCard

Metro vCard - Responsive Metro Style vCard
Metro vCard – Responsive Metro Style vCard

Responsive layout, clean design vCard, XHTML valid, JQuery & CSS3, great animations, well document, quick and easy, slide to page metro style, working contact form.

Demo | Buy

Start – Metro UI Responsive Admin Template

Start - Metro UI Responsive Admin Template
Start – Metro UI Responsive Admin Template

Start is a new responsive admin template based on latest Windows 8 interface. This one, called Metro UI, has its roots in the design principles of classic Swiss graphic design – minimal, bold, high contrast and flat colors are some of its great features.

Start is the starting point for your next web application. It`s suitable for any user interface or administration panel, for any devices – from desktop to mobile devices. Start using now and be what`s next for the future of web applications!

Start admin template will save you a lot of time in your development process. Build on famous Twitter Bootstrap framework and updated for using Sass (CSS preprocessor).

Demo | Buy

Metro Mobile Premium WordPress Mobile Template

Metro Mobile Premium WordPress Mobile Template
Metro Mobile Premium WordPress Mobile Template

Metro Mobile Template is just limited with your imagination. Create your own metro mobile tiles and own style (WordPress 3.7 Tested).

Demo | Buy

Black Pearl – Responsive WordPress Theme

Black Pearl - Responsive WordPress Theme
Black Pearl – Responsive WordPress Theme

Black pearl is a unique and powerful theme that is simple, modern and easy to use. It is inspired by metro style design and brought you a set of amazing features with fully responsive design.

Demo | Buy

Matrix – Responsive WordPress Theme

Matrix - Responsive WordPress Theme
Matrix – Responsive WordPress Theme

Matrix is a responsive, intuitive tile-based theme which is inspired by Metro design. The tiles can be made ‘live’ to display more information on the screen without occupying more space.

This WordPress theme comes with 10 pre-defined colours and an advanced but easy-to-use admin panel. It is highly customizable to suit the needs of every user. Unlike conventional designs, each tile can be customized to create any design you can imagine.

Demo | Buy

Retro Metro | SMV Creations

Retro Metro - SMV Creations
Retro Metro – SMV Creations

Retro Metro follows strict Metro UI Guidelines, following the design principles of classic Swiss graphic design.
Under this design approach, the content and typography is given more attention as opposed to UI chrome. This template is compatible across all mobile and tablet devices and also on regular desktop interfaces since it is on complete liquid layout with aesthetics in mind.

Demo | Buy

Touch Responsive & Bootstrap WordPress Theme

Touch Responsive & Bootstrap WordPress Theme
Touch Responsive & Bootstrap WordPress Theme

Touch Twitter Bootstrap – Responsive WP Theme. Unlimited combinations on any page. Very powerful theme which suits both, creative and business users with no programming background, as well as advanced developers. The Theme is built on top of the great Themeple Framework. It comes with a hundreds of options so you can modify, styling, colors, layout and fonts directly from within the Theme Options. Build your own skin and pages right out from your Page Builder and Theme Options. Font, background and color options as well as the dynamic template builder will help you create the Website you need in no time. In addition to the global options you can set unique styling options for each entry.

Demo | Buy

MetroStyle Responsive All Purpose WordPress Theme

MetroStyle Responsive All Purpose WordPress Theme
MetroStyle Responsive All Purpose WordPress Theme

This theme can be applied to any business needs. Easy color and image selection with many design settings can help you transform MetroStyle into a unique business selling tool. The MetroStyle theme is SEO optimized and uses only CSS for fast loading.

Demo | Buy

Matrix – Responsive Tile-Based Template

Matrix - Responsive Tile-Based Template
Matrix – Responsive Tile-Based Template

Matrix is a responsive, intuitive tile-based template which is inspired by Metro design. The tiles can be made ‘live’ to display more information on the screen without occupying more space.

This template comes with 15 HTML files and 10 pre-defined colors. It is highly customizable to suit the needs of every user. Unlike conventional designs, each tile can be customized to create any design you can imagine.

All the files are coded with valid HTML5 tags and CSS3, and are Search Engine Optimized (SEO) using valid HTML5 semantic tags for each section and are written in decreasing order of importance down the page. For instance, the title and content of an article comes before the comments and sidebar within a HTML file, and titles are enclosed in h1 tags to signify their importance.

Demo | Buy

Metrofy – Responsive Metro Inspired Template

Metrofy - Responsive Metro Inspired Template
Metrofy – Responsive Metro Inspired Template

Specially designed based on the Metro Design Language. This template was designed for creating portfolios, agency & consulting firm websites and corporate websites.

The Tiles Layout, the elastic and Flex sliders will help you present your content beautifully, be it your line of products or services or portfolio items.

Demo | Buy

Metro – Responsive Newsletter with Template Builder

Metro - Responsive Newsletter with Template Builder
Metro – Responsive Newsletter with Template Builder

A module based responsive template with Template Builder. The Template Builder let you create your template in three simple steps. With this Theme you get a Template Builder for easy Template making.

Demo | Buy

Metro.press – Expressive WordPress Theme

MetroPress - Expressive WordPress Theme
MetroPress – Expressive WordPress Theme

Metro.press is a responsive premium WordPress Theme inspired by metro design. Metro.press is powered by Warp Framework and Widgetkit, it is fully localized/internationalized, SEO friendly, and has been tested in all major browsers. Metro.press comes with nine expressive colors and style variations. Metro.press is fully responsive and suitable for big and small screens.

Demo | Buy