source: extensions/manage_info_photos/maintain.class.php @ 30672

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

class manage_info_photos_maintain extends PluginMaintain
{
  private $installed = false;

  function __construct($plugin_id){
    parent::__construct($plugin_id);
  }

  function install($plugin_version, &$errors=array()){
       global $prefixeTable;

if (!defined('ADD_INFO_PHOTO_TABLE')) define('ADD_INFO_PHOTO_TABLE', $prefixeTable.'add_Info_photos');
        $query = "CREATE TABLE IF NOT EXISTS ". ADD_INFO_PHOTO_TABLE ." (
id_info_pho SMALLINT(5) UNSIGNED NOT NULL auto_increment,
designation VARCHAR(255) NOT NULL ,
orderinfo SMALLINT(5) UNSIGNED NOT NULL ,
active SMALLINT(5) UNSIGNED NOT NULL ,
edit SMALLINT(5) UNSIGNED NOT NULL ,
PRIMARY KEY (id_info_pho))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);

if (!defined('ADD_INFO_PHOTO_DATA_TABLE')) define('ADD_INFO_PHOTO_DATA_TABLE', $prefixeTable.'add_Info_photos_data');
        $query = "CREATE TABLE IF NOT EXISTS ". ADD_INFO_PHOTO_DATA_TABLE ." (
id_img SMALLINT(5) UNSIGNED NOT NULL ,
id_info_pho SMALLINT(5) UNSIGNED NOT NULL ,
data VARCHAR(255) NOT NULL ,
PRIMARY KEY (id_img,id_info_pho))DEFAULT CHARSET=utf8;";
        $result = pwg_query($query);
        
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (1,"author",1,0,0);';
    pwg_query($q);
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (2,"Created on",2,0,0);';
    pwg_query($q);
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (3,"Posted on",3,0,0);';
    pwg_query($q);
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (4,"Dimensions",4,0,0);';
    pwg_query($q);    
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (5,"File",5,0,0);';
    pwg_query($q);          
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (6,"Filesize",6,0,0);';
    pwg_query($q);
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (7,"Tags",7,0,0);';
    pwg_query($q);   
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (8,"Albums",8,0,0);';
    pwg_query($q);      
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (9,"Visits",9,0,0);';
    pwg_query($q);       
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (10,"Average",10,0,0);';
    pwg_query($q);
$q = 'INSERT INTO ' . $prefixeTable . 'Add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (11,"Who can see this photo?",11,0,0);';
    pwg_query($q); 
    
  }

  function activate($plugin_version, &$errors=array()){
  
  }

  function update($old_version, $new_version, &$errors=array()){
    global $conf;
    if (!isset($conf['Add_Info_photos'])) {
        conf_update_param('Add_Info_photos','Categories',true);
    }
  }
  
  function deactivate(){
  }

  function uninstall(){
    conf_delete_param('Add_Info_photos');
    $q = 'DROP TABLE ' . $prefixeTable . 'add_Info_photos;';
    pwg_query($q);
    $q = 'DROP TABLE ' . $prefixeTable . 'add_Info_photos_data;';
    pwg_query($q);
  }
}
?>