Category Archives: Tutorials

How To Reduce WordPress Comment Spam

Video Transcription

A self hosted WordPress site is one of the best CMS systems for blogging out there and we recommend it to almost all of our clients minus the few that have special requirements like large eCommerce sites or sites that require larger database management.  But one of the problems that a lot of people face is the constant fight against comment spam.

This is when every time you login to WordPress, you see a whole load of spam comments just waiting to be deleted.  And going through and deleting them all is a time consuming job.  One which you really shouldn’t have to be doing.

What Is A Spam Comment?

A spam comment is usually generated by a computer software or some outsourced worker in a lower paid area of the world manually posting to blogs they find that they feel is “relevant” to their industry with the hope of obtaining a cheeky backlink.  The posts themselves are normally easy to spot as they are full of irrelevant keywords, spammy hyperlinks, and sometimes contain very poor grammer.

So How Can You Stop Comment Spam?

How to reduce wordpress comment spam

There’s a great plugin called Akismet which is known as the best free WordPress plugin that helps deal with comment spam.  It’s clever enough to work out which pingbacks, trackbacks and blog comments are spam and which ones are legit.  It’s really quick to set up, in fact, I’ll show you quickly now what you need to do to get it installed.

Once you’re logged into WordPress, click on Plugins > Add New on the left hand navigation.  Do a quick search for Akismet, find it in the search result list and then click to install and activate.

The next thing you need to do is obtain a free Akismet API Key and don’t worry, it’s not complicated.  Just follow the link to their website and follow the on-screen instructions for creating an account.

Once you’ve generated your key, all you need to do is go back to your Akismet configuration page enter the key and your website is now protected – Easy!

Thanks for tuning in to this week’s video.  This is Froggo Marketing, I’m James Downton and I’ll catch up with you soon.

3 Sexy SQL Hacks To Transfer WordPress To A New Domain

WordPress runs off a MySQL Database.  This is where all of your content is stored when you hit the save, publish or anything that needs to be remembered inside your WP dashboard.  It’s this MySQL database that needs to be configures correctly in order to move your site onto a new domain.  Otherwise you get the dreaded error message that many newbie web masters have probably lost a few hairs over.

Transfer WordPress to a new domain

Anyway, once you hook the database up correctly the battle still isn’t won… there’s still a list of things that you’ve got to change.  This is because the old domain that your WordPress site was on previously has riddled the MySQL database with that old domain.  You’ve now got to update it to the new domain in every place that it crops up…

But fear not, there are some sexy SQL hacks we all use to get the job done at lightening speed:

1. Change Siteurl & Homeurl

If you copy over your database and do not change both your Siteurl and Homeurl to the new domain, your site will NOT load.  Use this SQL script to update both to your new domain.

[sql]UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl.com’, ‘http://www.newurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;[/sql]

2. Changing GUID (Globally Unique Identifier)

Changing the GUID is the big one.  This little code will swap out every line of code containing the old domain and replace it with the new domain.

[sql]UPDATE wp_posts SET guid = REPLACE (guid, ‘http://www.oldurl.com’, ‘http://www.newurl.com’);[/sql]

3. Change The URL In Your Published Content

Any links in your posts from being on the old domain will need to be changed too.  WordPress stores them in the database using an absolute path instead of a relative path so they all need to be updated manually… or with this code.

[sql]UPDATE wp_posts SET post_content = REPLACE (post_content, ‘http://www.oldurl.com’, ‘http://www.newurl.com’);[/sql]

 

How to create image rollovers using css

In this weeks video blog I show you how to create rollover images that don’t flicker when scrolled over using CSS. Firstly I show you how to create the image using Adobe Photoshop before taking you through how to code it up. Continue reading

How to show and hide text in a form using onclick and onblur

In this weeks video tutorial I show you how how to show and hide text using onclick and onblur. It’s a great way to reduce the need for headings or titles in a form, or any field for that matter including search fields. Continue reading