modules/track/track.module

<?
// $Id: track.module,v 1.11 2009/03/07 19:48:29 gadzuk Exp $

/**
 * @file
 * GPX-handling and displaying.
 */

define('TRACK_PATH', drupal_get_path('module', 'track'));

include_once(TRACK_PATH ."/track.gpx.inc");
include_once(TRACK_PATH ."/track.tile.inc");
include_once(TRACK_PATH ."/track.google.map.inc");


$phptrackback = "";

function get_gpx_filepath($nid) {
 $extras = new StdClass();
 $extras->file = db_fetch_object(db_query('SELECT * FROM {track} WHERE nid = %d', $nid));
 return $extras->file->filepath;
}

function track_add() {
  return node_add("track");
}

/**
 * Implementation of hook_menu().
 */
function track_menu() {
  $items = array();

  // Menu items appearing under Navigation
  $items['track'] = array(
   'title' => 'Track list',
   'page callback' => 'list_trk',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_NORMAL_ITEM);
  $items['track/add'] = array(
   'title' => 'Track upload',
   'page callback' => 'track_add',
   'access callback' => 'user_access',
   'access arguments' => array('Create tracks'),
   'type' => MENU_NORMAL_ITEM);

  // Callbacks for various track functions
  $items['track/trk'] = array(
   'page callback' => 'download_trk',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/kml'] = array(
   'page callback' => 'download_kml',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/gpx'] = array(
   'page callback' => 'download_gpx',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/icon'] = array(
   'page callback' => 'get_icon',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/ajax/all'] = array(
   'page callback' => 'trackback_all',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/ajax/detail'] = array(
   'page callback' => 'trackback_detail',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/profile'] = array(
   'page callback' => 'trackback_profile',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/repartition'] = array(
   'page callback' => 'trackback_repartition',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);
  $items['track/boundslist'] = array(
   'page callback' => 'track_boundslist',
   'access callback' => 'user_access',
   'access arguments' => array('access content'),
   'type' => MENU_CALLBACK);

  return $items;
}

function track_boundslist() {
    $result = db_query('SELECT latmin, lonmin, latmax, lonmax FROM {track}');
    if ($result) {
     while ($bounds = db_fetch_object($result)) {
       echo $bounds->lonmin .";".$bounds->latmin .";".$bounds->lonmax .";".$bounds->latmax."<br>\n";
     }
    }
}

function trackback_profile($nid) {
  $aGPXfile = new GPX_file();
  $aGPXfile->LoadFromFile(get_gpx_filepath($nid));
  $aGPXfile->XMLforProfile();
}

function trackback_repartition($nid) {
  $aGPXfile = new GPX_file();
  $aGPXfile->LoadFromFile(get_gpx_filepath($nid));
  $aGPXfile->XMLforRepartition();
}

function get_icon($diff) {
 header("Content-type: image/png");

 if ($diff == "S") {
  $image_name = TRACK_PATH ."/misc/pushpins/058.png";
 } elseif ($diff == "M") {
  $image_name = TRACK_PATH ."/misc/pushpins/150.png";
 } elseif ($diff == "L") {
  $image_name = TRACK_PATH ."/misc/pushpins/011.png";
 } else {
  $image_name = TRACK_PATH ."/misc/pushpins/007.png";
 }

 $im = imagecreatefrompng($image_name);
 imageAlphaBlending($im, true);
 imageSaveAlpha($im, true);

 if ($diff == "XL") {
  $black = imagecolorallocate($im, 0, 0, 0);
 } else {
  $black = imagecolorallocate($im, 0, 0, 0);
 }

 $string = $diff;
 $len = strlen($string);

 if($len <= 2) {
   $px = (imagesx($im) - 7 * strlen($string)) / 2 + 1;
   imagestring($im, 3, $px, 3, $string, $black);
 } else {
   $px = (imagesx($im) - 7 * strlen($string)) / 2 + 2;
   imagestring($im, 2, $px, 3, $string, $black);
 }

 imagepng($im);
 imagedestroy($im);
}

