Changeset 3232 for trunk/bp-blogs/bp-blogs-classes.php

Timestamp:

09/06/2010 04:24:57 PM (16 years ago)

Author:

apeatling

Message:

Merging 1.2 branch with trunk

File:

• trunk/bp-blogs/bp-blogs-classes.php (modified) (2 diffs)

trunk/bp-blogs/bp-blogs-classes.php

@@ -279 +279 @@
                         return $paged_blogs;
 
-                for ( $i = 0; $i < count( $paged_blogs ); $i++ )
-                        $paged_blogs[$i]->latest_post = $wpdb->get_row( "SELECT post_title, guid FROM {$wpdb->base_prefix}" . $paged_blogs[$i]->blog_id . "_posts WHERE post_status = 'publish' AND post_type = 'post' AND id != 1 ORDER BY id DESC LIMIT 1" );
+                /* Fetch lastest post for each blog. */
+                $post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT p.post_id, p.blog_id FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND p.blog_id IN ( {$blog_ids} ) GROUP BY p.blog_id ORDER BY p.date_created DESC" ) );
+
+                for ( $i = 0; $i < count( $paged_blogs ); $i++ ) {
+                        foreach ( (array)$post_ids as $post ) {
+                                if ( $post->blog_id == $paged_blogs[$i]->blog_id ) {
+                                        $paged_blogs[$i]->latest_post = $wpdb->get_row( "SELECT post_title, guid FROM {$wpdb->base_prefix}" . $post->blog_id . "_posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY id DESC LIMIT 1" );
+                                }
+                        }
+                }
 
                 /* Fetch the blog description for each blog (as it may be empty we can't fetch it in the main query). */
@@ -308 +316 @@
 }
 
