$array_cat_directories = array();
$query = '
SELECT id,path,file,date_available
,tn_ext,name,filesize,storage_category_id,average_rate
FROM '.IMAGES_TABLE.' AS i
INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=ic.image_id
'.$page['where'].'
'.$conf['order_by'].'
LIMIT '.$page['start'].','.$page['nb_image_page'].'
;';
//echo '<pre>'.$query.'</pre>';
$result = pwg_query($query);
// template thumbnail initialization
if ( mysql_num_rows($result) > 0 )
{
$template->assign_block_vars('thumbnails', array());
// first line
$template->assign_block_vars('thumbnails.line', array());
// current row displayed
$row_number = 0;
}
while ($row = mysql_fetch_array($result))
{
$thumbnail_url = get_thumbnail_src($row['path'], @$row['tn_ext']);
// message in title for the thumbnail
$thumbnail_title = $row['file'];
if (isset($row['filesize']))
{
$thumbnail_title .= ' : '.$row['filesize'].' KB';
}
// url link on picture.php page
$url_link = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'];
$url_link.= '&image_id='.$row['id'];
if ($page['cat'] == 'search')
{
$url_link.= '&search='.$_GET['search'];
}
else if ($page['cat'] == 'list')
{
$url_link.= '&list='.$_GET['list'];
}
$template->assign_block_vars(
'thumbnails.line.thumbnail',
array(
'IMAGE' => $thumbnail_url,
'IMAGE_ALT' => $row['file'],
'IMAGE_TITLE' => $thumbnail_title,
'IMAGE_TS' => get_icon($row['date_available']),
'U_IMG_LINK' => add_session_id($url_link)
)
);
if ($conf['show_thumbnail_caption'])
{
// name of the picture
if (isset($row['name']) and $row['name'] != '')
{
$name = $row['name'];
}
else
{
$name = str_replace('_', ' ', get_filename_wo_extension($row['file']));
}
if ($page['cat'] == 'best_rated')
{
$name = '('.$row['average_rate'].') '.$name;
}
if ($page['cat'] == 'search')
{
$name = replace_search($name, $_GET['search']);
}
$template->assign_block_vars(
'thumbnails.line.thumbnail.element_name',
array(
'NAME' => $name
)
);
}
if ($user['show_nb_comments']
and is_numeric($page['cat'])
and $page['cat_commentable'])
{
$query = '
SELECT COUNT(*) AS nb_comments
FROM '.COMMENTS_TABLE.'
WHERE image_id = '.$row['id'].'
AND validated = \'true\'
;';
$row = mysql_fetch_array(pwg_query($query));
$template->assign_block_vars(
'thumbnails.line.thumbnail.nb_comments',
array('NB_COMMENTS'=>$row['nb_comments']));
}
// create a new line ?
if (++$row_number == $user['nb_image_line'])
{
$template->assign_block_vars('thumbnails.line', array());
$row_number = 0;
}
}
?>
Ca c'est mon fichier category_default.inc
Hors ligne
Ne plus toucher au config_local.
Faire une recherche dans include/category_default.inc.php de
SELECT DISTINCT(id),path,file,date_available
à remplacer par
SELECT id,path,file,date_available
Et si ça marche tu ouvres un bug dans le BUG Trackers et tu mettras le lien au post...
Hors ligne