| // | branch : BSF (Best So Far) | // +-----------------------------------------------------------------------+ // | file : $RCSfile$ // | last update : $Date$ // | last modifier : $Author$ // | revision : $Revision$ // +-----------------------------------------------------------------------+ // | This program is free software; you can redistribute it and/or modify | // | it under the terms of the GNU General Public License as published by | // | the Free Software Foundation | // | | // | This program is distributed in the hope that it will be useful, but | // | WITHOUT ANY WARRANTY; without even the implied warranty of | // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | // | General Public License for more details. | // | | // | You should have received a copy of the GNU General Public License | // | along with this program; if not, write to the Free Software | // | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | // | USA. | // +-----------------------------------------------------------------------+ /** * This file is included by category.php to show thumbnails for the default * case * */ /** * $array_cat_directories is a cache hash associating category id with their * complete directory */ $array_cat_directories = array(); $query = ' SELECT DISTINCT(id),file,date_available,category_id ,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 '
'.$query.'
'; $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)) { // 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']); } $thumbnail_url = get_thumbnail_src($row['file'], $row['storage_category_id'], @$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?'; if ($page['cat'] == 'random') { $url_link.= 'cat='.$row['category_id']; } else { $url_link.= 'cat='.$page['cat']; } $url_link.= '&image_id='.$row['id']; if ($page['cat'] == 'search') { $url_link.= '&search='.$_GET['search']; } $template->assign_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE' => $thumbnail_url, 'IMAGE_ALT' => $row['file'], 'IMAGE_TITLE' => $thumbnail_title, 'IMAGE_NAME' => $name, 'IMAGE_TS' => get_icon($row['date_available']), 'IMAGE_STYLE' => 'thumb_picture', 'U_IMG_LINK' => add_session_id($url_link) ) ); if ($conf['show_comments'] and $user['show_nb_comments']) { $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; } } ?>