function trackback_detail($nid) {
  // create interface object with map
  $aMap = new GoogleMap();
  // init all values
  $aMap->Init();

  // map is displaying sync, zoom
  if ($aMap->mapaction == "initsync") {
    $result = db_query('SELECT min(latmin) as latminr, min(lonmin) as lonminr,max(latmax) as latmaxr, max(lonmax) as lonmaxr, avg(latstart) as latavg, avg(lonstart) as lonavg FROM {track} WHERE nid='.$nid);
    if ($result) {
     while ($bounds = db_fetch_object($result)) {
       $latmin = $bounds->latminr;
       $lonmin = $bounds->lonminr;
       $latmax = $bounds->latmaxr;
       $lonmax = $bounds->lonmaxr;
       $latavg = $bounds->latavg;
       $lonavg = $bounds->lonavg;
     }
    }

    $varlon = max(1e-5, $lonmax - $lonmin);
    $angle = 360 * 0.7;
    $zoomlevellon = 17;
    while ($angle>$varlon)
    {
  $angle = $angle / 2;
  $zoomlevellon--;
    }

    $varlat = max(1e-5, $latmax - $latmin);
    $angle = 360 * 0.7;
    $zoomlevellat = 17;
    while ($angle>$varlat)
    {
  $angle = $angle / 2;
  $zoomlevellat--;
    }

    $zoomlevel = max(0, max($zoomlevellat, $zoomlevellon));

    // center and zoom the map
    $lonavg = ($lonmin + $lonmax) / 2.0;
    $latavg = ($latmin + $latmax) / 2.0;
    $aMap->MoveAndZoom($lonavg, $latavg, $zoomlevel);
  }
  // map is displaying async, display
  if ($aMap->mapaction == "initasync") {
    $aGPXfile = new GPX_file();
    $aGPXfile->LoadFromFile(get_gpx_filepath($nid));
    $aMap->AddClearLastTrace();
    $points = $aGPXfile->PointsForGoogleMaps(2000);

    $track = node_load($nid);
    $desc = theme('info_window_html', $track);
    $aMap->AddTrace($points, "#ff0000", 3, 0.8);

    $intensite = $track->file->dzplus / ($track->file->length / 4);
    $intensite = ($intensite - 30) * (100 / 40);

    if ($intensite < 30) {
      $mapicon = base_path()."track/icon/S";
    }
    elseif ($intensite < 60) {
      $mapicon = base_path()."track/icon/M";
    }
    elseif ($intensite < 100) {
      $mapicon = base_path()."track/icon/L";
    }
    else {
      $mapicon = base_path()."track/icon/XL";
    }

    $aMap->AddPoint($points[0][0], $points[0][1], $track->nid, $desc, $mapicon);
    $aMap->DisplayInfo("info", "");
  }
  // send scenario to map
  $aMap->ShowXMLforAJAX();
}

