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); }