Pasted

<?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;
 
        }
 
?>