Changeset 640296

Timestamp:

12/17/2012 01:57:21 AM (13 years ago)

Author:

Bit51

Message:

Added .csv export for 404 logs

Location:

better-wp-security/trunk/inc/admin

Files:

• common.php (modified) (1 diff)
• construct.php (modified) (1 diff)
• content.php (modified) (2 diffs)

better-wp-security/trunk/inc/admin/common.php

@@ -840 +840 @@
         function log404csv() {
 
-
+            global $wpdb;
+
+            @header( 'Content-type: text/x-csv' );
+            @header( 'Content-Transfer-Encoding: binary' );
+            @header( 'Content-Disposition: attachment; filename=404errors.csv' );
+            @header( 'Cache-Control: no-cache, must-revalidate' ); 
+            @header( 'Expires: Thu, 22 Jun 1978 00:28:00 GMT' );
+
+            @ini_set( 'auto_detect_line_endings', true );
+
+            $headers = array(
+                'url',
+                'time',
+                'host',
+                'referrer'
+            );
+
+            $errors = $wpdb->get_results( "SELECT url, timestamp, host, referrer, url FROM `" . $wpdb->base_prefix . "bwps_log` WHERE `type` = 2;", ARRAY_A );
+
+            array_unshift( $errors, $headers );
+
+            foreach ( $errors as $error ) {
+
+                foreach ( $error as $attr ) {
+
+                    echo $attr . ',';
+
+                }
+
+                echo PHP_EOL;
+
+            }
+            
+            exit;
 
         }

better-wp-security/trunk/inc/admin/construct.php

@@ -29 +29 @@
         
             add_action( 'admin_init', array( &$this, 'awaycheck' ) );
+
+            //Process 404 .csv file
+            if ( isset( $_GET['bit51_404_csv'] ) ) {
+
+                add_action( 'init', array( &$this, 'log404csv' ) );
+                
+            }
                 
         }

better-wp-security/trunk/inc/admin/content.php

@@ -2331 +2331 @@
             $log_content_4_table->prepare_items();
             $log_content_4_table->display();
-            
-            echo '<a href="admin.php?page=better-wp-security-logs&bit51_404_csv">' . __( 'Download 404 Log in .csv format', $this->hook ) . '</a>';
-
-            //Process 404 .csv file
-            if ( isset( $_GET['bit51_404_csv'] ) ) {
-                 $this->log404csv();
-            }
+
+            ?>
+
+                <p><a href="<?php echo admin_url(); ?><?php echo is_multisite() ? 'network/' : ''; ?>admin.php?page=better-wp-security-logs&bit51_404_csv" target="_blank" ><?php _e( 'Download 404 Log in .csv format', $this->hook ); ?></a></p>
+
+            <?php
             
         }
@@ -2387 +2386 @@
                 ?>
                 
-                <p><a href="<?php echo admin_url(); ?><?php echo is_multisite() ? 'network/' : ''; ?>admin.php?page=better-wp-security-logs#file-change"><?php _e( 'Return to Log', $this->hook ); ?></a></p>
+                <p><a href="<?php echo admin_url(); ?><?php echo is_multisite() ? 'network/' : ''; ?>admin.php?page=better-wp-security-logs#file-change" ><?php _e( 'Return to Log', $this->hook ); ?></a></p>
                 
             <?php