Changeset 2064

Timestamp:

11/10/2015 01:11:42 AM (11 years ago)

Author:

dd32

Message:

Translate: Stats overview: Only active projects should be included in the counts on the stats page.

File:

• sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-stats-overview.php (modified) (2 diffs)

sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-stats-overview.php

@@ -61 +61 @@
                                 LEFT JOIN {$gpdb->prefix}projects p ON stats.project_id = p.id
                         WHERE
-                                p.path IN ( $all_project_paths_sql )";
+                                p.path IN ( $all_project_paths_sql )
+                                AND p.active = 1";
 
                 $rows = $gpdb->get_results( $sql );
@@ -93 +94 @@
                         WHERE
                                 p.parent_project_id IN ( $parent_project_ids )
+                                AND p.active = 1
                         GROUP BY locale, locale_slug";