Newer
Older
tuve_scripts / cron.php
@Charlie Root Charlie Root on 27 Mar 2019 5 KB Sync
<?
/* Main include info */
include ("include/config.php");
include_once ('include/FLV/FLV/FLV.php');

define('AUDIO_FRAME_INTERVAL', 3);

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);

$result = $db->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');
 */

while ($qData = $result->fetch_assoc()) {

  if ($qData['status'] == 5) {
    print "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 (($qData['len'] <= 1) || ($qData['width'] <= 1) || ($qData['height'] <= 1)) {
    $flv = new FLV();
    print "File: " . $qData['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/" . $qData['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 = " . $qData['vid'];
      $mType = 2;
    } else
      $qry = "UPDATE videos SET length = $len,width = $width,height = $height WHERE vid = " . $qData['vid'];
    print("$qry:");
    print mysql_query($qry);
    unset($meta);
    unset($skipTagTypes);
    unset($flv);
  }
  if (($qData['thumb'] == "") || ($qData['thumbFrame'] == "")) {
    if ($qData['thumbFrame'] == "")
      $thumbFrame = 1;
    print "File: " . $qData['file'] . "\nThumb: " . $qData['file'] . ".jpg\nthumbFrame: " . $qData['thumbFrame'] . "\n\n";

    if ($mType == 1) {
      $cmd = "/usr/local/bin/ffmpeg -i \"/home/tuve/streams/" . $qData['file'] . "\" -t 0.001 -ss " . $qData['thumbFrame'] . " -vframes 1 -f mjpeg -y /tmp/1.jpg";
      system($cmd);
      $cmd = "/bin/mv /tmp/1.jpg \"/home/tuve/images/" . $qData['file'] . ".jpg\"";
      system($cmd);

      // $cmd = "/usr/bin/scp \"/home/tuve/images/" . $qData['file'] . ".jpg\" tuve@creation.ubixonline.com:/usr/web/sites/ubixonline.com/docroot/images/thumbs/";
      // system($cmd);

      $thumb = $qData['file'] . ".jpg";

      $query = "UPDATE videos SET thumb = \"http://tuve.brainchurts.com/images/thumbs/" . $thumb . "\",thumbFrame = " . $qData['thumbFrame'] . " WHERE vid = " . $qData['vid'];
    } else
      $query = "UPDATE videos SET thumb = \"http://tuve.brainchurts.com/images/sb/none.gif\",thumbFrame = " . $qData['thumbFrame'] . " WHERE vid = " . $qData['vid'];

    // mysql_query($query);
    $db->query($query);
  }
}

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

?>