Author: james

Restore a magento database

To restore a .sql file backup without constraint checking, simply add the following statements at the beginning of your .sql file: SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT; SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS; SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION; SET NAMES utf8; SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’; SET

read more

Joomla password reset MD5’s

password = “MD5 hash of password” —————————————————— admin = 21232f297a57a5a743894a0e4a801fc3 secret = 5ebe2294ecd0e0f08eab7690d2a6ee69 OU812 = 7441de5382cf4fecbaa9a8c538e76783Use in the jos_users table.

Image mapping made easy at image-maps.com

Had to create some image maps for a client. These usually take ages to work out using the area tags and stuff like that, BUT discovered http://www.image-maps.com/ and it turns out to be a remarkably good website and a useful

read more

Adding jquery innerfade to vslider on WordPress

wordpress_small

Was getting a bit frustrated with the very good vSlider plugin for WordPress. it’s a very good and simple image slider plugin for WordPress, with a nice interface for adding images and changing the sliding effects, BUT there’s one problem,

read more