<?php

     $galclass = new Gallery;

     $_language->read_module('gallery');

     $ergebnis = safe_query("SELECT * FROM ".PREFIX."gallery_groups");

     while($ds = mysql_fetch_array($ergebnis)) {

          $title = $ds['name'];

          $gallerys = mysql_num_rows(safe_query("SELECT galleryID FROM ".PREFIX."gallery WHERE groupID='".$ds['groupID']."'"));

          $pics = mysql_num_rows(safe_query("SELECT picID FROM ".PREFIX."gallery as gal, ".PREFIX."gallery_pictures as pic WHERE gal.groupID='".$ds['groupID']."' AND gal.galleryID=pic.galleryID"));

    $gallery = mysql_fetch_array(safe_query("SELECT * FROM ".PREFIX."gallery WHERE groupID='".$ds['groupID']."' ORDER BY galleryID DESC LIMIT 0,5"));

          

          

          $gallery['picID'] = $galclass->randompic($gallery['galleryID']);

          

          //Bilder ausgabe thumb

          $dir='images/gallery/';

          $gallery['pic'] = $dir.'large/'.$gallery['picID'].'.jpg';

          //Bilder ausgabe thumb ende

          

               //most hits

     $ds = mysql_fetch_array(safe_query("SELECT picID FROM ".PREFIX."gallery_pictures ORDER BY views DESC LIMIT 0,1"));

     if(!$ds[picID]) $ds[picID] = $galclass->randompic();

     $most_hits = $galclass->showthumb($ds[picID]);

     

          //views ausgabe     geht leider nur von einem pic,

          $views = safe_query("SELECT * FROM ".PREFIX."gallery_pictures WHERE galleryID='".$gallery['galleryID']."'");           

          if(mysql_num_rows($views)) {

          $view = array();

               while($ds = mysql_fetch_array($views)) {

                    $view[] = $ds['views'];                    

               }               

           $views = array_sum($view);           

          }     

          //views ausgabe     ende

          eval ("\$sc_gallery = \"".gettemplate("sc_gallery")."\";");

          echo $sc_gallery;

     $_language->read_module('gallery');

     }

?>

$ergebnis = safe_query("SELECT * FROM ".PREFIX."gallery_groups DESC LIMIT 0.5");