Changeset 716369

Timestamp:

05/22/2013 03:22:45 AM (13 years ago)

Author:

straker503

Message:

1.0.5 (2013-05-21)

• Fixed posts not properly displaying post views
• Fixed database access to tables using 'wp_' table prefix to use prefix defined in wp-config.php
• Added shortcode

Location:

jetpack-post-views

Files:

• assets/banner-772×250.png (added)
• trunk/jetpack-post-views.php (modified) (14 diffs)
• trunk/readme.txt (modified) (3 diffs)

jetpack-post-views/trunk/jetpack-post-views.php

@@ -6 +6 @@
  * Description: Adds a widget that displays your most popular posts using Jetpack stats. <strong>NOTE:</strong> If the plugin does not work, visit the <a href="options-general.php?page=jetpack_post_views">Settings</a> page to enter a WordPress API Key.
  * Author: Steven Lambert
- * Version: 1.0.4
+ * Version: 1.0.5
  * Author URI: http://sklambert.com
  * License: GPL2+
@@ -13 +13 @@
 // Define plugin version
 if ( !defined( 'JETPACK_POST_VIEWS_VERSION_NUM' ) ) {
-    define( 'JETPACK_POST_VIEWS_VERSION_NUM', '1.0.4' );
+    define( 'JETPACK_POST_VIEWS_VERSION_NUM', '1.0.5' );
 }
 
@@ -34 +34 @@
         // Admin hooks
         add_action( 'admin_init',                          array( &$this, 'register_setting' ) );
-        add_action( 'admin_menu',                          array( &$this, 'register_settings_page' ) ); 
-        add_filter( 'plugin_action_links',                 array( &$this, 'settings_link' ), 10, 2 );    
+        add_action( 'admin_menu',                          array( &$this, 'register_settings_page' ) );
+        add_filter( 'plugin_action_links',                 array( &$this, 'settings_link' ), 10, 2 );
 
         // Shecudled hooks
         add_action( 'jetpack_post_views_scheduled_update', array( &$this, 'get_post_views' ) );
 
+        // Post hooks
+        add_action( 'publish_post',                        array( &$this, 'add_jetpack_meta' ) );
+
         // Query the database for the blog_id
         global $wpdb;
