Changeset 5633 for extensions/NBC_UserAdvManager/trunk/include

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/include/functions.inc.php (modified) (22 diffs)

extensions/NBC_UserAdvManager/trunk/include/functions.inc.php

@@ -22 +22 @@
 WHERE user_id = '.$id.'
 ;';
-  $data = mysql_fetch_assoc(pwg_query($query));
+  $data = pwg_db_fetch_assoc(pwg_query($query));
 
 /* Check if user is already registered (profile changing) - If not (new registration), language is set to current gallery language */
@@ -166 +166 @@
 WHERE user_id = '.$user_id.'
 ;';
-  $data = mysql_fetch_assoc(pwg_query($query));
+  $data = pwg_db_fetch_assoc(pwg_query($query));
   $language = $data['language'];
   
@@ -265 +265 @@
 WHERE user_id = '.$user_id.'
 ;';
-  $data = mysql_fetch_assoc(pwg_query($query));
+  $data = pwg_db_fetch_assoc(pwg_query($query));
   $language = $data['language'];
 
@@ -320 +320 @@
 WHERE id = '".$id."'
 ;";
-    list($count) = mysql_fetch_row(pwg_query($query));
+    list($count) = pwg_db_fetch_row(pwg_query($query));
 
     if ($count == 0)
@@ -336 +336 @@
   $Confirm_Mail_ID = FindAvailableConfirmMailID();
 
-  list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+  list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
   
   if (isset($Confirm_Mail_ID))
@@ -345 +345 @@
 WHERE user_id = '".$user_id."'
 ;";
-    list($status) = mysql_fetch_row(pwg_query($query));
+    list($status) = pwg_db_fetch_row(pwg_query($query));
     
     $query = "
@@ -399 +399 @@
   $Confirm_Mail_ID = FindAvailableConfirmMailID();
 
-  list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+  list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
   
   if (isset($Confirm_Mail_ID))
@@ -427 +427 @@
   global $conf;
 
-  list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+  list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
 
   $query = "
@@ -474 +474 @@
 WHERE id = '".$id."'
 ;";
-  list($count) = mysql_fetch_row(pwg_query($query));
+  list($count) = pwg_db_fetch_row(pwg_query($query));
 
   if ($count == 1)
@@ -483 +483 @@
 WHERE id = '".$id."'
 ;";
-    $data = mysql_fetch_assoc(pwg_query($query));
+    $data = pwg_db_fetch_assoc(pwg_query($query));
         
     if (!empty($data) and isset($data['user_id']) and !isset($data['date_check']))
@@ -492 +492 @@
 WHERE user_id = '".$data['user_id']."'
 ;";
-      list($registration_date) = mysql_fetch_row(pwg_query($query));
+      list($registration_date) = pwg_db_fetch_row(pwg_query($query));
 
 /*              Time limit process              */
@@ -516 +516 @@
                                         if ($deltadays <= $conf_UAM_ConfirmMail[1]) // If Nb of days is less than the limit set
                                         {
-                                                list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+                                                list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
 
                                                 $query = '
@@ -568 +568 @@
                                 else
                                 {
-                                        list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+                                        list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
 
                                         $query = '
@@ -640 +640 @@
 WHERE user_id = '".$id."'
 ;";
-  list($count) = mysql_fetch_row(pwg_query($query));
+  list($count) = pwg_db_fetch_row(pwg_query($query));
 
   if ($count == 1)
@@ -649 +649 @@
 WHERE user_id = '".$id."'
 ;";
-    $data = mysql_fetch_assoc(pwg_query($query));
+    $data = pwg_db_fetch_assoc(pwg_query($query));
 
     if (!empty($data) and isset($data['user_id']) and !isset($data['date_check']))
     {      
-                        list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+                        list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
 
                         $query = "
@@ -718 +718 @@
 WHERE LOWER(".stripslashes($conf['user_fields']['username']).") = '".strtolower($username)."'
 ;";
-    $users = mysql_num_rows(pwg_query($query));
+    $users = pwg_db_num_rows(pwg_query($query));
     if ($users > 0)
     {
@@ -837 +837 @@
         $result = pwg_query($query);
       
-  while ($row = mysql_fetch_assoc($result))
+  while ($row = pwg_db_fetch_assoc($result))
   {
         $user = $row;
@@ -864 +864 @@
                 $result = pwg_query($query);
         
-    while ($row = mysql_fetch_assoc($result))
+    while ($row = pwg_db_fetch_assoc($result))
     {
         array_push(
@@ -901 +901 @@
         $result = pwg_query($query);
       
-  while ($row = mysql_fetch_assoc($result))
+  while ($row = pwg_db_fetch_assoc($result))
   {
         $user = $row;
@@ -942 +942 @@
         $result = pwg_query($query);
       
-  while ($row = mysql_fetch_assoc($result))
+  while ($row = pwg_db_fetch_assoc($result))
   {
         $user = $row;
@@ -977 +977 @@
 WHERE user_id = '".$id."'
 ;";
-        list($registration_date) = mysql_fetch_row(pwg_query($query));
+        list($registration_date) = pwg_db_fetch_row(pwg_query($query));
 
 /*              Time limit process              */
@@ -1088 +1088 @@
 {
   $query = 'DESC '.$table.';';
-  return (bool)($res=mysql_query($query));
+  return (bool)($res=pwg_query($query));
 }