function trackback_all() {
  // create interface object with map
  $aMap = new GoogleMap();
  // init all values
  $aMap->Init();

  if ($aMap->mapaction == "initsync") {
    $result = db_query('SELECT min(latmin) as latminr, min(lonmin) as lonminr,max(latmax) as latmaxr, max(lonmax) as lonmaxr FROM {track}');
    $nresult = 0;
    if ($result) {
     while ($bounds = db_fetch_object($result)) {
       $latmin = $bounds->latminr;
       $lonmin = $bounds->lonminr;
       $latmax = $bounds->latmaxr;
       $lonmax = $bounds->lonmaxr;
       $lonavg = ($lonmin + $lonmax) / 2.0;
       $latavg = ($latmin + $latmax) / 2.0;
       $nresult++;
     }
    }

    if ($nresult > 0) {
    $varlon = max(1e-5, $lonmax - $lonmin);
    $angle = 360;
    $zoomlevellon = 17;
    while ($angle>$varlon)
    {
  $angle = $angle / 2;
  $zoomlevellon--;
    }

    $varlat = max(1e-5, $latmax - $latmin);
    $angle = 360;
    $zoomlevellat = 17;
    while ($angle>$varlat)
    {
  $angle = $angle / 2;
  $zoomlevellat--;
    }

    $zoomlevel = max(0, max($zoomlevellat, $zoomlevellon));

    // center and zoom the map
    $aMap->MoveAndZoom($lonavg, $latavg, $zoomlevel);
    } else {
    $aMap->MoveAndZoom("0", "0", 17);
    }

  }
  if ($aMap->mapaction == "initasync") {
    $result = db_query('SELECT n.nid, r.title, r.teaser, u.name, u.uid, t.latstart, t.lonstart, t.dzplus, t.length FROM {node} n INNER JOIN {users} u ON u.uid = n.uid INNER JOIN {node_revisions} r ON r.vid = n.vid INNER JOIN {track} t ON t.nid = n.nid');

    if ($result) {
     while ($track = db_fetch_object($result)) {
      $desc = theme('info_window_html', $track);

      $intensite = $track->dzplus / ($track->length / 4);
      $intensite = ($intensite - 30) * (100 / 40);

      if ($intensite < 30) {
        $mapicon = base_path()."track/icon/S";
      }
      elseif ($intensite < 60) {
        $mapicon = base_path()."track/icon/M";
      }
      elseif ($intensite < 100) {
        $mapicon = base_path()."track/icon/L";
      }
      else {
        $mapicon = base_path()."track/icon/XL";
      }
      $aMap->AddPoint($track->lonstart, $track->latstart, $track->nid, $desc, $mapicon);
     }
    }
    $aMap->DisplayInfo("info", "");
  } // end init

  if ($aMap->mapaction == "clicked") {
    $aGPXfile = new GPX_file();
    $aGPXfile->LoadFromFile(get_gpx_filepath($aMap->idclicked));
    $aMap->AddClearLastTrace();
    $aMap->AddTrace($aGPXfile->PointsForGoogleMaps(2000), "#0000ff", 2, 0.8);

//    $track = node_load($aMap->idclicked);
    $desc = theme('info_details', $track);
    $aMap->DisplayInfo("info", $desc);
  }

  // send scenario to map
  $aMap->ShowXMLforAJAX();
}

function theme_info_window_html($track) {
  prepare_google_maps();
  $output = "";
  $output .= "<b>".$track->title."</b>";
  $output .= " ".t("by")." ";
  $output .= l($track->name, 'user/'.$track->uid);
  $output .= check_markup($track->teaser, $track->format, FALSE);
  $output .= "<b>".l(t('More details'), 'node/'.$track->nid)."</b>";
  return $output;
}

function theme_info_details($track) {
  prepare_google_maps();
  $output = theme('track_files', $track, true);
  return $output;
}

function prepare_google_maps() {
  _gmap_doheader();
  drupal_add_js(TRACK_PATH .'/misc/map.inc.js');
}

function track_footer($main = 0) {
  global $phptrackback;

  if ($phptrackback != "") {
   prepare_google_maps();
   $content = '';
   $content .= "<script type=\"text/javascript\">";
   $content .= "\n";
   $content .= "//<![CDATA[\n";
   $content .= " var myMapClass = null;\n";
   $content .= "$(document).ready(function() {\n";
   $content .= "  myMapClass = new MapClass();\n";
   $content .= "  myMapClass.initmap('".base_path().$phptrackback."', 'map');\n";
   $content .= " });\n";
   $content .= "//]]>";
   $content .= "\n";
   $content .= "</script >\n";
  }

  return $content;
}

function track_page_last() {
  $output = '';
  $result = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'track' AND n.status = 1 ORDER BY n.created DESC"), variable_get('default_nodes_main', 10));

  $header = array();
  $header[] = t("Name");
  $header[] = t("Teaser");
  $header[] = t("Length");
  $header[] = t("Z+");
  $header[] = t("Z-");
  $header[] = "<b>".t("Intensity")."</b>";

  $rows = array();

  while ($node = db_fetch_object($result)) {
    $row = array();
    $track = node_load($node->nid);
    $row[] = l($track->title, 'node/'.$track->nid);
    $row[] = check_markup($track->teaser, $track->format, FALSE);
    $row[] = sprintf('%2.2f', $track->file->length)." km";
    $row[] = sprintf('%2.2f', $track->file->dzplus)." m";
    $row[] = sprintf('%2.2f', $track->file->dzminu)." m";

    if ($track->file->length != 0) {
      $intensite = $track->file->dzplus / ($track->file->length / 4);
      $intensite = ($intensite - 30) * (100 / 40);
    } else {
      $intensite = 0.0;
    }

    if ($intensite < 30) {
      $sint = "S";
    }
    elseif ($intensite < 60) {
      $sint = "M";
    }
    elseif ($intensite < 100) {
      $sint = "L";
    }
    else {
      $sint = "XL";
    }

    $row[] = "<b>".$sint."</b>";
    $rows[] = $row;
  }
  $output .= theme_table($header, $rows);

  $output .= theme('pager', NULL, variable_get('default_nodes_main', 10));
  return $output;
}

