@@ 499-512 (lines=14) @@ | ||
496 | return $totals; |
|
497 | } |
|
498 | ||
499 | public function get_posts_total() { |
|
500 | $totals = array(); |
|
501 | global $wpdb, $blog_id; |
|
502 | ||
503 | $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 ) ); |
|
504 | ||
505 | if ( ! empty( $my_data ) ) { |
|
506 | foreach ( $my_data as $row ) { |
|
507 | $totals[] = new Sharing_Post_Total( $row->id, $row->total ); |
|
508 | } |
|
509 | } |
|
510 | ||
511 | usort( $totals, array( 'Sharing_Post_Total', 'cmp' ) ); |
|
512 | ||
513 | return $totals; |
|
514 | } |
|
515 | } |
@@ 359-374 (lines=16) @@ | ||
356 | 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 ) ); |
|
357 | } |
|
358 | ||
359 | public function get_posts_total() { |
|
360 | global $wpdb, $blog_id; |
|
361 | ||
362 | $totals = array(); |
|
363 | $name = strtolower( $this->get_id() ); |
|
364 | ||
365 | $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 ) ); |
|
366 | ||
367 | if ( ! empty( $my_data ) ) { |
|
368 | foreach ( $my_data as $row ) { |
|
369 | $totals[] = new Sharing_Post_Total( $row->id, $row->total ); |
|
370 | } |
|
371 | } |
|
372 | ||
373 | usort( $totals, array( 'Sharing_Post_Total', 'cmp' ) ); |
|
374 | ||
375 | return $totals; |
|
376 | } |
|
377 |