Changeset 412

Timestamp:

Apr 30, 2004, 7:11:25 PM (20 years ago)

Author:

z0rglub

Message:

bug 26 : When categories tree has category ids not in ascending order, the order of display still uses ids order. Corrected using categories.uppercats order

File:

• branches/release-1_3/include/functions_category.inc.php (modified) (1 diff)

branches/release-1_3/include/functions_category.inc.php

@@ -288 +288 @@
   $cat['comment'] = nl2br( $cat['comment'] );
 
-  $cat['name'] = array();
-
-  $query = 'SELECT name';
+  // first, we retrieve the names of upper categories in the default order
+  // (not the correct one automatically)
+  $buffers_name = array();
+
+  $query = 'SELECT id, name';
   $query.= ' FROM '.PREFIX_TABLE.'categories';
   $query.= ' WHERE id IN ('.$cat['uppercats'].')';
-  $query.= ' ORDER BY id ASC';
   $query.= ';';
   $result = mysql_query( $query );
   while( $row = mysql_fetch_array( $result ) )
   {
-    array_push( $cat['name'], $row['name'] );
+    $buffer_names[$row['id']] = $row['name'];
+  }
+
+  // then we reorder the names with the order given in the
+  // categories.uppercats database field
+  $cat['name'] = array();
+  
+  foreach ( explode( ',', $cat['uppercats'] ) as $id_uppercat ) {
+    array_push( $cat['name'], $buffer_names[$id_uppercat] );
   }