Random Image in Block?

[Maya]

The code looks similar to an earlier post, but np

Thanks..I popped it in and ...

and it works, I just wanted to  uh.. 'enhance ' it now

show 3 or 4 images in a center block at once

do you know how?

[Maya]

rofl.. u should here what my son just asked

[Jpg]

Let me take a look into it. I'll see what I can do. If I remember correctly I can make an infinite amount...

[usermike3969]

try like this

Code: [Select]

function ssi_galleryrandom()

 {
  global $scripturl,$db_prefix,$modSettings,$boardurl;
  echo'<table cellspacing="0" cellpadding="5" border="0" align="center" width="90%"><tr>';
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
  $request = db_query("SELECT thumbfilename,ID_PICTURE FROM {$db_prefix}gallery_pic GROUP BY thumbfilename ORDER BY RAND() LIMIT 3", __FILE__,__LINE__);
  while ($row = mysql_fetch_assoc($request))
  echo' <center><td align="center" colspan="3"><a href="', $scripturl, '?action=gallery;sa=view;id=',
  $row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] .

  $row['thumbfilename'] ,'" /></a></center>';
  echo'</td></tr>';
  echo'</table></br>';
  mysql_free_result($request);
}

[Jpg]

Nice.

I like it.
How about for 5...

Code: [Select]

function ssi_galleryrandom()
{
  global $scripturl,$db_prefix,$modSettings,$boardurl;
  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }

  $request = db_query("SELECT thumbfilename,ID_PICTURE
                                FROM {$db_prefix}gallery_pic
                                ORDER BY RAND() LIMIT 5", __FILE__, __LINE__);

  while ($row = mysql_fetch_assoc($request))
  {
    echo' <center><a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] . $row['thumbfilename'] ,'" /></a></center>';
  }
  mysql_free_result($request);
}
I got some help from a pal of mine.

Shows 5. Just add this to the bottom of your SSi.php.
Then you can use the SSI function

Code: [Select]

ssi_galleryrandom();

[usermike3969]

nice but it puts them under each other and i think she wonted them beside each other thats y i made the tables in the code i edited

[Jpg]

I love your idea much more better.

[Maya]

hehe... ur right usermike...5 random go vertical..

I definitely want them to go horrorzontally...

autothumbnailing too... sure looks like it from the pics I put in for test..*thmbs up 2u

very cool...

[usermike3969]

so does that mean it worked ?

[Maya]

  lol...sorry...( im trying to cook some grub too...)

yes it worked..I even experimented....

changed the colspan from 3 to 5
and the limit 3 to limit 5...

voila...perfect ( almost: auto- height resizes but not width)

sorry for takin so long...


and thanks all for your patience... 

[Jpg]

I had some fun with the template with this code.
I'll post up some codes later, some for editing it like adding a logo and 5 most recent images, and 5 random images with little pictures as headers...blah blah blah.

[Maya]

cool Jpg

5 most recent for a tp side block...

what about having them able to randomise from certain cats only....

ie: have one center block for a cat of artwork and one for musicians run in another block right below...

uh oh...I feel a few more ideas comin on...lol

btw-same Maya 

[xface]

what happen when u tried the linking codes

This:

Parse error: syntax error, unexpected '=' in /full/directory/path/www/site/SSI.php on line 1572

I have tryed just about every combination to get it included, but then again my knowledge is not all that great, LOL!!

[usermike3969]

try this

Code: [Select]

function ssi_galleryrandom()
{
  global $scripturl,$db_prefix,$modSettings,$boardurl;

  if(empty($modSettings['gallery_url']))
  {
    $modSettings['gallery_url'] = $boardurl . '/gallery/';
  }
 
  $request = db_query("SELECT thumbfilename,ID_PICTURE,filename FROM

{$db_prefix}gallery_pic GROUP BY thumbfilename ORDER BY RAND() LIMIT 1", __FILE__,

__LINE__);
  $row = mysql_fetch_assoc($request);
  mysql_free_result($request);
  echo' <center><a href="', $scripturl, '?action=gallery;sa=view;id=',

$row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] .

$row['thumbfilename'] ,'" /></a></center>'

;
?><script language="javascript" type="text/javascript">
<!--
function linkingcodes() {
  newwindow2=window.open('','name','height=350,width=800,scrollbars=yes');
  var tmp = newwindow2.document;
  tmp.write('<html><head><title>Linking codes</title>');
  tmp.write('');
  tmp.write('</head><body bgcolor="#000000"><center><font color="#FFFFFF">');
  tmp.write('HTML THUMB</br>&lt;img src="<?echo $modSettings['gallery_url'].$row['thumbfilename'];?>"&gt; ');
  tmp.write('</br></br>HTML</br>&lt;img src="<?echo $modSettings['gallery_url'].$row['filename']; ?>"&gt;');
  tmp.write('</br></br>BBC THUMB</br>[img]<?echo $modSettings['gallery_url'].$row['thumbfilename'];?>[/img]');
  tmp.write('</br></br>BBC</br>[img]<?echo $modSettings['gallery_url'].$row['filename']; ?>[/img]');
  tmp.write('</font></center></body></html>');
  tmp.close();
}
// -->
</script><center><form>
</br><input type="button" onClick="return linkingcodes()" value="Linking codes!">
</form></center>
<?
}
place this before

Code: [Select]

?>

[xface]

yup that works perfect!! is there an easy way to combine the thumbnail with the direct link to the gallery full image page? I think this little code is priceless!!!

your the king!