Changeset 7030

Timestamp:

04/05/2018 04:16:43 AM (7 years ago)

Author:

dd32

Message:

Plugin Directory: Ratings/Reviews: Enhance the bin script from r7029 to also operate on a singular plugin.

See #2606.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/bin/resync-ratings.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/bin/resync-ratings.php

@@ -8 +8 @@
     die();
 }
-$opts = getopt( '', array( 'post:', 'url:', 'abspath:', 'age:' ) );
+$opts = getopt( '', array( 'plugin:', 'url:', 'abspath:' ) );
 
 if ( empty( $opts['url'] ) ) {
@@ -32 +32 @@
 }
 
-$slugs = $wpdb->get_col( "SELECT post_name FROM {$wpdb->posts} WHERE post_type = 'plugin' and post_status = 'publish'" );
+if ( !empty( $opts['plugin'] ) ) {
+    $sql = $wpdb->prepare( "SELECT post_name FROM {$wpdb->posts} WHERE post_type = 'plugin' and post_status = 'publish' AND post_name = %s", $opts['plugin'] );
+} else {
+    // All plugins.
+    $sql = "SELECT post_name FROM {$wpdb->posts} WHERE post_type = 'plugin' and post_status = 'publish'";
+}
+
+$slugs = $wpdb->get_col( $sql );
 
 foreach ( $slugs as $i => $slug ) {