Changeset 26470 for extensions/gvideo/maintain.inc.php

Timestamp:

Jan 6, 2014, 4:41:55 PM (10 years ago)

Author:

mistic100

Message:

Update for Piwigo 2.6
TODO: button on Admin Tools bar

File:

• extensions/gvideo/maintain.inc.php (modified) (1 diff)

extensions/gvideo/maintain.inc.php

@@ -1 +1 @@
 <?php
-if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
-
-defined('GVIDEO_ID') or define('GVIDEO_ID', basename(dirname(__FILE__)));
-include_once(PHPWG_PLUGINS_PATH . GVIDEO_ID . '/include/install.inc.php');
-
-
-/* install */
-function plugin_install() 
+defined('PHPWG_ROOT_PATH') or die('Hacking attempt!');
+
+class gvideo_maintain extends PluginMaintain
 {
-  gvideo_install();
+  private $installed = false;
   
-  define('gvideo_installed', true);
+  private $default_conf = array(
+    'autoplay' => 0,
+    'width' => 640,
+    'height' => 360,
+    'sync_description' => 1,
+    'sync_tags' => 1,
+    'vimeo' => array(
+      'title' => 1,
+      'portrait' => 1,
+      'byline' => 1,
+      'color' => '00adef',
+      ),
+    'dailymotion' => array(
+      'logo' => 1,
+      'title' => 1,
+      'color' => 'F7FFFD',
+      ),
+    'youtube' => array(),
+    'wat' => array(),
+    'wideo' => array(),
+    );
+    
+  private $table;
+  
+  function __construct($plugin_id)
+  {
+    global $prefixeTable;
+    
+    parent::__construct($plugin_id);
+    
+    $this->table = $prefixeTable . 'image_video';
+  }
+
+  function install($plugin_version, &$errors=array())
+  {
+    global $conf;
+
+    // add config parameter
+    if (empty($conf['gvideo']))
+    {
+      $conf['gvideo'] = serialize($this->default_conf);
+      conf_update_param('gvideo', $conf['gvideo']);
+    }
+    else
+    {
+      $old_conf = is_string($conf['gvideo']) ? unserialize($conf['gvideo']) : $conf['gvideo'];
+
+      if (!isset($old_conf['sync_description']))
+      {
+        $old_conf['sync_description'] = 1;
+        $old_conf['sync_tags'] = 1;
+        
+        $conf['gvideo'] = serialize($old_conf);
+        conf_update_param('gvideo', $conf['gvideo']);
+      }
+    }
+
+    // create table
+  $query = '
+CREATE TABLE IF NOT EXISTS `' . $this->table . '` (
+  `picture_id` mediumint(8) NOT NULL,
+  `url` varchar(255) DEFAULT NULL,
+  `type` varchar(64) NOT NULL,
+  `video_id` varchar(128) NOT NULL,
+  `width` smallint(9) DEFAULT NULL,
+  `height` smallint(9) DEFAULT NULL,
+  `autoplay` tinyint(1) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
+;';
+    pwg_query($query);
+    
+    // update video_id lenght
+    $query = 'ALTER TABLE `' . $this->table . '` CHANGE `video_id` `video_id` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;';
+    pwg_query($query);
+    
+    // new collumn in images table
+    $result = pwg_query('SHOW COLUMNS FROM `' . IMAGES_TABLE . '` LIKE "is_gvideo";');
+    if (!pwg_db_num_rows($result))
+    {
+      pwg_query('ALTER TABLE `' . IMAGES_TABLE . '` ADD `is_gvideo` TINYINT(1) NOT NULL DEFAULT 0;');
+      
+      $query = '
+UPDATE `' . IMAGES_TABLE . '`
+  SET is_gvideo = 1
+  WHERE id IN(
+    SELECT picture_id FROM `' . $this->table . '`
+    )
+;';
+      pwg_query($query);
+    }
+    
+    // remove old configuration
+    if (isset($conf['PY_GVideo']))
+    {
+      conf_delete_param('PY_GVideo');
+    }
+    
+    // updade video files
+    $this->update_24();
+
+    $this->installed = true;
+  }
+
+  function activate($plugin_version, &$errors=array())
+  {
+    if (!$this->installed)
+    {
+      $this->install($plugin_version, $errors);
+    }
+  }
+
+  function deactivate()
+  {
+  }
+
+  function uninstall()
+  {
+    conf_delete_param('gvideo');
+
+    pwg_query('DROP TABLE `' . $this->table . '`;');
+
+    pwg_query('ALTER TABLE `'. IMAGES_TABLE .'` DROP `is_gvideo`;');
+  }
+  
+  /**
+   * update from 2.3 to 2.4
+   */
+  function update_24()
+  {
+    global $conf;
+    
+    // search existing videos
+  $query = '
+SELECT *
+  FROM '.IMAGES_TABLE.'
+  WHERE
+    file LIKE "%.gvideo"
+    OR file LIKE "%.dm"
+    OR file LIKE "%.ytube"
+    OR file LIKE "%.wideo"
+    OR file LIKE "%.vimeo"
+    OR file LIKE "%.wat"
+;';
+    $result = pwg_query($query);
+    
+    if (!pwg_db_num_rows($result))
+    {
+      return;
+    }
+    
+    if (!isset($conf['prefix_thumbnail']))
+    {
+      $conf['prefix_thumbnail'] = 'TN-';
+    }
+
+    if (!isset($conf['dir_thumbnail']))
+    {
+      $conf['dir_thumbnail'] = 'thumbnail';
+    }
+    
+    set_time_limit(600);
+    include_once(gvideo_path . 'include/functions.inc.php');
+    include_once(PHPWG_ROOT_PATH . 'admin/include/functions_upload.inc.php');
+    
+    $videos_inserts = array();
+    $images_updates = array();
+    $images_delete = array();
+    
+    while ($img = pwg_db_fetch_assoc($result))
+    {
+      $file_content = file_get_contents($img['path']);
+      list($file['id'], $file['height'], $file['width'], ) = explode('/', $file_content);
+      $file['type'] = get_extension($img['path']);
+      
+      switch ($file['type'])
+      {
+        case 'vimeo':
+          $video = array(
+            'type' => 'vimeo',
+            'url' => 'http://vimeo.com/'.$file['id'],
+            );
+          break;
+        case 'dm':
+          $video = array(
+            'type' => 'dailymotion',
+            'url' => 'http://dailymotion.com/video/'.$file['id'],
+            );
+          break;
+        case 'ytube':
+          $video = array(
+            'type' => 'youtube',
+            'url' => 'http://youtube.com/watch?v='.$file['id'],
+            );
+          break;
+        case 'wideo':
+          $video = array(
+            'type' => 'wideo',
+            'url' => 'http://wideo.fr/video/'.$file['id'].'.html',
+            );
+          break;
+        case 'wat':
+          $video = array(
+            'type' => 'wat',
+            'url' => null,
+            );
+          break;
+        case 'gvideo': // closed
+        default:
+          $images_delete[] = $img['id'];
+          continue;
+      }
+      
+      $real_path = str_replace($img['file'], null, str_replace('././', './', $img['path']));
+      
+      // get existing thumbnail
+      $thumb = $real_path.$conf['dir_thumbnail'].'/'.$conf['prefix_thumbnail'].get_filename_wo_extension($img['file']).'.*';
+      $thumb = glob($thumb);
+      if (!empty($thumb))
+      {
+        $thumb_name = $video['type'].'-'.$file['id'].'-'.uniqid().'.'.get_extension($thumb[0]);
+        $thumb_source = $conf['data_location'].$thumb_name;
+        copy($thumb[0], $thumb_source);
+      }
+      else
+      {
+        $thumb_name = $video['type'].'-'.$file['id'].'-'.uniqid().'.jpg';
+        $thumb_source = $conf['data_location'].$thumb_name;
+        copy(gvideo_path.'mimetypes/'.$video['type'].'.jpg', $thumb_source);
+        add_film_frame($thumb_source);
+      }
+      
+      // update element
+      $image_id = add_uploaded_file($thumb_source, $thumb_name, null, null, $img['id']);
+      
+      // update path and rename the file
+      $img['new_path'] = $real_path.$thumb_name;
+      rename($img['path'], $img['new_path']); // why ? what's the purpose of this line ?
+      
+      $images_updates[] = array(
+        'id' => $img['id'],
+        'path' => $img['new_path'],
+        'is_gvideo' => 1,
+        );
+      
+      if (empty($file['width'])) $file['width'] = '';
+      if (empty($file['height'])) $file['height'] = '';
+      
+      // register video    
+      $videos_inserts[] = array(
+        'picture_id' => $image_id,
+        'url' => $video['url'],
+        'type' => $video['type'],
+        'video_id' => $file['id'],
+        'width' => $file['width'],
+        'height' => $file['height'],
+        'autoplay' => '',
+        );
+        
+      unset($thumb_source, $thumb_name, $file, $video, $url);
+    }
+    
+    // delete obsolete elements
+    delete_elements($images_delete);
+    
+    // registers videos
+    mass_inserts(
+      gvideo_table,
+      array('picture_id', 'url', 'type', 'video_id', 'width', 'height', 'autoplay'),
+      $videos_inserts
+      );
+      
+    // update images
+    mass_updates(
+      IMAGES_TABLE,
+      array('primary'=>array('id'), 'update'=>array('path', 'is_gvideo')),
+      $images_updates
+      );
+  }
 }
-
-/* activate */
-function plugin_activate()
-{
-  if (!defined('gvideo_installed'))
-  {
-    gvideo_install();
-  }
-}
-
-/* uninstall */
-function plugin_uninstall() 
-{
-  global $prefixeTable;
-  
-  pwg_query('DELETE FROM `'. CONFIG_TABLE .'` WHERE param = "gvideo" LIMIT 1;');
-  pwg_query('DROP TABLE `'.$prefixeTable.'image_video`;');
-  pwg_query('ALTER TABLE `' . IMAGES_TABLE . '` DROP `is_gvideo`;');
-}
-
-?>