Engine of a Mini Seven racing Mini
Photo: Copyright © 2009 Eelke Blok

Web

Changing a user's password in OpenX 2.8

The user management of OpenX is a little confusing if you are used to other systems. There is a blog-post about the user system on the OpenX-blog giving a good overview.

One aspect that they seem to have forgotten is dat users may want to change their password. A "I forgot my password" link is provided, but other than that there is no way to change your password.

Finding number of Drupal-nodes created per hour in a single query

For a customer I've been running an import of old content into a Drupal installation and I got the feeling that the process seemed to run slower and slower. We say "meten is weten" in Dutch ("measuring is knowing"), so I wondered if it was possible to write a single SQL query to find out how many nodes were created per hour since the start of the import. This is the query I came up with:

SELECT FLOOR((node.changed - 1304604369) / 3600) AS hour, COUNT(nid) FROM node WHERE node.changed >= 1304604369 GROUP BY hour;

Translations broken on WooThemes Bueno

The past few days, I have been working on switching my girlfriend's new site - Mientje's Baksels - from wordpress.com to a self-hosted blog, using Wordpress 3's new multisite feature (this blog should move there soon too, I just have to sort out the domain transfer). The wordpress.com blog used WooTheme's Bueno theme, which we thought matched very well with the subject of her blog: cakes.