Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- global $wpdb;
- $album = $wpdb->get_var('SELECT sortorder FROM wp_ngg_album WHERE id =' . $album_id);
- $galleries = unserialize($album);
- $gallery_ids = join(',',$galleries);
- $users = $wpdb->get_results("SELECT DISTINCT wp_users.display_name, wp_users.ID
- FROM wp_ngg_gallery
- INNER JOIN wp_users ON wp_ngg_gallery.author = wp_users.ID
- WHERE wp_ngg_gallery.gid IN ($gallery_ids)");
- $count = $wpdb->get_var("SELECT count(1)
- FROM wp_ngg_gallery
- INNER JOIN wp_users ON wp_ngg_gallery.author = wp_users.ID
- WHERE wp_ngg_gallery.gid IN ($gallery_ids)");
- $i = 0;
- echo $count;
- foreach($users as $user) {
- $i++;
- echo '<a href="#' . $user->ID . '">' . $user->display_name . '</a>' . (($i !== $count) ? ', ' : NULL);
- })
Add Comment
Please, Sign In to add comment