Changeset 6471

Timestamp:

10/29/2012 07:48:50 PM (12 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' :