juliocavalcanti

Lightbox SlideGallery with one Thumbnail [NextGen Custom]

Sep 2nd, 2013 (edited)
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.88 KB | None | 0 0
  1. <?php
  2.  
  3. global $wpdb;
  4.         $galleries = new stdClass;
  5.         $galleries = $wpdb->get_results('SELECT gid,previewpic,title,name FROM wp_dnag_ngg_gallery');
  6.        
  7.         print_r($galleries);
  8.        
  9.         foreach($galleries as $gallery){
  10.  
  11.                 $previewpic_id = $gallery->previewpic;
  12.                 $gallery_id = $gallery->gid;
  13.                 $gallery_title = $gallery->title;
  14.                 $gallery_name = $gallery->name;
  15.                 $picture = new stdClass;
  16.                 $picture = $wpdb->get_results('SELECT filename,description FROM wp_dnag_ngg_pictures WHERE pid = '. $previewpic_id);
  17.                 $picture = $picture[0];
  18.                 $previewpic_filename = $picture->filename;
  19.                 $previewpic_description = $picture->description;
  20.                 $pictures = new stdClass;
  21.                 $pictures = $wpdb->get_results('SELECT pid,filename,description FROM wp_dnag_ngg_pictures WHERE galleryid = '. $gallery_id);
  22.                 $siteurl = get_bloginfo('url');
  23.                 $qnt_images  = intval($wpdb->get_var("SELECT COUNT(*) FROM wp_dnag_ngg_pictures WHERE galleryid = ".$gallery_id));
  24.                 $img_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$previewpic_filename;
  25.                 $content = '<div class="image-gallery">';
  26.                 $content .= '   <a rel="lightbox[set_'.$gallery_id.']" class="galeria-fotos" href="'.$img_url.'" title="'.$previewpic_description.'">';
  27.                 $content .= '   <div class="preview-image">';
  28.                 $content .= '   <img alt="'.$previewpic_description.'" class="Thumb" title="'.$previewpic_description.'" width="333" src="'.$img_url.'" />';
  29.                 $content .= '   </div><h6>'.$gallery_title.'</h6></a><p>'.$qnt_images.' Fotos</p>';
  30.                 $i = 0;
  31.                
  32.                 while($i <= sizeof($pictures)-1){
  33.                         $picture_filename = $pictures[$i]->filename;
  34.                         $picture_description = $pictures[$i]->description;
  35.                         $picture_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$picture_filename;
  36.                         if($pictures[$i]->pid != $previewpic_id){
  37.                                 $content .= '   <div class="hidden-images" style="display:none;">';
  38.                                 $content .= '           <div>';
  39.                                 $content .= '                   <a rel="lightbox[set_'.$gallery_id.']" class="galeria-fotos" href="'.$picture_url.'" title="'.$picture_description.'"><img id="foto-'.$pictures[$i]->pid.'" width="1" src="'.$picture_url.'" /></a>';
  40.                                 $content .= '           </div>';
  41.                                 $content .= '   </div>';
  42.                         }
  43.                         $i++;
  44.                 }
  45.                 $content .= '</div>';
  46.        
  47.                 echo $content;
  48.  
  49.         }
  50.  
  51. ?>
Advertisement
Add Comment
Please, Sign In to add comment