<?php

function gzdecode($data) {
  $len = strlen($data);
  if ($len < 18 || strcmp(substr($data,0,2),"\x1f\x8b")) {
    return null;  // Not GZIP format (See RFC 1952)
  }
  $method = ord(substr($data,2,1));  // Compression method
  $flags  = ord(substr($data,3,1));  // Flags
  if ($flags & 31 != $flags) {
    // Reserved bits are set -- NOT ALLOWED by RFC 1952
    return null;
  }
  // NOTE: $mtime may be negative (PHP integer limitations)
  $mtime = unpack("V", substr($data,4,4));
  $mtime = $mtime[1];
  $xfl   = substr($data,8,1);
  $os    = substr($data,8,1);
  $headerlen = 10;
  $extralen  = 0;
  $extra     = "";
  if ($flags & 4) {
    // 2-byte length prefixed EXTRA data in header
    if ($len - $headerlen - 2 < 8) {
      return false;    // Invalid format
    }
    $extralen = unpack("v",substr($data,8,2));
    $extralen = $extralen[1];
    if ($len - $headerlen - 2 - $extralen < 8) {
      return false;    // Invalid format
    }
    $extra = substr($data,10,$extralen);
    $headerlen += 2 + $extralen;
  }

  $filenamelen = 0;
  $filename = "";
  if ($flags & 8) {
    // C-style string file NAME data in header
    if ($len - $headerlen - 1 < 8) {
      return false;    // Invalid format
    }
    $filenamelen = strpos(substr($data,8+$extralen),chr(0));
    if ($filenamelen === false || $len - $headerlen - $filenamelen - 1 < 8) {
      return false;    // Invalid format
    }
    $filename = substr($data,$headerlen,$filenamelen);
    $headerlen += $filenamelen + 1;
  }

  $commentlen = 0;
  $comment = "";
  if ($flags & 16) {
    // C-style string COMMENT data in header
    if ($len - $headerlen - 1 < 8) {
      return false;    // Invalid format
    }
    $commentlen = strpos(substr($data,8+$extralen+$filenamelen),chr(0));
    if ($commentlen === false || $len - $headerlen - $commentlen - 1 < 8) {
      return false;    // Invalid header format
    }
    $comment = substr($data,$headerlen,$commentlen);
    $headerlen += $commentlen + 1;
  }

  $headercrc = "";
  if ($flags & 2) {
    // 2-bytes (lowest order) of CRC32 on header present
    if ($len - $headerlen - 2 < 8) {
      return false;    // Invalid format
    }
    $calccrc = crc32(substr($data,0,$headerlen)) & 0xffff;
    $headercrc = unpack("v", substr($data,$headerlen,2));
    $headercrc = $headercrc[1];
    if ($headercrc != $calccrc) {
      return false;    // Bad header CRC
    }
    $headerlen += 2;
  }

  // GZIP FOOTER - These be negative due to PHP's limitations
  $datacrc = unpack("V",substr($data,-8,4));
  $datacrc = $datacrc[1];
  $isize = unpack("V",substr($data,-4));
  $isize = $isize[1];

  // Perform the decompression:
  $bodylen = $len-$headerlen-8;
  if ($bodylen < 1) {
    // This should never happen - IMPLEMENTATION BUG!
    return null;
  }
  $body = substr($data,$headerlen,$bodylen);
  $data = "";
  if ($bodylen > 0) {
    switch ($method) {
      case 8:
        // Currently the only supported compression method:
        $data = gzinflate($body);
        break;
      default:
        // Unknown compression method
        return false;
    }
  } else {
    // I'm not sure if zero-byte body content is allowed.
    // Allow it for now...  Do nothing...
  }

  // Verifiy decompressed size and CRC32:
  // NOTE: This may fail with large data sizes depending on how
  //       PHP's integer limitations affect strlen() since $isize
  //       may be negative for large sizes.
  if ($isize != strlen($data) || crc32($data) != $datacrc) {
    // Bad format!  Length or CRC doesn't match!
    return false;
  }
  return $data;
}

