[Ranma2k]

Originally Posted by transitbus

That is exactly what I am trying to do but I get nothing, the module does not even show up.

as per my orignal post, I compiled the different suggestions and this is what i came up with

https://vborg.vbsupport.ru/showpost....&postcount=246

If I can get this to work, I'll work on limiting it to one random picture.

What I would love to have is a module for CMPS that pulls a random pic and shows it for a certain amount of time. So in a way what i want is a random picture of the day that pulls from this addon

Here you go
create a file with the following code:

<?
$rec = $vbulletin->db->query_read("
        SELECT imgid,imgfile,thumbname,imgwidth,imgheight,imgdate
        FROM ".TABLE_PREFIX."vbimghost
        WHERE imgprivate='0'
        order by imgdate DESC
        LIMIT 5
        "); 

$count = $db->num_rows($rec);

$rec2 = $vbulletin->db->query_read("
        SELECT count(*) mark
        FROM ".TABLE_PREFIX."vbimghost
        WHERE userid='$userinfo[userid]' and imgprivate='0'
        "); 
$row2 = $vbulletin->db->fetch_array($rec2);
if ($count){
	while ($row = $vbulletin->db->fetch_array($rec)) {
		$vbimghost['id']=$row['imgid'];
		$vbimghost['path']=$vbulletin->options['bburl']."/".$vbulletin->options['imgdir']."/".$row['imgfile'];
		$vbimghost['dispath']=$vbulletin->options['bburl']."/vbimghost.php?do=displayimg&imgid=".$row['imgid'];
		$vbimghost['width']=$row['imgwidth'];
		$vbimghost['height']=$row['imgheight'];
		$vbimghost['date']=date('Y-m-d', $row['imgdate']);
		if (file_exists($vbulletin->options['imgdir']."/".$row['thumbname'])){
			$vbimghost['thumbpath']=$vbulletin->options['bburl']."/".$vbulletin->options['imgdir']."/".$row['thumbname'];
			$vbimghost['thumbsize']=0;
		}else{ 
			$vbimghost['thumbpath']=$vbimghost['path'];
			if ($row['imgwidth'] <= $vbulletin->options['imgthumw'])
				$vbimghost['thumbsize']=$row['imgwidth'];
			else 
				$vbimghost['thumbsize']=$vbimghost['imgthumw'];
		}
			eval('$mimghost .= "'.fetch_template('vbimghost_memberbit') . '";');
			 $vbimghost['more'] = "<a href='vbimghost.php?do=viewimages&id=$userinfo[userid]'>" .construct_phrase($vbphrase['vbimghost_viewmore'],$row2['mark'])."</a>";
	 } 
}else{
		$vbimghost['more'] = "";
		eval('$mimghost ="'.fetch_template('vbimghost_memberbit_noimg') . '";');
}

$vbimghost['last5'] = $mimghost;

eval('$home["$mods[modid]"][\'content\'] = "' . fetch_template('adv_portal_vbimghost_module') . '";');
?>

Name the file (last5.php) and save it int he module folder

Now create a template with the following name ( adv_portal_vbimghost_module )
and put this code in it

<tr>
<td>
<table class="tborder" align="center" border="0" cellpadding="6" cellspacing="1" width="100%">
<tbody>
	<tr align="center">
		$vbimghost[last5]
	</tr>
</tbody>
</table>
</td>
</tr>

Now go to vbadvanced and chose Add Module --> select PHP FILE

in there set the following :

Module Title : Last 5 images uploaded
Column : center
Active : yes
Update All Pages: yes ( if you want it to be displayed on all pages )
File to include : last5.php
Templates Used : adv_portal_vbimghost_module
Clean File Output: no
Use Module Shell Template: yes


and it should work with you