Changeset 271 for branches/release-1_3/include/functions_category.inc.php

Timestamp:

Jan 11, 2004, 1:02:03 AM (21 years ago)

Author:

z0rglub

Message:

use the order of categories.uppercats for retrieving the local directory,
and not the ascending order of category ids (if you alterate manually the
database by moving an old category under a new one).

File:

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

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

@@ -260 +260 @@
 
   $cat = array();
-                
+
   $query = 'SELECT nb_images,id_uppercat,comment,site_id,galleries_url,dir';
   $query.= ',date_last,uploadable,status,visible,representative_picture_id';
@@ -332 +332 @@
   }
 
-  $query = 'SELECT dir';
+  $upper_array = explode( ',', $uppercats );
+
+  $database_dirs = array();
+  $query = 'SELECT id,dir';
   $query.= ' FROM '.PREFIX_TABLE.'categories';
   $query.= ' WHERE id IN ('.$uppercats.')';
-  $query.= ' ORDER BY id ASC';
   $query.= ';';
   $result = mysql_query( $query );
   while( $row = mysql_fetch_array( $result ) )
   {
-    $local_dir.= $row['dir'].'/';
+    $database_dirs[$row['id']] = $row['dir'];
+  }
+  foreach ( $upper_array as $id ) {
+    $local_dir.= $database_dirs[$id].'/';
   }