0) { $filter['visible_categories'] = implode(',', array_keys($filter['categories'])); } else { // Must be not empty $filter['visible_categories'] = -1; } $query =' SELECT distinct image_id FROM '. IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON image_id = id WHERE '; if (!empty($filter['visible_categories'])) { $query.= ' category_id IN ('.$filter['visible_categories'].') and'; } $query.= ' date_available > SUBDATE( CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)'; if (count($filter['visible_images']) > 0) { $filter['visible_images'] = implode(',', array_from_query($query, 'image_id')); } else { // Must be not empty $filter['visible_images'] = -1; } } else { // Read only data $filter['check_key'] = pwg_get_session_var('filter_check_key', ''); $filter['categories'] = unserialize(pwg_get_session_var('filter_categories', serialize(array()))); $filter['visible_categories'] = pwg_get_session_var('filter_visible_categories', ''); $filter['visible_images'] = pwg_get_session_var('filter_visible_images', ''); } $header_notes[] = l10n_dec('note_filter_day', 'note_filter_days', $user['recent_period']); } else { $filter['check_key'] = ''; $filter['categories'] = array(); $filter['visible_categories'] = ''; $filter['visible_images'] = ''; } pwg_set_session_var('filter_enabled', $filter['enabled']); pwg_set_session_var('filter_check_key', $filter['check_key']); pwg_set_session_var('filter_categories', serialize($filter['categories'])); pwg_set_session_var('filter_visible_categories', $filter['visible_categories']); pwg_set_session_var('filter_visible_images', $filter['visible_images']); ?>