'), 'U_INDEX' => duplicate_index_url( array('start'=>0) ), ) ); if ( !empty($page['items']) ) $dataTpl->assign( 'NB_ITEMS_DESC', sprintf( l10n('%d images'), count($page['items']) ).'
' ); // +-----------------------------------------------------------------------+ // | sub categories network links | // +-----------------------------------------------------------------------+ if ( 'categories'==$page['section'] and !isset($page['flat']) ) { $query = ' SELECT id, name, permalink, comment, uppercats, representative_picture_id FROM '.CATEGORIES_TABLE.' INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.' ON id = cat_id and user_id = '.$user['id'].' WHERE id_uppercat '. (!isset($page['category']) ? 'is NULL' : '= '.$page['category']['id']).' ORDER BY rank ;'; // echo "

" . var_export($query,true);
  $result = pwg_query($query);
  $categories = array();
  $thumbnail_ids=array();
  while ($row = mysql_fetch_assoc($result))
  {
    array_push($categories, $row);
    if (isset($row['representative_picture_id']) and is_numeric($row['representative_picture_id']))
      array_push($thumbnail_ids, $row['representative_picture_id'] );
  }
  $thumbnail_src_of = array();
  if ( count($thumbnail_ids) )
  {
    $query = '
SELECT id, path, tn_ext
  FROM '.IMAGES_TABLE.'
  WHERE id IN ('.implode(',', $thumbnail_ids).')';
    $result = pwg_query($query);
    while ($row = mysql_fetch_assoc($result))
      $thumbnail_src_of[$row['id']] = get_thumbnail_url($row);
    unset($thumbnail_ids);
  }

  $cat_bounds = rvm_get_cat_bounds();

  foreach ($categories as $category)
  {
    if ( !isset( $cat_bounds[ $category['id'] ] ) )
      continue; // without geo tagged images

    $bounds = $cat_bounds[ $category['id'] ];

    if ( isset($bounds['self']) )
    {
      $count_desc = l10n_dec('%d image', '%d images', $bounds['self']['count']);
      if ( $bounds['self']['count'] == $bounds['count'] )
        $count_desc .= ' '.l10n('images_available_cpl');
      else
        $count_desc .= '/'.l10n_dec('%d image', '%d images', $bounds['count']).' '.l10n_dec('images_available_cat','images_available_cats', $bounds['nb_cats'] );
    }
    else
      $count_desc = l10n_dec('%d image', '%d images', $bounds['count'])
        .' '.l10n_dec('images_available_cat','images_available_cats', $bounds['nb_cats'] );

		$tpl_var = array(
				'NAME'    => $category['name'],
				'COMMENT' => trigger_event('render_category_literal_description', trigger_event('render_category_description', @$category['comment']) ),
				'U_CATEGORY' => make_index_url( array('category'=>$category) ),
				'U_KML'   => rvm_make_kml_index_url( array('section'=>'categories', 'category'=>$category) ),
				'U_MAP'   => rvm_make_map_index_url( array('section'=>'categories', 'category'=>$category) ),
				'COUNT_DESC' => $count_desc,
				'region'  => $bounds,
      );
    if ( isset( $thumbnail_src_of[$category['representative_picture_id']] ) )
      $tpl_var['TN_SRC'] = $thumbnail_src_of[$category['representative_picture_id']];

    $dataTpl->append( 'categories', $tpl_var );
  }
}



// +-----------------------------------------------------------------------+
// | generate content for items                                            |
// +-----------------------------------------------------------------------+
$bounds = array();
foreach( $page['items'] as $img )
{
	$bounds = bounds_add($bounds, $img['lat'], $img['lon']);
	$page_url = duplicate_picture_url(array('image_id' => $img['id'],'image_file' => $img['file']),  array('start') );

	if (!empty( $img['name'] ) )
		$title = $img['name'];
	else
		$title = str_replace('_', ' ', get_filename_wo_extension($img['file']));

  $tpl_var = array(
      'U_PAGE'=> $page_url,
      'TN_SRC'  => get_thumbnail_url($img),
      'TITLE'  => $title,
      'DESCRIPTION'  => trigger_event('render_element_description', $img['comment']),
      'LAT'   => $img['lat'],
      'LON'   => $img['lon'],
      'DATE_CREATION' => $img['date_creation'],
    );
	$dataTpl->append('images', $tpl_var);
}

if ( !empty($bounds) )
  $dataTpl->assign( 'region', $bounds );

/*header('Cache-Control: public' );
header('Expires: '.gmdate('D, d M Y H:i:s', time()+600).' GMT');
header('Pragma:');*/
header('Content-Disposition: inline; filename="'.str2url($page['title']).'.kml";' );
header('Content-Type: application/vnd.google-earth.kml+xml; charset='.get_pwg_charset());
if (isset($_GET['debug']))
  header('Content-Type: text/xml; charset='.get_pwg_charset());


$dataTpl->pparse('main');

?>