Changeset 360780

Timestamp:

03/16/2011 03:23:56 PM (15 years ago)

Author:

bforchhammer

Message:

Added sorting by most recent post (latest activity)

Location:

author-avatars/trunk/lib

Files:

• AuthorAvatarsForm.class.php (modified) (1 diff)
• UserList.class.php (modified) (2 diffs)

author-avatars/trunk/lib/AuthorAvatarsForm.class.php

@@ -328 +328 @@
             'random' => __('Random', 'author-avatars'),
             'user_id' => __('User Id', 'author-avatars'),
-        );
-        if (AA_is_bp()) {
-            $order_options['recent_activity'] = __('Recent Activity', 'author-avatars');
-        }
+            'recent_activity' => __('Recent Activity', 'author-avatars'),
+        );
         
         $attributes = array(

author-avatars/trunk/lib/UserList.class.php

@@ -731 +731 @@
      * Returns the time of last activity for a given user. 
      *
-     * This requires that BuddyPress is installed.
-     * If it's not available the function returns an empty string.
+     * If BuddyPress is available this function uses the `last_activity` meta
+     * data value maintained by BuddyPress. Otherwise it returns the date of
+     * the latest post or page published by the given user.
      *
      * @param int $user_id
@@ -741 +742 @@
             return gmdate( 'Y-m-d H:i:s', (int)get_usermeta( $user_id, 'last_activity' ) );
         }
-        return "";
+        else {
+            global $wpdb;
+            $query = 'SELECT `post_date` FROM `wp_posts` WHERE `post_status` = "publish" AND `post_author` = ' . $user_id . ' ORDER BY `post_date` DESC LIMIT 1';
+            return $wpdb->get_var($query);
+        }
     }