function all_albums($id_user)
{
$alb_header = '<span class="header1">Все альбомы</span>';
if (isset($_SESSION['id_user'])) {
$f = " AND ( ( `ascope`='friends' AND " . $_SESSION['id_user'] . " IN (\n\t\t\t\t\tSELECT `id_friend` FROM `friends` frnd WHERE frnd.`id_author`= " . $id_user . ") OR `album`.`id_user`=" . $_SESSION['id_user'] . ") OR \n\t\t\t\t\t \t\t( `ascope`='onlyme' AND `album`.`id_user`=" . $_SESSION['id_user'] . ") OR (`ascope` = 'all') )";
} else {
$f = " AND ( `ascope` = 'all' )";
}
$res = $this->q("SELECT `id_album`, `id_user` 'id_author', `name`, `image`, DATE_FORMAT(`date`, '%e.%m.%Y') 'date'\n\t\t\t\t\t\t FROM `album` WHERE `id_user`=" . $id_user . $f . " ORDER BY `date` ASC");
for ($i = 0; $row_albums = mysql_fetch_assoc($res); $i++) {
$num_photos = mysql_num_rows($this->q("SELECT `id_photo` FROM `photo` WHERE `id_album`=" . $row_albums['id_album']));
$albumname = wordwrap($row_albums['name'], 10, "<br>", 1);
$albmp[$i] = new album($id_user, $row_albums['id_album'], $num_photos, $albumname, $row_albums['image'], $row_albums['date'], false, false);
}
$all_albums = new section($alb_header, 8, 5);
$all_albums->add_albums($albmp);
$all_albums_con = new content($all_albums, sh_mainpage_spacers());
$this->set_content($all_albums_con);
}
