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