Geeklog Forums

// RANDOM IMAGE FUNCTION
function phpblock_rand4image() {
        global $_CONF, $_USER, $_TABLES;
       
        $imgdir = "photos";
        $title_limit = 30;
        $dscp_limit = 50;
               
        // DATABASE
        $rand_sql = DB_query("SELECT image_id,cat_id,image_name,image_description,image_thumb_file FROM 4images_images WHERE (image_thumb_file!='')ORDER BY RAND(NOW()) LIMIT 1");
        $num = DB_numRows($rand_sql);
        if ($num == 0) {
                $rand .= '<br/><center>No images exist yet!</center><br/>';    
        } else {
                $A = DB_fetchArray($rand_sql);
                $album = DB_getItem("4images_categories",cat_name,"cat_id=$A[cat_id]");
       
                if(strlen ($A['image_name']) > $title_limit){
                        $A['image_name'] = substr($A['image_name'], 0, $title_limit);
                        $A['image_name'] .= "..";
                }

                $rand .='<table width="98%"><td width="100%">';
                $rand .='<center><a href="' .$_CONF['site_url']. '/' .$imgdir. '/details.php?image_id=' .$A['image_id']. '">';
                $rand .='<img src="' .$_CONF['site_url']. '/' .$imgdir. '/data/thumbnails/' .$A['cat_id']. '/' .$A['image_thumb_file']. '" alt="' .$A['image_name']. '" style="border: 1 solid #000000;"><br>';
                $rand .=$A['image_name'];
                $rand .='</a></center>';
                $rand .='<br>Album: <a href="' .$_CONF['site_url']. '/' .$imgdir. '/categories.php?cat_id=' .$A['cat_id']. '">' .$album. '</a>';
                $rand .='</td></table>';        

                return $rand;
        }
}