Changeset 10929

Timestamp:

04/27/2021 04:44:30 AM (5 years ago)

Author:

dd32

Message:

Helpscout: Search pending signups for the email address in addition to accounts.

File:

• sites/trunk/api.wordpress.org/public_html/dotorg/helpscout/profile.php (modified) (1 diff)

sites/trunk/api.wordpress.org/public_html/dotorg/helpscout/profile.php

@@ -14 +14 @@
         $user = get_user_by( 'email', $request->customer->email );
         if ( isset( $user->user_nicename ) ) {
-                $html .= '<p>Profile: <a href="https://profiles.wordpress.org/' . $user->user_nicename . '">'. $user->user_nicename .'</a></p>';
-                $html .= '<p>Forums: <a href="https://wordpress.org/support/users/'. $user->user_nicename . '">'. $user->user_nicename .'</a></p>';
+                $html .= '<p>Profile: <a href="https://profiles.wordpress.org/' . $user->user_nicename . '/">'. $user->user_nicename .'</a></p>';
+                $html .= '<p>Forums: <a href="https://wordpress.org/support/users/'. $user->user_nicename . '/">'. $user->user_nicename .'</a></p>';
         } else {
                 $html .= '<p>No profile found</p>';
         }
+
+        // See if they have a pending user account.
+        $records = $wpdb->get_results( $wpdb->prepare(
+                "SELECT * FROM {$wpdb->base_prefix}user_pending_registrations
+                WHERE user_email = %s OR user_email LIKE %s",
+                $request->customer->email,
+                str_replace( '@', '+%@', $wpdb->esc_like( $request->customer->email ) ) // Handle plus addressing.
+        ) );
+        if ( $records ) {
+                $html .= '<p>Signups found:</p>';
+                $html .= '<ul>';
+
+                $match_status = function( $u ) {
+                        if ( $u->created ) {
+                                return 'Created';
+                        }
+                        if ( ! $u->cleared ) {
+                                return 'Caught in Spam';
+                        }
+                        return 'Pending';
+                };
+
+                foreach ( $records as $u ) {
+                        $html .= sprintf(
+                                '<li><a href="%s">%s <strong>%s</strong></a></li>',
+                                esc_url( add_query_arg( 's', urlencode( $u->user_email ), 'https://login.wordpress.org/wp-admin/index.php?page=user-registrations&s=' ) ),
+                                esc_html( $u->user_login ) . (
+                                        $request->customer->email == $u->user_email ? '' : ' (' . esc_html( $u->user_email ) . ')'
+                                ),
+                                esc_html( $match_status( $u ) )
+                        );
+                }
+
+                $html .= '</ul>';
+        }
+
+        $html .= sprintf(
+                '<p><a href="%s">Search pending signups</a></p>',
+                esc_url( add_query_arg( 's', urlencode( $request->customer->email ), 'https://login.wordpress.org/wp-admin/index.php?page=user-registrations&s=' ) ),
+        );
 
 }