public function remove($giftId)
{
$result = array("error" => true, "error_code" => ERROR_UNKNOWN);
$giftInfo = $this->info($giftId);
if ($giftInfo['error'] === true) {
return $result;
}
if ($giftInfo['giftTo'] != $this->requestFrom) {
return $result;
}
$currentTime = time();
$stmt = $this->db->prepare("UPDATE gifts SET removeAt = (:removeAt) WHERE id = (:giftId)");
$stmt->bindParam(":giftId", $giftId, PDO::PARAM_INT);
$stmt->bindParam(":removeAt", $currentTime, PDO::PARAM_INT);
if ($stmt->execute()) {
$result = array("error" => false, "error_code" => ERROR_SUCCESS);
$account = new account($this->db, $giftInfo['giftTo']);
$account->updateCounters();
unset($account);
$notify = new notify($this->db);
$notify->removeNotify($giftInfo['giftTo'], $giftInfo['giftFrom'], NOTIFY_TYPE_GIFT, $giftInfo['id']);
unset($notify);
}
return $result;
}
public function remove($friendId)
{
$result = array("error" => true, "error_code" => ERROR_UNKNOWN);
$my_profile = new profile($this->db, $this->profileId);
if ($my_profile->is_friend_exists($friendId)) {
$currentTime = time();
$stmt = $this->db->prepare("UPDATE friends SET removeAt = (:removeAt) WHERE friendTo = (:friendTo) AND friend = (:friend) AND removeAt = 0");
$stmt->bindParam(":friendTo", $this->profileId, PDO::PARAM_INT);
$stmt->bindParam(":friend", $friendId, PDO::PARAM_INT);
$stmt->bindParam(":removeAt", $currentTime, PDO::PARAM_INT);
if ($stmt->execute()) {
$result = array("error" => false, "error_code" => ERROR_SUCCESS);
$stmt2 = $this->db->prepare("UPDATE friends SET removeAt = (:removeAt) WHERE friend = (:friend) AND friendTo = (:friendTo) AND removeAt = 0");
$stmt2->bindParam(":friend", $this->profileId, PDO::PARAM_INT);
$stmt2->bindParam(":friendTo", $friendId, PDO::PARAM_INT);
$stmt2->bindParam(":removeAt", $currentTime, PDO::PARAM_INT);
$stmt2->execute();
$account = new account($this->db, $this->profileId);
$account->updateCounters();
unset($account);
$account = new account($this->db, $friendId);
$account->updateCounters();
}
}
return $result;
}
public function like($fromUserId)
{
$result = array("error" => true, "error_code" => ERROR_UNKNOWN);
$account = new account($this->db, $fromUserId);
$account->setLastActive();
unset($account);
if ($this->is_like_exists($fromUserId)) {
$removeAt = time();
$stmt = $this->db->prepare("UPDATE profile_likes SET removeAt = (:removeAt) WHERE toUserId = (:toUserId) AND fromUserId = (:fromUserId) AND removeAt = 0");
$stmt->bindParam(":fromUserId", $fromUserId, PDO::PARAM_INT);
$stmt->bindParam(":toUserId", $toUserId, PDO::PARAM_INT);
$stmt->bindParam(":removeAt", $removeAt, PDO::PARAM_INT);
$stmt->execute();
$notify = new notify($this->db);
$notify->removeNotify($this->id, $fromUserId, NOTIFY_TYPE_LIKE, 0);
unset($notify);
$myLike = false;
} else {
$createAt = time();
$ip_addr = helper::ip_addr();
$stmt = $this->db->prepare("INSERT INTO profile_likes (toUserId, fromUserId, createAt, ip_addr) value (:toUserId, :fromUserId, :createAt, :ip_addr)");
$stmt->bindParam(":toUserId", $this->id, PDO::PARAM_INT);
$stmt->bindParam(":fromUserId", $fromUserId, PDO::PARAM_INT);
$stmt->bindParam(":createAt", $createAt, PDO::PARAM_INT);
$stmt->bindParam(":ip_addr", $ip_addr, PDO::PARAM_STR);
$stmt->execute();
$myLike = true;
if ($this->id != $fromUserId) {
$blacklist = new blacklist($this->db);
$blacklist->setRequestFrom($this->id);
if (!$blacklist->isExists($fromUserId)) {
$account = new account($this->db, $this->id);
if ($account->getAllowLikesGCM() == ENABLE_LIKES_GCM) {
$gcm = new gcm($this->db, $this->id);
$gcm->setData(GCM_NOTIFY_LIKE, "You have new like", 0);
$gcm->send();
}
unset($account);
$notify = new notify($this->db);
$notify->createNotify($this->id, $fromUserId, NOTIFY_TYPE_LIKE, 0);
unset($notify);
}
unset($blacklist);
}
}
$account = new account($this->db, $this->id);
$account->updateCounters();
$likesCount = $account->getLikesCount();
unset($account);
$result = array("error" => false, "error_code" => ERROR_SUCCESS, "likesCount" => $likesCount, "myLike" => $myLike);
return $result;
}
public function remove($photoId)
{
$result = array("error" => true);
$photoInfo = $this->info($photoId);
if ($photoInfo['error'] === true) {
return $result;
}
if ($photoInfo['fromUserId'] != $this->requestFrom) {
return $result;
}
$currentTime = time();
$stmt = $this->db->prepare("UPDATE photos SET removeAt = (:removeAt) WHERE id = (:photoId)");
$stmt->bindParam(":photoId", $photoId, PDO::PARAM_INT);
$stmt->bindParam(":removeAt", $currentTime, PDO::PARAM_INT);
if ($stmt->execute()) {
$result = array("error" => false);
$account = new account($this->db, $photoInfo['fromUserId']);
$account->updateCounters();
unset($account);
}
return $result;
}