Posts written by Martin Toner Web Designer Developer

Magento Delete All Tables Prefixed With ‘wp_’

Ever installed Magento using a one click installer and forgot to remove the “wp_” prefix ?

Simple to remove your tables ? Nope ! pesky Foreign Key Constraints !

Try this code in your favourite MySql program. Please note running the resulting SQL code this will immediately delete all of your databases prefixed with “wp_” so if you are not sure back up ! Read More

Highlight Current Post Category In WordPress Categories Widget Using jQuery PHP

This simple snippet of PHP code will apply the ‘current-cat’ class to any categories in the WordPress categories widget that the current post resides in.

Add this code to your single.php template file in your current template. Make sure you have a .current-cat class in your css.

This assumes jQuery is included and uses $ to declare it.

WordPress Spam BuddyPress Easy MySQL Spam Filter Query

WordPress spam sign ups are a real pain. If you need to do some work on the database to do a mass clean-up of spam users. I created this little MySql query which basically counts the number of full-stops or dots in an email address. Having recently done this for a client, I noticed a pattern especially in @gmail accounts where the same word is used as an email address but has full stops positioned in different places in the email address. To the human eye this sticks out like a sore thumb. So in order to check via a query I created this query. Read More

mr website

Mr Men Fun

Not that I have much free time being a freelance self-employed website developer but in my infrequent spare time and when the inspiration gets me I like to draw Mr. Men. Yes thats right…. For a lot of people my age these are one of the earliest images that reside in my code cluttered brain.

Having recently re-discovered the Mr. Men series of books when my son was born, I was amazed by how much of the story and especially the images were so familiar and vivid in my memory. The felt-tip colouring in and thick black outlines are so iconic particularly the 70s style wallpaper in the various Mr. Men houses.

natural-solid-surfaces

Natural Solid Surfaces Website

Natural Solid Surfaces a division of Natural Stone Surfaces commissions SK23 design new website showcasing their solid surfaces range of products.

SK23 was please to undertake this project for one of the High Peaks thriving businesses, based nearby in Chapel-en-le-Frith. Supplying quality work surfaces for both residential and commercial kitchens, bars and restaurants.

The website is now live : www.naturalsolidsurfaces.com (or will be soon)