/wp-content/plugins/better-wp-security/core/class-itsec-logger-all-logs.php

<?php

/**
 * Log tables for Authentication Module
 *
 * @package    iThemes-Security
 * @subpackage Authentication
 * @since      4.0
 */
final class ITSEC_Logger_All_Logs extends ITSEC_WP_List_Table {

	function __construct() {

		parent::__construct(
			array(
				'singular' => 'itsec_raw_log_item',
				'plural'   => 'itsec_raw_log_items',
				'ajax'     => true
			)
		);

	}

	/**
	 * Define type column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_time( $item ) {

		return $item['time'];

	}

	/**
	 * Define function column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_function( $item ) {

		return $item['function'];

	}

	/**
	 * Define priority column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_priority( $item ) {

		return $item['priority'];

	}

	/**
	 * Define host column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_host( $item ) {
		require_once( ITSEC_Core::get_core_dir() . '/lib/class-itsec-lib-ip-tools.php' );

		$r = array();
		if ( ! is_array( $item['host'] ) ) {
			$item['host'] = array( $item['host'] );
		}
		foreach ( $item['host'] as $host ) {
			if ( ITSEC_Lib_IP_Tools::validate( $host ) ) {
				$r[] = '<a href="' . esc_url( ITSEC_Lib::get_trace_ip_link( $host ) ) . '" target="_blank" rel="noopener noreferrer">' . esc_html( $host ) . '</a>';
			}
		}
		$return = implode( '<br />', $r );

		return $return;

	}

	/**
	 * Define username column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_user( $item ) {

		if ( 0 != $item['user_id'] ) {
			return '<a href="' . esc_url( admin_url( 'user-edit.php?user_id=' . $item['user_id'] ) ) . '" target="_blank" rel="noopener noreferrer">' . $item['user'] . '</a>';
		} else {
			return $item['user'];
		}

	}

	/**
	 * Define url column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_url( $item ) {

		return $item['url'];

	}

	/**
	 * Define referrer column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_referrer( $item ) {

		return $item['referrer'];

	}

	/**
	 * Define data column
	 *
	 * @param array $item array of row data
	 *
	 * @return string formatted output
	 *
	 **/
	function column_data( $item ) {

		global $itsec_logger;

		$raw_data = maybe_unserialize( $item['data'] );

		$data = apply_filters( "itsec_logger_filter_{$item['type']}_data_column_details", '', $raw_data );

		if ( empty( $data ) ) {
			if ( is_array( $raw_data ) && sizeof( $raw_data ) > 0 ) {

				$data = $itsec_logger->print_array( $raw_data, true );

			} elseif ( ! is_array( $raw_data ) ) {

				$data = sanitize_text_field( $raw_data );

			} else {

				$data = '';

			}
		}

		if ( strlen( $data ) > 1 ) {

			$content = '<div class="itsec-all-log-dialog" id="itsec-log-all-row-' . $item['id'] . '" style="display:none;">';
			$content .= $data;
			$content .= '</div>';

			$content .= '<a href="itsec-log-all-row-' . $item['id'] . '" class="dialog">' . __( 'Details', 'better-wp-security' ) . '</a>';

			return $content;

		} else {

			return '';

		}

	}

	/**
	 * Define Columns
	 *
	 * @return array array of column titles
	 */
	public function get_columns() {

		return array(
			'function' => __( 'Function', 'better-wp-security' ),
			'priority' => __( 'Priority', 'better-wp-security' ),
			'time'     => __( 'Time', 'better-wp-security' ),
			'host'     => __( 'Host', 'better-wp-security' ),
			'user'     => __( 'User', 'better-wp-security' ),
			'url'      => __( 'URL', 'better-wp-security' ),
			'referrer' => __( 'Referrer', 'better-wp-security' ),
			'data'     => __( 'Data', 'better-wp-security' ),
		);

	}

	/**
	 * Prepare data for table
	 *
	 * @return void
	 */
	public function prepare_items() {

		global $itsec_logger, $wpdb;

		$columns               = $this->get_columns();
		$hidden                = array();
		$this->_column_headers = array( $columns, $hidden, false );
		$per_page              = 20; //20 items per page
		$current_page          = $this->get_pagenum();
		$total_items           = $wpdb->get_var( "SELECT COUNT(*) FROM `" . $wpdb->base_prefix . "itsec_log`;" );

		$items = $itsec_logger->get_events( 'all', array(), $per_page, ( ( $current_page - 1 ) * $per_page ), 'log_date' );

		$table_data = array();

		$count = 0;

		foreach ( $items as $item ) { //loop through and group 404s

			$table_data[ $count ]['id']       = $count;
			$table_data[ $count ]['type']     = sanitize_text_field( $item['log_type'] );
			$table_data[ $count ]['function'] = sanitize_text_field( $item['log_function'] );
			$table_data[ $count ]['priority'] = sanitize_text_field( $item['log_priority'] );
			$table_data[ $count ]['time']     = sanitize_text_field( $item['log_date'] );
			$table_data[ $count ]['host']     = sanitize_text_field( $item['log_host'] );
			$table_data[ $count ]['user']     = sanitize_text_field( $item['log_username'] );
			$table_data[ $count ]['user_id']  = sanitize_text_field( $item['log_user'] );
			$table_data[ $count ]['url']      = sanitize_text_field( $item['log_url'] );
			$table_data[ $count ]['referrer'] = sanitize_text_field( $item['log_referrer'] );
			$table_data[ $count ]['data']     = $item['log_data'];

			$count ++;

		}

		$this->items = $table_data;

		$this->set_pagination_args(
			array(
				'total_items' => $total_items,
				'per_page'    => $per_page,
				'total_pages' => ceil( $total_items / $per_page )
			)
		);

	}

}