Random Image in Block?

[usermike3969]

what happen when u tried the linking codes

[xface]

fatal error, but I think I might have screwed something up there. I will try it again today now that I have a few hours of sleep under my belt.

I will let you know how it turns out...

[Maya]

I, understand code, but don't know how to write code, yet  , so I am just content to get this working for now with 1 image...figure the rest out later

lol... not havin fun here...no biggie, just  trying this on a test site till I see something work..

heres what I have done..

added the code to the ssi.php

created a php block (thnx btw)

and heres what I get...

Fatal error: Cannot redeclare ssi_grandom() (previously declared in /home/talk/public_html/test/SSI.php:1595) in /home/talk/public_html/test/Sources/Load.php(1708) : eval()'d code(35) : eval()'d code on line 1

[SMFHacks]

What are you putting in the php block?

[Maya]

 ...k..( sorry Im workin on about 10 different thing right now...)

I pasted the wrong code in...
(its ok btw, I have just finished a slew of nasty words dericted to self....lol)

now I have put the correct call in the php box

ssi_grandom(2);



I removed the 2 to just make it ();

(if no cat is defined will it just call from all categories ?)

but get a red x...

it is trying to call the image from http://mysite/gallery and I need it to call them from mysite/test/gallery...
Is that back in the ssi.php code I put in...?

[usermike3969]

r u using the last code i gave here ??

[SMFHacks]

This is correct code you all should use

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 GROUP BY thumbfilename ORDER BY RAND() LIMIT 1", __FILE__, __LINE__);
$row = mysql_fetch_assoc($request);
mysql_free_result($request);
echo' <a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="',  $modSettings['gallery_url'] . $row['thumbfilename'] ,'" /></a>'

;}


[xface]

yeah that is the correct code it works awesome.

What I liked about the other code was the linking codes. This would allow members of mine to host the photo at another forum, and in turn drag other visitor's to my site.....

I have not tryed the linking codes version posted earlier yet today, been to busy sleeping...LOL

[Maya]

actually the code i had posted was

Code: [Select]

function ssi_grandom ($cat)
{
    global $scripturl,$modSettings,$db_prefix;
    $cat = (int) $cat;

    $request = db_query("SELECT thumbfilename, filename, ID_CAT, ID_PICTURE FROM {$db_prefix}gallery_pic WHERE ID_CAT = $cat GROUP BY thumbfilename ORDER BY RAND() LIMIT 1", __FILE__, __LINE__);
    $row = mysql_fetch_assoc($request);
    mysql_free_result($request);
    echo' <a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="',$modSettings['gallery_url'], $row['thumbfilename'] ,'" /></a>';
}
(this code got the pics well the red x showing..

I just replaced it with the code u posted and i am back to

Fatal error: Call to undefined function: ssi_grandom() in /home/talk/public_html/test/Sources/Load.php(1708) : eval()'d code(35) : eval()'d code on line 1

phpbox with "ssi_grandom(); "

 

[SMFHacks]

If you use my code then you would put ssi_galleryrandom(); in the php box

[usermike3969]

Maya is what u wont to do is like what i have on my main page in the center at the bottem ??

[Maya]

Perfect... thank you...it works very well

Yes that is exactly what I want to do...a few adjustment for my site( and maybe without the info on bottom, but yes...

*btw thanks for the test for me...

[usermike3969]

Code: [Select]

function ssi_g3random ()
{global $db_prefix, $scripturl, $txt, $context,$ID_MEMBER,$modSettings, $boarddir,$boardurl;
          echo'<table cellspacing="0" cellpadding="5" border="0" align="center" width="90%"><tr>';

         $request10 = db_query("SELECT z.ID_PICTURE, z.commenttotal, z.filesize, z.views, z.thumbfilename, z.title, z.ID_MEMBER, x.memberName, x.realName, z.date, z.description FROM {$db_prefix}gallery_pic as z, {$db_prefix}members AS x WHERE approved = 1 GROUP BY date ORDER BY RAND() DESC LIMIT 3", __FILE__, __LINE__);
          while ($row10 = mysql_fetch_assoc($request10))
          {
          echo'<td align="center" colspan="3"></br><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row10['ID_PICTURE'] . '"><img src="' . $modSettings['gallery_url'] . $row10['thumbfilename']  . '" /></a></br>';
         }
          mysql_free_result($request10);
          echo'</td></tr>';
          echo'</table></br>';
}
this is the code i used but mite not b the best way

[Maya]

no dice...

back to parse error on fp

Parse error: syntax error, unexpected $end in /home/talk/public_html/test/Sources/Load.php(1708) : eval()'d code(35) : eval()'d code on line 1


when I changed this in the ssi,
I changed what i put in the php box to match

ssi_g3random ()
 
then back... hmmm

[Jpg]

I'll help everyone out. I modified SMF Hack's code and made it center when it a block.. No biggy.



USE THIS ONE

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 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>'

;}
Put this in a PHP block.

Code: [Select]

ssi_galleryrandom();