SUBDATE( CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY );'; } else { // $user['forbidden_categories'] including with USER_CACHE_CATEGORIES_TABLE $query = ' SELECT id,name, representative_picture_id, comment, nb_images, date_last, max_date_last, count_images, count_categories FROM '.CATEGORIES_TABLE.' INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.' ON id = cat_id and user_id = '.$user['id'].' WHERE id_uppercat '. (!isset($page['category']) ? 'is NULL' : '= '.$page['category']).' ORDER BY rank ;'; } $result = pwg_query($query); $categories = array(); $image_ids = array(); while ($row = mysql_fetch_assoc($result)) { $row['is_child_date_last'] = isset($row['date_last']) and $row['max_date_last']>$row['date_last']; if (isset($row['representative_picture_id']) and is_numeric($row['representative_picture_id'])) { // if a representative picture is set, it has priority $image_id = $row['representative_picture_id']; } else if ($conf['allow_random_representative']) {// searching a random representant among elements in sub-categories $query = ' SELECT image_id FROM '.CATEGORIES_TABLE.' AS c INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.category_id = c.id WHERE uppercats REGEXP \'(^|,)'.$row['id'].'(,|$)\' AND c.id NOT IN ('.$user['forbidden_categories'].') ORDER BY RAND() LIMIT 0,1 ;'; $subresult = pwg_query($query); if (mysql_num_rows($subresult) > 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); } } if (isset($image_id)) { $row['representative_picture_id'] = $image_id; array_push($image_ids, $image_id); array_push($categories, $row); } unset($image_id); } if (count($categories) > 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_assoc($result)) { $thumbnail_src_of[$row['id']] = get_thumbnail_url($row); } } if (count($categories) > 0) { if ($conf['subcatify']) { $template->set_filenames( array( 'mainpage_categories' => 'mainpage_categories.tpl', ) ); foreach ($categories as $category) { $comment = strip_tags(@$category['comment'], '

'); if ($page['section']=='recent_cats') { $name = get_cat_display_name_cache($category['uppercats'], null, false); } else { $name = $category['name']; } $icon_ts = get_icon($category['max_date_last'], $category['is_child_date_last']); $template->assign_block_vars( 'categories.category', array( 'SRC' => $thumbnail_src_of[$category['representative_picture_id']], 'ALT' => $category['name'], 'TITLE' => $lang['hint_category'], 'ICON' => $icon_ts, 'URL' => make_index_url( array( 'category' => $category['id'], 'cat_name' => $category['name'], ) ), 'CAPTION_NB_IMAGES' => get_display_images_count ( $category['nb_images'], $category['count_images'], $category['count_categories'] ), 'DESCRIPTION' => @$comment, 'NAME' => $name, ) ); } $template->assign_var_from_handle('CATEGORIES', 'mainpage_categories'); } else { $template->set_filenames( array( 'thumbnails' => 'thumbnails.tpl',)); // first line $template->assign_block_vars('thumbnails.line', array()); // current row displayed $row_number = 0; if ($page['section']=='recent_cats') { $old_level_separator = $conf['level_separator']; $conf['level_separator'] = '
'; } foreach ($categories as $category) { $template->assign_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE' => $thumbnail_src_of[ $category['representative_picture_id'] ], 'IMAGE_ALT' => $category['name'], 'IMAGE_TITLE' => $lang['hint_category'], 'U_IMG_LINK' => make_index_url( array( 'category' => $category['id'], 'cat_name' => $category['name'], ) ), 'CLASS' => 'thumbCat', ) ); if ($page['section']=='recent_cats') { $name = get_cat_display_name_cache($category['uppercats'], null, false); } else { $name = $category['name']; $template->merge_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE_TS' => get_icon($category['max_date_last'], $category['is_child_date_last']), ) ); } $template->assign_block_vars( 'thumbnails.line.thumbnail.category_name', array( 'NAME' => $name ) ); // create a new line ? if (++$row_number == $user['nb_image_line']) { $template->assign_block_vars('thumbnails.line', array()); $row_number = 0; } } if ( isset($old_level_separator) ) { $conf['level_separator']=$old_level_separator; } $template->assign_var_from_handle('THUMBNAILS', 'thumbnails'); } } ?>