source: plugins/blocNotes/_install.php @ 2195

<?php
# ***** BEGIN LICENSE BLOCK *****
#
# This file is part of Bloc-Notes.
# Copyright 2008,2009,2010 Moe (http://gniark.net/)
#
# Bloc-Notes 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; either version 3 of the License, or
# (at your option) any later version.
#
# Bloc-Notes 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, see <http://www.gnu.org/licenses/>.
#
# Icons (*.png) are from Tango Icon theme :
#    http://tango.freedesktop.org/Tango_Icon_Gallery
#
# ***** END LICENSE BLOCK *****

if (!defined('DC_CONTEXT_ADMIN')) {return;}

# On lit la version du plugin
$m_version = $core->plugins->moduleInfo('blocNotes','version');
 
# On lit la version du plugin dans la table des versions
$i_version = $core->getVersion('blocNotes');
 
# La version dans la table est supérieure ou égale à
# celle du module, on ne fait rien puisque celui-ci
# est installé
if (version_compare($i_version,$m_version,'>=')) {
     return;
}

# update the database only if the plugin has already been installed
if ($i_version !== null)
{
     # encode settings to preserve new lines when editing about:config
     if (version_compare($i_version,'1.0.2','<'))
     {
          # per-blog setting
          $rs = $core->con->select('SELECT setting_value, setting_id, blog_id '.
          'FROM '.$core->prefix.'setting '.
          'WHERE setting_ns = \'blocnotes\' '.
          'AND (setting_id = \'blocNotes_text\');');
          
          while($rs->fetch())
          {
               $cur = $core->con->openCursor($core->prefix.'setting');
               $cur->setting_value = base64_encode($rs->setting_value);
               $cur->update('WHERE setting_ns = \'blocnotes\' '.
                    'AND setting_id = \''.$rs->setting_id.'\''.
                    'AND blog_id = \''.$rs->blog_id.'\';');
          }
          
          # users setting (global)
          $rs = $core->con->select('SELECT setting_value, setting_id, blog_id '.
          'FROM '.$core->prefix.'setting '.
          'WHERE setting_ns = \'blocnotes\' '.
          'AND (setting_id LIKE \'blocNotes_text_%\');');
          
          while($rs->fetch())
          {
               $cur = $core->con->openCursor($core->prefix.'setting');
               $cur->setting_value = base64_encode($rs->setting_value);
               $cur->update('WHERE setting_ns = \'blocnotes\' '.
                    'AND setting_id = \''.$rs->setting_id.'\';');
          }
     }
     
     # store users setting in (dc_)user
     if (version_compare($i_version,'1.0.3','<'))
     {
          # users setting (global)
          $rs = $core->con->select('SELECT setting_value, setting_id '.
          'FROM '.$core->prefix.'setting '.
          'WHERE setting_ns = \'blocnotes\' '.
          'AND (setting_id LIKE \'blocNotes_text_%\');');
          
          while($rs->fetch())
          {
               $user_id = str_replace('blocNotes_text_','',$rs->setting_id);
               
               $cur = $core->con->openCursor($core->prefix.'user');
               $cur->blocNotes = base64_decode($rs->setting_value);
               $cur->update('WHERE user_id = \''.$user_id.'\';');
          }
          
          # delete old settings
          $core->con->execute('DELETE FROM '.$core->prefix.'setting '.
               'WHERE setting_ns = \'blocnotes\' '.
               'AND (setting_id LIKE \'blocNotes_text_%\');');
     }

     if (version_compare($i_version,'1.0.4','<'))
     {
          # rename blocNotes field to bloc_notes (fix problem with PostgreSQL)
          if ($core->con->driver() == 'pgsql')
          {
               $core->con->execute('ALTER TABLE '.$core->prefix.'user '.
                    'RENAME COLUMN blocNotes TO bloc_notes;');
          }
          else
          {
               $core->con->execute('ALTER TABLE '.$core->prefix.'user '.
                    'CHANGE blocNotes bloc_notes TEXT;');
          }
     }
}

# table
$s = new dbStruct($core->con,$core->prefix);
 
# add bloc_notes column to (dc_)user 
$s->user
     ->bloc_notes('text',0,true,null)
;

$si = new dbStruct($core->con,$core->prefix);
$changes = $si->synchronize($s);

# La procédure d'installation commence vraiment là
$core->setVersion('blocNotes',$m_version);

return true;
?>