[NBM] Step 4: Screen NBM is available

  o Add news parameters
  o Add file functions_notification_by_mail.inc.php in order to use in future, these functions on php file of subscribe/unsubscribe
  o Write a little html help file

+ improve mass_update in order to used binary fields (used collate and SHOW COLUMNS FROM)
 


git-svn-id: http://piwigo.org/svn/trunk@1105 68402e56-0260-453c-a942-63ccdbb3a9ee

2 files changed, 173 insertions, 1 deletions

diff --git a/admin/include/functions.php b/admin/include/functions.php
index 076c69fb4..4dd2869ef 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -743,7 +743,7 @@ UPDATE '.$tablename.'
   {
     // creation of the temporary table
     $query = '
-DESCRIBE '.$tablename.'
+SHOW FULL COLUMNS FROM '.$tablename.'
 ;';
     $result = pwg_query($query);
     $columns = array();
@@ -762,6 +762,10 @@ DESCRIBE '.$tablename.'
         {
           $column.= " default '".$row['Default']."'";
         }
+        if (isset($row['Collation']))
+        {
+          $column.= " collate '".$row['Collation']."'";
+        }
         array_push($columns, $column);
       }
     }
diff --git a/admin/include/functions_notification_by_mail.inc.php b/admin/include/functions_notification_by_mail.inc.php
new file mode 100644
index 000000000..31753c7de
--- /dev/null
+++ b/admin/include/functions_notification_by_mail.inc.php
@@ -0,0 +1,168 @@
+<?php
+// +-----------------------------------------------------------------------+
+// | PhpWebGallery - a PHP based picture gallery                           |
+// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
+// | Copyright (C) 2003-2006 PhpWebGallery Team - http://phpwebgallery.net |
+// | Copyright (C) 2006 Ruben ARNAUD - team@phpwebgallery.net              |
+// +-----------------------------------------------------------------------+
+// | branch        : BSF (Best So Far)
+// | file          : $RCSfile$
+// | last update   : $Date: 2006-03-23 02:49:04 +0100 (jeu., 23 mars 2006) $
+// | last modifier : $Author: rvelices $
+// | revision      : $Revision: 1094 $
+// +-----------------------------------------------------------------------+
+// | 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.                                                                  |
+// +-----------------------------------------------------------------------+
+
+/*
+ * Search an available check_key
+ *
+ * It's a copy of function find_available_feed_id
+ *
+ * @return string nbm identifier
+ */
+function find_available_check_key()
+{
+  while (true)
+  {
+    $key = generate_key(128);
+    $query = '
+select
+  count(*)
+from
+  '.USER_MAIL_NOTIFICATION_TABLE.'
+where
+  check_key = \''.$key.'\';';
+
+    list($count) = mysql_fetch_row(pwg_query($query));
+    if ($count == 0)
+    {
+      return $key;
+    }
+  }
+}
+
+
+/*
+ * Add quote to all elements of check_key_list
+ *
+ * @return quoted check key list
+ */
+function quote_check_key_list($check_key_list = array())
+{
+  return array_map(create_function('$s', 'return \'\\\'\'.$s.\'\\\'\';'), $check_key_list);
+}
+
+/*
+ * Subscribe or unsubscribe notification by mail
+ *
+ * is_subscribe define if action=subscribe or unsubscribe
+ * check_key list where action will be done
+ *
+ * @return updated data count
+ */
+function do_subscribe_unsubcribe_notification_by_mail($is_subscribe = false, $check_key_list = array())
+{
+  global $page;
+
+  $updated_data_count = 0;
+  if ($is_subscribe)
+  {
+    $msg_info = l10n('nbm_user_change_enabled_true');
+  }
+  else
+  {
+    $msg_info = l10n('nbm_user_change_enabled_false');
+  }
+
+  if (count($check_key_list) != 0)
+  {
+    $quoted_check_key_list = quote_check_key_list($check_key_list);
+
+    $query = '
+select
+  N.check_key, U.username, U.mail_address
+from
+  '.USER_MAIL_NOTIFICATION_TABLE.' as N,
+  '.USERS_TABLE.' as U
+where
+  N.user_id =  U.id and
+  N.enabled = \''.boolean_to_string(!$is_subscribe).'\' and
+  check_key in ('.implode(",", $quoted_check_key_list).')
+order by
+  username;';
+
+    $result = pwg_query($query);
+    if (!empty($result))
+    {
+      $updates = array();
+      $enabled_value = boolean_to_string($is_subscribe);
+
+      while ($row = mysql_fetch_array($result))
+      {
+        array_push
+        (
+          $updates,
+          array
+          (
+            'check_key' => $row['check_key'],
+            'enabled' => $enabled_value
+          )
+        );
+        $updated_data_count += 1;
+        array_push($page['infos'], sprintf($msg_info, $row['username'], $row['mail_address']));
+      }
+
+      mass_updates(
+        USER_MAIL_NOTIFICATION_TABLE,
+        array(
+          'primary' => array('check_key'),
+          'update' => array('enabled')
+        ),
+        $updates
+      );
+    }
+  }
+
+  array_push($page['infos'], sprintf(l10n('nbm_user_change_enabled_updated_data_count'), $updated_data_count));
+
+  return $updated_data_count;
+}
+
+/*
+ * Unsubscribe notification by mail
+ *
+ * check_key list where action will be done
+ *
+ * @return updated data count
+ */
+function unsubcribe_notification_by_mail($check_key_list = array())
+{
+  return do_subscribe_unsubcribe_notification_by_mail(false, $check_key_list);
+}
+
+/*
+ * Subscribe notification by mail
+ *
+ * check_key list where action will be done
+ *
+ * @return updated data count
+ */
+function subcribe_notification_by_mail($check_key_list = array())
+{
+  return do_subscribe_unsubcribe_notification_by_mail(true, $check_key_list);
+}
+
+?>
\ No newline at end of file