includes/admin/components/watchdog/index.php ➔ wsl_component_watchdog_database()

Complexity

Conditions	24
Paths	6

Size

Total Lines

163

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function wsl_component_watchdog_database()
{
	$assets_base_url = WORDPRESS_SOCIAL_LOGIN_PLUGIN_URL . 'assets/img/16x16/';

	global $wpdb;

	// If action eq delete WSL user profiles
	if( isset( $_REQUEST['delete'] ) && isset( $_REQUEST['_wpnonce'] ) && wp_verify_nonce( $_REQUEST['_wpnonce'] ) )
	{
		if( $_REQUEST['delete'] == 'log' )
		{
			$wpdb->query( "TRUNCATE TABLE {$wpdb->prefix}wslwatchdog" );
		}
	}
?>
<style>
	.widefatop td, .widefatop th { border: 1px solid #DDDDDD; }
	.widefatop th label { font-weight: bold; }
</style>

<div style="padding: 5px 20px; border: 1px solid #ddd; background-color: #fff;">

	<h3><?php _wsl_e("Authentication log viewer - latest activity", 'wordpress-social-login') ?></h3>

	<p style="float: right;margin-top:-45px">
		<?php
			$delete_url = wp_nonce_url( 'options-general.php?page=wordpress-social-login&wslp=watchdog&delete=log' );
		?>
		<a class="button button-secondary" style="background-color: #da4f49;border-color: #bd362f;text-shadow: 0 -1px 0 rgba(0, 0, 0, 0.25);color: #ffffff;" href="<?php echo $delete_url ?>" onClick="return confirm('Are you sure?');"><?php _wsl_e("Delete WSL Log", 'wordpress-social-login'); ?></a>
	</p>

	<hr />

	<?php
		$list_sessions = $wpdb->get_results( "SELECT user_ip, session_id, provider, max(id) as max_id FROM `{$wpdb->prefix}wslwatchdog` GROUP BY session_id, provider ORDER BY max_id DESC LIMIT 25" );

		if( ! $list_sessions )
		{
			_wsl_e("<p>No log found!</p>", 'wordpress-social-login');
		}
		else
		{
			foreach( $list_sessions as $seesion_data )
			{
				$user_ip    = $seesion_data->user_ip;
				$session_id = $seesion_data->session_id;
				$provider   = $seesion_data->provider;

				if( ! $provider )
				{
					continue;
				}

				?>
				<div style="padding: 15px; margin-bottom: 8px; border: 1px solid #ddd; background-color: #fff;box-shadow: 0 1px 3px rgba(0, 0, 0, 0.1);">
					<img src="<?php echo $assets_base_url . strtolower( $provider ) . '.png' ?>" style="vertical-align:top;width:16px;height:16px;" /> <?php echo sprintf( _wsl__("<b>%s</b> : %s - %s", 'wordpress-social-login'), $provider, $user_ip, $session_id ) ?>
				</div>

				<table class="wp-list-table widefat widefatop">
					<tr>
						<th>#</th>
						<th>Action</th>
						<th>Args</th>
						<th>Time</th>
						<th>User</th>
						<th style="text-align:center">&#916;</th>
					</tr>
			<?php
				$list_calls = $wpdb->get_results( "SELECT * FROM `{$wpdb->prefix}wslwatchdog` WHERE session_id = '$session_id' AND provider = '$provider' ORDER BY id ASC LIMIT 500" );

				$abandon    = false;

$abandon is not used, you could remove the assignment.

				$newattempt = false;

$newattempt is not used, you could remove the assignment.

				$newsession = true;

$newsession is not used, you could remove the assignment.

				$functcalls = 0;

$functcalls is not used, you could remove the assignment.

				$exectime   = 0;

$exectime is not used, you could remove the assignment.

				$oexectime  = 0;
				$texectime  = 0;

				foreach( $list_calls as $call_data )
				{
					$exectime = (float) $call_data->created_at - ( $oexectime ? $oexectime : (float) $call_data->created_at );
					$oexectime = (float) $call_data->created_at;
					$texectime += $exectime;

					$call_data->action_args = json_decode( $call_data->action_args );

					$newattempt = false;

$newattempt is not used, you could remove the assignment.

					$action_name_uid = uniqid();

					$action_desc = 'N.A.';

$action_desc is not used, you could remove the assignment.

					?>
					<tr  style="<?php if( stristr( $call_data->action_name, 'dbg:' ) ) echo 'background-color:#fffcf5;'; ?> <?php if( 'wsl_render_login_form_user_loggedin' == $call_data->action_name || $call_data->action_name == 'wsl_hook_process_login_before_wp_set_auth_cookie' ) echo 'background-color:#edfff7;'; ?><?php if( 'wsl_process_login_complete_registration_start' == $call_data->action_name ) echo 'background-color:#fefff0;'; ?><?php if( 'wsl_process_login_render_error_page' == $call_data->action_name || $call_data->action_name == 'wsl_process_login_render_notice_page' ) echo 'background-color:#fffafa;'; ?>">
						<td nowrap width="10">
							<?php echo $call_data->id; ?>
						</td>
						<td nowrap width="350">
							<span style="color:#<?php
											if( stristr( $call_data->action_name, 'dbg:' ) ){
												echo '333333';
											}

											if( 'wsl_hook_process_login_before_wp_safe_redirect' == $call_data->action_name ){
												echo 'a6354b';
											}

											if( 'wsl_hook_process_login_before_wp_set_auth_cookie' == $call_data->action_name ){
												echo '9035a6';
											}

											if( 'wsl_process_login_render_error_page' == $call_data->action_name ){
												echo 'f50505';
											}

											if( 'wsl_process_login_render_notice_page' == $call_data->action_name ){
												echo 'fa1797';
											}
										?>"
										><?php echo $call_data->action_name; ?></span>
						</td>
						<td>
							<span style="float:right;"><a style="font-size:25px" href="javascript:void(0);" onClick="action_args_toggle( '<?php echo $action_name_uid; ?>' )">+</a></span>
							<a href="javascript:alert('<?php echo $call_data->url; ?>');">
								<small>
									<?php
										echo substr( $call_data->url, 0, 100 );
										echo strlen( $call_data->url ) > 100 ? '...' : '';
									?>
								</small>
							</a>
							<pre style="display:none; overflow:scroll; background-color:#fcfcfc; color:#808080;font-size:11px;max-width:750px;" class="action_args_<?php echo $action_name_uid; ?>"><?php echo htmlentities( print_r( $call_data->action_args, true ) ); ?></pre>
						</td>
						<td nowrap width="115">
							<?php echo date( "Y-m-d h:i:s", $call_data->created_at ); ?>
						</td>
						<td nowrap width="40">
							<?php if( $call_data->user_id ) echo '<a href="options-general.php?page=wordpress-social-login&wslp=users&uid=' . $call_data->user_id . '">#' . $call_data->user_id . '</a>'; ?>
						</td>
						<td nowrap width="10" style="<?php if( $exectime > 0.5 ) echo 'color: #f44 !important;'; ?>">
							<?php echo number_format( $exectime, 3, '.', '' ); ?>
						</td>
					</tr>
				<?php
				}
			?>
			</table>
			<?php
				echo number_format( $texectime, 3, '.', '' );
				echo '<br />';
			}
		}
	?>
	<script>
		function action_args_toggle( action )
		{
			jQuery('.action_args_' + action ).toggle();

			return false;
		}
	</script>
</div>
<?php
}