source: extensions/piclens/maintain.inc.php @ 17809

<?php
/*
 * Plugin Name: CoolIris-Piclens
 * File :  maintain.inc.php  
 */

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');


function plugin_install()
{
}

function plugin_activate()
{


  // Check if upgrade is needed
        $query = '
          SELECT value
          FROM '.CONFIG_TABLE.'
          WHERE param = \''.basename(dirname(__FILE__)).'\'
        ;';
        $result = pwg_query($query);

        if($result) 
        {
                 $row = mysql_fetch_row($result);
                 if(is_string($row[0])) 
                 {
                        $row = unserialize($row[0]);
                        if (!isset($row['piclens_rss_name']))   // name and desc format changed from 0.3.x --> 0.4.x 
                                upgrade_piclens_from_03x($row);                 
                 }
        }

}

function plugin_uninstall()
{

        $query = '
      DELETE FROM '.CONFIG_TABLE.'
          WHERE param = \''.basename(dirname(__FILE__)).'\'
        ;';

        pwg_query($query);

}

function upgrade_piclens_from_03x($row)
{
        $piclens_rss_name = '';
        $piclens_rss_desc = '';

        if (isset($row['piclens_name_image']) and $row['piclens_name_image'] != 4)      // old name format
        {
                if ($row['piclens_cat_view'])           // View cat active
                        $piclens_rss_name .= "%C2 - ";
                switch($row['piclens_name_image'])
                {
                        case 2 : $piclens_rss_name .= "%IC";
                                break;
                        case 3 : $piclens_rss_name .= "%I2";
                                break;
                        default : $piclens_rss_name .= "%IC";
                                break;
                }
                
        }
        if (isset($row['piclens_name_desc']))   // old description format
        {
                switch($row['piclens_name_desc'])
                {
                        case 2 : $piclens_rss_desc .= "%I2";
                                break;
                        case 3 : $piclens_rss_desc .= "%I3";
                                break;
                        default :
                                break;
                }
        }
        // New format for name and desc in database
        $row['piclens_rss_name'] = $piclens_rss_name;
        $row['piclens_rss_desc'] = $piclens_rss_desc;
        
        $query = '
          REPLACE INTO '.CONFIG_TABLE.'
          VALUES(
                \''.basename(dirname(__FILE__)).'\',
                \''.serialize($row).'\',
                \'Configuration de Piclens\')
        ;';

        pwg_query($query);

}


?>