Changeset 602 for trunk/include

Timestamp:

Nov 13, 2004, 2:43:53 PM (20 years ago)

Author:

plg

Message:

• admin/cat_options page added : manage options for the whole categories tree (uploadable, commentable). status and visible will be soon added

• admin.php : $conf_link var to avoid lines longer than 79 characters

• config.upload_available configuration parameter disappear : it's simpler to manage with cat_options

• config.show_comments idem : new column categories.commentable, each categories can be commentable or not

• categories.site_id becomes a nullable column : a virtual category does belong to no site

• function display_select_categories has a new argument : $CSS_classes array to optionnaly assign a CSS class to each category in the select field

• added informations in include/config.inc.php for setting default value of :

• categories.visible
• categories.status
• categories.uploadable
• categories.commentable

• 2 new indexes images_i3(average_rate) and images_i4(hit) : optimizes best rated and most visited categories

Location:

trunk/include

Files:

• category_default.inc.php (modified) (1 diff)
• config.inc.php (modified) (1 diff)
• functions_category.inc.php (modified) (6 diffs)

trunk/include/category_default.inc.php

@@ -121 +121 @@
     );
     
-  if ($conf['show_comments'] and $user['show_nb_comments'])
+  if ($user['show_nb_comments']
+      and is_numeric($page['cat'])
+      and $page['cat_commentable'])
   {
     $query = '

trunk/include/config.inc.php

@@ -168 +168 @@
 // show_gt : display generation time at the bottom of each page
 $conf['show_gt'] = true;
+
+// Default options for new categories.
+//
+// Some options for categories (commentable, uploadable, status, visible)
+// must be set directly in the database by changing the corresponding
+// default values of the column. Examples :
+//
+// ALTER TABLE phpwebgallery_categories ALTER visible SET DEFAULT 'true';
+// ALTER TABLE phpwebgallery_categories ALTER status SET DEFAULT 'private';
+// ALTER TABLE phpwebgallery_categories ALTER uploadable SET DEFAULT 'true';
+// ALTER TABLE phpwebgallery_categories ALTER commentable SET DEFAULT 'false';
+//
+// MySQL default values are used when inserting a row and that no value is
+// given for the column. In PhpWebGallery, the above columns are not valued
+// during categories insertion, so default values are important.
 ?>

trunk/include/functions_category.inc.php

@@ -309 +309 @@
   $infos = array( 'nb_images','id_uppercat','comment','site_id','galleries_url'
                   ,'dir','date_last','uploadable','status','visible'
-                  ,'representative_picture_id','uppercats' );
+                  ,'representative_picture_id','uppercats','commentable' );
 
   $query = 'SELECT '.implode( ',', $infos );
@@ -455 +455 @@
       $page['cat_site_id']    = $result['site_id'];
       $page['cat_uploadable'] = $result['uploadable'];
+      $page['cat_commentable'] = $result['commentable'];
       $page['uppercats']      = $result['uppercats'];
       $page['title'] = get_cat_display_name( $page['cat_name'],' - ','',false);
@@ -912 +913 @@
                                    $indent,
                                    $selecteds,
-                                   $blockname)
+                                   $blockname,
+                                   $CSS_classes)
 {
   global $template,$user;
@@ -924 +926 @@
       {
         $selected = ' selected="selected"';
+      }
+
+      $class = '';
+      foreach (array_keys($CSS_classes) as $CSS_class)
+      {
+        if (in_array($category['id'], $CSS_classes[$CSS_class]))
+        {
+          $class = $CSS_class;
+        }
       }
 
@@ -930 +941 @@
         array('SELECTED'=>$selected,
               'VALUE'=>$category['id'],
+              'CLASS'=>$class,
               'OPTION'=>$indent.'- '.$category['name']
               ));
@@ -936 +948 @@
                                 $indent.str_repeat(' ',3),
                                 $selecteds,
-                                $blockname);
+                                $blockname,
+                                $CSS_classes);
     }
   }