/** * Get a subset of the search logs * * @param SearchPager $pager Pager object * @return array Array of Search_Log items **/ function get(&$pager) { global $wpdb; $rows = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS * FROM {$wpdb->prefix}search_phrases " . $pager->to_limits('', array('phrase', 'ip')), ARRAY_A); $pager->set_total($wpdb->get_var("SELECT FOUND_ROWS()")); $data = array(); if ($rows) { foreach ($rows as $row) { $data[] = new Search_Log($row); } } return $data; }