/**
* 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;
}