function list_trk() {
  global $phptrackback;
  $phptrackback = 'track/ajax/all';

  prepare_google_maps();

  $content = '';

/*  $output .= theme_item_list(
     array(),
     t('Map'),
     'ul'
     );
*/

  $content .= '   <table width="95%"><tr><td>';
  $content .= '   <div id="map" style="height: 600px; left:0px; right:0px;"></div>';
  $content .= '   </td></tr><tr><td>';
  $content .= '   <div id="info" style="height: 100px">'.t("Loading").'...'.'</div>';
  $content .= '   </td></tr></table>';

  $content .= track_page_last();

  return $content;
}

function download_trk($nid = 0) {
  $aGPXfile = new GPX_file();
  $aGPXfile->LoadFromFile(get_gpx_filepath($nid));
  $aGPXfile->ConvertToTRK();
}

function download_kml($nid = 0) {
  $aGPXfile = new GPX_file();
  $aGPXfile->LoadFromFile(get_gpx_filepath($nid));
  $aGPXfile->ConvertToKML();
}

function download_gpx($nid = 0) {
   $file = get_gpx_filepath($nid);
   file_transfer($file, array('Content-Disposition: attachment; filename="'.basename($file).'"') );
}

/**
 * Implementation of hook_perm.
 */
function track_perm() {
  return array('create tracks');
}

/**
 * Implementation of hook_help().
 */
function track_help($path, $arg) {
  switch ($path) {
    case 'node/add#track':
      return t('Upload new track.');
  }
}

/**
 * Implementation of hook_node_info.
 */
function track_node_info() {
  return array(
    'track' => array(
      'name' => t('Track'),
      'module' => 'track',
      'description' => t("A track is a GPS/GPX track file"),
    )
  );
}

/**
 * Implementation of hook_access.
 */
function track_access($op, $node) {
  global $user;
  switch ($op) {
    case 'create':
      return user_access("create tracks");
    case 'update':
    case 'delete':
      return user_access("create tracks") && ($user->uid == $node->uid);
  }
}

function track_flash_chart($width, $height, $nid, $type) {
  global $base_path;

  $swf = "FC2Line.swf";
  if ($type == "repartition")
   $swf = "FC2Column.swf";
  $output = '';
  $output .= '<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" ';
  $output .= 'codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" ';
  $output .= 'WIDTH="'.$width.'" HEIGHT="'.$height.'" id="FC2Area3D" ALIGN="">';
  $output .= '<PARAM NAME=movie VALUE="'.$base_path.TRACK_PATH.'/misc/'.$swf.'?dataUrl='. $base_path . 'track/'.$type.'/'.$nid.'">';
  $output .= '<PARAM NAME=quality VALUE=high><PARAM NAME=bgcolor VALUE=#FFFFFF>';
  $output .= '<EMBED src="'.$base_path.TRACK_PATH.'/misc/'.$swf.'?dataUrl='.$base_path.'track/'.$type.'/'.$nid.'" quality=high ';
  $output .= 'bgcolor=#FFFFFF WIDTH="'.$width.'" HEIGHT="'.$height.'" NAME="FC2Area3D" ';
  $output .= 'ALIGN="" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"></EMBED>';
  $output .= '</OBJECT>';
  return $output;
}

/**
 * Implementation of hook_view.
 */
function track_view(&$node, $teaser = FALSE, $page = FALSE) {
  global $phptrackback;
  if ($phptrackback == "")
   $phptrackback = 'track/ajax/detail/'.$node->nid."/";

  $node = node_prepare($node, $teaser);
  $node->content['track'] = array(
    '#value' => theme('track_files', $node),
    '#weight' => 1,
  );
  return $node;
}

/**
 * Implementation of hook_theme().
 */
function track_theme() {
  return array(
    'track' => array('arguments' => array('element')),
    'track_files' => array('arguments' => array('element')),
    'item_list' => array('arguments' => array('element')),
    'info_window_html' => array('arguments' => array('element')),
    'info_details' => array('arguments' => array('element')),
  );
}

