Changeset 14547

Timestamp:

10/09/2025 03:19:46 AM (6 weeks 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 );