How to display NextGEN gallery in templates?

Question

I have installed the NextGEN Gallery plugin and have all my images in albums. Can someone please support me in displaying the NextGEN gallery with the use of the Galleryview plugin?

Is there any easier way?

Answer 1

With both Nextgen Gallery and Nextgen-Galleryview active, the shortcode [nggallery id=1 template="galleryview"] should work with 1 being your gallery ID.

Answer 2

// How to fetch NextGEN Gallery by custom query    
$sqlquery = "SELECT * FROM wp_ngg_pictures 
    WHERE gid=3 AND wp_ngg_pictures.gid='wp_ngg_pictures'.galleryid ";
$pageposts = $wpdb->get_results( $sqlquery );
if ( $pageposts ) {
    global $post;
    foreach ( $pageposts as $post ) { 
        ?><img src="<?php echo $post->path; ?>/<?php echo $post->filename; ?>" alt=""><?php
    }
}