require dirname(__FILE__) . '/includes/bootstrap.php'; //Getting Current User ID if (!($userID = buckys_is_logged_in())) { buckys_redirect('/index.php', MSG_NOT_LOGGED_IN_USER, MSG_TYPE_ERROR); } $albumID = isset($_REQUEST['albumID']) ? $_REQUEST['albumID'] : ''; if (!$albumID || !BuckysAlbum::checkAlbumOwner($albumID, $userID)) { buckys_redirect("/photo_albums.php", MSG_INVALID_REQUEST, MSG_TYPE_ERROR); } //Getting UserData from Id $userData = BuckysUser::getUserData($profileID); //Getting Album $album = BuckysAlbum::getAlbum($albumID); //Getting Photos $myphotos = BuckysPost::getPhotosByUserID($userID, $userID, BuckysPost::INDEPENDENT_POST_PAGE_ID, true); $albumPhotos = BuckysAlbum::getPhotos($albumID); //Getting Album Photos if (isset($_POST['action'])) { //Create New Album if ($_POST['action'] == 'save-album') { //If the album title is empty, throw error //If the album title is empty, throw error if (trim($_POST['album_name']) == '') { buckys_redirect('/photo_album_edit.php?albumID=' . $_POST['albumID'], MSG_ALBUM_TITLE_EMPTY, MSG_TYPE_ERROR); } BuckysAlbum::updateAlbum($_POST['albumID'], trim($_POST['album_name']), $_POST['visibility'], $_POST['photos']); buckys_redirect("/photo_album_edit.php?albumID=" . $_POST['albumID'], MSG_ALBUM_UPDATED); } else { if ($_POST['action'] == 'remove-from-album' || $_POST['action'] == 'add-to-album') { $photoID = $_POST['photoID']; $photo = BuckysPost::getPostById($photoID);
/** * Get photos * * @param int $userID * @param int $loggedUserID * @param int $pageID * @param boolean $canViewPrivate * @param int $postID * @param int $albumID * @param int $limit * @param string $lastDate * @return Indexed */ public static function getPhotosByUserID($userID, $loggedUserID = null, $pageID = BuckysPost::INDEPENDENT_POST_PAGE_ID, $canViewPrivate = false, $postID = null, $albumID = null, $limit = null, $lastDate = null) { global $db; $userID = intval($userID); //Getting Page Parameter if (isset($_GET['page']) && buckys_not_null($_GET['page'])) { $page = intval($_GET['page']); } else { $page = 1; } //Page Limit Query if ($limit) { $limit_query = ' LIMIT ' . ($page - 1) * $limit . ", " . $limit; } if (buckys_not_null($loggedUserID) && $canViewPrivate) { //Get All posts that were posted by $userID $query = 'SELECT p.*, CONCAT(u.firstName, " ", u.lastName) AS posterFullName, pl.likeID, pa.album_id FROM ' . TABLE_POSTS . ' AS p LEFT JOIN ' . TABLE_USERS . ' AS u ON p.poster = u.userID LEFT JOIN ' . TABLE_ALBUMS_PHOTOS . ' AS pa ON pa.post_id = p.postID LEFT JOIN ' . TABLE_POSTS_LIKES . ' AS pl ON pl.postID = p.postID AND pl.userID = ' . $userID . ' WHERE p.poster= ' . $userID . ' AND p.pageID=' . $pageID; } else { //Get Only Public Posts $query = 'SELECT p.*, CONCAT(u.firstName, " ", u.lastName) AS posterFullName, pl.likeID, pa.album_id FROM ' . TABLE_POSTS . ' AS p LEFT JOIN ' . TABLE_USERS . ' AS u ON p.poster = u.userID LEFT JOIN ' . TABLE_ALBUMS_PHOTOS . ' AS pa ON pa.post_id = p.postID LEFT JOIN ' . TABLE_POSTS_LIKES . ' AS pl ON pl.postID = p.postID AND pl.userID = ' . $userID . ' WHERE p.poster= ' . $userID . ' AND p.visibility=1 ' . ' AND p.pageID=' . $pageID; } $query .= ' AND p.type="image" '; //If postID is set, get only one post if ($postID != null) { $query .= $db->prepare(' AND p.postID=%d', $postID); } //AlbumID Query if ($albumID != null) { $aPhotos = BuckysAlbum::getPhotos($albumID); $apIds = [0]; foreach ($aPhotos as $a) { $apIds[] = $a['postID']; } $query .= ' AND p.postID in (' . implode(', ', $apIds) . ')'; } if ($lastDate != null) { $lastDate = date('Y-m-d H:i:s', strtotime($lastDate)); $query .= ' AND p.post_date < "' . $lastDate . '"'; } $query .= ' ORDER BY p.post_date DESC ' . $limit_query; $rows = $db->getResultsArray($query); return $rows; }