Changeset 601 for trunk/bp-activity/bp-activity-classes.php

Timestamp:

12/02/2008 09:04:12 PM (17 years ago)

Author:

apeatling

Message:

Added profile field filters
Added RSS feeds to site wide, personal and friend feeds
Small fixes on blog, member and group directories

File:

• trunk/bp-activity/bp-activity-classes.php (modified) (13 diffs)

trunk/bp-activity/bp-activity-classes.php

@@ -5 +5 @@
     var $item_id;
     var $user_id;
+    var $primary_link;
     var $component_name;
     var $component_action;
@@ -59 +60 @@
             
             // Add the cached version of the activity to the cached activity table.
-            $activity_cached = $wpdb->query( $wpdb->prepare( "INSERT INTO " . $this->table_name_cached . " ( content, component_name, date_cached, date_recorded, is_private ) VALUES ( %s, %s, FROM_UNIXTIME(%d), FROM_UNIXTIME(%d), %d )", $activity_content, $this->component_name, time(), $this->date_recorded, $this->is_private ) );
+            $activity_cached = $wpdb->query( $wpdb->prepare( "INSERT INTO " . $this->table_name_cached . " ( content, primary_link, component_name, date_cached, date_recorded, is_private ) VALUES ( %s, %s, %s, FROM_UNIXTIME(%d), FROM_UNIXTIME(%d), %d )", $activity_content['content'], $activity_content['primary_link'], $this->component_name, time(), $this->date_recorded, $this->is_private ) );
         
             // Add the cached version of the activity to the cached activity table.
-            $sitewide_cached = $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_sitewide'] . " ( user_id, content, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, FROM_UNIXTIME(%d), FROM_UNIXTIME(%d) )", $bp['loggedin_userid'], $activity_content, $this->component_name, time(), $this->date_recorded ) );
+            $sitewide_cached = $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_sitewide'] . " ( user_id, content, primary_link, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, %s, FROM_UNIXTIME(%d), FROM_UNIXTIME(%d) )", $bp['loggedin_userid'], $activity_content['content'], $activity_content['primary_link'], $this->component_name, time(), $this->date_recorded ) );
             
             if ( $activity && $activity_cached )
@@ -110 +111 @@
             for ( $i = 0; $i < count( $activities ); $i++ ) {
                 $activities_formatted[$i]['content'] = $activities[$i]->content;
+                $activities_formatted[$i]['primary_link'] = $activities[$i]->primary_link;
                 $activities_formatted[$i]['date_recorded'] = $activities[$i]->date_recorded;
                 $activities_formatted[$i]['component_name'] = $activities[$i]->component_name;
@@ -127 +129 @@
                         continue;
                         
-                    $activities_formatted[$i]['content'] = $content;
+                    $activities_formatted[$i]['content'] = $content['content'];
+                    $activities_formatted[$i]['primary_link'] = $content['primary_link'];
                     $activities_formatted[$i]['date_recorded'] = $activities[$i]->date_recorded;
                     $activities_formatted[$i]['component_name'] = $activities[$i]->component_name;
@@ -145 +148 @@
     }
     
-    function get_activity_for_friends( $user_id = null, $limit = 30, $since = '-1 week' ) {
+    function get_activity_for_friends( $user_id = null, $limit = 30, $since = '-3 days' ) {
         global $wpdb, $bp;
         
@@ -168 +171 @@
             for ( $i = 0; $i < count( $activities ); $i++ ) {
                 $activities_formatted[$i]['content'] = $activities[$i]->content;
+                $activities_formatted[$i]['primary_link'] = $activities[$i]->primary_link;
                 $activities_formatted[$i]['date_recorded'] = $activities[$i]->date_recorded;
                 $activities_formatted[$i]['component_name'] = $activities[$i]->component_name;
@@ -191 +195 @@
                 for ( $j = 0; $j < count( $activities[$i]['activity']); $j++ ) {
                     $activities[$i]['activity'][$j]->content = bp_activity_content_filter( $activities[$i]['activity'][$j]->content, $activities[$i]['activity'][$j]->date_recorded, $activities[$i]['full_name'], false, false, false );
-                    $activities_formatted[] = array( 'user_id' => $friend_ids[$i], 'content' => $activities[$i]['activity'][$j]->content, 'date_recorded' => $activities[$i]['activity'][$j]->date_recorded, 'component_name' => $activities[$i]['activity'][$j]->component_name );
+                    $activities_formatted[] = array( 'user_id' => $friend_ids[$i], 'content' => $activities[$i]['activity'][$j]->content, 'primary_link' => $activities[$i]['activity'][$j]->primary_link, 'date_recorded' => $activities[$i]['activity'][$j]->date_recorded, 'component_name' => $activities[$i]['activity'][$j]->component_name );
                 }
             }
@@ -211 +215 @@
             $limit_sql = $wpdb->prepare( " LIMIT %d", $limit );
         
-        /* Remove entries that are older than 1 week */
-        $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp['activity']['table_name_sitewide'] . " WHERE DATE_ADD(date_recorded, INTERVAL 1 WEEK) <= NOW()" ) );
+        /* Remove entries that are older than 6 months */
+        $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp['activity']['table_name_sitewide'] . " WHERE DATE_ADD(date_recorded, INTERVAL 6 MONTHS) <= NOW()" ) );
         
         $activities = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . $bp['activity']['table_name_sitewide'] . " ORDER BY date_recorded DESC $limit_sql" ) );
