/public/wp-content/plugins/wp-statistics/includes/optimization/wps-optimization.php
PHP | 267 lines | 189 code | 55 blank | 23 comment | 42 complexity | 34b0c7e0e8d4003d5adaffcfbf4bec73 MD5 | raw file
- <?php
- GLOBAL $wpdb, $WP_Statistics;
- $wp_prefix = $wpdb->prefix;
-
- if( !is_super_admin() )
- wp_die(__('Access denied!', 'wp_statistics'));
-
- if( array_key_exists( 'populate', $_GET ) ) {
- if( intval($_GET['populate']) == 1 ) {
- require_once( plugin_dir_path( __FILE__ ) . '../functions/geoip-populate.php' );
- echo wp_statistics_populate_geoip_info();
- }
- }
-
- if( array_key_exists( 'hash-ips', $_GET ) ) {
- if( intval($_GET['hash-ips']) == 1 ) {
- // Generate a random salt
- $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
- $randomString = '';
- for ($i = 0; $i < 50; $i++) {
- $randomString .= $characters[rand(0, strlen($characters) - 1)];
- }
-
- // Get the rows from the Visitors table.
- $result = $wpdb->get_results( "SELECT DISTINCT ip FROM {$wp_prefix}statistics_visitor" );
-
- foreach( $result as $row ) {
-
- if( substr( $row->ip, 0, 6 ) != '#hash#' ) {
-
- $wpdb->update(
- $wp_prefix . "statistics_visitor",
- array(
- 'ip' => '#hash#' . sha1( $row->ip . $randomString ),
- ),
- array(
- 'ip' => $row->ip,
- )
- );
- }
- }
-
- echo "<div class='updated settings-error'><p><strong>" . __('IP Addresses replaced with hash values.', 'wp_statistics') . "</strong></p></div>";
- }
- }
-
- if( array_key_exists( 'install', $_GET ) ) {
- if( intval($_GET['install']) == 1 ) {
- $WPS_Installed = "1.0";
- include( plugin_dir_path( __FILE__ ) . "../../wps-install.php" );
- echo "<div class='updated settings-error'><p><strong>" . __('Install routine complete.', 'wp_statistics') . "</strong></p></div>";
- }
- }
-
- if( array_key_exists( 'index', $_GET ) ) {
- if( intval($_GET['index']) == 1 ) {
- // Check the number of index's on the visitors table, if it's only 5 we need to check for duplicate entries and remove them
- $result = $wpdb->query("SHOW INDEX FROM {$wp_prefix}statistics_visitor WHERE Key_name = 'date_ip'");
-
- if( $result != 5 ) {
- // We have to loop through all the rows in the visitors table to check for duplicates that may have been created in error.
- $result = $wpdb->get_results( "SELECT ID, last_counter, ip FROM {$wp_prefix}statistics_visitor ORDER BY last_counter, ip" );
-
- // Setup the inital values.
- $lastrow = array( 'last_counter' => '', 'ip' => '' );
- $deleterows = array();
-
- // Ok, now iterate over the results.
- foreach( $result as $row ) {
- // if the last_counter (the date) and IP is the same as the last row, add the row to be deleted.
- if( $row->last_counter == $lastrow['last_counter'] && $row->ip == $lastrow['ip'] ) { $deleterows[] .= $row->ID;}
-
- // Update the lastrow data.
- $lastrow['last_counter'] = $row->last_counter;
- $lastrow['ip'] = $row->ip;
- }
-
- // Now do the acutal deletions.
- foreach( $deleterows as $row ) {
- $wpdb->delete( $wp_prefix . 'statistics_visitor', array( 'ID' => $row ) );
- }
-
- // The table should be ready to be updated now with the new index, so let's do it.
- $result = $wpdb->get_results( "ALTER TABLE " . $wp_prefix . 'statistics_visitor' . " ADD UNIQUE `date_ip_agent` ( `last_counter`, `ip`, `agent` (75), `platform` (75), `version` (75) )" );
-
- // We might have an old index left over from 7.1-7.3 so lets make sure to delete it.
- $wpdb->query( "DROP INDEX `date_ip` ON {$wp_prefix}statistics_visitor" );
-
- // Record in the options that we've done this update.
- $dbupdates = $WP_Statistics->get_option('pending_db_updates');
- $dbupdates['date_ip_agent'] = false;
- $WP_Statistics->update_option('pending_db_updates', $dbupdates);
- }
- }
- }
-
- if( array_key_exists( 'visits', $_GET ) ) {
- if( intval($_GET['visits']) == 1 ) {
- // Check the number of index's on the visits table, if it's only 5 we need to check for duplicate entries and remove them
- $result = $wpdb->query("SHOW INDEX FROM {$wp_prefix}statistics_visit WHERE Key_name = 'unique_date'");
-
- // Note, the result will be the number of fields contained in the index, so in our case 1.
- if( $result != 1 ) {
- // We have to loop through all the rows in the visitors table to check for duplicates that may have been created in error.
- $result = $wpdb->get_results( "SELECT ID, last_counter, visit FROM {$wp_prefix}statistics_visit ORDER BY last_counter, visit DESC" );
-
- // Setup the initial values.
- $lastrow = array( 'last_counter' => '', 'visit' => 0, 'id' => 0 );
- $deleterows = array();
-
- // Ok, now iterate over the results.
- foreach( $result as $row ) {
- // if the last_counter (the date) and IP is the same as the last row, add the row to be deleted.
- if( $row->last_counter == $lastrow['last_counter'] ) { $deleterows[] .= $row->ID; }
-
- // Update the lastrow data.
- $lastrow['last_counter'] = $row->last_counter;
- $lastrow['id'] = $row->ID;
- $lastrow['visit'] = $row->visit;
- }
-
- // Now do the acutal deletions.
- foreach( $deleterows as $row ) {
- $wpdb->delete( $wp_prefix . 'statistics_visit', array( 'ID' => $row ) );
- }
-
- // The table should be ready to be updated now with the new index, so let's do it.
- $result = $wpdb->get_results( "ALTER TABLE " . $wp_prefix . 'statistics_visit' . " ADD UNIQUE `unique_date` ( `last_counter` )" );
-
- // Record in the options that we've done this update.
- $dbupdates = $WP_Statistics->get_option('pending_db_updates');
- $dbupdates['unique_date'] = false;
- $WP_Statistics->update_option('pending_db_updates', $dbupdates);
- }
- }
- }
-
- if( array_key_exists( 'historical-submit', $_POST ) ) {
-
- if( array_key_exists( 'wps_historical_visitors', $_POST ) ) {
- $result = $wpdb->update( $wp_prefix . "statistics_historical", array( 'value' => $_POST['wps_historical_visitors'] ), array( 'category' => 'visitors' ) );
-
- if( $result == 0 ) {
- $result = $wpdb->insert( $wp_prefix . "statistics_historical", array( 'value' => $_POST['wps_historical_visitors'], 'category' => 'visitors', 'page_id' => -1, 'uri' => '-1' ) );
- }
- }
-
- 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 );
- $total++;
- }
-
- $rowcount -= $limitsize;
- $offset += $limitsize;
- }
- }
-
- $WP_Statistics->update_option('search_converted', 1);
- echo "<div class='updated settings-error'><p><strong>" . sprintf( __('Search table conversion complete, %d rows added.', 'wp_statistics'), $total ) . "</strong></p></div>";
-
- }
-
- $selected_tab = "";
- if( array_key_exists( 'tab', $_GET ) ) { $selected_tab = $_GET['tab']; }
-
- switch( $selected_tab )
- {
- case 'export':
- $current_tab = 1;
- break;
- case 'purging':
- $current_tab = 2;
- break;
- case 'database':
- $current_tab = 3;
- break;
- case 'updates':
- $current_tab = 4;
- break;
- case 'historical':
- $current_tab = 5;
- break;
- default:
- $current_tab = 0;
-
- }
- ?>
- <script type="text/javascript">
- jQuery(document).ready(function() {
- jQuery("#tabs").tabs();
- <?php if( $current_tab != 0 ) { echo 'jQuery("#tabs").tabs("option", "active",' . $current_tab. ');' . "\n"; }?>
- } );
- </script>
- <div class="wrap">
- <div id="tabs" class="ui-tabs ui-widget ui-widget-content ui-corner-all">
- <ul class="ui-tabs-nav ui-helper-reset ui-helper-clearfix ui-widget-header ui-corner-all">
- <li class="ui-state-default ui-corner-top"><a href="#resources" class="ui-tabs-anchor"><span><?php _e('Resources/Information', 'wp_statistics'); ?></span></a></li>
- <li class="ui-state-default ui-corner-top"><a href="#export" class="ui-tabs-anchor"><span><?php _e('Export', 'wp_statistics'); ?></span></a></li>
- <li class="ui-state-default ui-corner-top"><a href="#purging" class="ui-tabs-anchor"><span><?php _e('Purging', 'wp_statistics'); ?></span></a></li>
- <li class="ui-state-default ui-corner-top"><a href="#database" class="ui-tabs-anchor"><span><?php _e('Database', 'wp_statistics'); ?></span></a></li>
- <li class="ui-state-default ui-corner-top"><a href="#updates" class="ui-tabs-anchor"><span><?php _e('Updates', 'wp_statistics'); ?></span></a></li>
- <li class="ui-state-default ui-corner-top"><a href="#historical" class="ui-tabs-anchor"><span><?php _e('Historical', 'wp_statistics'); ?></span></a></li>
- </ul>
-
- <div id="resources">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-resources.php' ); ?>
- </div>
-
- <div id="export">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-export.php' ); ?>
- </div>
-
- <div id="purging">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-purging.php' ); ?>
- </div>
-
- <div id="database">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-database.php' ); ?>
- </div>
-
- <div id="updates">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-updates.php' ); ?>
- </div>
-
- <div id="historical">
- <?php include( dirname( __FILE__ ) . '/tabs/wps-optimization-historical.php' ); ?>
- </div>
-
- </div>
- </div>