db_operations()->get_number_of_themes(); $table_name = "all_themes"; $ats_create_db = isset( $_REQUEST['ats_create_db']) ? wp_strip_all_tags($_REQUEST['ats_create_db']) : ""; $update_db = isset( $_REQUEST['update_db']) ? wp_strip_all_tags($_REQUEST['update_db']) : "No"; $data_loaded_time = Klick_Ats()->get_options()->get_option('data-loaded'); if (isset($_REQUEST['update_db']) && ($_REQUEST['update_db']== "Yes")) { Klick_Ats()->db_operations()->drop_table($table_name); } ?>
'> db_operations()->check_table_exist($table_name) == false) {?>











klick_ats_time_elapsed_string($data_loaded_time) . __(' to re-download','klick-ats'); ?> )

prefix . "all_themes"; $query_params = ""; $query_params .= !empty($_REQUEST['required_wp_version']) ? "requires >= " . wp_strip_all_tags($_REQUEST['required_wp_version'], true) : "requires >= 0.0"; $per_page_limit = 24; $navigation = array(); $page_number = isset( $_REQUEST['page_number']) ? $_REQUEST['page_number'] : "1"; $navigation = Klick_Ats()->db_operations()->set_start_and_limit($page_number, $per_page_limit); $start = $navigation['start']; $limit = $navigation['limit']; $form_data = array('min_number_of_ratings'=> isset( $_REQUEST['min_number_of_ratings']) ? $_REQUEST['min_number_of_ratings'] : "", // num_ratings 'avg_ratings' => isset( $_REQUEST['avg_ratings']) ? $_REQUEST['avg_ratings'] : "" , //rating 'active_installs' => isset( $_REQUEST['active_installs']) ? $_REQUEST['active_installs'] : "", //active_installs 'downloaded' => isset( $_REQUEST['downloaded']) ? $_REQUEST['downloaded'] : "", //downloaded 'search_by_tags' => isset( $_REQUEST['search_by_tags']) ? $_REQUEST['search_by_tags'] : "", 'search_by_name' => isset( $_REQUEST['search_by_name']) ? $_REQUEST['search_by_name'] : "", 'search_by_author' => isset( $_REQUEST['search_by_author']) ? $_REQUEST['search_by_author'] : "" , 'search_by_description' => isset( $_REQUEST['search_by_description']) ? $_REQUEST['search_by_description'] : "" , 'search_by_keywords' => isset( $_REQUEST['search_by_keywords']) ? $_REQUEST['search_by_keywords'] : "", 'allow_exact_name' => isset( $_REQUEST['allow_exact_name']) ? $_REQUEST['allow_exact_name'] : "" , 'allow_exact_author' => isset( $_REQUEST['allow_exact_author']) ? $_REQUEST['allow_exact_author'] : "", ); $sanitized_form_data = Klick_Ats()->db_operations()->create_sanitized_data($form_data); $query_params = Klick_Ats()->db_operations()->build_query_params($sanitized_form_data, $query_params); $query_for_num_rows = Klick_Ats()->db_operations()->get_query_affected_rows($table_name, $query_params); Klick_Ats()->get_options()->update_option('affected-total-rows',$query_for_num_rows[0]->total_num_rows); Klick_Ats()->get_options()->update_option('total-pages',ceil($query_for_num_rows[0]->total_num_rows/$per_page_limit)); $results = $wpdb->get_results("SELECT * FROM $table_name WHERE $query_params LIMIT $start, $limit"); $total_rows = Klick_Ats()->get_options()->get_option('affected-total-rows'); $advanced_search_toggle = Klick_Ats()->get_options()->get_option('advanced-search-toggle'); // If advanced search enable if(!empty($total_rows) && isset($advanced_search_toggle) && $advanced_search_toggle == 1){ Klick_Ats()->klick_ats_pagination($page_number); } ?> 0){ ?>
'install-theme', 'theme' => $theme->slug, ), self_admin_url( 'update.php' ) ); foreach (unserialize($theme->versions) as $key => $value) { $latest_version_zip = $value; } ?>
screenshot_url ) ) { ?>

name; ?>

true ) ); if ( ! isset( $themes[ $theme->slug] ) ) { ?> slug; ?>">Details
". __('No themes found','klick-ats') . "
"; } ?>