Changeset 6471

Timestamp:

10/29/2012 07:48:50 PM (14 years ago)

Author:

djpaul

Message:

Add support for 'online' type searches to BP_User_Query.
See #4060

File:

• trunk/bp-core/bp-core-classes.php (modified) (1 diff)

trunk/bp-core/bp-core-classes.php

@@ -198 +198 @@
                 switch ( $type ) {
 
-                        // 'active', 'online', 'newest', and 'random' queries
+                        // 'online' query happens against the last_activity usermeta key
+                        case 'online' :
+                                $this->uid_name = 'user_id';
+                                $sql['select']  = "SELECT DISTINCT u.{$this->uid_name} as id FROM {$wpdb->usermeta} u";
+                                $sql['where'][] = $wpdb->prepare( "u.meta_key = %s", bp_get_user_meta_key( 'last_activity' ) );
+                                $sql['where'][] = $wpdb->prepare( 'u.meta_value >= DATE_SUB( UTC_TIMESTAMP(), INTERVAL 5 MINUTE )' );
+                                $sql['orderby'] = "ORDER BY u.meta_value";
+                                $sql['order']   = "DESC";
+
+                                break;
+
+                        // 'active', 'newest', and 'random' queries
                         // all happen against the last_activity usermeta key
                         case 'active' :
-                        case 'online' :
                         case 'newest' :
                         case 'random' :