<?
  /* Main include info */
  ini_set('include_path',"/home/tuve/include/");
  include("site.inc");
  include_once('FLV/FLV.php');
  
  $db =  new mysqli ( "SPBX-DB002.SpherePBX.com", "tuve", "5558585", "tuve" );

  if (file_exists("/tmp/cron.php.lock"))
    exit(0);

  system("/usr/bin/touch /tmp/cron.php.lock");
  

  $query = "SELECT vid,file,length,width,height,thumb,thumbFrame,mType,status FROM videos WHERE status != 6 ORDER BY vid";
  $result = mysql_query($query);

  for ($i=0;$i<mysql_numrows($result);$i++) {
    $file = mysql_result($result,$i,'file');
    $len = mysql_result($result,$i,'length');
    $width = mysql_result($result,$i,'width');
    $height = mysql_result($result,$i,'height');
    $thumb  = mysql_result($result,$i,'thumb');
    $thumbFrame = mysql_result($result,$i,'thumbFrame');
    $mType = mysql_result($result,$i,'mType');
    $vid = mysql_result($result,$i,'vid');
    $status = mysql_result($result,$i,'status');

     if ($status == 5) {
       system("/usr/bin/scp www@utopia.ubixonline.com:./$file /media/streams/");
       system("/usr/bin/scp \"/media/streams/$file\" tuploads@tuve.ubixonline.com:.");
       $query = "UPDATE videos SET status = 0 WHERE vid = $vid";
       mysql_query($query);
       }

    if (($len <= 1) || ($width <= 1) || ($height <= 1)) {
      $flv = new FLV();
      print "File: $file\n";
      $meta = array();
      $meta['metadatacreator'] = 'FLV Tools for PHP v0.1 by DrSlump';
      $meta['metadatadate'] = gmdate('Y-m-d\TH:i:s') . '.000Z';
      $meta['keyframes'] = array();
      $meta['keyframes']['filepositions'] = array();
      $meta['keyframes']['times'] = array();
      $skipTagTypes = array();

      $flv->open("/home/tuve/streams/" . $file);

      while ($tag = $flv->getTag( $skipTagTypes )) {
        $ts = number_format($tag->timestamp/1000, 3,'.','');
	    
        if ($tag->timestamp > 0)
          $meta['lasttimestamp'] = $ts;
	    
        switch ($tag->type) {
          case FLV_Tag::TYPE_VIDEO :
            //Optimization, extract the frametype without analyzing the tag body
            if ((ord($tag->body[0]) >> 4) == FLV_Tag_Video::FRAME_KEYFRAME) {
              $meta['keyframes']['filepositions'][] = $flv->getTagOffset();
              $meta['keyframes']['times'][] = $ts;
       	      }
	           	
            if (!in_array(FLV_TAG::TYPE_VIDEO, $skipTagTypes)) {
              $meta['width'] = $tag->width;
              $meta['height'] = $tag->height;
              $meta['videocodecid'] = $tag->codec;                
              array_push($skipTagTypes, FLV_Tag::TYPE_VIDEO);
              }
            break;
          case FLV_Tag::TYPE_AUDIO :
            if ($ts - $oldTs > AUDIO_FRAME_INTERVAL) {
       	      $meta['audioframes']['filepositions'][] = $flv->getTagOffset();
              $meta['audioframes']['times'][] = $ts;
              $oldTs = $ts;
              }
            if (!in_array( FLV_Tag::TYPE_AUDIO, $skipTagTypes))  {
              $meta['audiocodecid'] = $tag->codec;
              $meta['audiofreqid'] = $tag->frequency;
              $meta['audiodepthid'] = $tag->depth;
              $meta['audiomodeid'] = $tag->mode;
              array_push($skipTagTypes, FLV_Tag::TYPE_AUDIO);
              }
            break;
	        case FLV_Tag::TYPE_DATA :
	            if ($tag->name == 'onMetaData')
	            {
	            	$fileMetaPos = $pos;
	            	$fileMetaSize = $tag->size;
	            	$fileMeta = $tag->value;
	            }
	        break;
	    }
	    
	    //Does it actually help with memory allocation?
	    unset($tag);
	}
    $len = $meta['lasttimestamp'];
    $width  = $meta['width'];
    $height = $meta['height'];
    print "Len: $len\nWidth: $width\nHeight: $height\n\n";

    if (($width == "") || ($height == "")) {
      $qry = "UPDATE videos SET length = $len,width = 400,height = 300,mType = 2 WHERE vid = $vid";
      $mType = 2;
      }
    else
      $qry = "UPDATE videos SET length = $len,width = $width,height = $height WHERE vid = $vid";
    print ("$qry:");
    print mysql_query($qry);
    unset($meta);
    unset($skipTagTypes);
    unset($flv);
      }
    if (($thumb == "") || ($thumbFrame == "")) {
      if ($thumbFrame == "")
        $thumbFrame = 1;
      print "File: $file\nThumb: $file.jpg\nthumbFrame: $thumbFrame\n\n";

      if ($mType == 1) {
        $cmd = "/usr/local/bin/ffmpeg -i \"/home/tuve/streams/$file\" -t 0.001 -ss $thumbFrame -vframes 1 -f mjpeg -y /tmp/1.jpg";
        system($cmd);
        $cmd = "/bin/mv /tmp/1.jpg \"/home/tuve/images/$file.jpg\"";
        system($cmd);
        $cmd = "/usr/bin/scp \"/home/tuve/images/$file.jpg\" tuve@creation.ubixonline.com:/usr/web/sites/ubixonline.com/docroot/images/thumbs/";
        system($cmd);
        $thumb = "$file.jpg";
        $query = "UPDATE videos SET thumb = \"http://www.ubixonline.com/images/thumbs/$thumb\",thumbFrame = $thumbFrame WHERE vid = $vid";
        }
      else
        $query = "UPDATE videos SET thumb = \"http://www.ubixonline.com/images/sb/none.gif\",thumbFrame = $thumbFrame WHERE vid = $vid";

      mysql_query($query);
      }
    }

  system("/bin/rm /tmp/cron.php.lock");

?>