/** * Delete page by PageID * * @param integer $userID * @param integer $pageID */ public function deletePageByID($pageID, $userID = null) { global $db; $postIns = new BuckysPost(); $pageFollowerIns = new BuckysPageFollower(); //Get Page info & related posts belonged to this page. $pageData = $this->getPageByID($pageID); if (!$pageData) { return false; } if (!empty($userID) && $pageData['userID'] != $userID) { return false; // You don't have permission to delete this page } $postList = $postIns->getPostsByPageID($pageData['pageID']); //Delete related posts if (is_array($postList) && count($postList) > 0) { foreach ($postList as $postData) { $postIns->deletePost($pageData['userID'], $postData['postID']); } } //Delete page $query = sprintf("DELETE FROM %s WHERE pageID=%d", TABLE_PAGES, $pageID); $db->query($query); //Delete followers $pageFollowerIns->removeAllFollowersByPageID($pageID); return true; }