Changeset 1529248

Timestamp:

11/06/2016 07:13:31 PM (9 years ago)

Author:

pkthree

Message:

Peter's Post Notes 1.6.2

Location:

peters-post-notes/trunk

Files:

• peters_post_notes.php (modified) (3 diffs)
• readme.txt (modified) (2 diffs)

peters-post-notes/trunk/peters_post_notes.php

@@ -5 +5 @@
 Description: Add notes on the "edit post" and "edit page" screens' sidebars, as well as general notes on the dashboard, in WordPress 2.8 and up. When used with Peter's Collaboration E-mails 1.2 and up, the notes are sent along with the e-mails in the collaboration workflow.
 Author: Peter Keung
-Version: 1.6.1
+Version: 1.6.2
 Change Log:
+2016-11-06  1.6.2: Fix query bug for users with no associated posts.
 2016-02-13  1.6.1: Improve UX by wrapping checkboxes inside labels. (Thanks Hrohh!)
 2016-02-12  1.6.0: Support private notes on posts.
@@ -54 +55 @@
 $ppn_db_notes = $wpdb->prefix . 'collabnotes';
 $ppn_db_generalnotes = $wpdb->prefix . 'generalnotes';
-$ppn_version = '1.6.1';
+$ppn_version = '1.6.2';
 
 /* --------------------------------------------
@@ -556 +557 @@
             $ppn_num_notes = ' LIMIT ' . $ppn_num_notes_limit;
         }
-        
-        $ppn_newest_posts = $wpdb->get_results( 'SELECT postid, author, notetime, notecontent, personal FROM ' . $ppn_db_notes . $ppn_query_options . ' AND ( personal = 0 OR author = ' . $current_user->ID . ' ) ORDER BY notetime DESC' . $ppn_num_notes, OBJECT );
+        $ppn_newest_posts_query = 'SELECT postid, author, notetime, notecontent, personal FROM ' . $ppn_db_notes . $ppn_query_options;
+        if( $ppn_query_options )
+        {
+            $ppn_newest_posts_query .= ' AND ';
+        }
+        else
+        {
+            $ppn_newest_posts_query .= ' WHERE ';
+        }
+        $ppn_newest_posts_query .= '( personal = 0 OR author = ' . $current_user->ID . ' ) ORDER BY notetime DESC' . $ppn_num_notes;
+        $ppn_newest_posts = $wpdb->get_results( $ppn_newest_posts_query, OBJECT );
     }
 

peters-post-notes/trunk/readme.txt

@@ -4 +4 @@
 Tags: post, notification, admin, collaboration, workflow, posts
 Requires at least: 3.2
-Tested up to: 4.4
+Tested up to: 4.7
 Stable tag: trunk
 
@@ -52 +52 @@
 
 == Changelog ==
+
+= 1.6.2 =
+* 2016-11-06: Fix query bug for users with no associated posts. (Thanks Alex!)
 
 = 1.6.1 =