function theme_track_files($node) {
  prepare_google_maps();

  //theme_node_example_order_info
  $output = "";

  if ($file = $node->file) {
   $output .= "<p>";

   $output .= theme_item_list(
    array(
     t('Length').' : '.sprintf('%2.2f', $node->file->length).'km',
     t('Positive Z').' : '.sprintf('%2.2f', $node->file->dzplus).'m',
     t('Negative Z').' : '.sprintf('%2.2f', $node->file->dzminu).'m',
     t('Z min').' : '.sprintf('%2.2f', $node->file->zmin).'m',
     t('Z max').' : '.sprintf('%2.2f', $node->file->zmax).'m'
    ),
    t('Characteristics'),
    'ul'
    );

   if (!$teaser) {
    $output .= theme_item_list(
     array(),
     t('Map'),
     'ul'
     );

   $output .= '   <table width="95%"><tr><td>';
   $output .= '   <div id="map" style="height: 600px; left:0px; right:0px;"></div>';
   $output .= '   </td></tr><tr><td>';
   $output .= '   <div id="info" style="height: 30px">'.t("Loading").'...'.'</div>';
   $output .= '   </td></tr></table>';


    $output .= theme_item_list(
     array(
       track_flash_chart(565, 420, $node->nid, "profile"),
       track_flash_chart(565, 420, $node->nid, "repartition")
     ),
     t('Charts')." (".l("FusionCharts", "http://www.infosoftglobal.com/FusionCharts/").")",
     'ul'
    );

    // Only create link to file when it is in the proper location.
    if (file_check_location($file->filepath, file_directory_path())) {
    $output .= theme_item_list(
     array(
      "<p>".l($node->title . ' - '.t('GPX file'), 'track/gpx/'.$node->nid),
//      "<p>".l($node->title . ' - '.t('TRK file'), 'track/trk/'.$node->nid),
      "<p>".l($node->title . ' - '.t('KML file'), 'track/kml/'.$node->nid)
     ),
     t('Downloads'),
     'ul'
     );
   }

   }

   $output .= "</p>";
  }

  return $output;
}

/**
 * Implementation of hook_form().
 *
 * Return an array of the form elements needed to edit this node.
 */
function track_form(&$node) {
  $op = isset($_POST['op']) ? $_POST['op'] : '';

  if ($op == t('Preview')) {
   track_validate($node);
  }
  if ($op == t('Submit')) {
   track_validate($node);
  }

  // Set form parameters so we can accept file uploads.
  $form['#attributes'] = array('enctype' => 'multipart/form-data');

  // Title of the track
  $form['title'] = array('#type' => 'textfield', '#title' => t('Title'), '#required' => TRUE, '#default_value' => $node->title, '#weight' => -5);

  // Check if a file exists for the node
  if ($node->file->filepath) {
     $form['title']['#description'] .= t('A file already exists: '.$node->file->filepath);
     $form['current_file'] = array(
       '#type' => 'hidden',
       '#value' => $node->file->filepath
     );
  }
  // file upload field
  $form['file'] = array(
     '#type' => 'file',
     '#title' => t('File').'<span class="form-required" title="This field is required.">*</span>',
     '#size' => 40,
     '#default_value' => '',
     '#weight' => -3,
     '#description' => t('GPX file'),
  );

  $form['body_filter']['body'] = array(
   '#type' => 'textarea',
   '#title' => t('Body'),
   '#default_value' => $node->body,
   '#rows' => 10,
   '#weight' => -2,
   '#required' => TRUE);
  $form['body_filter']['filter'] = filter_form($node->format);

  return $form;
}


function track_form_alter($form_id, &$form) {
}

function file_check_local($source) {
    $file = new StdClass();
    $file->filename = trim(basename($source), '.');
    $file->filepath = $source;
    return $file;
}

function track_validate_file(&$node) {
  $validators = array(
    'file_validate_extensions' => array('gpx'),
  );

  // Check for a new file upload.
  if ($file = file_save_upload('file', $validators, file_directory_path())) {
    file_set_status($file, FILE_STATUS_PERMANENT);

    $node->file = $file;
    $node->current_file = $node->file->filepath;
  }
  else
  {
   $current_file = isset($_POST['edit']['current_file']) ? $_POST['edit']['current_file'] : '';
   if (file_exists($current_file)) {
     $node->file = file_check_local($current_file);
     $node->current_file = $node->file->filepath;
     $file = $node->file;
   }
  }
  return $file;
}

