" . var_export($uppercats_list,true);

  foreach ( array_reverse($uppercats_list) as $uppercats)
  {
    $cat_ids = explode(',', $uppercats);
    $bounds = $cat_bounds[ $cat_ids[count($cat_ids)-1] ];
    for ($i=count($cat_ids)-2; $i>=0; $i--)
    {
      $this_bounds = @$cat_bounds[ $cat_ids[$i] ];
      if ( !isset($this_bounds) )
      {
        $this_bounds = $bounds;
        unset($this_bounds['self']);
      }
      else
      {
//        if ($cat_ids[$i]==43) echo "
Before\n" . var_export($this_bounds,true);
//        if ($cat_ids[$i]==43) echo "
Union\n" . var_export($bounds,true);
        $this_bounds = bounds_union($this_bounds, $bounds);
      }
      $this_bounds['nb_cats'] = 1 + @$this_bounds['nb_cats'];
//      if ($cat_ids[$i]==43) echo "
" . var_export($this_bounds,true);
      $cat_bounds[ $cat_ids[$i] ] = $this_bounds;
    }
  }
  //echo "
" . var_export($cat_bounds,true);
	mkgetdir( dirname($cache_file_name) );
  $file = fopen($cache_file_name , 'w' );
  fwrite($file, serialize($cat_bounds) );
  fclose( $file );

  return $cat_bounds;
}


define('RVM_BUILD_ARRAY',     0);
define('RVM_BUILD_HASH',      1);
define('RVM_BUILD_AGGREGATE', 2);

function rvm_build_section_items($img_fields, $where_sql, $mode, $order_by=null)
{
  global $page, $conf, $user;

  $page['items'] = array();

  if (empty($where_sql))
    $where_sql .= 'i.latitude IS NOT NULL';
  $where_sql_images_only = $where_sql;
  $where_sql .= get_sql_condition_FandF(
      array
        (
          'forbidden_categories' => 'category_id',
          'visible_categories' => 'category_id',
          'visible_images' => 'i.id'
        ),
      "\n  AND"
  );

  switch ($mode)
  {
    case RVM_BUILD_ARRAY:
      $func = 'array_from_query';
      $group_by = '
  GROUP BY i.id';
      break;
    case RVM_BUILD_HASH:
      $func = create_function( '$q', 'return hash_from_query($q, "id");' );
      $group_by = '
  GROUP BY i.id';
      break;
    case RVM_BUILD_AGGREGATE:
      $func = 'array_from_query';
      $group_by = '';
      break;
  }

  if ($mode != RVM_BUILD_AGGREGATE )
  {
    if ($order_by==null and pwg_get_session_var('image_order',0) > 0)
    {
      $orders = get_category_preferred_image_orders();

      $conf['order_by'] = str_replace(
        'ORDER BY ',
        'ORDER BY '.$orders[ pwg_get_session_var('image_order',0) ][1].',',
        $conf['order_by']
        );
      $page['super_order_by'] = true;
    }
    elseif ($order_by!=null)
    {
      $conf['order_by']=$order_by;
      $page['super_order_by'] = true;
    }
    elseif ( 'categories' == $page['section'] and isset($page['category']['image_order']) )
    {
      $conf['order_by'] = 'ORDER BY '.$page['category']['image_order'];
    }
  }
  else
  {
    $conf['order_by'] = 'ORDER BY NULL';
    $page['super_order_by'] = true;
  }

  if ('categories' == $page['section'])
  {
    if ( isset($page['flat']) or isset($page['category']) )
    {
      if (isset($page['flat']))
      {
        if ( isset($page['category']) )
        {
          $subcat_ids = get_subcat_ids( array($page['category']['id']) );
          $where_sql .= ' AND category_id IN ('.implode(',',$subcat_ids).')';
        }
      }
      else
      {
        $where_sql .= ' AND category_id='.$page['category']['id'];
      }

      $query='
SELECT '.$img_fields.'
  FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON i.id=image_id
  WHERE '.$where_sql.$group_by.'
  '.$conf['order_by'];

      $page['items'] = $func($query);
    }
    if ( isset($page['category']) )
    {
      $page['title'] = trigger_event('render_category_name', $page['category']['name']);
      $page['comment'] = $page['category']['comment'];
    }
    else
      $page['title'] = $conf['gallery_title'];
  }
  else if ('tags' == $page['section'])
  {
    $items = get_image_ids_for_tags( array($page['tags'][0]['id']), 'AND', $where_sql_images_only, 'ORDER BY NULL' );
    if ( !empty($items) )
    {
      $query = '
SELECT '.$img_fields.'
  FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' i ON i.id=image_id
  WHERE image_id IN ('.implode(',', $items).')'
  .$group_by.'
  '.$conf['order_by'];

      $page['items'] = $func($query);
    }
    $page['title'] = strip_tags( get_tags_content_title() );
  }
  elseif ('search' == $page['section'])
  {
    include_once( PHPWG_ROOT_PATH .'include/functions_search.inc.php' );
    $search_result = get_search_results($page['search'], @$page['super_order_by'], $where_sql_images_only);
    if ( !empty($search_result['items']) )
    {
      $query = '
SELECT '.$img_fields.'
  FROM '.IMAGES_TABLE.' i
  WHERE id IN ('.implode(',', $search_result['items']).')'
  .$group_by.'
  '.$conf['order_by'].'
;';

      if ($mode != RVM_BUILD_AGGREGATE )
      {
        $page['items'] = hash_from_query($query, 'id' );

        global $item_ranks;
        $item_ranks = array_flip($search_result['items']);
        function cmp_item_hash($a, $b)
        {
          global $item_ranks;
          return $item_ranks [ $a['id'] ] - $item_ranks [ $b['id'] ];
        }
        uasort( $page['items'], 'cmp_item_hash' );
        unset( $item_ranks );
      }
      else
        $page['items'] = $func($query);
    }

    $page['title'] = l10n('Search results');
  }
  elseif ('recent_pics' == $page['section'])
  {
    $conf['order_by'] = ' ORDER BY hit DESC, file ASC';

    $query ='
SELECT '.$img_fields.'
  FROM '.IMAGES_TABLE.' i
    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
  WHERE date_available >= SUBDATE(
      CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)
    AND '.$where_sql
  .$group_by.'
  '.$conf['order_by'].'
  LIMIT 0, '.$conf['top_number'].'
;';

    $page['items'] = $func($query);
    $page['title'] = l10n('Recent photos');
  }
  else if ('list'==$page['section'])
  {
    $query ='
SELECT '.$img_fields.'
  FROM '.IMAGES_TABLE.' i
    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
  WHERE image_id IN ('.implode(',', $page['list']).')
    AND '.$where_sql
  .$group_by.'
  '.$conf['order_by'].'
;';

    $page['items'] = $func($query);
    $page['title'] = l10n('Random photos');
  }
  else
    fatal_error( 'section '.$page['section']. ' not handled '. __FILE__);
}

?>