Changeset 4090

Timestamp:

09/17/2016 12:01:39 PM (10 years ago)

Author:

ocean90

Message:

Rosetta Roles: Adjust Rosetta_Roles::get_translate_projects() to only fetch parent projects with their direct sub-projects.

File:

• sites/trunk/global.wordpress.org/public_html/wp-content/mu-plugins/roles/rosetta-roles.php (modified) (2 diffs)

sites/trunk/global.wordpress.org/public_html/wp-content/mu-plugins/roles/rosetta-roles.php

@@ -674 +674 @@
 
         /**
-         * Fetches all projects from translate.wordpress.org.
+         * Fetches all parent projects and their direct sub-projects like 'wp'
+         * and 'wp/dev' or 'wp-plugins' and 'wp-plugins/wordpress-importer'.
          *
          * @return array List of projects.
@@ -690 +691 @@
                 );
 
-                $_projects = $wpdb->get_results( "
+                $_projects = $wpdb->get_results( '
                         SELECT id, name, parent_project_id, slug
                         FROM translate_projects
-                        WHERE id NOT IN( " . implode( ',', $ignore_project_ids ) . " )
-                        ORDER BY id ASC
-                " );
+                        WHERE
+                                id NOT IN(' . implode( ',', $ignore_project_ids ) . ') AND
+                                LENGTH(path) - LENGTH(REPLACE(path, "/", "")) BETWEEN 0 AND 1;
+                ' );
 
                 $projects = array();