public function getListAction()
{
$request = $_GET;
$token = isset($request['TOKEN']) ? trim($request['TOKEN']) : null;
$lastDate = isset($request['lastDate']) ? $request['lastDate'] : null;
if (!$token) {
return ['STATUS_CODE' => STATUS_CODE_BAD_REQUEST, 'DATA' => buckys_api_get_error_result('Api token should not be blank')];
}
if (!($userID = BuckysUsersToken::checkTokenValidity($token, "api"))) {
return ['STATUS_CODE' => STATUS_CODE_UNAUTHORIZED, 'DATA' => buckys_api_get_error_result('Api token is not valid.')];
}
$stream = BuckysPost::getUserPostsStream($userID, $lastDate);
//Format Result Data
$result = [];
foreach ($stream as $post) {
if ($post['pageID'] != BuckysPost::INDEPENDENT_POST_PAGE_ID) {
$pageIns = new BuckysPage();
$pageData = $pageIns->getPageByID($post['pageID']);
}
$pagePostFlag = false;
if (isset($pageData)) {
$pagePostFlag = true;
}
$item = [];
$item['articleId'] = $post['postID'];
$item['posterId'] = $post['poster'];
$item['articleImage'] = "";
$item['articleVideo'] = "";
$item['articleVideoId'] = "";
if ($pagePostFlag) {
$item['posterName'] = $pageData['title'];
$item['posterThumbnail'] = buckys_not_null($pageData['logo']) ? THENEWBOSTON_SITE_URL . DIR_WS_PHOTO . "users/" . $pageData['userID'] . "/resized/" . $pageData['logo'] : THENEWBOSTON_SITE_URL . DIR_WS_IMAGE . "newPagePlaceholder.jpg";
} else {
$item['posterName'] = $post['posterFullName'];
$item['posterThumbnail'] = THENEWBOSTON_SITE_URL . BuckysUser::getProfileIcon($post['poster']);
}
$item['postedDate'] = buckys_api_format_date($userID, $post['post_date']);
$item['purePostedDate'] = $post['post_date'];
$item['articleContent'] = $post['content'];
if ($post['type'] == 'video') {
$item['articleVideo'] = $post['youtube_url'];
$item['articleVideoId'] = buckys_get_youtube_video_id($post['youtube_url']);
} else {
if ($post['type'] == 'image') {
$item['articleImage'] = THENEWBOSTON_SITE_URL . DIR_WS_PHOTO . 'users/' . $post['poster'] . '/resized/' . $post['image'];
}
}
$item['articleLikes'] = $post['likes'];
$item['articleComments'] = $post['comments'];
$item['isLiked'] = !$post['likeID'] ? "no" : "yes";
$result[] = $item;
}
return ['STATUS_CODE' => STATUS_CODE_OK, 'DATA' => ["STATUS" => "SUCCESS", "RESULT" => $result]];
}
public function getListAction()
{
global $TNB_GLOBALS, $db;
$data = $_POST;
$keyword = isset($data['keyword']) ? $data['keyword'] : null;
$token = isset($data['TOKEN']) ? trim($data['TOKEN']) : null;
$sort = "pop";
$page = isset($data['page']) ? $data['page'] : null;
if (!$token) {
return ['STATUS_CODE' => STATUS_CODE_BAD_REQUEST, 'DATA' => buckys_api_get_error_result('Api token should not be blank')];
}
if (!($userID = BuckysUsersToken::checkTokenValidity($token, "api"))) {
return ['STATUS_CODE' => STATUS_CODE_UNAUTHORIZED, 'DATA' => buckys_api_get_error_result('Api token is not valid.')];
}
//Search Results
$searchIns = new BuckysSearch();
$pageIns = new BuckysPage();
$pageFollowerIns = new BuckysPageFollower();
$db_results = $searchIns->search($keyword, BuckysSearch::SEARCH_TYPE_USER_AND_PAGE, $sort, $page);
$results = [];
foreach ($db_results as $item) {
$row = [];
if ($item['type'] == "user") {
//User
$row['type'] = "user";
//Getting Detail Information
$query = $db->prepare("SELECT \n u.firstName, \n u.lastName, \n u.userID, \n u.thumbnail, \n u.current_city, \n u.current_city_visibility,\n f.friendID \n FROM \n " . TABLE_USERS . " AS u\n LEFT JOIN " . TABLE_FRIENDS . " AS f ON f.userID=%d AND f.userFriendID=u.userID AND f.status='1'\n WHERE u.userID=%d", $userID, $item['userID']);
$data = $db->getRow($query);
$row['id'] = $item['userID'];
$row['title'] = $data['firstName'] . " " . $data['lastName'];
$row['description'] = $data['current_city_visibility'] ? $data['current_city'] : "";
$row['isFriend'] = !$data['friendID'] ? 'no' : 'yes';
$row['image'] = THENEWBOSTON_SITE_URL . BuckysUser::getProfileIcon($data);
} else {
$row['type'] = "page";
//Page
$pageData = $pageIns->getPageByID($item['pageID']);
$followerCount = $pageFollowerIns->getNumberOfFollowers($item['pageID']);
$row['id'] = $item['pageID'];
$row['title'] = $pageData['title'];
$row['description'] = number_format($followerCount) . " follower" . ($followerCount > 1 ? "s" : "");
$row['isFollowed'] = BuckysPageFollower::isFollower($userID, $pageData['pageID']) ? 'yes' : 'no';
$row['image'] = THENEWBOSTON_SITE_URL . (!$pageData['logo'] ? DIR_WS_IMAGE . "newPagePlaceholder.jpg" : DIR_WS_PHOTO . "users/" . $pageData['userID'] . "/resized/" . $pageData['logo']);
}
$results[] = $row;
}
return ['STATUS_CODE' => STATUS_CODE_OK, 'DATA' => ["STATUS" => "SUCCESS", "RESULT" => $results]];
}
/**
* Check relations if it has already followed the page
*
* @param integer $pageID
* @param integer $userID
* @return bool
*/
public function hasRelationInFollow($pageID, $userID)
{
global $db;
$pageIns = new BuckysPage();
if (!is_numeric($pageID) || !is_numeric($userID)) {
return false;
}
// failed
$pageData = $pageIns->getPageByID($pageID);
if ($pageData['userID'] == $userID) {
//It means you are the owner of this page.
// return true;
}
$query = sprintf("SELECT * FROM %s WHERE pageID=%d AND userID=%d", TABLE_PAGE_FOLLOWERS, $pageID, $userID);
if ($db->getRow($query)) {
return true;
} else {
return false;
}
}
<?php
require dirname(__FILE__) . '/includes/bootstrap.php';
//Getting Current User ID
$userID = buckys_is_logged_in();
$pageIns = new BuckysPage();
$pageFollowerIns = new BuckysPageFollower();
$paramPageID = isset($_GET['pid']) ? intval($_GET['pid']) : null;
$pageData = $pageIns->getPageByID($paramPageID);
//If the parameter is null, goto homepage
if (!buckys_not_null($pageData)) {
buckys_redirect('/index.php');
}
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1;
$totalCount = $pageFollowerIns->getNumberOfFollowers($pageData['pageID']);
$pagination = new Pagination($totalCount, BuckysPageFollower::COUNT_PER_PAGE, $page);
$page = $pagination->getCurrentPage();
//Get Friends
$view['followers'] = $pageFollowerIns->getFollowers($pageData['pageID'], $page, BuckysPageFollower::COUNT_PER_PAGE);
$view['pageData'] = $pageData;
buckys_enqueue_stylesheet('profile.css');
buckys_enqueue_stylesheet('friends.css');
buckys_enqueue_stylesheet('account.css');
buckys_enqueue_stylesheet('stream.css');
buckys_enqueue_stylesheet('posting.css');
buckys_enqueue_stylesheet('uploadify.css');
buckys_enqueue_stylesheet('jquery.Jcrop.css');
buckys_enqueue_stylesheet('page.css');
buckys_enqueue_javascript('uploadify/jquery.uploadify.js');
buckys_enqueue_javascript('jquery.Jcrop.js');
buckys_enqueue_javascript('jquery.color.js');
</a>
<br/> <a href="/myfriends.php?type=pending" class="accountSubLinks">Pending</a> <br/>
<!-- <a href="/moderator.php" class="accountLinks">Vote</a> -->
<?php
?>
<h6>Page Manager</h6>
<!-- <a href="/follows.php?user=<?php
echo $userID;
?>
" class="accountLinks">Groups</a> -->
<a href="/page_add.php" class="accountSubLinks">Create New Page</a><br/>
<?php
//Get my created pages link
$pageIns = new BuckysPage();
$pageList = $pageIns->getPagesByUserId($userID);
if (count($pageList) > 0) {
foreach ($pageList as $pageD) {
echo sprintf('<a href="/page.php?pid=%d" class="accountSubLinks">%s</a><br/>', $pageD['pageID'], $pageD['title']);
}
}
?>
<!-- Control Panel-->
<?php
if (buckys_check_user_acl(USER_ACL_MODERATOR)) {
?>
<?php
$reportedItems = BuckysReport::getReportedObjectCount();
$pendingAds = BuckysAds::getPendingAdsCount();
/**
* Save Post
*
* @param $userID
* @param mixed $data
* @return bool|int|null|string
*/
public static function savePhoto($userID, $data)
{
global $db, $TNB_GLOBALS;
//Check the Photo File Name
if (!isset($data['file']) || strpos($data['file'], "../") !== false || !file_exists(DIR_FS_PHOTO_TMP . $data['file'])) {
buckys_add_message(MSG_FILE_UPLOAD_ERROR, MSG_TYPE_ERROR);
return false;
}
$data['pageID'] = isset($data['pageID']) && is_numeric($data['pageID']) ? $data['pageID'] : BuckysPost::INDEPENDENT_POST_PAGE_ID;
// Validate the file type
$fileParts = pathinfo($data['file']);
if (!in_array(strtolower($fileParts['extension']), $TNB_GLOBALS['imageTypes'])) {
buckys_add_message(MSG_INVALID_PHOTO_TYPE, MSG_TYPE_ERROR);
return false;
}
//Validate File Size
list($width, $height, $type, $attr) = getimagesize(DIR_FS_PHOTO_TMP . $data['file']);
if ($width * $height > MAX_IMAGE_WIDTH * MAX_IMAGE_HEIGHT) {
buckys_add_message(MSG_PHOTO_MAX_SIZE_ERROR, MSG_TYPE_ERROR);
return false;
}
//Checking File Size and move it from the tmp folder to the user photo folder and resize it.
if ($data['post_visibility'] == 2) {
//Calc Ratio using real image width
$ratio = floatval($width / $data['width']);
$sourceWidth = ($data['x2'] - $data['x1']) * $ratio;
BuckysPost::moveFileFromTmpToUserFolder($userID, $data['file'], PROFILE_IMAGE_WIDTH, PROFILE_IMAGE_HEIGHT, $data['x1'] * $ratio, $data['y1'] * $ratio, $sourceWidth, $sourceWidth);
if ($data['pageID'] == BuckysPost::INDEPENDENT_POST_PAGE_ID) {
//Update User Profile Field
BuckysUser::updateUserFields($userID, ['thumbnail' => $data['file']]);
$is_profile = 1;
} else {
//Update Page Profile field
$pageIns = new BuckysPage();
$pageIns->updateData($data['pageID'], ['logo' => $data['file']]);
$is_profile = 1;
}
} else {
if ($width > MAX_POST_IMAGE_WIDTH) {
$height = $height * (MAX_POST_IMAGE_WIDTH / $width);
$width = MAX_POST_IMAGE_WIDTH;
}
if ($height > MAX_POST_IMAGE_HEIGHT) {
$width = $width * (MAX_POST_IMAGE_HEIGHT / $height);
$height = MAX_POST_IMAGE_HEIGHT;
}
//Create normal image
BuckysPost::moveFileFromTmpToUserFolder($userID, $data['file'], $width, $height, 0, 0);
$is_profile = 0;
}
$now = date('Y-m-d H:i:s');
$newId = $db->insertFromArray(TABLE_POSTS, ['poster' => $userID, 'pageID' => $data['pageID'], 'profileID' => $data['profileID'], 'content' => $data['content'], 'type' => 'image', 'post_date' => $now, 'image' => $data['file'], 'visibility' => $data['post_visibility'] > 0 ? 1 : 0, 'is_profile' => $is_profile]);
if (!$newId) {
buckys_add_message($db->getLastError(), MSG_TYPE_ERROR);
return false;
}
//Assign Photo to Album
if (isset($data['album']) && $data['album'] != '') {
if (!BuckysAlbum::checkAlbumOwner($data['album'], $userID)) {
buckys_add_message(MSG_INVALID_ALBUM_ID, MSG_TYPE_ERROR);
} else {
BuckysAlbum::addPhotoToAlbum($data['album'], $newId);
}
}
buckys_add_message(MSG_PHOTO_UPLOADED_SUCCESSFULLY);
return $newId;
}
<?php
if (!isset($BUCKYS_GLOBALS)) {
die("Invalid Request!");
}
$userIns = new BuckysUser();
$pageIns = new BuckysPage();
$pageFollowerIns = new BuckysPageFollower();
$searcuResult = $view['search_result'];
?>
<script type="text/javascript">
</script>
<section id="main_section">
<?php
buckys_get_panel('top_search');
?>
<section id="main_content" class="search-result-panel">
<?php
render_result_messages();
?>
<div class="search-result-list">
<?php
if (count($searcuResult) > 0) {
function buckys_get_single_post_html($post, $userID, $isPostPage = false, $pageData = null)
{
ob_start();
if ($post['pageID'] != BuckysPost::INDEPENDENT_POST_PAGE_ID) {
$pageIns = new BuckysPage();
$pageData = $pageIns->getPageByID($post['pageID']);
}
$pagePostFlag = false;
if (isset($pageData)) {
$pagePostFlag = true;
}
?>
<div class="post-item" id=<?php
echo $post['postID'];
?>
>
<?php
if ($pagePostFlag) {
?>
<?php
render_pagethumb_link($pageData, 'postIcons');
?>
<?php
} else {
?>
<a href="/profile.php?user=<?php
echo $post['poster'];
?>
" class="poster-thumb"><img src="<?php
echo BuckysUser::getProfileIcon($post['poster']);
?>
" class="postIcons" /></a>
<?php
}
?>
<div class="post-content">
<?php
if ($pagePostFlag) {
?>
<div class="post-author"><a href="page.php?pid=<?php
echo $pageData['pageID'];
?>
"><b><?php
echo $pageData['title'];
?>
</b></a></div>
<?php
} else {
?>
<div class="post-author"><a href="profile.php?user=<?php
echo $post['poster'];
?>
"><b><?php
echo $post['posterFullName'];
?>
</b></a></div>
<?php
}
?>
<?php
echo buckys_process_post_content($post, $pageData);
?>
<div class="post-date">
<span class="lft">
<?php
if (buckys_not_null($userID) && $post['poster'] != $userID) {
?>
<a href='/manage_post.php?action=<?php
echo buckys_not_null($post['likeID']) ? 'unlikePost' : 'likePost';
?>
&postID=<?php
echo $post['postID'];
?>
' class="like-post-link"><?php
echo buckys_not_null($post['likeID']) ? 'Unlike' : 'Like';
?>
</a> ·
<?php
}
?>
<?php
if (buckys_not_null($userID) && $post['poster'] == $userID) {
?>
<a href='/manage_post.php?action=delete-post&userID=<?php
echo $userID;
?>
&postID=<?php
echo $post['postID'];
?>
' class="remove-post-link">Delete</a> ·
<?php
}
?>
<span><?php
echo buckys_format_date($post['post_date']);
?>
</span>
<?php
if (buckys_not_null($userID) && $post['poster'] != $userID && !$post['reportID']) {
?>
· <a href="/report_object.php" data-type="post" data-id="<?php
echo $post['postID'];
?>
" data-idHash="<?php
echo buckys_encrypt_id($post['postID']);
?>
" class="report-link">Report</a>
<?php
}
?>
</span>
<span class="rgt">
<?php
echo $post['visibility'] ? 'Public' : 'Private';
?>
</span>
<div class="clear"></div>
</div>
<div class="post-like-comment">
<?php
if ($pagePostFlag) {
?>
<a href="/page.php?pid=<?php
echo $pageData['pageID'];
?>
&post=<?php
echo $post['postID'];
?>
" class="usersThatLiked likes-link"><?php
echo $post['likes'] > 1 ? $post['likes'] . " likes" : $post['likes'] . " like";
?>
</a>
·
<a href="/page.php?pid=<?php
echo $pageData['pageID'];
?>
&post=<?php
echo $post['postID'];
?>
" class="usersThatLiked"><?php
echo $post['comments'] > 1 ? $post['comments'] . " comments" : $post['comments'] . " comment";
?>
</a>
<?php
} else {
?>
<a href="/posts.php?user=<?php
echo $post['poster'];
?>
&post=<?php
echo $post['postID'];
?>
" class="usersThatLiked likes-link"><?php
echo $post['likes'] > 1 ? $post['likes'] . " likes" : $post['likes'] . " like";
?>
</a>
·
<a href="/posts.php?user=<?php
echo $post['poster'];
?>
&post=<?php
echo $post['postID'];
?>
" class="usersThatLiked"><?php
echo $post['comments'] > 1 ? $post['comments'] . " comments" : $post['comments'] . " comment";
?>
</a>
<?php
}
?>
</div>
<?php
if ($post['likes'] > 0) {
$likedUsers = BuckysPost::getLikedUsers($post['postID']);
?>
<div class="liked-users">
<ul>
<?php
foreach ($likedUsers as $l) {
?>
<li><a href="/profile.php?user=<?php
echo $l['userID'];
?>
"><img src="<?php
echo BuckysUser::getProfileIcon($l);
?>
"> <span><?php
echo $l['firstName'] . " " . $l['lastName'];
?>
</span></a></li>
<?php
}
?>
<?php
if ($post['likes'] > 30) {
?>
<li class="more-likes">+ <?php
echo $post['likes'] - count($likedUsers);
?>
more</li>
<?php
}
?>
</ul>
</div>
<?php
}
?>
<?php
if (buckys_not_null($userID)) {
?>
<div class="post-new-comment">
<a href="/profile.php?user=<?php
echo $userID;
?>
"><img src="<?php
echo BuckysUser::getProfileIcon($userID);
?>
" class="replyToPostIcons" /></a>
<form method="post" class="postcommentform" name="postcommentform" action="">
<input type="text" class="input" name="comment" placeholder="Write a comment...">
<input type="hidden" name="postID" value="<?php
echo $post['postID'];
?>
" />
<input type="submit" value="Post Comment" id="submit_post_reply" class="redButton" />
<?php
render_loading_wrapper();
?>
</form>
</div>
<?php
}
?>
<?php
$comments = BuckysComment::getPostComments($post['postID']);
echo render_post_comments($comments, $userID);
if (count($comments) > 0 && BuckysComment::hasMoreComments($post['postID'], $comments[count($comments) - 1]['posted_date'])) {
?>
<a href="#" class="show-more-comments" data-last-date="<?php
echo $comments[count($comments) - 1]['posted_date'];
?>
" data-post-id="<?php
echo $post['postID'];
?>
">view more</a>
<?php
}
?>
</div>
<input type="hidden" class="post-created-date" value="<?php
echo $post['post_date'];
?>
" />
</div>
<?php
$html = ob_get_contents();
ob_end_clean();
return $html;
}
/**
* Unban Users
*
* @param mixed $ids
*/
public static function unbanUsers($ids)
{
global $db, $TNB_GLOBALS;
if (!is_array($ids)) {
$ids = [$ids];
}
//Check the user has lready been banned or not
$rows = $db->getResultsArray("SELECT * FROM " . TABLE_BANNED_USERS . " WHERE bannedID IN (" . implode(', ', $ids) . ")");
if ($rows) {
foreach ($rows as $brow) {
$userID = $brow['bannedUserID'];
//Change User Table
$db->query("UPDATE " . TABLE_USERS . " SET status=1 WHERE userID=" . $userID);
//Change Posts table
$db->query("UPDATE " . TABLE_POSTS . " SET post_status=1 WHERE poster=" . $userID);
//Change Activities
$db->query("UPDATE " . TABLE_MAIN_ACTIVITIES . " SET activityStatus=1 WHERE userID=" . $userID);
//Change Messages
$db->query("UPDATE " . TABLE_MESSAGES . " SET messageStatus=1 WHERE sender=" . $userID);
//Fix Comments Count
$query = $db->prepare("SELECT count(commentID) AS c, postID FROM " . TABLE_POSTS_COMMENTS . " WHERE commenter=%d AND commentStatus=0 GROUP BY postID", $userID);
$pcRows = $db->getResultsArray($query);
foreach ($pcRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `comments` = `comments` + " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Unblock Comments
$db->query("UPDATE " . TABLE_POSTS_COMMENTS . " SET commentStatus=1 WHERE commenter=" . $userID);
//Fix Likes Count
$query = $db->prepare("SELECT count(likeID) AS c, postID FROM " . TABLE_POSTS_LIKES . " WHERE userID=%d AND likeStatus=0 GROUP BY postID", $userID);
$plRows = $db->getResultsArray($query);
foreach ($plRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `likes` = `likes` + " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Unblock Likes
$db->query("UPDATE " . TABLE_POSTS_LIKES . " SET likeStatus=1 WHERE userID=" . $userID);
//Unblock Votes for Moderator
$query = $db->prepare("SELECT count(voteID) AS c, candidateID FROM " . TABLE_MODERATOR_VOTES . " WHERE voterID=%d AND voteStatus=0 GROUP BY candidateID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_MODERATOR_CANDIDATES . " SET `votes` = `votes` + " . $row['c'] . " WHERE candidateID=" . $row['candidateID']);
}
$db->query("UPDATE " . TABLE_MODERATOR_VOTES . " SET voteStatus=1 WHERE voterID=" . $userID);
//Unblock Replies
$query = $db->prepare("SELECT count(r.replyID), r.topicID, t.categoryID FROM " . TABLE_FORUM_REPLIES . " AS r LEFT JOIN " . TABLE_FORUM_TOPICS . " AS t ON t.topicID=r.topicID WHERE r.status='suspended' AND r.creatorID=%d GROUP BY r.topicID", $userID);
$rRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `status`='publish' WHERE creatorID=" . $userID . " AND `status`='suspended'");
foreach ($rRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `replies` = `replies` + " . $row['c'] . " WHERE topicID=" . $row['topicID']);
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` + " . $row['c'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumTopic::updateTopicLastReplyID($row['topicID']);
BuckysForumCategory::updateCategoryLastTopicID($row['categoryID']);
}
//unblock Topics
$query = $db->prepare("SELECT count(topicID) AS tc, SUM(replies) AS rc, categoryID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=%d AND `status`='suspended' GROUP BY categoryID", $userID);
$tRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `status`='publish' WHERE creatorID=" . $userID . " AND `status`='suspended'");
foreach ($tRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` + " . $row['rc'] . ", `topics` = `topics` + " . $row['tc'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumCategory::updateCategoryLastTopicID($row['categoryID']);
}
//Unblock Reply Votes
$query = $db->prepare("SELECT count(voteID) AS c, objectID FROM " . TABLE_FORUM_VOTES . " WHERE voterID=%d AND voteStatus=0 GROUP BY objectID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `votes` = `votes` + " . $row['c'] . " WHERE replyID=" . $row['objectID']);
}
$db->query("UPDATE " . TABLE_FORUM_VOTES . " SET voteStatus=1 WHERE voterID=" . $userID);
//Unblock page section & Trade section
$tradeItemIns = new BuckysTradeItem();
$tradeOfferIns = new BuckysTradeOffer();
$pageIns = new BuckysPage();
$tradeItemIns->massStatusChange($userID, BuckysTradeItem::STATUS_ITEM_ACTIVE);
$tradeOfferIns->massStatusChange($userID, BuckysTradeOffer::STATUS_OFFER_ACTIVE);
$pageIns->massStatusChange($userID, BuckysPage::STATUS_ACTIVE);
//enable Shop Products
$shopProdIns = new BuckysShopProduct();
$shopProdIns->massStatusChange($userID, BuckysShopProduct::STATUS_ACTIVE);
//Remove From banned users table
$db->query("DELETE FROM " . TABLE_BANNED_USERS . " WHERE bannedID=" . $brow['bannedID']);
}
}
}
/**
* Remove Account
*
*/
public function deleteUserAccount($userID)
{
global $db;
$userID = intval($userID);
//Fix Comments Count
$query = $db->prepare("SELECT count(commentID) as c, postID FROM " . TABLE_POSTS_COMMENTS . " WHERE commenter=%d AND commentStatus=1 GROUP BY postID", $userID);
$pcRows = $db->getResultsArray($query);
foreach ($pcRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `comments` = `comments` - " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Fix Likes Count
$query = $db->prepare("SELECT count(likeID) as c, postID FROM " . TABLE_POSTS_LIKES . " WHERE userID=%d AND likeStatus=1 GROUP BY postID", $userID);
$plRows = $db->getResultsArray($query);
foreach ($plRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `likes` = `likes` - " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Block Votes for Moderator
$query = $db->prepare("SELECT count(voteID) as c, candidateID FROM " . TABLE_MODERATOR_VOTES . " WHERE voterID=%d AND voteStatus=1 GROUP BY candidateID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_MODERATOR_CANDIDATES . " SET `votes` = `votes` - " . $row['c'] . " WHERE candidateID=" . $row['candidateID']);
}
//Block Replies
$query = $db->prepare("SELECT count(r.replyID), r.topicID, t.categoryID FROM " . TABLE_FORUM_REPLIES . " AS r LEFT JOIN " . TABLE_FORUM_TOPICS . " AS t ON t.topicID=r.topicID WHERE r.status='publish' AND r.creatorID=%d GROUP BY r.topicID", $userID);
$rRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `status`='suspended' WHERE creatorID=" . $userID . " AND `status`='publish'");
foreach ($rRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `replies` = `replies` - " . $row['c'] . " WHERE topicID=" . $row['topicID']);
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` - " . $row['c'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumTopic::updateTopicLastReplyID($row['topicID']);
}
//Block Topics
$query = $db->prepare("SELECT count(topicID) as tc, SUM(replies) as rc, categoryID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=%d AND `status`='publish' GROUP BY categoryID", $userID);
$tRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `status`='suspended' WHERE creatorID=" . $userID . " AND `status`='publish'");
foreach ($tRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` - " . $row['rc'] . ", `topics` = `topics` - " . $row['tc'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumCategory::updateCategoryLastTopicID($row['categoryID']);
}
//Block Reply Votes
$query = $db->prepare("SELECT count(voteID) as c, objectID FROM " . TABLE_FORUM_VOTES . " WHERE voterID=%d AND voteStatus=1 GROUP BY objectID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `votes` = `votes` - " . $row['c'] . " WHERE replyID=" . $row['objectID']);
}
//Delete Reported Objects
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT postID FROM " . TABLE_POSTS . " WHERE poster=" . $userID . ")");
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT topicID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID . ")");
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT replyID FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . ")");
//Delete From banned Users
$db->query("DELETE FROM " . TABLE_BANNED_USERS . " WHERE bannedUserID=" . $userID);
//Delete Activities
$db->query("DELETE FROM " . TABLE_ACTIVITES . " WHERE userID=" . $userID);
//Delete Album Photos
$db->query("DELETE FROM " . TABLE_ALBUMS_PHOTOS . " WHERE album_id IN (SELECT albumID FROM " . TABLE_ALBUMS . " WHERE owner=" . $userID . ")");
//Delete ALbums
$db->query("DELETE FROM " . TABLE_ALBUMS . " WHERE owner=" . $userID);
//Delete Friends
$db->query("DELETE FROM " . TABLE_FRIENDS . " WHERE userID=" . $userID . " OR userFriendID=" . $userID);
//Delete Messages
$db->query("DELETE FROM " . TABLE_MESSAGES . " WHERE userID=" . $userID . " OR sender=" . $userID);
//Delete Private Messengers
$db->query("DELETE FROM " . TABLE_MESSENGER_BLOCKLIST . " WHERE userID=" . $userID . " OR blockedID=" . $userID);
$db->query("DELETE FROM " . TABLE_MESSENGER_BUDDYLIST . " WHERE userID=" . $userID . " OR buddyID=" . $userID);
$db->query("DELETE FROM " . TABLE_MESSENGER_MESSAGES . " WHERE userID=" . $userID . " OR buddyID=" . $userID);
//Delete Posts
$posts = $db->getResultsArray("SELECT * FROM " . TABLE_POSTS . " WHERE poster=" . $userID);
foreach ($posts as $post) {
//Delete Comments
$db->query("DELETE FROM " . TABLE_POSTS_COMMENTS . " WHERE postID=" . $post['postID']);
//Delete Likes
$db->query("DELETE FROM " . TABLE_POSTS_LIKES . " WHERE postID=" . $post['postID']);
//Delete hits
$db->query("DELETE FROM " . TABLE_POSTS_HITS . " WHERE postID=" . $post['postID']);
}
$db->query("DELETE FROM " . TABLE_POSTS . " WHERE poster=" . $userID);
//Delete Pages
$pageIns = new BuckysPage();
$pageIns->deletePageByUserID($userID);
//Delete Trade Section which are related to this user.
$tradeIns = new BuckysTradeItem();
$tradeIns->deleteItemsByUserID($userID);
//Delete Comments
$db->query("DELETE FROM " . TABLE_POSTS_COMMENTS . " WHERE commenter=" . $userID);
//Delete Likes
$db->query("DELETE FROM " . TABLE_POSTS_LIKES . " WHERE userID=" . $userID);
//Getting Removed Topics
$topicIDs = $db->getResultsArray("SELECT topicID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID);
if (!$topicIDs) {
$topicIDs = array(0);
}
//Delete Reply Votes
$db->query("DELETE FROM " . TABLE_FORUM_VOTES . " WHERE voterID=" . $userID);
$db->query("DELETE FROM " . TABLE_FORUM_VOTES . " WHERE objectID IN ( SELECT replyID FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . " OR topicID IN (" . implode(", ", $topicIDs) . ") )");
//Delete Replies
$db->query("DELETE FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . " OR topicID IN (" . implode(", ", $topicIDs) . ")");
//Delete Topics
$db->query("DELETE FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID);
//Delete Users
/*$db->query("DELETE FROM " . TABLE_USERS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_CONTACT . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_EDUCATIONS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_EMPLOYMENTS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_LINKS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_TOKEN . " WHERE userID=" . $userID);*/
//Don't delete user from the database, just update the user's status
$db->query("UPDATE " . TABLE_USERS . " SET `status`=" . BuckysUser::STATUS_USER_DELETED . " WHERE userID=" . $userID);
}
<?php
require dirname(__FILE__) . '/includes/bootstrap.php';
$userID = buckys_is_logged_in();
//Read Parameters (common)
$paramAction = 'view';
if (isset($_REQUEST['action'])) {
$paramAction = get_secure_string($_REQUEST['action']);
}
$pageIns = new BuckysPage();
$pageFollowerIns = new BuckysPageFollower();
//Capture Ajax requests (such as save title, ... here)
if (is_numeric($userID)) {
switch ($paramAction) {
//============ Update About Content By Ajax =================//
case 'updateAbout':
$paramPageID = get_secure_integer($_REQUEST['pageID']);
$paramContent = get_secure_string($_REQUEST['content']);
$pageData = $pageIns->getPageByID($paramPageID);
if ($pageData && $pageData['userID'] == $userID) {
$data['about'] = $paramContent;
$pageIns->updateData($paramPageID, $data);
echo json_encode(['success' => 1, 'msg' => MSG_CONTENT_UPDATED_SUCCESS, 'content' => $paramContent, 'content_display' => render_enter_to_br($paramContent)]);
} else {
if (empty($pageData)) {
//No such page exists
echo json_encode(['success' => 0, 'msg' => MSG_NO_SUCH_PAGE]);
} else {
//You don't have permission to update content
echo json_encode(['success' => 0, 'msg' => MSG_NO_PERMISSION_TO_EDIT_PAGE]);
}
/**
* @param $row
* @param $userID
* @return string
*/
public static function getActivityHTML($row, $userID)
{
ob_start();
$user = BuckysUser::getUserBasicInfo($row['userID']);
$owner = BuckysUser::getUserBasicInfo($row['poster']);
$pagePostFlag = false;
if ($row['pageID'] != BuckysPost::INDEPENDENT_POST_PAGE_ID) {
$pageIns = new BuckysPage();
$pageData = $pageIns->getPageByID($row['pageID']);
}
if (isset($pageData)) {
$pagePostFlag = true;
}
if ($pagePostFlag) {
$objectLink = "/page.php?pid=" . $row['pageID'] . "&post=" . $row['objectID'];
$authorLink = '/page.php?pid=' . $row['pageID'];
} else {
$objectLink = "/posts.php?user="******"&post=" . $row['objectID'];
$authorLink = '/profile.php?user='******'poster'];
}
if ($row['activityType'] == 'like') {
?>
<div class="activityComment">
<?php
render_profile_link($user, 'replyToPostIcons');
?>
<span>
<a href="/profile.php?user=<?php
echo $row['userID'];
?>
"
class="userName"><?php
echo $user['firstName'] . " " . $user['lastName'];
?>
</a>
liked <?php
echo $row['poster'] == $userID ? 'your' : "<a href='/profile.php?user="******"' class=\"userName\">" . $owner['firstName'] . " " . $owner['lastName'] . "'s</a>";
?>
<?php
switch ($row['type']) {
case "image":
echo "<a href='" . $objectLink . "'>photo</a>";
break;
case "video":
echo "<a href='" . $objectLink . "'>video</a>";
break;
case "text":
default:
echo "<a href='" . $objectLink . "'>post</a> ";
if (strlen(buckys_trunc_content($row['content'], 60)) > 0) {
echo '“' . buckys_trunc_content($row['content'], 60) . '”';
}
break;
}
?>
</span>
</div>
<?php
} else {
if ($row['activityType'] == 'comment') {
?>
<div class="activityComment">
<?php
render_profile_link($user, 'replyToPostIcons');
?>
<span>
<a href="/profile.php?user=<?php
echo $row['userID'];
?>
"
class="userName"><?php
echo $user['firstName'] . " " . $user['lastName'];
?>
</a>
left a comment on
<?php
if ($row['poster'] == $userID) {
echo 'your';
} else {
if ($row['poster'] == $row['userID']) {
//Getting User Data
$tUinfo = BuckysUser::getUserBasicInfo($row['userID']);
switch (strtolower($tUinfo['gender'])) {
case 'male':
echo 'his';
break;
case 'female':
echo 'her';
break;
break;
echo 'their';
break;
}
} else {
echo "<a href='/profile.php?user="******"' class=\"userName\">" . $owner['firstName'] . " " . $owner['lastName'] . "'s</a>";
}
}
?>
<?php
switch ($row['type']) {
case "image":
echo "<a href='" . $objectLink . "'>photo</a>";
break;
case "video":
echo "<a href='" . $objectLink . "'>video</a>";
break;
case "text":
default:
echo "<a href='" . $objectLink . "'>post</a> ";
break;
}
if (strlen(buckys_trunc_content($row['comment_content'], 25)) > 0) {
echo ': “' . buckys_trunc_content($row['comment_content'], 25) . '”';
}
?>
</span>
</div>
<?php
}
}
$html = ob_get_contents();
ob_end_clean();
return $html;
}
<?php
require dirname(__FILE__) . '/includes/bootstrap.php';
$userID = buckys_is_logged_in();
$popularImages = BuckysPost::getPostsFromStats('image');
$popularPosts = BuckysPost::getPostsFromStats('text');
$popularVideos = BuckysPost::getPostsFromStats('video');
$popularPages = BuckysPage::getPopularPagesForHomepage();
$recentTopics = BuckysForumTopic::getTopics(1, 'publish', null, 'lastReplyDate DESC, t.createdDate DESC', 5);
$recentTradeItems = BuckysTradeItem::getRecentItems(3);
buckys_enqueue_stylesheet('index.css');
$BUCKYS_GLOBALS['content'] = "home";
$BUCKYS_GLOBALS['title'] = "BuckysRoom - The Worlds Most Popular Open Source Social Network";
require DIR_FS_TEMPLATE . $BUCKYS_GLOBALS['template'] . "/" . $BUCKYS_GLOBALS['layout'] . ".php";
}
if (!$_POST['pageName']) {
buckys_redirect("/page_add.php", MSG_PAGE_NAME_EMPTY, MSG_TYPE_ERROR);
}
if (!$_POST['file']) {
buckys_redirect("/page_add.php", MSG_PAGE_LOGO_EMPTY, MSG_TYPE_ERROR);
}
if (!isset($_POST['file']) || strpos($_POST['file'], "../") !== false || !file_exists(DIR_FS_PHOTO_TMP . $_POST['file'])) {
buckys_redirect("/page_add.php", MSG_FILE_UPLOAD_ERROR, MSG_TYPE_ERROR);
}
$fileParts = pathinfo($_POST['file']);
if (!in_array(strtolower($fileParts['extension']), $TNB_GLOBALS['imageTypes'])) {
buckys_redirect("/page_add.php", MSG_INVALID_PHOTO_TYPE, MSG_TYPE_ERROR);
return false;
}
$pageClass = new BuckysPage();
if ($pageID = $pageClass->addPage($userID, $_POST)) {
buckys_add_message(MSG_PAGE_CREATED_SUCCESSFULLY, MSG_TYPE_SUCCESS);
buckys_redirect("/page.php?pid=" . $pageID);
} else {
buckys_redirect("/page_add.php");
}
}
buckys_enqueue_stylesheet('account.css');
buckys_enqueue_stylesheet('uploadify.css');
buckys_enqueue_stylesheet('jquery.Jcrop.css');
buckys_enqueue_stylesheet('posting.css');
buckys_enqueue_stylesheet('page.css');
buckys_enqueue_javascript('uploadify/jquery.uploadify.js');
buckys_enqueue_javascript('jquery.Jcrop.js');
buckys_enqueue_javascript('jquery.color.js');
/**
* Remove Account
*/
public static function deleteUserAccount($userID)
{
global $db;
$userID = intval($userID);
//Fix Comments Count
$query = $db->prepare("SELECT count(commentID) AS c, postID FROM " . TABLE_POSTS_COMMENTS . " WHERE commenter=%d AND commentStatus=1 GROUP BY postID", $userID);
$pcRows = $db->getResultsArray($query);
foreach ($pcRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `comments` = `comments` - " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Fix Likes Count
$query = $db->prepare("SELECT count(likeID) AS c, postID FROM " . TABLE_POSTS_LIKES . " WHERE userID=%d AND likeStatus=1 GROUP BY postID", $userID);
$plRows = $db->getResultsArray($query);
foreach ($plRows as $row) {
$db->query("UPDATE " . TABLE_POSTS . " SET `likes` = `likes` - " . $row['c'] . " WHERE postID=" . $row['postID']);
}
//Block Votes for Moderator
$query = $db->prepare("SELECT count(voteID) AS c, candidateID FROM " . TABLE_MODERATOR_VOTES . " WHERE voterID=%d AND voteStatus=1 GROUP BY candidateID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_MODERATOR_CANDIDATES . " SET `votes` = `votes` - " . $row['c'] . " WHERE candidateID=" . $row['candidateID']);
}
//Block Replies
$query = $db->prepare("SELECT count(r.replyID), r.topicID, t.categoryID FROM " . TABLE_FORUM_REPLIES . " AS r LEFT JOIN " . TABLE_FORUM_TOPICS . " AS t ON t.topicID=r.topicID WHERE r.status='publish' AND r.creatorID=%d GROUP BY r.topicID", $userID);
$rRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `status`='suspended' WHERE creatorID=" . $userID . " AND `status`='publish'");
foreach ($rRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `replies` = `replies` - " . $row['c'] . " WHERE topicID=" . $row['topicID']);
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` - " . $row['c'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumTopic::updateTopicLastReplyID($row['topicID']);
}
//Block Topics
$query = $db->prepare("SELECT count(topicID) AS tc, SUM(replies) AS rc, categoryID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=%d AND `status`='publish' GROUP BY categoryID", $userID);
$tRows = $db->getResultsArray($query);
$db->query("UPDATE " . TABLE_FORUM_TOPICS . " SET `status`='suspended' WHERE creatorID=" . $userID . " AND `status`='publish'");
foreach ($tRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_CATEGORIES . " SET `replies` = `replies` - " . $row['rc'] . ", `topics` = `topics` - " . $row['tc'] . " WHERE categoryID=" . $row['categoryID']);
BuckysForumCategory::updateCategoryLastTopicID($row['categoryID']);
}
//Block Reply Votes
$query = $db->prepare("SELECT count(voteID) AS c, objectID FROM " . TABLE_FORUM_VOTES . " WHERE voterID=%d AND voteStatus=1 GROUP BY objectID", $userID);
$vRows = $db->getResultsArray($query);
foreach ($vRows as $row) {
$db->query("UPDATE " . TABLE_FORUM_REPLIES . " SET `votes` = `votes` - " . $row['c'] . " WHERE replyID=" . $row['objectID']);
}
//Delete Reported Objects
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT postID FROM " . TABLE_POSTS . " WHERE poster=" . $userID . ")");
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT topicID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID . ")");
$db->query("DELETE FROM " . TABLE_REPORTS . " WHERE objectID IN (SELECT replyID FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . ")");
//Delete From banned Users
$db->query("DELETE FROM " . TABLE_BANNED_USERS . " WHERE bannedUserID=" . $userID);
//Delete Activities
$db->query("DELETE FROM " . TABLE_MAIN_ACTIVITIES . " WHERE userID=" . $userID);
//Delete Album Photos
$db->query("DELETE FROM " . TABLE_ALBUMS_PHOTOS . " WHERE album_id IN (SELECT albumID FROM " . TABLE_ALBUMS . " WHERE OWNER=" . $userID . ")");
//Delete ALbums
$db->query("DELETE FROM " . TABLE_ALBUMS . " WHERE OWNER=" . $userID);
//Delete Friends
$db->query("DELETE FROM " . TABLE_FRIENDS . " WHERE userID=" . $userID . " OR userFriendID=" . $userID);
//Delete Messages
$db->query("DELETE FROM " . TABLE_MESSAGES . " WHERE userID=" . $userID . " OR sender=" . $userID);
//Delete Private Messengers
$db->query("DELETE FROM " . TABLE_MESSENGER_BLOCKLIST . " WHERE userID=" . $userID . " OR blockedID=" . $userID);
$db->query("DELETE FROM " . TABLE_MESSENGER_BUDDYLIST . " WHERE userID=" . $userID . " OR buddyID=" . $userID);
$db->query("DELETE FROM " . TABLE_MESSENGER_MESSAGES . " WHERE userID=" . $userID . " OR buddyID=" . $userID);
//Delete Posts
$posts = $db->getResultsArray("SELECT * FROM " . TABLE_POSTS . " WHERE poster=" . $userID);
foreach ($posts as $post) {
//Delete Comments
$db->query("DELETE FROM " . TABLE_POSTS_COMMENTS . " WHERE postID=" . $post['postID']);
//Delete Likes
$db->query("DELETE FROM " . TABLE_POSTS_LIKES . " WHERE postID=" . $post['postID']);
//Delete hits
$db->query("DELETE FROM " . TABLE_POSTS_HITS . " WHERE postID=" . $post['postID']);
}
$db->query("DELETE FROM " . TABLE_POSTS . " WHERE poster=" . $userID);
//Delete Pages
$pageIns = new BuckysPage();
$pageIns->deletePageByUserID($userID);
//Delete Trade Section which are related to this user.
$tradeIns = new BuckysTradeItem();
$tradeIns->deleteItemsByUserID($userID);
//Delete Shop Section which are related to this user
$shopIns = new BuckysShopProduct();
$shopIns->deleteProductsByUserID($userID);
//Delete Comments
$db->query("DELETE FROM " . TABLE_POSTS_COMMENTS . " WHERE commenter=" . $userID);
//Delete Likes
$db->query("DELETE FROM " . TABLE_POSTS_LIKES . " WHERE userID=" . $userID);
//Delete Page Followers
$db->query("DELETE FROM " . TABLE_PAGE_FOLLOWERS . " WHERE userID=" . $userID);
//Getting Removed Topics
$topicIDs = $db->getResultsArray("SELECT topicID FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID);
if (!$topicIDs) {
$topicIDs = [0];
}
//Delete Reply Votes
$db->query("DELETE FROM " . TABLE_FORUM_VOTES . " WHERE voterID=" . $userID);
$db->query("DELETE FROM " . TABLE_FORUM_VOTES . " WHERE objectID IN ( SELECT replyID FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . " OR topicID IN (" . implode(", ", $topicIDs) . ") )");
//Delete Replies
$db->query("DELETE FROM " . TABLE_FORUM_REPLIES . " WHERE creatorID=" . $userID . " OR topicID IN (" . implode(", ", $topicIDs) . ")");
//Delete Topics
$db->query("DELETE FROM " . TABLE_FORUM_TOPICS . " WHERE creatorID=" . $userID);
//Delete Users
/*$db->query("DELETE FROM " . TABLE_USERS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_CONTACT . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_EDUCATIONS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_EMPLOYMENTS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_LINKS . " WHERE userID=" . $userID);
$db->query("DELETE FROM " . TABLE_USERS_TOKEN . " WHERE userID=" . $userID);*/
//Don't delete user from the database, just update the user's status
$db->query("UPDATE " . TABLE_USERS . " SET `status`=" . BuckysUser::STATUS_USER_DELETED . " WHERE userID=" . $userID);
//Send
$bitCoinInfo = BuckysUser::getUserBitcoinInfo($userID);
if ($bitCoinInfo) {
$userInfo = BuckysUser::getUserBasicInfo($userID);
$content = "Your " . TNB_SITE_NAME . " account has been deleted. However, you may still access your Bitcoin wallet at:\n" . "https://blockchain.info/wallet/login\n" . "Identifier: " . $bitCoinInfo['bitcoin_guid'] . "\n" . "Password: "******"\n";
//Send Email to User
buckys_sendmail($userInfo['email'], $userInfo['firstName'] . ' ' . $userInfo['lastName'], TNB_SITE_NAME . ' Account has been Deleted', $content);
}
}