/**
 * Implementation of hook_validate().
 *
 * Verify that there is a file attached to the node.
 */
function track_validate(&$node) {
  $file = track_validate_file($node);
  // Make sure there is an upload or an existing file.
  if (!$file && !file_exists($node->current_file) && !file_exists($node->file->filepath)) {
    form_set_error('file', t('A file must be provided.'));
  }
}

/**
 * Implementation of hook_execute().
 *
 * If a file was uploaded save it before updating the database.
 */
function track_execute(&$node) {
  $file = track_validate_file($node);
  // Make sure there is an upload or an existing file.
  if (!$file && !file_exists($node->current_file)) {
    form_set_error('file', t('A file must be provided.'));
  }
}

/**
 * Implementation of hook_load().
 *
 * The node is being loaded. Load the file's information from the database so
 * it can be added to the node.
 */
function track_load($node) {
  $extras = new StdClass();
  $extras->file = db_fetch_object(db_query('SELECT filename, filepath, '.
  'latstart,lonstart,latmin,latmax,lonmin,lonmax,length,dzminu,dzplus,zmin,zmax'.
  ' FROM {track} WHERE nid = %d', $node->nid));
  return $extras;
}

/**
 * Implementation of hook_insert().
 *
 * The node is being created, save the file's infomation to the database.
 */
function track_insert($node) {
  track_validate($node);
  $file = $node->file;

  $aGPXfile = new GPX_file();
  $aGPXfile->LoadFromFile($file->filepath);
  $aGPXfile->getInfos($latstart,$lonstart,$latmin,$latmax,$lonmin,$lonmax,$length,$dzminu,$dzplus,$zmin,$zmax);

  db_query("INSERT INTO {track} (nid, filename, filepath, ".
  "latstart,lonstart,latmin,latmax,lonmin,lonmax,length,dzminu,dzplus,zmin,zmax".
  ") VALUES (%d, '%s', '%s', %f, %f, %f, %f, %f, %f, %f, %f, %f, %f, %f)",
  $node->nid, $file->filename, $file->filepath,
  $latstart,$lonstart,$latmin,$latmax,$lonmin,$lonmax,$length,$dzminu,$dzplus,$zmin,$zmax
  );
}

/**
 * Implementation of hook_update().
 *
 * The node is being updated, save the updated file's infomation to the database.
 */
function track_update($node) {
  track_validate($node);
  $file = $node->file;

  if ($file->filepath) {
    $aGPXfile = new GPX_file();
    $aGPXfile->LoadFromFile($file->filepath);
    $aGPXfile->getInfos($latstart,$lonstart,$latmin,$latmax,$lonmin,$lonmax,$length,$dzminu,$dzplus,$zmin,$zmax);

    db_query("UPDATE {track} SET filename='%s', filepath='%s',".
    "latstart=%f,lonstart=%f,latmin=%f,latmax=%f,lonmin=%f,lonmax=%f,length=%f,dzminu=%f,dzplus=%f,zmin=%f,zmax=%f".
    "WHERE NID=%d",
    $file->filename, $file->filepath,
    $latstart,$lonstart,$latmin,$latmax,$lonmin,$lonmax,$length,$dzminu,$dzplus,$zmin,$zmax,$node->nid
    );
  }
}

/**
 * Implementation of hook_delete().
 *
 * The node is being delete, remove the file and any information.
 */
function track_delete($node) {
  file_delete($node->filepath);
  db_query("DELETE FROM {track} WHERE nid = %d", $node->nid);
}

//function track_settings() {
//  $form['googlemapskey'] = array(
//    '#type' => 'textfield',
//    '#title' => t('Google Maps key'),
//    '#default_value' => variable_get('googlemapskey', 'AAAAAAAAAAA'),
//    '#size' => 120,
//    '#maxlength' => 255,
//    '#description' => t('Required by Google. ').l(t('You will be able to generate your key here'), 'http://www.google.com/apis/maps/signup.html')
//  );
//
//  return $form;
//}
