source: extensions/meta/maintain.class.php @ 31925

<?php
// +-----------------------------------------------------------------------+
// | meta plugin for Piwigo                                                |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2008-2016 ddtddt               http://temmii.com/piwigo/ |
// +-----------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or modify  |
// | it under the terms of the GNU General Public License as published by  |
// | the Free Software Foundation                                          |
// |                                                                       |
// | This program is distributed in the hope that it will be useful, but   |
// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
// | General Public License for more details.                              |
// |                                                                       |
// | You should have received a copy of the GNU General Public License     |
// | along with this program; if not, write to the Free Software           |
// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
// | USA.                                                                  |
// +-----------------------------------------------------------------------+

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

class meta_maintain extends PluginMaintain
{
  function install($plugin_version, &$errors=array())
  {
 global $conf, $prefixeTable;
    $q = 'CREATE TABLE ' . $prefixeTable . 'meta(
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaname VARCHAR( 255 ) NOT NULL ,
metaval lONGTEXT NOT NULL ,
metatype VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;';
    pwg_query($q);

    $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (1,"author","","name");';
    pwg_query($q);

    $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (2,"keywords","","name");';
    pwg_query($q);

    $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (3,"Description","","name");';
    pwg_query($q);

    $q = '
INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");';
    pwg_query($q);

    if (!defined('meta_img_TABLE'))
        define('meta_img_TABLE', $prefixeTable . 'meta_img');
    $query = "CREATE TABLE IF NOT EXISTS " . meta_img_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeyimg VARCHAR( 255 ) NOT NULL ,
metadesimg VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);

    if (!defined('meta_cat_TABLE'))
        define('meta_cat_TABLE', $prefixeTable . 'meta_cat');
    $query = "CREATE TABLE IF NOT EXISTS " . meta_cat_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeycat VARCHAR( 255 ) NOT NULL ,
metadescat VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);

    if (!defined('METAPERSO_TABLE'))
        define('METAPERSO_TABLE', $prefixeTable . 'metaperso');
    $query = "CREATE TABLE IF NOT EXISTS " . METAPERSO_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment,
metaname VARCHAR( 255 ) NOT NULL ,
metaval lONGTEXT NOT NULL ,
metatype VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);

    $majm1 = 'meta 2.0.5';
    $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm1 . '",1,"MAJ meta");';
    pwg_query($query);

    $majm2 = 'meta 2.1.0';
    $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm2 . '",1,"MAJ meta");';
    pwg_query($query);

    if (empty($conf['contactmeta'])) {
        conf_update_param('contactmeta', '');
    }

    if (!defined('META_AP_TABLE'))
        define('META_AP_TABLE', $prefixeTable . 'meta_ap');
    $query = "CREATE TABLE IF NOT EXISTS " . META_AP_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeyap VARCHAR( 255 ) NOT NULL ,
metadesap VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);
  }

  function update($old_version, $new_version, &$errors=array())
  {
 global $prefixeTable, $template;
          define('METAPERSO_TABLE', $prefixeTable . 'metaperso');

    $query = "CREATE TABLE IF NOT EXISTS " . METAPERSO_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment,
metaname VARCHAR( 255 ) NOT NULL ,
metaval lONGTEXT NOT NULL ,
metatype VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);

    if (!isset($conf['contactmeta'])) {
        conf_update_param('contactmeta', ',');
    }

    if (!defined('META_AP_TABLE'))
        define('META_AP_TABLE', $prefixeTable . 'meta_ap');
    $query = "CREATE TABLE IF NOT EXISTS " . META_AP_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeyap VARCHAR( 255 ) NOT NULL ,
metadesap VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
    $result = pwg_query($query);

//Gestion MAJ2
    $majm2 = 'meta 2.1.0';
    $query = '
select param,value
        FROM ' . CONFIG_TABLE . '
  WHERE param = \'' . $majm2 . '\'
        ;';
    $result = pwg_query($query);

    $row = pwg_db_fetch_assoc($result);
    $majparam2 = $row['param'];
    $majvalue2 = $row['value'];

    if (!$majvalue2 == 1) {

//Gestion MAJ1
        $majm1 = 'meta 2.0.5';
        $query = '
select param,value
        FROM ' . CONFIG_TABLE . '
  WHERE param = \'' . $majm1 . '\'
        ;';
        $result = pwg_query($query);

        $row = pwg_db_fetch_assoc($result);
        $majparam1 = $row['param'];
        $majvalue1 = $row['value'];

        if (!$majvalue1 == 1) {
            if (!defined('meta_img_TABLE'))
                define('meta_img_TABLE', $prefixeTable . 'meta_img');
            $query = "CREATE TABLE IF NOT EXISTS " . meta_img_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeyimg VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
            $result = pwg_query($query);

            if (!defined('meta_cat_TABLE'))
                define('meta_cat_TABLE', $prefixeTable . 'meta_cat');
            $query = "CREATE TABLE IF NOT EXISTS " . meta_cat_TABLE . " (
id SMALLINT( 5 ) UNSIGNED NOT NULL ,
metaKeycat VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
            $result = pwg_query($query);

            $query = '
select id
  FROM ' . CATEGORIES_TABLE . '
  ORDER BY id DESC;';
            $result = pwg_query($query);
            $row = pwg_db_fetch_assoc($result);

            $comp = $row['id'] + 1;
            $i = 1;

            while ($i < $comp) {
                $query = '
select id,metaKeywords
  FROM ' . CATEGORIES_TABLE . '
  WHERE id = \'' . $i . '\'';
                $result = pwg_query($query);
                $row = pwg_db_fetch_assoc($result);

                if (!$row['id'] == 0 and ! $row['metaKeywords'] == 0) {
                    $query = '
INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES (' . $row['id'] . ',"' . $row['metaKeywords'] . '");';
                    $result = pwg_query($query);
                }
                ++$i;
            }

            $query = ' ALTER TABLE ' . CATEGORIES_TABLE . ' DROP COLUMN `metaKeywords`';
            pwg_query($query);

            $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm1 . '",1,"MAJ meta");';
            pwg_query($query);
            $majvalue1 == 1;
            $maj = 0;
        }

        $q = '
ALTER TABLE ' . meta_cat_TABLE . ' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL ';
        pwg_query($q);

        $q = '
ALTER TABLE ' . meta_img_TABLE . ' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL ';
        pwg_query($q);

        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm2 . '",1,"MAJ meta");';
        pwg_query($query);

        $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl'));

        $majvalue2 == 1;
        $maj = 0;
    }  }

  function uninstall()
  {

    $majm1 = 'meta 2.0.5';
    $majm2 = 'meta 2.1.0';

    global $prefixeTable;

    $q = 'DROP TABLE ' . $prefixeTable . 'meta;';
    pwg_query($q);

    $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="' . $majm1 . '" LIMIT 1;';
    pwg_query($q);

    $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="' . $majm2 . '" LIMIT 1;';
    pwg_query($q);

    $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;';
    pwg_query($q);

    $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;';
    pwg_query($q);

    conf_delete_param('contactmeta');
  }
}