Category Archives: Hack

A little SEO experiment with watches: Patek Philippe

Posted on by
Reply

When searching for my own name (philippeback) I do get results about Patek Philippe watches interleaved.

It’s quite annoying, so let’s try to recover some space. Hence the commentary below.

About Patek Philippe Watches

Not that I dislike Patek Philippe’s watches. On the contrary, I would love wearing such a Patek Philippe’s watch. If only for the fun of the name. Hey Back and Patek do share some letters after all.

Maybe should I create a Back Philippe’s watch and take over the world with a high grade quality watch.

But it would take a long time (pun intended) just to get to the level of recognition that Patek Philippe does enjoy!

I could maybe write a Patek Philippe Watch simulator. This would have me learn the key elements making out a carefully engineered quality watch like a Patek Philippe.

So, let’s see what it gives. Feel free to enjoy the great Patek Philippe’s watches and my own content if you are so inclined.

Peace.

Share

Widgets, iNove and WordPress: widget reorganization

Posted on by
2

I wanted to change a widget from a widget bar to another since I mistakenly put a lot of widgets into the wrong bar (east, instead of south).

There was no obvious option to do so from the UI, so I launched phpMyAdmin, looked around for widget configuration and found that:

  1. all config lives in the wp_options table
  2. you have to search around to find that the wp_options table has a row where the option_name is “sidebars_widgets”
  3. the value is coded as a serialized array

So, the trick is to perform an update like:

UPDATE `web_wrdp`.`wp_options`
SET `option_value` = 'a:5:{s:9:"sidebar-1";a:0:{}s:9:"
sidebar-4";a:0:{}s:9:"sidebar-3";a:0:{}s:9:"sidebar-2";
a:6:{i:0;s:17:"gd-linkedin-badge";i:1;s:20:"categories-358354231";i:2;s:5:
"links";i:3;s:14:"text-358354861";i:4;s:20:"recent-flickr-photos";i:5;s:13:"twitter-tools";}s:13:"array_version";i:3;}'
WHERE CONVERT(`wp_options`.`option_name` USING utf8) = 'sidebars_widgets' LIMIT 1

and change the sidebar-4 into sidebar-2, and sidebar-2 into sidebar-4 to switch the content of the sidebars.

And it works!

Share