user_exists && !$setting['setting_permission_album'] ) { $page = "error"; $smarty->assign('error_header', 639); $smarty->assign('error_message', 656); $smarty->assign('error_submit', 641); include "footer.php"; } // PARSE GET/POST if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; } if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "album_datecreated DESC"; } if(isset($_POST['v'])) { $v = $_POST['v']; } elseif(isset($_GET['v'])) { $v = $_GET['v']; } else { $v = 0; } // ENSURE SORT/VIEW ARE VALID if($s != "album_datecreated DESC" && $s != "album_dateupdated DESC") { $s = "album_dateupdated DESC"; } if($v != "0" && $v != "1"&& $v != "2"&& $v != "3"&& $v != "4"&& $v != "5") { $v = 0; } if($v==0||$v==1){ // SET WHERE CLAUSE $where = "CASE WHEN se_albums.album_user_id='{$user->user_info[user_id]}' THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_albums.album_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE"./* WHEN ((se_albums.album_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_albums.album_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_albums.album_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1)) THEN TRUE ELSE FALSE END"; // CREATE ALBUM OBJECT $album = new se_album(); $album_privacy_max = $owner->user_privacy_max($user); $where = "(album_privacy & $album_privacy_max)"; // ONLY MY FRIENDS' ALBUMS if($v == "1" && $user->user_exists) { // SET WHERE CLAUSE $where .= " AND (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$user->user_info['user_id']}' AND friend_user_id2=se_albums.album_user_id AND friend_status=1)"; } $where.=" AND se_albums.album_user_id='{$owner->user_info[user_id]}'"; $signup_array = $album->randomalbums($where); // GET TOTAL ALBUMS $total_albums = $album->album_total($where); // MAKE ENTRY PAGES $albums_per_page = 21; $page_vars = make_page($total_albums, $albums_per_page, $p); // GET ALBUM ARRAY $album_array = $album->album_list($page_vars[0], $albums_per_page, $s, $where); } elseif($v==3||$v==4) { $where = "CASE WHEN se_albums.album_user_id='{$user->user_info[user_id]}' THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_albums.album_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE"./* WHEN ((se_albums.album_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_albums.album_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((se_albums.album_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_albums.album_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1)) THEN TRUE ELSE FALSE END"; if($v == "4" && $user->user_exists) { // SET WHERE CLAUSE $where .= " AND (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$user->user_info['user_id']}' AND friend_user_id2=se_albums.album_user_id AND friend_status=1)"; } $album = new se_album(); $signup_array = $album->randomphotos($where); // GET TOTAL FILES IN ALBUM $total_albums = $album->list_files_count($where); //echo $total_albums ; $media_per_page = 21; $sortby = "media_order ASC"; // MAKE MEDIA PAGES $page_vars = make_page($total_albums, $media_per_page, $p); $album_array = $album->list_files($page_vars[0], $media_per_page, $sortby, $where, $select); $photospart=1; $smarty->assign_by_ref('photospart', $photospart); } elseif($v==4) { $album = new se_album(); // GET TOTAL FILES IN ALBUM $total_albums = $album->list_files_count(); //echo $total_albums ; $media_per_page = 21; $sortby = "media_order ASC"; // MAKE MEDIA PAGES $page_vars = make_page($total_albums, $media_per_page, $p); $album_array = $album->list_files($page_vars[0], $media_per_page, $sortby, $where, $select); $photospart=1; $smarty->assign_by_ref('photospart', $photospart); } $y=0; for($x=$page_vars[1]; $x<=$page_vars[2]; $x++) { if(($page_vars[1]+10)==$x) {break;} $for[$y]=$x; $y++; } //$signup_array = recent_signups(); $smarty->assign_by_ref('signups', $signup_array); $smarty->assign('for', $for); // ASSIGN SMARTY VARIABLES AND DISPLAY ALBUMS PAGE $smarty->assign('albums', $album_array); $smarty->assign('total_albums', $total_albums); $smarty->assign('p', $page_vars[1]); $smarty->assign('maxpage', $page_vars[2]); $smarty->assign('p_start', $page_vars[0]+1); $smarty->assign('p_end', $page_vars[0]+count($album_array)); $smarty->assign('s', $s); $smarty->assign('v', $v); include "footer.php"; ?>