Shin
May
13

SQL to change your WordPress links

A simple quickie in case I ever forget, and you might like it too.
Say you have static content, like a folder of pictures, you want to move or rename. But all your posts link to the old folder.
Here’s a quick way to update all your posts in sql, for example using phpMyAdmin:
update wp_posts set post_content = replace(post_content, '\/anime\/pics', '\/anime2\/pics');
In my case this replaces all the links containing ‘/anime/pics’ with ‘/anime2/pics’ as that’s what I renamed the anime folder to.
Note the \/ in the sql statement, you need to escape all your / slashes in the statement by putting a \ before it, or your get errors.

Feb
21

Google Buzz

There’s a lot of hype since the mighty Google announced their latest addition, Google Buzz, but after a quick look it seems to me it’s just Google’s version of Twitter, complete with geotagging and flickr integration.
So for me there’s not really a point as it integrates with Google’s web apps, which I don’t use. Even though the mobile version of Buzz looks nice enough, I don’t want to load a webpage just to use it in a, for me, cumbersome way. I’ve got an iPhone, I want an app for that. And seeing as I don’t use a gmail app but the regular apple mail app to read my gmail… the point is moot. Unless Google were to come out with an all-in-one app that offers all their services neatly integrated I think I’ll pass this one.

Nov
14

Me and the internet 2009

This topic made me think about social networks, how I use the internet and how things have changed over the years.
I used to seriously dislike the whole social networking fad because I think it pretty much killed ye olde fashioned forums. Now however I’m more getting the hang of it and actually prefer it because it fits better into my current schedule and workflow.
Read more…

May
23

Bye bye last.fm?

Read this if you’re using last.fm. This could be the final nail in their coffin (next to charging for the radio).

May
21

5 Minutes of fame

5_minutes_of_fame

Zomg, I was like, totally famous for 5 minutes. Myeah, maybe not. I was however on the front page of 5minutesfame.com for 5 minutes, showing off my last tweets and my twitter profile, just because I was the first to enter my name in that 5 minute timespan.
All of that gained me a massive 1 new follower on Twitter. Time to sink back into obscurity.

Dec
12

Google Chrome, beta no more

Wow, they move fast. 3 months ago the first beta was released. Now, 10 versions later they’ve hit gold and 1.0 has been released. And if the first beta was fast, this one is a lot faster, and of course a lot more stable as well.

Nov
19

LIFE photo archive

Thanks to Google 10 million photos of the LIFE photo archive are now viewable online. It’s easily searchable and the pics date back to the 1750s.
Too bad about the watermark on the full size versions.

Nov
04

World Wide Winter

It looks and feels like autumn/winter outside, and while on the one hand that tends to make the autumn blues kick in and make people feel a tad down because of the lack of sunshine, on the other hand it’s always fun because the whole WWW seems to become more active again. WordPress 2.7 is just around the corner, and it looks like it’s going to be a great one.
New WordPress sites to give you coding tips and tricks seem to be the latest rage, and new plugins are coming so fast and many you’d think everyone’s been stockpiling their code over the summer.
‘t is the season to be jolly!

Oct
29

MTV Music


Better late than never, they must have thought over at MTV, as they finally strike back at YouTube and open up a new website dedicated to music videos and related footage. I like, the videos are obviously of higher quality as most of the stuff that’s on the Tube which in the case of most 80′s and 90′s music is most often ripped from ye olde VHS tapes.
I also like because it’s possible to embed the videos on your site. They already have a huge amount of music and they’re adding more each and every day. MTV vs. YouTube…. round 1…. ding!

Work in progress... not home!
Trying to get all/most of the new code working before I start on the eyecandy.