Changeset 9471 for trunk/src/bp-blogs/bp-blogs-classes.php
- Timestamp:
- 02/10/2015 02:49:16 AM (12 years ago)
- File:
-
- 1 edited
-
trunk/src/bp-blogs/bp-blogs-classes.php (modified) (18 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/bp-blogs/bp-blogs-classes.php
r9354 r9471 40 40 */ 41 41 public function populate() { 42 global $wpdb, $bp; 42 global $wpdb; 43 44 $bp = buddypress(); 43 45 44 46 $blog = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$bp->blogs->table_name} WHERE id = %d", $this->id ) ); … … 54 56 */ 55 57 public function save() { 56 global $wpdb , $bp;58 global $wpdb; 57 59 58 60 $this->user_id = apply_filters( 'bp_blogs_blog_user_id_before_save', $this->user_id, $this->id ); … … 78 80 return false; 79 81 82 $bp = buddypress(); 83 80 84 if ( $this->id ) { 81 85 // Update … … 113 117 */ 114 118 public function exists() { 115 global $bp, $wpdb; 119 global $wpdb; 120 121 $bp = buddypress(); 116 122 117 123 return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(id) FROM {$bp->blogs->table_name} WHERE user_id = %d AND blog_id = %d", $this->user_id, $this->blog_id ) ); … … 141 147 */ 142 148 public static function get( $type, $limit = false, $page = false, $user_id = 0, $search_terms = false, $update_meta_cache = true, $include_blog_ids = false ) { 143 global $bp, $wpdb; 149 global $wpdb; 150 151 $bp = buddypress(); 144 152 145 153 if ( !is_user_logged_in() || ( !bp_current_user_can( 'bp_moderate' ) && ( $user_id != bp_loggedin_user_id() ) ) ) … … 232 240 */ 233 241 public static function delete_blog_for_all( $blog_id ) { 234 global $wpdb , $bp;242 global $wpdb; 235 243 236 244 bp_blogs_delete_blogmeta( $blog_id ); 245 246 $bp = buddypress(); 247 237 248 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name} WHERE blog_id = %d", $blog_id ) ); 238 249 } … … 247 258 */ 248 259 public static function delete_blog_for_user( $blog_id, $user_id = null ) { 249 global $wpdb , $bp;260 global $wpdb; 250 261 251 262 if ( !$user_id ) 252 263 $user_id = bp_loggedin_user_id(); 264 265 $bp = buddypress(); 253 266 254 267 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name} WHERE user_id = %d AND blog_id = %d", $user_id, $blog_id ) ); … … 264 277 */ 265 278 public static function delete_blogs_for_user( $user_id = null ) { 266 global $wpdb , $bp;279 global $wpdb; 267 280 268 281 if ( !$user_id ) 269 282 $user_id = bp_loggedin_user_id(); 283 284 $bp = buddypress(); 270 285 271 286 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->blogs->table_name} WHERE user_id = %d", $user_id ) ); … … 290 305 */ 291 306 public static function get_blogs_for_user( $user_id = 0, $show_hidden = false ) { 292 global $bp, $wpdb; 307 global $wpdb; 308 309 $bp = buddypress(); 293 310 294 311 if ( !$user_id ) … … 325 342 */ 326 343 public static function get_blog_ids_for_user( $user_id = 0 ) { 327 global $bp, $wpdb; 344 global $wpdb; 345 346 $bp = buddypress(); 328 347 329 348 if ( !$user_id ) … … 341 360 */ 342 361 public static function is_recorded( $blog_id ) { 343 global $bp, $wpdb; 362 global $wpdb; 363 364 $bp = buddypress(); 344 365 345 366 return $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$bp->blogs->table_name} WHERE blog_id = %d", $blog_id ) ); … … 358 379 */ 359 380 public static function total_blog_count_for_user( $user_id = null ) { 360 global $bp, $wpdb; 381 global $wpdb; 382 383 $bp = buddypress(); 361 384 362 385 if ( !$user_id ) … … 387 410 */ 388 411 public static function search_blogs( $filter, $limit = null, $page = null ) { 389 global $wpdb , $bp;412 global $wpdb; 390 413 391 414 $search_terms_like = '%' . bp_esc_like( $filter ) . '%'; … … 400 423 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 401 424 } 425 426 $bp = buddypress(); 402 427 403 428 $paged_blogs = $wpdb->get_results( "SELECT DISTINCT bm.blog_id FROM {$bp->blogs->table_name_blogmeta} bm LEFT JOIN {$wpdb->base_prefix}blogs wb ON bm.blog_id = wb.blog_id WHERE ( ( bm.meta_key = 'name' OR bm.meta_key = 'description' ) AND {$search_terms_sql} ) {$hidden_sql} AND wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 ORDER BY meta_value ASC{$pag_sql}" ); … … 422 447 */ 423 448 public static function get_all( $limit = null, $page = null ) { 424 global $bp, $wpdb; 449 global $wpdb; 450 451 $bp = buddypress(); 425 452 426 453 $hidden_sql = !bp_current_user_can( 'bp_moderate' ) ? "AND wb.public = 1" : ''; 427 $pag_sql = ( $limit && $page ) ? $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ) : '';454 $pag_sql = ( $limit && $page ) ? $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ) : ''; 428 455 429 456 $paged_blogs = $wpdb->get_results( "SELECT DISTINCT b.blog_id FROM {$bp->blogs->table_name} b LEFT JOIN {$wpdb->base_prefix}blogs wb ON b.blog_id = wb.blog_id WHERE wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 {$hidden_sql} {$pag_sql}" ); … … 449 476 */ 450 477 public static function get_by_letter( $letter, $limit = null, $page = null ) { 451 global $bp, $wpdb; 478 global $wpdb; 479 480 $bp = buddypress(); 452 481 453 482 $letter_like = '%' . bp_esc_like( $letter ) . '%'; … … 483 512 */ 484 513 public static function get_blog_extras( &$paged_blogs, &$blog_ids, $type = false ) { 485 global $bp, $wpdb; 514 global $wpdb; 515 516 $bp = buddypress(); 486 517 487 518 if ( empty( $blog_ids ) ) … … 562 593 */ 563 594 public static function get_user_blog( $user_id, $blog_id ) { 564 global $bp, $wpdb; 595 global $wpdb; 596 597 $bp = buddypress(); 565 598 566 599 $user_blog = $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$bp->blogs->table_name} WHERE user_id = %d AND blog_id = %d", $user_id, $blog_id ) );
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)