BOINC / boinc

drupal/sites/default/boinc/modules/boincimport/includes/import_team.php

<?php
// $Id$

/**
 * @file
 * A special, detachable routine for importing teams.
 *
 * The process of importing teams relies on Drupal API calls that may not
 * be intended for large batch processing. This script is intended to be called
 * via exec() by a higher level import routine to handle a small subset of teams
 * at a time and avoid exhausting memory.
 */

  require_once('./includes/bootstrap.inc');
  drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
  require_boinc('db');

  // Parse arguments
  $team_id = isset($argv[1]) ? $argv[1] : null;
  $team_type_tid = isset($argv[2]) ? $argv[2] : null;
  $input_format = isset($argv[3]) ? $argv[3] : null;

  $count = 0;

  // Get teams from BOINC
  db_set_active('boinc_rw');
  $boincteam = db_fetch_object(db_query('SELECT * FROM team WHERE id=%d', array($team_id)));
  $boincteam_members = db_query('SELECT id FROM user WHERE teamid=%d', array($team_id));
  $boincteam_admin = (int) db_result(db_query('SELECT userid FROM team_admin WHERE teamid=%d', array($team_id)));
  db_set_active('default');

  $team_exists = db_query('SELECT team_id FROM {boincteam} WHERE team_id = %d', $boincteam->id);
  // FIXME: $team_exists==FALSE should be handled as an error and return an error code!

Comment refers to a FIXME task "$team_exists==FALSE should be handled as an error and return an error code!"

  if ($team_exists != FALSE && db_fetch_object($team_exists) == FALSE) {
    $boincteam->description = _boincimport_text_sanitize($boincteam->description);
    $teaser = node_teaser($boincteam->description);

    // Construct the team as an organic group node
    $node = array(
      'type' => 'team',
      'title' => $boincteam->name,
      'body' => $boincteam->description,
      'teaser' => $teaser,
      'uid' => boincuser_lookup_uid($boincteam->userid),
      'path' => null,
      'status' => 1,  // published or not - always publish
      'promote' => 0,
      'created' => $boincteam->create_time,
      'comment' => 0,  // comments disabled
      'moderate' => 0,
      'sticky' => 0,
      'format' => $input_format
    );

    // Use pathauto function, if available, to clean up the path
    if (module_exists('pathauto')) {
      module_load_include('inc', 'pathauto', 'pathauto');
      $node['path'] = pathauto_cleanstring($boincteam->name);
    }
    else {
      echo 'Pathauto module is required!';
      exit;
    }

    $node = (object) $node; // node_save requires an object form

    $node->taxonomy[] = taxonomy_get_term($team_type_tid);

    // Save the team node
    node_save($node);

    // Save the team IDs to a BOINC <--> Drupal reference table.
    db_query('INSERT INTO {boincteam} (team_id, nid) VALUES (%d, %d)', $boincteam->id, $node->nid);
  }

  // Determine team membership
  db_set_active('boinc_rw');
  $boincteam_member_ids = array();
  while ($boincuser = db_fetch_object($boincteam_members)) $boincteam_member_ids[] = $boincuser->id;
  db_set_active('default');
  if ($boincteam_member_ids) {
    $team_members = db_query('SELECT uid FROM {boincuser} WHERE boinc_id IN(%s)', implode(',', $boincteam_member_ids));
    $team_admin = (int) db_result(db_query('SELECT uid FROM {boincuser} WHERE boinc_id=%d', $boincteam_admin));

    while ($drupal_user = db_fetch_object($team_members)) {
      // Add action to take on member accounts?
      $count++;
    }
  }

  echo $count;