| @@ 497-510 (lines=14) @@ | ||
| 494 | return $totals; |
|
| 495 | } |
|
| 496 | ||
| 497 | public function get_posts_total() { |
|
| 498 | $totals = array(); |
|
| 499 | global $wpdb, $blog_id; |
|
| 500 | ||
| 501 | $my_data = $wpdb->get_results( $wpdb->prepare( 'SELECT post_id as id, SUM( count ) as total FROM sharing_stats WHERE blog_id = %d GROUP BY post_id ORDER BY count DESC ', $blog_id ) ); |
|
| 502 | ||
| 503 | if ( ! empty( $my_data ) ) { |
|
| 504 | foreach ( $my_data as $row ) { |
|
| 505 | $totals[] = new Sharing_Post_Total( $row->id, $row->total ); |
|
| 506 | } |
|
| 507 | } |
|
| 508 | ||
| 509 | usort( $totals, array( 'Sharing_Post_Total', 'cmp' ) ); |
|
| 510 | ||
| 511 | return $totals; |
|
| 512 | } |
|
| 513 | } |
|
| @@ 348-363 (lines=16) @@ | ||
| 345 | return (int) $wpdb->get_var( $wpdb->prepare( 'SELECT count FROM sharing_stats WHERE blog_id = %d AND post_id = %d AND share_service = %s', $blog_id, $post->ID, $name ) ); |
|
| 346 | } |
|
| 347 | ||
| 348 | public function get_posts_total() { |
|
| 349 | global $wpdb, $blog_id; |
|
| 350 | ||
| 351 | $totals = array(); |
|
| 352 | $name = strtolower( $this->get_id() ); |
|
| 353 | ||
| 354 | $my_data = $wpdb->get_results( $wpdb->prepare( 'SELECT post_id as id, SUM( count ) as total FROM sharing_stats WHERE blog_id = %d AND share_service = %s GROUP BY post_id ORDER BY count DESC ', $blog_id, $name ) ); |
|
| 355 | ||
| 356 | if ( ! empty( $my_data ) ) { |
|
| 357 | foreach ( $my_data as $row ) { |
|
| 358 | $totals[] = new Sharing_Post_Total( $row->id, $row->total ); |
|
| 359 | } |
|
| 360 | } |
|
| 361 | ||
| 362 | usort( $totals, array( 'Sharing_Post_Total', 'cmp' ) ); |
|
| 363 | ||
| 364 | return $totals; |
|
| 365 | } |
|
| 366 | ||