I'm currently flying from JFK airport to SF to attend DrupalCon2010! I've enrolled for the Cracking Drupal security 1 day session, and will definately be attending as much as i can with the rest of the conference! Looking forward to meeting up with a few local melbourne php/drupal guy's as well as catch on with what's happening with Drupal 7 because unfortunately I havent had any time recently to catch up with it (my most popular site is still drupal 5! but it works!)

oh and American Airlines WiFi is awesome :D

I came across this article about youtube ditching its fivestar rating basically because users treat it as a binary thing, either they love it (5 stars) or hate it (0 stars) or simply dont bother voting, there are some edge cases where users DO bother voting however.

more here... http://youtube-global.blogspot.com/2009/09/five-stars-dominate-ratings.h...

http://beat.com.au/ now running drupal http://drupal.org , a great choice for this kind of website! not huge amounts of data, but definate content structure, gig guides etc, nice theming too! seems to be based on the zen theme

/**
 * Brute force import buddylist into friendlist
 * the friendlist import sucks pretty bad and emails everyone when they import
 */
function buddylist_import_to_friendlist() {
  $ret=array();
  $result = db_query("SELECT * FROM {buddylist} where received=1;");
  while($row = db_fetch_array($result)) {
    // friendlist can be two way so we need to insert twice with opposing uids so they handshake
    db    

      
Read more
    
  

mysql> select * from friendlist_statuses;
+-----+--------------+--------------+------+---------+------------+------+------------------+
| sid | requester_id | requestee_id | rtid | status  | rid_origin | rid  | last_update_time |
+-----+--------------+--------------+------+---------+------------+------+------------------+
|   7 |            1 |         5484 |    1 | TW_BOTH |        232 |  232 |       1259898195 |
|   8 |         5484 |            1 |    1 | TW_BOTH |        233 |  233 |       1259898195 |
+-----+--------------+--------------+------+---------+------------    

      
Read more
    
  

Simple script you could drop into /etc/cron.daily/backup_db , handy for testing the exit level of mysqldump and rsync, and then rsyncing to your external server, keeps a rolling month's worth of backups.

error checked from mysqldump by testing for info in the STDERR output, and rsync tested by examining the return code ($?)


#!/bin/bash