Changeset 134

Timestamp:

Sep 19, 2003, 11:41:42 PM (21 years ago)

Author:

z0rglub

Message:

• A category can have its representative picture

• Use the plain structure instead of the get_cat_info for retrieving the last date of a category

File:

• trunk/category.php (modified) (2 diffs)

trunk/category.php

@@ -348 +348 @@
   $i = 0;
   foreach ( $subcats as $subcat_id => $non_empty_id ) {
-    $subcat_infos  = get_cat_info( $subcat_id );
-
-    $name ='[ <span style="font-weight:bold;">';
-    $name.= $subcat_infos['name'][0];
+    $name = '<img src="'.$user['lien_collapsed'].'" style="border:none;"';
+    $name.= ' alt="&gt;"/> ';
+    $name.= '[ <span style="font-weight:bold;">';
+    $name.= $page['plain_structure'][$subcat_id]['name'];
     $name.= '</span> ]';
 
+    // searching the representative picture of the category
+    $query = 'SELECT representative_picture_id';
+    $query.= ' FROM '.PREFIX_TABLE.'categories';
+    $query.= ' WHERE id = '.$non_empty_id;
+    $row = mysql_fetch_array( mysql_query( $query ) );
+    
     $query = 'SELECT file,tn_ext,storage_category_id';
     $query.= ' FROM '.PREFIX_TABLE.'images';
     $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
     $query.= ' WHERE category_id = '.$non_empty_id;
-    $query.= ' ORDER BY RAND()';
+    // if the category has a representative picture, this is its thumbnail
+    // tha will be displayed !
+    if ( $row['representative_picture_id'] != '' )
+      $query.= ' AND id = '.$row['representative_picture_id'];
+    else
+      $query.= ' ORDER BY RAND()';
     $query.= ' LIMIT 0,1';
     $query.= ';';
@@ -384 +395 @@
     $url_link.= $subcat_id;
 
-    list( $year,$month,$day ) = explode( '-', $subcat_infos['date_last'] );
-    $date = mktime( 0, 0, 0, $month, $day, $year );
+    $date = $page['plain_structure'][$subcat_id]['date_last'];
 
     // sending vars to display