<?php
class gallery_simple_module extends CmsModule {
    var $root = "/";
    var $gallery_table = "gallery";
    var $gallery_path = "/gallery/";
    var $thumbnail_path= "/gallery/tn/";
    var $grid_template = "gallery_grid.tpl";
    var $single_template = "gallery_single.tpl";
    // warning sign image
    var $warning_sign = "icon/warning_sign.png";
 
    var $max_width = "500";
    var $default_album=1;
 
    function init(){
        parent::init();
        $this->root = $GLOBALS['cms_config']['root'];
        // max width from globals first
        if ($GLOBALS['cms_config']['gallery_image_max_width'] != "")
            $this->max_width =
                  $GLOBALS['cms_config']['gallery_image_max_width'];
        // can be overridden by template parameters
        if ($this->vars['max_width'] != "")
            $this->max_width = $this->vars['image_max_width'];
        if ($this->vars['warning_sign'] != "")
            $this->warning_sign = $this->vars['warning_sign'];
 
    }
    // get single value from an sql query or false if error or zero lines
    // this function is found in 'utils.php' as well
    function getSQLvalue($sql){
        $result = @mysql_query($sql);
        if (mysql_error()) {
            return false;
        } else {
            if (mysql_num_rows($result)==0) {
                return false;
        } else {
                $row=mysql_fetch_row($result);
                return $row[0];
            }
        }
    }
 
    /**
     * Combine showing the image grid and a single image
     * to one module due to the simplicity of the task.
     */
    function fetch(){
        $mySmarty = new Smarty();
        // first the single image case: we get the image id in $_GET
        $error = '';
        if ($_GET['img_id'] != ''){
            $id=mysql_real_escape_string($_GET['img_id']);
            // filter out breaking/XSS attempts
            // more checks needed for error handling, though
            if (!ctype_digit($id)){
                $error = 'Error: image id is not valid';
                $mySmarty->assign('imagepath',$this->warning_sign);
                $mySmarty->assign('error',$error);
            } else {
                $query = "SELECT id,imagepath,title,description " .
                         "FROM $this->gallery_table WHERE id=$id";
                $result = mysql_query($query);
                $obj = mysql_fetch_object($result);
                $abs_image_path = $this->root.$this->gallery_path.$obj->imagepath;
                $img = imagecreatefromjpeg($abs_image_path);
                $width = imagesx($img);
                $height= imagesy($img);
                // calculate new dimensions if necessary
                if ($width > $this->max_width){
                    $proportion = $width / $height;
                    $width = $this->max_width;
                    $height= floor($width / $proportion);
                }
                $mySmarty->assign("imagepath",$this->gallery_path.
                                 $obj->imagepath);
                $mySmarty->assign("title",$obj->title);
                $mySmarty->assign("description",$obj->description);
                $mySmarty->assign("width",$width);
                $mySmarty->assign("height",$height);
            }
 
            return $mySmarty->fetch($this->single_template);
 
        // Then the grid case - show several images
        } else {
            // do we have album id in the URL
            if (isset($_GET['aid'])){
                $aid = mysql_real_escape_string($_GET['aid']);
                // filter out possible breaking attempt
                if (!ctype_digit($aid)){
                    $error = "Error: Gallery id '$aid' is not valid";
                    $mySmarty->assign('error',$error);
                    // get default album
                    $aid = $this->getSQLvalue(
                           "SELECT id FROM gallery_albums " .
                           "WHERE default_album=1");
                }
                if (!($aid > 0)){
                    // if empty or <= zero get default
                    $aid = $this->getSQLvalue(
                           "SELECT id FROM gallery_albums " .
                           "WHERE default_album=1");
                }
            } else {
                // get the default album
                $aid = $this->getSQLvalue(
                       "SELECT id FROM gallery_albums " .
                       "WHERE default_album=1");
            }
            // first get all the images in the album and add to array
            $query =  "SELECT gallery.id, gallery.imagepath, gallery.title " .
                      "FROM images_albums, gallery " .
                      "WHERE images_albums.album_id=$aid " .
                      "AND gallery.id = images_albums.photo_id ";
            $result = mysql_query($query);
            $photos = array();
            while ($obj = mysql_fetch_object($result)){
                $photo = array();
                $photo['id'] = $obj->id;
                $photo['imagepath'] = $obj->imagepath;
                $photo['title'] = $obj->title;
                $photos[] = $photo;
            }
            // now let's list all the albums that have photos in them
            // for the dropdown above the image grid
            $query ="SELECT album_id AS id,name " .
                    "FROM images_albums,gallery_albums " .
                    "WHERE gallery_albums.id=album_id " .
                    "GROUP BY album_id ";
            $result = mysql_query($query);
            while ($obj=mysql_fetch_object($result)){
                $album = array();
                $album['id']   = $obj->id;
                $album['name'] = $obj->name;
                $albums[] = $album;
            }
            // now we have evetything in place, assign and fetch!
            $mySmarty->assign("aid",$aid);
            $mySmarty->assign('photos',$photos);
            $mySmarty->assign('albums',$albums);
            $mySmarty->assign("thumbnail_dir",$this->thumbnail_path);
            return $mySmarty->fetch($this->grid_template);
        }
    }
 
}
?>