After working with the Georgia Straight for a little over a year, it's satisfying to finally see our web team's vision unleashed. We've launched a redesign that combines a new look with a new navigation scheme. In the previous version, content over a week old was only accessible through the "back issues" interface. In the new version access to content is more blog-like. Content flows in reverse chronological order for each topic and can be subscribed to via RSS.
At the Georgia Straight, we've implemented our first contest based on user generated content and user content rating. In partnership with the Canadian Broadcasting Corporation, we're offering a $1000 makeover to the highest rated contestants who submit their photos. By rating the submitted photos, our users get to decide who should get a makeover.
When testing different user roles in Drupal, there is a handy trick that leverages Gmail's ability to pass information in via your email address. For example, if your Gmail email address is "firstname.lastname@example.org" you can pass additional information by adding a plus sign before the "@" and the additional information after the plus sign. For example, "email@example.com". When creating test users with different roles, the role can be specified in the email address using this technique.
Oct. 2007 Presentation for Vancouver Drupal Users Group (PDF) viewable online here
SELECT IF ( LEFT(my_name_column, 4) = 'the ', CONCAT(RIGHT(my_name_column, LENGTH(my_name_column) - 4), ', The'), my_name_column ) AS my_sortable_name_column FROM my_table ORDER BY my_sortable_name_column ASC