I was riding home tonight and I hit traffic as usual coming into Southall town centre. I weaved through stationary traffic and at the head of the queue was an HGV (just the cab). It had its hazards on and just as I pulled up behind it I thought it had been in a crash. I saw some debris in the road a few feet behind the truck.

As I drew up beside the debris I saw it was a walking stick. Just then I saw the driver of the lorry climbing out of the truck clutching a mobile phone to his ear. He looked as white as a sheet. I thought he’s probably embarrassed about breaking down and across two lanes of rush hour traffic.

As I slowly passed the lorry I saw him. Under the passenger wheel was an Asian man. He didn’t look old, he had jet black hair. He was still and blood was pooling around his head. From the brief glimpse I got as I passed he looked like he was pinned under the front wheel.

I must admit I panicked at that point. My usual response is someone else will deal will it. I knew the driver was probably on the phone to emergency services and there looked to be lots of bystanders,

All this flashed through my mind briefly as I moved past the accident. However not 30 feet from the site is Southall police station. It crossed my mind that the Police have better first aid training than me, so I slewed the bike into their car park and ran into reception.

The officer behind the glass screen was talking to a customer, but after some slight banging on the door, she came out to ask what was wrong. I told her about the accident and she dropped all of her her clients and with a colleague, ran out of the police station.

I don’t know what happened to the guy under the truck. I don’t know why I’m writing this apart from it’s part of my life and it’s slightly cathartic.

Made me think about life a bit anyway
Simon

I am running Magento and a Wordpress blog on Nginx. URL rewriting was working fine on Magento, but whenever I added a location block for /blog/ with the rewrite rule in it, I got a 403 error for the blod directory.

It turns out that this is because you have redeclare the default files for this directoy, then do the rewrite, like so:

location /blog/ {
index index.html index.php;
expires 30d;
if (!-e $request_filename) {
rewrite . /blog/index.php last;
}
}

Very public not to self:

It seems importing a Magento backup into MySQL via the command line you have to do it from a regular command prompt, not a MySQL prompt.

Drop and create a fresh DB
mysql> drop database shop;
mysql> create database shop;

Then exit and do this from a command prompt
[root@]# mysql -uroot -ppasswordgoeshere shop < backup-20100713182416.sql;

This is a good idea. You can buy a mini mobile phone that’s SIM free for only £19.99.

You could get a PAYG SIM for it too if you’re afraid of losing the phone.

Check the deal out here

This a real story out of the Hastings Observer. It seems this man decided to commit suicide by stabbing himself in the groin with a giant souvenir pencil.

And here’s me with a really giant pencil. Wish my groin was this big.

Me and the girlfriend were talking about how air fresheners seem to be the most innovative sector of all fast moving consumer goods. As you do.

Everytime we see a new advert for air fresheners we groan, wondering what they have done now to make me want a new air freshener.

In recent years we have seen:

• motioned trigger air fresheners
• power point plugin air fresheners
• dual scent air fresheners
• air fresheners disguised as pebbles
• air fresheners disguised as candles
• air fresheners for toilets
• air fresheners for cats

Anyway, I was wondering where the air freshener industry was going to take us next. Here’s my best guess at the future of air de-odourisation solutions.

Aromatherapy Air Fresheners
These will pump our peppy citrus smells in the morning and calming lavender scents in the evening

Fan Driven Smell Dispersal
A squirt of scent only permeates so far into the home. What we need is a squirt, then a huge gust of air to waft the smell into all the nooks and crannies.

Home Selling Air Fresheners
They say that when you are showing potential homebuyers around a home you should bake a loaf of bread at the same time. It makes the house seem more homely. Why not let a air freshener make your house smell like a freshly baked loaf.

Personal Air Fresheners
This would be a pendant you wear that contains a motion sensor. Every time you stop still - it releases a puff of pleasant scent. Great if you’re visiting public toilets.

Air Fresheners Disguised as Flowers
Flowers are meant to smell nice aren’t they? These definitely will as they are filled with lab produced chemicals.

Film & TV Licensed Air Fresheners
If you are watching a film like avatar at home on your HD TV - you want it to be as immersive as possible. Why not get an Avatar air freshener that for 3 hours pumps out the smell of Pandora’s forests.

Remember Scents
Smells are often linked very closely with memories because the olfactory bulb in the brain has intimate access to the amygdala, which processes emotion, and the hippocampus, which is responsible for associative learning.

Why don’t companies release scents of the 80s (brut & bubblegum) or scents of the 90s (sweat and mdma)?

These would take us back to a simpler time when we didn’t have to worry so much about what our house fucking smelt like.

At work recently we were recently asked for naming suggestions for the blog. Here’s mine.

Search Box
The entry into the search World

Search Monkey General’s Amazing Tales
You’ve got to read it to believe it.

Canine Fatty Lumps
Or any other random search term (apart from dogging in Bridgeport)

No Results Found
Not something on our search – because we’ll return any old shit

iRelevance
Relevance is the key to search.

Query Deary!
Going after the pink searches

Al Go-rhythm
A blog under a witty pseudonym

Crush Google
A blog that outlines our ultimate goal

Telescope
We search the Sky

Stop and Search
Because you look suspicious

Crazy Search Science & Stats
Nice alliteration and it says what it does on the tin

SearchLight
Casting light on searches

Vanity Search
A vanity search is when you search for your own name.

3 Searches
There are 3 types of search. Navigational, Informational and Transactional (pr0n fits into all 3)

10 QPS
10 queries per second is what we do at peak times (maybe).

We wanted to use the excellent integrated labels with Magento.

We worked out that we needed to:
Copy Abstract.php from app\code\core\Mage\Sales\Model\Order\Pdf to  app\code\local\Mage\Sales\Model\Order\Pdf

Add the following to around line 233

/* Print shipping address for postage label */
$this->_setFontBold($page);
$this->y = 170;
foreach ($shippingAddress as $label){
if ($label!==”) {
$page->drawText(strip_tags(ltrim($label)), 70, $this->y, ‘UTF-8′);
$this->y -=10;
}
}

This printed the shipping address fine. However we noticed that it was printing out the customer’s phone number on the label too.

To remove this you have to go to app\code\core\Mage\Customer\etc\config.xml [make a backup first] and remove the references to a telephone number from within the <pdf translate=”title” module=”customer”> block.

Simon

Taken me age to figure out how to remove the Tax column from the magento PDF invoice.

I’ve made all my changes in a local version of the Magento core code as described here.

The two files you need to edit are:

1. To remove headers: /app/code/local/Mage/Sales/Model/Order/Pdf/Invoice.php
2. To rmove the tax from each individual line item /app/code/local/Mage/Sales/Model/Order/Pdf/Items/Invoice/Default.php

Hope that helps

Simon