Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $wpdb;
- $galleries = new stdClass;
- $galleries = $wpdb->get_results('SELECT gid,previewpic,title,name FROM wp_dnag_ngg_gallery');
- print_r($galleries);
- foreach($galleries as $gallery){
- $previewpic_id = $gallery->previewpic;
- $gallery_id = $gallery->gid;
- $gallery_title = $gallery->title;
- $gallery_name = $gallery->name;
- $picture = new stdClass;
- $picture = $wpdb->get_results('SELECT filename,description FROM wp_dnag_ngg_pictures WHERE pid = '. $previewpic_id);
- $picture = $picture[0];
- $previewpic_filename = $picture->filename;
- $previewpic_description = $picture->description;
- $pictures = new stdClass;
- $pictures = $wpdb->get_results('SELECT pid,filename,description FROM wp_dnag_ngg_pictures WHERE galleryid = '. $gallery_id);
- $siteurl = get_bloginfo('url');
- $qnt_images = intval($wpdb->get_var("SELECT COUNT(*) FROM wp_dnag_ngg_pictures WHERE galleryid = ".$gallery_id));
- $img_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$previewpic_filename;
- $content = '<div class="image-gallery">';
- $content .= ' <a rel="lightbox[set_'.$gallery_id.']" class="galeria-fotos" href="'.$img_url.'" title="'.$previewpic_description.'">';
- $content .= ' <div class="preview-image">';
- $content .= ' <img alt="'.$previewpic_description.'" class="Thumb" title="'.$previewpic_description.'" width="333" src="'.$img_url.'" />';
- $content .= ' </div><h6>'.$gallery_title.'</h6></a><p>'.$qnt_images.' Fotos</p>';
- $i = 0;
- while($i <= sizeof($pictures)-1){
- $picture_filename = $pictures[$i]->filename;
- $picture_description = $pictures[$i]->description;
- $picture_url = $siteurl.'/wp-content/gallery/'.$gallery_name.'/'.$picture_filename;
- if($pictures[$i]->pid != $previewpic_id){
- $content .= ' <div class="hidden-images" style="display:none;">';
- $content .= ' <div>';
- $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>';
- $content .= ' </div>';
- $content .= ' </div>';
- }
- $i++;
- }
- $content .= '</div>';
- echo $content;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment