0) { $template->assign_block_vars('thumbnails', array()); // first line $template->assign_block_vars('thumbnails.line', array()); // current row displayed $row_number = 0; } foreach ($subcats as $subcat_id => $non_empty_id) { $name = $page['plain_structure'][$subcat_id]['name']; // searching the representative picture of the category $query = ' SELECT representative_picture_id FROM '.CATEGORIES_TABLE.' WHERE id = '.$non_empty_id.' ;'; $row = mysql_fetch_array(pwg_query($query)); $query = ' SELECT file,path,tn_ext FROM '.IMAGES_TABLE.', '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$non_empty_id.' AND id = image_id'; // if the category has a representative picture, this is its thumbnail // that will be displayed ! if (isset($row['representative_picture_id'])) { $query.= ' AND id = '.$row['representative_picture_id']; } else { $query.= ' ORDER BY RAND() LIMIT 0,1'; } $query.= ' ;'; $image_result = pwg_query($query); $image_row = mysql_fetch_array($image_result); $thumbnail_link = get_thumbnail_src($image_row['path'], @$image_row['tn_ext']); $thumbnail_title = $lang['hint_category']; $url_link = PHPWG_ROOT_PATH.'category.php?cat='.$subcat_id; $date = $page['plain_structure'][$subcat_id]['date_last']; $template->assign_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE' => $thumbnail_link, 'IMAGE_ALT' => $image_row['file'], 'IMAGE_TITLE' => $thumbnail_title, 'IMAGE_NAME' => '['.$name.']', 'IMAGE_TS' => get_icon($date), 'IMAGE_STYLE' => 'thumb_category', 'U_IMG_LINK' => add_session_id($url_link) ) ); $template->assign_block_vars('thumbnails.line.thumbnail.bullet',array()); // create a new line ? if (++$row_number == $user['nb_image_line']) { $template->assign_block_vars('thumbnails.line', array()); $row_number = 0; } } ?>