[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

1 files changed, 5 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);
       }
     }