Random Image for SMF Gallery Mod

[jacortina]

Great! I will try, so whats the final code with no errors?

That depends (sorry, but it's true).

Do you want to put the random image function in your SSI (do you plan on multiple occurrences of calling it or calling it from you site, but outside the TP/Forum structure)?

Do you want to display the extra links to guests or not?

If modifying SSI, look at first post in this thread for what you have to do to accomplish that.

Then create a phpblock with this code:

Code Select Expand

global $scripturl, $user_info;

ssi_galleryrandom();

if ($user_info['is_guest']) {
echo 'Please register so you can add your pics to the gallery';
}
else
{
echo '<center>
<br>
<a href="',$scripturl,'?action=gallery">Show Gallery</a>
<br>
<a href="',$scripturl,'?action=gallery;sa=add;cat=1">Add Picture</a>
</center>';
}

If you don't want to modify SSI.php, replace the single line:
ssi_galleryrandom();
in the above with the actual contents of the function:

Code Select Expand

global $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>';

[kran1um]

Thanks! It worked!