SUBDATE(CURRENT_DATE ,INTERVAL '.$user['recent_period'].' DAY)'; if ( $user['forbidden_categories'] != '' ) { $query.= ' AND id NOT IN ('.$user['forbidden_categories'].')'; } $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; } // for each category, we have to search a recent picture to display and // the name to display while ( $row = mysql_fetch_array( $result ) ) { $cat_infos = get_cat_info( $row['category_id'] ); $name = get_cat_display_name($cat_infos['name'],'
','',false); $query = ' SELECT path,file,tn_ext FROM '.IMAGES_TABLE.', '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$row['category_id'].' AND date_available > SUBDATE(CURRENT_DATE ,INTERVAL '.$user['recent_period'].' DAY) AND id = image_id ORDER BY RAND() LIMIT 0,1 ;'; $subrow = mysql_fetch_array(pwg_query($query)); $thumbnail_src = get_thumbnail_src($subrow['path'], @$subrow['tn_ext']); $url_link = PHPWG_ROOT_PATH.'category.php?cat='.$row['category_id']; $template->assign_block_vars( 'thumbnails.line.thumbnail', array( 'IMAGE' => $thumbnail_src, 'IMAGE_ALT' => $subrow['file'], 'IMAGE_TITLE' => $lang['hint_category'], 'IMAGE_NAME' => '['.$name.']', '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; } } ?>