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);