Просмотр поста

# случайный вывод новых фоток	
	if (!$user_id){ # не показываем своим юзерам
	echo '<br />Новые Фото:<br />';
    $req = mysql_query("SELECT `cms_album_files`.*, `users`.`name` AS `user_name`, `cms_album_cat`.`name` AS `album_name`$select
    FROM `cms_album_files`
    INNER JOIN `users` ON `cms_album_files`.`user_id` = `users`.`id`
    INNER JOIN `cms_album_cat` ON `cms_album_files`.`album_id` = `cms_album_cat`.`id`
    WHERE `cms_album_files`.`time` > '" . ($realtime - 25920000) . "'" . ($rights >= 6 ? "" : " AND `cms_album_files`.`access` > '1'") . "
    ORDER BY RAND()
    LIMIT 0,8");
    while ($res = mysql_fetch_assoc($req)) {
	echo '<a href="id' . $res['user_id'] . '"><img src="../../files/users/album/' . $res['user_id'] . '/' . $res['tmb_name'] . '" width="23" height="31" /></a>';
	}
	} # end rand photo