source: extensions/edit_gmaps/maintain.inc.php @ 28017

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
if (!defined('EDIT_CL_PATH')) 
define(  'EDIT_CL_PATH',   PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/' );
        include_once(EDIT_CL_PATH.'edit_gmaps.inc.php');

$cl_edit_functions = new cl_edit_functions();

function plugin_install($plugin_id,$plugin_version,&$errors)
{
global $conf ;

 $colonnes=cl_edit_functions::Get_columns_of(IMAGES_TABLE);
 $key = array_search('alt', $colonnes[IMAGES_TABLE]); 
if (!$key){
 $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `alt` DOUBLE(9,6)';
    pwg_query($q);      
    }
    $key = array_search('lon', $colonnes[IMAGES_TABLE]); 
if (!$key){
 $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lon` DOUBLE(9,6)';
    pwg_query($q);      
    }
    $key = array_search('lat', $colonnes[IMAGES_TABLE]); 
if (!$key){
 $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lat` DOUBLE(9,6)';
    pwg_query($q);      
    }
}

function plugin_activate()
{
  $dir_name = basename( dirname(__FILE__) );
  if (!isset($conf['edit_gmaps'])){    
  $q = '
    INSERT INTO '.CONFIG_TABLE.' (param, value, comment)
    VALUES ("edit_gmaps","","Parametres du plugin edit_gmaps")
  ;';
  pwg_query($q);
  }
}

function plugin_deactivate(){ 
  cl_meta_invalidate_cache();
  global $conf;  
  if (isset($conf['edit_gmaps']))  {
    $q = '
      DELETE FROM '.CONFIG_TABLE.'
      WHERE param="edit_gmaps"
    ;';
    pwg_query($q);
    }
}

function plugin_uninstall(){
  global $conf ;
     $q = 'ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `alt`';
    pwg_query( $q );  

  if (!isset($conf['gmaps_api_key'])) 
{  
    $q = 'ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lon`';
  pwg_query( $q );
    $q = 'ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lat`';
  pwg_query( $q );
  }

}
?>