File "cerber-users.php"
Full Path: /home/concvitk/public_html/wp-content/plugins/wp-cerber/admin/cerber-users.php
File size: 38.3 KB
MIME-type: text/x-php
Charset: utf-8
<?php
add_action( 'personal_options', function ( $profileuser ) {
if ( lab_lab() ) :
?>
<tr>
<th scope="row">
<label for="cerber_user_2fa"><?php _e( 'Two-Factor Authentication', 'wp-cerber' ); ?>
</label>
</th>
<td>
<?php
$cus = cerber_get_set( CRB_USER_SET, $profileuser->ID );
$selected = ( empty( $cus['tfm'] ) ) ? 0 : $cus['tfm'];
echo cerber_select( 'cerber_user_2fa', array(
0 => __( 'Determined by user role policies', 'wp-cerber' ),
1 => __( 'Always enabled', 'wp-cerber' ),
2 => __( 'Disabled', 'wp-cerber' ),
), $selected );
?>
</td>
</tr>
<?php
endif;
$pin = CRB_2FA::get_user_pin_info( $profileuser->ID );
if ( $pin ) :
?>
<tr>
<th scope="row"><?php _e( '2FA PIN Code', 'wp-cerber' ); ?></th>
<td>
<?php
echo $pin;
?>
</td>
</tr>
<?php
endif;
if ( defined( 'IS_PROFILE_PAGE' ) && IS_PROFILE_PAGE ) {
return;
}
$b = crb_is_user_blocked( $profileuser->ID );
$b_msg = ( ! empty( $b['blocked_msg'] ) ) ? $b['blocked_msg'] : '';
$b_note = ( ! empty( $b['blocked_note'] ) ) ? $b['blocked_note'] : '';
$dsp = ( ! $b ) ? 'display:none;' : '';
?>
<tr>
<th scope="row"><?php _e( 'Block User', 'wp-cerber' ); ?></th>
<td>
<fieldset>
<legend class="screen-reader-text">
<span><?php _e( 'User is not permitted to log into the website', 'wp-cerber' ) ?></span>
</legend>
<label for="crb_user_blocked">
<input name="crb_user_blocked" type="checkbox" id="crb_user_blocked"
value="1" <?php
checked( ( $b ) ? true : false ); ?> />
<?php _e( 'User is not permitted to log into the website', 'wp-cerber' );
if ( $by_who = crb_user_blocked_by( $b ) ) {
echo ' - <i>' . $by_who . '</i>';
}
?>
</label>
</fieldset>
</td>
</tr>
<tr class="crb_blocked_txt" style="<?php echo $dsp; ?>">
<th scope="row"><?php _e( 'User Message', 'wp-cerber' ); ?></th>
<td>
<textarea placeholder="<?php _e( 'An optional message for this user', 'wp-cerber' ); ?>"
id="crb_blocked_msg" name="crb_blocked_msg"><?php echo htmlspecialchars( $b_msg, ENT_SUBSTITUTE ); ?></textarea>
</td>
</tr>
<tr class="crb_blocked_txt" style="<?php echo $dsp; ?>">
<th scope="row"><?php _e( 'Admin Note', 'wp-cerber' ); ?></th>
<td>
<textarea placeholder="<?php _e( 'It is visible only to website administrators', 'wp-cerber' ); ?>"
id="crb_blocked_note" name="crb_blocked_note"><?php echo htmlspecialchars( $b_note, ENT_SUBSTITUTE ); ?></textarea>
</td>
</tr>
<?php
}, 1000 );
add_filter( 'user_contactmethods', function ( $methods, $user ) {
if ( lab_lab() ) {
$methods['cerber_2fa_email'] = __( 'Two-Factor Authentication Email', 'wp-cerber' );
}
return $methods;
}, 0, 2 );
add_action( 'edit_user_profile_update', function ( $user_id ) {
crb_admin_user2fa( $user_id );
if ( $user_id == get_current_user_id() ) {
return;
}
$b = absint( cerber_get_post( 'crb_user_blocked' ) );
if ( ! $b ) {
delete_user_meta( $user_id, CERBER_BUKEY );
}
else {
cerber_block_user( $user_id, strip_tags( stripslashes( $_POST['crb_blocked_msg'] ) ), strip_tags( stripslashes( $_POST['crb_blocked_note'] ) ) );
}
} );
add_action( 'personal_options_update', 'crb_admin_user2fa' );
function crb_admin_user2fa( $user_id ) {
$cus = cerber_get_set( CRB_USER_SET, $user_id );
if ( ! $cus || ! is_array( $cus ) ) {
$cus = array();
}
if ( ! isset( $_POST['cerber_user_2fa'] ) ) {
return;
}
$cus['tfm'] = absint( $_POST['cerber_user_2fa'] );
if ( ( $email = trim( cerber_get_post( 'cerber_2fa_email' ) ) ) ) {
if ( is_email( $email ) ) {
$cus['tfemail'] = $email;
}
else {
add_action( 'user_profile_update_errors', function ( $errors ) {
$errors->add( 'invalid-email', 'Invalid email address for Two-factor authentication' );
} );
}
}
else {
$cus['tfemail'] = '';
}
cerber_update_set( CRB_USER_SET, $cus, $user_id );
if ( $cus['tfm'] == 2 ) {
CRB_2FA::delete_2fa( $user_id, true );
}
}
add_filter( 'user_row_actions', 'crb_collect_uids', 10, 2 );
add_filter( 'ms_user_row_actions', 'crb_collect_uids', 10, 2 );
function crb_collect_uids( $actions, $user_object ) {
crb_users_on_the_page( $user_object );
return $actions;
}
function crb_users_on_the_page( $user_object = null ) {
static $list = array();
if ( $user_object ) {
$list[ $user_object->ID ] = $user_object->user_login;
}
else {
return $list;
}
}
add_filter( 'views_users', function ( $views ) {
global $wpdb;
$c = cerber_db_get_var( 'SELECT COUNT(meta_key) FROM ' . $wpdb->usermeta . ' WHERE meta_key = "' . CERBER_BUKEY . '"' );
$t = __( 'Blocked Users', 'wp-cerber' );
if ( $c ) {
$t = '<a href="users.php?crb_filter_users=blocked">' . $t . '</a>';
}
$views['cerber_blocked'] = $t . ' (' . $c . ')';
return $views;
} );
add_filter( 'users_list_table_query_args', function ( $args ) {
if ( isset( $_REQUEST['crb_filter_users'] ) ) {
$args['meta_key'] = CERBER_BUKEY;
$args['meta_compare'] = 'EXISTS';
}
return $args;
} );
function crb_format_user_name( $user ) {
if ( is_integer( $user ) ) {
$user = get_userdata( $user );
}
if ( ! $user ) {
return 'Unknown user';
}
if ( $user->first_name ) {
$ret = $user->first_name . ' ' . $user->last_name;
}
else {
$ret = $user->display_name;
}
return $ret . ' (' . $user->user_login . ')';
}
// Bulk actions
add_filter( "bulk_actions-users", function ( $actions ) {
$actions['cerber_block_users'] = __( 'Block', 'wp-cerber' );
return $actions;
} );
add_filter( "handle_bulk_actions-users", function ( $url ) {
if ( cerber_get_bulk_action() == 'cerber_block_users' ) {
if ( $users = cerber_get_get( 'users', '\d+' ) ) {
foreach ( $users as $user_id ) {
cerber_block_user( absint( $user_id ) );
}
}
else {
// 'No users selected';
}
$preserve = array( 's', 'paged', 'role', 'crb_filter_users' );
$remove = array_diff(
array_keys( crb_get_query_params() ),
$preserve );
$url = remove_query_arg( $remove, $url );
}
return $url;
} );
function cerber_block_user( $user_id, $msg = '', $note = '' ) {
if ( ! is_super_admin() ) {
return;
}
if ( $user_id == get_current_user_id() ) {
return;
}
if ( ( $m = get_user_meta( $user_id, CERBER_BUKEY, true ) )
&& ! empty( $m['blocked'] )
&& $m[ 'u' . $user_id ] == $user_id
&& $m['blocked_msg'] == $msg
&& $m['blocked_note'] == $note ) {
return;
}
if ( ! $m || ! is_array( $m ) ) {
$m = array();
}
if ( empty( $m['blocked'] ) ) {
$m['blocked_time'] = time();
$m['blocked'] = 1;
$m[ 'u' . $user_id ] = $user_id;
$m['blocked_by'] = get_current_user_id();
$m['blocked_ip'] = cerber_get_remote_ip();
}
$m['blocked_msg'] = $msg;
$m['blocked_note'] = $note;
update_user_meta( $user_id, CERBER_BUKEY, $m );
crb_destroy_user_sessions( $user_id );
}
function crb_admin_show_role_policies() {
$roles = wp_roles();
$tabs_config = array();
$policies = crb_get_settings( 'crb_role_policies' );
foreach ( $roles->role_names as $role_id => $name ) {
$tabs_config[ $role_id ] = array(
'title' => $name,
//'desc' => $info,
'content' => crb_admin_role_form( $role_id, crb_array_get( $policies, $role_id ) ),
);
}
crb_admin_show_vtabs( $tabs_config, __( 'Save All Changes', 'wp-cerber' ), array( 'cerber_admin_do' => 'update_role_policies' ) );
}
function crb_admin_role_form( $role_id, $values ) {
$html = '<table class="form-table">';
foreach ( crb_admin_role_config() as $section_id => $config ) {
foreach ( $config['fields'] as $field_id => $field ) {
$pro = ( isset( CRB_PRO_POLICIES[ $field_id ] ) && ! lab_lab() );
$hide = ( $pro && CRB_PRO_POLICIES[ $field_id ][0] == 2 ) ? 'display:none;' : '';
$title = crb_array_get( $field, 'title', '' );
if ( empty( $field['disabled'] ) ) {
$field['disabled'] = ( crb_array_get( $field, 'disable_role' ) == $role_id );
}
if ( $field_id == '2famode' && $role_id == 'administrator' ) {
$field['disabled'] = ! cerber_2fa_checker();
}
$enabler = '';
if ( isset( $field['enabler'] ) ) {
$enabler .= ' data-input_enabler="' . CRB_FIELD_PREFIX . $role_id . '[' . $field['enabler'][0] . ']" ';
if ( isset( $field['enabler'][1] ) ) {
$enabler .= ' data-input_enabler_value="' . $field['enabler'][1] . '" ';
}
}
$s = ( $pro ) ? ' color: #888; ' : '';
$tr_class = '';
if ( isset( $field['enabler'] ) ) {
$tr_class = crb_check_enabler( $field, crb_array_get( $values, $field['enabler'][0], '' ) );
}
if ( ! empty( $field['disabled'] ) ) {
$tr_class .= ' crb-disabled-colors';
}
if ( $field['type'] != 'html' ) {
//$value = ( ! $pro ) ? crb_array_get( $values, $field_id, '' ) : '';
$value = crb_array_get( $values, $field_id, '' );
$field['pro'] = isset( CRB_PRO_POLICIES[ $field_id ] );
$field_html = crb_admin_form_field( $field, $role_id . '[' . $field_id . ']', $value );
$html .= '<tr style="' . $hide . '" class="' . $tr_class . '"><th scope="row" style="' . $s . '">' . $title . '</th><td>' . $field_html . '<i ' . $enabler . '></i></td></tr>';
}
else {
$t = ( $pro && $field_id == '2fasmart' ) ? crb_admin_cool_features() : '';
$html .= '<tr class="' . $tr_class . '"><td colspan="2" style="padding-left: 0; ' . $s . '">' . $t . $title . '<i ' . $enabler . '></i></td></tr>';
}
}
}
$html .= '</table>';
return $html;
}
function crb_admin_form_field( $field, $name, $value, $id = '' ) {
$value = crb_attr_escape( $value );
$label = crb_array_get( $field, 'label' );
if ( ! $id ) {
$id = CRB_FIELD_PREFIX . $name;
}
$atts = '';
if ( $field['disabled'] ) {
// || ( ! empty( $field['pro'] ) && ! lab_lab() ) ) {
$atts = ' disabled ';
}
if ( $field['disabled'] ) {
$value = '';
}
if ( isset( $field['placeholder'] ) ) {
$atts .= ' placeholder="' . $field['placeholder'] . '"';
}
$style = '';
if ( isset( $field['width'] ) ) {
$style .= ' width:' . $field['width'];
}
switch ( $field['type'] ) {
case 'checkbox':
return cerber_checkbox( $name, $value, $label, $id, $atts );
break;
case 'select':
return cerber_select( $name, $field['set'], $value, '', $id, '', '', null, $atts );
break;
case 'textarea':
$html = '<textarea class="large-text crb-monospace" id="' . $id . '" name="' . $name . '" ' . $atts . '>' . $value . '</textarea>';
if ( $label ) {
$html .= '<br/><label class="crb-below" for="' . $id . '">' . $label . '</label>';
}
return $html;
break;
case 'text':
default:
$type = crb_array_get( $field, 'type', 'text' );
//return $pre . '<input type="' . $type . '" id="' . $id . '" name="' . $name . '" value="' . $value . '"' . $atts . ' class="' . $class . '" ' . $size . $maxlength . $atts . $data . ' />';
return '<input style="' . $style . '" type="' . $type . '" id="' . $id . '" name="' . $name . '" value="' . $value . '" ' . $atts . ' />';
break;
}
}
function crb_admin_role_config() {
return array(
'access' => array(
'name' => '',
'desc' => '',
'fields' => array(
'nodashboard' => array(
'title' => __( 'Block access to WordPress Dashboard', 'wp-cerber' ),
'type' => 'checkbox',
'disable_role' => 'administrator',
),
'notoolbar' => array(
'title' => __( 'Hide Toolbar when viewing site', 'wp-cerber' ),
'type' => 'checkbox',
),
)
),
'redirect' => array(
'name' => __( 'Redirection rules', 'wp-cerber' ),
'desc' => '',
'fields' => array(
'rdr_login' => array(
'title' => __( 'Redirect user after login', 'wp-cerber' ),
'type' => 'text',
'width' => '100%',
),
'rdr_logout' => array(
'title' => __( 'Redirect user after logout', 'wp-cerber' ),
'type' => 'text',
'width' => '100%',
),
)
),
'misc' => array(
'name' => '',
'desc' => '',
'fields' => array(
'auth_expire' => array(
'title' => __( 'User session expiration time', 'wp-cerber' ),
//'label' => 'minutes',
'placeholder' => 'minutes',
'type' => 'number',
),
'sess_limit' => array(
'title' => __( 'Number of allowed concurrent user sessions', 'wp-cerber' ),
'type' => 'number',
'pro' => 2
),
'sess_limit_policy' => array(
'title' => __( 'When the limit on concurrent user sessions is reached', 'wp-cerber' ),
'type' => 'select',
'set' => array(
0 => __( 'Terminate the oldest user session on a new login', 'wp-cerber' ),
1 => __( 'Deny further login attempts', 'wp-cerber' ),
),
'pro' => 2
),
'sess_limit_msg' => array(
//'title' => __( 'User message', 'wp-cerber' ),
'label' => __( 'Display this message if an attempt to log in is denied because the limit on concurrent user sessions has been reached', 'wp-cerber' ),
'type' => 'textarea',
'placeholder' => __( 'You are not allowed to log in. Ask your administrator for assistance.', 'wp-cerber' ),
'enabler' => array( 'sess_limit_policy', 1 ),
'pro' => 2
),
'app_pwd' => array(
'title' => __( 'Application Passwords', 'wp-cerber' ),
'type' => 'select',
'set' => array(
0 => __( 'Use global policies', 'wp-cerber' ),
1 => __( 'Enabled, access to API using standard user passwords is allowed', 'wp-cerber' ),
2 => __( 'Enabled, no access to API using standard user passwords', 'wp-cerber' ),
3 => __( 'Disabled', 'wp-cerber' ),
),
'pro' => 2
),
)
),
'twofactor' => array(
'name' => __( 'Two-Factor Authentication', 'wp-cerber' ),
'desc' => '',
'fields' => array(
'2famode' => array(
'title' => __( 'Two-factor authentication', 'wp-cerber' ),
'type' => 'select',
'set' => array(
0 => __( 'Disabled', 'wp-cerber' ),
1 => __( 'Always enabled', 'wp-cerber' ),
2 => __( 'Advanced mode', 'wp-cerber' )
),
),
'2fasmart' => array(
'title' => __( 'Enforce two-factor authentication if any of the following conditions is true', 'wp-cerber' ),
'type' => 'html',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fanewcountry' => array(
'title' => __( 'Login from a different country', 'wp-cerber' ),
'type' => 'checkbox',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fanewnet4' => array(
'title' => __( 'Login from a different network Class C', 'wp-cerber' ),
'type' => 'checkbox',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fanewip' => array(
'title' => __( 'Login from a different IP address', 'wp-cerber' ),
'type' => 'checkbox',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fanewua' => array(
'title' => __( 'Login from a different browser or device', 'wp-cerber' ),
'type' => 'checkbox',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fasessions' => array(
'title' => __( 'If the number of concurrent user sessions is greater', 'wp-cerber' ),
'type' => 'number',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'note2' => array(
'title' => __( 'Enforce two-factor authentication with fixed intervals', 'wp-cerber' ),
'type' => 'html',
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2fadays' => array(
'title' => __( 'Regular time intervals (days)', 'wp-cerber' ),
'type' => 'number',
//'label' => __( 'days interval', 'wp-cerber' ),
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
'2falogins' => array(
'title' => __( 'Fixed number of logins', 'wp-cerber' ),
'type' => 'number',
'label' => __( 'number of logins', 'wp-cerber' ),
'enabler' => array( '2famode', 2 ),
'pro' => 1
),
)
),
);
}
function crb_admin_save_role_policies( $post ) {
$roles = wp_roles();
$policies = array();
foreach ( $roles->role_names as $role_id => $name ) {
$policies[ $role_id ] = $post[ $role_id ];
}
array_walk_recursive( $policies, function ( &$element, $key ) {
$element = trim( $element );
if ( $key == 'rdr_logout' ) {
if ( false !== strrpos( $element, 'wp-admin' ) ) {
$element = '';
}
}
if ( $element && in_array( $key, array( 'rdr_login', 'rdr_logout' ) ) ) {
if ( substr( $element, 0, 4 ) != 'http'
&& $element[0] != '/' ) {
$element = '/' . $element;
}
}
if ( ! is_array( $element )
&& ! is_numeric( $element ) ) {
$element = sanitize_text_field( (string) $element );
}
} );
if ( ! $settings = get_site_option( CERBER_SETTINGS ) ) {
$settings = array();
}
$settings['crb_role_policies'] = $policies;
if ( cerber_update_site_option( CERBER_SETTINGS, $settings ) ) {
cerber_admin_message( __( 'Policies have been updated', 'wp-cerber' ) );
}
}
function crb_destroy_user_sessions( $user_id ) {
if ( ! $user_id || get_current_user_id() == $user_id ) {
return;
}
$manager = WP_Session_Tokens::get_instance( $user_id );
$manager->destroy_all();
}
function crb_admin_is_current_session( $session_id ) {
static $st = null;
if ( $st === null ) {
$st = crb_get_session_token();
}
return ( $session_id === cerber_hash_token( $st ) );
}
function crb_admin_get_user_cell( $user_id = null, $base_url = '', $text = '', $label = '' ) {
static $wp_roles, $user_cache = array();
if ( ! $user_id ) {
return '';
}
$key = $user_id . '-' . sha1( (string) $text . ' ' . (string) $label );
if ( isset( $user_cache[ $key ] ) ) {
return $user_cache[ $key ];
}
if ( ! $user = get_userdata( $user_id ) ) {
if ( ! $user_data = cerber_get_set( 'user_deleted', $user_id ) ) {
$user_cache[ $key ] = 'UID ' . $user_id;
return '';
}
}
else {
$user_data = array( 'roles' => $user->roles, 'display_name' => $user->display_name );
}
if ( ! isset( $wp_roles ) ) {
$wp_roles = wp_roles()->roles;
}
$roles = '';
if ( ! is_multisite() && $user_data['roles'] ) {
$r = array();
foreach ( $user_data['roles'] as $role ) {
$r[] = $wp_roles[ $role ]['name'];
}
$roles = '<span class="crb_act_role">' . implode( ', ', $r ) . '</span>';
}
$lbl = ( $label ) ? '<span class="crb-us-lbl">' . $label . '</span>' : '';
if ( $base_url ) {
$ret = '<a href="' . $base_url . '&filter_user=' . $user_id . '"><b>' . $user_data['display_name'] . '</b></a>' . $lbl . '<p>' . $roles . '</p>';
}
else {
$ret = '<b>' . $user_data['display_name'] . '</b>' . $lbl . '<p>' . $roles . '</p>';
}
$ret = '<div class="crb-us-name">' . $ret . '</div>';
if ( $avatar = get_avatar( $user_id, 32 ) ) {
$avatar = '<td>' . $avatar . '</td>';
}
else {
$avatar = '';
}
$user_cache[ $key ] = '<table class="crb-avatar"><tr>' . $avatar . '<td>' . $ret . $text . '</td></tr></table>';
return $user_cache[ $key ];
}
function crb_admin_show_sessions() {
// Helper for WP_List_Table URLs and navigation links
if ( nexus_is_valid_request() ) {
// Add parameters
$add = array( 'paged', 'order', 'orderby' );
foreach ( $add as $param ) {
//if ( $val = crb_array_get( crb_get_query_params(), $param ) ) {
if ( $val = crb_get_query_params( $param ) ) {
$_REQUEST[ $param ] = $val;
$_GET[ $param ] = $val;
}
}
// Correct URL
add_filter( 'set_url_scheme', function ( $url, $scheme, $orig_scheme ) {
return cerber_admin_link( 'sessions' );
}, 10, 3 );
}
echo '<form id="crb-user-sessions" method="get" action="">';
cerber_nonce_field( 'control', true );
echo '<input type="hidden" name="page" value="' . crb_admin_get_page() . '">';
echo '<input type="hidden" name="tab" value="' . crb_admin_get_tab() . '">';
echo '<input type="hidden" name="cerber_admin_do" value="crb_manage_sessions">';
$slaves = new CRB_Sessions_Table();
$slaves->prepare_items();
//$slaves->search_box( 'Search', 'search_id' );
$slaves->display();
echo '</form>';
}
// Personal data exporters ----------------------------------------
function crb_pdata_exporter_act( $email_address, $page = 1 ) {
$per_page = 1000; // Rows per step (SQL query)
$limit = ( $per_page * ( absint( $page ) - 1 ) ) . ',' . $per_page;
$data = array();
if ( ( ! $user = get_user_by( 'email', $email_address ) )
|| ! $user->ID
|| ! $rows = cerber_get_log( null, array( 'id' => $user->ID ), null, $limit ) ) {
$done = true;
if ( $page == 1 ) { // Nothing was logged at all
$data[] = array( 'name' => 'Events', 'value' => 'None logged' );
}
}
else {
$done = false; // There are rows to be exported
$labels = cerber_get_labels( 'activity' );
foreach ( $rows as $row ) {
//$value = 'IP: ' . $row->ip . ' | ' . $labels[ $row->activity ];
$value = array( 'IP_ADDRESS' => $row->ip, 'EVENT' => $labels[ $row->activity ] );
if ( $row->user_login ) {
$value['USERNAME'] = $row->user_login;
}
$value = json_encode( $value, JSON_UNESCAPED_UNICODE );
// Format is defined by WordPress
$data[] = array( 'name' => cerber_date( $row->stamp, false ), // First column
'value' => $value // Second column
);
}
}
return crb_pdata_formater( $data, 'cerber-activity', 'Activity Log', $done );
}
function crb_pdata_exporter_trf( $email_address, $page = 1 ) {
$per_page = 500; // Rows per step (SQL query)
$limit = ( $per_page * ( absint( $page ) - 1 ) ) . ',' . $per_page;
$data = array();
if ( ( ! $user = get_user_by( 'email', $email_address ) )
|| ! $user->ID
|| ! $rows = cerber_db_get_results( 'SELECT ip, uri, stamp, request_fields, request_details FROM ' . CERBER_TRAF_TABLE . ' WHERE user_id = ' . $user->ID . ' LIMIT ' . $limit, MYSQL_FETCH_OBJECT ) ) {
$done = true;
if ( $page == 1 ) { // Nothing was logged at all
$data[] = array( 'name' => 'Events', 'value' => 'None logged' );
}
}
else {
$done = false; // There are rows to be exported
$what = crb_get_settings( 'pdata_trf' );
foreach ( $rows as $row ) {
$value = array( 'IP_ADDRESS' => $row->ip );
if ( isset( $what[1] ) ) {
$value['URL'] = $row->uri;
}
if ( isset( $what[2] ) ) {
$fields = crb_auto_decode( $row->request_fields );
if ( ! empty( $fields[1] ) ) {
$value['FORM_FIEDLS'] = $fields[1];
}
}
if ( isset( $what[3] ) ) {
$dets = crb_auto_decode( $row->request_details );
if ( ! empty( $dets[8] ) ) {
$value['COOKIES'] = $dets[8];
}
}
$value = json_encode( $value, JSON_UNESCAPED_UNICODE );
// Format is defined by WordPress
$data[] = array( 'name' => cerber_date( $row->stamp, false ), // First column
'value' => $value // Second column
);
}
}
return crb_pdata_formater( $data, 'cerber-traffic', 'Traffic Log', $done );
}
function crb_pdata_formater( $data = array(), $exp_id = '', $label = '', $done = true ) {
$export_items[] = array(
'group_id' => $exp_id,
'group_label' => $label,
'item_id' => $exp_id,
'data' => $data,
);
return array(
'data' => $export_items,
'done' => $done,
);
}
if ( crb_get_settings( 'pdata_export' ) ) {
add_filter( 'wp_privacy_personal_data_exporters', 'crb_pdata_register_exporters' );
}
function crb_pdata_register_exporters( $exporters ) {
if ( crb_get_settings( 'pdata_act' ) ) {
$exporters['cerber-security-act'] = array(
'exporter_friendly_name' => 'WP Cerber Activity',
'callback' => 'crb_pdata_exporter_act',
);
}
if ( crb_get_settings( 'pdata_trf' ) ) {
$exporters['cerber-security-trf'] = array(
'exporter_friendly_name' => 'WP Cerber Traffic',
'callback' => 'crb_pdata_exporter_trf',
);
}
return $exporters;
}
// Personal data erasers ----------------------------------------
function crb_pdata_eraser( $email_address, $page = 1 ) {
$removed = false;
$retained = false;
$done = true;
$msg = array();
if ( is_super_admin()
&& ( $user = get_user_by( 'email', $email_address ) )
&& $user->ID ) {
cerber_db_query( 'DELETE FROM ' . CERBER_LOG_TABLE . ' WHERE user_id = ' . $user->ID );
cerber_db_query( 'DELETE FROM ' . CERBER_TRAF_TABLE . ' WHERE user_id = ' . $user->ID );
if ( ( $reg = get_user_meta( $user->ID, '_crb_reg_', true ) )
&& ( empty( $reg['user'] ) || $reg['user'] == $user->ID ) ) {
delete_user_meta( $user->ID, '_crb_reg_' );
}
cerber_delete_set( 'user_deleted', $user->ID );
if ( crb_get_settings( 'pdata_sessions' ) ) {
update_user_meta( $user->ID , 'session_tokens', array() );
}
$removed = true;
// Check if removing is OK
if ( cerber_get_log( null, array( 'id' => $user->ID ), null, 1 )
|| cerber_db_get_var( 'SELECT user_id FROM ' . CERBER_TRAF_TABLE . ' WHERE user_id = ' . $user->ID . ' LIMIT 1' ) ) {
$removed = false;
$retained = true;
$done = false;
if ( $page >= 3 ) { // We failed after three attempts
$msg[] = 'WP Cerber is unable to delete rows in its log tables due to a database error. Check the server error log.';
$done = true;
}
}
}
return array(
'items_removed' => $removed,
'items_retained' => $retained,
'messages' => $msg,
'done' => $done,
);
}
if ( crb_get_settings( 'pdata_erase' ) ) {
add_filter( 'wp_privacy_personal_data_erasers', 'crb_pdata_register_eraser' );
}
function crb_pdata_register_eraser( $erasers ) {
$erasers['cerber-security-erase'] = array(
'eraser_friendly_name' => __( 'WP Cerber Personal Data Eraser' ),
'callback' => 'crb_pdata_eraser',
);
return $erasers;
}
/**
* Quick analysis - returns textual info if the user has any issue with logging in (from the WP Cerber point of view).
* Helps to troubleshot user logging in issues.
*
* @param WP_User $user
*
* @return array|false
*
* @since 9.0.2
*/
function crb_get_user_auth_status( $user ) {
$nope = '';
$nope_more = '';
if ( $b = crb_is_user_blocked( $user->ID ) ) {
$nope = crb_user_blocked_by( $b );
$nope_more = htmlspecialchars( $b['blocked_note'] );
return array( $nope, $nope_more, true );
}
if ( crb_is_username_prohibited( $user->user_login ) ) {
$nope = __( 'username is prohibited', 'wp-cerber' );
$nope_more = '<a href="' . cerber_admin_link( 'global_policies' ) . '" target="_blank">' . __( "Check users' settings", 'wp-cerber' ) . '</a>';
return array( $nope, $nope_more, true );
}
// Is user's IP blocked?
if ( $user_ip = crb_is_user_ip_blocked( $user ) ) {
$nope = __( 'The IP address of the last failed attempt to log in is blocked', 'wp-cerber' );
$remove = cerber_admin_link_add( array( 'cerber_admin_do' => 'lockdel', 'ip' => $user_ip ), true );
$nope_more = array( $user_ip, sprintf( __( 'If necessary, <%s>unblock the IP address<%s>.', 'wp-cerber' ), 'a href="' . $remove . '" onclick="return confirm(\'' . __( 'Are you sure?', 'wp-cerber' ) . '\');"', '/a' ) );
return array( $nope, $nope_more, false );
}
// Was the attempt to log in denied by WP Cerber?
$last_login = cerber_get_last_login( $user->ID );
$last_denied = crb_get_last_failed( $user->user_login, $user->user_login, true );
if ( $last_denied->stamp < $last_login->stamp ) {
return false; // Not relevant anymore, user has logged in
}
if ( $reason = cerber_get_labels( 'status', $last_denied->ac_status ) ) {
$nope = __( 'The last attempt to log in was denied due to the following reason', 'wp-cerber' );
$nope_more = array( $reason );
$knowledge_base = array( CRB_STS_11 => 'antispam', 14 => 'acl', 16 => 'geo' );
if ( $go = crb_array_get( $knowledge_base, $last_denied->ac_status ) ) {
$nope_more[] = sprintf( __( 'If necessary, <%s>check and update settings<%s>.', 'wp-cerber' ), 'a href="' . cerber_admin_link( $go ) . '" target="_blank"', '/a' );
}
}
if ( $nope ) {
return array( $nope, $nope_more, false );
}
return false;
}
/**
* @param string $nope
* @param string|array $nope_more
*
* @return string
*
* @since 9.0.2
*/
function crb_format_user_status( $nope, $nope_more, $prefix = true ) {
$p = ( $prefix ) ? __( 'User is not allowed to log in', 'wp-cerber' ) . ' - ' : '';
$more = '';
if ( $nope_more ) {
if ( ! is_array( $nope_more ) ) {
$nope_more = array( $nope_more );
}
$more = '<p>' . implode( '</p><p>', $nope_more ) . '</p>';
}
return '<span>' . $p . $nope . '</span>' . $more;
}
/**
* Detects if the user's IP is blocked due to multiple failed attempts to log in
*
* @param WP_User $user
*
* @return false|string The IP address of the last failed attempt to log in if the IP is blocked
*
* @since 9.0.2
*/
function crb_is_user_ip_blocked( $user ) {
// No blocked IP, no failed attempts
if ( ! cerber_db_get_row( 'SELECT * FROM ' . CERBER_BLOCKS_TABLE . ' LIMIT 1' )
//|| ! $last_failed = cerber_db_get_row( 'SELECT * FROM ' . CERBER_LOG_TABLE . ' WHERE ( user_login = "' . $user->user_login . '" OR user_login = "' . $user->user_email . '" ) AND activity = ' . CRB_EV_LFL . ' ORDER BY stamp DESC LIMIT 1', MYSQL_FETCH_OBJECT ) ) {
|| ! $last_failed = crb_get_last_failed( $user->user_login, $user->user_email ) ) {
return false;
}
// User logged in after several failed attempts - OK
if ( ( $last_login = cerber_get_last_login( $user->ID ) )
&& ( $last_failed->stamp < $last_login->stamp ) ) {
return false;
}
// Is user's IP locked?
if ( ( $block = cerber_get_block( $last_failed->ip ) )
&& $block->reason_id == 701 ) {
return $last_failed->ip;
}
return false;
}
class CRB_Sessions_Table extends WP_List_Table {
private $base_admin;
private $geo;
public function __construct() {
parent::__construct( array(
'singular' => 'Session',
'plural' => 'Sessions',
'ajax' => false,
'screen' => 'cerber_user_sessions' // Without this it does not work
) );
$this->geo = lab_lab();
$this->base_admin = wp_nonce_url( cerber_admin_link( 'sessions' ), 'control', 'cerber_nonce' );
}
// Columns definition
function get_columns() {
return array(
'cb' => '<input type="checkbox" />', //Render a checkbox instead of text
'ses_user' => __( 'User', 'wp-cerber' ),
//'ses_role' => __( 'Role', 'wp-cerber' ),
'ses_started' => __( 'Created', 'wp-cerber' ),
'ses_expires' => __( 'Expires', 'wp-cerber' ),
'ses_ip' => '<div class="crb_act_icon"></div>' . __( 'IP Address', 'wp-cerber' ),
'ses_host' => __( 'Host Info', 'wp-cerber' ),
'ses_action' => __( 'Action', 'wp-cerber' ),
);
}
// Sortable columns
function get_sortable_columns() {
return array(
'ses_user' => array( 'user_id', false ), // true means dataset is already sorted by ASC
'ses_started' => array( 'started', false ),
'ses_expires' => array( 'expires', false ),
'ses_ip' => array( 'ip', false ),
);
}
// Bulk actions
function get_bulk_actions() {
return array(
'bulk_session_terminate' => __( 'Terminate session', 'wp-cerber' ),
'bulk_block_user' => __( 'Block user', 'wp-cerber' ),
);
}
protected function extra_tablenav( $which ) {
if ( $which == 'top' ) {
?>
<div class="alignleft actions">
<?php
$filter = '';
$uname = '';
if ( $user_id = crb_get_query_params( 'filter_user', '\d+' ) ) {
if ( $u = get_userdata( $user_id ) ) {
$uname = crb_format_user_name( $u );
}
else {
$user_id = 0;
}
}
$filter .= cerber_select( 'filter_user', ( $user_id ) ? array( $user_id => $uname ) : array(), $user_id, 'crb-select2-ajax', '', false, esc_html__( 'Filter by registered user', 'wp-cerber' ), array( 'min_symbols' => 3 ) );
$search_ip = esc_attr( stripslashes( crb_get_query_params( 'search_ip' ) ) );
$filter .= '<input type="text" value="' . $search_ip . '" name="search_ip" placeholder="' . esc_html__( 'Search for IP address', 'wp-cerber' ) . '">';
echo '<div id="crb-top-filter">' . $filter . '<input type="submit" value="Filter" class="button button-primary action"></div>';
?>
</div>
<?php
}
}
function prepare_items() {
global $wpdb;
if ( ! crb_sessions_get_num() ) {
crb_sessions_sync_all();
}
else {
crb_sessions_del_expired();
}
$where = array();
$total_items = 0;
$get = crb_get_query_params();
// Sorting
$orderby = crb_array_get( $get, 'orderby', 'started', '\w+' );
$order = crb_array_get( $get, 'order', 'DESC', '\w+' );
$orderby = sanitize_sql_orderby( $orderby . ' ' . $order ); // !works only with fields, not tables references!
$orderby = ' ORDER BY ' . $orderby . ' ';
// Pagination, part 1, SQL
$per_page = crb_admin_get_per_page();
$current_page = $this->get_pagenum();
if ( $current_page > 1 ) {
$offset = ( $current_page - 1 ) * $per_page;
$limit = ' LIMIT ' . $offset . ',' . $per_page;
}
else {
$limit = 'LIMIT ' . $per_page;
}
// Search
if ( $user_id = crb_array_get( $get, 'filter_user', 0, '\d+' ) ) {
$where[] = 'user_id = ' . $user_id;
}
if ( $ip = stripslashes( crb_array_get( $get, 'search_ip' ) ) ) {
$where[] = 'ip LIKE "%' . preg_replace( '/[^:.\d]/', '', $ip ) . '%"';
}
$where = ( ! empty( $where ) ) ? ' WHERE ' . implode( ' AND ', $where ) : '';
// Retrieving data
$query = 'SELECT SQL_CALC_FOUND_ROWS * FROM ' . cerber_get_db_prefix() . CERBER_USS_TABLE . ' ses JOIN ' . $wpdb->users . ' us ON (ses.user_id = us.ID) ' . $where . $orderby . $limit;
if ( $this->items = cerber_db_get_results( $query ) ) {
$total_items = cerber_db_get_var( 'SELECT FOUND_ROWS()' );
}
if ( ! empty( $term ) ) {
echo '<div style="margin-top:15px;"><b>' . __( 'Search results for:', 'wp-cerber' ) . '</b> “' . htmlspecialchars( $term, ENT_SUBSTITUTE ) . '”</div>';
}
// Pagination, part 2
$this->set_pagination_args( array(
'total_items' => $total_items,
'per_page' => $per_page,
'total_pages' => ceil( $total_items / $per_page )
) );
}
public function single_row( $item ) {
//$item['user_data'] = get_userdata( $item['user_id'] );
parent::single_row( $item );
}
function column_cb( $item ) {
if ( ! crb_admin_is_current_session( $item['wp_session_token'] ) ) {
return '<input type="checkbox" name="ids[]" value="' . $item['wp_session_token'] . '" />';
}
return '';
}
/**
* @param array $item // not object!
* @param string $column_name
*
* @return string
*/
function column_default( $item, $column_name ) {
//return $item[ $column_name ]; // raw output as is
switch ( $column_name ) {
case 'ses_user':
$label = '';
$links = '';
if ( ! nexus_is_valid_request() ) {
$links = $this->row_actions( array(
'<a href="' . get_edit_user_link( $item['user_id'] ) . '">' . __( 'Profile', 'wp-cerber' ) . '</a>',
) );
$label = ( crb_admin_is_current_session( $item['wp_session_token'] ) ) ? __( 'You', 'wp-cerber' ) : '';
}
return crb_admin_get_user_cell( $item['user_id'], cerber_admin_link( 'sessions' ), $links, $label );
break;
case 'ses_started':
$logins = cerber_activity_link( array( CRB_EV_LIN ) ) . '&filter_user=' . $item['user_id'];
$set = array(
'<a href="' . $logins . '">' . __( 'All Logins', 'wp-cerber' ) . '</a>',
'<a href="' . cerber_admin_link( 'activity' ) . '&filter_user=' . $item['user_id'] . '">' . __( 'User Activity', 'wp-cerber' ) . '</a>'
);
$url = '';
// TODO: make it via AJAX per user row with a click "Details"
if ( $item['session_id'] ) {
/*$log = cerber_db_get_row( 'SELECT * FROM ' . CERBER_LOG_TABLE . ' WHERE session_id = "' . $item['session_id'] . '"' );
if ( $log ) {
$det = explode( '|', $log['details'] );
$url = $det[4];
}*/
}
return '<span title="' . $url . '">' . cerber_date( $item['started'] ) . '</span>' . $this->row_actions( $set );
break;
case 'ses_expires':
return cerber_date( $item['expires'] );
break;
case 'ses_ip':
$set = array(
'<a href="' . cerber_admin_link( 'activity' ) . '&&filter_ip=' . $item['ip'] . '">' . __( 'Activity', 'wp-cerber' ) . '</a>',
'<a href="' . cerber_admin_link( 'traffic' ) . '&&filter_ip=' . $item['ip'] . '">' . __( 'Traffic', 'wp-cerber' ) . '</a>'
);
return crb_admin_ip_cell( $item['ip'], '', $this->row_actions( $set ) );
break;
case 'ses_host':
$ip_id = cerber_get_id_ip( $item['ip'] );
$ip_info = cerber_get_ip_info( $item['ip'], true );
if ( ! $hostname = crb_array_get( $ip_info, 'hostname_html' ) ) {
$hostname = crb_get_ajax_placeholder( 'hostname', $ip_id );
}
$country = ( $this->geo ) ? '<p style="">' . crb_country_html( $item['country'], $item['ip'] ) . '</p>' : '';
return $hostname . $country;
break;
case 'ses_action':
if ( crb_admin_is_current_session( $item['wp_session_token'] ) ) {
return '';
}
$href = $this->base_admin . '&cerber_admin_do=terminate_session&id=' . $item['wp_session_token'] . '&user_id=' . $item['user_id'];
return crb_confirmation_link( $href, __( 'Terminate', 'wp-cerber' ) );
break;
}
return '';
}
function no_items() {
if ( ! empty( $_GET['s'] ) ) {
parent::no_items();
}
else {
echo 'No user sessions found.';
}
}
}