source: extensions/gvideo/admin/add.php @ 19056

<?php
if (!defined('GVIDEO_PATH')) die('Hacking attempt!');

include_once(GVIDEO_PATH.'include/functions.inc.php');
include_once(PHPWG_ROOT_PATH . 'admin/include/functions_upload.inc.php');

if (isset($_POST['add_video']))
{
  // check inputs
  if (empty($_POST['url']))
  {
    array_push($page['errors'], l10n('Please fill the video URL'));
  }
  if ( !empty($_POST['url']) and ($video = parse_video_url($_POST['url'])) === false )
  {
    array_push($page['errors'], l10n('Unable to contact host server'));
  }
  
  if (count($page['errors']) == 0)
  {
    // download thumbnail
    $thumb_name = $video['type'].'-'.$video['video_id'].'-'.uniqid().'.'.get_extension($video['thumbnail']);
    $thumb_source = $conf['data_location'].$thumb_name;
    if (download_remote_file($video['thumbnail'], $thumb_source) !== true)
    {
      $thumb_source = $conf['data_location'].get_filename_wo_extension($thumb_name).'.jpg';
      copy(GVIDEO_PATH.'mimetypes/'.$video['type'].'.jpg', $thumb_source);
    }
    
    if (isset($_POST['add_film_frame']))
    {
      add_film_frame($thumb_source);
    }
    
    // add image and update infos
    $image_id = add_uploaded_file($thumb_source, $thumb_name, array($_POST['category']));
    
    $updates = array(
      'name' => pwg_db_real_escape_string($video['title']),
      'author' => pwg_db_real_escape_string($video['author']),
      'is_gvideo' => 1,
      );
      
    if ( $_POST['sync_description'] and !empty($video['description']) )
    {
      $updates['comment'] = pwg_db_real_escape_string($video['description']);
    }
    if ( $_POST['sync_tags'] and !empty($video['tags']) )
    {
      set_tags(get_tag_ids(implode(',', $video['tags'])), $image_id);
    }
    
    single_update(
      IMAGES_TABLE,
      $updates,
      array('id' => $image_id),
      true
      );
    
    // register video
    if ($_POST['size_common'] == 'true')
    {
      $_POST['width'] = $_POST['height'] = '';
    }
    else if ( !preg_match('#^([0-9]+)$#', $_POST['width']) or !preg_match('#^([0-9]+)$#', $_POST['height']) )
    {
      array_push($page['errors'], l10n('Width and height must be integers'));
      $_POST['width'] = $_POST['height'] = '';
    }
    if ($_POST['autoplay_common'] == 'true')
    {
      $_POST['autoplay'] = '';
    }
    
    $insert = array(
      'picture_id' => $image_id,
      'url' => $video['url'],
      'type' => $video['type'],
      'video_id' => $video['video_id'],
      'width' => $_POST['width'],
      'height' => $_POST['height'],
      'autoplay' => $_POST['autoplay'],
      );
      
    single_insert(
      GVIDEO_TABLE,
      $insert
      );
      
    $query = '
SELECT id, name, permalink
  FROM '.CATEGORIES_TABLE.'
  WHERE id = '.$_POST['category'].'
;';
    $category = pwg_db_fetch_assoc(pwg_query($query));
      
    array_push($page['infos'], sprintf(
      l10n('Video successfully added. <a href="%s">View</a>'), 
      make_picture_url(array(
        'image_id' => $image_id,
        'category' => array(
          'id' => $category['id'],
          'name' => $category['name'],
          'permalink' => $category['permalink'],
          ),
        ))
      ));
    unset($_POST);
  }
}

// categories
$query = '
SELECT id,name,uppercats,global_rank
  FROM '.CATEGORIES_TABLE.'
;';
display_select_cat_wrapper($query, array(), 'category_parent_options');

// upload limit
$upload_max_filesize = min(
  get_ini_size('upload_max_filesize'),
  get_ini_size('post_max_size')
  );
$upload_max_filesize_shorthand = 
  ($upload_max_filesize == get_ini_size('upload_max_filesize')) ?
  get_ini_size('upload_max_filesize', false) :
  get_ini_size('post_max_filesize', false);
  
// template
$template->assign(array(
  'upload_max_filesize' => $upload_max_filesize,
  'upload_max_filesize_shorthand' => $upload_max_filesize_shorthand,
  'gd_available' => function_exists('imagecreatetruecolor'),
  'gvideo' => $conf['gvideo'],
  'POST' => @$_POST,
  ));

$template->set_filename('gvideo_content', dirname(__FILE__) . '/template/add.tpl');

?>