случайное фото на главной странице

а никто не делал случайное фото на главной странице сайта???? встречался старый мод, только на 3.20 не работает... может поможете?

1) откройте файл home.php перед строкой

// ASSIGN SMARTY VARIABLES AND INCLUDE FOOTER

Вставить

// START - GET RAND PHOTOS
if( in_array('album', $global_plugins) )
{
$rand = $database->database_query("
SELECT
se_media.*,
se_albums.album_id,
se_users.user_id,
se_users.user_username
FROM
se_media
LEFT JOIN
se_albums
ON se_albums.album_id=se_media.media_album_id
LEFT JOIN
se_users
ON se_users.user_id=se_albums.album_user_id
LEFT JOIN
se_levels
ON se_users.user_level_id=se_levels.level_id
WHERE
se_albums.album_search='1' OR
se_levels.level_album_search='0'
ORDER BY
rand()
LIMIT
20
");

$rand_photos = array();
while( $row=$database->database_fetch_assoc($rand) )
{
if( !in_array($row['media_ext'], array('jpg', 'jpeg', 'gif', 'png', 'bmp', 'tif')) ) continue;

$row['media_path'] = $url->url_userdir($row['user_id']).$row['media_id'].'.'.$row['media_ext'];

$rand_photos[] = $row;
}

$smarty->assign('rand_photos', $rand_photos);
}
// END – GET RAND PHOTOS

2) Открыть home.tpl в нем в нужном месте вставить

{* START - RAND PHOTOS *}
{if !empty($rand_photos)}
<table cellspacing='0' class='portal_table' align='center' width='100%'>
<tr><td class='header'>Случайное фото</td></tr>
<tr>
<td class='portal_box'>
{if !empty($rand_photos)}
{section name=rand_photos_loop loop=$rand_photos max=3}{* START NEW ROW *}
{cycle name="startrow_rand_photos" values="<table cellpadding='0' cellspacing='0' align='center'><tr>,,,,"}
<td class='portal_member'>
{strip}
<div align="center" style="width:96px; height:96px; border: 1px solid #A0A0A0; background: #E0E0E0;">
<a href='{$url->url_create("album_file", $rand_photos[rand_photos_loop].user_username, $rand_photos[rand_photos_loop].album_id,$rand_photos[rand_photos_loop].media_id)}' style="display:block;">
{if $rand_photos[rand_photos_loop].media_ext == "jpg" OR
$rand_photos[rand_photos_loop].media_ext == "jpeg" OR
$rand_photos[rand_photos_loop].media_ext == "gif" OR
$rand_photos[rand_photos_loop].media_ext == "png" OR
$rand_photos[rand_photos_loop].media_ext == "tif" OR
$rand_photos[rand_photos_loop].media_ext == "bmp"}
<img src='{$rand_photos[rand_photos_loop].media_path}' class='photo' style="border:none; margin:3px;" border='0' width='{$misc->photo_size($rand_photos[rand_photos_loop].media_path,"90","90","w")}'>
{else}
<img src='./images/icons/file_big.gif' valign="center" class='photo' border='0' width='{$misc->photo_size("./images/icons/file_big.gif","90","90","w")}'>
{/if}
</a>
</div>
{/strip}

<div align="center">
<a href='{$url->url_create("album_file",$rand_photos[rand_photos_loop].user_username, $rand_photos[rand_photos_loop].album_id, $rand_photos[rand_photos_loop].media_id)}' style="display:block;">
{$rand_photos[rand_photos_loop].media_title|truncate:15|default:"Untitled"}
</a>
</div>

<div align="center" style="font-weight:normal;">
by
<a href='{$url->url_create("profile",$rand_photos[rand_photos_loop].user_username)}' style="font-weight:normal;">
{$rand_photos[rand_photos_loop].user_username|truncate:15}
</a>
</div>
</td>
{* END ROW AFTER 5 RESULTS *}
{if $smarty.section.rand_photos_loop.last == true}
</tr></table>
{else}
{cycle name="endrow_rand_photos" values=",,,,</tr></table>"}
{/if}
{/section}
{else}
К сожалению, в базе нет ни одного фото.
{/if}
</td>
</tr>
</table>
{/if}
{* END - RAND PHOTOS *}