/** * create_most_viewed_articles_query */ function create_most_viewed_articles_query($bean, $order_by, $where, $keywords, $row_offset, $limit, $date_filter, $searchVars, $spec_SearchVars) { $spec_SearchVars['frequency'] = 'Top_10'; $sql = create_fts_search_list_query($bean->db, $spec_SearchVars, $searchVars, true); $sql = str_replace("'Published'", "'Published' AND {$date_filter} ", $sql); return $sql; }
function perform_basic_search($srch_str_raw, $focus) { $searchVars = array(); $spec_SearchVars = array(); //make sure string does not have html encoding $srch_str_raw = from_html($srch_str_raw); $srch_str_raw_orig = $srch_str_raw; //lets remove defined tags from the search string $tagNamesArr = separateTagNames($srch_str_raw); if (!empty($tagNamesArr)) { $_POST['searchText'] = $tagNamesArr['search_string_raw']; $spec_SearchVars['tag_name'] = $tagNamesArr['tag_token_string']; } if (isset($_POST['canned_search']) and !empty($_POST['canned_search'])) { $spec_SearchVars['canned_search'] = $_POST['canned_search']; } //create array of available search parameters. if (isset($_POST['searchText']) and !empty($_POST['searchText'])) { $spec_SearchVars['searchText_include'] = from_html($_POST['searchText']); } $list_query = create_fts_search_list_query($focus->db, $spec_SearchVars, $searchVars); if (empty($list_query)) { return ''; } return $list_query; }