Jul
24

Apple delays white iPhone 4

Science & Technology

Apple has delayed the white iPhone 4, probably targeting Christmas:

More waits. [via ijustrealized]

0

Jul
19

Coupon: The Movie

Entertain Me

A movie about coupons, basically:

Mr. Show – Coupon: The Movie

0

Jul
18

One of the best juggling acts I have seen

Entertain Me

Here is how good Juggling can get. Excellent staging, a Band that knows exactly whats required Musically and one of the World’s Greatest Jugglers on top form.

The Hat Juggling is a thing of Beauty and in my opinion is the best non-ball juggling sequence ever performed.

0

Jul
17

Dora the Explorer

Entertain Me

Can you point to the trailer that combines Leo’s new sci-fi movie and Dora The Explorer? Very Good!

Let’s sing the backpack song!

0

Jul
16

Far too much spam

meta

This blog has far too much spam for me to handle. Now I won’t be going through the spam to pull out legitimate comments. It has just become unmanageable. :(

0

Jun
08

Apple announces iPhone 4 in WWDC

uncategorized

Nice stuff includes Retina display which is said to be “the sharpest, most vibrant, highest-resolution phone screen ever, with four times the pixel count of previous iPhone models. In fact, the pixel density is so high that the human eye is unable to distinguish individual pixels. Which makes text amazingly crisp and images stunningly sharp.”

You can see more features here.

It comes also with a 5-megapixel still camera and video recording, HD (720p) up to 30 frames per second with audio. Finally a decent camera!

3

Jun
08

Finding and replace text in MySQL

meta

I’ve been slowly moving images into Amazon S3. My main purpose to do offload images to another server. This current server is quite badly hit due to hot-linking actually. All the old images hot-linked will be broken. I am not too concern about that. I have updated all my blog posts to reflect the new image urls.

These are the MySQL find and replace commands for URL address changes:

  • UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "'http://beconfused.com/images/", "'http://beconfused.com/new-address/")
  • UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "\"http://beconfused.com/images/", "'http://beconfused.com/new-address/")
  • UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "'http://www.beconfused.com/images/", "'http://beconfused.com/new-address/")
  • UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "\"http://www.beconfused.com/images/", "'http://beconfused.com/new-address/")

Not that my WordPress posts table is called ‘wp_posts’, yours may be called something else.

The above code changes all HTML links and images to the new address. Notice it starts with a quotation, this is to ensure what is being changed is part of a HTML attribute. Single and double quotations will be changed.

You can execute it in phpMyAdmin.

0