Changeset 1021 for trunk/bp-wire/bp-wire-classes.php
- Timestamp:
- 02/06/2009 03:07:48 AM (17 years ago)
- File:
-
- 1 edited
-
trunk/bp-wire/bp-wire-classes.php (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/bp-wire/bp-wire-classes.php
r511 r1021 24 24 global $wpdb, $bp; 25 25 26 $sql = $wpdb->prepare( "SELECT * FROM " . $this->table_name . "WHERE id = %d", $this->id );26 $sql = $wpdb->prepare( "SELECT * FROM {$this->table_name} WHERE id = %d", $this->id ); 27 27 28 28 $wire_post = $wpdb->get_row($sql); … … 41 41 if ( $this->id ) { 42 42 $sql = $wpdb->prepare( 43 "UPDATE " . $this->table_name . "SET43 "UPDATE {$this->table_name} SET 44 44 item_id = %d, 45 45 user_id = %d, … … 57 57 } else { 58 58 $sql = $wpdb->prepare( 59 "INSERT INTO " . $this->table_name . "(59 "INSERT INTO {$this->table_name} ( 60 60 item_id, 61 61 user_id, … … 84 84 global $wpdb, $bp; 85 85 86 return $wpdb->query( $wpdb->prepare( "DELETE FROM " . $this->table_name . "WHERE id = %d", $this->id ) );86 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$this->table_name} WHERE id = %d", $this->id ) ); 87 87 } 88 88 … … 95 95 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 96 96 97 $wire_posts = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . $table_name . "WHERE item_id = %d ORDER BY date_posted DESC $pag_sql", $item_id ) );98 $count = $wpdb->get_var( $wpdb->prepare( "SELECT count(id) FROM " . $table_name . "WHERE item_id = %d", $item_id ) );97 $wire_posts = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$table_name} WHERE item_id = %d ORDER BY date_posted DESC $pag_sql", $item_id ) ); 98 $count = $wpdb->get_var( $wpdb->prepare( "SELECT count(id) FROM {$table_name} WHERE item_id = %d", $item_id ) ); 99 99 100 100 return array( 'wire_posts' => $wire_posts, 'count' => $count );
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)