*/ private static $deleting = array(); /** * Pending add/remove role events coalesced on shutdown unless set_user_role handles them. * * @var array> */ private static $pending_role_events = array(); /** * Whether a shutdown flusher for role events is registered. * * @var bool */ private static $role_flush_scheduled = false; /** * Register WordPress hooks. */ public static function register_hooks() { add_action( Activitysignature_Helpers::HOOK_BACKFILL, array( __CLASS__, 'backfill_users_batch' ) ); add_action( 'user_register', array( __CLASS__, 'track_user_creation' ) ); add_action( 'profile_update', array( __CLASS__, 'track_user_update' ), 10, 2 ); add_action( 'wp_login', array( __CLASS__, 'track_user_login' ), 10, 2 ); add_action( 'wp_login_failed', array( __CLASS__, 'track_failed_login' ) ); add_action( 'set_user_role', array( __CLASS__, 'track_role_change' ), 10, 3 ); add_action( 'add_user_role', array( __CLASS__, 'track_role_added' ), 10, 2 ); add_action( 'remove_user_role', array( __CLASS__, 'track_role_removed' ), 10, 2 ); add_action( 'delete_user', array( __CLASS__, 'track_user_delete' ) ); add_action( 'wpmu_delete_user', array( __CLASS__, 'track_user_delete' ) ); add_action( 'remove_user_from_blog', array( __CLASS__, 'track_user_removed_from_blog' ), 10, 2 ); add_action( Activitysignature_Helpers::HOOK_CLEANUP, array( __CLASS__, 'cleanup_old_activities' ) ); } /** * Process one batch of existing-user backfill (activation-safe). */ public static function backfill_users_batch() { // Wait until tracking is enabled so we do not burn through the queue unrecorded. if ( ! Activitysignature_Helpers::is_tracking_enabled() ) { wp_schedule_single_event( time() + HOUR_IN_SECONDS, Activitysignature_Helpers::HOOK_BACKFILL ); set_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_RUNNING, 1, HOUR_IN_SECONDS ); return; } $offset = (int) get_option( Activitysignature_Helpers::OPTION_BACKFILL, 0 ); $batch = 50; $users = get_users( array( 'number' => $batch, 'offset' => $offset, 'orderby' => 'ID', 'order' => 'ASC', 'fields' => array( 'ID', 'user_login', 'user_email', 'user_registered' ), ) ); if ( empty( $users ) ) { delete_option( Activitysignature_Helpers::OPTION_BACKFILL ); delete_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY ); delete_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_RUNNING ); set_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_DONE, 1, DAY_IN_SECONDS ); return; } $user_ids = wp_list_pluck( $users, 'ID' ); update_meta_cache( 'user', $user_ids ); self::prime_last_logins( $user_ids ); global $wpdb; $blocked = false; foreach ( $users as $user ) { if ( ! Activitysignature_Helpers::should_track( 'user_created', $user->ID ) ) { continue; } $recorded_key = Activitysignature_Helpers::get_user_meta_key( 'creation_recorded' ); if ( get_user_meta( $user->ID, $recorded_key, true ) ) { continue; } $created_local = get_date_from_gmt( $user->user_registered ); $wpdb->last_error = ''; $result = Activitysignature_Helpers::insert_activity( $user->ID, 'user_created', array( 'user_login' => $user->user_login, 'user_email' => $user->user_email, 'user_registered' => $user->user_registered, 'source' => 'backfill', ), $created_local ); if ( false !== $result ) { update_user_meta( $user->ID, $recorded_key, true ); if ( ! get_user_meta( $user->ID, Activitysignature_Helpers::get_user_meta_key( 'created_date' ), true ) ) { update_user_meta( $user->ID, Activitysignature_Helpers::get_user_meta_key( 'created_date' ), $created_local ); } delete_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY ); continue; } if ( '' === $wpdb->last_error ) { // The registration timestamp cannot be stored. Leave the queue able to move on. update_user_meta( $user->ID, $recorded_key, true ); delete_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY ); continue; } $retries = (int) get_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY, 0 ) + 1; if ( $retries >= 5 ) { update_user_meta( $user->ID, $recorded_key, true ); delete_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY ); continue; } update_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY, $retries, false ); $blocked = true; break; } if ( $blocked ) { // Keep the offset on the failed account and try this batch again. wp_schedule_single_event( time() + 15 * MINUTE_IN_SECONDS, Activitysignature_Helpers::HOOK_BACKFILL ); set_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_RUNNING, 1, HOUR_IN_SECONDS ); return; } if ( count( $users ) === $batch ) { update_option( Activitysignature_Helpers::OPTION_BACKFILL, $offset + $batch, false ); wp_schedule_single_event( time() + 5, Activitysignature_Helpers::HOOK_BACKFILL ); set_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_RUNNING, 1, HOUR_IN_SECONDS ); } else { delete_option( Activitysignature_Helpers::OPTION_BACKFILL ); delete_option( Activitysignature_Helpers::OPTION_BACKFILL_RETRY ); delete_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_RUNNING ); set_transient( Activitysignature_Helpers::TRANSIENT_BACKFILL_DONE, 1, DAY_IN_SECONDS ); } } /** * Prime last-login metadata for a set of users with one activity query. * * @param int[] $user_ids User IDs. */ public static function prime_last_logins( $user_ids ) { $user_ids = array_values( array_unique( array_filter( array_map( 'absint', (array) $user_ids ) ) ) ); $missing = array(); foreach ( $user_ids as $user_id ) { if ( ! get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login' ), true ) && ! get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ), true ) ) { $missing[] = $user_id; } } if ( empty( $missing ) ) { return; } global $wpdb; $table = Activitysignature_Helpers::get_table_name(); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table; results persisted to user meta (cache for subsequent reads). $rows = $wpdb->get_results( // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare, WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber -- Dynamic IN (%d) list; values passed to prepare(). $wpdb->prepare( 'SELECT user_id, MAX(activity_date) AS last_login FROM %i WHERE activity_type = %s AND user_id IN (' . implode( ',', array_fill( 0, count( $missing ), '%d' ) ) . ') GROUP BY user_id', ...array_merge( array( $table, 'user_login' ), $missing ) ), OBJECT_K ); foreach ( $missing as $user_id ) { if ( isset( $rows[ $user_id ]->last_login ) ) { update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login' ), $rows[ $user_id ]->last_login ); } else { update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ), 1 ); } } } /** * Track user creation. * * @param int $user_id User ID. */ public static function track_user_creation( $user_id ) { if ( ! Activitysignature_Helpers::should_track( 'user_created', $user_id ) ) { return; } $user = get_userdata( $user_id ); if ( ! $user ) { return; } Activitysignature_Helpers::insert_activity( $user_id, 'user_created', array( 'user_login' => $user->user_login, 'user_email' => $user->user_email, ), get_date_from_gmt( $user->user_registered ) ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'created_date' ), get_date_from_gmt( $user->user_registered ) ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'creation_recorded' ), true ); } /** * Track user profile updates (skip no-ops). * * @param int $user_id User ID. * @param WP_User|null $old_user_data Previous user object. */ public static function track_user_update( $user_id, $old_user_data = null ) { if ( ! Activitysignature_Helpers::should_track( 'user_updated', $user_id ) ) { return; } $user = get_userdata( $user_id ); if ( ! $user ) { return; } // Role-only saves still fire profile_update; skip when tracked fields are unchanged. if ( $old_user_data instanceof WP_User ) { $unchanged = ( $user->user_login === $old_user_data->user_login && $user->user_email === $old_user_data->user_email && $user->display_name === $old_user_data->display_name && $user->user_nicename === $old_user_data->user_nicename && $user->user_url === $old_user_data->user_url ); if ( $unchanged ) { return; } } Activitysignature_Helpers::insert_activity( $user_id, 'user_updated', array( 'user_login' => $user->user_login, 'user_email' => $user->user_email, 'display_name' => $user->display_name, 'user_nicename' => $user->user_nicename, 'user_url' => $user->user_url, ) ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_update' ), current_time( 'mysql' ) ); } /** * Track successful login. * * @param string $user_login Username. * @param WP_User|null $user User object. */ public static function track_user_login( $user_login, $user = null ) { if ( ! $user instanceof WP_User ) { $user = get_user_by( 'login', $user_login ); } if ( ! $user || ! Activitysignature_Helpers::should_track( 'user_login', $user->ID ) ) { return; } Activitysignature_Helpers::insert_activity( $user->ID, 'user_login', array( 'user_login' => $user->user_login, 'ip_address' => Activitysignature_Helpers::get_client_ip(), 'actor_user_id' => (int) $user->ID, ) ); update_user_meta( $user->ID, Activitysignature_Helpers::get_user_meta_key( 'last_login' ), current_time( 'mysql' ) ); delete_user_meta( $user->ID, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ) ); wp_cache_delete( 'activitysignature_last_login_' . get_current_blog_id() . '_' . $user->ID, Activitysignature_Helpers::CACHE_GROUP ); } /** * Track failed login attempts (rate-limited). * * @param string $username Attempted username or email. */ public static function track_failed_login( $username ) { if ( ! Activitysignature_Helpers::should_track( 'user_login_failed' ) ) { return; } $settings = Activitysignature_Helpers::get_settings(); if ( empty( $settings['track_failed_logins'] ) ) { return; } $raw = is_string( $username ) ? trim( $username ) : ''; $username = sanitize_user( $raw ); $user = get_user_by( 'login', $username ); if ( ! $user && is_email( $raw ) ) { $user = get_user_by( 'email', $raw ); $username = $user ? $user->user_login : sanitize_user( $raw ); } $user_id = $user ? (int) $user->ID : 0; if ( $user_id && ! Activitysignature_Helpers::should_track( 'user_login_failed', $user_id ) ) { return; } $ip = Activitysignature_Helpers::get_client_ip(); $bucket = Activitysignature_Helpers::TRANSIENT_FAIL_PREFIX . md5( $ip . '|' . strtolower( $raw ) ); $count = (int) get_transient( $bucket ); if ( $count >= 10 ) { return; } set_transient( $bucket, $count + 1, HOUR_IN_SECONDS ); $alert_count = absint( $settings['failed_alert_count'] ); if ( $alert_count > 0 && $count + 1 === $alert_count && is_email( $settings['failed_alert_email'] ) ) { $identity = sanitize_text_field( $raw ); if ( strlen( $identity ) > 100 ) { $identity = substr( $identity, 0, 100 ) . '…'; } wp_mail( $settings['failed_alert_email'], __( 'Activity Signature: failed login threshold reached', 'activitysignature' ), sprintf( /* translators: 1: attempt count, 2: attempted username, 3: IP address */ __( '%1$d failed login attempts were recorded for %2$s from IP %3$s within one hour.', 'activitysignature' ), $alert_count, $identity ? $identity : __( '(empty)', 'activitysignature' ), $ip ? $ip : __( '(unknown)', 'activitysignature' ) ) ); } Activitysignature_Helpers::insert_activity( $user_id, 'user_login_failed', array( 'user_login' => $username ? $username : $raw, 'user_email' => is_email( $raw ) ? sanitize_email( $raw ) : '', 'ip_address' => $ip, ) ); } /** * Track role changes. * * @param int $user_id User ID. * @param string $role New role. * @param array $old_roles Previous roles. */ public static function track_role_change( $user_id, $role, $old_roles ) { $user_id = (int) $user_id; // Prefer the set_user_role summary over individual add/remove events. self::$pending_role_events = array_values( array_filter( self::$pending_role_events, static function ( $event ) use ( $user_id ) { return (int) $event['user_id'] !== $user_id; } ) ); if ( ! Activitysignature_Helpers::should_track( 'user_role_changed', $user_id ) ) { return; } $user = get_userdata( $user_id ); if ( ! $user ) { return; } $old_roles = array_values( (array) $old_roles ); if ( array( $role ) === $old_roles ) { return; } Activitysignature_Helpers::insert_activity( $user_id, 'user_role_changed', array( 'user_login' => $user->user_login, 'new_role' => $role, 'old_roles' => $old_roles, ) ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_update' ), current_time( 'mysql' ) ); } /** * Queue a role being added (flushed on shutdown unless set_user_role handles it). * * @param int $user_id User ID. * @param string $role Role slug. */ public static function track_role_added( $user_id, $role ) { self::$pending_role_events[] = array( 'user_id' => (int) $user_id, 'role' => (string) $role, 'change' => 'added', ); self::schedule_role_event_flush(); } /** * Register a one-time shutdown callback for queued role events. */ private static function schedule_role_event_flush() { if ( self::$role_flush_scheduled ) { return; } self::$role_flush_scheduled = true; add_action( 'shutdown', array( __CLASS__, 'flush_pending_role_events' ), 0 ); } /** * Queue a role being removed (flushed on shutdown unless set_user_role handles it). * * @param int $user_id User ID. * @param string $role Role slug. */ public static function track_role_removed( $user_id, $role ) { self::$pending_role_events[] = array( 'user_id' => (int) $user_id, 'role' => (string) $role, 'change' => 'removed', ); self::schedule_role_event_flush(); } /** * Persist standalone add_role / remove_role events. */ public static function flush_pending_role_events() { $events = self::$pending_role_events; self::$pending_role_events = array(); foreach ( $events as $event ) { $user_id = (int) $event['user_id']; if ( ! Activitysignature_Helpers::should_track( 'user_role_changed', $user_id ) ) { continue; } $user = get_userdata( $user_id ); if ( ! $user ) { continue; } $payload = array( 'user_login' => $user->user_login, 'change' => $event['change'], ); if ( 'added' === $event['change'] ) { $payload['new_role'] = $event['role']; $payload['old_roles'] = array_values( array_diff( (array) $user->roles, array( $event['role'] ) ) ); } else { $payload['removed'] = $event['role']; $payload['new_role'] = ! empty( $user->roles ) ? array_values( (array) $user->roles )[0] : ''; $payload['old_roles'] = array_values( array_unique( array_merge( (array) $user->roles, array( $event['role'] ) ) ) ); } Activitysignature_Helpers::insert_activity( $user_id, 'user_role_changed', $payload ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_update' ), current_time( 'mysql' ) ); } } /** * Track removal from the current blog on multisite. * * @param int $user_id User ID. * @param int $blog_id Blog ID. */ public static function track_user_removed_from_blog( $user_id, $blog_id = 0 ) { $blog_id = $blog_id ? (int) $blog_id : get_current_blog_id(); if ( $blog_id !== get_current_blog_id() ) { switch_to_blog( $blog_id ); self::track_user_delete( $user_id ); restore_current_blog(); return; } self::track_user_delete( $user_id ); } /** * Track user deletion. * * @param int $user_id User ID. */ public static function track_user_delete( $user_id ) { $user_id = (int) $user_id; $dedupe = get_current_blog_id() . ':' . $user_id; if ( isset( self::$deleting[ $dedupe ] ) ) { return; } self::$deleting[ $dedupe ] = true; if ( ! Activitysignature_Helpers::should_track( 'user_deleted', $user_id ) ) { return; } $user = get_userdata( $user_id ); if ( ! $user ) { return; } Activitysignature_Helpers::insert_activity( $user_id, 'user_deleted', array( 'user_login' => $user->user_login, 'user_email' => $user->user_email, ) ); } /** * Get user creation date in site-local MySQL datetime. * * @param int $user_id User ID. * * @return string */ public static function get_user_created_date( $user_id ) { $user_id = (int) $user_id; $cached_date = get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'created_date' ), true ); if ( $cached_date ) { return $cached_date; } $user = get_userdata( $user_id ); if ( ! $user || empty( $user->user_registered ) ) { return ''; } return get_date_from_gmt( $user->user_registered ); } /** * Get user last login date. * * @param int $user_id User ID. * * @return string MySQL datetime or empty string. */ public static function get_last_login( $user_id ) { $user_id = (int) $user_id; $last_login = get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login' ), true ); if ( $last_login ) { return $last_login; } if ( get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ), true ) ) { return ''; } $cache_key = 'activitysignature_last_login_' . get_current_blog_id() . '_' . $user_id; $last_login = wp_cache_get( $cache_key, Activitysignature_Helpers::CACHE_GROUP ); if ( 'none' === $last_login ) { return ''; } if ( false === $last_login ) { global $wpdb; $table_name = Activitysignature_Helpers::get_table_name(); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- Custom table; result cached via wp_cache_* and user meta above/below. $last_login = $wpdb->get_var( $wpdb->prepare( 'SELECT activity_date FROM %i WHERE user_id = %d AND activity_type = %s ORDER BY activity_date DESC LIMIT 1', $table_name, $user_id, 'user_login' ) ); if ( $last_login ) { wp_cache_set( $cache_key, $last_login, Activitysignature_Helpers::CACHE_GROUP, 12 * HOUR_IN_SECONDS ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login' ), $last_login ); delete_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ) ); } else { wp_cache_set( $cache_key, 'none', Activitysignature_Helpers::CACHE_GROUP, 12 * HOUR_IN_SECONDS ); update_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_login_checked' ), 1 ); $last_login = ''; } } return $last_login ? $last_login : ''; } /** * Get last profile update date. * * @param int $user_id User ID. * * @return string MySQL datetime or empty string. */ public static function get_last_update( $user_id ) { $user_id = (int) $user_id; $last_update = get_user_meta( $user_id, Activitysignature_Helpers::get_user_meta_key( 'last_update' ), true ); return $last_update ? $last_update : ''; } /** * Cleanup old activity records in batches. * * @return int Number of rows deleted. */ public static function cleanup_old_activities() { global $wpdb; $settings = Activitysignature_Helpers::get_settings(); $days = max( 7, (int) $settings['retention_days'] ); $table = Activitysignature_Helpers::get_table_name(); $limit = ( new DateTimeImmutable( 'now', wp_timezone() ) ) ->modify( '-' . $days . ' days' ) ->format( 'Y-m-d H:i:s' ); $batch = 1000; $deleted = 0; $hit_cap = false; do { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table batch cleanup; caching delete candidates is not applicable. $ids = $wpdb->get_col( $wpdb->prepare( 'SELECT id FROM %i WHERE activity_date < %s ORDER BY id ASC LIMIT %d', $table, $limit, $batch ) ); if ( empty( $ids ) ) { break; } $count = (int) Activitysignature_Helpers::delete_rows_by_ids( $ids ); $deleted += $count; if ( $count === $batch && $deleted >= 20000 ) { $hit_cap = true; break; } } while ( $count === $batch && $deleted < 20000 ); if ( $hit_cap ) { $next = wp_next_scheduled( Activitysignature_Helpers::HOOK_CLEANUP ); if ( ! $next || $next > time() + 5 * MINUTE_IN_SECONDS ) { wp_schedule_single_event( time() + MINUTE_IN_SECONDS, Activitysignature_Helpers::HOOK_CLEANUP ); } } return $deleted; } }