+/* DEPRECATED - Post DB recording is scheduled for removal. Please use the activity stream to fetch a user's posts. */
+Class BP_Blogs_Post {
+        var $id;
+        var $user_id;
+        var $blog_id;
+        var $post_id;
+        var $date_created;
+
+        function bp_blogs_post( $id = null, $blog_id = null, $post_id = null ) {
+                global $bp, $wpdb;
+
+                if ( $id || ( !$id && $blog_id && $post_id ) ) {
+                        $this->id = $id;
+                        $this->blog_id = $blog_id;
+                        $this->post_id = $post_id;
+                        $this->populate();
+                }
+        }
+
+        function populate() {
+                global $wpdb, $bp;
+
+                if ( $this->id )
+                        $post = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$bp->blogs->table_name_blog_posts} WHERE id = %d", $this->id ) );
+                else
+                        $post = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$bp->blogs->table_name_blog_posts} WHERE blog_id = %d AND post_id = %d", $this->blog_id, $this->post_id ) );
+
+                $this->id = $post->id;
+                $this->user_id = $post->user_id;
+                $this->blog_id = $post->blog_id;
+                $this->post_id = $post->post_id;
+                $this->date_created = $post->date_created;
+        }
+
+        function save() {
+                global $wpdb, $bp;
+
+                $this->post_id = apply_filters( 'bp_blogs_post_id_before_save', $this->post_id, $this->id );
+                $this->blog_id = apply_filters( 'bp_blogs_post_blog_id_before_save', $this->blog_id, $this->id );
+                $this->user_id = apply_filters( 'bp_blogs_post_user_id_before_save', $this->user_id, $this->id );
+                $this->date_created = apply_filters( 'bp_blogs_post_date_created_before_save', $this->date_created, $this->id );
+
+                do_action( 'bp_blogs_post_before_save', $this );
+
+                if ( $this->id ) {
+                        // Update
+                        $sql = $wpdb->prepare( "UPDATE {$bp->blogs->table_name_blog_posts} SET post_id = %d, blog_id = %d, user_id = %d, date_created = FROM_UNIXTIME(%d) WHERE id = %d", $this->post_id, $this->blog_id, $this->user_id, $this->date_created, $this->id );
+                } else {
+                        // Save
+                        $sql = $wpdb->prepare( "INSERT INTO {$bp->blogs->table_name_blog_posts} ( post_id, blog_id, user_id, date_created ) VALUES ( %d, %d, %d, FROM_UNIXTIME(%d) )", $this->post_id, $this->blog_id, $this->user_id, $this->date_created );
+                }
+
+                if ( !$wpdb->query($sql) )
+                        return false;
+
+                do_action( 'bp_blogs_post_after_save', $this );
+
+                if ( $this->id )
+                        return $this->id;
+                else
+                        return $wpdb->insert_id;
+        }
+
+        /* Static Functions */
+
+        function delete( $post_id, $blog_id ) {
+                global $wpdb, $bp, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_posts} WHERE blog_id = %d AND post_id = %d", $blog_id, $post_id ) );
+        }
+
+        function delete_oldest( $user_id = null ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_posts} WHERE user_id = %d ORDER BY date_created ASC LIMIT 1", $user_id ) );
+        }
+
+        function delete_posts_for_user( $user_id = null ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $bp->loggedin_user->id;
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_posts} WHERE user_id = %d", $user_id ) );
+        }
+
+        function delete_posts_for_blog( $blog_id ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_posts} WHERE blog_id = %d", $blog_id ) );
+        }
+
+        function get_latest_posts( $blog_id = null, $limit = 5 ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( $blog_id )
+                        $blog_sql = $wpdb->prepare( " AND p.blog_id = %d", $blog_id );
+
+                $post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT p.post_id, p.blog_id FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 $blog_sql ORDER BY p.date_created DESC LIMIT $limit" ) );
+
+                for ( $i = 0; $i < count($post_ids); $i++ ) {
+                        $posts[$i] = BP_Blogs_Post::fetch_post_content($post_ids[$i]);
+                }
+
+                return $posts;
+        }
+
+        function get_posts_for_user( $user_id = null ) {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $bp->displayed_user->id;
+
+                // Show a logged in user their posts on private blogs, but not anyone else.
+                if ( !bp_is_my_profile() ) {
+                        $post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT p.post_id, p.blog_id FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND p.user_id = %d ORDER BY p.date_created DESC", $user_id) );
+                        $total_post_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(p.post_id) FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND p.user_id = %d", $user_id) );
+                } else {
+                        $post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT p.post_id, p.blog_id FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND p.user_id = %d ORDER BY p.date_created DESC", $user_id) );
+
+                        $total_post_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(p.post_id) FROM {$bp->blogs->table_name_blog_posts} p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND p.user_id = %d", $user_id) );
+                }
+
+                for ( $i = 0; $i < count($post_ids); $i++ ) {
+                        $posts[$i] = BP_Blogs_Post::fetch_post_content($post_ids[$i]);
+                }
+
+                return array( 'posts' => $posts, 'count' => $total_post_count );
+        }
+
+        function fetch_post_content( $post_object ) {
+                // TODO: switch_to_blog() calls are expensive and this needs to be changed.
+                switch_to_blog( $post_object->blog_id );
+                $post = get_post($post_object->post_id);
+                $post->blog_id = $post_object->blog_id;
+                restore_current_blog();
+
+                return $post;
+        }
+
+        function get_total_recorded_for_user( $user_id = null ) {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(post_id) FROM {$bp->blogs->table_name_blog_posts} WHERE user_id = %d", $user_id ) );
+        }
+
+        function is_recorded( $post_id, $blog_id, $user_id = null ) {
+                global $bp, $wpdb, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM {$bp->blogs->table_name_blog_posts} WHERE post_id = %d AND blog_id = %d AND user_id = %d", $post_id, $blog_id, $user_id ) );
+        }
+
+        function total_post_count( $blog_id ) {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$blog_id )
+                        return false;
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(post_id) FROM {$bp->blogs->table_name_blog_posts} WHERE blog_id = %d", $blog_id ) );
+        }
+
+        function get_all() {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                return $wpdb->get_col( $wpdb->prepare( "SELECT post_id, blog_id FROM " . $bp->blogs->table_name_blog_posts ) );
+        }
+
+}
+
+/* DEPRECATED - Comment DB recording is scheduled for removal. Please use the activity stream to fetch a user's comments. */
+Class BP_Blogs_Comment {
+        var $id;
+        var $user_id;
+        var $blog_id;
+        var $comment_id;
+        var $comment_post_id;
+        var $date_created;
+
+        function bp_blogs_comment( $id = false, $blog_id = false, $comment_id = false ) {
+                global $bp, $wpdb;
+
+                if ( !$user_id )
+                        $user_id = $bp->displayed_user->id;
+
+                if ( $id || ( !$id && $blog_id && $comment_id ) ) {
+                        $this->id = $id;
+                        $this->blog_id = $blog_id;
+                        $this->comment_id = $comment_id;
+                        $this->populate();
+                }
+        }
+
+        function populate() {
+                global $wpdb, $bp;
+
+                if ( $this->id )
+                        $comment = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$bp->blogs->table_name_blog_comments} WHERE id = %d", $this->id ) );
+                else
+                        $comment = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$bp->blogs->table_name_blog_comments} WHERE blog_id = %d AND comment_id = %d", (int)$this->blog_id, (int)$this->comment_id ) );
+
+                $this->comment_id = $comment->comment_id;
+                $this->user_id = $comment->user_id;
+                $this->blog_id = $comment->blog_id;
+                $this->comment_post_id = $comment->comment_post_id;
+                $this->date_created = $comment->date_created;
+        }
+
+        function save() {
+                global $wpdb, $bp;
+
+                $this->comment_id = apply_filters( 'bp_blogs_comment_id_before_save', $this->comment_id, $this->id );
+                $this->comment_post_id = apply_filters( 'bp_blogs_comment_post_id_before_save', $this->comment_post_id, $this->id );
+                $this->blog_id = apply_filters( 'bp_blogs_comment_blog_id_before_save', $this->blog_id, $this->id );
+                $this->user_id = apply_filters( 'bp_blogs_comment_user_id_before_save', $this->user_id, $this->id );
+                $this->date_created = apply_filters( 'bp_blogs_comment_date_created_before_save', $this->date_created, $this->id );
+
+                do_action( 'bp_blogs_comment_before_save', $this );
+
+                if ( $this->id ) {
+                        // Update
+                        $sql = $wpdb->prepare( "UPDATE {$bp->blogs->table_name_blog_comments} SET comment_id = %d, comment_post_id = %d, blog_id = %d, user_id = %d, date_created = FROM_UNIXTIME(%d) WHERE id = %d", $this->comment_id, $this->comment_post_id, $this->blog_id, $this->user_id, $this->date_created, $this->id );
+                } else {
+                        // Save
+                        $sql = $wpdb->prepare( "INSERT INTO {$bp->blogs->table_name_blog_comments} ( comment_id, comment_post_id, blog_id, user_id, date_created ) VALUES ( %d, %d, %d, %d, FROM_UNIXTIME(%d) )", $this->comment_id, $this->comment_post_id, $this->blog_id, $this->user_id, $this->date_created );
+                }
+
+                if ( !$wpdb->query($sql) )
+                        return false;
+
+                do_action( 'bp_blogs_comment_after_save', $this );
+
+                if ( $this->id )
+                        return $this->id;
+                else
+                        return $wpdb->insert_id;
+        }
+
+        /* Static Functions */
+
+        function delete( $comment_id, $blog_id ) {
+                global $wpdb, $bp, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_comments} WHERE comment_id = %d AND blog_id = %d", $comment_id, $blog_id ) );
+        }
+
+        function delete_oldest( $user_id = null ) {
+                global $wpdb, $bp, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_comments} WHERE user_id = %d ORDER BY date_created ASC LIMIT 1", $user_id ) );
+        }
+
+        function delete_comments_for_user( $user_id = null ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $bp->loggedin_user->id;
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_comments} WHERE user_id = %d", $user_id ) );
+        }
+
+        function delete_comments_for_blog( $blog_id ) {
+                global $wpdb, $bp;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name_blog_comments} WHERE blog_id = %d", $blog_id ) );
+        }
+
+        function get_comments_for_user( $user_id = null ) {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $bp->displayed_user->id;
+
+                // Show the logged in user their comments on hidden blogs, but not to anyone else.
+                if ( !bp_is_my_profile() ) {
+                        $comment_ids = $wpdb->get_results( $wpdb->prepare( "SELECT c.comment_id, c.blog_id FROM {$bp->blogs->table_name_blog_comments} c LEFT JOIN {$wpdb->base_prefix}blogs b ON c.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND c.user_id = %d ORDER BY c.date_created ASC", $user_id) );
+                        $total_comment_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(c.comment_id) FROM {$bp->blogs->table_name_blog_comments} c LEFT JOIN {$wpdb->base_prefix}blogs b ON c.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND c.user_id = %d", $user_id) );
+                } else {
+                        $comment_ids = $wpdb->get_results( $wpdb->prepare( "SELECT c.comment_id, c.blog_id FROM {$bp->blogs->table_name_blog_comments} c LEFT JOIN {$wpdb->base_prefix}blogs b ON c.blog_id = b.blog_id WHERE b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND c.user_id = %d ORDER BY c.date_created ASC", $user_id) );
+
+                        $total_comment_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(c.comment_id) FROM {$bp->blogs->table_name_blog_comments} c LEFT JOIN {$wpdb->base_prefix}blogs b ON c.blog_id = b.blog_id WHERE b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 AND c.user_id = %d", $user_id) );
+                }
+
+                for ( $i = 0; $i < count($comment_ids); $i++ )
+                        $comments[$i] = BP_Blogs_Comment::fetch_comment_content($comment_ids[$i]);
+
+                return array( 'comments' => $comments, 'count' => $total_comment_count );
+        }
+
+        function fetch_comment_content( $comment_object ) {
+                switch_to_blog($comment_object->blog_id);
+                $comment = get_comment($comment_object->comment_id);
+                $comment->blog_id = $comment_object->blog_id;
+                $comment->post = &get_post( $comment->comment_post_ID );
+                restore_current_blog();
+
+                return $comment;
+        }
+
+        function get_total_recorded_for_user( $user_id = null ) {
+                global $bp, $wpdb, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_id) FROM {$bp->blogs->table_name_blog_comments} WHERE user_id = %d", $user_id ) );
+        }
+
+        function total_comment_count( $blog_id, $post_id ) {
+                global $bp, $wpdb;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( $post_id )
+                        $post_sql = $wpdb->prepare( " AND comment_post_id = %d", $post_id );
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_id) WHERE blog_id = %d{$post_sql}", $blog_id ) );
+        }
+
+
+        function is_recorded( $comment_id, $comment_post_id, $blog_id, $user_id = null ) {
+                global $bp, $wpdb, $current_user;
+
+                if ( !$bp->blogs )
+                        bp_blogs_setup_globals();
+
+                if ( !$user_id )
+                        $user_id = $current_user->ID;
+
+                return $wpdb->get_var( $wpdb->prepare( "SELECT comment_id FROM {$bp->blogs->table_name_blog_comments} WHERE comment_id = %d AND blog_id = %d AND comment_post_id = %d AND user_id = %d", $comment_id, $blog_id, $comment_post_id, $user_id ) );
+        }
+
+}
+
 ?>