Changeset 4090

Timestamp:

09/17/2016 12:01:39 PM (8 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();