/**
 * 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_query("INSERT INTO {friendlist_relations} 
                (requester_id, requestee_id, rtid, create_time, tw_disregarded_time) 
                VALUES ( %d, %d, 1, %d, %d )",
                $row['uid'], $row['buddy'], $row['timestamp'], $row['timestamp']);
    $rid = db_last_insert_id('friendlist_relations','rid');
    
    db_query("INSERT INTO {friendlist_statuses} 
                (requester_id, requestee_id, rtid, status, rid_origin,  rid, last_update_time)
                VALUES ( %d, %d, 1, 'TW_BOTH', %d, %d, %d )",
                $row['uid'], $row['buddy'], $rid, $rid, $row['timestamp']);

    db_query("INSERT INTO {friendlist_relations} 
                (requester_id, requestee_id, rtid, create_time, tw_disregarded_time) 
                VALUES ( %d, %d, 1, %d, %d)",
                $row['buddy'], $row['uid'], $row['timestamp'], $row['timestamp']);
    $rid = db_last_insert_id('friendlist_relations','rid');
    
    db_query("INSERT INTO {friendlist_statuses} 
                (requester_id, requestee_id, rtid, status, rid_origin,  rid, last_update_time)
                VALUES ( %d, %d, 1, 'TW_BOTH', %d, %d, %d )",
                $row['buddy'], $row['uid'], $rid, $rid, $row['timestamp']);
  }
  
}