/**
* Remove the like that was given
*/
function testRemoveLikeTopic()
{
$liked_message = basicMessageInfo($this->id_topic, true, true);
// Lets remove the like from the topic
likePost(1, $liked_message, '-');
// get the number of likes, better be none now
$likescount = messageLikeCount($this->id_topic);
$this->assertEqual($likescount, 0);
}
if (!empty($users_id)) {
$sql = "SELECT `id` FROM `likes` WHERE users_id =:users_id\tAND share_id =:share_id";
$stmt = $conn->prepare($sql);
$stmt->bindValue(':users_id', $users_id);
$stmt->bindValue(':share_id', $share_id);
try {
$stmt->execute();
} catch (PDOException $e) {
echo $e->getMessage();
}
$result = $stmt->FetchAll(PDO::FETCH_ASSOC);
if ($result) {
$success = "0";
$msg = "Post is already liked";
} else {
$res = likePost($users_id, $share_id);
$success = "1";
$msg = "post liked!";
if (!empty($res)) {
$like_id = $res;
}
// $sql1="SELECT P.url, U.name, CONCAT('$path',profile_pic) as profile_pic, U.apn_id,
// CASE
// WHEN DATEDIFF(NOW(),L.created_on) != 0 THEN CONCAT(DATEDIFF(NOW(),L.created_on) ,'d ago')
// WHEN HOUR(TIMEDIFF(NOW(),L.created_on)) != 0 THEN CONCAT(HOUR(TIMEDIFF(NOW(),L.created_on)) ,'h ago')
// WHEN MINUTE(TIMEDIFF(NOW(),L.created_on)) != 0 THEN CONCAT(MINUTE(TIMEDIFF(NOW(),L.created_on)) ,'m ago')
// ELSE
// CONCAT(SECOND(TIMEDIFF(NOW(),L.created_on)) ,'s ago')
// END as time_since
// FROM `post` P
// JOIN likes L ON P.id = L.share_id
$getInsertFieldValue['user_owner_id_fk'] = $user_owner_id;
$getInsertFieldValue['likeDate_f'] = $createdDate;
$lastInserted_user_id = $rm->insert_record($getInsertFieldValue, 'likes_t');
if (!empty($lastInserted_user_id)) {
$sqlLikeCountUpdate = "update news_feeds_t set like_count_f= like_count_f+1 where post_id={$POSTID}";
mysql_query($sqlLikeCountUpdate, $GLOBALS['link']);
$deviceId = $rm->idToValue('device_id_f', 'user_details_t', 'user_id', $user_owner_id);
//getting deviceId
if ($deviceId != '') {
$message = "You have received a like on your post.";
$rm->sendPushNotification($deviceId, $message);
}
$result = $rm->getParticularPost($POSTID, $USERID);
return $result;
} else {
$result = $rm->likeUnSuccessful();
return $result;
}
}
// end of else first
} else {
$result = $rm->ssl_error();
return $result;
}
} else {
$result = $rm->ssl_error();
return $result;
}
}
echo likePost();
/**
* Unlikes a post that you previously liked ... no negatives though, hurts feelings :'(
* It redirects back to the referrer afterward.
* It is accessed via ?action=like,sa=unlikepost.
*/
public function action_unlikepost()
{
global $user_info, $topic, $txt, $modSettings;
$this->_id_liked = !empty($_REQUEST['msg']) ? (int) $_REQUEST['msg'] : 0;
// We used to like these
require_once SUBSDIR . '/Likes.subs.php';
require_once SUBSDIR . '/Messages.subs.php';
// Have to be able to access it to unlike it now
if ($this->prepare_like() && canAccessMessage($this->_id_liked)) {
$liked_message = basicMessageInfo($this->_id_liked, true, true);
if ($liked_message) {
$likeResult = likePost($user_info['id'], $liked_message, '-');
if ($likeResult === true) {
// Oh noes, taking the like back, let them know so they can complain
if (!empty($modSettings['mentions_enabled'])) {
require_once CONTROLLERDIR . '/Mentions.controller.php';
$mentions = new Mentions_Controller();
$mentions->setData(array('id_member' => $liked_message['id_member'], 'type' => 'rlike', 'id_msg' => $this->_id_liked));
// Notifying that likes were removed ?
if (!empty($modSettings['mentions_dont_notify_rlike'])) {
$mentions->action_rlike();
} else {
$mentions->action_add();
}
}
} elseif ($this->_api) {
$this->_likes_response = array('result' => false, 'data' => $likeResult);
}
} elseif ($this->_api) {
loadLanguage('Errors');
$this->_likes_response = array('result' => false, 'data' => $txt['like_unlike_error']);
}
}
// Back we go
if ($this->_api) {
$this->likeResponse();
} elseif (!isset($_REQUEST['profile'])) {
redirectexit('topic=' . $topic . '.msg' . $this->_id_liked . '#msg' . $this->_id_liked);
} else {
redirectexit('action=profile;area=showlikes;sa=given;u=' . $user_info['id']);
}
}
$liftid = $_GET['liftid'];
$results = $db->update("UPDATE Lift SET L_Seats = L_Seats - 1 WHERE L_ID = " . $liftid . ";");
foreach ($results as $result) {
echo $result;
}
}
function likePost()
{
global $db;
$userID = $_SESSION["U_ID"];
$postID = $_GET['like'];
$sql = "INSERT INTO Likes(`P_ID`, `U_ID`)VALUES('" . $postID . "','" . $userID . "');";
$results = $db->insert($sql);
return $results;
}
if (isset($_GET['function'])) {
switch ($_GET['function']) {
case 'updatelift':
decrementAvailableSeats();
break;
case 'displaylift':
getAvailableLifts();
break;
case 'searchdrivers':
getDrivers();
break;
case 'likepost':
likePost();
break;
}
}
<?php
require_once 'include.php';
$act = $_REQUEST['act'];
if ($act === 'signup') {
$msg = signup();
} elseif ($act === 'login') {
$msg = login();
} elseif ($act === 'logout') {
$msg = logout();
} elseif ($act === 'post') {
$msg = post();
} elseif ($act === 'deletePost') {
$msg = deletePost();
} elseif ($act === 'likePost') {
$msg = likePost();
} elseif ($act === 'commentPost') {
$msg = commentPost();
} elseif ($act === 'deleteComment') {
$msg = deleteComment();
} elseif ($act === 'changeInfo') {
$msg = changeInfo();
} elseif ($act === 'readNotify') {
$msg = readNotify();
} elseif ($act === 'markAllRead') {
$msg = markAllRead();
}
?>
<!DOCTYPE HTML>
<html>
<head>
