Stuff

$previous_database = db_set_active('seperate_db')
db_set_active($previous_database);

function swap_db_form_alter($form_id, &$form) {

  // Send profile data to external database.

  if (isset($form['type']) && 'user-edit' == $form_id) {
    if (db_result(db_query("SELECT fid FROM {profile_fields} WHERE username = '%s'". $query_suffix, $args2))) {

     $form['#submit']['send_to_db'] = array();

    }
  }
}


function send_to_db($user_profile, $mode) {

  $name = $user_profile->username;
  $user = db_fetch_object(db_query("
  SELECT uid 
  FROM {JOIN_TABLE_USERS} 
  WHERE exid = '%s'",
    $name
  ));
  
  if ($user) {

    $node->field_age[0]['value'] = $user_profile->age;
    $node->field_location[0]['value'] = $user_profile->location;

    $exists = db_fetch_object(db_query("
      SELECT nid
      FROM node n
      WHERE n.type = 'user_profile'
      AND n.uid = %d",
      $user->uid
    ));

  if ($exists) $node->nid = $exists->nid;

  if ($mode == 1) node_save($node);
  return $output;

}

db_set_active();