Changeset 20545

Timestamp:

Feb 4, 2013, 2:04:42 PM (11 years ago)

Author:

plg

Message:

feature 65: fetch_assoc behaves different with mysql and mysqli. When no row
is returned, mysql returns bool:false, while mysqli returns null and it was
breaking completely the installation process. I have faked the old mysql
behavior with mysqli (just for get_default_user_infos function)

File:

• trunk/include/functions_user.inc.php (modified) (1 diff)

trunk/include/functions_user.inc.php

@@ -809 +809 @@
   if (!isset($cache['default_user']))
   {
-    $query = 'SELECT * FROM '.USER_INFOS_TABLE.
-            ' WHERE user_id = '.$conf['default_user_id'].';';
+    $query = '
+SELECT *
+  FROM '.USER_INFOS_TABLE.'
+  WHERE user_id = '.$conf['default_user_id'].'
+;';
 
     $result = pwg_query($query);
-    $cache['default_user'] = pwg_db_fetch_assoc($result);
-
-    if ($cache['default_user'] !== false)
-    {
+
+    if (pwg_db_num_rows($result) > 0)
+    {
+      $cache['default_user'] = pwg_db_fetch_assoc($result);
+      
       unset($cache['default_user']['user_id']);
       unset($cache['default_user']['status']);
       unset($cache['default_user']['registration_date']);
+    }
+    else
+    {
+      $cache['default_user'] = false;
     }
   }