Changeset 5633 for extensions/NBC_UserAdvManager/trunk/admin/UAM_admin.php

Timestamp:

Apr 4, 2010, 4:18:52 PM (14 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager]

• Bug 1571 fixed : Missing translation tag
• Bug 1572 fixed : Fix unable to read resource: "ConfirmMail.tpl"
• Bug 1574 fixed : Beautifying ConfirmMail page. Moved to a "template" folder with css file and icons.

• Bug 1576 partially fixed : Compatibility with other database systems than MySql like PostgreSql or Sqlite. Using Piwigo's pwg_db_### integrated functions. mysql_list_fields() and mysql_num_fields() are not implemented in Piwigo's database functions. This point is still under discuss on FR forum.

File:

• extensions/NBC_UserAdvManager/trunk/admin/UAM_admin.php (modified) (13 diffs)

extensions/NBC_UserAdvManager/trunk/admin/UAM_admin.php

@@ -216 +216 @@
   $result = pwg_query($query);
         
-  while ($row = mysql_fetch_assoc($result))
+  while ($row = pwg_db_fetch_assoc($result))
   {
     $groups[$row['id']] = $row['name'];
@@ -370 +370 @@
                   $result = pwg_query($query);
                         
-                  while($row = mysql_fetch_assoc($result))
+                  while($row = pwg_db_fetch_assoc($result))
                 {
                                 $msg_error1 .= (($msg_error1 <> '') ? '<br/>' : '') . l10n('Err_audit_no_casse').stripslashes($row['username']);
@@ -388 +388 @@
                         $result = pwg_query($query);
                         
-                        while($row = mysql_fetch_assoc($result))
+                        while($row = pwg_db_fetch_assoc($result))
                         {
                                 if (!ValidateUsername(stripslashes($row['username'])))
@@ -407 +407 @@
                   $result = pwg_query($query);
                         
-                  while($row = mysql_fetch_assoc($result))
+                  while($row = pwg_db_fetch_assoc($result))
                   {
                           $conf_MailExclusion = preg_split("/[\s,]+/",$conf_UAM[13]);
@@ -801 +801 @@
 WHERE id = '".$user_id."'
 ;";
-                                        $data = mysql_fetch_assoc(pwg_query($query));
+                                        $data = pwg_db_fetch_assoc(pwg_query($query));
                                 
                 ResendMail2User($typemail,$user_id,stripslashes($data['username']),$data['mail_address'],true);
@@ -886 +886 @@
 ;";
                                         
-                                        $data = mysql_fetch_assoc(pwg_query($query));
+                                        $data = pwg_db_fetch_assoc(pwg_query($query));
                                 
                 ResendMail2User($typemail,$user_id,stripslashes($data['username']),$data['mail_address'],false);                                
@@ -970 +970 @@
 ;";
                                         
-                                        $data = mysql_fetch_assoc(pwg_query($query));
+                                        $data = pwg_db_fetch_assoc(pwg_query($query));
                                 
                 ForceValidation($data['id']);                           
@@ -1001 +1001 @@
                 $result = pwg_query($query);
           
-    while ($row = mysql_fetch_assoc($result))
+    while ($row = pwg_db_fetch_assoc($result))
     {
       $groups[$row['id']] = $row['name'];
@@ -1082 +1082 @@
       $result = pwg_query($query);
       
-      $row = mysql_fetch_assoc($result);
+      $row = pwg_db_fetch_assoc($result);
     
       if (isset($row['reminder']) and $row['reminder'] == 'true')
@@ -1353 +1353 @@
 ;";
                                         
-                                        $data = mysql_fetch_assoc(pwg_query($query));
+                                        $data = pwg_db_fetch_assoc(pwg_query($query));
                                 
                 ghostreminder($user_id,stripslashes($data['username']),$data['mail_address']);                          
@@ -1378 +1378 @@
   FROM '.USER_LASTVISIT_TABLE.';';
 
-        $count = mysql_num_rows(pwg_query($query1));
+        $count = pwg_db_num_rows(pwg_query($query1));
 
         if ($count <> 0)
@@ -1397 +1397 @@
           $result = pwg_query($query);
           
-          while ($row = mysql_fetch_assoc($result))
+          while ($row = pwg_db_fetch_assoc($result))
           {
-            list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+            list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
             
             $query = "
@@ -1424 +1424 @@
           $result = pwg_query($query);
           
-          while($row = mysql_fetch_assoc($result))
+          while($row = pwg_db_fetch_assoc($result))
           {
-            list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+            list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
             
             $query = "