Changeset 14547

Timestamp:

10/09/2025 03:19:46 AM (10 months ago)

Author:

dd32

Message:

Make: Add a tool to allow Make teams to assign / remove badges as needed.

This allows teams to grant badges from a central place (their Make site) without needing to have BuddyPress (profiles.wordpress.org) admin access.
See wp-admin => Tools -> Profile Badges.

By default this is limited to users with manage_options (Administrators) but can be lowered to those who can publish on the P2 or disabled.

A super-admin needs to set the badges which are able to be managed on each site.

See #8068.
Fixes #3043, #3026.

Location:

sites/trunk/wordpress.org/public_html/wp-content

Files:

• mu-plugins/pub/profile-helpers.php (modified) (3 diffs)
• plugins/wporg-badge-management (added)
• plugins/wporg-badge-management/admin-post.php (added)
• plugins/wporg-badge-management/admin.php (added)
• plugins/wporg-badge-management/index.php (added)

sites/trunk/wordpress.org/public_html/wp-content/mu-plugins/pub/profile-helpers.php

@@ -58 +58 @@
                         FROM bpmain_wporg_groups_members m
                         JOIN bpmain_wporg_groups g ON m.group_id = g.id
-                        WHERE g.slug = %s AND m.is_confirmed = 1 AND m.is_banned = 0",
-                $badge
+                        WHERE g.slug = %s AND m.is_confirmed = 1 AND m.is_banned = 0
+                        ORDER BY date_modified DESC
+                        LIMIT 10000", // Arbitrary high limit to avoid extra huge result sets.
+                $badge,
         ) );
 
@@ -86 +88 @@
                 $user_id
         ), ARRAY_A );
+
+        return array_column( $badges, 'name', 'slug' );
+}
+
+/**
+ * Get a list of all available badges.
+ *
+ * WARNING: Uncached.
+ *
+ * @return array An array of badge names keyed by slug.
+ */
+function get_badges() {
+        global $wpdb;
+
+        $badges = $wpdb->get_results(
+                "SELECT slug, name
+                        FROM bpmain_wporg_groups
+                        ORDER BY name",
+                ARRAY_A
+        );
 
         return array_column( $badges, 'name', 'slug' );
@@ -229 +251 @@
         }
 
+        $_user = false;
+
+        // If it looks like a profile url, extract the slug.
+        if ( is_string( $user ) && str_starts_with( $user, 'https://profiles.wordpress.org/' ) ) {
+
+                $user = trim( str_replace( 'https://profiles.wordpress.org/', '', $user ), '/' );
+                $user = explode( '/', $user )[0];
+
+                return get_user_by( 'slug', $user )->ID ?? false;
+        }
+
         // Support user login / email / slug.
         $_user = get_user_by( 'login', $user );