Guest User

Untitled

a guest
Jun 24th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. global $wpdb;
  2. $album = $wpdb->get_var('SELECT sortorder FROM wp_ngg_album WHERE id =' . $album_id);
  3. $galleries = unserialize($album);
  4.  
  5. $gallery_ids = join(',',$galleries);
  6.  
  7. $users = $wpdb->get_results("SELECT DISTINCT wp_users.display_name, wp_users.ID
  8. FROM wp_ngg_gallery
  9. INNER JOIN wp_users ON wp_ngg_gallery.author = wp_users.ID
  10. WHERE wp_ngg_gallery.gid IN ($gallery_ids)");
  11.  
  12. $count = $wpdb->get_var("SELECT count(1)
  13. FROM wp_ngg_gallery
  14. INNER JOIN wp_users ON wp_ngg_gallery.author = wp_users.ID
  15. WHERE wp_ngg_gallery.gid IN ($gallery_ids)");
  16. $i = 0;
  17. echo $count;
  18. foreach($users as $user) {
  19. $i++;
  20. echo '<a href="#' . $user->ID . '">' . $user->display_name . '</a>' . (($i !== $count) ? ', ' : NULL);
  21. })
Add Comment
Please, Sign In to add comment