@@ -218 +222 @@
         for ( $i = 0; $i < count( $activities ); $i++ ) {
             $activities_formatted[$i]['content'] = $activities[$i]->content;
+            $activities_formatted[$i]['primary_link'] = $activities[$i]->primary_link;
             $activities_formatted[$i]['date_recorded'] = $activities[$i]->date_recorded;
             $activities_formatted[$i]['component_name'] = $activities[$i]->component_name;
@@ -225 +230 @@
     }
     
+    function get_sitewide_items_for_feed( $limit = 35 ) {
+        global $wpdb, $bp;
+        
+        $activities = BP_Activity_Activity::get_sitewide_activity( $limit );
+        for ( $i = 0; $i < count($activities); $i++ ) {
+                $title = explode( '<span', $activities[$i]['content'] );
+
+                $activity_feed[$i]['title'] = trim( strip_tags( $title[0] ) );
+                $activity_feed[$i]['link'] = $activities[$i]['primary_link'];
+                $activity_feed[$i]['description'] = sprintf ( $activities[$i]['content'], '' );
+                $activity_feed[$i]['pubdate'] = $activities[$i]['date_recorded'];
+        }
+
+        return $activity_feed;  
+    }
+    
     function cache_friends_activities( $activity_array ) {
         global $wpdb, $bp;
@@ -233 +254 @@
         for ( $i = 0; $i < count($activity_array); $i++ ) {
             // Cache that sucka...
-            $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_loggedin_user_friends_cached'] . " ( user_id, content, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, FROM_UNIXTIME(%d), %s )", $activity_array[$i]['user_id'], $activity_array[$i]['content'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'] ) );
+            $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_loggedin_user_friends_cached'] . " ( user_id, content, primary_link, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, %s, FROM_UNIXTIME(%d), %s )", $activity_array[$i]['user_id'], $activity_array[$i]['content'], $activity_array[$i]['primary_link'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'] ) );
         }
         
@@ -252 +273 @@
             
             // Cache that sucka...
-            $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_current_user_cached'] . " ( content, component_name, date_cached, date_recorded, is_private ) VALUES ( %s, %s, FROM_UNIXTIME(%d), %s, %d )", $activity_array[$i]['content'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'], $activity_array[$i]['is_private'] ) );
+            $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_current_user_cached'] . " ( content, primary_link, component_name, date_cached, date_recorded, is_private ) VALUES ( %s, %s, FROM_UNIXTIME(%d), %s, %d )", $activity_array[$i]['content'], $activity_array[$i]['primary_link'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'], $activity_array[$i]['is_private'] ) );
             
             // Add to the sitewide activity stream
             if ( !$activity_array[$i]['is_private'] )
-                $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_sitewide'] . " ( user_id, content, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, FROM_UNIXTIME(%d), %s )", $user_id, $activity_array[$i]['content'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'] ) );
+                $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp['activity']['table_name_sitewide'] . " ( user_id, content, primary_link, component_name, date_cached, date_recorded ) VALUES ( %d, %s, %s, FROM_UNIXTIME(%d), %s )", $user_id, $activity_array[$i]['content'], $activity_array[$i]['primary_link'], $activity_array[$i]['component_name'], time(), $activity_array[$i]['date_recorded'] ) );
         }
         
@@ -262 +283 @@
     }
     
+    function get_last_updated() {
+        global $bp, $wpdb;
+        
+        return $wpdb->get_var( $wpdb->prepare( "SELECT date_recorded FROM " . $bp['activity']['table_name_sitewide'] . " ORDER BY date_recorded ASC LIMIT 1" ) );
+    }
+    
 
 }