function wp_statistics_searchengine($search_engine = 'all', $time = 'total')
{
global $wpdb, $WP_Statistics;
// Determine if we're using the old or new method of storing search engine info and build the appropriate table name.
$tablename = $wpdb->prefix . 'statistics_';
if ($WP_Statistics->get_option('search_converted')) {
$tablename .= 'search';
} else {
$tablename .= 'visitor';
}
// Get a complete list of search engines
$search_query = wp_statistics_searchengine_query($search_engine);
// This function accepts several options for time parameter, each one has a unique SQL query string.
// They're pretty self explanatory.
switch ($time) {
case 'today':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d')}' AND {$search_query}");
break;
case 'yesterday':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -1)}' AND {$search_query}");
break;
case 'week':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -7)}' AND {$search_query}");
break;
case 'month':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -30)}' AND {$search_query}");
break;
case 'year':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -360)}' AND {$search_query}");
break;
case 'total':
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE {$search_query}");
break;
default:
$result = $wpdb->query("SELECT * FROM `{$tablename}` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', $time)}' AND {$search_query}");
break;
}
return $result;
}
function wp_statistics_searchengine($search_engine = 'all', $time = 'total')
{
global $wpdb, $WP_Statistics;
// Get a complete list of search engines
$search_query = wp_statistics_searchengine_query($search_engine);
// This function accepts several options for time parameter, each one has a unique SQL query string.
// They're pretty self explanatory.
switch ($time) {
case 'today':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d')}' AND {$search_query}");
break;
case 'yesterday':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -1)}' AND {$search_query}");
break;
case 'week':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -7)}' AND {$search_query}");
break;
case 'month':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -30)}' AND {$search_query}");
break;
case 'year':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', -360)}' AND {$search_query}");
break;
case 'total':
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE {$search_query}");
break;
default:
$result = $wpdb->query("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE `last_counter` = '{$WP_Statistics->Current_Date('Y-m-d', $time)}' AND {$search_query}");
break;
}
return $result;
}
}
}
if (array_key_exists('wps_historical_visits', $_POST)) {
$result = $wpdb->update($wp_prefix . "statistics_historical", array('value' => $_POST['wps_historical_visits']), array('category' => 'visits'));
if ($result == 0) {
$result = $wpdb->insert($wp_prefix . "statistics_historical", array('value' => $_POST['wps_historical_visits'], 'category' => 'visits', 'page_id' => -2, 'uri' => '-2'));
}
}
}
if (array_key_exists('search', $_GET)) {
// Make sure we get all the search engines, even the ones the disabled ones.
$se_list = wp_statistics_searchengine_list();
$total = 0;
$limitsize = 10000;
foreach ($se_list as $key => $se) {
$sql = wp_statistics_searchengine_query($key);
$rowcount = $wpdb->get_var("SELECT count(*) FROM `{$wpdb->prefix}statistics_visitor` WHERE {$sql}");
$offset = 0;
while ($rowcount > 0) {
$result = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}statistics_visitor` WHERE {$sql} LIMIT {$offset}, {$limitsize}");
foreach ($result as $row) {
$parts = parse_url($row->referred);
$data['last_counter'] = $row->last_counter;
$data['engine'] = $key;
$data['host'] = $parts['host'];
$data['words'] = $WP_Statistics->Search_Engine_QueryString($row->referred);
$data['visitor'] = $row->ID;
if ($data['words'] == 'No search query found!') {
$data['words'] = '';
}
$wpdb->insert($wpdb->prefix . 'statistics_search', $data);