include_once("./scrape/http_get.php");
include_once("./scrape/substring.php");


date_default_timezone_set('GMT');
//include_once("http_get.php");
//$page =  http_get('http://www.fairhavens.org.uk/default.asp?id=724');
$dbh=mysql_pconnect ("dbname", "username", "pass")or die ("
	
");
mysql_select_db ("dbname");
mysql_query("SET NAMES 'latin1'");

$sql = "SELECT name,password from garmin_user_data where userid = 1200160";

$result = mysql_fetch_array(mysql_query($sql));



$request = http_get("http://connect.garmin.com/feed/rss/activities?feedname=feedname&owner=nellylock");
$array = simplexml_load_string( $request, 'SimpleXMLElement', LIBXML_NOCDATA);



foreach($array->channel->item as $activity){
print("<pre>");
$link = $activity->{'link'};
$link_breakdown = explode("/",$link);
$activity_id = end($link_breakdown);
$description = (String)($activity->{'description'});
//echo $description;


$sql = 
		"INSERT INTO garmin_activity_data_min 							(`activityID`,`activityName`,`userId`,`device`,`activityType`,`sumEnergy`,`maxSpeed`,`beginTimestamp`,`sumDuration`,`sumDistance`, `beginLongitude`,`beginLatitude`)
		Values
		('".$activity_id."','".$activity->{'title'}."','1200160','".$array_x->{'Activities'}->{'Activity'}->{'Creator'}->{'Name'}."','".$activity->{'category'}->{0}."','".$data->{'sumEnergy'}->{'display'}."','".$data->{'maxSpeed'}->{'display'}."','".$activity->{'pubDate'}."','','".$array_x->{'Activities'}->{'Activity'}->{'Lap'}->{0}->{'DistanceMeters'}."','".$data->{'beginLongitude'}->{'display'}."','".$data->{'beginLatitude'}->{'display'}."');";

echo $sql;
if(mysql_query($sql)){
		echo "success";
		}
		else{
			
		}

}


exit;

//print_r($array);
?>

<div style="background:#acd7fc; border:1px solid #3399CC;padding:10px;">
<h2 style="margin:0; padding:0;">Loading Garmin Data</h2>
<?
$howmany_qry = "Select * from garmin_activity_data_min where userid = 1200160;";
$howmanyqry = mysql_query($howmany_qry);
?>
<b>Results already in system: </b><?=mysql_num_rows($howmanyqry);?><br/>
<?
foreach($array->results->activities as $activity){
	foreach ($activity as $data){
		
		
		
		
		
		
		$sql = 
		"INSERT INTO garmin_activity_data_min 							(`activityID`,`activityName`,`userId`,`device`,`activityType`,`sumEnergy`,`maxSpeed`,`beginTimestamp`,`sumDuration`,`sumDistance`, `beginLongitude`,`beginLatitude`)
		Values
		('".$data->{'activityId'}."','".$data->{'activityName'}->{'value'}."','".$data->{'userId'}."','".$data->{'device'}->{'display'}."','".$data->{'activityType'}->{'display'}."','".$data->{'sumEnergy'}->{'display'}."','".$data->{'maxSpeed'}->{'display'}."','".$data->{'beginTimestamp'}->{'disp
		lay'}."','".$data->{'sumDuration'}->{'display'}."','".$data->{'sumDistance'}->{'display'}."','".$data->{'beginLongitude'}->{'display'}."','".$data->{'beginLatitude'}->{'display'}."');";
		
		if(mysql_query($sql)){
		
		}
		else{
			
		}
		

}
}

$howmany_qry = "Select * from garmin_activity_data_min where userid = 1380644;";
$howmany_afterqry = mysql_query($howmany_qry);
?>
<b>Results now in system: </b><?=mysql_num_rows($howmany_afterqry);?><br/><br/>
<b>New into the system: </b><? if((mysql_num_rows($howmany_afterqry) - mysql_num_rows($howmanyqry)) >0) echo (mysql_num_rows($howmany_afterqry) - mysql_num_rows($howmanyqry)); else echo '0' ;?><br/>


</div>