-        $stats_options = $wpdb->get_var( "SELECT option_value 
-                                          FROM   wp_options 
+        $options_table = $wpdb->base_prefix."options";
+        $stats_options = $wpdb->get_var( "SELECT option_value
+                                          FROM   $options_table
                                           WHERE  option_name = 'stats_options'" );
         $stats = unserialize($stats_options);
@@ -54 +58 @@
 
             // Try another possiblility to get the blog_id
-            $jetpack_options = $wpdb->get_var( "SELECT option_value 
-                                                FROM   wp_options 
+            $jetpack_options = $wpdb->get_var( "SELECT option_value
+                                                FROM   $options_table
                                                 WHERE  option_name = 'jetpack_options'" );
             $jetpack = unserialize($jetpack_options);
@@ -62 +66 @@
                 $this->blog_id = $jetpack['id'];
             }
-            else { // Jetpack stats really unabailable
+            else { // Jetpack stats really unavailable
                 $this->blog_id = -1;
             }
@@ -107 +111 @@
     function register_setting() {
         register_setting( 'jetpack_post_views_settings', 'jetpack_post_views_settings', array( &$this, 'validate_settings' ) );
+    }
+
+
+    /* ADD JETPACK POST META ON POST PUBLISH */
+    function add_jetpack_meta() {
+        global $post;
+        add_post_meta( $post->ID, 'jetpack-post-views', 0, true );
     }
 
@@ -348 +359 @@
                     <li><a href="<?php echo get_permalink( $post['post_id'] ) ?>"><?php echo get_the_title( $post['post_id'] ) ?></a>
                         <?php if ( $instance['show_views'] ) { 
-                            echo " - ".number_format_i18n( $post['views'] )." views";
+                            echo " - ".number_format_i18n( $post['views'] ? $post['views'] : 0 )." views";
                         } ?>
                     </li>
@@ -513 +524 @@
             foreach( $allposts as $post) {
                 // Ensure that the $post-ID exists as a key in the array before trying to update post information.
-                // This prevents the uers from pulling data from another website and trying to add it to their own
+                // This prevents the user from pulling data from another website and trying to add it to their own
                 // posts. 
                 if ( array_key_exists( $post->ID, $postdata) ) {
@@ -525 +536 @@
                     }
                     else {
-                        add_post_meta( $post->ID, 'jetpack-post-views', $newViews, true );
+                        add_post_meta( $post->ID, 'jetpack-post-views', ($newViews ? $newViews: 0), true );
                     }
+                }
+                else {
+                    add_post_meta( $post->ID, 'jetpack-post-views', 0, true );
                 }
             }
@@ -534 +548 @@
     /* UPGRADE PLUGIN TO NEW VERSION */
     function upgrade() {
+        global $post;
+
         // Delete old options
         delete_option( 'jetpack-post-views_version' );
@@ -539 +555 @@
         delete_option( 'jetpack_post_views_stats_has_run' );
 
-        define( 'JETPACK_POST_VIEWS_VERSION_NUM', '1.0.4' );
+        // Add post meta for each post
+        $args = array( 'numberposts' => -1, 'post_type' => 'post', 'post_status' => 'publish');
+        $allposts = get_posts( $args );
+        foreach( $allposts as $post) {
+            $views = get_post_meta( $post->ID, 'jetpack-post-views', true );
+
+            if (!$views) {
+                add_post_meta( $post->ID, 'jetpack-post-views', 0, true );
+            }
+        }
+
+        define( 'JETPACK_POST_VIEWS_VERSION_NUM', '1.0.5' );
     }
 
@@ -587 +614 @@
 
     // Upgrade the plugin if necessary
-    if ( JETPACK_POST_VIEWS_VERSION_NUM != '1.0.4' ) {
+    if ( JETPACK_POST_VIEWS_VERSION_NUM != '1.0.5' ) {
         $Jetpack_Post_Views->upgrade();
     }
@@ -626 +653 @@
                 <li><a href="<?php echo get_permalink( $post['post_id'] ) ?>"><?php echo get_the_title( $post['post_id'] ) ?></a>
                     <?php if ( $args['displayViews'] ) { 
-                        echo " - ".number_format_i18n( $post['views'] )." views";
+                        echo " - ".number_format_i18n( $post['views'] ? $post['views'] : 0 )." views";
                     } ?>
                 </li>
@@ -636 +663 @@
     }
 }
+
+/* 
+ * SHORTCODE
+ * Use the Jetpack stats_get_csv() function to create a list of the top posts
+ * atts: days         - number of days of the desired time frame. '-1' means unlimited 
+ *       limit        - number of posts to display. '-1' means unlimited. If days is -1, then limit is capped at 500
+ *       exclude      - comma-separated list of post IDs to exclude form displaying
+ *       displayviews - flag to display the post views
+ */
+add_shortcode( 'jpv', 'JPV_shortcode' );
+function JPV_shortcode( $atts ) {
+    extract( shortcode_atts( array(
+        'days' => '-1',
+        'limit' => '5',
+        'exclude' => '',
+        'displayviews' => false,
+    ), $atts ) );
+
+    JPV_display_top_posts( $args = array( 'days' => $days, 'limit' => $limit, 'exclude' => $exclude, 'displayViews' => $displayviews ) );
+}

jetpack-post-views/trunk/readme.txt

@@ -8 +8 @@
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
 
-A plugin that displays your most popular posts using Jetpack stats.
+Displays your most popular posts using Jetpack stats.
 
 == Description ==
@@ -61 +61 @@
 **NOTE** This function only works if the function `stats_get_csv()` exists. If this function is not working probably, it is probably due to the `stats_get_csv()` function not returning the needed results.
 
+= How can I display the top posts in my posts? =
+
+Use the shortcode '[jpv]'
+
+The shotcode uses the same parameters as the 'JPV_display_top_posts()' function
+
 == Screenshots ==
 
@@ -69 +75 @@
 
 == Changelog ==
+
+= 1.0.5 (2013-05-21) =
+* Fixed posts not properly displaying post views
+* Fixed database access to tables using 'wp_' table prefix to use prefix defined in wp-config.php
+* Added shortcode
 
 = 1.0.4 (2013-03-14) =