Changeset 1641 for trunk/include/functions_user.inc.php

Timestamp:

Dec 8, 2006, 12:21:54 AM (17 years ago)

Author:

rvelices

Message:

• remove #user_cache_categories.is_child_date_last
• optimize code in get_icon
• correct css font-wigth:italic to font-style:italic
• aditionnal check on $confauthorize_remembering before allowing auto_login

File:

• trunk/include/functions_user.inc.php (modified) (9 diffs)

trunk/include/functions_user.inc.php

@@ -273 +273 @@
         calculate_permissions($userdata['id'], $userdata['status']);
 
-      update_user_cache_categorie($userdata['id'], $userdata['forbidden_categories']);
+      update_user_cache_categories($userdata['id'], $userdata['forbidden_categories']);
 
       // Set need update are done
@@ -450 +450 @@
 /**
  * compute data of categories branches
- *
- * was internal function of update_user_cache_categorie
- * move to global because function be redeclare when it's internal
  */
 function compute_branch_cat_data(&$cats, &$list_cat_id, &$level, &$ref_level)
@@ -473 +470 @@
       {
         $cats[$cat_id]['max_date_last'] = $date;
-        $cats[$cat_id]['is_child_date_last'] = true;
       }
       else
@@ -495 +491 @@
 
 /**
- * update data of user_cache_categorie
+ * update data of user_cache_categories
  *
  * @param int user_id
  * @return null
  */
-function update_user_cache_categorie($user_id, $user_forbidden_categories)
+function update_user_cache_categories($user_id, $user_forbidden_categories)
 {
   // delete user cache
   $query = '
-  delete from '.USER_CACHE_CATEGORIES_TABLE.'
-  where user_id = '.$user_id.'
+DELETE FROM '.USER_CACHE_CATEGORIES_TABLE.'
+  WHERE user_id = '.$user_id.'
 ;';
   pwg_query($query);
 
   $query = '
-    select
-      id cat_id, date_last,
-      nb_images, global_rank
-    from '.CATEGORIES_TABLE;
+SELECT id cat_id, date_last max_date_last, nb_images count_images, global_rank
+  FROM '.CATEGORIES_TABLE;
   if ($user_forbidden_categories != '')
   {
     $query.= '
-    where id not in ('.$user_forbidden_categories.')';
+    WHERE id NOT IN ('.$user_forbidden_categories.')';
   }
   $query.= ';';
@@ -524 +518 @@
 
   $cats = array();
-  while ($row = mysql_fetch_array($result))
-  {
+  while ($row = mysql_fetch_assoc($result))
+  {
+    $row['user_id'] = $user_id;
+    $row['count_categories'] = 0;
     $cats += array($row['cat_id'] => $row);
   }
@@ -536 +532 @@
   foreach ($cats as $id => $category)
   {
-    // Update field
-    $cats[$id]['user_id'] = $user_id;
-    $cats[$id]['is_child_date_last'] = false;
-    $cats[$id]['max_date_last'] = $cats[$id]['date_last'];
-    $cats[$id]['count_images'] = $cats[$id]['nb_images'];
-    $cats[$id]['count_categories'] = 0;
-
     // Compute
     $level = substr_count($category['global_rank'], '.') + 1;
@@ -559 +548 @@
   $level = 1;
   compute_branch_cat_data($cats, $list_cat_id, $level, $ref_level);
-
-  foreach ($cats as $id => $category)
-  {
-    // Convert field
-    $cats[$id]['is_child_date_last'] = boolean_to_string($cats[$id]['is_child_date_last']);
-  }
 
   include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
@@ -572 +555 @@
     array
     (
-      'user_id', 'cat_id', 
-      'is_child_date_last', 'max_date_last', 
-      'count_images', 'count_categories'
+      'user_id', 'cat_id',
+      'max_date_last', 'count_images', 'count_categories'
     ),
     $cats
@@ -801 +783 @@
   global $conf, $user;
 
-  if ($remember_me)
+  if ($remember_me and $conf['authorize_remembering'])
   {
     $key = calculate_auto_login_key($user_id);