Changeset 27697 for extensions/AddUsersNotes/maintain.inc.php

Timestamp:

Mar 11, 2014, 11:25:49 PM (10 years ago)

Author:

plg

Message:

compatibility with Piwigo 2.6 new user manager

relies on a new trigger ws_users_getList (for Piwigo 2.6.2)

Replace table piwigo_user_notes by column piwigo_user_infos.usernotes (simpler
coding for the plugin and automatic management of column in user manager table)

File:

• extensions/AddUsersNotes/maintain.inc.php (modified) (1 diff)

extensions/AddUsersNotes/maintain.inc.php

@@ -1 +1 @@
 <?php
-
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
-function plugin_install()
+class AddUsersNotes_maintain extends PluginMaintain
 {
+  private $installed = false;
+
+  function __construct($plugin_id)
+  {
+    parent::__construct($plugin_id);
+  }
+
+  function install($plugin_version, &$errors=array())
+  {
     global $prefixeTable;
+    
+    // add a new column to existing table
+    $result = pwg_query('SHOW COLUMNS FROM `'.USER_INFOS_TABLE.'` LIKE "usernotes";');
+    if (!pwg_db_num_rows($result))
+    {
+      pwg_query('ALTER TABLE `' . USER_INFOS_TABLE . '` ADD `usernotes` VARCHAR(255) DEFAULT NULL;');
+    }
 
-if (!defined('USERNOTES_TABLE')) define('USERNOTES_TABLE', $prefixeTable.'user_notes');
-        $query = "CREATE TABLE IF NOT EXISTS ". USERNOTES_TABLE ." (
-user_id SMALLINT( 5 ) UNSIGNED NOT NULL ,
-note VARCHAR( 255 ) NOT NULL ,
-PRIMARY KEY (user_id))DEFAULT CHARSET=utf8;";
-        $result = pwg_query($query);
-        
+    // if we find the old table, we copy notes
+    $result = pwg_query('SHOW TABLES LIKE "'.$prefixeTable.'user_notes";');
+    if (pwg_db_num_rows($result))
+    {
+      $query = '
+UPDATE
+    '.USER_INFOS_TABLE.' AS ui,
+    '.$prefixeTable.'user_notes AS un
+  SET ui.usernotes = un.note
+  WHERE ui.user_id = un.user_id
+    AND LENGTH(note) > 0
+;';
+      pwg_query($query);
+
+      pwg_query('DROP TABLE '.$prefixeTable.'user_notes;');
+    }
+    
+    $this->installed = true;
+  }
+
+  function activate($plugin_version, &$errors=array())
+  {
+    if (!$this->installed)
+    {
+      $this->install($plugin_version, $errors);
+    }
+  }
+
+  function deactivate()
+  {
+  }
+
+  function uninstall()
+  {
+    pwg_query('ALTER TABLE `'. USER_INFOS_TABLE .'` DROP `usernotes`;');
+  }
 }
-
-function plugin_uninstall()
-{
-        global $prefixeTable;
-
-        $q = 'DROP TABLE ' . $prefixeTable . 'user_notes;';
-    pwg_query($q);
-}
-
-
 ?>