source: extensions/UserCollections/maintain.class.php @ 29056

<?php
defined('PHPWG_ROOT_PATH') or die('Hacking attempt!');

class UserCollections_maintain extends PluginMaintain
{
  private $collections;
  private $collection_images;
  private $collection_shares;
  
  private $default_conf = array(
    'allow_mails' => true,
    'allow_public' => true,
    );
  
  function __construct($id)
  {
    global $prefixeTable;
    
    parent::__construct($id);
    $this->collections = $prefixeTable . 'collections';
    $this->collection_images = $prefixeTable . 'collection_images';
    $this->collection_shares = $prefixeTable . 'collection_shares';
  }
  
  function install($plugin_version, &$errors=array())
  {
    global $conf, $prefixeTable;

    if (empty($conf['user_collections']))
    {
      conf_update_param('user_collections', $this->default_conf, true);
    }

    // create tables
    $query = '
CREATE TABLE IF NOT EXISTS `' . $this->collections . '` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `user_id` smallint(5) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `date_creation` datetime NOT NULL,
  `comment` text NULL,
  `nb_images` mediumint(8) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;';
    pwg_query($query);

    $query = '
CREATE TABLE IF NOT EXISTS `' . $this->collection_images . '` (
  `col_id` mediumint(8) NOT NULL,
  `image_id` mediumint(8) NOT NULL,
  `add_date` datetime NULL,
  UNIQUE KEY `UNIQUE` (`col_id`,`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;';
    pwg_query($query);

    $query = '
CREATE TABLE IF NOT EXISTS `' . $this->collection_shares . '` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `col_id` mediumint(8) NOT NULL,
  `share_key` varchar(64) NOT NULL,
  `params` text NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `share_key` (`share_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;';
    pwg_query($query);


    // version 2.0.0
    $result = pwg_query('SHOW COLUMNS FROM `' . $this->collection_images . '` LIKE "add_date";');
    if (!pwg_db_num_rows($result))
    {
      pwg_query('ALTER TABLE `' . $this->collection_images . '` ADD `add_date` datetime NULL;');
    }

    $result = pwg_query('SHOW COLUMNS FROM `' . $this->collections . '` LIKE "comment";');
    if (!pwg_db_num_rows($result))
    {
      pwg_query('ALTER TABLE `' . $this->collections . '` ADD `comment` text NULL;');
      pwg_query('ALTER TABLE `' . $this->collections . '` DROP `active`;');
    }

    // version 2.1.0
    $result = pwg_query('SHOW COLUMNS FROM `' . $this->collections . '` LIKE "public";');
    if (pwg_db_num_rows($result))
    {
      $now = date('Y-m-d H:i:s');

      $query = '
SELECT id, public_id
  FROM `' . $this->collections . '`
  WHERE public = 1
;';
      $result = pwg_query($query);

      $inserts = array();
      while ($row = pwg_db_fetch_assoc($result))
      {
        $inserts[] = array(
          'col_id' => $row['id'],
          'share_key' => $row['public_id'],
          'params' => serialize(array('password'=>'','deadline'=>'')),
          'add_date' => $now,
          );
      }

      mass_inserts($this->collection_shares,
        array('col_id','share_key','params','add_date'),
        $inserts
        );

      pwg_query('ALTER TABLE `' . $this->collections . '` DROP `public`, DROP `public_id`;');
    }
  }

  function update($old_version, $new_version, &$errors=array())
  {
    $this->install($new_version, $errors);
  }

  function uninstall()
  {
    conf_delete_param('user_collections');

    pwg_query('DROP TABLE IF EXISTS `' . $this->collections . '`;');
    pwg_query('DROP TABLE IF EXISTS `' . $this->collection_images . '`;');
    pwg_query('DROP TABLE IF EXISTS `' . $this->collection_shares . '`;');
  }
}