//------------------------------------------------------------ log informations
pwg_log('category', $page['title']);

// BEGIN COMS ON INDEX

$comments = array();
$element_ids = array();
$category_ids = array();

/*Nombre de commentaires à afficher*/
$NbrComs = 5;

$query = 'SELECT com.id AS comment_id
, com.image_id
, ic.category_id
, com.author
, com.date
, com.content
, com.id AS comment_id
 FROM phpwebgallery_image_category AS ic
 INNER JOIN phpwebgallery_comments AS com
 ON ic.image_id = com.image_id
 GROUP BY comment_id
 ORDER BY date DESC
 LIMIT 0,'.$NbrComs;

$result = pwg_query($query);
while ($row = mysql_fetch_array($result))
{
  array_push($comments, $row);
  array_push($element_ids, $row['image_id']);
  array_push($category_ids, $row['category_id']);
}

if (count($comments) > 0)
{
  // retrieving element informations
  $elements = array();
  $query = '
SELECT id, name, file, path, tn_ext
  FROM '.IMAGES_TABLE.'
  WHERE id IN ('.implode(',', $element_ids).')
;';
  $result = pwg_query($query);
  while ($row = mysql_fetch_array($result))
  {
    $elements[$row['id']] = $row;
  }

  // retrieving category informations
  $categories = array();
  $query = '
SELECT id, name, uppercats
  FROM '.CATEGORIES_TABLE.'
  WHERE id IN ('.implode(',', $category_ids).')
;';
  $result = pwg_query($query);
  while ($row = mysql_fetch_array($result))
  {
    $categories[$row['id']] = $row;
  }

  foreach ($comments as $comment)
  {
    // name of the picture
    $name = get_cat_display_name_cache(
      $categories[$comment['category_id']]['uppercats'], null, false);
    $name.= $conf['level_separator'];
    if (!empty($elements[$comment['image_id']]['name']))
    {
      $name.= $elements[$comment['image_id']]['name'];
    }
    else
    {
      $name.= get_name_from_file($elements[$comment['image_id']]['file']);
    }

    // source of the thumbnail picture
    $thumbnail_src = get_thumbnail_src(
      $elements[$comment['image_id']]['path'],
      @$elements[$comment['image_id']]['tn_ext']
      );

    // link to the full size picture
    $url = make_picture_url(
            array(
              'category' => $comment['category_id'],
              'cat_name' => $categories[ $comment['category_id']] ['name'],
              'image_id' => $comment['image_id'],
              'image_file' => $elements[$comment['image_id']]['file'],
            )
          );

    $template->assign_block_vars(
      'picture',
      array(
        'TITLE_IMG'=>$name,
        'I_THUMB'=>$thumbnail_src,
        'U_THUMB'=>$url
        ));

    $author = $comment['author'];
    if (empty($comment['author']))
    {
      $author = l10n('guest');
    }

    $template->assign_block_vars(
      'comment',
      array(
        'U_PICTURE' => $url,
        'TN_SRC' => $thumbnail_src,
        'AUTHOR' => $author,
        'DATE'=>format_date($comment['date'],'mysql_datetime',true),
        'CONTENT'=>parse_comment_content($comment['content']),
        ));  
  }
}
//END COMS ON INDEX

<!-- BEGIN COMS ON INDEX -->
<div id="content">
  <h2><a href="comments.php" title="Derniers commentaires">Derniers commentaires</a></h2>
<div id="comments">
  <!-- BEGIN comment -->
  <div class="comment">
    <a class="illustration" href="{comment.U_PICTURE}"><img src="{comment.TN_SRC}" /></a>
    <p class="commentHeader"><span class="author">{comment.AUTHOR}</span> - <span class="date">{comment.DATE}</span></p>
    <blockquote>{comment.CONTENT}</blockquote>
    <hr class="separation">
  </div>
  <!-- END comment -->
</div></div>
<!-- END COMS ON INDEX -->

if ($user['forbidden_categories'] != '')
{
  $query.= '
    AND category_id NOT IN ('.$user['forbidden_categories'].')';
}