0) { list($image_id) = mysql_fetch_row($subresult); } } else { // searching a random representant among representant of sub-categories $query = ' SELECT representative_picture_id FROM '.CATEGORIES_TABLE.' WHERE uppercats REGEXP \'(^|,)'.$row['id'].'(,|$)\' AND id NOT IN ('.$user['forbidden_categories'].') AND representative_picture_id IS NOT NULL ORDER BY RAND() LIMIT 0,1 ;'; $subresult = pwg_query($query); if (mysql_num_rows($subresult) > 0) { list($image_id) = mysql_fetch_row($subresult); } } $comment = null; if (isset($row['comment'])) { $comment = strip_tags($row['comment'], '

'); } if (isset($image_id)) { array_push( $categories, array( 'category' => $row['id'], 'picture' => $image_id, 'name' => $row['name'], 'date_last' => @$row['date_last'], 'comment' => $comment, 'nb_images' => $row['nb_images'], ) ); array_push($image_ids, $image_id); } unset($image_id); } if (count($image_ids) > 0) { $thumbnail_src_of = array(); $query = ' SELECT id, path, tn_ext FROM '.IMAGES_TABLE.' WHERE id IN ('.implode(',', $image_ids).') ;'; $result = pwg_query($query); while ($row = mysql_fetch_array($result)) { $thumbnail_src_of[$row['id']] = get_thumbnail_src($row['path'], @$row['tn_ext']); } if ($conf['subcatify']) { $template->set_filenames( array( 'mainpage_categories' => 'mainpage_categories.tpl', ) ); $template->assign_block_vars('categories', array()); foreach ($categories as $category) { $template->assign_block_vars( 'categories.category', array( 'SRC' => $thumbnail_src_of[ $category['picture'] ], 'ALT' => htmlentities($category['name'],ENT_QUOTES), 'TITLE' => $lang['hint_category'], 'ICON' => get_icon(@$category['date_last']), 'URL' => make_index_url( array( 'category' => $category['category'], 'cat_name' => $category['name'], ) ), 'NAME' => htmlentities($category['name'],ENT_QUOTES), 'CAPTION_NB_IMAGES' => (($category['nb_images'] == 0) ? '' : sprintf("%d ".l10n('pictures'), $category['nb_images'])), 'DESCRIPTION' => @$category['comment'], ) ); } $template->assign_var_from_handle('CATEGORIES', 'mainpage_categories'); } else { $template->assign_block_vars('thumbnails', array()); // first line $template->assign_block_vars('thumbnails.line', array()); // current row displayed $row_number = 0; foreach ($categories as $category) { $template->assign_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE' => $thumbnail_src_of[ $category['picture'] ], 'IMAGE_ALT' => $category['name'], 'IMAGE_TITLE' => $lang['hint_category'], 'IMAGE_TS' => get_icon(@$category['date_last']), 'U_IMG_LINK' => make_index_url( array( 'category' => $category['category'], 'cat_name' => $category['name'], ) ), 'CLASS' => 'thumbCat', ) ); $template->assign_block_vars( 'thumbnails.line.thumbnail.category_name', array( 'NAME' => $category['name'] ) ); // create a new line ? if (++$row_number == $user['nb_image_line']) { $template->assign_block_vars('thumbnails.line', array()); $row_number = 0; } } } } ?>