'.$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['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_NAME' => $name, 'IMAGE_TS' => get_icon($row['date_available']), 'IMAGE_STYLE' => 'thumb_picture', 'U_IMG_LINK' => add_session_id($url_link) ) ); 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; } } ?>